SQL Database Administrator

Infosys Limited; United Kingdom; Remote; GBP 45,000 - 55,000; Full time

Job summary

A global technology consulting firm is seeking an experienced SQL Database Administrator to work closely with Data Engineers and Subject Matter Experts. This role involves maintaining best practices while collaborating with various teams to set technical vision. Candidates should have experience in MS SQL server administration, a Bachelor's degree or equivalent, and familiarity with cloud environments like Azure. Benefits include competitive compensation and health insurance.

Benefits

Medical/Dental/Vision/Life Insurance

401(k) plan

Paid holidays plus Paid Time Off

Qualifications

• At least 6 months of experience in MS SQL server administration and maintenance.
• Strong analytical skills and experience in performance tuning.
• Able to install and configure the MS SQL Server.
• Experience with database upgrades and migrations.

Responsibilities

• Maintain database systems and troubleshoot problems.
• Collaborate with teams to set technical vision and architecture.
• Manage roles and permissions of database users.
• Document database infrastructure including diagrams.

Skills

MS SQL Server administration

Cloud environment understanding (Azure)

Troubleshooting skills in SQL Clustering

Performance tuning in MS SQL server/PostgreSQL

Data modeling

Education

Bachelor’s degree or foreign equivalent

Tools

SQL Profiler

PostgreSQL

SQL Server Integration Services (SSIS)

PowerShell

Job description

Technology: Cloud Platform, Databases on Azure, Database Administration, MS SQL Server

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

Required Qualifications:

• Candidate can work from anywhere in the USA. This position may require travel to project/client locations.
• Candidate must be available to work on a rotating shift schedule to provide 24/7 support.
• Shift 1: 05:00–14:00 CST
• Shift 2: 13:00–22:00 CST
• Shift 3: 21:00–06:00 CST
• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 6 months of Information Technology experience.
• At least 6 months of experience in MS SQL server administration and maintenance (PostgreSQL will be an added advantage).
• Understanding of Cloud environment (Azure will be preferable).
• Able to install and configure the MS SQL Server, configure the SQL clustering, SQL Always-On Availability Groups.
• Able to do capacity planning based on the growth pattern of the databases.
• Have expert troubleshooting skills on the SQL Clustering environment and Postgres environment.
• Monitor, maintain database systems and troubleshoot problems that may arise.
• Strong Analytic skills, Data Modelling & Performance tuning in MS SQL server/PostgreSQL.
• Perform Upgrade of databases to different versions of SQL and migration of databases from SQL server to PostgreSQL.
• Maintain data integrity and security (manage 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 back-ups, restoration and replication.
• Knowledge of SQL Server Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
• Should be well versed with the SQL replication functions and Change Data capture process.
• 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.

Preferred Qualifications:

• Worked on tools like Qlik Attunity, SolarWinds DPA and Delphix.
• PowerShell programming.
• Backup and restore tools like EMC Networker, CommVault.
• Planning and Co-ordination skills.
• Experience of Mergers and Acquisitions will be an added advantage.
• Good Communication and Analytical skills.

Benefits:

Estimated annual compensation range for this role will be as follows:

In CA/ WA / NY / CO / MD / IL / MN / NJ: $61,000 to $73,200.

In Washington, DC: $61,700 to $66,200.

Along with competitive pay, as a full-time Infosys employee, you are also eligible for the following benefits:

• Medical/Dental/Vision/Life Insurance.
• Long-term/Short-term Disability.
• Health and Dependent Care Reimbursement Accounts.
• Insurance (Accident, Critical Illness, Hospital Indemnity, Legal).
• 401(k) plan and contributions dependent on salary level.
• Paid holidays plus Paid Time Off.

About Us

Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation.

EEO Statement

Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.