Oracle DBA/Dev

Location: Irvine
Posted on: November 20, 2024

Job Description:

 
Job Description:
 
Oracle DBA-08653
Description
• 7+ years of in-depth Oracle DB and other database design and administration across a multi-platform UNIX/NT environment.
• Application implementation and installation in an online environment of Oracle R12/ 11i with demonstrated competency in execution of multiple projects to meet goals
• Support for Oracle VCP Module(s) – Demantra and ASCP is highly desired
• Minimum of 5 years of project management or technical responsibility through various project in multidiscipline, high-performance work teams and development groups
• 3+ years of experience in successfully developed and implemented applications in new computing environment, using new and emerging technologies
• Plans and manages all technical and functional tasks associated with database administration, including creating, maintaining, and monitoring databases; performance tuning analysis; capacity planning; workload modeling and prediction; systems support; long-term strategic planning; application support and optimization; problem resolution tracking; and software upgrades.
• Assesses customer requirements; analyzes the architecture of business events and databases that support the architecture; evaluates possible solutions; and presents recommendations to IT management
• Performs software installation and configuration, including upgrades and applying patches
• Works closely with Business Solutions teams, developers, Systems Administrators and peers in other areas of IT
• Ensure backups are successful and restore processes are known and tested
• Ensures that databases supporting application systems are developed in a way that complies with architectural standards and established methodologies and practices
• Monitors and reports to IT management and user the status of multiple concurrent project efforts
• Anticipates and identifies issues inhibiting the attainment of project goals; develop and implement corrective actions
• Provides 24/7 on-call support as needed
• Develops project resource strategies, allocating budget, staff,  tools, and specialized support necessary for cost-effective implementation and support of project efforts
• Has sufficient experience and expertise to perform multiple tasks/assignments of a medium to complex level. General supervision and little guidance.
• Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors. Exercises judgment in selecting methods, techniques and evaluation criteria for obtaining results.
• Excellent research and trouble shooting skills and experience in Oracle Applications R12 and 11i for EBS and VCP
• Conceptual knowledge of information technologies and methodologies in a multi-platform environment is desirable
• Experience in scheduling and performance of regular database maintenance such as cloning, rebuilding indexes, table space reorganization, and data file additions
• Experience in implementation, maintenance and monitoring of database backups and recovery, enforcing proper policies and procedures
• Knowledge of High Availability Clustered Multiprocessing functionality
• Experience in effectively managing projects in a cross-functional environment against critical deadlines
• Excellent communications skills and strong customer focus
• Must be able to plan, coordinate and execute multiple projects and deadlines
• Strong technical knowledge, with hands-on experience managing systems development in client server/web architectures and environments; knowledge MS Office, Windows, SQL Server, Oracle ERP (11i), and Oracle tools is critical
• Adapt quickly to rapidly changing technology and apply it to business needs
• Ability to define problems, collect data, establish facts, and draw valid conclusions.
• Able to interpret an extensive variety of technical instructions in mathematical or diagram form
• Strong ability to develop and maintain effective working relationships with others who may have ongoing competing priorities and viewpoints
Qualifications
• Application implementation and installation in an online environment of Oracle R12/ 11i with demonstrated competency in execution of multiple projects to meet goals
• Support for Oracle VCP Module(s) – Demantra and ASCP is highly desired
• Solid understanding of relational database management systems, client/server programming and distributed databases
• Experience in database design, server and application products configuration, and patch installations
• Full knowledge of SQL, and stored procedures, including programming, tuning and optimization, and Unix Shell scripts
• Solid knowledge and experience in areas of database monitoring through scripts and tools, database optimization, database migration, DDL management, backup and recovery, scheduling packages, and related RDBMS-specific tools and utilities, e.g. Appworx, Oracle Enterprise Manager, etc.
Job Discipline Information Technology (IT) & Support Services
Primary LocationUS-California-Irvine
Schedule Full-tim
 
 
 

Keywords: , Camarillo , Oracle DBA/Dev, IT / Software / Systems , Irvine, California