Azure SQL Database Administrator

Infosys • Hartford, CT

96d

About The Position

Infosys is seeking a Azure SQL Database Administrator. This role requires close partnership and collaboration with other Data Engineers and Subject Matter Experts. This candidate needs to maintain best practices and collaborate with the architecture and application teams to set the technical vision and target architecture.

Requirements

• Candidate must be located within commuting distance or willing to relocate to Richardson, TX.
• Candidate must be available to work on a rotating shift schedule to provide 24/7 support.
• Bachelor's degree or foreign equivalent required from an accredited institution.
• At least 4 years of Information Technology experience.
• At least 3 years of hands-on experience in MS SQL server on Azure/PostgreSQL administration and maintenance.
• Strong analytic skills, data modeling & performance tuning in MS SQL Server/PostgreSQL.
• Strong knowledge of SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
• Candidates authorized to work for any employer in the United States without employer-based visa sponsorship.

Nice To Haves

• Worked on tools like Qlik Attunity, SolarWinds DPA and Delphix.
• PowerShell programming.
• Backup and restore tools like EMC Networker, CommVault.
• Planning and coordination skills.
• Experience of Mergers and Acquisitions.

Responsibilities

• Maintain best practices and collaborate with architecture and application teams.
• Install and configure MS SQL Server, configure SQL clustering, SQL Always On Availability Groups.
• Perform capacity planning based on the growth pattern of the databases.
• Troubleshoot SQL Clustering environment and Postgres environment.
• Monitor and maintain database systems and troubleshoot problems.
• Perform data modeling and performance tuning in MS SQL Server/PostgreSQL.
• Upgrade databases to different versions of SQL and migrate databases from SQL Server to PostgreSQL.
• Maintain data integrity and security by managing roles and permissions of database users.
• Use tools like SQL Profiler, Database tuning advisor, Execution plans for database tuning and Index recommendations.
• Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
• Develop strategies and implement solutions for managing backups, restoration, and replication.
• Ensure timely completion of the databases regular refreshes keeping all the reporting environment in sync.
• Create detailed documentation including diagrams of database infrastructure.
• Learn relevant business processes and understand the data flow, criticality, and dependencies.

Benefits

• Travel may be required as per the job requirements.

What This Job Offers

• Industry: Professional, Scientific, and Technical Services
• Education Level: Bachelor's degree
• Number of Employees: 5,001-10,000 employees