SUMMARY

• Around 7+ years of experience having knowledge on development of lifecycle, management of the databases, installation and configuration of PostgreSQL, performance monitoring, Architecture, Administration.
• Expertise in Database Administration, System Analysis and Administration, Design, Development & Support of Postgresql 9.x to 12.x in Production, Development & Test Environments.
• A senior PostgreSQL DBA and Developer with Code testing and shell scripting and development.
• Extensively worked on install and configure of high available DB architecture.
• Experienced in DB upgradation including major and minor upgrades.
• Experienced in migration from DB2 legacy systems into latest Postgres environments.
• Involved in scheduling auto start and DB refresh with necessary required shell scripting in bash and Python.
• Operational activities include User Access, DB Refresh, Maintenance, Alerting, and Monitoring as a daily schedule.
• Experienced in install and configuration of tools like EFM, Pgbouncer, Pgpool, Pgbench, PEM and BART.
• Working closely with development team as per the requirement and provide them with necessary support as per Database standards.
• Expertise in improving the Database performance by implementing necessary actions required.
• Tune the DB configurations based on requirement and performance.
• Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Implement point in recovery (PITR) to avoid data loss and provide availability to the system.
• Experienced in migration of Database from on - premises to AWS cloud platform.
• Extensive experience in Disaster Recovery, Troubleshooting, Backup and Restore Procedures.

TECHNICAL SKILLS

RDBMS: PostgreSQL 9.8.x to 10.x, MySQL 5.6, Oracle 11g.

Languages: Shell scripting, PL/PGSQL, PLSQL, Java Script, Perl

Operating Systems: Centos, Red hat, AIX, Solaris, Windows 94, Windows 8

Replications: Binary and Object level replications

Backups: Pgdump and base backup

High Availability: Cold, logical, hot (Warm Standby, Hot standby, Streaming replication, Cascade replication etc.)

Cloud Environment: AWS- EC2 and VPCX console, RDB instances (Beginners experience)

PROFESSIONAL EXPERIENCE

Confidential | Charlotte, NC

Sr. Postgre SQL DBA

Responsibilities:

• Expertise in configuring and installation of PostgreSQL, Postgresplus advanced Server on OLTP to OLAP systems on from high end to low end environment.
• Experience in backup/restore of PostgreSQL databases.
• Strong experience in performance tuning & index maintenance.
• Expertise in database performance diagnostics in both development and production systems as well as SQL levels.
• Design & manage PostgreSQL database schemas.
• Experience designing database structures, indexes, views, partitioning.
• Implementing of logical and physical backups.
• Monitor and manage database indexes for enhancing the performance.
• Expertise in migrating data from Oracle to PostgreSQL and PostgresPlus Advanced Server using ora2pg and EDB migration toolkit.
• Extensively worked on creating foreign data wrappers to connect to other data resources from within postgres.
• Knowledge in Setup and maintenance of Postgres master-slave clusters utilizing streaming replication
• Experience in security access control, testing, configuration management, version control, highly available web applications.
• Maintenance and establishment of integrity & security controls.
• Good knowledge of fault detection & resolution process.
• Capability of migration of the versions.
• Ability to implement database change controls, as well as development, staging & production PostgreSQL databases.
• Responsible for PostgreSQL databases backup, recovery & upgrades.
• Proven skills communicating effectively with various levels of technical, non-technical, business & executive audiences.
• Daily activities include monitoring lock files, backup and performance issues.
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Schedule daily Point in time recovery (PITR) to the development environment for proper product testing.
• Experience in writing the pg dump and pg restore scripts using parallel dump and restore methods for automation.
• Scheduling pg dump and pg restore scripts for everyday dev and test server refresh as per apps team requests.

Confidential | Johnston, Iowa

Sr. PostgreSQL DBA

Responsibilities:

• Plan and configure the physical database environment required for development, testing, education and production usage.
• Plan and coordinate the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long-range requirements, and operational guidelines.
• Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools and archival and recovery tools and data access.
• Configure log analyzing tools like pgfouine and pgbadger etc.
• Having hands on experience in creating and managing the PostgreSQL instance from Amazon RDS.
• Experience in tuning and creating security groups, roles through Amazon RDS.
• Experience in creating the read replicas in Amazon RDS for high availability.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
• Review database design and integration of systems and makes recommendations regarding enhancements and/or improvements.
• Install and configure Nagios check postgresql.pl plugins for Monitoring PostgreSQL instances effectively.
• Experience in programming with PL/PGSQL
• Strong experience with load balancing using pg pool.
• Tune auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
• Expertise in trouble shooting the database performance issues along the with query optimization.
• Solid understanding of infrastructure, application and database performance metrics.
• Provide appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
• Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
• Prepare and/or review activity, progress, and performance reports.
• Experience configuring and maintaining database monitoring/trending tools.
• Diagnose, resolve and implement preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
• Develop SQL reports that meet client expectations for the application (used by custom application).
• Excellent verbal and written communications skills.
• Recommend and oversee implementation of database level configuration changes to optimize performance.
• Ensure maintenance of physical integrity of all production databases.
• Working knowledge of IDOL tool.

Confidential

PostgreSQL DBA

Responsibilities:

• Experienced in administering and maintaining medium enterprise database servers on Linux servers.
• Participating in daily meetings to discuss about the new database design, modeling and creation.
• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Experience designing database structures, indexes, views, partitioning.
• Implementing backup and recovery (Logical and Online).
• Controlling migrations of programs, data base changes, reference data changes and menu changes through the development life cycle.
• Setup and maintenance of Postgres master-slave clusters utilizing streaming replication
• Cross-datacenter disaster recovery and backup architecture
• Performing schema management, database sizing, maintaining privileges.
• Data migration while upgrading database versions ranging from 8.2 to 9.5.
• Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater).
• Performance monitoring and optimization
• Installing and configuring Object level replication like Slony etc.
• Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.
• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.
• Configuring log analyzation tools like pgfouine and pgbadger etc.
• Scheduled maintenance activities to vacuum, analyze to improve the query response time.
• Maintaining custom vacuum strategies at table and db level.
• Query optimization and troubleshooting.
• Troubleshoots with problems regarding the databases, applications and development tools.
• Close collaboration with engineering on schema additions and updates utilizing Liquibase.

Confidential

Postgres developer

Responsibilities:

• Expert in Coding of new tables, views and modifications as well as Pl/PgSQL Stored Procedures, Data Types, Triggers, Constraints and Constraints.
• Perform bulk loading of Inventory database.
• Worked on Replication and Log shipping for SQL Server High Availability
• Extensively worked on Active-Active and Active-Passive Clustering
• Experience in Oracle Database 9i/10g Administration.
• Created PL/SQL packages, procedures and functions.
• Monitoring tools and Application support.
• Install, initialize, validate, and configure postgres Databases.
• Manage database objects and workload management processes by defining and managing roles, privileges, and resource queues.
• Extensively used data manipulation language and data query language to access, manage and query data.
• Expert in writingshell scripts.
• Perform system administrative tasks, including managing and checking the state of the postgres database and its data and checking the distribution of data.
• Worked on Improving query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.
• Worked on optimizing indexes for better performance and maintainability
• Improve query performance by following performance enhancement tips and database best practices.
• Usedexplain and analyzeto identify and fine tune sql queries for performance improvements.
• Load data into a postgres database instance using external tables, SQL copy and insert commands, and parallel load utilities.