SQL DBA - Infra Ops Specialist

ROLE : INFRA OPS SPECIALIST

We are looking for a SQL DBA who will be responsible for building AWS EC2 servers, configuring Always ON and migrating SQL databases to On-premise and cloud environment (AWS) and ensuring their security, stability, reliability, and performance. He would help to solve all migration related issues and ensure end to end smooth migration.

Location : Hartford CT ( 100% Onsite )

Responsibilities :

• The ability to assist in finalizing a Microsoft SQL Server migration design in which to migrate Microsoft SQL server machines into a right-sized Virtual Machine (VM) for On-premise and AWS EC2 residing within the customer’s environment.
• Building AWS EC2 servers using terraform and Jenkins pipelines.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Implement Always On Availability Group as a High Availability solution.
• Automate repetitive tasks performed day to day basis.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Prepare documentations and specifications.

Skills and Qualifications

• Strong proficiency with SQL 2022 and its variation among popular databases
• Strong proficiency in SQL Server side by side migration
• String experience in Always ON setup, configurations and setup
• Experience with backups, restores and recovery models
• Strong knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Experience in SSRS/SSIS/SSAS migration
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Experience of Cloud solutions.
• Strong proficiency in Powershell scripting on SQL and Windows servers.
• Capable of troubleshooting common database issues.
• Knowledge on AWS EC2, S3 Bucket, Security, and other IaaS/PaaS services.
• Knowledge on monitoring solutions in Dynatrace, Foglight etc.

Top 5 Skills on exp level

• SQL DBA - 10 + yrs of exp
• AWS Cloud - 8 + years
• SQL Server migration - 10+ years
• Performance Tuning and Optimization - 8 + years

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.  

Our commitment to diversity and inclusion
Cognizant is an equal opportunity employer that embraces diversity, champions equity and values inclusion. We are dedicated to nurturing a community where everyone feels heard, accepted and welcome. 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 protected characteristic as outlined by federal, state 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.

While our system allows application in all languages, job required language(s) and proficiency level(s) vary. However, basic English proficiency is required for Company-wide communications purposes.

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. Learn how Cognizant helps clients lead with digital at www.cognizant.com.