Database engineer / Developer

Roles and responsibilities
1. Keep Databases running efficiently and accurately and highly performant 24x7 in production
2. Ensure new database code meets company standards for readability, reliability and performance
3. Passionate about technology and applying it to business solutions
4. Work closely with business and engineering and devops stakeholders
5. Engage proactively with stakeholders and other cross-functional team members in the
development of tech solutions
The Ideal Candidate:
1. 3-6 years development experience with SQL SERVER / PostGresSQL / MySQL platforms
2. Strong Knowledge of SQL
3. A good understanding of data normalisation, data modelling and database schema design
principals
4. Strong proven experience of database optimisation techniques
5. Monitor database performance , implement changes and apply new patches and versions when
required
6. Automate regular process, track issues and document changes
7. Assist developers with complex query tuning and schema refinement
8. Proven working experience as a Database administrator
9. Experience with database backup, restore and recovery models
10. Knowledge of High-Availability (HA) and Disaster Recovery(DR) options for SQL Server
11. Good knowledge or database sharding - horizontal and vertical
12. Good experience in managing database in clustered deployment - read replicas, active-active,
active-passive
13. Experience on AWS technologies (RDS,EC2,EBS,S3,RedShift,Glue)
14. Experience in implementation & support of NoSQL technologies
redis,memcached,mongodb,elasticcache)
15. Hands on programming experience in Python
16. Ability to multi-task and work independently
17. Proficient in Agile development methodology especially when applied to state-full data
environments

Good to have :
1. Experience with Financial Data, Capital Markets and Mutual funds industry/data
1. Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts
1. Understanding of Distributed Systems and Parallel Processing architecture.