Essential duties and responsibilities include the following.
Design, create and maintain databases through multiple product lifecycle settings, from development to production systems
Configure and maintain database servers and processes, monitor system health and performance, to ensure high levels of performance, availability, and security.
Convert complex business requirements into technical specifcations to build scalable and reliable data solutions
Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations.
Independently analyse, solve, and correct issues in real time on production, providing problem resolution end-to-end.
Refine and automate regular processes, track issues, and document changes.
Develop complex query, performance tuning, stored procedures and triggers, scheduled jobs, schema refinement.
Flexibility to work after office hours for any production issue or production deployment.
Perform scheduled maintenance and support release deployment activities after hours.
Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
Qualifications include:
4+ years of database and backend development experience
Valuable understanding of database systems and architectures
Expertise in writing complex SQL queries and stored procedures
Hands on experience with RDBMS and NoSQL data stores like MySQL and MongoDB
Experience working with Python scripting and application development
Experience working with Cloud applications and data stores like AWS RDS is a plus
In-depth understanding of data management and ETL processes