KEY RESPONSIBILITIES
Application onboarding and configuring of database servers according to best practices.
Designing and maintaining high availability solutions like replication and failover setups is vital to ensure database uptime. Engineers also plan for disaster recovery scenarios to minimize data loss.
Schedule regular backups, test recovery procedures, and ensure data integrity to minimize downtime in case of system failures.
Monitor database performance and identify bottlenecks or areas of improvement. This includes analysing query performance, optimizing database schema, and adjusting server settings to ensure optimal performance.
Keeping PostgreSQL up to date with the latest patches and versions is crucial for security and feature enhancements. Support Engineers plan and execute upgrades carefully to avoid disruptions.
Plan for database growth by assessing current usage patterns and making scaling recommendations.
WHAT WE ARE LOOKING FOR
Relevant working experience in database administration and support
Strong experience in Yugabyte and/or PostgreSQL.
Strong SQL, data modelling and data analysis skills are a must.
Hands-on experience in big data engineering jobs using Python, PySpark, Linux, and ETL tools like Informatica.
Track record in implementing systems using Hive, Impala and Cloudera Data Platform will be preferred.
Experience in Oracle, Microsoft SQL, MySQL,
Experience in cloud databases (e.g. AWS RDS).
Strong analytical and problem-solving skills
Strong communications and interpersonal skills with stakeholders across levels
Good vendor management skills, and knowledge of industry best practices
Certifications in ITIL and above database technologies will be an advantage