Senior Database Administrator - PostgreSQL (5-9 yrs)

Responsibilities :

- Design, configure, and manage Data Warehouse Database Systems.

- Monitor and report on performance metrics, system health, and logging compliance.

- Postgres performance monitoring and troubleshooting.

- Perform database administration tasks, including backup and recovery, troubleshooting, performance tuning, and SQL optimization.

- Design database schema and tune data types and data distribution for performance optimization.

- Configure, implement, and tune workload management for resource allocation and query event handling.

- Support users and troubleshoot data access applications and ad hoc queries.

- Evaluate new database technologies and products and recommend to technical management.

- Contribute to document company database standards, guidelines, and operational procedures.

- Perform a variety of tasks, relying on experience and judgment to manage time, plan, and accomplish goals on several client engagements.

- Provide 24 x 7 x 365 support through on-call rotation.

- 4+ years of Postgres database experience.

- The candidate should have high-functioning knowledge of Linux Postgres Database Installation.

- Experience with Postgres Data Loading.

- Experience in working with Support.

- Experience with Production Support and working on shifts/on-call rotation.

- Proficiency in Unix OS and shell/perl/python scripting.

- 5- 8 years of experience in general database administration.

- At least 4 years of experience managing and maintaining relational database technologies, such as Postgres, is required.

- Working experience with the PostgreSQL database and its Functions usage.

- Hands-on experience with PostgreSQL installation, configuration, and administration, starting and stopping database instances.

- Hands-on experience with PostgreSQL database backup and recovery and archived Wal log management, crash instance recovery.

- Good understanding and experience of PostgreSQL High Availability solutions like PostgreSQL replication and OS cluster active-passive setup installation and configuration.

- Must know what database users and roles, permissions in PostgreSQL, and their management.

- Hands-on experience with PostgreSQL database Version upgrades and migrations.

- Good Troubleshooting experience.

- Familiarity with Greenplum database.

- Knowledge of Hadoop is a plus.

- Interact with vendor support to ensure open issues are resolved within the defined SLA.

- Understanding of Data Warehousing MPP architecture, technologies, and concepts.

- Ability to write and analyze complex SQL queries for performance.

- Competence to read and interpret query plans, database statistics, and database performance measurements and optimize SQL.

- Proficiency in backup and recovery methodologies and techniques.

- Ability to diagnose problems and resolve issues across various tiers (application, database, network, and appliance).

- Adherence to SDLC, Change Management, troubleshooting, and development methodologies.

- Strong Unix/Linux and shell scripting.

- Ability to perform work with minimal supervisory direction.

- Excellent written and verbal communication skills.

- B. E/ B. Tech/ M. Tech/ MCA/BCA. in Computer Science or related discipline or equivalent work experience required.