What are the responsibilities and job description for the SQL DBA - Infra Ops Specialist position at Cognizant Technology Solutions?
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
Top 5 Skills on exp level
