AddressSQL DB Administrator
At Cognizant, our global community sets us apart—an energetic, collaborative, and inclusive workplace where everyone can thrive. And with projects at the forefront of innovation, you can build a varied, rewarding career and draw inspiration from dedicated colleagues and leaders. Cognizant is right where you belong.
Role Overview
We are seeking a passionate SQL DB Administratorto join our growing and dynamic team! This role will be for Cognizant's Infrastructure practice.
What You'll Do
• Experience in Database Administration in SQL Server (2012,2014, 2016, 2017)
• Experience in Database Deployment and Transformation in Public Cloud (Azure / AWS / Google)
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
• Good knowledge on Mongo DB
• Knowledge on DB architectures and P2G activities
• Good knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Always ON
• Strong knowledge of indexes, index management, integrity checks, Database Encryption, configuration, patching.
• Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SSCM, PerfMon, DMVs)
• Documentation skills for processes and procedures ( creating KBs, run books, topology etc )
• SQL Database Operational support to tech users
What you bring to the role
Must haves’ skills-SQL DB
Nice to haves’ skills –Mongo DB
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 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.
Working arrangements
We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a hybrid position requiring 3 days a week in a client or Cognizant office in Toronto. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.
The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.
Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation at nacareers2@cognizant.com.
Employee Status : Full Time Employee
Shift : Day Job
Travel : No
Job Posting : Apr 05 2024
About Cognizant
Cognizant (Nasdaq-100: CTSH) 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 is ranked 185 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com or follow us @Cognizant.
