PostgreSQL Database

Job Description:
We are looking for an experienced PostgreSQL Database Developer to join our dynamic team. The ideal candidate will be responsible for the design development and maintenance of PostgreSQL databases in a high-performance scalable environment. You will work closely with other teams to build manage and optimize databases to meet business needs and ensure system efficiency.

Key Responsibilities:

• Design and implement efficient database structures using PostgreSQL ensuring scalability availability and security.

• Write complex SQL queries stored procedures and triggers to support business logic and application performance.

• Design and implement database schemas and data models for enterprise-level applications.

• Optimize queries and database performance using techniques such as indexing partitioning and query rewriting.

• Collaborate with development teams to integrate PostgreSQL with applications and resolve data issues.

• Maintain and enhance PostgreSQL databases ensuring they run efficiently are properly maintained and meet the required SLAs.

• Develop backup and recovery strategies to ensure data integrity and system reliability.

• Monitor database performance troubleshoot issues and implement tuning strategies.

• Work on database migrations including data migration schema changes and version control for databases.

• Provide expert-level support in PostgreSQL architecture maintenance and troubleshooting.

• Ensure database security by implementing access controls encryption and backup/recovery solutions.

• Collaborate with DevOps teams to automate and manage database deployments in cloud environments like AWS Azure or GCP.

• Implement data integrity and ensure adherence to data governance standards.

Skills & Qualifications:

• Proven experience as a PostgreSQL Database Developer/Administrator.

• Strong knowledge of PostgreSQL architecture and management.

• Proficient in writing advanced SQL queries PL/pgSQL and developing stored procedures and triggers.

• Experience with performance tuning query optimization and database indexing strategies.

• Knowledge of database replication clustering and high-availability setups in PostgreSQL.

• Experience with backup and recovery solutions including PITR (Point In Time Recovery).

• Proficiency in data modeling and schema design.

• Experience working with PostgreSQL on cloud platforms (AWS Azure GCP) is a plus.

• Familiarity with PostgreSQL extension tools like PostGIS (for GIS applications) or Foreign Data Wrappers.

• Experience with CI/CD pipelines for database changes using tools like Jenkins GitLab CI etc.

• Familiarity with Linux/Unix environments and shell scripting.

• Good understanding of database security principles including user roles permissions and encryption.

• Excellent problem-solving skills and the ability to work in a fast-paced collaborative environment.

• Bachelors degree in Computer Science Information Technology or a related field (or equivalent experience).