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