Oracle Database Architect

$165,000 - $205,000/Yr

Professional Solutions Delivered - Pleasanton, CA

posted 4 months ago

Full-time
Pleasanton, CA
Professional, Scientific, and Technical Services

About the position

Professional Solutions Delivered, LLC (ProSoDel) is seeking an experienced Oracle Database Architect to join our team in Pleasanton, CA. This role is critical in supporting our Oracle/Linux Opportunity, where you will be responsible for overseeing the architecture and management of Oracle databases across the organization. The ideal candidate will have a strong background in Oracle database technologies and a proven track record of successful database migrations and implementations. In this position, you will coordinate with the Project Manager, customers, and Oracle to obtain un-distributed release patches for RHEL 7 & 8. You will be tasked with migrating approximately 75 Oracle Databases from RHEL 6 to Oracle Enterprise 8, as well as migrating 25-30 web applications from RHEL 7 to Oracle Enterprise 8. This migration is essential to reduce operational impact and ensure a smooth transition to the new environment. You will also be responsible for freezing release updates to development, QA, and production environments, ensuring that changes are managed effectively. As the Oracle Database Architect, you will develop and direct a cohesive strategy for database architecture that aligns with the organization's goals and innovation initiatives. You will lead the evaluation and integration of emerging database technologies, design scalable and reliable database architectures, and oversee the implementation of these architectures in collaboration with database administrators and IT project teams. Your role will also involve performance tuning, query optimization, and implementing advanced techniques for data partitioning and indexing. You will architect solutions for high availability and disaster recovery, ensuring minimal downtime and data loss, and establish strategies for data protection and integrity. Additionally, you will mentor other database architects and administrators, lead cross-functional teams in database projects, and engage with senior management to align database strategies with business objectives. Your expertise will be crucial in conducting capacity planning, implementing strategies for cloud expansion, and optimizing resources. You will also be responsible for developing comprehensive documentation for database architectures and policies, ensuring best practices are adopted throughout the organization. This position requires a proactive approach to staying abreast of developments in Oracle technologies and database management, as well as leading research into novel techniques that can provide competitive advantages. You will spearhead pilot projects to assess new database solutions and their feasibility, contributing to the overall success of the organization.

Responsibilities

  • Coordinate with Project Manager, customer, and Oracle to obtain un-distributed release patches for RHEL 7 & 8.
  • Migrate approximately 75 Oracle Databases on RHEL 6 to Oracle Enterprise 8 before migration to Oracle.
  • Migrate approximately 25-30 web applications from RHEL 7 to Oracle Enterprise 8 before migration to Oracle.
  • Freeze release updates to Dev, QA, and production environments one-by-one in coordination with Project Manager and customer.
  • Migrate approximately 12 RHEL 8 databases/applications to Oracle.
  • Develop and direct a cohesive strategy for Oracle database architecture across the organization.
  • Lead the evaluation and strategic integration of emerging database technologies and capabilities.
  • Design advanced, reliable, and scalable database architectures that address complex business requirements.
  • Oversee the implementation of new database architectures, working closely with database administrators and IT project teams.
  • Lead efforts in performance tuning, query optimization, and system scaling.
  • Implement advanced techniques for data partitioning, indexing, and application of Oracle optimization tools.
  • Architect solutions for high availability and disaster recovery in an Oracle Enterprise environment.
  • Plan and test disaster recovery procedures to guarantee business continuity.
  • Establish encryption, auditing, and access control strategies to protect data integrity.
  • Lead the development of conceptual, logical, and physical data models.
  • Guide the integration of Oracle databases with other data sources and applications.
  • Conduct advanced capacity planning to forecast future database needs.
  • Implement strategies for database sharding, cloud expansion, and resource optimization.
  • Serve as a mentor to database architects and administrators.
  • Lead cross-functional teams in the successful execution of database projects.
  • Evaluate and recommend database tools, software, and services.
  • Stay abreast of developments in Oracle technologies and database management fields.
  • Develop comprehensive documentation for database architectures, policies, and procedures.
  • Establish and maintain database architecture best practices.
  • Engage with senior management and stakeholders to align database strategies with business objectives.
  • Participate in strategic planning sessions, offering insights on database technologies.
  • Lead research into novel database techniques and technologies.

Requirements

  • Bachelor's degree or higher in a relevant field.
  • Must have an Oracle Certification.
  • Possess an active DoD Approved 8570 IAT Level II or above Certification.
  • 12-15 years of experience in database architecture and management.
  • 8 to 10 years of work experience in Oracle database technologies.
  • Experience in capacity planning, designing, and implementing enterprise solutions using Oracle Database Technology.
  • Experience in Oracle Database Administration 12C, 18c, 19c.
  • DB Architecture experience in Oracle 12c, 18c, 19c.
  • Experience migrating from RHEL (6/7) to Oracle Enterprise 8.
  • Experience installing, configuring, and maintaining Oracle databases and application servers.
  • Familiarity with DISA STIGs, NIST SP800-53.x requirements, and conducting DoD vulnerability/compliance assessments.
  • US citizen with active DoD Secret (T3) clearance.

Nice-to-haves

  • Master's degree in a relevant field.
  • Oracle database administrator level 1 or level 2 Certification.
  • Oracle Web Logics Server Certification.
  • Oracle Linux 8 Administration Certification.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service