Database Analyst 6 in West Des Moines, IA at APEX Systems

Date Posted: 3/1/2018

Job Snapshot

Job Description

Job #:  818539

Database Analyst 6

Des Moines, IA


  • Analyzing database performance
  • Database design/planning
  • Capacity planning
  • Resolution and tracking of the most complex Oracle issues
    • Communicating critical support issues identified to Oracle Support Services
      • Managing escalations for Severity 1 service requests
    • Creating problem workarounds for open service requests
    • Monitoring service requests and communicating status to others on the team
    • Investigating recent SR reports
    • Filing, tracking, and reporting SRs
    • Recommending best practices designed to minimize future SRs
  • Conducting quarterly account reviews
  • Creating and implementing backup and recovery procedures
  • Creating, filing, tracking, and reporting test cases
  • Providing available product-specific white papers and bulletins
  • Researching features and functionality of supported Oracle programs
  • Researching information on problems/questions posed by application DBAs
  • Provide on-call coverage for  first response problem tickets for DBMS from Oracle and patching on UNIX systems, as well as Exadata
    • Looking for the strength to be in Oracle
  • Consults with and advises senior management and multiple clients on high impact data or database management issues, influencing strategic direction
  • Handles and leads various large-scale or highly complex data/database management activities including one or more of the following:
    • Designing highly complex logical and/or physical databases;
    • Leading highly complex data modeling, mapping, integration, and capacity planning efforts;
    • Developing management policies, procedures and standards; and
    • Business requirements identification, analysis and development
  • Provides mentoring, guidance and general oversight to less experienced staff in a variety of database design, administration and/or modeling activities
  • Leads complex projects


  • Knowledge and understanding of Oracle Dataguard
  • Knowledge and understanding of Oracle Golden Gate
  • Knowledge and understanding of Oracle CRS
  • Ability to problem solve database issues while on-call 24x7
  • Knowledge of performance data collection, monitoring and improvement
  • Knowledge of backups and recovery
  • Knolwedge of database security administration
  • Knolwedge of database and server performance monitoring, tuning, and capacity planning
  • Effective communication, ability to work independently, and leadership skills are key
  • 7+ years of database design and administration experience


Minimum Qualifications:

  • 7+ years of experience with Oracle technologies (partitioning, security, performance tuning, memory management, SQL tuning, statistics gathering, application audit logs, Oracle RAC, scheduling, backup and recovery, and data guard) and UNIX (AIX, Solaris, or Linux).
  • 5+ years’ experience with performance monitoring, database and SQL tuning tools such as Explain plan, AWR, Grid control or similar technologies.  Understand and interpret the reports generated from tools and action plan to overcome performance issues.
  • Experience supporting logical replication.

Preferred Skills:

  • Bachelor's degree in IT (Computer Science, Information Systems, etc.) or related field
  • 7+ years related experience in information systems design and development
  • 2+ years of Oracle Exadata Experience
  • 3+ years of experience with ASM/CRS on Oracle 12c
  • 3+ years of experience RMAN backup  with Oracle Oracle 12c
  • Proven ability to provide in-depth consulting services in the identification and resolution of database issues
  • Proven ability to troubleshoot and trace data related issues throughout the architecture
  • Ability to analyze how Oracle resources are being used during SQL executions
  • Ability to work off-hours, when required
  • Demonstrated experience supporting Golden Gate replication.
  • Demonstrated experience cross training and providing support for other applications and RDBMS Platforms.
  • Demonstrated experience with Database Capacity Planning.
  • Demonstrated experience with a UNIX-based programming language (Kornshell, PHP, PERL, C)
  • Demonstrated experience participating in the planning, design and usage of data resources
  • Demonstrated experience providing support to development team on infrastructure and DBA Support
  • Demonstrated experience providing a daily status of application and performance
  • Candidate must possess self motivation and strong communication skills (oral and written) to manage customer relations with emphasis on verbal and written communication
  • Demonstrated ability to quickly learn, retain, and apply good interpersonal skills, and perform effectively under time pressure are critical skills required for this position
  • Ability to write and maintain high quality documentation
  • Demonstrated experience supporting an Exadata environment










EEO Employer

Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or 844-463-6178.