MS SQL DBA
Cognizant
Date: 9 hours ago
City: Chennai, Tamil Nadu
Contract type: Full time

Job Description
Job Title: 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.
Essential Skills
SQL Server Adminstration and AWS cloud
Nice to Have Skills.
Oracle / PostgreSQL
Qualifications
Job Title: MS SQL Server DBA
- Job Summary – highlight project details/what is exciting about the role :
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.
- 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.
- Perform regular database maintenance tasks, such as index rebuilding, query optimization, and database tuning.
- Proactively identify and resolve database performance issues and bottlenecks.
- 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.
- Perform in-depth performance tuning and optimization, identifying and resolving performance bottlenecks, slow queries, and other related issues.
- Oversee and manage database replication strategies, including setup, configuration, monitoring, and troubleshooting of replication in Standalone and Always ON.
- Monitor database health using various tools, set up alerting mechanisms, and respond to incidents in a timely manner to minimize downtime and data loss.
- 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.
- Job Requirements
Essential Skills
SQL Server Adminstration and AWS cloud
Nice to Have Skills.
Oracle / PostgreSQL
Qualifications
- A bachelor's 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
- Travel required YES NO
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
Business Analyst
Amazon,
Chennai, Tamil Nadu
4 days ago
DescriptionAre you passionate about solving business challenges at a global scale? Amazon Employee Services is looking for an experienced Business Analyst to join Retail Business Services team and help unlock insights which take our business to the next level. The candidate understand and implement new and repeatable processes to improve our employee global work authorization experiences. They will do this...

Senior Procurement Specialist
Toast,
Chennai, Tamil Nadu
6 days ago
Toast is a rapidly growing startup building the first all-in-one restaurant management software platform. Toast’s Android tablet-based system helps restaurants operate more efficiently and connect with their customer base in new and innovative ways. We’re growing fast and have a customer base of cafes, restaurants, bars and nightclubs across the country. We work hard and care about our customers’ success...

Sales Manager-Banc assurance-HDFC
Bajaj Allianz General Insurance,
Chennai, Tamil Nadu
6 days ago
ExecutionAnalyze the customer segmentation, sales trends in terms of demographics, geography, characteristics etc. to assess the potential for businessConduct trainings at the branch for all banking partners around regulatory guidelines and products.Plan for activation of branches through R&R activities to increase the penetration in active branches to realize full potential of the bank partner in the given geographyRelationship ManagementDrive the...
