Us Citizen
Green Card
Corp-Corp
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 16th 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:
· SQL Server, MongoDB, MySQL, CosmosDB, DynamoDB, PostgreSQL, Redshift DB, Azure and Mongo Cloud.
· Amazon AWS RDS, RedShift, EC2 and S3
T-SQL Advanced Lavel. PowerShell
Very good in TSQL, PowerShell , Cloud, Azure – probably a senior team member. IAS 7
Very good in automation of SQL activities and reports.