We provide IT Staff Augmentation Services!

Postgres Database Administrator Resume

3.00/5 (Submit Your Rating)

Lakeland, FL

SUMMARY

  • A 6 + years DBA with strong experience in PostgreSQL database administration running in heterogeneous environment including Linux, Solaris, UNIX, and Windows.
  • Experienced in change and Incident management, troubleshooting and Performance Tuning using tools such as Explain, analyze, vacuum, planner path, configuration files.
  • I am skilled in different database installations, design, creation, configuration, backup and Recovery using various strategies and tools such as pg dump/pg dumpall, psql/pg restore, pg basebackup, BARMAN and Manual Scripts, SQL or shell scripts.
  • I have developed expertise in database maintenance, monitoring, data migration on - premise and cloud.
  • I have Sound knowledge in High Availability and data replication technologies such postgres streaming and logical replication.
  • I am also skilled in different database security implementations including roles, privileges, auditing as well as upgrading, applying latest security patches to databases and database components.
  • In addition, I am motivational, possess great leadership skills, proactive, bilingual, a team player, a good communicator and always ready to learn. I also pay attention to detail and good at documenting

PROFESSIONAL EXPERIENCE

Confidential - LAKELAND, FL

Postgres Database Administrator

Responsibilities:

  • Installed, Configured, Setup, Maintained and Supported postgres 9.6, 11, 12, 13 Physical and Logical Standby database for Test, Development and Production for various home-developed applications
  • Perform physical backup using pg base backup and BARMAN
  • Performe logical backups and restore using pg dump/pg dumpall/psql/pg restore a
  • Perfom major using migration technic with pg dump/pg restore utility as well as in place upgrade using pg upgrade
  • Patch postgres with the minor release versions for bug fixes
  • Proactively identifying, troubleshooting and tuning live databases Performance
  • Migrate Postgres databases from on-prem servers to OCI platform
  • Migrate oracle databases to PostgreSQL running on On-prem servers and cloud instances such as OCI, EC2 and RDS.
  • Identify and resolved incidents, change requests and address to user problems/concerns.
  • Create and assign appropriate roles and attributes/permissions to roles depending on the user/application activity.
  • Perform on-call management of database in a rotatry schedule
  • Setup notifications (various levels for Cluster activities, tablespace utilizations, alerts) and monitored maintenance activities to achieve optimum database uptime.
  • Set up a monitoring system to gather performance metrics, tune postgres adding, removing or updating different configuration in the configuration files.
  • Review and tune SQLs to be run in Prod environment for maximium performance
  • Monitor postgres database using scripts and datadog as well as system resources using New Relic
  • Configure postgres to snowflake replication for dataware house using third Qlik Replicate
  • Configure postgres to postgres physical and logical replication
  • Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.

Confidential - MILWAUKE, WI

Database Administrator

Responsibilities:

  • Responsible for all backup, recovery testing, and upgrading of all of the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.
  • Responsible for setting up Logical Replication and streaming replication
  • Daily log analysis using pgbadger tool and query tuning.
  • Maintained custom vacuum strategies at table and db level. Identifying and fixing the issues on gpcrondump and gpdbrestore.
  • Controlled database security by setting up pg hba.conf, granting least privileges on object. Knowledge in database design s and user attributes
  • Responsible for monitoring environments using monitoring tool viz. custom scripts and other supporting tools like pgBadger.
  • Managed database administration, backup recovery and troubleshooting
  • Monitored the bloat repot on every table and performed maintenance with minimal downtime.
  • Identifiedand resolved incidents and address to user problems/concerns

We'd love your feedback!