Database Architect

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.