HANSLEY CHE TAH

**** ****** ***** ** *****: ad1359@r.postjobfree.com

Laurel - MD www.linkedin.com/in/hansley-tah-3951b4128

Mobile: 937-***-****

PROFESSIONAL EXPERIENCE

A Database Administrator with over 9 years of verified experience in Oracle, PostgreSQL, MySQL and MSSQL

Have profound experience in database design, upgrades, migration, security, backup and recovery, replication, cloning, Query tuning and monitoring.

Installed and configured PostgreSQL Clusters, SQL Server instances and MySQL databases on servers on various platforms.

Used terraform in deploying Aurora PostgreSQL and MySQL databases.

Experienced in the optimization of various database environments ranging from small business databases to large enterprise databases.

Perform data migrations from Oracle and SQL Server to RDS/Aurora PostgreSQL using AWS SCT and DMS tools.

Implement and manage ETL processes

Setup and manage high availability solutions like database clustering, replication & Always On Availability Groups

Monitor and plan for storage requirements, scaling and resource allocation.

Configure alerts for critical events and thresholds

Establish and enforce security policies, user permissions and access controls.

Design and implement best practices for database backups and disaster recovery strategies based on SLA.

Proficient in setting up monitoring tools to track database health, performance metrics and availability.

Cooperate with developers on database schema design and optimization.

Plan and execute database version upgrades and patches.

Use custom scripts to automate various DBA tasks while optimizing application performance.

Proficient in supporting a mission-critical database environment with 24x7 On-Call Support.

Experience in deploying AWS resources such as EC2 instances, RDS and Aurora Databases using terraform

Used Ansible to manage configurations across multiple database servers to ensure consistency and compliance

Experience in Git for versioning and GitHub for Source Code Management.

Exposed to Docker for containerization and deployment.

Exposed to Jenkins integration with GitHub, Nexus, and Tomcat application/database servers.

Had exposure to NOSQL database such as Mongo DB

TECHNICAL SUMMARY

SKILLS TOOLS

Operating Systems: Ms DOS, Ms Windows (Server), UNIX-Solaris, LINUX (Redhat /Ubuntu).

Databases: PostgreSQL 13, 12, 11, 10; Aurora (PostgreSQL and MySQL), SQL SERVER 2016, 2017, 2019, MySQL 5.7, 8

and Oracle.

Database Tools: PgAdmin, DBeaver, Putty, MobaXterm, SSMS, MySQL Workbench, PgBadger, PgBackrest, pgDash, PgBouncer, OEM AWS SCT and DMS, Microsoft Visual Studio.

Monitoring Tools: AWS CloudWatch, Performance Insights, Enhance Monitoring, Zabbix and Dynatrace.

Other Tools: PagerDuty, Jira, Ms Teams, Azure DevOps, Git, Jenkins, Maven, Ansible, Docker and Terraform.

ACADEMICS:

Bachelor’s Degree in Information Technology

Uganda Pentecostal University, Uganda (2009 – 2013)

PROFESSIONAL CERTIFICATIONS

AWS Certified Solutions Architect - Associate

Certified Oracle Database Administration 12c

Certified Oracle Database Professional 12c Comptia Security + Fundamentals of Red Hat Enterprise Linux

WORK EXPERIENCE

Organization: Rocket Central LLC

Duration: March 2022 – November 2023

Role: PostgreSQL/SQL Server Database Administrator

Environment: Linux and Windows

-Deployed and configure different versions of Aurora PostgreSQL, MySQL and SQL Server databases to the cloud using terraform modules. Making use of GitHub repositories and CI/CD platforms.

-Perform deployments of Aurora Global Databases across AWS regions for Disaster Recovery purposes.

-Actively assisted in the planning and execution of data migration from SQL Server to Aurora PostgreSQL.

-Configure parameters like memory, disk storage and CPU settings for optimal performance.

-Monitor database performance and identify bottlenecks using tools like performance insights and pgDash.

-Analyze and Optimize complex queries and database configurations for better performance.

-Implement and schedule automated maintenance tasks like vacuuming, reindexing and statistics updates.

-Implement and manage backups and recovery strategies.

-Perform periodic backup testing and recovery procedures to ensure data integrity and availability.

-Monitor resource utilization and plan for scaling as needed, ensuring right sizing of database instances.

-Enforce security policies and access controls, creating appropriate roles, granting permissions based on need

-Implement encryption of data in transit and at rest.

-Predict and plan for future storage and performance requirements.

-Perform patches and updates to databases to fix bugs and security vulnerabilities

-Plan and perform Upgrades involving different versions Aurora PostgreSQL, MSSQL and MySQL, using the AWS console and terraform modules.

-Ensures compliance with AWS specific database regulations and standards.

-Also, perform upgrades for Aurora databases using Blue/Green and Fast database cloning configurations

-Configure and manage failover and replication mechanisms to ensure high availability.

-Plan and implemented recovery strategies based on the SLA.

-Utilize custom scripts for databases administration tasks to streamline operations.

-Periodically provide knowledge share presentations and guidance to other team members and stakeholders on database-related topics.

-Maintain a comprehensive documentation on database configurations, procedures and processes.

-Perform installation and configuration of PostgreSQL, SQL Server and MySQL databases on virtual boxes.

-Setup and monitor HA solutions such as MySQL replication, SQL Server Log shipping, Always On Availability Group on SQL Server Clustering, etc

-Utilization of Pager-Duty in managing bi-weekly on call rotation for production support.

-Hands on experience in using Azure DevOps tools in managing stories assign to me from clients or other team members.

-Had exposure to Mongo DB.

WORK EXPERIENCE

Organization : SunTrust – Tampa, FL Duration: Sept. 2016 to December 2021 Role: Senior PostgreSQL Administrator Environment: Ubuntu, RHEL, Windows

Participated and assisted in data migration from Oracle databases to Aurora/RDS PostgreSQL.

Performed installation and configuration of PostgreSQL versions 10, 11 and 12.

Proficient in ensuring database security by Creating users and roles, granting only the necessary privileges based on the principle of least privileges.

Providing production support based on ServiceNow ticketing system.

Provided a good backup policy with the configuration of pgBackrest for differential / incremental backups.

Hands-on experience in PostgreSQL system study, replication - physical/logical designing, testing, troubleshooting, query tuning and disaster recovery implementation.

Configuring PostgreSQL Streaming Replication with Replication manager for automatic failover.

Monitored PostgreSQL databases in RDS/Aurora for optimum performance, using CloudWatch, Performance insights and Enhance Monitoring tools, analyzing and tuning of compute and databases based on results.

Configured pgbadger for extended log analysis and generating statistical reports.

Performed installation and configuration of pgBouncer for connection pooling.

Proven experience in Query tuning and OS tuning for better application performance and optimization.

Worked extensively with developers, making sure their queries are fine-tuned, check for proper index and partition utilization to ensure best performance.

Troubleshoot, identify and resolve various potential and immediate technological incidents.

Experience using ANALYZE, EXPLAIN AND EXPLAIN ANAYZE commands for enhancing performance tuning.

Upgraded PostgreSQL database servers from Versions 10 up to 12 using pg_upgrade and logical Replication with near zero downtime.

Configure logical replication on some critical tables for analyzing purposes.

Scheduled and performed manual vacuum analyze and vacuum full on specific databases during maintenance window on RDS and Aurora platform.

Carried out knowledge share trainings and guidance to other team members and stakeholders on PostgreSQL database related topics.

Customized vacuum on certain tables and modified autovacuum parameter settings for best performance.

Exposure in deploying and configuring AWS VPCs, IAM Roles, and S3 buckets using terraform modules.

Automate tasks such as database backups, user management and schema changes using ansible.

Had Exposure to NOSQL databases such as Mongo DB and Cassandra.

Perform installation of SQL Server instances on non-prod servers and perform some basic database tasks.

Had Experience configuring Jenkins job with related plugins for Testing and Continuous Deployment to accomplish the CI / CD pipeline

Had exposure in using Docker in creating replica for production environments for backup testing and restore procedures.

WORK EXPERIENCE

Organization: CareSource – Dayton, OH

Duration : February 2014 to August 2016

Role : Oracle and PostgreSQL Database Administrator

Environment: Windows, Linux (Redhat/Ubuntu)

Rewrite and implemented a new backup strategy following company SLA; execution of backup schedule for both file system backups using pg_basebackup and pg_backRest for incremental and differential backups.

Perform refreshes to lower environment using pg_dumpall and pg_dump and for logical backups.

Used restoration techniques like pg_restore and Point in Time Recovery.

Supported daily administration, monitoring, tuning, and troubleshooting of database issues.

Configuring third party client software pgadmin4 and Dbeaver to access the PostgreSQL databases.

Used customized scripts to automate repetitive tasks and proactively managing any abnormal changes.

Create users, roles and grant necessary privileges, revoke privileges and expire passwords as necessary.

Perform maintenance jobs like autovacuum/vacuum, reindexing on certain tables.

Monitored Resources and Applications using AWS Cloud Watch, Performance Insight, and Enhanced monitoring, including creating alarms to monitor certain critical metrics.

Coordinated the installation and configuration of 12c RHEL and Windows server as well as Container Databases on standalone servers and cluster on windows and Unix platforms.

Worked New Features on 12c databases such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c Databases.

Participated in the implementation of HA solution using oracle RAC, Physical Standby and GoldenGate.

Applied PSU on standalone TEST environment using OPatch and same PSU (Grid and RDBMS Patching) on production cluster using OPatch Auto.

Successfully implemented Physical Standby Databases on 2-node 12C Real Application Cluster and automated scripts to delete archive logs that already applied to standby.

Actively involved in datacenter migrating large size database in multiple platforms and implemented two types of standby databases supported by Data Guard, logical and physical standby databases in 12c on 2 node RAC.

Generated AWR (Stats pack), ADDM, Explain Plan, TKPROF, SQLTRACE, ORADEBUG reports for Performance tuning and used new tools of 12c for security purpose.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 11g & 12C environment for the Production databases.

Implement and enforce security for all the Oracle Databases; the three basic security tasks are authentication (Setting up user accounts to control logins to the database), authorization (setting permissions on various parts of the database), and auditing (tracking who did what, with the database).

Migrated Oracle Databases from Windows to Linux using RMAN (Same version and higher versions)

Generated Stats pack/AWR reports using OEM 12c and analyzed the reports for Oracle wait events, time-consuming SQL queries, tablespace growth, and database growth.

Tools Used: Oracle RMAN, DBMS STATS, Data pump, SQL TRACE, TKPROF, and EXPLAIN PLAN.

Performed Migrations from oracle On-premise to RDS PostgreSQL.

Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.

Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.

I was part of a team that Migrated Large Data stores using AWS DMS and Snowball Edge.

Contact this candidate