MS SQL Server Administrator

Job Title: MS SQL Server Administrator

Phys Location: Remote

Description: MS SQL Server Administrator :
We are looking for a skilled SQL Server DBA. As a DBA you will be responsible for a database's performance, integrity, and security. You'll be engaged in the database's design and development and debugging any difficulties that arise on behalf of the users.
Experience: -

• L2 with minimum 6 years experience.
• L3 with minimum 10 years’ experience.

L2 Roles:

• Installation/Upgradation/Migration of SQL Servers.
• Apply any patches or service packs for SQL Server.
• Configure High Availability/Disaster recovery solutions.
• Configure automated alerts to send a mail to team if any issues.
• Work on incidents, change tickets and problem tickets.
• Setup Maintenance plans for Backups, Database integrity check, Rebuild index and Update statistics and make sure to run all the jobs without any issues.
• Troubleshoot locking issues, including deadlocks, blocking, lock timeouts and fix them.
• Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
• Execute all changes of db. schema and maintain controlled development database environment.
• Work closely with application developers to test, configure, and optimize servers based on application demands
• Handle database object deployment to Integration, QA, UAT, and Production
• Provide day to day support of high OLTP HA of SQL Server databases- Identify root causes of production problems and work with developers to resolve such problems.
• Work on performance tuning like creating missing indexes.

L3 Roles:

• Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
• Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
• Hands on Configuring and Maintaining SSIS,SSRS,SSAS.
• Attend CAB (Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
• Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
• Work on Writing custom stored procedures, T-SQL queries, PowerShell scripts, views, and triggers based on requirements for DB maintenance and automate tasks.
• Work on writing technical and RCA(Root Cause Analysis) documentation.
• Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
• work on performance tuning like provide suggestions to create indexes and tune stored procedures.
• Troubleshoot recurring problems and fix them permanently.
• Conduct DB DR Drill activity, ensure to bring the DR site online if any outage at Primary site.

Skills:

• Extensive knowledge of SQL and SQL server tools
• Experience in Database Performance, Development and Maintenance
• In-depth understanding of database security, backup and recovery, and performance monitoring requirements
• Knowledge of PowerShell or Unix shell scripting
• Outstanding writing and verbal communication abilities
• MCSE/MCSA certificates preferred
• Working knowledge of Linux and Windows Server infrastructures
• Extensive knowledge of database technologies (MySQL, PostgreSQL, Oracle, MongoDB) Any 2 DB technologies is preferred.
• Prior experience with cloud services (AWS, Microsoft Azure and GCP)