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
What we offer
- The chance to work with impact. Here, you’re empowered to bring your biggest thinking to help our company and clients improve everyday life.
- Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
- The opportunity to thrive on a high caliber team with heart. We celebrate each other’s experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
- A comprehensive total rewards package, including a competitive salary and a pension plan with matching contributions.
- Flexible health and financial benefits to support you and your eligible dependents—from day one.
- True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.
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.
Other employment-related information
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.
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.