PostgreSQL Administrator

About the Role:

We are seeking a highly skilled and experienced PostgreSQL Database Administrator to join our team.
Key Responsibilities
• 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.

Additional Key Responsibilities:
• 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.

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 and collaboration skills.