Senior Database Analyst

Jobtailor; São Bernardo do Campo; Presencial; BRL 120 000 - 190 000; Tempo integral

Resumo da oferta

Jobtailor is seeking an experienced Database Administrator to manage production SQL Server and Oracle environments in a dynamic, data-driven setting. You will optimize performance, ensure security, and drive reliability across critical systems.

You will plan installations, upgrades, migrations and DR strategies while implementing automation to reduce manual work. Strong collaboration with IT teams and adherence to ITIL-aligned processes are essential.

Qualificações

• Bachelor’s degree in Information Technology, Computer Science, Computer Engineering or related fields.

Responsabilidades

• Administer, monitor and optimize production SQL Server and Oracle databases for availability, performance and security.
• Plan and execute database installation, configuration, upgrade, migration and update activities in line with business requirements.
• Manage and optimize backup, restore and disaster recovery routines to ensure data integrity and availability.
• Perform performance analyses and tuning of databases, infrastructure and applications to improve efficiency and stability.
• Maintain access control, apply patches and ensure compliance with security and data governance policies.
• Participate in evaluation of database solutions, considering licensing, costs and benefits.
• Contribute to strategic projects modernizing data environments and automation.
• Develop automations for operational activities to reduce manual tasks.
• Provide technical support across teams and share knowledge within the database area.

Conhecimentos

Database administration

Performance tuning

Security compliance

Data governance

Automation scripting

Stakeholder collaboration

Formação académica

Bachelor’s degree in IT/CS/CE

Ferramentas

SSMS

SQL Profiler

Windows Performance Monitor

Oracle Enterprise Manager

Oracle RMAN

Oracle Data Guard

Red Hat Linux

Descrição da oferta de emprego

Responsibilities

• Administer, monitor and optimize production SQL Server and Oracle database environments, ensuring availability, performance, security and continuity of services;
• Plan and execute database installation, configuration, upgrade, migration and update activities, meeting business requirements and market best practices;
• Manage and optimize backup, restore and disaster recovery routines, ensuring data integrity and availability;
• Perform performance analyses and tuning of infrastructure, databases and applications, proposing improvements to increase efficiency and stability of environments;
• Manage access, apply patches and ensure compliance with security, audit and data governance policies;
• Participate in the technical and financial evaluation of database and infrastructure solutions, considering licensing, costs and benefits;
• Take part in strategic projects related to modernizing data environments, process automation and adopting new technologies;
• Develop and implement automations for operational activities, reducing manual tasks and increasing process efficiency;
• Provide technical support to multidisciplinary teams, acting as a reference in the database area and sharing knowledge with professionals of different seniority levels;
• Represent the area in technical forums, meetings and global initiatives, contributing to decision-making and alignment with corporate strategies;
• Work in compliance with agile methodologies and IT service management processes.

Requirements

• Bachelor’s degree in Information Technology, Computer Science, Computer Engineering or related fields;
• Proven experience in administration of SQL Server and Oracle databases;
• Solid experience in implementation, support and administration of production database environments;
• Experience in migration, upgrade and modernization projects for database platforms;
• Advanced knowledge in installation, configuration, monitoring and troubleshooting of SQL Server and Oracle environments;
• Experience with backup, restore and disaster recovery strategies in corporate environments;
• Knowledge in performance analysis, tuning and capacity planning of databases;
• SQL Server On‑Premises and Oracle On‑Premises;
• Windows Cluster and SQL Server Always On;
• SQL Server Management Studio (SSMS), SQL Profiler and Windows Performance Monitor;
• Oracle Database on Red Hat Linux environment;
• Oracle Data Guard, Oracle RMAN and Oracle Enterprise Manager (Diagnostic and Tuning Pack);
• Knowledge of database infrastructure governance, including security, audit, segregation of duties and environment standardization;
• Knowledge of agile methodologies (Scrum and Kanban) and IT service management processes based on ITIL.