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:
- 25 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#.
