JUMP TO CONTENT
Shortlist
search jobs Search
About the role ICON and you Application Process Day in the life Who we are

DBA II

043505_2

About the role

This vacancy has now expired. Please see similar roles below...

  • Providing moderate to Complex database support for 250+ Microsoft SQL servers.
  • Perform SQL Server Installation, Upgrades, Migrations and Configuration.
  • ·         Install database software service packs and cumulative updates as necessary
  • ·         Monitor performance of database systems resources and query throughput
  • ·         Optimize SQL Code as necessary (Stored Procedures, Functions, Index)
  • ·         Monitor and maintain database storage resources
  • ·         Maintain database documentation as required
  • ·         Maintain and administer database security access
  • ·         Troubleshoot and resolve database connectivity issues
  • ·         Follow Change Management processes to implement database configuration changes
  • ·         Follow Problem Management processes to troubleshoot and resolve recurring issues
  • ·         Proactively monitor and respond to MSSQL database Alerts.
  • ·         Provide clarification for internal database servers Audits.
  • ·         Need to work with vendor to implement performance recommendations.
  • ·         Configuring and Maintaining High Availability [Clustering, Always ON, Mirroring] for many Critical servers.
  • Monitor and optimize the complex performance and security of the RDBMS servers and other servers as required.
  • Perform complex setups, installations, updates and maintenance of all IT RDBMS servers in accordance with ICON SOPs.
  • Perform complex level troubleshooting of issues and problems generated by IT systems and as requested.
  • Provide assistance to the programming team as needed for tasks including performance tuning and data uploads from basic to moderate level of complex tasks.
  • Provide assistance to the application support team in performing study installations, configurations and reviews; uploads of client data into the system; setup of new users; setup and configuration of system as needed; in addition to various other maintenance tasks as assigned at moderate to complex level while minimizing the number of errors as needed.
  • Perform basic to moderate level of complex system migration and cross platform database communication.
  • Ensure the backup site for IT RDBMS servers are ready to be brought online in the event of a site failure in the primary IT RDBMS server sites of moderately complex task.
  • Provide assistance to the IT team for backing up and restoring all data from IT RDBMS servers.
  • Perform BI Tasks: Create and deploy moderately complex SSRS Reports and SSIS packages.
  • Perform basic reviews for all levels of DBA Tasks.
  • Ability to determine and make improvements in current processes and applications.
  • Required to be on call to support after hours to resolve SQL issues as they arise.
  • Ability to complete tasks on time with no supervision.
  • Ability to mentor team members on DBA basic to moderately complex projects and tasks.
  • Supports the organization, management and vision of the practice. Supports the multiple tasks involved in a project or assignment and prioritizes their completion.
  • Ability to automate existing process using shell scripting .
  • Hands on experience on Oracle , MYSQL , Mongo databases will be added advantage .
  • Ability to work on Linux operating systems will be added advantage.

    List #1

    Day in the life

    Mission, vision, Values
    Home Sweet Office: Why Culture Compatibility Matters

    Teaser label

    Inclusion & Belonging

    Content type

    Blogs

    Publish date

    04/29/2024

    Summary

    Cultural Fit in the Workplace Finding the perfect cultural fit is crucial when searching for a new employer. It goes beyond just the job description and salary package. Cultural fit refers to how

    Teaser label

    Explore how aligning with the right company culture can transform your work environment into a home away from home.

    Read more
    Medicine container
    Precision Medicine: How Personalised Therapies are Transforming Healthcare

    Teaser label

    Industry

    Content type

    Blogs

    Publish date

    04/29/2024

    Summary

    Precision medicine is a groundbreaking approach that aims to revolutionise healthcare by tailoring medical treatments to individual patients. Unlike traditional medicine, which adopts a one-size-fi

    Teaser label

    Discover how precision medicine is revolutionising healthcare by tailoring treatments to each patient.

    Read more
    Headshot of Deepak, the author of this blog
    Day in the life of a Clinical Data Mangement Project Manager

    Teaser label

    Our People

    Content type

    Blogs

    Publish date

    04/29/2024

    Summary

    Deepak is a Clinical Data Management Project Manager at ICON Strategic Solutions, the largest global provider of Functional Service Provision (FSP). He works as a dedicated resource within one of o

    Teaser label

    Deepak shares his experience as Clinical Data Management Project Manager at ICON Strategic Solutions.

    Read more
    View all

    Who we are

    Press play to find out more

    Similar jobs at ICON

    Assistant Clinical Data Coordinator

    Salary

    Location

    India, Chennai

    Location

    Chennai

    Remote Working

    Office Based

    Business Area

    ICON Full Service & Corporate Support

    Job Categories

    Clinical Data Management

    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

    JR119397

    Expiry date

    01/01/0001

    Sunidhi Sinha

    Author

    Sunidhi Sinha
    Sunidhi Sinha

    Author

    Sunidhi Sinha
    Read more Shortlist Save this role
    Read more Shortlist Save this role
    CRA II

    Salary

    Location

    China, Shanghai

    Department

    Clinical Monitoring

    Location

    Shanghai

    Remote Working

    Hybrid: Office/Remote

    Business Area

    ICON Full Service & Corporate Support

    Job Categories

    Clinical Monitoring

    Job Type

    Permanent

    Description

    Job Advert PostingAt 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’

    Reference

    JR113644

    Expiry date

    01/01/0001

    Jonathan Cunliffe

    Author

    Jonathan Cunliffe
    Jonathan Cunliffe

    Author

    Jonathan Cunliffe
    Read more Shortlist Save this role
    Read more Shortlist Save this role
    Senior TMF Lead

    Salary

    Location

    India, Chennai

    Department

    Clinical Trial Management

    Location

    Bangalore

    Chennai

    Bengaluru

    Remote Working

    Hybrid: Office/Remote

    Business Area

    ICON Full Service & Corporate Support

    Job Categories

    Regulatory Document Management

    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

    Reference

    JR115493

    Expiry date

    01/01/0001

    Amrutha Saidala

    Author

    Amrutha Saidala
    Amrutha Saidala

    Author

    Amrutha Saidala
    Read more Shortlist Save this role
    Read more Shortlist Save this role
    Senior Clinical Trial Transparency Associate

    Salary

    Location

    Poland, Romania, Hungary, Slovakia

    Department

    Medical Affiars & Medical Writing Roles

    Location

    Hungary

    Poland

    Romania

    Slovakia

    Business Area

    ICON Strategic Solutions

    Job Categories

    Medical Writing

    Job Type

    Permanent

    Description

    Senior Clinical Trial Transparency Associate is responsible for CTT deliverables, the role is single sponsor dedicated.  The role can be based in Eastern Europe

    Reference

    2024-110086

    Expiry date

    01/01/0001

    Natalia Roth

    Author

    Natalia Roth
    Natalia Roth

    Author

    Natalia Roth
    Read more Shortlist Save this role
    Read more Shortlist Save this role
    Contract Analyst - Sponsor Dedicated

    Salary

    Location

    Greece

    Department

    Clinical Operations Roles

    Location

    Greece

    Remote Working

    Remote

    Business Area

    ICON Strategic Solutions

    Job Categories

    Contracts Administration

    Job Type

    Permanent

    Description

    As a Site Contracting Rep you will be joining the world’s largest & most comprehensive clinical research organisation, powered by healthcare intelligence.

    Reference

    2024-110186

    Expiry date

    01/01/0001

    Alexander Sourounis

    Author

    Alexander Sourounis
    Alexander Sourounis

    Author

    Alexander Sourounis
    Read more Shortlist Save this role
    Read more Shortlist Save this role
    TMF Specialist (All Levels)

    Salary

    Location

    India, Chennai

    Department

    Clinical Trial Management

    Location

    Bangalore

    Chennai

    Bengaluru

    Remote Working

    Office Based

    Business Area

    ICON Full Service & Corporate Support

    Job Categories

    Regulatory Document Management

    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

    JR117226

    Expiry date

    01/01/0001

    Gowri Shankar Nalla Perumal

    Author

    Gowri Shankar Nalla Perumal
    Gowri Shankar Nalla Perumal

    Author

    Gowri Shankar Nalla Perumal
    Read more Shortlist Save this role
    Read more Shortlist Save this role

    Browse popular job categories below or search all jobs above