Sr. Database Administrator (Dba) - Systems Engineer

Factset Research Systems

São Paulo

Híbrido

BRL 180.000 - 320.000

Jornada completa

Hace 7 días
Sé de los primeros/as/es en solicitar esta vacante

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Descripción de la vacante

FactSet's Data Platform Engineering - SQL team in São Paulo seeks an experienced Database Engineer to manage and optimize Oracle environments across on-premises and cloud, ensuring high reliability, security, and performance. You will implement backup, recovery, and audit controls, and collaborate with global teams in the US, UK, and India.

The role involves standing up upgrades and migrations, automating operations in AWS RDS, and participating in an on-call rotation.

Formación

  • 6-8 years hands-on experience administering Oracle databases in high-volume environments.
  • Experience with database backup, restore, and recovery operations in enterprise environments.
  • Experience with Oracle RMAN backup and recovery.
  • Experience with Oracle Data Pump (expdp/impdp) and RMAN utilities.
  • Knowledge of Oracle Transportable Tablespaces (TTS) and Cross-Platform Transportable Tablespaces (XTTS).
  • Fluent English is required to communicate across regions (US/UK/India).

Responsabilidades

  • Administer, maintain, and optimize multi-terabyte Oracle databases, ensuring reliability, performance, auditing and security.
  • Install, configure, and upgrade Oracle databases across on-premises and cloud environments (AWS RDS and On-Prem).
  • Lead database upgrades and cross-version migrations, including cross-DB-platform migrations.
  • Develop backup and recovery strategies, including PITR and DR procedures.
  • Enforce audit controls for database change and access management; implement HA/DR procedures.
  • Automate database operations in AWS RDS and collaborate with cross-functional teams.

Conocimientos

Oracle DB administration
English communication
On-call experience

Educación

Bachelor's degree in computer science/engineering

Herramientas

RMAN
Data Pump
Transportable Tablespaces (TTS/XTTS)
AWS RDS

Descripción del empleo

FactSet creates flexible, open data and software solutions for over 200,000 investment professionals worldwide, providing instant access to financial data and analytics that investors use to make crucial decisions.

At FactSet, our values are the foundation of everything we do. They express how we act and operate , serve as a compass in our decision-making, and play a big role in how we treat each other, our clients, and our communities. We believe that the best ideas can come from anyone, anywhere, at any time, and that curiosity is the key to anticipating our clients' needs and exceeding their expectations.

Fluency in English (written and spoken) is a definitive must to apply.

Resume must be submitted in ENGLISH .

Job Location: São Paulo City - Pinheiros (3 days/week at office)

Working hours: Brazil business hours + On-call Rotation every 4-5 weeks

Employment condition : Brazil full-time CLT with FactSet competitive benefits global package applied to Brazil (FactSet total rewards).

Your Team's Impact

Join FactSet's Data Platform Engineering - SQL team, where you'll play a critical role in managing and optimizing the mission-critical databases that power FactSet's global financial solutions. Reporting to the Data Platform Engineering leadership, you'll work at scale across on-premises and cloud environments, with high visibility across our US, UK, and India teams. This is a hybrid position based in São Paulo.

What You'll Do
  • Administer, maintain, and optimize multi-terabyte Database environments, emphasizing reliability, performance, auditing, and security.
  • Install, configure, and upgrades Oracle / MS SQL Server instances across on-premises and cloud environments (AWS RDS and On-Prem).
  • Lead database upgrades and migrations from older versions to the latest releases , including cross-DB-platform migration.
  • Develop and implement database backup and recovery strategies, including Point-in-Time Recovery (PITR) and disaster recovery procedures.
  • Ensure audit compliance by designing and enforcing controls for database change management and access management.
  • Implement high availability (HA) and disaster recovery (DR) procedures.
  • Automate the database operations in AWS RDS.
  • Collaborate with cross-functional teams to define requirements and successfully deliver database and security solutions.

This role requires participation in an On-Call rotation to provide support during off-hours, weekends or emergencies (On-call: Rotation every 4-5 weeks).

What We're Looking For
Minimum Requirements
  • 6-8 years hands-on experience administering Oracle databases in high-volume, mission-critical environments. (MS SQL Server /PostgreSQL experience a plus).
  • Experience with database backup, restore, and recovery operations in enterprise environments.
  • Experience with Oracle Data Pump (expdp / impdp) and RMAN backup and recovery.
  • Hands-on experience with Oracle Transportable Tablespaces (TTS) and Cross-Platform Transportable Tablespaces (XTTS).
  • Experience using RMAN and Oracle Data Pump utilities.
Critical Skills
  • Hands on experience in other AWS Services like RDS, EC2, S3, VPC , DMS etc.
  • Experience with database migrations, upgrades, and cross-DB-platform migrations.
  • Experience with Oracle backup and recovery strategies, including RMAN, Data Pump, TTS, and XTTS
  • Experience with database performance troubleshooting using AWR / ASH / ADDM / Query Store.
  • Experience in scripting for automation and tooling. (Preferred python / Terraform)
  • Proven ability in HA/DR and backup/restore planning and execution.
  • Fluent English is required, as you will need to communicate across multiple regions, specifically the US, UK and India.
  • Deep understanding of Database security, user/role management, auditing, and encryption.
  • Exceptional troubleshooting and performance tuning skills.
  • Excellent communication, analytical thinking, and teamwork.
Additional Skills:
  • Experience with MySQL, Aurora PosgreSQL, MariaDB.
  • Experience with Oracle-to-PostgreSQL and SQL Server-to-PostgreSQL migrations.
  • Experience with AWS DMS for heterogeneous database migrations.
  • Certified AWS Solution Architect / OCA / OCP
Education:
  • Bachelor's degree in computer science, engineering, or related discipline.
Company Overview:

FactSet ( NYSE:FDS | NASDAQ:FDS ) helps the financial community to see more, think bigger, and work better. Our digital platform and enterprise solutions deliver financial data, analytics, and open technology to more than 8,200 global clients, including over 200,000 individual users. Clients across the buy-side and sell-side, as well as wealth managers, private equity firms, and corporations, achieve more every day with our comprehensive and connected content, flexible next-generation workflow solutions, and client-centric specialized support. As a member of the S&P 500, we are committed to sustainable growth and have been recognized among the Best Places to Work in 2023 by Glassdoor as a Glassdoor Employees' Choice Award winner. Learn more at www.factset.

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Sr. Database Administrator (DBA) - Systems Engineer
Sr. Database Administrator (DBA) - Systems Engineer

10051 FactSet Brasil Consultoria Ltda • São Paulo

Híbrido
BRL 180.000 - 320.000
Software Engineer (Go, Python, Ci/Cd, Rotation On-Call) - Hybrid
Software Engineer (Go, Python, Ci/Cd, Rotation On-Call) - Hybrid

Factset Research Systems • São Paulo

Presencial
BRL 180.000 - 300.000
Competitive benefits package
Software Engineer (Go, Python, CI/CD, Rotation On-call) - Hybrid
Software Engineer (Go, Python, CI/CD, Rotation On-call) - Hybrid

10051 FactSet Brasil Consultoria Ltda • São Paulo

Presencial
BRL 180.000 - 240.000
Software Engineer (Go, Python, CI/CD, Rotation On-call) - Hybrid
Software Engineer (Go, Python, CI/CD, Rotation On-call) - Hybrid

FactSet • São Paulo

Presencial
BRL 180.000 - 300.000
Lead Site Reliability Engineer (Kubernetes Required) - Hybrid
Lead Site Reliability Engineer (Kubernetes Required) - Hybrid

FactSet • São Paulo

Híbrido
BRL 180.000 - 300.000
Software Engineer (Go, Python, CI/CD, Rotation On-call) - Hybrid
Software Engineer (Go, Python, CI/CD, Rotation On-call) - Hybrid

FactSet Research Systems Inc. • São Paulo

Híbrido
BRL 120.000 - 180.000
Cloud Engineer - GCP/AWS
Cloud Engineer - GCP/AWS

10051 FactSet Brasil Consultoria Ltda • São Paulo

Presencial
BRL 180.000 - 280.000
Cloud Engineer - Gcp/Aws
Cloud Engineer - Gcp/Aws

Factset Research Systems • São Paulo

Híbrido
BRL 180.000 - 300.000
Technology Consultant- Vermilion
Technology Consultant- Vermilion

10051 FactSet Brasil Consultoria Ltda • São Paulo

Presencial
BRL 180.000 - 300.000
Health insurance
Retirement plan
Stock purchase program
+1
Principal Cloud Engineer - Gcp/Aws (Hybrid)
Principal Cloud Engineer - Gcp/Aws (Hybrid)

FactSet • São Paulo

Presencial
BRL 280.000 - 480.000