PostgreSQl DBA

Job Description

Designation - PostgreSQl DBA Location - Chennai Qualification - BE / B.Tech / M.Tech / MS / M.Sc / MCA Notice Period - Immediate. Relevant Experience - 2.5 Yrs Any Other Information - A qualified 2+ 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. Required 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: Warm Standby, Hot standby, Streaming replication, Cascade replication, Synchronous replication etc. Job Description 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 auto vacuum 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. Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community. 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 ProductionPostgreSQL databases within the organization. Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. 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. Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios / relevant tools 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. 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) 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.