Senior Oracle DBA - Performance Expert Porto

Senior Oracle DBA - Performance Expert
Porto
Porto, Porto District, Portugal

Company Description

Founded in 2015, BPCE Infogérance & 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.

Job Description

The Database Infrastructure Expert designs, deploys, standardizes and maintains the foundations and services of Database solutions
- premises systems and in the cloud.

Manages technical infrastructure projects and contributes to business projects. On a
-
- day basis, he performs
- 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 his field. He can also be asked to support business projects in his area of expertise.

Responsibilities:

• Industrialize and Automate (Iaa
  C) all SGBD infrastructure management processes and actions to optimize the costs and processing times of these actions in a rapidly increasing scope.
• Bring added value to internal and external customers through the provision of new services (As a Service) dedicated to DBMS.

• 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.
• Utilize SGBD Migration Factory tools and solutions.

• Define standard technical services and solutions and their respective sizing.
• Develop detailed configuration specifications.
• Define standards for the use and operation of DBMS.
• Contribute to the development of technical solutions for the catalogue and architecture patterns of DBMS solutions.
• Publish, present and explain those solutions and their associated SLAs.
• Contribute to the development and maintenance of the Infrastructure Evolution Plan.
• Develop, industrialize and automate deployment models (Iaa
  C) for all processes and actions for managing DBMS infrastructure components.
• Ensure the integrity of the infrastructure bases of the existing databases by guaranteeing physical security (backup procedures, restoration, logging,
  - up after incidents, etc. ) and logic (confidentiality, access).
• Adjust database settings for optimal use.
• Ensure technological monitoring of the DBMS solutions and software packages selected by the company.

• Build models and prototypes.
• Perform conformity and approval tests (technical and functional).
• Write evaluation and functional reports.
• Validate solutions to make them the corporate standards.

• Perform architecture audits.
• Conduct architecture performance studies and analysis.
• Tune databases.
• Support production teams and/or publishers on escalated issues.

• Define, approve and validate technical architectures.
• Advise users and develop recommendations for business projects.
• Participate in data migration projects.
• Create specific tools of assistance to the exploitation as requested.

• Define, approve and validate technical architectures.
• Assume the role of project manager for some Database Infrastructure Projects.
• Document, coach, follow, write procedures, perform customer packages, etc.

• Implement automatic monitoring (technical and functional).
• Capacity Planning.
• Management and analysis (AI) tools for directing infrastructure logs of Databases.
• Provide
  - level technical support (L3) for all databases and assist users (training, technical queries, etc. ).

• Contribute to the monitoring and control of investments, maintenance and budget.
• English level B2 / French is a plus.
• Good communication skills.
• Good organizational, analytical and
  - solving skills.
• Autonomous, while capable of working within a team and with other teams and/or experts.
• Fast learner, easy to adapt, team worker.
• Client focus.
• Availability for
  - duty call and punctual trips to France.