Job Description

  • Deep understanding of NoSQL and relational databases and database fundamentals, including data storage, data modeling, and data access patterns.
  • Build/Prepare recommendations for database functions that meet business operating standards while improving the efficiency of business processes.
  • Implement appropriate indexes (B-Tree, Geospatial, Text) for performance improvement.
  • Recommend and implement best practices for Rest API integration framework/model.
  • Good experiences on MSSQL/MySQL database design (Tables, Views, Functions, SP's etc..,) and support.
  • Managing logins and database users, as well as database roles, application roles, and other security principals within database.
  • Monitoring, Tuning, and Troubleshooting the database related issues.
  • Rebuilding and reorganizing indexed on a regular basis.
  • Migrate MySQL/MSSQL database to Azure MySQL/MSSQL Database.
  • Install, configure, patch, and upgrade database software (Mongo and Couchbase, ELK or Cassandra or Hive/HDFS is an added advantage).
  • Assist developers in detecting performance problems using MMS and Mongo Profiler.
  • Design, implement, maintain and automate the appropriate backup and recovery architecture as required.
  • Knowledge of PaaS and IaaS architecture, pricing model.
  • Database features and limitation in Azure.
  • Hands on experience with Linux system administration.