We are seeking a highly skilled and experienced DBA Lead to join our team. In this role, you will be responsible for Migrating and assisting SQL instances and streamlining the entire migration process and be a continuous contributor for improvement of overall Migration activities
In this role, you will
Migrating many SQL instances to new data center, Several migrations may include new server builds and new (upgraded) versions of SQL installations. Servers will be built by a different team
SQL Installation/upgrades and configuration across SQL Server 2012, 2014, 2016, 2017, 2019
Assisting with testing and verifying migrated / upgraded SQL Instances
Identify potential risk and make recommendations
Testing and remediation of impact on DBA maintenance scripts, SQL agent jobs, audits, triggers, credentials, policy management, ODBC driver configurations
Streamlining the entire migration process to minimize downtime
Participate in migrating production servers (non‐business hours)
Provide regular status updates and attend project meetings
Document new / upgraded server configurations and share knowledge
Contribute to database operations and continuous improvement activities, including on call rotation as assigned
Whatyou’llneed to succeed (requiredskills)
Strong experience in Managing Team from DB technologies from SQL server, Oracle, and/or Sybase domains
Hands-on experience with RDBMS Server Design, build and migrations.
Very good experience with configuration of HA solutions like Failover cluster and Always solutions
Migration experience to On promise SQL Server databases to Cloud like Azure/AWS
Must have strong experience with SQL server security hardening and implementing best practices
Expertise in managing multiple SQL Server 2005, 2008, 2012, 2014, 2016 and 2017 instances on medium to large systems
Strong experience in handling very large databases
Very good knowledge of Windows OS and its related commands
Good knowledge of T-SQL and query tuning Performing tasks related to installation
Enough expertise to identify and recommend changes/improvements to the build process
Knowledge of SQL Server from architecture to administration including design, development, and optimization of SQL Server databases
Proficient in performance tuning, backup, recovery, security, patching, upgrades, and high availability.
Strong expertise in designing and High Availability (HA) deep skills in Windows Clustering, SQL Always on Availability Groups ,Clustering, log shipping, mirroring and Storage replication.
Analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
scripting languages like PowerShell, or other shell scripting and Python, Ansible playbooks
Working experience in working on Azure SQL Server and Database
Whatwill help you stand out (preferredskills)
SQL DBA, Azure SQL with a minimum of 5 years of exp at expert level knowledge
Project Management/Lead Experience with a minimum of 3 years of experience at expert level knowledge
Oracle/Sybase DBA with a minimum of of 3 years of experience at intermediate level of knowledge
Working arrangements
We strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a remote position open to qualified applicants in Ontario and/or Nova Scotia, where our hubs are located. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.
Note: 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.
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.
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 2025) is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital at www.cognizant.com.
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 CareersNA2@cognizant.com 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.