What are the responsibilities and job description for the SQL DBA - Infra Ops Specialist position at Cognizant?
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
