Sr. Database Administrator (DBA) - Systems Engineer
Factset
·Yesterday
- Location
- São Paulo, BRA, Brazil
- Workplace
- Hybrid
- Type
- Full-time
- Department
- Engineering
- Seniority
- Senior
- Experience
- 6+ years
- Source
- Workday
Description
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.com and follow us on X and LinkedIn.
At FactSet, we celebrate difference of thought, experience, and perspective. Qualified applicants will be considered for employment without regard to characteristics protected by law.