Loading...

Sql Database Engineer

Description

Location: Remote, Karnataka

Job description: 

Preferred Experience

•              Ideal candidate has been supporting traditional server based relational databases (SQL Server) for over 7+ years out of which last 4+ years in public cloud environments (Azure)

•              Database administration experience in SQL Server 2012/2016/above versions

•              Strong Installation, deployment, maintenance, troubleshooting experience in high-availability database environments (Always-On, Clustering, Mirroring, etc.).

•              Experience performing SQL backups, restores and recovery models

•              Able to provide 24*7 shift hours support at L2/L3 level

•              Experience in updating KB articles, Problem Management articles, and SOPs/runbooks

•              Passion for delivering timely and outstanding customer service

•              Great written and oral communication skills with internal and external customers

•              Strong ITIL foundation experience

•              Ability to work independently, with little or no direct supervision.

•              Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

•              Work directly with end customer, business stakeholders as well as technical resources.

•              Having good knowledge in performance tuning.

  • Good understanding of PAAS and RDS databases

 

Basic Qualifications

•              7+ years of overall operational experience

•              4+ years of Azure/GCP experience as a cloud DBA (SQL)

•              Assist in daily administration activities including setup, configuration and monitoring of databases to ensure backups, availability and performance are all maintained to the highest standards.

•              Assist the support staff to troubleshoot SQL and any other database errors.

•              Ensure all key databases have deep insight monitoring enabled to enable improved capabilities around fault detection

•              Perform regular database maintenance when required and ensure databases are backed up according to agreed RTO / RPO information

•              Maintenance work to be planned meticulously to minimise/eradicate self-inflicted P1 outages

  • Backup and restores (Backups should be automated with RSV)

 

•              Monitoring database costs regularly and identify strategies to minimize cost as part of internal FinOps practices

•              Segregation of duties (User Management – designing User roles and responsibilities)

•              Participating in DR (Disaster Recovery)/COB (Continuity of Business) plans as applicable

•              Experience with SSIS, SSRS, T-SQL, SynapseDB

•              Knowledge of Mysql will be a plus.

•              Experience with python / powershell scripting - preferred

•              Secondary skill in Oracle/MySQL/PostgreSQL - preferred

 

Preferred Certifications

Azure fundamentals certification (AZ-900) - REQUIRED

Azure Database Certification (DP-300) - preferred

AWS Certified Database Specialty - preferred

MCTS, MCITP certifications a plus

 

B.Tech/BE/MCA in Information Technology degree or equivalent experience