Database Engineer – Oracle Expert
- Full-time
Job 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.
Within BPCE-IT, the mission of the Infrastructure Data entity is to design, deploy and evolve the DATA infrastructures of the information systems to serve the business applications of BPCE-IT customers by guaranteeing safety, quality, performance, the uniqueness, coherence and sustainability of their exploitation.
As part of its growth, the Infrastructure Data entity is looking for experts (senior and intermediate) and engineers (junior) in the Databases area whose main activities are:
- Automation of database patch management and migration on any of the following technologies: Oracle, SQL Server, MySQL, MongoDB, PostgreSQL, EOM, OPS Manager, MEM, …
- Scripting with any of the following tools: shell, powershell, python, ansible, terraform, DSC, …
- Ensure the continuity and reliability of the DATA infrastructures for all information systems of BPCE-IT customers, secure their systems by Patching or Upgrade or Migrate the Database in the appropriate supported version, always guaranteeing the service in compliance with the standards.
- Analyze and forecast patching and migration processes in order to meet the expected calendar goals.
- Contribute to business projects and assist other teams in solving issues (performance, tuning, config, …).
The Database Engineer – Oracle Expert deploys the BPCE Managed Services & Technologies strategy at the department level. He is the SME on Oracle technology for the migration factory automation process.
Missions:
- Understand the remediation strategy and process to succeed in the SI improvement.
- Develop skills on patching and migration topics.
- knows how to deal with patching and migration subjects autonomously.
- Anticipate implement changes in the organization of the activity within the company:
- Propose methods for integrating changes in the activity of the service concerned to promote their consideration.
- Participate to improve the process of Patch Management and Migration Factory teams.
- Appropriate and relay upward and transversal communication.
- Ensure proximity to teammates and managers as part of the deployment of key Company topics (decisions, group info, customer info, etc.) In order to ensure that the hierarchy is aware of any operational difficulties.
- Organize and facilitate daily the activity of his entity and its interactions with the company:
- Contribute to the continuous improvement process.
- Setup automated dashboarding to follow activity and share progress.
- Provide business reporting and forecasting.
Studies and Controls:
- Monitor and control versions of existing databases and software packages selected by the company.
- Develop detailed configuration specifications and sizing.
- Propose 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 (IaaC) for:
- all processes and actions for managing DBMS infrastructure components.
- all DBMS services in the form of "As a Service" to add value to internal and external customers.
- 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).
- Adjust database settings for optimal use.
- Ensure technological monitoring of the DBMS solutions and software packages selected by the company.
Prototyping and qualification of technical solutions for internal company standards
- Perform conformity and approval tests (technical and functional)
- Write evaluation and functional reports.
- Validate solutions to make them the corporate standards.
Audit and Recommendations
- Participate to maintain and perform:
- Architecture performance studies, analysis and audits
- Databases’ tuning
- Support production teams and/or publishers on escalated issues
Contribution to Business Projects
- Propose technical architectures.
- 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.
- Create, on request or by anticipation of needs, specific tools of assistance to the exploitation.
Contribution to IT Development Projects
- Propose technical architectures.
- Document, follow, write procedures, perform customer packages, etc.
Exploitation & Support
- Implement automatic monitoring and follow-up with dashboards (technical and functional)
- Capacity Planning
- Management and analysis (AI) tools for directing infrastructure logs Databases.
- Provide third-level technical support (L3) for all databases and assist users (training, technical queries, etc.)
Qualifications
Main Technical Requirements:
- Subject mater expert on Oracle Databases infrastructure
- Experience on Oracle patch management and major version upgrade
- Shell
The following skills would be a plus:
- Knowledge on other SGBD technologies (SQL Server, MySQL, PostGRE, MongoDB)
- Experience in automation with Ansible
- Python programming
- Powershell scripting
- Experience in development using DevOPs tools (GIT Bitbucket, Confluence, JIRA, Jenkins, XLDeploy to manage CI/CD environments)
Other Requirements:
- English level B2 / French is a plus.
- Good communication skills
- Good organizational, analytical and problem-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 to:
- Punctual trips to France
Additional Information
At Natixis, we are committed to fostering a working environment where each and every one of our people is treated with dignity and respect and where every voice is heard. Our differences make us collectively stronger and are a source of fulfilment, innovation and performance.
In the framework of its Diversity, Equity & Inclusion policy, Natixis in Portugal has implemented a Blind CV Screening process, with the purpose of reducing hiring bias. A blind CV excludes any personal details which refer to the applicant’s gender, age or ethnicity. When applying for our positions, please submit a blind CV, that is, with no picture, name, gender, age, nationality, ethnicity and address. Your personal statement, work experience, courses and certifications, education, skills and contact information is what matters to us.
#MuchMoreThanJustAJob
Early morning. Campo 24 de Agosto. In 4 minutes, you are clocking in at the office. Start your day having breakfast with the Team and grab fresh fruit on the way to your seat, in one of Porto’s most typical neighborhoods. This Purple Day is going to be a busy one: daily meeting ensuring all team members are on the same page regarding work status, priorities and blockers, language class and, just after, a Talent Management meeting with your manager, discussing your career path.
Lunch break. Today, your Team is onboarding newcomers, but also welcoming French colleagues: the perfect excuse to walk downtown and bond over a francesinha. When returning, inhale nature and peace of mind in Natixis Urban Garden (look at the crops; ready to harvest!).
Back inside. Brainstorming session on a new, exciting project in our disruptive and immersive Manaus Village. The afternoon went flying (tasks, meetings, some jokes with your teammates). End it on a high note: celebrating cultural diversity with a Diwali, the Indian festival of lights.
Tomorrow, you attend a conference led by influential speakers in your industry and, the day after, you will work from home, benefitting from some focus time to complete that report and soft skills course on LinkedIn Learning. Once you are done with your work for the day, strike the right note playing with Natixis band or be part of a board games session. If that is too steady for you, meet your colleagues to catch some waves or sail the Douro river during golden hour.