Job Summary
We are looking for a SQL engineer who will be responsible for upgrade of SQL databases from SQL 2016 version to SQL 2022 in 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.
Responsibilities
Job Description SQL Upgrade
We are looking for a SQL engineer who will be responsible for upgrade of SQL databases from SQL 2016 version to SQL 2022 in 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.
Responsibilities
The ability to assist in finalizing a Microsoft SQL Server migration design in which to migrate older Microsoft SQL server machines into a right sized Virtual Machine for On premise and AWS EC2 residing within the customers environment.
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 2016 and above and its variation among popular databases
Strong proficiency in SQL Server migration from old version to newer version
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 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.
Certifications Required
Microsoft sql server certified admin AWS cloud admin
The Cognizant community:
We are a high caliber team who appreciate and support one another. Our people uphold an energetic, collaborative and inclusive workplace where everyone can thrive.
- Cognizant is a global community with more than 300,000+ associates around the world.
- We don’t just dream of a better way – we make it happen.
- We take care of our people, clients, company, communities and climate by doing what’s right.
- We foster an innovative environment where you can build the career path that’s right for you.
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
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, 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.
Disclaimer:
Compensation information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.