Senior Database Administrator - PostgreSQL

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. Requirements : - 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. (ref:hirist.tech)

Location: bangalore, IN

Posted Date: 5/1/2025