Senior Database Administrator - 1804472
Company: Fidelity Investments
Location: Merrimack, NH
Posted on: May 11, 2018
Job Description:
Duties: Designs, implements, monitors, and tunes databases built
on mainframe and distributed architecture. Works on cross platform
migration of databases from DB2, SQL server, and Sybase to Oracle and
MariaDB. Creates Oracle Enterprise Manager (OEM) 12c repository. Develops
custom metrics, incidents, rules, and business intelligence reports
through OEM 12c. Primary Responsibilities: • Works with solution architect team to implement new versions
and solutions. • Creates database packages, procedures, functions, and
triggers. • Creates and maintains standby databases. • Documents design, operational procedures, and standards for
complex and business critical databases. • Designs and tests recoverability for highly available
databases. • Maintains technical implementations of operational
procedures. • Works directly with the user community for project
definition. • Identifies users and situations that may be hazardous to
the system/network. • Implements operational procedures to ensure network
integrity, physical protection, and authorized access to the network and
applications. • Assists in developing business cases to justify
information security architecture initiatives. Requirements: Bachelor’s degree (or foreign education
equivalent) in Computer Science, Engineering, Information Technology,
Information Systems, Mathematics, Physics, or a closely related field and three (3)
years of experience in the job offered or three (3) years of experience
performing Oracle database administration within a mission critical asset
management environment; Or, alternatively, a Master’s degree (or foreign
education equivalent) in Computer Science, Engineering, Information
Technology, Information Systems, Mathematics, Physics, or a closely related
field and one (1) year of experience in the job offered or one (1) year of
experience performing Oracle database administration within a mission
critical asset management environment. Candidate must also possess:
Demonstrated Expertise (“DE”) performing DB2, Sybase, SQL Server, and Oracle 12c Real
Application Cluster (RAC) database administration, including Oracle EXADATA
solutions and Oracle E-Business Suites R12, within a mission critical
asset management environment; DE performing database instance, query
tuning, and troubleshooting real-time mission critical database
applications, using Oracle Enterprise Manager 13c; and identifying bottlenecks and
providing performance tuning and optimization recommendations based on
Oracle AWR, ASH, and SQLT reports and system diagnostics; DE performing
setup, administration, and configuration of Oracle Real Application
Custer (RAC) patching; and performing Oracle database replication or Cross
Platform Database Migration using Golden Gate and Data Guard
configuration for mission critical asset management applications; DE performing
setup of Sybase Replication Server and heterogeneous replication between
Sybase, SQL Server, DB2, and Oracle systems, using GoldenGate, Informatica,
and MySQL Workbench. To apply, visit http://jobs.fidelity.com and search for Job
Number 1804472.
Keywords: Fidelity Investments, Cambridge , Senior Database Administrator - 1804472, Finance , Merrimack, NH, Massachusetts