Oracle DBA at mGage, a Vivial Company (Minneapolis, MN)

Summary:

Assist DBA Team with all functions and tasks of the DBA group. This will include assisting with creation and maintenance of all databases for development, QA, and production. Assist with general database administration and performance tuning as required. Monitor, troubleshoot, and resolve all necessary alerts.

  

  ESSENTIAL FUNCTIONS AND RESPONSIBILITIES

• Possess and grow fundamental database administration skill of Oracle RDBMS and related tools.
  
• Update and maintain Oracle databases supporting multiple development and implementation projects.
  
• Implements solutions by using standard methods, automation, and tools.
  
• Maintain cross team relationships and assist teams with database object and SQL query design.
  
• General DBA activities including installing, sizing, implementing, maintaining, and tuning of Oracle database servers.
  
• Backup and recovery operations for both production and non-production database environments utilizing RMAN.
  
• Manage and deploy application database modifications.
  
• Manage and apply Oracle patches.
  
• Maintain and document, existing and new, processes and procedures.
  
• Audit database maintenance activities.
  
• Provide 24x7 on-call support within a team rotation.
  
• Other job duties as assigned.
  

REQUIRED KNOWLEDGE:

• SQL and PL/SQL programming.
  
• Database and SQL performance tuning.
  
• Knowledge of RAC, RMAN, ASM, Data Guard, Oracle 11G and 12c, Linux, Scripting.
  
• Knowledge of database physical and logical design principals.
  
• Strong organization skills and attention to detail.
  
• Strong communication (verbal and written), and interpersonal skills.
  
• Strong problem solving and technical troubleshooting skills.
  

EXPERIENCE REQUIRED:

• 3+ years experience with Oracle
  
• Experience with Oracle RAC, ASM, Data Guard a strong plus
  
• Experience with Postgres, MySQL, and AWS a strong plus
  
• Experience with basic administration and scripting on Linux
  
• Programming experience including PL/SQL, SQL, SQL*PLUS, ksh, bash, etc
  
• Production environment experience of at least 2 years supporting multiple 7x24 database systems
  
• Experience working within strong change management systems as they apply to ALL database changes
  

• Bachelor's degree in Computer Science or related field
  

SKILLS/ABILITIES:                

• Excellent communication skills are required, both written and oral.
  
• Ability to work independently and as part of a team.
  
• Ability to self-direct and prioritize.
  
• Ability to follow oral and written direction.
  
• Ability to solve problems.
  
• Ability to learn new concepts and skills and put them into use.   
  

A few points about why its great to work at mGage:

• Outstanding benefits including major medical, dental and vision
• Matching 401k with immediate vesting and an excellent PTO program

• State of the art office and technology
• Fun and Casual work environment

by via developer jobs - Stack Overflow