Title : Lead Administrator

Location : Nashville, Georgia (Onsite)

Duration : Full Time

Description:

Required Skills : SQL, MSSQL, AWS or Azure Certified

Roles and Responsibilities

• 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.

Core skills

• 12 years 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 Years experience with AWS Service offerings and Components, AWS-CLI, AWS-RDS, AWS Storage, Cloud formation and AWS DB Migrations.
• 8 Years experience with SQL Server Performance tuning, Capacity planning, Resource usage analysis and Recommendations.
• 4 years' experience with Windows PowerShell for SQL Server, PowerShell usage on AWS-CLI.
• 8 years' experience with deploying SSRS, Assemblies/CLRs, Extended Stored Procedures, SSIS, etc.
• 8 years' 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

Education & Training

• 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