Database Administrator II
About the role
This vacancy has now expired. Please click here to view live vacancies.
Overview of the Role
-
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
-
Detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
-
Setup backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
-
Setup indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
-
Write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
-
SQL Database Operational support to tech users
Role Requirements
-
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
-
Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
-
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
-
Expert experience in implementing operational automation.
-
Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
-
Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
-
Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
-
Proficiency in Microsoft SQL Server
Benefits of Working in ICON
Other than working with a great team of smart and energetic people, we also offer a very competitive benefits package. This varies from country to country so a dedicated recruiter will discuss this with you at interview stage.
We care about our people as they are the key to our success. We provide an open and friendly work environment where we empower people and provide them with opportunities to develop their long term career.
What’s Next?
Following your application you will be contacted by one of our dedicated recruiters and if successful we will be able to provide you with more details about this opportunity.
ICON is an equal opportunity employer - M/F/D/V and committed to providing a workplace free of any discrimination or harassment
Impactful work. Meaningful careers. Quality rewards.
At ICON, our employees are our greatest strength. That’s why we are committed to empowering you to live your best life, both inside and outside of work. Whether your ambition is lead a global team, become a deep scientific or technical expert, work in-house with our customers or gain experience in a variety of different ICON functions, we will support you in realising your full potential. See all locations Learn more about Our Culture at ICON
Day in the life
.png)
Teaser label
IndustryContent type
BlogsPublish date
06/06/2025
Summary
Building Connections that Drive Progress In an industry where collaboration is critical to advancing science and improving patient outcomes, networking is more than a professional courtesy - it’s
.png)
Teaser label
IndustryContent type
BlogsPublish date
05/29/2025
Summary
Blood Cancer Day Blood Cancer Day is a powerful reminder of the millions of individuals and families whose lives are affected by hematological malignancies every year. These diseases are complex,
.png)
Teaser label
IndustryContent type
BlogsPublish date
05/22/2025
Summary
World Schizophrenia Awareness Day 2025 Every year on 24 May, World Schizophrenia Awareness Day offers a vital opportunity to raise awareness, dismantle stigma, and celebrate the strength of individ
Similar jobs at ICON
Salary
Location
China, Shanghai
Location
Beijing
Shanghai
Remote Working
Home or Office
Business Area
ICON Full Service & Corporate Support
Job Categories
Clinical Operations
Job Type
Permanent
Description
We are currently seeking a Senior Clinical Associate to join our diverse and dynamic team. As a Senior Clinical Associate at ICON, you will play a critical role in overseeing and supporting the execut
Reference
JR131035
Expiry date
01/01/0001
Author
Jessica ZhongAuthor
Jessica ZhongSalary
Location
Korea, South
Department
Clinical Monitoring
Location
South Korea
Seoul
Business Area
ICON Strategic Solutions
Job Categories
Clinical Monitoring
Job Type
Permanent
Description
(Sr.) CRA I or II, Home-based, South Korea As a (Sr.) CRA I or II you will be joining the world’s largest & most comprehensive clinical research organisation, powered by healthcare intelligence.
Reference
2025-120101
Expiry date
01/01/0001
Author
Sonia OhAuthor
Sonia OhSalary
Location
Brazil, Sao Paulo
Location
Sao Paulo
Remote Working
Office Based
Business Area
ICON Full Service & Corporate Support
Job Categories
Drug Safety
Job Type
Permanent
Description
We are currently seeking a Pharmacovigilance Associate to join our diverse and dynamic team. As a Pharmacovigilance Associate at ICON, you will play a vital role in monitoring and ensuring the safety
Reference
JR131552
Expiry date
01/01/0001
Author
Florencia PistolesiAuthor
Florencia PistolesiSalary
Location
Brazil, Sao Paulo
Department
Clinical Monitoring
Location
Sao Paulo
Remote Working
Home or Office
Business Area
ICON Full Service & Corporate Support
Job Categories
Clinical Monitoring
Job Type
Permanent
Description
At ICON, it’s our people that set us apart. Our diverse teams enable us to become a better partner to our customers and help us to fulfil our mission to advance and improve patients’ lives. Our ‘Own I
Reference
JR131451
Expiry date
01/01/0001
Author
Ana LuciaAuthor
Ana LuciaSalary
Location
Canada
Department
Biometrics Roles
Location
Canada
Business Area
ICON Strategic Solutions
Job Categories
Clinical Data Management
Clinical Data Scientist Lead
Clinical Systems
Data Standards Consultant
Job Type
Permanent
Description
As a Clinical Data Manager you will be joining the world’s largest & most comprehensive clinical research organisation, powered by healthcare intelligence. En tant que responsable des données clinique
Reference
2025-120354
Expiry date
01/01/0001
Author
Brendan HoeyAuthor
Brendan HoeySalary
Location
United States, Canada
Department
Biometrics Roles
Location
Canada
United States
Business Area
ICON Strategic Solutions
Job Categories
Clinical Data Management
Clinical Data Scientist Lead
Clinical Systems
Data Standards Consultant
Job Type
Permanent
Description
As a Clinical Data Manager you will be joining the world’s largest & most comprehensive clinical research organisation, powered by healthcare intelligence. En tant que responsable des données clinique
Reference
2025-120351
Expiry date
01/01/0001
Author
Brendan HoeyAuthor
Brendan Hoey