Postgres Database Developer

Job Description

As a Senior Postgres Database Developer, you will play a pivotal role in designing, developing, and maintaining scalable database solutions that support critical business functions. This position requires expertise in database management systems, a collaborative mindset, and a passion for driving technical innovation. You will work closely with cross-functional teams to optimize database performance, implement robust data integration strategies, and ensure the integrity and reliability of our data systems.

Key Responsibilities

 Education & Experience : Bachelor’s degree in Information Technology, Computer Science, or a related field, or equivalent professional experience.

Technical Proficiency :  Expertise in relational database management systems (PostgreSQL, Oracle etc.).

 Proficiency in writing and optimizing complex SQL queries and stored procedures.

 Familiarity with cloud database solutions (e.g. GCP Cloud SQL, AWS RDS, Azure SQL Database) and NoSQL databases (e.g. MongoDB, DynamoDB).

 Experience with database performance monitoring and automated testing tools.

 Experience with Python scripting.

 Soft Skills : Strong problem-solving abilities, attention to detail, and the ability to communicate technical insights to both technical and non-technical stakeholders Required Skills & Qualifications  Design, develop, and maintain scalable, high-performance database solutions that support critical business functions.

 Optimize database performance and ensure data integrity through proactive monitoring, tuning, and troubleshooting.

 Collaborate with cross-functional teams, including software engineers, data scientists, and business analysts, to determine database requirements and implement effective solutions.

 Lead data migration and integration projects to consolidate and transform data across multiple systems.

 Develop and enforce best practices for database design, data modeling, and query optimization.  Implement high-availability and disaster recovery strategies to ensure system reliability.

 Contribute to architectural decisions involving database structures, scalability, and performance.  Provide mentorship and technical guidance to junior developers through code reviews, knowledge sharing, and training sessions.  Stay up-to-date with emerging database technologies and evaluate their applicability to our business needs. Good-to-Have Skills

 Experience with data security, compliance standards (e.g., GDPR, HIPAA), and disaster recovery.

 Familiarity with agile development methodologies and DevOps practices.