Responsibilities:
- Demonstrated proficiency in PostgreSQL modeling and the implementation of complex workflows.
- Expertise in PostgreSQL database administration, pglogical, troubleshooting, deploying security controls, and performance optimization.
- Execute Incident and Problem management duties with precision and efficiency.
- Solid understanding of database maintenance within AWS environments (Ec2/Managed RDS instances).
- Develop and implement Disaster Recovery (DR) strategies, conducting practice tests to fortify DR availability confidence for mission-critical databases.
- Mastery in High-availability concepts such as clustering, database mirroring, Log shipping, and replication.
- Proficiency in Performance Tuning and Query optimization utilizing SQL profiler.
Qualifications:
- Bachelor’s degree in computer science, Engineering, or related field.
- Excellent communication and problem-solving abilities.
- Must have PostgreSQL, AWS Aurora DB, Oracle, SQL Server DB