Senior DB Developer

Job Description

What you ll do We are looking for a skilled and detail-oriented PostgreSQL Developer with 4-6 years of hands-on experience to join our dynamic engineering team. In this role, you will be responsible for designing developing, and optimizing PostgreSQL databases that power high-performance applications in the healthcare sector. You will collaborate with architects, backend engineers, and business analysts to deliver reliable and scalable data solutions Responsibilities Database Development and Optimization Design and implement efficient PostgreSQL schemas, indexes, constraints, and relationships. Develop advanced SQL queries, stored procedures, views, and triggers using PostgreSQL. Optimize complex queries and database performance for scalability and speed. Perform data profiling, query tuning, and performance analysis. Data Architecture and Modeling Create and maintain logical and physical data models based on business requirements. Define standards for data consistency, normalization, and integrity. Implement data validation rules and constraints to ensure data accuracy. Integration and Collaboration Collaborate with backend developers to ensure seamless data access through APIs and services. Design and implement ETL processes for internal data flows and external data ingestion. Work with cross-functional teams to translate business requirements into database logic. Tools and Automation Utilize tools for database versioning (e.g., Flyway, Liquibase). Automate database deployments and migrations within CI/CD pipelines. Continuous Improvement Monitor emerging PostgreSQL features and best practices. Recommend and implement improvements in data design, coding practices, and performance strategy. Qualifications : Bachelor s degree in Computer Science, Engineering, or equivalent technical field. 4-6 years of professional experience with PostgreSQL database development. Experience working in Agile/Scrum environments. Exposure to microservices and cloud-native applications is an advantage. Primary Skills PostgreSQL: Strong proficiency in PostgreSQL and advanced SQL. SQL Development: Experience building reusable stored procedures, functions, views, CTEs, and triggers. Performance Tuning: Expertise in optimizing complex queries using indexing, execution plans, and materialized views. Schema Design: In-depth knowledge of data modeling, normalization, and relational design. Data Integration: Experience with data pipelines, ETL processes, and transforming structured/semi-structured data. JSON/JSONB: Practical experience working with unstructured data and PostgreSQL s advanced JSON features. ORMs: Experience integrating PostgreSQL with ORMs such as Sequelize, Hibernate, or SQLAlchemy. Secondary Skills Experience working with cloud-based PostgreSQL (e.g., AWS RDS, Azure Database for PostgreSQL). Familiarity with RESTful APIs and backend service integration. Working knowledge of NoSQL alternatives, hybrid storage strategies, or data lakes. CI/CD and DevOps understanding for integrating DB updates into pipelines. Strong analytical and debugging skills. Effective communication and documentation abilities to interact with stakeholders.