Andersen Windows & Doors - Careers

Oracle Database Administrator - (22193)

Share this Job:
Apply Online    
Description
An Oracle Database Administrator is responsible for the design, creation, configuration, upgrades, administration, monitoring, performance tuning, backup and maintenance of databases in the organization.  They analyze, test, and implement physical database design and automation supporting various business applications.  They ensure data recovery, data maintenance, data integrity, and space requirements for physical databases are met through policies, procedures and standards relating to database management.  They provide excellent coordination between the user, technical representative, application administrator, and other entities to ensure effective data management. This individual will assist with planning and reliably implement security measures to safeguard the databases according to department standards.
An Oracle Database Administrator will also assist in developing database strategies, monitoring processes, improving database performance and capacity planning for future expansion requirements.  May participate and contribute to architectural decisions. They develop system testing strategies, monitor testing efforts; test complex operating environments and database management systems in compliance with department standards.  This position will also assist with the analysis of complex technical system problems, design and implement effective solutions.  This position is expected to work closely with external service partners to plan and coordinate activities, either project-related or managed services, as necessary.
 
Responsibilities:
  • Provide first-level application support: Resolve problems and answer questions related to the Oracle RDBMS and platform environment; contact vendor support when necessary; facilitate application development and client problem resolution with optimum speed and efficiency
  • Identify and implement team operational efficiencies by automation & process improvements opportunities and / or implementing new technologies.
  • Oracle RDBMS performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency
  • Maintain database backup/recovery environment: Respond quickly to refresh data; verify implementation of correct backup strategy, develop recovery procedures; support recovery from loss of data caused by user or system error
  • Install and upgrade Oracle RDBMS and related products: Keep Oracle RDBMS at current release and maintenance levels; provide current & stable production and development environments
  • Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or de-fragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance
  • Perform database refreshes upon request: refresh data from one environment to another at the request of the application development staff, execute necessary tasks to accomplish this, to minimize impact provide application development staff optimal development environment with current data
  • Provide assistance in database design as needed: Research and recommend optimal design criteria; publish standards and work with development staff standardize environment and improve efficiency
  • Experience working closely with a matrix team consisting of employees, contractors, and vendors with various skills and disciplines
  • Ensure database availability, performance, and supportability can meet application requirements.  Ability to work with application groups to determine those requirements.
  • Performance tuning experience including performance issue identification and tuning.
  • Tier 2/3 troubleshooting.  When technical issues are escalated internally, you are able to work until resolution.
  • Clearly articulate requirements, issues, project status, etc. to non-technical management personnel.
  • Identify and communicate licensing, sizing, upgrades, etc. requirements to technology vendors
  • Standard DBA tasks – installation, space management, backup & recovery, patching, upgrades, etc. within Oracle environments.
  • Participate in 24/7 on-call rotation.
  • Mentoring of junior Database Administrators
  • Assist with developing and maintaining a DBA technical roadmap including proposals for financial capital planning
  • Writes and maintain documentation for standard procedures
Qualifications
  • Bachelor degree in computer science, mathematics or similar discipline.
  • Oracle Certified Professional DBA in Oracle Database 11g or 12c
  • 5-8 years of RDBMS experience (Oracle databases)
  • Experience required with all of the following…
    • Oracle Database 11g Release 2
    • Oracle Database 12c Release 1
    • Oracle Data Guard Physical Standby
    • Oracle Grid Infrastructure specifically Automatic Storage Management (ASM)
    • Oracle Recovery Manager (RMAN)
    • Oracle SQL & PL/SQL
    • Oracle Database Software Installation, Upgrade and Patching within the OFA framework
    • Oracle Database Restore, Recovery and Migration
    • Oracle Grid/Cloud Control
    • Basic UNIX/Linux system administration
    • Basic scripting skills (Bourne Shell, Korn Shell and Bash Shell)
  • Desired experience with the following…
    • Oracle VM
    • Oracle Application Express (APEX)
    • Oracle Database Restore, Recovery and Migration
    • Oracle Security Practices
    • Quest SharePlex
    • Exposure to other database technologies, e.g. Microsoft SQL Server
  • Cloud service experience a plus
  • Highly independent and motivated worker
  • Strong interpersonal skills; ability to work with cross-functional teams and within a matrixed organization.
  • Strong verbal and written communication skills
  • Strong analytical and problem-solving skills
  • Ability to handle multiple simultaneous projects with aggressive deadlines
  • Ability to troubleshoot issues using My Oracle Support and other online resources
  • Familiarity with data modeling and data mining
  • Have a general understanding of database hardware design, including disk subsystems
  • Good knowledge of Database replication technologies
  • Good knowledge of structured Query Language
Job:
Information Technology
Location:
Oak Park Heights, MN US
Organization:
Andersen Corporation
Apply Online    
Join Our Talent Community