Ms Sql Database Administrator

Role & responsibilities

Roles & Responsibilities:

Familiar the different editions of SQL Server and can advise on when to use each to optimize.
Strong backup/recovery, including replication/failover tuning and troubleshooting knowledge of SQL Server. Experience using Azure SQL and related tools (Hybrid connections, etc.) is a bonus.

Install, configure, upgrade, patch, and manage Microsoft SQL Server databases.
Establish and maintain backup and recovery policy and procedures. Provide proactive monitoring and performance tuning including physical server level, database level, and query tuning. Create users and assign permissions based on authorized level of access. Provide L3-level representation for DBA team to account leadership, clients, application owners, and infrastructure teams. Ensure 24/7 availability of the SQL Server database environment. This will include 24/7 on- call responsibilities on a rotating schedule. Represent SQL Server Database Administration team in Disaster Recovery and project activities. Share technical expertise providing technical mentorship and cross training to other team members. Maintain documentation of the database environment and infrastructure. Work with system administrators, architects, development teams, and business application owners to ensure database changes are in-line with operational standards and the strategies needed to scale. Work collaboratively with cross-functional teams to administer as well as troubleshoot live issues both internal as well as customer reported. Investigate and troubleshoot issues. Create and execute scripts to perform needed system functions.

Hands on Experience in Always on, Log shipping and DC & DR configuration.

• To provide 24x7 Support.

Database server administration ( MS-SQL) and team management.

Good communication skills, Need to participate in client meetings.

Handle regular day to day IT Infra operations.

Installation of ms-sql ,Applications and break fixing of H/W and S/W issues .

Working on Service Desk tickets.

Coordinating with IT stake holders to fix the issues.

Participate in internal/external audits to showcase the IT compliance status.

Perform the IT related task and update the status higher management on regularly.

Participating in Day/Weekly status review meetings

• Excellent oral and written communication skills
• Experience in Operating Systems tuning and configurations.
• Ability to obtain and maintain a Minimum Background Investigation (MBI)

Required Professional and Technical Expertise:

• A minimum of 8+ years of overall experience in IT Database Domain with proven experience in Database Operations.
• Client Meetings, External Audit, Database Installation, Database Environment, Database MS-SQL Server Administration
• MS-SQL Certification will be added advantage.

Preferred candidate profile