Hybrid Oracle DBA

Company: EDI Staffing
Location: Washington
Posted on: March 20, 2023

Job Description:

Job Description

SUMMARY
Provides design, builds, enhances, monitors, optimizes and supports databases in a controlled Linux environment in the AWS Cloud. Experience in database migration from Oracle to Postgres. Used to working in a controlled environment and following procedures. Ensures maximum security, availability and performance of the database systems while ensuring IT general controls are strong and enforced. Implements database architectures and system alternatives to keep pace with the industry, enhances practice of database administration, and maximizes corporate investment. Assists data analysts with research requests and with determining the cause and extent of problems when they occur. Helps to make recommendations to improve processes and procedures.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Migrate existing Oracle databases to Postgres
• Troubleshoot performance issues and assist with resolution
• Develops, documents and rolls out standard process for implementing database and system patch upgrades and new database environment builds via CI/CD pipeline
• Operate databases in AWS Cloud to support research and analysis
• Defines, refines, and standardizes database performance and tuning practices
• Refines and manages baseline configurations for the database environment
• Automates routine database functions to ensure accuracy and minimize costs
• Establishes and practices a consistent database backup and recovery practice that complies with the backup and retention policies and business continuity practices
• Performs migration of corporate database systems
• Develops and follows upgrade procedures to ensure consistency within all databases
• Conducts performance testing and reports on impact of Oracle and Microsoft upgrades on applications
• Maintains detailed database architecture diagrams and documentation
• Provides 24x7 operational support of corporate production databases on a rotating schedule
• Performs routine production database and application maintenance tasks on a rotating basis
• Monitors all production database activity for operational improvements to include, but not limited to CPU, Disk and Memory utilization, IOPS, replication and consistency of sites, long running queries/data loads, query access plans, security infractions and overall performance of databases Develops and implements corrective measures for database issues/problems found during monitoring.
  • Provides database technical support for Technology and Application Delivery projects to include, but not limited to analysis of database design and schema, database environment provisioning, security assessments, database build executions, database application performance testing/tuning and supporting project deployments. Leads and manages all database aspects of the assigned technology delivery project.
    • Acts as subject matter expert for all database systems; provides level 2 and 3 technical support for complex database issues.
    • Provides technical input to software developers and end users in the areas of database capabilities, performance and best practices.
    • Stays current with AWS database services and capabilities
    • Provides training and guidance to peers and Database Administrators
    • Recommends, creates, and follows all relevant policies and procedures to operate a controlled production environment
    • Leads and manages database administration activities as assigned by the Lead Database Administrator
    • Performs other duties as assigned
      EDUCATION/QUALIFICATIONS
      Ten or more years of related experience with other DBMS software including DB2, Sybase, PostgreSQL and SQL Server. Must possess advanced knowledge of Oracle DBA administration, Oracle clusters, Golden Gate, database/application tuning, and recovery in 19c. Demonstrated knowledge and experience with Linux/UNIX operating systems, PL/SQL development and IT General Controls. AWS and Oracle Certifications desired.
      
      Ability to work in a fast-paced development environment and provide 24x7 support to ensure continuous market presence. Ability to transform business and technology solutions to operate in the Cloud. Ability to read and comprehend complex instructions, write detailed reports, business correspondence, system requirement documents, procedures, and training manuals.
      
      Ability to effectively present information and respond to questions from groups of managers and staff. Ability to define problems, collect data, establish facts and draw valid conclusions. Ability to interpret and deal with an extensive variety of technical instructions in mathematical or diagram form. Ability to identify, research and present technical solutions to management and stakeholders for action.

Keywords: EDI Staffing, Washington DC , Hybrid Oracle DBA, IT / Software / Systems , Washington, DC