We provide IT Staff Augmentation Services!

Postgresql Database Administrator Resume

2.00/5 (Submit Your Rating)

VA

Hire Now

SUMMARY

  • Skilled and experienced PostgreSQL and Oracle Database Administrator with over 5 years of hands - on experience, including complete life cycle knowledge.
  • Skilled at analyzing AWR, ASH, and ADDM, PGHERO, PERM and pgBadger reports in order to troubleshoot performance issues and ensure that the system works at it optimal.
  • Highly detailed oriented, with a drive to continually expand and obtain knowledge to better service Databases and assist in solving problems.
  • Looking to apply skills learned through experience in assisting companies to archive their goals and objectives.

AREAS OF EXPERTISE

  • Project & Production Support
  • Oracle 12c, 11g, & 10g Versions
  • Installation & Configuration
  • Upgrades & Patches
  • Migration of Systems
  • Backup & Recovery
  • Performance Tuning
  • RMAN
  • Recovery Catalog
  • Optimization of SQL & PL/SQL Scripts
  • Database Security
  • AWR Report
  • ADDM Advisors
  • Auditing
  • Flashback
  • SQL-Trace
  • TKPROF
  • SHELL Scripts
  • OEM Database & Grid Control
  • DevOps
  • Git github
  • AWS
  • OLAP
  • OLTP
  • Streaming Replication
  • Ora2pg
  • PgBouncer
  • Foreign Data Wrapper
  • SCT
  • DMS
  • Containerization (Docker)

TECHNICAL SKILLS

Platforms: Windows Server, Linux (red hat, centos), AIX

Languages: SQL, PSQL, PL/SQL, PL/PgSQL, Bash

Tools: SQL Developer, OEM Grid Control, AWR, ADDM, ASH, PgHero, PgAdmin 4, PEM, PgTune, PgBouncer, PgBadger, Remedy, Foglight, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, VA

PostgreSQL Database Administrator

Responsibilities:

  • Installed/Configured PostgreSQL Version 9.6, 10 and 11 and monitored and managed them using PgAdmin and PSQL.
  • Performed backup using pgBackrest, pg dump and pg Basebackup.
  • Created and managed database objects such as users, roles, indexes, views, sequences and permissions.
  • Migrated oracle databases to AWS Aurora with PostgreSQL compatibility using Schema Conversion Tool (SCT) and Data Migration Service (DMS) Tool.
  • Manually converts incompatible codes not converted using SCT.
  • Wrote post-validation scripts to validate oracle and PostgreSQL objects count.
  • Migrated from oracle to PostgreSQL on premise using ora2pg.
  • Performed database patching as well as version upgrade using Logical replication and Pg upgrade from 9 to 11.
  • Configured and managed Streaming Replication between master and multiple slaves for high availability.
  • Used customized scripts to monitor table growth and automated backups using cronjobs.
  • Used PgHero for performance tuning. Tuned SQL using Explain Analyze and PG STAT ACTIVITY.
  • Performed maintenance activities like vacuum, vacuum full and analyze.
  • Tuned Postgre Instances using Pgtune and Pgconfigurator.
  • Configured pgBouncer for connection pooling.

Confidential, Germantown, MD

Oracle Database Administrator

Responsibilities:

  • Experience with migrating from on premise to Exadata machine using Golden Gate.
  • Implemented procedures for automation of database management through tables and indexes.
  • Executed processes for evaluation of system space, database allocation and storage metrics.
  • Maintained all existing databases and new installations at current and stable production levels.
  • Installed 11gR2 RAC while performing disk group management in ASM.
  • Monitored health checks of OCR and VOTING DISKS while troubleshooting issues in RAC environment.
  • Ensured the secure and efficient operation of Oracle Database Systems.
  • Performed daily tasks such as resolving tickets, development support, and collaboration with application tuning.
  • Created and implemented recovery strategies, and successfully recovered databases using RMAN.
  • Utilized RMAN utility to schedule and monitor physical backups in the CRON tab.
  • Created users, groups, roles, profiles, and granted privileges according to job needs.
  • Optimized and tuned SQL queries using SQL-TRACE, TKPROF, and EXPLAIN PLAN utilities.
  • Applied security patches such as Patch set, Critical Patch Updates, and Patch Set Updates.
  • Used Transportable Tablespace (TTS) to quickly move a user’s tablespace across Oracle databases.
  • Implemented data refreshes using RMAN, Datapump, and conventional export/import for Oracle 11g and 10g.
  • Installed and configured Oracle 11.2.0.1 database on LINUX and WINDOWS platform.
  • Upgraded databases from 11g to non-CDB 12c.
  • Successfully used materialized views and Oracle Streams in Oracle 10gR2 to perform data replication.
  • Implemented Tablespace level TDE security and created Oracle wallets.
  • Constantly monitored the performance of databases through viewing alert log and trace files.
  • Managed space, capacity planning, disaster recovery, and overall maintained the databases.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship