SUMMARY

• Seasoned Database Administrator with over 7 years of hands - on experience, in installing, configuring, and managing database system such as PostgreSQL and Oracle.
• I am proficient in database monitoring & tuning, Migration, Upgrades, Backup & Recovery, Cloning, Replication, and Security Implementations.
• I worked on complete system development life- cycle (SDLC) and I am proficient in technologies like, PostgreSQL, Oracle 11g, 12c, and AWS (RDS, EC2).
• I am an energetic achiever who possesses good communication, analytical and organizational abilities, comfortable working both remote or on site, I can quickly learn new environments, communicate technical knowledge to others and effectively manage concurrent priorities.

TECHNICAL SKILLS

Databases: PostgreSQL, EDB, AWS (RDS, EC2), Oracle12c

Tools: & Utilities: PgAdmin4, PgBouncer, PgBackrest, PgBadger, PgPass, PgAgent, Pgpool, PEM, EFM, Repmgr, Pgrepack, Pgbench, MTK, SCT, DMS, Ora2pg SQL*Plus, Service Now, Jira, DBCA, Toad, Amazon CloudWatch, CloudFormation, Terraform, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner.

Operating Systems: (RHEL) CentOS 6 & 7 CLI, KVM, VMware, MS Windows, UNIX (Solaris 10, AIX, HP-UX).

Languages: PL/PGSQL, PL/SQL, Bash/UNIX Shell Scripting, DBMS (DDL, DML, DCL, TCL)

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

PostgreSQL Database Administrator

Responsibilities:

• Part of teh on call production support team for 24/7 on-call production support.
• Champion database versions upgrades using pg dump, pg restore, pg upgrade, and logical replication.
• Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg base backup and Pg backrest also Pg dumpall and Pg dump for logical backups.
• Support daily administration, monitoring, tuning, and troubleshooting PostgreSQL clusters using custom scripts, PgAdmin, and Cloud Watch (DB Instances sizes range 10 GB to 20TB)
• Tune teh performance of databases and queries using pgHero, Pg tuner, EXPLAIN ANAYZE and PG STAT ACTIVITY
• Daily monitoring of System Event Logs for unusual events and taking appropriate action according to company policies of incident reports.
• Leveraged background workers and processes as well table partitioning and Indexes to improve query speed and enable faster parallel query.
• Participated in capacity planning to meet teh demands of teh dynamic aspects of storage and memory for teh databases
• Championed Database security policy and installation, using passwords, privileges, and user profiles. Used Database Encryption for database at rest and SSL/TLS for data in transit. Also implemented teh “triple A” (AAA) and database auditing policies as well as data redaction.
• Provision instances on AWS using CloudFormation and Terraform.
• Used teh Migration Tool Kit, Ora2pg, AWS Data Migration Service (DMS) and Schema Conversion Tool (SCT) to migrate databases across platforms (Oracle to PostgreSQL on premises and AWS Cloud)
• Performing cluster’s maintenance activities like vacuum, vacuum full, analyze.
• Increased performance by configuring PgBouncer, Pgpool, (connection pooling) to manage applications connections.
• Generated statistic reports using PgBadger.
• Experienced in handling logical and physical database BACKUPS. Assisted in developing and implementing best practices for Disaster Recovery and Backups.
• Used restoration techniques like pg restore and (PITR) Point in Time Recovery.
• Performing BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database or Schema Refreshes
• Configuring streaming replication (including cascading replication). configured a REPLICATION between MASTER and SLAVE and monitored On-Going replication.
• Upgrading database version (pg dump/pg restore, pg upgrade and logical replication).
• Performed database Cloning and Refreshes from production to lower environments

Confidential, Baltimore, MD

Oracle / PostgreSQL Database Administrator

Responsibilities:

• Extensively investigated and followed-up with application teams, and proposed solutions to resolve slowness and performance issues.
• Troubleshooting PostgreSQL database using Explain, explain analyzed
• Configured a cluster of pgpool-II for high availability and to avoid single point of failure.
• Experience providing 24/7 support for mission critical applications. Experience providing best practice for implementation, configuration, and database optimization.
• Responsible for all backup, recovery of PostgreSQL databases using pg backrest and pg dump.
• Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012
• Championed database migration from 10g to 11g and database upgrade from 11g to 12c using teh Oracle Data pump and DBUA respectively.
• Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities, respectively. Also used block change tracking (BCT) which reduced backup time from 8hrs down to 45mins.
• Support daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 2012 (Database sizes range 100GB to 21TB)
• Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports.
• Implement table and index partitioning to increase disk load balancing, improve query speed and enable faster parallel query.
• Capacity planning to meet teh demands of teh dynamic aspects of storage and memory for teh databases
• Deployed Database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented teh “triple A” (AAA) and database auditing policies as well as data redaction.
• Cloned databases using RMAN and DATAPUMP utilities for all database sizes
• Installed and administered OraclePhysical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)
• Performed database Refreshes from production environments
• Performed PL/SQL errors fixes and modified teh applications using PL/SQL
• Maintaining highly reliable 24x7x365 Linux production servers forAWSEC2 instances.
• Part of teh on call production support team for 24/7 on-call production support.