Oracle Database Architect

Professional Solutions Delivered, LLC (ProSoDel) is a total solutions provider for government and commercial customers in the areas of Program Management, Logistics, Organizational Change Management, Communications, Training, and Information Technology (IT) Support Services. We are currently seeking an Oracle Database Architect to join our team of professionals in support of the Oracle/Linux Opportunity.
Essential Duties & Job Functions:

• Coordinate with Project Manager, customer, and Oracle to obtain un-distributed (retired) release patches for RHEL 7 & 8.
• Responsible for migrating ~75 Oracle Databases on RHEL 6 to Oracle Enterprise 8 before migration to Oracle, to reduce operational impact.
• Responsible for migrating ~25-30 web applications from RHEL 7 to Oracle Enterprise 8 before migration to Oracle, to reduce operational impact.
• 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, ensuring it supports the customer's goals and innovation initiatives.
• Lead the evaluation and strategic integration of emerging database technologies and capabilities to keep the organizational data management practices ahead of industry trends.
• Design advanced, reliable, and scalable database architectures that address complex business requirements while optimizing performance and ensuring data security and compliance.
• 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 to ensure the database infrastructure operates efficiently under varying loads.
• 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, ensuring minimal downtime and data loss.
• Plan and test disaster recovery procedures to guarantee business continuity under all circumstances.
• Establish encryption, auditing, and access control strategies to protect data integrity.
• Lead the development of conceptual, logical, and physical data models that accurately reflect business data needs.
• Guide the integration of Oracle databases with other data sources and applications across the enterprise, ensuring seamless data flows and consistency.
• Conduct advanced capacity planning to accurately forecast future database needs and ensure scalability to meet growth and performance targets.
• Implement strategies for database sharding, cloud expansion, and resource optimization.
• Serve as a mentor to database architects and administrators, promoting best practices and continuous learning.
• Lead cross-functional teams in the successful execution of database projects, fostering collaboration and innovation.
• Evaluate and recommend database tools, software, and services, overseeing vendor selection and contract negotiations to ensure beneficial agreements.
• Stay abreast of developments in Oracle technologies and broader database management fields, assessing their applicability to organizational needs.
• Develop comprehensive documentation for database architectures, policies, and procedures.
• Establish and maintain database architecture best practices, ensuring they are adopted throughout the organization.
• Engage with senior management and stakeholders to align database strategies with business objectives, communicating complex concepts in understandable terms.
• Participate in strategic planning sessions, offering insights on database technologies and data management trends.
• Lead research into novel database techniques and technologies that can offer competitive advantages or operational improvements.
• Spearhead pilot projects to assess the potential impact and feasibility of new database solutions.
• Performs related work as assigned.

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

• Master's degree
• (1) Oracle database administrator level 1 or level 2 Certification.
• (1) Oracle Web Logics Server Certification.
• (1) Oracle Linux 8 Administration Certification