Oracle Database Administrator Jobs

Oracle Database Administrator

General Characteristics

Manages and maintains all production and non-production databases. Responsible for standards and design of physical data storage, maintenance, access and security administration. Performs backup and recovery on Database Management Systems, configures database parameters, and prototype designs against logical data models, defines data repository requirements, data dictionaries and warehousing requirements. This position optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.

Dimensions Education:

Bachelor’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.

Experience:

• Ten years of experience in database administration, information technology, database architecture or a related field

• Experience with Linux and Solaris Server environments

• Extensive experience with SQL and PL/SQL

• Extensive hands-on experience with Oracle database management

• Familiarity with Oracle database design, coding and documentation

• Experience with database backup and recovery procedures

Complexity:

Intermediate professional level role. Supports multiple services and multiple databases of medium to high complexity (complexity defined by database size, technology used, multiple different systems and interfaces) with multiple concurrent users, ensuring control, integrity and accessibility of data. Works on multiple projects as a project leader or sometimes as a project advisor. May coach more junior technical staff.

Database Administrator Job Responsibilities:

• Install and maintain the performance of database servers.

• Develop processes for optimizing database security.

• Set and maintain database standards.

• Manage database access.

• Performance tuning of database systems.

• Install, upgrade, patching, and manage database applications.

• Diagnose and troubleshoot database errors.

• Engages with development teams throughout the software life cycle ensuring sustainable software releases and monitor application performance with the database

• Recommend and implement emerging database technologies.

• Create and manage database reports, visualizations, and dashboards.

• Capacity Planning

• Database reorganization planning

• Performance Tuning --Job #1440 Variance: Advanced

• Be available for on-call support as needed.

Database Administrator Qualifications/Skills:

• Advanced knowledge of database security, backup and recovery, and performance monitoring standards

• Understanding of relational and dimensional data modeling

• Unix shell scripting skills

• Strong mathematical and statistical knowledge

• Excellent written and verbal communication skills

• Impeccable attention to detail

Desired Skills

• Goldengate experience a plus

• Azure synapse experience a plusKnowledge, Skills, and Abilities: