Job description

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. • Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).

Requirements