PostgreSQL Database Administrator Resume Atlanta, GA - Hire IT People

SUMMARY

Experienced Database Administrator with six years+ of extensive experience in PostgreSQL and one year of Oracle database engines.
Has hands - on experience in implementing, designing, performance tuning and optimizing small-scale to enterprise databases through the complete system development lifecycle.
Have supported various projects such as Goldengate replication, data guard, and on premise migrations.
A motivated team player with great interpersonal and technical skills to quickly master new technologies and transfer knowledge to other.

TECHNICAL SKILLS

Databases: ORACLE, POSTGRESQL 9.6-11.4, 10g, 11g, 12c

Database Tools: SQL*Plus, PgAdmin4, PgBouncer, PgBackrest, PgDump, PgRestore, PgHero, PgDBCA, Toad, OEM Grid, RMAN, MTK, Orapg2, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, DBCA, DBUA, ADDM, Oracle Migration Workbench,pg rewind, pg repack, pg promte, pg crypto, AWS DMS, AWS SCT

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX, CentOs 7

PROFESSIONAL EXPERIENCE

PostgreSQL Database Administrator

Confidential, Atlanta, GA

Responsibilities:

Served in a 24/7 on-call support position for all prod, QA, and dev environments
Exposure to cross platform migrations preferably oracle to PostgreSQL.
Documented and assisted in data migration from oracle databases to PostgreSQL database in AWS RDS, Aurora
Installed/configured PostgreSQL (9.5, 9.6. and recently worked with PostgreSQL VERSIONS 10 and 11).
Tuned autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
Proactively managed standby replication and hot standby for disaster recovery.
Managed and monitored these databases using PgAdmin, psql tools.
Used pg Hero for Performance TUNING mostly, SQL Tuning using EXPLAIN ANAYZE and PG STAT ACTIVITY.
Created roles, granting privileges, creating tables, use of indexes, and primary & foreign key constraints as required.
Performed maintenance activities like vacuum, vacuum full, analyze; checking the auto vacuum jobs, customized vacuum on certain tables and columns.
Used Pg Bouncer for connection pooling, pg Badger for generating statistic reports.
Experienced in tuning PostgreSQL database settings & Troubleshooting performance issues, Managing Users and Tablespace on PostgreSQL Servers.
Used Customized scripts, to monitor database growth, TABLE growth, automated backups using cronjobs.
Hands on experience on restoration techniques on PostgreSQL like pg restore, pg promte, pg rewind, pg repack and (PITR) Point in Time Recovery.
Familiar backups (pg basebackup, pg backrest, pg dump,) and restore, compressed (gzip) backups, database or schema refreshes.
Configured a replication between Master and Slave Servers and monitoring on-going replication.
Upgrading database version using pg dump/pg restore and pg upgrade tools and updating the latest security patches to database, which are provided by PostgreSQL open source community.

Oracle Database Administrator

Confidential, Dallas, TX

Responsibilities:

Provided prompt 24/7 support for all production and development databases
Utilized RMAN and traditional Datapump export/import to clone and migrate databases
Used RMAN to successfully recover database data during database crashes and media and disk failures as well as create and implement recovery strategies
Extensively used Crontab to schedule and monitor hot and cold physical backups
Created all users, groups, roles, profiles, and privileges for relevant groups
Optimized and tuned SQL queries using SQL*TRACE, TKPROF, and Explain Plan
Applied all needed security patches including patch set, critical patch updates (CPU), patch set updates (PSU), and one-off patches
Skillfully used RMAN and Datapump conventional import/export to implement database, schema, and table level data refreshes
Successfully migrated from 10g to 11g to 11gR2 RAC and from 12c non-CDB to pluggable databases
Implemented tablespace level TDE security successfully and created Oracle Wallets
Reviewed alert log and trace files to constantly monitor database performance (V$ dynamic performance views at peak load)
Checked database health status including table size growth, extent allocation, free and used space, and fragmentation by creating and running scripts
Managed space maintenance, capacity planning, disaster recovery, and database overall maintenance
Ensured zero downtime during physical standby database creation by using RMAN, performing failover and switchover manually and Dataguard Broker
Created standard process documentation for peers to follow and utilize

We provide IT Staff Augmentation Services!

Postgresql Database Administrator Resume

Atlanta, GA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship