CAREER SUMMARY

• A qualified 6+ years senior DBA having knowledge and ability to perform all of the basic database management skills of data administration, web connectivity, physical structure, SQL and SQL applications, and overall architecture and database analysis.

TECHNICAL SKILLS:

RDBMS: PostgreSQL from 8.4.x to 9.5.x, Oracle 10g

Languages: Shell scripting, PL/PGSQL

Operating Systems: Linux, Unix, Windows

Replications: Binary and Object level replications

Backups: Logical and Physical backups

High Availability: WarmStandby, Hotstandby, Streaming replication, Cascade replication, Synchronous replication etc.PROFESSIONAL PROFILE:

PostgreSQL DBA

Responsibilities: 

• Plans and coordinates 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.
• Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
• Reviews database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
• Establish and maintain security and integrity controls.
• Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
• Prepares and/or reviews activity, progress, and performance reports.
• Plans and configures the physical database environment. 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.
• Develops project plans for implementing database environments. Provides input to technical projects and oversees the tactical aspects of all database related tasks.
• Diagnoses, resolves and implements preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
• Recommends and oversees implementation of database level configuration changes to optimize performance. Ensures maintenance of physical integrity of all production databases.
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL  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 decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
• Studied and stayed current on features and functionality of PostgreSQL.
• Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
• Scheduling daily Point in time recovery (PITR) 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.

PostgreSQL DBA

Responsibilities: 

• Ability to proactively identify, troubleshoot and resolve live database systems issues.
• Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
• Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.
• Ability to thrive in a fast-paced, deadline-sensitive environment.
• Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
• 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.
• Automate the configuration management of database and Big Data systems.
• Performing schema management, database sizing, maintaining privileges.
• Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.
• Daily log analysis using pgbadger tool and query tuning.
• Maintaining custom vacuum strategies at table and db level.
• Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance.
• Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
• Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications.

PostgreSQL DBA, Oracle 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).
• 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.
• 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.
• Removing the Index bloat Concurrently to improve the performance.
• 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
• Close collaboration with engineering on schema additions and updates utilizing Liquibase Participation in week-long on-call rotations