Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Cognizant Team. If you also belong to the team, you can get access from here

Cognizant Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 47k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern
filter salaries All Filters

1 Cognizant MS SQL DBA Job

MS SQL DBA

8-12 years

Chennai

1 vacancy

MS SQL DBA

Cognizant

posted 28d ago

Job Description

Job Description
Job Title: MS SQL Server DBA
1. Job Summary highlight project details/what is exciting about the role :
Strong experience as a MS SQL Server DBA.
Overall, 8-12 years of Experience as MS SQL Server DBA
In-depth knowledge of SQL Server database Architecture, including database design, installation, configuration, and maintenance.
Proficiency in writing SQL queries, PowerShell scripts, automating reports.
Experience with database performance tuning and optimization techniques.
Familiarity with high availability and disaster recovery solutions, such as database Always On mirroring, log shipping, and clustering.
Knowledge of database security best practices and the ability to implement and enforce security measures.
Strong problem-solving and troubleshooting skills.
Excellent communication and collaboration skills.
Strong knowledge in AWS Environment.
Hands On with SQL RDS databases, DB refresh in RDS, knowledge of S3 bucket, IAM roles, SNS alarms, Snapshot and Recovery.
2. Key Responsibilities list what the person will be doing on a day to day basis: % of time
Installation, Administration and Maintenance of SQL Server Instances.
Implement and maintain database backup and recovery strategies to minimize data loss and downtime.
Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning.
Proactively identify and resolve database performance issues and bottlenecks.
Monitor and analyze database performance metrics and provide recommendations for improvement.
Plan and execute database migration and upgrade projects from ON Prem to EC2 or RDS.
Troubleshoot and resolve database-related problems in a timely manner.
Document database configurations, procedures, and troubleshooting steps.
Setup High-Availability techniques like Always ON, Mirroring as part of Disaster Recovery Strategy for the Databases, troubleshooting issues.
Utilize your extensive experience to design, implement, and maintain high-performance SQL Server databases, ensuring optimal performance, availability, and reliability.
Perform in-depth performance tuning and optimization, identifying and resolving performance bottlenecks, slow queries, and other related issues.
Analyze wait events and proactively address performance challenges to ensure smooth and efficient database operations.
Oversee and manage database replication strategies, including setup, configuration, monitoring, and troubleshooting of replication in Standalone and Always ON.
Implement and manage Change Data Capture (CDC) processes to enable real-time data integration and synchronization across databases.
Monitor database health using various tools, set up alerting mechanisms, and respond to incidents in a timely manner to minimize downtime and data loss.
Database upgrades, migrations, and patching while minimizing risks and downtime on both Standalone and Aways ON.
Document database configurations, processes, and best practices, contributing to the creation and maintenance of internal knowledge resources.
Stay up-to-date with the latest industry trends, emerging technologies, and best practices in SQL Server database administration.
Provide 24x7 support for critical production systems.
3. Job Requirements
As per the 2006 Age Discrimination Act please do not specify number of years experience. Use words like Extensive, Strong, Good, Fair
Essential Skills:
SQL Server Adminstration and AWS cloud
Nice to Have Skills.
Oracle / PostgreSQL
Qualifications:
A bachelors degree in computer science or a related discipline
Extensive knowledge of SQL and SQL server tools
Handson in AWS cloud
Database cloud migration expertise
Experience in Database Performance, Development and Maintenance
In-depth understanding of database security, backup and recovery, and performance monitoring requirements
Familiarity with relational and dimensional data modelling
Extensive knowledge in database design, implementation, and conversion
Knowledge of PowerShell and Unix shell scripting
Outstanding writing and verbal communication abilities
Working knowledge of Linux /Windows Server infrastructures
4.Travel required YES NO

The Cognizant community:
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.

  • Cognizant is a global community with more than 350,000 associates around the world.
  • We don t just dream of a better way - we make it happen.
  • We take care of our people, clients, company, communities and climate by doing what s right.
  • We foster an innovative environment where you can build the career path that s right for you.

About us:
Cognizant is one of the worlds leading professional services companies, transforming clients business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World s Best Employers 2024) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com

Our commitment to diversity and inclusion:
Cognizant is an equal opportunity employer that embraces diversity, champions equity and values inclusion. We are dedicated to nurturing a community where everyone feels heard, accepted and welcome. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status or any other protected characteristic as outlined by federal, state or local laws.

If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email CareersNA2@cognizant.com with your request and contact information.

Disclaimer:
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.


Employment Type: Full Time, Permanent

Read full job description

Prepare for MS SQL DBA roles with real interview advice

People are getting interviews at Cognizant through

(based on 3.6k Cognizant interviews)
Job Portal
Campus Placement
Company Website
Referral
Walkin
Recruitment Consultant
33%
25%
11%
8%
6%
3%
14% candidates got the interview through other sources.
High Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.

What MS SQL DBA at Cognizant are saying

3.6
 Rating based on 3 MS SQL DBA reviews

Likes

Nathing

Dislikes

No projects, very difficulty to get project

Read 3 reviews

MS SQL DBA salary at Cognizant

reported by 73 employees with 3-8 years exp.
₹4.5 L/yr - ₹16.8 L/yr
49% more than the average MS SQL DBA Salary in India
View more details

What Cognizant employees are saying about work life

based on 47.1k employees
66%
87%
70%
73%
Flexible timing
Monday to Friday
No travel
Day Shift
View more insights

Cognizant Benefits

Submitted by Company
Shape your career
Invest in yourself
Learn and grow
Keep current
Stay healthy
Give back
Submitted by Employees
Health Insurance
Cafeteria
Work From Home
Free Transport
Soft Skill Training
Job Training +6 more
View more benefits

Compare Cognizant with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

Accenture

3.9
Compare

Capgemini

3.8
Compare

Tech Mahindra

3.6
Compare

IBM

4.1
Compare

Deloitte

3.8
Compare

Amazon

4.1
Compare

Google

4.4
Compare

PwC

3.4
Compare

Persistent Systems

3.5
Compare

Ernst & Young

3.5
Compare

DXC Technology

3.7
Compare

HCLTech

3.6
Compare

Virtusa Consulting Services

3.8
Compare

KPMG India

3.5
Compare

Zoho

4.3
Compare

Nagarro

4.0
Compare

Oracle

3.7
Compare

Similar Jobs for you

MS SQL DBA at Thinksys Software

Noida

5-10 Yrs

₹ 10-20 LPA

Database Admin at Pine Labs

5-12 Yrs

₹ 30-40 LPA

SQL Database Administrator at Neobric

Hyderabad / Secunderabad, Bangalore / Bengaluru

8-12 Yrs

₹ 25-35 LPA

Database Admin at Burgeon It Services Pvt Ltd

Bangalore / Bengaluru, Hyderabad / Secunderabad + 2

5-10 Yrs

₹ 20-22 LPA

SQL Database Administrator at GAVS Technologies Pvt. Ltd. (GAVS)

Chennai

7-12 Yrs

₹ 14-20 LPA

Plsql Developer at SMARTWORK IT SERVICES

3-10 Yrs

₹ 5-20 LPA

Database Admin at EDGE

6-14 Yrs

₹ 23-33 LPA

Plsql Developer at Azentio Software Pvt Ltd

Mumbai, Bangalore / Bengaluru

4-8 Yrs

₹ 22-25 LPA

Manager at Cognizant

Hyderabad / Secunderabad, Chennai + 1

8-13 Yrs

₹ 18-33 LPA

Senior Database Administrator at Flairdeck consulting

5-7 Yrs

₹ 15-20 LPA

Cognizant Chennai Office Location

View all
Chennai Office
5/535, Old Mahabalipuram Road Okkiam -Thoraipakkam Chennai
Tamil Nadu 600096

MS SQL DBA

8-12 Yrs

Chennai

28d ago·via naukri.com
write
Share an Interview