Senior Database Adminsitrator - SQL Server (7-12 yrs)

We have an Urgent opening for SQL DBA .

Work Experience : 7 years to 12 years'.

Work Location : Hyderabad / Bangalore.

Mode : Hybrid 2 days a week.

Timing : 4.30 PM to 12.30 PM.

Package : Best in the Industry

Role Description :

Lead SQL DBA role oversees all the databases and database servers in production and test environments to make sure they're constantly running on optimum performance. This role would also act as a gate keeper to our production environments.

In addition to this, this role takes ownership of all dba-related tasks and distributes those tasks accordingly to other dbas based on their capabilities.

Key Skills :

- Strong knowledge in relational data management, SQL Server 2008 through 2019.

- Strong experience and knowledge over TSQL and TSQL based objects.

- Dba task management : Includes receiving, evaluating, estimating and assigning all dba related tasks to other dbas.

- Collaborating with other teams on future projects and associated DB activities and plan accordingly.

- Oversee monitoring activities on the website database and other DBs and establish benchmarking for performance.

- Predict future performance based on new projects and upcoming events using the performance data collected.

- Maintain and monitor SQL Server Databases while maximizing availability of critical business data.

- Ensure proper DR and HA policies are in place and they're followed.

- Oversee required actions to make sure all servers are patched, and the latest service pack has been applied to all the servers while maintaining an effective communication on Server Maintenance and build activities and issues.

- Manage cloud databases including Azure SQL and AWS Redshift.

- Create scripts to automate administrative tasks.

Key Outcomes :

- Ability to identify slow running queries in and performance tune those queries.

- Identify server's hardware bottlenecks that could affect SQL Server's performance.

- Identify shortcomings in SSIS packages performance and address those issues.

- Work with DBA team to provide around the clock support.

- Willing to learn new technologies and new tools to better monitor/manage the environments.

- Manage security on SQL Server database servers.

- Database design and architecture knowledge and experience.

- Good knowledge and experience over Azure SQL DB & Cosmos DB.

- SQL Replication between local SQL Servers and Azure.

- Have some knowledge over AWS Redshift and its security and performance management.

- SSRS knowledge, Postgres Knowledge is a plus.

- Those with basic DevOps knowledge in terms of creation of CI/CD pipelines will have an added advantage.

Academics : Minimum 4 yr. degree in Engineering.