Professional Solutions Delivered - Dayton, OH
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, which is essential 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 architect will also coordinate with the Project Manager and customer to “freeze” release updates to Development, Quality Assurance, and production environments one-by-one, ensuring that all changes are managed effectively. The role includes migrating approximately 12 RHEL 8 databases/applications to Oracle, developing and directing a cohesive strategy for Oracle database architecture across the organization, and ensuring that it supports 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. In this role, 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 key responsibilities 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. The architect will also be responsible for planning and testing disaster recovery procedures to guarantee business continuity under all circumstances, establishing encryption, auditing, and access control strategies to protect data integrity. They 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 conducted 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.