PostgreSQL Administrator (5-8 yrs)

About the Role :

We are seeking a highly skilled and experienced PostgreSQL Database Administrator to join our dynamic team.

In this role, you will be responsible for the design, implementation, and maintenance of our large-scale PostgreSQL database infrastructure.

You will play a critical role in ensuring the performance, security, and availability of our mission-critical data.

The ideal candidate will possess a deep understanding of PostgreSQL internals, strong problem-solving skills, and a proven track record of managing complex database environments.

Responsibilities :

Database Design and Implementation :

- Design, build, and configure PostgreSQL databases to meet evolving business requirements.

- Develop and maintain database schemas, tables, indexes, views, and stored procedures.

- Implement and enforce database standards and best practices.

- Participate in capacity planning and performance forecasting.

Performance Tuning and Optimization :

- Monitor database performance and identify bottlenecks.

- Perform query optimization, indexing, and normalization to improve database efficiency.

- Analyze and tune database configurations for optimal performance.

- Conduct performance testing and benchmarking.

Primary Skills and Requirements :

- 5-8 years of proven experience as a PostgreSQL Database Administrator in a large-scale enterprise environment.

- Strong understanding of PostgreSQL architecture and internals.

- Expertise in database performance tuning, query optimization, indexing, and normalization.

- Experience with database backup and recovery procedures, including disaster recovery planning.

- Proficiency in SQL and database scripting (e.g., PL/pgSQL).

- Experience with database security and access control.

- Knowledge of ETL concepts and tools.

- Experience with database monitoring and alerting tools.

- Ability to work under pressure and meet deadlines.

- Excellent problem-solving and analytical skills.

- Strong communication and1 collaboration skills. -