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 onboard and support new products, and continuing to drive improvements to the resiliency and availability of database platforms.
Duties & Responsibilities
- 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
- Ensure the performance of the PostgreSQL database is stable and optimal
- Ensure the MongoDB database is working properly
- Set up additional alerts to monitor the on-premise and cloud environments
Required Experience & Knowledge
Essential
- In-depth knowledge of PostgreSQL
- Good knowledge of MongoDB environments
- Advanced SQL scripting experience
- Thorough knowledge of SSRS and SSIS
- Knowledge of troubleshooting and performance tuning
Desirable
- Experience with database modeling tools
- Experience with cloud environments like Amazon AWS and Microsoft Azure is a great plus
- Knowledge of InnoDB clusters
- Experience with clustering, Always ON availability groups and partitioning
Skills and Attributes
- Analytical skills necessary to perform troubleshooting 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
- Advanced level of both spoken and written English language
- Bachelor’s or Master’s degree in Computer Science or relevant experience
- Any relevant certificate would be considered a plus
Note: For this position, the working hours are from 5 am EST to 1 pm EST.