Microsoft SQL Server DBA L2 professionals

Job Description

• 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.

More Info

Education