Key Responsibilities:
•Manage SQL Server databases, focusing on performance, troubleshooting, and issue resolution.
•Maintain AWS services for database operations (RDS, S3, IAM policies).
•Monitor database performance and optimize queries, indexes, and parameters.
•Ensure database security by managing users, roles, and privileges.
•Handle environment cloning and refreshes for development and testing.
•Automate routine tasks and monitoring in cloud environments.
•Troubleshoot database and application connectivity issues.
•Archive huge tables into S3 buckets periodically and automate the process.
•Recording Incident & Problem Management for Tickets logged for the project.
Skills Required:
•SQL query performance tuning.
•Analysis of long-running queries and suggesting optimizations.
•Script review and validation.
•Troubleshooting database-related issues.
•Proficiency in DB Profiler, Query Store, and Extended Events (XEvent) session and job creation.
•Strong knowledge of indexes and table statistics.
•Ability to analyse execution plans and Plan XML files.
•Experience with AWS RDS configuration, backups, and monitoring.
•Familiarity with cloud automation and cost optimization strategies.
•ITSM certification is desirable.
#LI-CTSAPAC
#LI-CTSAPAC
About us
Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, realize tangible returns and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.
Additional employment information
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.
Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you’ll deliver services to and collaborate with stakeholders outside the province who may not speak French.
Cognizant is an equal opportunity employer. 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 characteristic protected by federal, provincial or local laws.
If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.
