Job Description:The Fidelity Brokerage Operations application DBA position entails database administration tasks on small, medium & large size Oracle databases and data warehouses, being part of a large team of database professionals spread across United States and Fidelity's overseas locations.
The Expertise and Skills You Bring: • BS in Computer Science or equivalent desirable
• Ability to perform applications database administration (Oracle) services including SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support & Engineering
• Experience in setting up, installing and managing multisite databases using Oracle Goldengate replication
• Experience with cloud databases platforms on Linux environments
• Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
• Provide database support in all phases of SDLC and agile experience is preferred
• Participate in 24X7 on call rotation schedule for various production support, database maintenance, housekeeping and installs
• Work with enterprise teams for Systems Administrators, Cyber Security and Capacity Planning groups as and when situation demands
• Strong time management skills with willingness and ability to prioritize multiple projects/initiatives at the same time
• Self-motivated with strong team, interpersonal and communication skills
• Establish database standards for operations, upgrades, migrations and onboarding new applications and/or clients
• Advanced skills in SQL Performance Tuning and Optimization (PTO), using Oracle Enterprise Manager Grid control (OEM 12c), Linux shell scripting, and writing database monitoring jobs in PL/SQL
• Strong Linux shell scripting experience preferred
• Ability to work well in a team environment, as well as maintaining a flexible attitude are a must
• Ability to develop and drive database administration strategies and initiatives as per the needs of the team
Required Skills: - 5+ years Oracle 19c (current)
- Large/complex organization
- Database performance tuning (SQL tuning)
- Goldengate
- Team is application DBAs (we are not looking for a system DBA)
- Exposure to cloud migration (AWS/SnowFlake) - highly preferred
- Oracle database skillset is a must, we cannot compromise
- Most significant skill is the admin piece