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
