Database Engineer - PostgreSQL (5-10 yrs)

Database Engineer

About the Role :

- We are seeking a skilled and experienced Database Engineer with a specialization in PostgreSQL to join our growing data engineering team.

- You will be a key contributor in designing, implementing, and maintaining our PostgreSQL database infrastructure.

- You will work closely with developers, data scientists, and other stakeholders to ensure the performance, reliability, and security of our data systems.

- This role requires a deep understanding of PostgreSQL internals, strong SQL skills, and a passion for data management best practices.

Responsibilities :

- Design, implement, and maintain PostgreSQL databases, including schema design, data modeling, and performance tuning.

- Optimize database performance through query optimization, indexing, and other techniques.

- Ensure data integrity and security by implementing appropriate security measures, access controls, and backup/recovery strategies.

- Monitor database performance and troubleshoot issues.

- Develop and maintain ETL processes for data ingestion and transformation.

- Collaborate with developers to optimize database interactions and ensure efficient query execution.

- Automate database administration tasks using scripting and other tools.

- Stay up-to-date with the latest PostgreSQL features and best practices.

- Contribute to the overall database architecture and strategy.

- Participate in on-call rotation for database support.

Qualifications :

- Bachelor's degree in Computer Science or a related field.

- 5+ years of relevant experience in database engineering with a focus on PostgreSQL.

- Deep understanding of PostgreSQL internals, architecture, and features.

- Strong SQL skills, including query optimization, stored procedures, and triggers.

- Experience with database performance tuning and monitoring tools.

- Experience with data modeling and schema design.

- Experience with ETL processes and tools.

- Knowledge of database security best practices.

- Excellent problem-solving and analytical skills.

- Strong communication and collaboration

Technical Skills (Required) :

- Database Systems : PostgreSQL (expert level)

- SQL : Advanced SQL skills, including query optimization, stored procedures, functions, triggers, and performance tuning.

- Operating Systems : Linux (strong proficiency)

- Scripting Languages : Python, Bash (or similar) for automation tasks.

- Database Administration Tools : pgAdmin, psql, or similar.

- ETL Tools : Experience with ETL tools (e.g., Informatica, Talend, Apache Airflow) is a plus.

- Cloud Platforms : Experience with cloud-based PostgreSQL offerings (e.g., AWS RDS for PostgreSQL, Azure Database for PostgreSQL, Google Cloud SQL for PostgreSQL) is a plus.

- Version Control : Git

Preferred Qualifications :

- Experience with high-availability and disaster recovery solutions for PostgreSQL.

- Experience with database replication and clustering technologies.

- Experience with NoSQL databases.

- Knowledge of data warehousing concepts.

- PostgreSQL certification