We are seeking an experienced Database Engineer with strong expertise in PostgreSQL to design, implement, and optimize database solutions for our organization. The ideal candidate will have a deep understanding of PostgreSQL, experience with MS SQL Server , and familiarity with Snowflake . This role requires a proactive individual who can ensure database performance, reliability, and security while collaborating with cross-functional teams.
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# .