SUMMARY

• 7+ years senior DBA having knowledge and ability to perform all of the basic database management skills of data administration, and overall architecture and database analysis.
• Configuring Postgresql Streaming Replication and Pgpool for load balancing.
• Managing the monitoring tools for better performance like PgBadger, EDB Postgres Enterprise Manager.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Responsible for the implementation, design, and optimization of various database environments ranging from small business databases to large enterprise databases.
• Worked on complete SDLC.
• Expertise involves in performance tuning, production support, installation, migration, monitoring and optimization of databases.
• Skilled at analyzing pg stat activity, pg stat statement, pg views, PEM reports, and pgbadger report in order to troubleshoot performance issues
• Experience in Installing and Configuring PostgreSQL version 9.6, 10, 11, and 12.
• Experience in implementing disaster recovery solution using PostgreSQL native Streaming Replication
• Experience in Backup & Recovery including PG dump, setting up WAL archiving for continuous archiving, and third - party tools such pgbackrest, BART (Backup and Recovery Tool), and Barman
• Performed on demand automatic failover tests using pg ctl promote command, pg autofailover, repmgr, Enterprise Failover Manger (EFM)
• Installation and Configuration of various tools such barman, pgpool-II, pgbouncer, pgbackrest repmgr, pgAdmin, pgagent for different PostgreSQL needs
• Implemented High Level Security idea for database protection by creating database roles, and modifying the host-based authentication file, and SSL Certificate authentication
• Experience in PostgreSQL cascading replication
• Experience in Linux scripts to automate database tasks such Vacuuming, database backup, database monitoring etc…
• Experience in SSL Certificate Configuration.
• Collaborate with development, architecture, and release teams, providing architectural design recommendations, driving standards for effective PostgreSQL transition to production operations.
• Experience in Cloning standby database using repmgr & automatic/manual failover with repmgrd
• Worked as team member to provide 24x7 on-call production database support.
• Upgrade from 9.3 to 9.4, 9.6,10,11,12 and changing environment server to server.
• Experience in migrating on-premises databases to PostgreSQL databases on AWS EC2, RDS
• Worked on AWS PostgreSQL databases for App migration into private cloud.
• Worked on AWS Database Migration Services for migrating data to RDS.
• Supported Main DBA functions in RDS and documenting in confluence page
• Hands on experience in encrypting data using AWS Key Management Service (KMS).
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Involved in 24x7 support for mission critical applications
• Configured and installed, involved using AWS services such as EC2, S3, RDS CloudWatch. Architecting new DBA solutions in AWS.
• Worked on integrating KMS to AWS CloudTrail to monitor logs used by keys for compliance Databases
• Experience using PEM, AWS CloudWatch, Ansible, puppet for database installation and monitoring
• Created new cluster and upgraded the cluster to another postgres sever.

TECHNICAL SKILLS

Databases: PostgreSQL 9.6, 10, 11, and 12

Tools: pgadmin, pgagent, ora2pg, Barman, repmgr, pgpool II, pgbouncer, xDB, pgbadger, pgbackrest, pg autofailover

Operating Systems: Windows & Linux- RHEL 7, Solaris, Windows

Utilities: Pg dump, pg dumpall, pg basebackup, pg dump, pg restore SQL and PGPL/SQL, SHELL

High-end Technologies: Streaming Replication, Logical Replication, xDB, EDB MTK

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

PostgreSQL DBA

Responsibilities:

• Maintained detailed technical documentation of database architecture and modeling as per business requirements.
• Provided technical assistance for preparation of shell scripts for task automation.
• Conducted complete analysis of database capacity and performance requirements.
• Implemented procedures for analysis, consolidation and tuning of databases for efficiency.
• Experience in migrating on-premises databases to PostgreSQL databases on AWS EC2, RDS
• Worked on AWS PostgreSQL databases for App migration into private cloud.
• Worked on AWS Database Migration Services for migrating data to RDS.
• Supported Main DBA functions in RDS and documenting in confluence page
• Hands on experience in encrypting data using AWS Key Management Service (KMS).
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects.
• Involved in 24x7 support for mission critical applications
• Configured and installed, involved using AWS services such as EC2, S3, RDS CloudWatch. Architecting new DBA solutions in AWS.
• Worked on integrating KMS to AWS CloudTrail to monitor logs used by keys for compliance Databases
• Experience using PEM, AWS CloudWatch, Ansible, puppet for database installation and monitoring
• Created new cluster and upgraded the cluster to another PostgreSQL sever.
• Configured Postgres Community version & EDB Advanced severs, Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, PEM, SolarWinds.
• Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
• Responsible for all backup, recovery of PostgreSQL databases using BART and pg dump.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment
• Migration of Data from Reports generated by various vendors into Postgresql Databases using Postgresql Export/Import Procedures.
• Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the corncob periodically in regular intervals.
• Experience Migrating data from Oracle to Postgresql using enterprise DB.
• Extensively investigated and followed-up with application teams, and proposed solutions to resolve slowness and performance issues.

Confidential, Lakeland, FL

PostgreSQL Database Administrator

Responsibilities:

• Created and dropped schemas and users in PostgreSQL.
• Install,configure, test, monitor, upgrade, andtune new and existingPostgreSQL databases.
• Develop SQL reports that meet client expectations for the application (used by custom application).
• Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Contributed to decreasingneed for downtimeby developing and improving procedures for automated monitoring and proactive intervention.
• Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
• Monitoring databases to optimize database performance and diagnosing any issues.
• Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases.
• Implement data models, database designs, data access, table maintenance and code changes together with our development team.
• Experience in code migration, database change management through various stages of development life cycle.
• Providing response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours.
• Work with development and operations teams to tune production queries for optimal performance.
• Implement and monitor replication for high availability and disaster recovery scenarios.
• Review new database schema changes.
• Monitor and manage database indexes for optimal performance.
• Studied and stayedcurrentonfeaturesand functionality ofPostgreSQL.
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Scheduling quarterly Point in time recovery (PITR) testing to the development environment for proper product testing.
• Configuring log analyzation tools like pgfouine and pgbadger etc.
• Installing and configuring nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Proactive in updating the latest security patches to database, which are provided by PostgreSQL open-source community
• Configured Logical and physical backup and recovery of all databases in PostgreSQL.
• Configured and Database installation creating tables, schemas, roles.
• Performed Backup and Point in time recovery in PostgreSQL.
• Switched the Database from Production to Testing and Testing to Production.
• Created Database Links from Testing to Production databases.
• Monitored the database for Index, partitioning Memory and I/O utilization.
• Used EXPLAIN and EXPLAIN ANALYZEto identify and fine tune sql queries for performance improvements.