Ms SQL Database Administrator

Job Description

Primary Skill (Technical Skill): MS SQL DBA

Secondary Skill (optional) :Sybase / Oracle / UDB DB2 / Open Source DB

Experience Level :5 – 8 Years

 Role & Responsibilities  

• Handled large database estates and managed TB size of databases  

• Install, configure and administer the SQL Server 2019, 2017, 2016, 2014, 2012, 2008 R2, 2008 and 2005 on Windows and Linux Servers

• Install and configure database monitoring tools

• Database refresh (Prod to Dev, QA)

• Database auditing and compliance

• Plan the instance upgrade, migration and patching

• Define backup and restore strategy

• Proactively analysis the performance and tuning recommendation

• Implement and troubleshoot DTS packages

• Experience in application DBA support and deployment activities

• Design, setup and configure load balancing on clusters

• SQL EM Metric design and configuration

• Develop database re-usable components

• Database disaster recovery (DR) strategy like mirroring / log shipping / replication configuration

• Develop data purging, archival management methods and best practices

• OS level activities related to database tasks and windows administration

• Coordinate and work with vendors for bug fixes and major incident resolution

• Primarily role is supporting the production and non-prod database environments  

• Ensure the reduction of repeated errors through implementation of necessary checkpoints

• Contribute towards evaluation of tools, products and software selection

• SLA tracking and reporting to Higher management

• Prepare and Maintain Standard Operating Procedure for all activities

• Proactive identification of risks and mitigation of the same  

• Technical presentation on emerging technologies.

• Foresee the need for newer technology based trainings on customer needs and provide suggestions for such trainings to Project Manager.

• Implement and Periodical check on Automation

• Implement and Periodical check on DB Security

• Identify, document and track Technology related risks and mitigation plan in the project

• Technical and Process guidance to L2 and L1 DBA

• Provide 24x7 and on call support for critical application databases

Skills Must have Nice to Have

Technical Skills (Core & Top-Up)  

• Strong installation and database administration experience on 2019, 2017, 2016, 2014 / 2012 / 2008 R2 and 2005

• Strong experience on log shipping, mirroring and replication

• Design and implement cluster high availability solution (Active-Active/Active-Passive)

• Configure, implement and troubleshoot DTS, SSIS and SSRS packages

• performance tuning and troubleshooting experience

• Powershell /DB scripting and automate routine tasks

• Experience windows administration on database activities

• Automation through scripting

• Experience on OS, Storage, Network and Virtualization activities

• Handled database estate of various technologies (Sybase, Oracle, MySQL and UDB DB2)

• Certification on Primary Technology

• Knowledge on Open Source DB  

• Process & Tools  

• Service Request and Incident, Problem, Change managements

• Configuration, Capacity planning and Knowledge management

• Experience on ITIL Tools like Remedy, Service Now or any other ticketing tool

• Identify and implement the service improvement plan  

• ITIL Foundation  certified Behavioral Skill  

• Strong verbal and written communication skills

• Team management and motivation

• Flexibility, good attitude  

• Manage the global infrastructure customer and projects