Oracle DBA

FIDELITY LLC
Merrimack, United States of America
7 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Shift work
Languages
English
Experience level
Senior
Compensation
$ 190K

Job location

Merrimack, United States of America

Tech stack

Amazon Web Services (AWS)
Amazon Web Services (AWS)
Azure
Cloud Computing
Cloud Database
Software Documentation
Computer Security
Information Systems
Databases
Data Infrastructure
Database Applications
Database Design
Linux
Distributed Data Store
Oracle Exadata
Oracle
Oracle Applications
Oracle Rac
Systems Development Life Cycle
Query Optimization
Standard Sql
Shell Script
PL-SQL
Snowflake
Database Optimization
Information Technology
Database Replication
Oracle Cloud Infrastructure

Job description

The Common Data Platform team within Institutional Brokerage Database Service organization needs a highly competent and motivated Senior Database Administrator with deep technical skills to manage multiple highly complex and critically important database platforms. This position would provide an excellent opportunity to work on leading database technologies like Oracle RAC, Oracle Exadata, Oracle GoldenGate, AWS EC2/RDS, Snowflake, etc. It is a great place to experience & learn end to end enterprise database service capabilities! This role requires a service-oriented mentality, high sense of ownership of the projects, problems, and requests assigned., * Perform applications database administration (Oracle & Snowflake) services including SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support & Engineering.

  • Proactively monitor databases servers and respond to any alerts
  • 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
  • Ability to quickly diagnose the problem areas and come up with solutions and/or workarounds
  • Should have strong time management skills with willingness and ability to prioritize multiple projects/initiatives at the same time
  • Establish database standards for operations, upgrades, migrations and onboarding new applications and/or clients
  • Write clear, concise, well organized user documentation to maintain standards and procedures, The Common Data Platform team within Institutional Brokerage Database Service organization provides business facing database solutions, encompassing the application/business aspects of databases, including database design, solution design, database engineering, application-data-database integration, data replication, performance consulting, deployment, and support, using world-class methodologies & technologies. This team provides end to end DBA services for distributed database technologies like Oracle, Snowflake, Exadata, GoldenGate, HVR, etc.

Requirements

  • Bachelors or master's degree in Computer Science or Information Systems or equivalent
  • 6+ years of experience in Oracle DBA with Exadata and RAC expertise
  • Expertise in database performance tuning, query optimization, and assist application teams in troubleshooting and resolving performance related issues
  • 2+ years of experience in Cloud (AWS/OCI/Azure)
  • 2+ years of experience in Snowflake database administration
  • Experience with Linux shell scripting and development experience with PL/SQL.
  • Experience with cloud databases platforms (AWS/Azure certification is preferred), on both Linux and Windows environments
  • 2+ years of experience in distributed replication technologies (Oracle Goldengate), preferred but not mandatory
  • 2+ years of experience in the Mutual Fund /Financial Services industry is highly desired, Placement in the range will vary based on job responsibilities and scope, geographic location, candidate's relevant experience, and other factors.

Placement in the range will vary based on job responsibilities and scope, geographic location, candidate's relevant experience, and other factors.

About the company

At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want! We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com. Fidelity Investments is an equal opportunity employer. Fidelity will reasonably accommodate applicants with disabilities who need adjustments to complete the application or interview process. Fidelity TalentSource, is the in-house temporary staffing provider for Fidelity Investments. Unlike traditional staffing agencies, we are an internal business unit within Fidelity's Talent Acquisition team, dedicated to recruiting talent from various backgrounds for roles in Fidelity's regional and investor center locations. Our mission is to help you experience Fidelity's diverse and inclusive workplace while expanding your skill set and professional network, with the ultimate goal of conversion to full-time employment as part of Fidelity's long-term strategy.

Apply for this position