Oracle DBA - Roanoke, United States - Saxon Global

Description

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