DBA-Developer (R1032375) in Horsham, PA at IQVIA™

Date Posted: 9/9/2018

Job Snapshot

Job Description

This position will be approximately 75% Development DBA and 25% Production DBA work.  Responsibilities include work on both Oracle and SQL Server platforms.  The emphasis is on providing assistance to the development team to integrate and upgrade the current software environment to satisfy corporate project requirements.

Required Skills:

  • Oracle
    • Oracle Enterprise Edition (11g and 12c) running on Oracle Enterprise Linux 7
    • Oracle Enterprise Manager
    • ASM
    • PL/SQL
    • Package writing and maintenance
    • Materialized Views
    • Message Queue/Advanced Queueing/AQ
    • RMAN
    • Knowledge of installing ORACLE CPUs
    • TOAD and Oracle Enterprise Manager
  • SQL Server
    • Experience with SQL Server versions 2005 to 2016
    • Experience running and troubleshooting SSIS packages
    • Experience troubleshooting performance issues in the SQL Server environment
    • Experience with performance tuning on SQL Server 2008 R2 and SQL Server 2016.
  • Scripting and coding
    • Linux shell scripting
    • Perl scripting / programming
    • PowerShell scripting
    • VB and C# .NET programming
    • SSRS 2008 R2 and SSRS 2016

Experience: 10 years minimum with at least 5 years as an Oracle DBA (combined Production and Development DBA roles)

Specific responsibilities:

  • Provide 24x7 coverage for Oracle Database environment
  • Maintain database backups and perform test recoveries in SQL Server and Oracle environments.
  • Plan and test disaster recovery processes as they relate to the databases
  • Monitor and address database related application issues on production databases
  • Upgrade and maintain Oracle and related software (apply Oracle CPUs, upgrade database version) in coordination with IT staff
  • Upgrade and maintain SQL Server and related software (apply patches and updates when necessary)
  • Coordinate removal and/or archiving of data that is no longer required to be available in the production databases.
  • Software Development and Support

    Design and create databases to support develop initiatives

    Maintain development database environments for programming and new solutions teams

    Refresh and cloning of production databases into test environments

    Develop software to support development initiatives

    Develop and co-develop (with the programming group) new applications

  • Consult on data access queries (SQL) for ad hoc analysis.

Job ID: R1032375