Sr SQL DBA

Sr. Sql Dba

San Ramon, Client Location

Roles And Responsibilities

• Expert in SQL Server Database Administration, including SQL Server on VMWare (on premise), Azure SQL Database and Azure SQL Managed Instance, SQL Server Reporting Server (SSRS).
• Install, configure, and maintain MSSQL databases on production, development, and UAT environments.
• Monitor database performance to ensure high levels of performance, availability, and security.
• Optimize and fine-tune databases for better query performance and scalability.
• Implement and manage backup and recovery procedures, ensuring that databases are protected against data loss and can be quickly restored.
• Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
• Database and T-SQL optimization including performance tuning, query optimization, and supportability.
• DevOps - be able to set up and integrate related DevOps process, managing CI/CD pipelines for Azure devops or Flyway tools.
• Change management including maintenance of multiple development, UAT, and production environments. Responsible for deploying approved changes to production.
• Create and maintain appropriate documentation about the database.
• Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
• Manage SQL server and Windows security audits and take corrective action to stay compliant.
• Provide support after hours through the on-call rotation and weekend support coverage.
• Perform scheduled maintenance and support release deployment activities after hours.

Experience And Qualifications

• 10+ years of strong SQL Server Database administration experience preferably in the asset management industry.
• Knowledge of Azure cloud and 3+ years of experience in Azure SQL Server Managed Instances or Azure SQL Server.
• 5+ years of experience with backups, restores and recovery models.
• 5+ years of experience of High Availability (HA), Availability Groups (AG) and Disaster Recovery (DR) options for SQL Server.
• Hands-on experience with database migration tools and methodologies, particularly to Azure SQL Database or Azure SQL Managed Instance.
• Proficiency with T-SQL for querying, performance tuning, and troubleshooting.
• Strong knowledge of backup, restore, and recovery models (SQL Server Native Backup or third-party tools such as Avamar or Commvault).
• Experience with high-availability solutions (Always On Availability Groups, SQL Clustering, Replication, or Log Shipping).
• Familiarity with database security protocols including encryption and data masking
• Proficient in database monitoring tools (Foglight, or SQL Server Profiler).
• Experienced in collaborating with data warehousing developers. Knowledge of BI toolsets including SSIS, SSRS, and MS SharePoint.
• Experience with SQL Server database replication and external replication platforms
• Must be capable of working independently and collaboratively.
• Great communication skills.

Preferred

• Microsoft Certified Database Administrator (MCDBA) or higher certificates on SQL Server.
• Understanding of or experience supporting .NET applications connectivity to SQL Servers.
• Understanding of or experience with virtual environments.

Salary And Other Compensation

• Applications will be accepted until 10/9/2025.
• The annual salary for this position is between 99,000 to 116,000 yearly depending on experience and other qualifications of the successful candidate.
• This position is also eligible for Cognizant's discretionary annual incentive program, based on performance and subject to the terms of Cognizant's applicable plans.
• Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

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 2024) is consistently listed among the most admired companies in the world.

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.