Database Administrator

SME (L3 or above only) DBA consultant with ten plus years of experience will provide enterprise services to build, maintain MS SQL-Servers, SSIS, SSAS with latest version. Implement CIS security best practices and automate the build standard. Implement policy management features to leverage the product features to roll out changes seamlessly. Example: SQL 2019 or above.

Install, upgrade and patch both existing and new database environments and other supporting tools such as SCCM or Ansible based automation.

Implement alerts through SCOM and OEM monitoring on new build servers environment to automate DBA proactive jobs and actively monitoring.

Hygiene best practice implementation, SDLC, change control best practices. Consultant will participate 24X7 production database support (Rota based) as required.

Consultant must provide technical documentation of the work including all scripts and commands applicable in a standard word format. Perform general troubleshooting on all database-related issues and documenting solution steps.

Partnership with application development, production support teams and Implement changes to the production environment CAB based change management guidelines and approval. Non-Production will be approved SNOW- SR based. He/She will be working with various CAPEX or OPEX type of projects tasks and update the project managers on a daily basis.

Candidate should have experience independently on complex projects and at the same time possessing excellent team skills to be able to collaborate with various infrastructure groups

Understanding of current support processes, definition of the to-be processes and gap analysis

Partnering with IT-Risk, CISO organization for planning and implementing security initiatives, performing vulnerability assessments, patch management, anti-virus management. Having knowledge of Qualys Scan is preferred.

Establishing process for maintaining sound backups for all database environments. Such as SQL Server Full, Differential, Log backups automation

Proactively monitor the SQL production databases and ensure alerts are provided when they occur, take corrective action to resolve these issues, and alert the IT management team of the issue.

Consultant will follow the SDLC policies and implement such policies and procedures to mitigate future risks.

Review, hardening and securing the current databases as per CIS standards. Provide guidance for securing databases which store sensitive and/or restricted data

Implementing database security controls via CyberArk to prevent data loss/leakage or unauthorized access to databases. Manage/Enhance Database Engine Security Configuration.

Identify root cause analysis (“RCA”) of performance issues and recommend the best possible solutions. Conduct RCAs for recurring production Database Administration related problems and automation is the Key