Reference: 012063

 

Job Description

 

This is an exciting opportunity to work within a fast paced, busy environment for a leading global provider of outsourced development services to the pharmaceutical, biotechnology and medical device industries. As part of the ADAllen Pharma Limited this person will be responsible for Database Administration.  Responsibilities extend to troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

 

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 ADAllen Pharma Limited

 

Other than working with a great team of smart and energetic people, we also offer a very competitive benefits package. 

 

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.