Design and develop new database schema objects such as tables, indexes, views, stored procedures, functions, triggers, jobs, while supporting legacy database schema currently supporting production environment
Solve database performance issues and diagnose malfunctions
Ensure performance, security, and availability of databases
Handle common database procedures such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, and optimize and tweak as necessary
7+ years experience in database programming
Good data analytical and data modelling skills
Expert in DB profiling & SQL performance tuning
Skilled at optimizing large, complicated SQL statements
Capable of configuring popular database engines and orchestrating clusters as necessary
Ability to plan resource requirements from high level specifications
Prepare documentations and specifications
Good To Have:
Good Knowledge of Reference Data
Experience in executing various development methodologies such as Waterfall, Agile, etc.
Proficient understanding of code versioning tools such as {{Git / Mercurial / SVN}}
Familiar with tools that can aid with profiling server resource usage and optimizing it.