Job Description

Contract job Position!

Job Title: Oracle DBA

Work Location: Irvine, CA or Los Angeles, CA

Job Overview:

We are seeking an experienced Oracle Database Administrator to oversee and manage our company’s Oracle database system. The role includes installing and maintaining database software, creating storage structures, managing user accounts, troubleshooting issues, performing regular backups, and ensuring robust database security.

To excel in this role, you should have a deep understanding of front-end and back-end DBA tools, strong problem-solving capabilities, and hands-on experience with Oracle database management. A successful Oracle DBA will ensure the smooth operation and optimization of the database system to maximize efficiency and performance.

Roles and Responsibilities:

• Install, configure, and maintain Oracle database environments.
• Design and implement database backup solutions and disaster recovery strategies.
• Enhance database performance by fine-tuning configuration settings.
• Diagnose and resolve database issues, contributing to system improvements.
• Develop, implement, and enforce database security measures to ensure data protection.
• Collaborate with teams to ensure database operations and data integrity.
• Deploy new database technologies and solutions as required.
• Maintain reports, dashboards, and visualizations for data workflows.
• Work directly with clients to understand requirements and provide technical guidance on database architecture and specifications.
• Assess the suitability of data for storage and design optimal storage strategies.
• Create and integrate complex database systems for both internal and external stakeholders.
• Define, document, and enforce database standards and models to optimize capacity and performance.
• Develop and execute test code in client-server environments to ensure software adheres to standards.
• Stay updated on emerging technologies and tools to improve database administration practices.
• Minimize database downtime, manage performance parameters, and ensure fast query responses.
• Collaborate with internal and external teams to meet Service Level Agreements (SLAs) and operational performance metrics, especially during critical events.
   

Requirements and Skills:

• Expertise in SQL and SQL server tools.
• Advanced knowledge of database security, backup, recovery, and performance monitoring.
• Proficiency in relational and dimensional data modeling.
• Strong skills in PowerShell and Unix shell scripting.
• High attention to detail, with excellent mathematical and statistical abilities.
• Strong written and verbal communication skills.
• Bachelor’s degree in IT or a related field.
• Knowledge of Linux and Windows Server infrastructure.
• Comprehensive understanding of database technologies (e.g., MySQL, MS SQL, PostgreSQL, Oracle, MongoDB).
• Must possess or be eligible for a DoD Secret Clearance with SSBI.
• Familiarity with Oracle Real Application Clusters (RAC), ASM, and Active Data Guard.
• Prior experience with DBA tools (frontend and backend) and third-party database management tools.
• Thorough understanding of database standards and end-user applications, with the ability to translate capacity needs into infrastructure deployment solutions.
   

Desired Experience for Oracle Database Administrator:

• Proficiency in learning and adapting to a wide range of new technologies.
• Strong foundation in various IT domains and practices.
• Keen interest in maintaining thorough documentation.
• Commitment to following and promoting best practices.
• Experience working with other relational database management systems such as PostgreSQL, Vertica, and MySQL.
• Previous experience in the retail industry is an advantage.
   

Qualifications for Oracle Database Administrator:

• Proven experience with Oracle Database Administration for versions 10g and higher on both Unix and Windows platforms.
• Hands-on expertise in developing and implementing business continuity and disaster recovery strategies.
• Experience with configuring Oracle Enterprise Manager (OEM), Grid Control, and generating Statspack reports.
• At least 3+ years of experience leading a team of five or more members, with the ability to provide status updates to senior management.
• Ability to lead the team and provide technical guidance and solutions.
• Proficiency in performance tuning and optimization of Oracle database servers.