Database Engineer - PostgreSQL

Database Engineer

Key Responsibilities:

• Design, implement, and maintain

  PostgreSQL database systems

  ensuring high performance, reliability, and security.
• Develop and optimize

  stored procedures, functions, and triggers

  in PostgreSQL.
• Write and optimize

  complex SQL queries

  for performance.
• Implement

  database migration strategies

  between different platforms.
• Collaborate with application developers to design efficient

  database schemas

  .
• Perform regular

  database maintenance

  , backup, and recovery operations.
• Monitor database performance and implement

  optimization strategies

  .
• Document database designs, procedures, and standards.

Required Skills & Experience:

• 2–5 years

  of experience in PostgreSQL database development.
• Strong proficiency in writing PostgreSQL

  stored procedures, functions, and triggers

  .
• Advanced

  SQL query writing and optimization

  skills.
• Experience with

  MS SQL Server

  .
• Knowledge of

  SQL best practices

  .
• Experience in

  database performance tuning

  and query optimization.
• Proficiency in

  database backup, recovery, and high availability solutions

  .

Preferred Qualifications:

• Basic understanding of

  Snowflake

  data warehouse platform.
• Experience with

  cloud-based database solutions

  (AWS RDS / Postgres).
• Knowledge of

  data modeling

  and normalization techniques.
• Experience with

  database version control

  and change management.
• Familiarity with programming languages such as

  Python

  or

  C#

  .