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 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 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 300,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 world's 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.
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.