Professional Solutions Delivered - College Station, TX
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 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 approximately 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 it supports the customer's goals and innovation initiatives. This includes leading the evaluation and strategic integration of emerging database technologies and capabilities to keep the organizational data management practices ahead of industry trends. The Oracle Database 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. Conducting advanced capacity planning to accurately forecast future database needs and ensure scalability to meet growth and performance targets will be part of the role, along with implementing strategies for database sharding, cloud expansion, and resource optimization. The Oracle Database Architect will serve as a mentor to database architects and administrators, promoting best practices and continuous learning. They will lead cross-functional teams in the successful execution of database projects, fostering collaboration and innovation. Evaluating and recommending database tools, software, and services, overseeing vendor selection and contract negotiations to ensure beneficial agreements will also be part of the responsibilities. Staying abreast of developments in Oracle technologies and broader database management fields, assessing their applicability to organizational needs, and developing comprehensive documentation for database architectures, policies, and procedures will be essential tasks. The architect will establish and maintain database architecture best practices, ensuring they are adopted throughout the organization, and engage with senior management and stakeholders to align database strategies with business objectives, communicating complex concepts in understandable terms. Participation in strategic planning sessions, offering insights on database technologies and data management trends, and leading research into novel database techniques and technologies that can offer competitive advantages or operational improvements will round out the responsibilities of this role.