Database Administrator

**Company Description** Natixis in Portugal is fully integrated in the global organization of Natixis, a French multinational financial services firm specialized in Asset & Wealth Management, Corporate & Investment Banking, Insurance and Payments. A subsidiary of Groupe BPCE, Natixis counts nearly 16.000 employees across 38 countries. Based in Porto, Natixis Centre of Expertise mission is to transform traditional banking by developing innovative solutions for the bank’s business, operations and work culture worldwide, as a key driver of the company’s culture of agility and innovation. Teams of IT and Banking Support Activities work in an integrated, inclusive and transversal way, supporting all the business lines and country platforms. Natixis in Portugal is the best combination of a “start-up mindset” with a large, solid structure. Its unique culture gives true meaning to a “beyond banking” personality: to be a real entrepreneur, self-challenging, ever striving to excel and go that extra mile. The Database Infrastructure Expert designs, deploys, standardizes and maintains the foundations and services of Databases solutions on-premises systems and in the cloud. 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. As a Database Infrastructure Expert, you will be responsible for: - 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 - Bring added value to internal and external customers through the provision of new services (As a Service) dedicated DBMS The Database Infrastructure Engineer 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. As a Database Infrastructure Engineer you will be responsible for: - Reduce operational risks and contribute to functionally enriching processes, - SGBD Migration Factory tools and solutions Studies and Controls: - 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 (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 - Monitor and control versions of existing databases and software packages selected by the company - 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 - 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 Audit and Recommendations - Perform: - Architecture audits - Architecture performance studies and analysis - Databases’ tuning - Support production teams and/or publishers on escalated issues Contribution to Business Projects - Define, approve and validate technical architectures - Advise users - Develop recommendations for business projects - Participate in data migration projects - Create, at request of the domains or the exploitation or in anticipation of the needs, the specific tools of assistance to the exploitation Contribution to IT Development Projects - Define, approve and validate technical architectures - Assume the role of project manager (for some Databases Infrastructure Projects) - Contribute to technical projects. - Document, coach, follow, write procedures, perform customer packages, etc. Exploitation & Support - Implement automatic monitoring (technical and functional) - Capac