Senior Oracle DBA - Performance Expert

<h3>Company Description</h3><p>Founded in 2015, BPCE Infogérance &amp; Technologies is a subsidiary of Groupe BPCE, dedicated to Infrastructures, End-User Environment, Security and Production. Driven by growth, expertise, transformation and agility, this project embraces an international mindset and a diverse skill set. You’ll find yourself in a dynamic and enriching workplace or, as we like to name it, a real tech playground, where you’ll be able to explore a huge tech stack.</p><h3>Job Description</h3><p>The<strong> Database Infrastructure Expert </strong>designs, deploys, standardizes and maintains the foundations and services of Databases solutions on-premises systems and in the cloud.</p><p>Manages technical infrastructure projects and contribute to business projects. On a day-to-day basis, he performs on-demand work on these environments, which he will optimize considering performance, capacity and costs. He guarantees the quality of service and solutions in all technical environments and the control of operational risk. He ensures and develops the expertise of its field. He can also be asked to support business projects in his area of expertise.</p><p>As a <strong>Database Infrastructure Expert,</strong> you will be responsible for:</p><ul><li>Industrialize and Automate (IaaC) all SGBD infrastructure management processes and actions to optimize the costs and processing times of these actions in a rapidly increasing scope</li><li>Bring added value to internal and external customers through the provision of new services (As a Service) dedicated DBMS</li></ul><p>The <strong>Database Infrastructure Engineer</strong> monitors, designs, deploys, and maintains the databases infrastructure regarding the hardware and software. He optimizes these environments by considering the performance, capacity, and costs. He also guarantees the quality of service and the control of operational risk. He should also support all the projects in his area of expertise.</p><p>As a <strong>Database Infrastructure Engineer</strong> you will be responsible for:</p><ul><li>Industrially migrate the database environments of business applications as part of the SGBD Migration Factory to remove obsolescence from SGBD environments,</li><li>Reduce operational risks and contribute to functionally enriching processes,</li><li>SGBD Migration Factory tools and solutions</li></ul><p><strong>Studies and Controls:</strong></p><ul><li>Define standard technical services and solutions and their respective sizing</li><li>Develop detailed configuration specifications</li><li>Define standards for the use and operation of DBMS</li><li>Contribute to the development of technical solutions for the catalogue and architecture patterns of DBMS solutions.</li><li>Publish, present and explain those solutions and their associated SLAs</li><li>Contribute to the development and maintenance of the Infrastructure Evolution Plan</li><li>Develop, industrialize and automate deployment models (IaaC) for:  <ul><li>all processes and actions for managing DBMS infrastructure components</li><li>all DBMS services in the form of "As a Service" to add value to internal and external customers</li></ul></li><li>Monitor and control versions of existing databases and software packages selected by the company</li><li>Ensure and guarantee the integrity of the infrastructure bases of the existing databases by guaranteeing physical security (backup procedures, restoration, logging, start-up after incidents, etc.) and logic (confidentiality, access)</li><li>Adjust database settings for optimal use.</li><li>Ensure technological monitoring of the DBMS solutions and software packages selected by the company</li></ul><p><strong>Prototyping and qualification of technical solutions for internal company standards</strong></p><ul><li>Build models and prototypes</li><li>Perform conformity and approval tests (technical and functional)</li><li>Write evaluation and functional reports</li><li>Validate solutions to make them the corporate standards</li></ul><p><strong>Audit and Recommendations</strong></p><p>Perform:</p><ul><li>Architecture audits<ul><li>Architecture performance studies and analysis</li><li>Databases’ tuning</li><li>Support production teams and/or publishers on escalated issues</li></ul></li></ul><p><strong>Contribution to Business Projects</strong></p><ul><li>Define, approve and validate technical architectures</li><li>Advise users - Develop recommendations for business projects</li><li>Participate in data migration projects</li><li>Industrially migrate the database environments of business applications as part of the SGBD Migration Factory to remove obsolescence from SGBD environments, reduce operational risks and contribute to functionally enriching processes, SGBD Migration Factory tools and solutions</li><li>Create, at request of the domains or the exploitation or in anticipation of the needs, the specific tools of assistance to the exploitation</li></ul><p><strong>Contributi