SUMMARY:

Seasoned multilingual Database Administrator with over 6 years of hands - on experience, knowledge and proficiency in database design, monitoring & tuning, Migration, Upgrades, Backup & Recovery, Cloning, Replication, and Security Implementations. Richard has worked on complete system development life- cycle (SDLC) and is proficient in an assortment of technologies including Oracle 11g, 12c, and PostgreSQL. A dedicated achiever and team player who possesses exceptional communication, analytical and organizational abilities.

SKILLS SUMMARY/PROJECTS:

• Installations/Upgrades/Patching Migration
• Database Security Replication
• Performance Tuning AWS Services (EC2, RDS)
• Data Guard Partitions/Indexes

TECHNICAL SUMMARY:

Databases: PostgreSQL 9.6-11 versions, AWS Aurora RDS, Oracle 10g, 11g, 12c

Database Tools: PgAdmin, PgBadger, PgHero, AWS CloudWatch, AWS DMS, AWS SCT, TOAD, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Statspack/AWR, DBCA, DBUA, ADDM, Splunk

Operating Systems: UNIX (Solaris 8/9/10, AIX, LINUX), Windows, Centos 7

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization.

PROFESSIONAL EXPERIENCE:

Confidential, Memphis, TN

PostgreSQL Database Administrator

Responsibilities:

• Supported 100+ databases in multiple SDLC environments.
• Involved in installing/configuring Postgresql 9.6 to 11
• Part of the on call production support team for 24/7 on-call production support.
• Configured streaming replication and cascading replication between MASTER and SLAVE, and monitored replication daily .
• Perfomed databases refreshes from production to UTA and DEV
• Performed database Cloning and Refreshes from production to lower environments.
• Providing production support based on a ticketing system.
• Used the Migration Tool Kit, Ora2pg, AWS Data Migration Service and Schema Conversion Tool Kit to migrate databases across platforms (Oracle to PostgreSQL on premises and AWS Cloud).
• Performed cluster’s maintenance activities like vacuum, vacuum full, analyze.
• Increased performance by configuring PgBouncer (connection pooling) to manage applications connections.
• Championed database versions upgrades using pg dump, pg restore and pg upgrade.
• Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg base backup and Pg backrest and Pg dumpall and Pg dump for logical backups.
• Supported daily administration, monitoring, tuning, and troubleshooting PostgreSQL clusters using custom scripts, PgAdmin, and Cloud Watch (DB Instances sizes range 100 GB to 15 TB)
• Tuned the performance of databases and queries using pgHero EXPLAIN ANAYZE and PG STAT ACTIVITY
• Daily monitored Splunk 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.
• 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.
• Performed BACKUPS, and RESTORE, Compressed (gzip) BACKUPS, Database or Schema REFRESHES
• Participated in capacity planning and scaled resources to meet the demands of the dynamic aspects of storage and memory for the 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.
• Generated various statistic reports using PgBadger.

Confidential, Boston, MA

Production Support Database Consultant

Responsibilities:

• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and Perl based utility “opatch”.
• Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.
• Performed Logical backup of critical application databases using EXPDP/IMPDP with a job scheduled (Crontab).
• Automated the Data Replication process using Materialized Views for reporting databases.
• Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof. SQL, PL/SQL and UNIX shell scripting.
• Monitored the Applications and database using OEM.
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Used Oracle Enterprise Manager (OEM) 11gGrid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• 24 X 7 Production & Development database support and administration.