Job Summary
We are seeking a Technical Lead with 4 to 6 years of experience to join our team. Hands on experience of MSSQL 2012 2016 2019 administration
Create database and its file structure
Knowledge of database backup and recovery strategy
User management and database security
User and role management for user
Knowledge of High Availability HA and Disaster Recovery DR options like mirroring clustering for SQL Server
Responsibilities
Hands on experience of MSSQL 2012 2016 2019 administration
Create database and its file structure
Knowledge of database backup and recovery strategy
User management and database security
User and role management for user
Knowledge of High Availability HA and Disaster Recovery DR options like mirroring clustering for SQL Server
Ability to organize and plan work independently
Knowledge of indexes index management and statistics
Ability to troubleshoot and resolve database problems
Knowledge of Windows Failover cluster
Knowledge of maintenance plan of including backups index maintenance consistency checks and statistics maintenance
Perform database performance monitoring and analysis and recommend tuning adjustments and make database adjustments to compensate
Provide support to application programmers through analysis and recommendations as requested for database access and performance problems
Identify recommend and reorganize database structures and data needed based on performance factors and user requirements
Provide application data refresh as requested to various development and test environments
Maintain documentation of backup and recovery procedures physical data storage and logical data design for assigned databases
Experience of windows OS
Experience with crossplatform database network communication techniques
An understanding of one or more database management systems including performance management security various file system concepts
Good written and verbal communication skills
Ability to work as a team member
Qualifications
Possess a strong understanding of AWS EC2 and AWS RDS with hands-on experience in managing and optimizing these services.Have extensive experience in administering MariaDB MySQL and MS SQL Server databases.Demonstrate proficiency in Windows operating systems and their integration with database systems.Exhibit excellent problem-solving skills and the ability to troubleshoot complex database issues.Show strong communication skills and the ability to work effectively in a hybrid work model.Have a proactive approach to learning and staying current with the latest database technologies and best practices.Display the ability to work independently and as part of a team managing multiple tasks and priorities effectively.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.
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.