Oracle Database Architect

$165,000 - $205,000/Yr

Professional Solutions Delivered - Albany, GA

posted 21 days ago

Full-time
Onsite - Albany, GA
Professional, Scientific, and Technical Services

About the position

As an Oracle Database Architect at Professional Solutions Delivered, LLC (ProSoDel), you will play a pivotal role in supporting our Oracle/Linux initiatives. This position requires a seasoned professional with extensive experience in Oracle database technologies and a strong understanding of enterprise solutions. You will be responsible for coordinating with project managers, customers, and Oracle to obtain necessary release patches for RHEL 7 & 8, ensuring that our systems are up-to-date and secure. Your primary focus will be on migrating approximately 75 Oracle databases from RHEL 6 to Oracle Enterprise 8, as well as transitioning around 25-30 web applications from RHEL 7 to Oracle Enterprise 8. This migration is crucial to minimize operational impact and enhance system performance. In addition to migration tasks, you will develop and direct a cohesive strategy for Oracle database architecture across the organization. This involves designing advanced, reliable, and scalable database architectures that meet complex business requirements while optimizing performance and ensuring data security and compliance. You will lead efforts in performance tuning, query optimization, and system scaling, ensuring that our database infrastructure operates efficiently under varying loads. Your expertise will also be essential in architecting solutions for high availability and disaster recovery, planning and testing disaster recovery procedures to guarantee business continuity. You will be responsible for establishing encryption, auditing, and access control strategies to protect data integrity, as well as guiding the integration of Oracle databases with other data sources and applications across the enterprise. Conducting advanced capacity planning to forecast future database needs and implementing strategies for database sharding and cloud expansion will also be part of your responsibilities. As a mentor to database architects and administrators, you will promote best practices and continuous learning within the team. Your role will require you to engage with senior management and stakeholders to align database strategies with business objectives, ensuring that complex concepts are communicated in understandable terms. You will also participate in strategic planning sessions, offering insights on database technologies and data management trends, and lead research into novel database techniques that can provide competitive advantages or operational improvements.

Responsibilities

  • Coordinate with Project Manager, customer, and Oracle to obtain un-distributed (retired) 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.
  • Coordinate with Project Manager and customer to freeze release updates to Dev, QA, and production environments one-by-one.
  • 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 broader 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.
  • Must have an Oracle Certification.
  • Possess an active DoD Approved 8570 IAT Level II or above Certification.
  • 12-15 years of experience in relevant fields.
  • 8 to 10 years of work experience in Oracle database technologies.
  • Experience in capacity planning, designing, and implementation of 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 experience in conducting DoD vulnerability/compliance assessments.
  • US citizen with active DoD Secret (T3) clearance.

Nice-to-haves

  • Master's degree.
  • 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