PostgreSQL Database Administrator Resume Miami, FL - Hire IT People

SUMMARY

Certified and Experienced Database Administrator with over 5 years profound knowledge in Installing, Configuring, Upgrading, and Maintaining PostgreSQL and Oracle databases in different OS platforms.
Professional skills include Backup and Recovery methodologies, Performance Tuning, Production Support, Upgrades & Patches, Migration, Security and User Management. Configured physical and logical standby databases for disaster recovery.
Configured and administered Golden gates for real time replication.
AWS Certified Cloud Practitioner. Excels at migrating databases; Oracle to PostgreSQL on premises and in AWS cloud and configuring databases for HA and scalability. Comfortable with AWS EC2, RDS and AURORA. Good experience in creating and editing Bash/Shell Scripts for automation.
Highly organized and detailed creating excellent documentation and records. Excellent communication, analytical and problem - solving skills with the desire to work with others to deploy applications and improve performance. Seeking to leverage these skills as a PostgreSQL Database Administrator for the benefit of a new company.

TECHNICAL SKILLS

PostgreSQL 9.6, 10, 11
Oracle 10g, 11g and 12c
Upgrading and Patching
Performance Monitoring and Tuning (Database, Memory and SQL Tuning) pgAdmin pgBasebackup
PgBackrest pgBouncer pgBadger pgdump pgupgrade pgrestore
Linux Red Hat 6.4 and 7
RMAN
AWS DMS, SCT
Security Implementations (Audits, TDE, Network Encryption)
Dataguard
Oracle Goldengate (11g and 12c)
AWD RDS, EC2, AURORA
PL/PGSQL
PL/SQL
Rally
Excellent written and verbal communicator
Interpersonal skills

PROFESSIONAL EXPERIENCE

Confidential, Miami, FL

PostgreSQL Database Administrator

Responsibilities:

Installed and configured PostgreSQL versions 9.6, 10 and 11.
Managed and monitored databases using pgAdmin, psql and PEM.
Part of the production support team for 24/7 on-call production support.
Used Explain Analyze and pg stat activity for performance tuning of databases and queries.
Leads the database versions upgrades using pg dump/pg restore/pg upgrade.
Created roles, privileges, tables, indexes and primary and foreign key constraints
Aided ticket-based production support and defined and implemented database system maintenance plan.
Configured streaming replication including cascading replication and monitored on-going replication.
Performed cluster’s maintenance activities like vacuum, vacuum full, vacuum analyze.
Used techniques like pg restore and Point-In-Time-Recovery to restore data files.
Used PgBadger to generate statistic reports.
Cross platform migrations from Oracle to PostgreSQL on premises and in AWS cloud using DMS, SCT.
Managed PostgreSQL databases on AWS RDS.
Support daily administration, monitoring, tuning, and troubleshooting PostgreSQL clusters using custom scripts, PgAdmin, AWS Console and Applied CloudWatch to the creation of EC2 host monitors, alarms, and notifications for production purposes.

Confidential, Houston, Texas

Oracle Database Administrator

Responsibilities:

Performed all backup and recovery tasks including developing physical hot and cold backups and logical backups
Utilized Crontab jobs to automate and monitor database health, backup, and recovery activities and maintain database security and performance
Collaborated with application development teams and analysis of objects to monitor and tune long running jobs
Extensively utilized AWR, ADDM, ASH, SQL Trace, and Explain Plan to create and rebuild indexes and tune queries
Used RMAN and Datapump to perform refreshes on database, schema, and table levels from prod to dev/test environments
Created guaranteed restore points to use during recovery and switch-over operations and develop logical recovery points
Created scripts to monitor database status including table size growth, extent allocation, free and used space, and fragmentation
Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)