Lead Administrator
Wipro
- Nashville, GA
- Permanent
- Full-time
- A PROUD HISTORY OF OVER 75 YEARS
- FY22 REVENUE 10.4 BN USD
- WE’RE PRESENT IN 66 COUNTRIES
- OVER 1,400 ACTIVE GLOBAL CLIENTS
- Design, Develop and Implement New Solutions using SQL Server/AWS technologies for Customers within Change Healthcare and for the SQL Server Engineering team.
- Migrate SQL Server Environments both from On-premises to Cloud (AWS) and vice versa with Highest standards with no downtimes.
- Should have an understanding and implementation knowledge of Security Audit and Compliances like HIPAA, SOX, FISMA and PCI.
- Handle Highly Technical SQL Server projects and deliver them on time.
- Self Learner/Motivator and possess Strong Sense of Ownership and Problem Solving Skills.
- Communicate effectively and Share knowledge with various teams, Project Managers and Application teams.
- Develop Amazon Cloud formation templates as needed for AWS Cloud projects.
- Deploy Solutions using the following Core technologies both *on-prem* and in *AWS/Azure Cloud*.
- SQL Server/Windows Clustering
- SQL Server Always-ON with read-only replicas and Multiple data centers setup.
- SQL Server Backups & Restores using SQL Native and using Netbackup/Commvault technologies.
- SQL Server Replication (Merge & Transactional), Database Mirroring and SQL Server Log Shipping.
- SQL Server Analysis Services.
- SSRS Multi-scale Deployments.
- SQL Server Database Audit and Dynamic data masking.
- SQL Server SSL and TDE.
- SQL Server Query Store.
- Design SQL Server Partitioning solutions for Very Large database tables.
- Migration between various SAN/NAS technologies, RAID configurations, Volume Types limitations etc.
- Refine and automate regular processes, track issues, and document them
- Migrate SQL Server databases from any version of SQL to any version.
- Track Performance changes using SQL Server Profiler traces.
- Create and tune Database Indexes.
- 12+ yrs hands-on SQL Server Production DBA experience handling very large database systems.
- Microsoft Certified Solutions Expert (preferred) or Microsoft Certified Solutions Associate in SQL 2014/SQL 2016/2017.
- 4+ Yrs experience with AWS Service offerings and Components, AWS-CLI, AWS-RDS, AWS Storage, Cloud formation and AWS DB Migrations.
- 8+ Yrs experience with SQL Server Performance tuning, Capacity planning, Resource usage analysis and Recommendations.
- 4+ yrs experience with Windows Powershell for SQL Server, Powershell usage on AWS-CLI.
- 8+ yrs experience with deploying SSRS, Assemblies/CLRs, Extended Stored Procedures, SSIS, etc.
- 8+ yrs experience with deploying SQL Replication, Log Shipping, DB Mirroring.
- Strong experience on Core Industry Standards for SQL Server, Windows AWS and SAN (for ex: NIST, CIS, SOX, PCI etc)
- Strong experience with AWS EC2 & VMWare technologies and best practices on VMWare/EC2 for SQL Server.
- Strong experience in process automation, related 3rd party software, as well as in-house solutions.
- Maintain commitment to professionally grow and share knowledge within the team.
- Should possess wide sql work experience from SQL 2005 to SQL 2019.
- Should have worked on Multi-Node Clustered Environments.
- Strong experience with SAN best practices for SQL Server and Storage in AWS (for ex: FSX, EBS)
- Experience working with AMS & Microsoft Tech Support.
- Possess working or understanding knowledge of Gitlab and CI/CD Pipeline
- Master’s in computer science preferred.
- Bachelor’s in computer science or equivalent.
- SQL Server certifications.
- AWS or Azure certification is a plus.
- SQL Server & AWS related professional training.