Purpose of the Role
The Database Engineer is responsible for continuously pushing the boundaries of our data infrastructure capabilities through the development of tools to improve infrastructure leverage, collaborating with engineers across various teams to on-board and support new products, and continuing to drive improvements to the resiliency and availability of database platforms.
Duties & Responsibilities
- Monitoring and ensuring the availability of highly transactional production on premise databases as well as Azure SQL Database and AWS RDS
- Responsible for HA and DR of the RDBMS
- Supporting developers with T-SQL and handling data manipulation, performance tuning and indexing
- Providing input for technical analysis
- Automate manual processes using a scripting language (powershell, python)
- Ensure the performance of SQL Server databases is stable and optimal
- Ensure the performance of MySQL and PostgreSQL databases is stable and optimal
- Ensure the replication of MySQL databases is working properly
- Set up additional alerts to monitor the on-premise and cloud environments
Required Experience & Knowledge
Essential
- In depth knowledge of Microsoft SQL Server 2012/2014/2016
- Good knowledge of MySQL environments
- Advanced SQL scripting experience
- Experience with cloud environments like Amazon AWS and Microsoft Azure
- Experience of deploying SQL Server in a virtualized environment
- Thorough knowledge of SSRS and SSIS
- Knowledge of troubleshooting and performance tuning
Desirable
- Experience with database modeling tools
- Knowledge of PostgreSQL databases
- Knowledge of InnoDB clusters
- Experience with clustering, Always ON availability groups and partitioning
Skills and Attributes
- Analytical skills necessary to perform troubleshooting of errors and performance issues
- Experience with activities for business-critical systems
- Strong problem solving and debugging skills
- Customer-oriented attitude with good prioritization skills
- Excellent teamwork ability
Required Education & Qualifications
- Bachelor’s or Master’s degree in Computer Science or related degree
- Any IT certifications will be considered as a big advantage
- Fluency in English (both written and spoken)