|
Search Jobvertise Jobs
| |
Jobvertise
|
Remote Oracle Database Administrator
Location: US-CA-Los Angeles
Email this job to a friend
Report this Job
Minimum Qualifications: - The proposed candidate must have a minimum of 8 years of experience in the design, development, modification, improvement, and implementation of Oracle relational database management systems that includes access methods, definition languages, and remote access software in an installation utilizing third-generation systems that support batch, remote access, database, and real time applications.
- The proposed candidate must possess 8 years of experience with Oracle databases on both physical and logical servers, data security, development of plans for the conversion of existing physical servers to virtual servers, database recovery and backup techniques, and optimized processing techniques also is required.
- Experience in implementation of full version oracle database upgrade (i.e. 12c to 19c) a minimum of 2 times within the last 8 years.
GENERAL
The Los Angeles Unified School District (LAUSD) seeks a qualified proposer to provide implementation services for Oracles databases which requires essential upgrades, rebuilding, and replication of Oracle databases.
DESIRABLE QUALIFICATIONS - Extensive background in providing comprehensive support for Oracle 19c databases.
- Proven experience in executing successful upgrades of Oracle databases to version 19c or higher. (12c to 19c upgrade experience preferred)
- Proficiency in replicating and/or migrating Oracle databases to the Cloud (preference for onpremise to VMware's Cloud Disaster Recovery (VCDR) environment.
- Skilled in providing adept database and application connectivity in support for Testing of applications both on-premise and in the VCDR environment.
- Experience in providing guidance and assistance during integrated run-for-record and other exercises.
- Adept understanding of business and educational data processing applications.
- Proficiency in various higher-level programming languages, including but not limited to MS SQL, SQL, PL/SQL, and Python.
- Comprehensive knowledge of Cloud-based Infrastructure architecture, preference or VMware on AWS also including Amazon AWS, Microsoft Azure, Google Cloud and Oracle Cloud Services
- Understanding of Platform as a Service (PaaS), Infrastructure as a Service (IaaS), Software as a Service (SaaS), and other related cloud technologies.
- Extensive experience in Hybrid-cloud, cloud migrations, and database migrations.
- Advanced knowledge of database backup, restore, and disaster recovery methodologies and technologies (familiarity with Google Actifio is a plus).
- Proficiency in performance tuning methodologies and technologies.
- Understanding of Oracle Clustered Database Configurations (Oracle RAC) as well as SQL SERVER Failover Cluster Manager (FCM), SQL SERVER "Always on"
- Understanding of Oracle Data Guard and Oracle GoldenGate for replicating data bases, the difference between the products, ability to select the more appropriate tool
- Thorough understanding of the principles and techniques of database administration and programming.
- Experience in the replication and/or migration of Oracle databases between 2 sites (Physical Site to Physical Site, Physical Site to Cloud and Cloud to Physical Site)
SCOPE OF SERVICES - The chosen candidate will collaborate closely with LAUSD / ITS Staff and the project team to undertake the following responsibilities:
- Convert the Oracle RAC (Cluster database) to a single node Oracle Database instance.
- Migrate Oracle Databases from physical servers to Virtual Machines (VMs).
- Aid in the development of Recovery Plans for each Protection Group, detailing the necessary steps to activate the Oracle DB in the VCDR Cloud environment and ensure connectivity with associated application(s).
- Coordinate with the Application Teams to capture and/or document the mappings of App server OO the applications connected to each Database/Database Server.
- Support ITS Applications Administrators with the creation of Test Plans.- providing all necessary steps to connect database server in the Cloud or on Premise
- Execute Recovery Plans for Unit and Integration Testing, managing the steps to recover the Oracle databases and establish connections with the applications, while documenting any additional essential steps in the RunBook for the protection groups.
- Assist with the Configuration of additional computer servers for integration testing in the VCDR environment.
- Release Oracle servers at the conclusion of the testing window back to the cloud provider.
- Establish and implement database backup procedures to be activated in the event of a real failover to the VCDR environment.
- Resolve issues and present viable solutions to L.A.U.S.D. Participate in Lessons Learned exercises.
- Facilitate knowledge transfer and transition tasks to LAUSD staff for the Operations & Maintenance (O&M) of the Oracle Databases in the VCDR Solution.
- Aid in the planning for the migration of the Oracle database servers from the current (onpremises) data centers to the new Co-location data center.
SOFTHQ INC
|
