• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 9th Jul 2021

§  Deep Knowledge and understanding of SQL server architecture.

§  Responsible for all administration and maintenance tasks for the MS SQL environment supporting the Subway platform.

§  Installation and configuration of SQL Server 2016/2017/2019 on-prem and Cloud.

§  Knowledge of Managing and administering SQL Server 2005/2008/2008R2/2012/2014/2016 or above database servers.

§  Administering Windows Server 2008 R2/2012R2 or above servers

§  Managing Databases spread across multiple servers in Production, Development, staging & testing environments.

§  Setting up Replication/Log Shipping/AlwaysOn Availability group.

§  Upgrading SQL Server and Server Patching both clustered and non-clustered environment.

§  Installation and configuration of PowerBI Gateway and Datasource.

§  Designing and implementing high availability solution like Windows Failover Clustering, Database Mirroring, AlwaysOn Availability, Log Shipping, Replications.

§  Configure SQL AlwaysOn Availability Group and Distributed AlwaysOn Availability Group in Azure using Load Balancers.

§  Setup the backups on on-prem and cloud database systems.

§  Automation daily routine task suing PowerShell/Chef or python.

§  Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and Troubleshooting Failed Jobs.

§  Monitor SQL Agent job failures and address critical issues immediately.

§  Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

§  Troubleshoot SQL Server service outages as they occur, including extended hours and weekends.

§  Self-starter and low guidance able to complete the project.

§  Ability to write and maintain technical documents

§  Strong problem-solving and analytical reasoning skills

§  Strong communication (written and verbal) skills; must be able to interface well with the end-users and client

§  A proven team player, who is driven to go the extra mile to make something great

§  Troubleshoot SQL Server service outages as they occur, including extended hours and weekends.

§  Incident Management - Handle critical issues 24x7 coverage.

Database System: