Microsoft SQL Server DBA L2

No of Years of Experience: 4-7
CTC : 8-8.5 LPA
Joining /Notice Period: 1 month max.
Job Location – Mumbai, Navi-Mumbai & Thane
Full time Graduation is must
Job Description: SQL DBA
Responsible for physical database architecture and design, development, performance tuning, implementation, and support of the applications from a database perspective
Define and implement database, SQL standards and best practices
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; work with large volume, heavy load databases
Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues
Create database scripts for all objects and integrate them with source control
Handle database object deployment to Integration, QA, UAT, and Production
Good in reading and writing complex stored procedures, views, and triggers
Experience in writing technical documentation
Good in T- SQL scripts- Has credible experience in supporting production databases
Backup / Recovery, Data Replication, Distributed databases, Data Migration- worked on replication , cluster , mirroring and log shipping and Always-On
Experience in resolving blocking and deadlock issues
Tune the databases- Write Windows Scripts, Planning, Job scheduling, and Monitoring
Monitoring & Troubleshooting Blocking and Deadlock
Execution of DBCC Commands , checkdb , shrinkfile , shrinkdatabase , indexdefrag , dbreindex, etc
Create and update maintenance plan for database maintenance- Monitor and understand the error log and event log Monitor the disk space on the server and take action accordingly (Including Data files, Transaction log files, tempdb database)
Connecting remote server using QA, EM, and TS) – Managing DB backups. Restoring database from Full/ Differential/ T- log backup
Provide day to day support of high OLTP HA of SQL Server (2000, 2005, 2008,2012,2016,2019) databases- Identify root causes of production problems and work with developers to circumvent and resolve such problems
Provide technical services to monitor and maintain environments, (the SQL Server production, development, and test databases) running on firm’s strategic platforms including periodic software upgrades and migration of the SQL Server products
Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization- Create and maintain Windows and SQL scripts to automate tasks such as setting up and refreshing DEV, QA, and Production database environments
Log, schedule and track all changes using change management system tools
Configuring and Replication of SQL Servers to DR Environment
Participate in DR Drills
Responsible for all corrections to the database infrastructure and for repairs to the system or database
SQL Server certified candidate is preferred.

Work arrangement
No