Personal details
Mohammad H.
Summary
Highly skilled Senior Database Administrator with over 15 years of experience offering a unique combination of technical and analytical skills. Extensive experience designing and supporting database solutions utilizing Oracle, MS SQL, MySQL, PostgreSQL, and Teradata technologies. Experience includes data pipeline, database creation, design, upgrade, monitoring, performance tuning, backup and restore, implementing security, high availability, migration and application development cycle. Experienced working on PL/SQL, bash, Python. Actively sharing knowledge through my website https://www.nazmulhuda.info.
Work Experience
• Responsible for all aspects of database maintenance in Oracle, MySQL, PostgreSQL and DynamoDB; installation, patching, migrations, upgrades, tuning, security, monitoring and backup & recovery.
• Configuration and implementing the DR (Stand by) databases using data guard.
• Source Code Version control of DDL/DML via Liquibase, git, Flyway
• Proactively monitor resources and applications using AWS cloud Watch including creating alarms to monitor metrics such as EBS, EC2, RDS, S3, SNS and configured notifications for the alarms generated based on events defined.
• Develops technical plans and roadmaps.
• Develop and enhance scripts to automate and execute various DBA tasks.
• Support developers for optimizing long running queries.
• Responsible for creating users, Groups, roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Responsible for managing databases backup and recovery using RMAN.
• Worked as team member to provide 24x7 on-call production database support.
• Working collaboratively with the technical team for designing, implementing, administering, and maintaining Oracle, SQL Server and Teradata databases as well as ensuring their security, integrity, availability, and optimal performance to meet business or user needs.
• Solved Oracle, SQL Server and Teradata related failures and provide solution.
• Perform Disaster Recovery plan and Testing. Restoring databases using Oracle Flashback Technology with guaranteed restore point. Implemented data guard for high availability/disaster recovery solution in Oracle database.
• Monitoring database growth and space administration.’
• Responsible for Implementation of TASM for performance tuning and workload management in Teradata database.
• Identifying tables with high skew, working with data modeling team to change the primary index on tables with high skew.
• Implemented various alert such as node down, blocked session, high data skew, high spool usage etc in Teradata viewpoint.
• Used various Teradata utilities like MLOAD, FASTLOAD, BTEQ, TPT
• Refresh dev environment with production data.
• Successfully migrated over 100 TB data warehouse from on-prem to Cloud.
• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts.
• Building SQL Enterprise clusters to provide Disaster Recovery/High Availability via Always-On availability groups.