Oracle Database Architect

$165,000 - $205,000/Yr

Professional Solutions Delivered - Shreveport, LA

posted 4 months ago

Full-time
Shreveport, LA
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 Shreveport, LA. 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. You will coordinate with project managers, customers, and Oracle to obtain necessary patches and manage the migration of approximately 75 Oracle databases from RHEL 6 to Oracle Enterprise 8, as well as 25-30 web applications from RHEL 7 to Oracle Enterprise 8. Your expertise will help reduce operational impact during these migrations. In this position, you will develop and direct a cohesive strategy for Oracle database architecture that aligns with the customer's goals and innovation initiatives. You will lead the evaluation and integration of emerging database technologies, ensuring that our data management practices remain ahead of industry trends. Your responsibilities will include designing advanced, reliable, and scalable database architectures that meet complex business requirements while optimizing performance and ensuring data security and compliance. You will oversee the implementation of new database architectures, working closely with database administrators and IT project teams. Performance tuning, query optimization, and system scaling will be key areas of focus to ensure efficient database operations. You will also implement advanced techniques for data partitioning, indexing, and utilize Oracle optimization tools to enhance performance. As part of your role, you will architect solutions for high availability and disaster recovery, ensuring minimal downtime and data loss. You will establish encryption, auditing, and access control strategies to protect data integrity and lead the development of conceptual, logical, and physical data models that reflect business data needs. Additionally, you will guide the integration of Oracle databases with other data sources and applications, ensuring seamless data flows and consistency across the enterprise. Your leadership will extend to mentoring database architects and administrators, promoting best practices and continuous learning. You will evaluate and recommend database tools, software, and services, overseeing vendor selection and contract negotiations. Staying abreast of developments in Oracle technologies and database management fields will be essential to assess their applicability to our organizational needs. You will also develop comprehensive documentation for database architectures, policies, and procedures, and engage with senior management to align database strategies with business objectives.

Responsibilities

  • Coordinate with Project Manager, customer, and Oracle to obtain un-distributed (retired) release patches for RHEL 7 & 8.
  • Migrate ~75 Oracle Databases on RHEL 6 to Oracle Enterprise 8 before migration to Oracle.
  • Migrate ~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 ~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.
  • Lead research into novel database techniques and technologies.
  • Spearhead pilot projects to assess the potential impact and feasibility of new database solutions.

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 Oracle database technologies.
  • 8 to 10 years of work experience in Oracle database administration (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