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.
