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.
Requirements:
· Bachelor’s degree in computer science, Engineering, or related field.
· 4+ years of relevant experience in PostgreSQL, AWS Aurora DB, Oracle, SQL Server DB