SUMMARY

• Talented Database Administrator with five years of experience implementing, and optimizing PostgreSQL, Oracle, and SQL Server database servers.
• He has hands - on experience, knowledge and proficiency in database design, monitoring & tuning, migration, upgrades, backup & recovery, cloning, replication, and security implementations in both cloud and on-premise environments.
• A motivated team player with a proven ability to quickly learn new environments, transfer technical knowledge to others, and remain calm under pressure.

AREAS OF EXPERTISE

• Installs/Upgrades/Patching
• AWS Migration and Services (RDS, EC2)
• Performance Tuning
• Technical Documentation
• Goldengate
• RAC Clusters
• Scrum Master
• Database Security
• Postgres Logical/Streaming Replication
• Database Scaling

TECHNICAL SKILLS

Databases: PostgreSQL, SQL Server, Oracle 10g, 11g, 12c, AWS

Tools: Navicat, PgAdmin4, PgBouncer, PgAgent, PgBadger, PgHero, Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, Oracle Enterprise Manager 13C, RMAN, SQL*Loader, Exp/Imp/Data Pump, AWR, DBCA, DBUA, ADDM, Toad, Putty, WinSCP, SQL Developer, OEM 12c, Crontab

Operating Systems: LINUX, UNIX (Solaris 8/9/10, AIX, HP-UX), MS WINDOWS, VMWare, Centos7

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

PostgreSQL/Oracle Database Administrator

Responsibilities:

• Install and configure servers for PostgreSQL versions 9.7,10.7 and 11.4 on both Windows and UNIX platforms.
• Exposed to cross platform migrations Oracle to PostgreSQL where I documented and assisted during MIGRATION from ORACLE Databases to PostgreSQL database in AWS Cloud.
• Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.
• Clone databases using creation templates and pg dump for testing purposes.
• Perform database Refreshes from production environments.
• Perform PL/PGSQL errors fixes for application issues.
• Perform patching and upgrades of Databases using AWS minor versions upgrades, pg upgrade, pg dumpall and logical replication.
• Configured PgBouncer for connection pooling and PgBadger for generating statistical reports.
• Configure a REPLICATION between MASTER and SLAVE, and monitored replication.
• Perform maintenance activities like checking on AUTO VACUUM jobs, Customized VACUUM on certain tables and columns.
• Experienced in tuning PostgreSQL server settings and troubleshooting performance issues.
• Implemented backup schedule for both physical using Pg base backup and Pg backrest and Pg dumpall and Pg dump for logical backups.
• Support daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on UNIX/Linux and AWS Console.
• Monitor CPU utilization, memory, Database Connections and storage space daily using pg stat activity, PEM, Pg view and AWS CloudWatch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.
• Implement table and index partitioning to improve query speed.
• Participate in capacity planning meetings to meet the demands of the dynamic aspects of clusters scaling.

Oracle Experience

Confidential

Responsibilities:

• Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.
• Monitored different databases and application servers using oracle enterprise manager (OEM 13c) 10g, 11g grid control, and cloud control 12c.
• Implemented and managed optimum physical database design (tablespaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
• Extensively used AWR, ADDM and Explain plan for periodic performance tuning.
• Provided instance level performance monitoring and tuning for event waits, sessions, physical and logical I/O and memory usage.
• Successfully implemented backup & recovery using RMAN which includes hot backups and cold backups.

Confidential, Chicago, IL

Oracle Production Support Database Administrator

Responsibilities:

• Participated in 24 x 7 production & development database support and administration.
• Working experience with latest toad having new features PLSQL & SQL script debugger, database health checkup, ASM manager, diagnose extents, segment advisor, SGA trace and query builder.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing data pump, conventional export/import utility
• Implemented proactive monitoring using tuning pack, diagnostics pack, and stats pack, SQL Trace & TKPROF. implemented oracle database 11g two node real application cluster (RAC) using oracle cluster-ware, and responsible for high availability and load balancing. *
• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies. involved in converting a single instance database to oracle 12c, 11g, 10g RAC databases. installed ASM environment and migrated databases from NON-ASM to ASM. made optimal use of oracle support in resolving the SRS documented the standard processes for peers to follow.