SQL DBA Professionals

5 - 8 years

6 - 9 Lacs

Posted:2 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Role mission

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

Key Outcomes

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

Skills or abilities

Strong communication skills. And willing to work in a team-oriented structure.
  • Strong knowledge in relational data management, SQL Server 2008 thru 2019.
Strong experience and knowledge over TSQL and TSQL based objects.
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 the rest of 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 & CosmosDB.
SQL Replication between local SQL Servers and Azure.
Have some knowledge over AWS Redshift and its security and performance management.
  • SSRS knowledge is a plus.
  • Postgres Knowledge is a big plus.

Education

:
  • Minimum 4 yr. degree in Systems related field or equivalent experience as a DBA
  • Microsoft SQL Server certification is a plus.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

RecommendedJobs for You