Professional Solutions Delivered - Camp Pendleton North, CA
posted 4 months ago
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. The Oracle Database Architect will play a critical role in coordinating with the Project Manager, customer, and Oracle to obtain un-distributed (retired) release patches for RHEL 7 & 8. This position is responsible for migrating approximately 75 Oracle Databases on RHEL 6 to Oracle Enterprise 8 before migration to Oracle, aiming to reduce operational impact. Additionally, the architect will oversee the migration of around 25-30 web applications from RHEL 7 to Oracle Enterprise 8, ensuring a smooth transition and minimal disruption to services. The role requires the architect to coordinate with the Project Manager and customer to “freeze” release updates to Development, Quality Assurance, and production environments one-by-one. The architect will also be responsible for migrating about 12 RHEL 8 databases/applications to Oracle. A key responsibility will be to develop and direct a cohesive strategy for Oracle database architecture across the organization, ensuring alignment with the customer's goals and innovation initiatives. The architect will lead the evaluation and strategic integration of emerging database technologies and capabilities to keep the organizational data management practices ahead of industry trends. The architect will design advanced, reliable, and scalable database architectures that address complex business requirements while optimizing performance and ensuring data security and compliance. They 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 essential to ensure the database infrastructure operates efficiently under varying loads. The architect will implement advanced techniques for data partitioning, indexing, and application of Oracle optimization tools, as well as architect solutions for high availability and disaster recovery in an Oracle Enterprise environment, ensuring minimal downtime and data loss. In addition, the architect will plan and test disaster recovery procedures to guarantee business continuity under all circumstances. Establishing encryption, auditing, and access control strategies to protect data integrity will also be a priority. The architect will lead the development of conceptual, logical, and physical data models that accurately reflect business data needs and guide the integration of Oracle databases with other data sources and applications across the enterprise, ensuring seamless data flows and consistency. Advanced capacity planning will be necessary to accurately forecast future database needs and ensure scalability to meet growth and performance targets. The architect will implement strategies for database sharding, cloud expansion, and resource optimization, serving as a mentor to database architects and administrators, promoting best practices and continuous learning.