Principal Engineer I - DBA

Company: SPECTRUM
Location: Denver
Posted on: June 25, 2022

Job Description:

JOB SCOPE

Responsible for Monitoring our Service Delivery Platform and troubleshooting system defects and providing recommendations for fixes. Plan, design, develop, implement and execute innovative application and platform solutions related to security, service delivery, datacenter and service desk management, Operation Support Systems, and Business Support Systems.

DUTIES AND RESPONSIBILITES

• Responsible for maintaining and assisting with day-to-day support of Oracle databases both on Exadatas and VMs.
• Implement data protection, replication and disaster recovery methodologies and strategies for capacity planning, configurations and complete setup of database solutions.
• Install and configure grid infrastructures and databases.
• Maintain high availability database solutions using diagnostic and monitoring tools and methods including, Real Application Clusters (RAC), Exadata, and Data Replication and Data Protection (Golden Gate and Data Guard). Design, configure, test and document system enhancements, including hardware and software updates, performance reliability, and scalability of the network.
• Create strategic infrastructure roadmaps including on premise, hybrid and cloud technologies.
• Allocate physical and logical resources, connectivity, networks and topology services, lifecycles and business processes.
• Collaborate with technical operations on system design and configuration of the Service Delivery Platform and other business applications.
• Performs other duties as requested by supervisor.BASIC / MINIMUM QUALIFICATIONS
  • Bachelors degree Engineering, Information Technology, Computer Science or related field, and / or related work experience.
  • Minimum eight (8) years of experience in maintaining and managing Oracle V.12c or other databases listed above, utilizing Oracle Exadata & Oracle Data Appliances to integrate software, and / or networking and storage.
  • Minimum eight (8) years of experience Utilize Oracle Enterprise Manager (OEM) to manage software deployment, operations, monitoring, diagnosing, and resolving problems.
  • Minimum eight (8) years of experience Perform data mappings and data materialization and data mining.ADDITIONAL JOB QUALIFICATIONS
    • Utilize On-line transaction processing (OLTP) and On-line Analytical Processing (OLAP) for database development.
    • Perform data mappings and data materialization and data mining.
    • Oversee heterogeneous databases and operating systems, bidirectional replication such as Golden Gate without distance limitations, maintain transactional integrity, reliable data delivery and fast recovery after service interruption.
    • Collaborate with application developers and system administrators to plan and implement code and database changes.
    • Configure Oracle Enterprise Manager monitoring tools, implement monitoring policies, establish data replication, and assist in developing and implementing disaster recovery strategies.
    • Review work plans and designs and provide recommendations for improvements.
    • Work with Oracle and other partners in completing security and other patches.
    • Command incident bridges from a technical point of view and drive issues to resolution.
    • Lead, identify and perform root cause analysis (RCA). Mentor junior DBAs and provide recommendations and work with management and leadership in providing optimal solutions.PREFERRED QUALIFICAITIONS
      • Experience with MongoDB and/or SQL Server a bonus.WORK ENVIORNMENT
        • Minimum travel required (national travel 3-4 times annually)
        • Must be available for on-call rotation
        • Must be available to perform maintenance after hours.
          #LI-AK EGN601-APO 310660 310660BR
          
          Here, employees dont just have jobs, they build careers. Thats why we believe in offering a comprehensive package that rewards employees for their contributions to our success, supports all aspects of their well-being, and delivers real value at every stage of life.
          
          The pay for this position has a salary range of $107,600.00 to $191,200.00. The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience and location. Also, certain positions are eligible for additional forms of compensation such as bonuses.Required
          Preferred

          Job Industries

          • Transportation

Keywords: SPECTRUM, Denver , Principal Engineer I - DBA, Other , Denver, Colorado