ManchesterRecruiter Since 2001
the smart solution for Manchester jobs

Senior Database Administrator - 2018208

Company: Fidelity Investments
Location: Merrimack, NH
Posted on: February 19, 2021

Job Description:

Designs and implements complex databases and business critical designs, using database technologies -- Oracle, Postgres, NoSQL, and Snowflake. Performs application database administration using Oracle services -- SQL code review, performance analysis, query tuning, database application design, physical data modeling, development support, and engineering. Assesses readiness of new system for conversion, including routine procedures, system administration, recovery and restart scenarios, error procedures, distribution of software releases, distribution of data, and network management. Provides database support in all phases of the Software Development Life Cycle (SDLC).

Primary Responsibilities:

Monitors databases servers and responds to alerts.

Participates in 24x7 on call rotation for production support, database maintenance, housekeeping, and installations.

Diagnoses problem areas and creates solutions and workarounds.

Establishes database standards for operations, upgrades, and migrations, and on-boards new applications and clients.

Writes clear, concise, well-coordinated technical documentation to maintain standards and procedures.

Automates recoverability for non-highly available databases.

Provides expertise to define complex database and data warehousing methodologies.

Ensures capacity management and performance tuning of an assigned database.

Establishes project plans for projects of moderate scope.

Implements complex and/or business critical changes.

Identifies users and situations that may be hazardous to the system/network.

Defines security requirements and operational procedures to ensure compliance with security framework.

Identifies environment (operational or application) modifications to improve security.

Diagnoses and troubleshoots storage problems.

Assesses and communicates the impact of changes to existing systems.

Monitors and reports on the progress of change implementation efforts.

Modifies existing databases and database management systems or collaborates with programmers and analysts to make changes.

Develops methods for seamlessly integrating products together including customizing commercial databases to fit specific needs.

Education and Experience:

Bachelors 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 in a mission critical database production support environment, using Oracle RAC, Goldengate, and Oracle Datagaurd.

Or, alternatively, Masters 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 in a mission critical database production support environment, using Oracle RAC, Goldengate, and Oracle Datagaurd.

Skills and Knowledge:

Candidate must also possess:

Demonstrated Expertise (DE) performing Oracle RAC database administration across AIX, Solaris, Linux, and Windows platforms, using Oracle Enterprise Manager (OEM), Oracle SQL *Developer, Oracle SQL*Plus, Oracle AWR, and Database Configuration Assistant (DBCA).

DE developing, installing, and managing Oracle replication technologies -- Oracle GoldenGate (Active-Active and Active-Passive) and Oracle Data Guard.

DE performing SQL performance Tuning and Optimization (PTO), using Oracle Enterprise Manager Grid control (OEM) and Linux shell scripting; writing database monitoring jobs in PL/SQL; and collaborating with enterprise infrastructure teams to diagnose end-to-end database technology stack performance issues, using Oracle AWR (Automatic Work Repository), Oracle Active Session History (ASH), Automatic Database Diagnostic Monitor (ADDM), and SQL monitor reports.

DE performing database architecture -- designing relational database physical data models, performing capacity planning, indexing, partitioning, archiving, and compression, and designing and implementing enhanced database monitoring and alerting solutions, using Linux shell scripting, Oracle PL/SQL programs, and Oracle Enterprise manager scheduler.

For full job details and to apply, please visit https://jobs.fidelity.com/ and search for job number: 2018208.

Keywords: Fidelity Investments, Manchester , Senior Database Administrator - 2018208, Finance , Merrimack, NH, New Hampshire


Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Finance Jobs


Principal Software Engineer/Developer - 2020800
Description: Designs and programs Oracle databases, using PL/SQL, SQL, and Oracle. Optimizes query performance and database objects, using PL/SQL and SQL. Builds procedures, packages, functions, trigger views, cursors, (more...)
Company: Fidelity Investments
Location: Smithfield, RI
Posted on: 04/2/2021

Principal Software Engineer/Developer - 2020794
Description: Designs and builds end-to-end systems, using Java RESTful Web Services Java, J2EE, JUnit, and Tomcat and Open Source Frameworks Spring Boot and Spring Core . Integrates data API's using Oracle PL/SQL. (more...)
Company: Fidelity Investments
Location: Merrimack, NH
Posted on: 04/2/2021

Principal Software Engineer/Developer - 2019727
Description: Creates software service solutions using fundamental design principals for building scalable applications. Writes service layer code and guides junior engineers on design and hands on coding. Drives track (more...)
Company: Fidelity Investments
Location: Boston, MA
Posted on: 03/19/2021


Principal Software Engineer/Developer - 2020793
Description: Develops and implements business-critical desktop and mobile applications, including the integration of third-party tools and the creation of middleware applications. Programs Object-Oriented solutions (more...)
Company: Fidelity Investments
Location: Smithfield, RI
Posted on: 04/2/2021

Log In or Create An Account

Get the latest New Hampshire jobs by following @recnetNH on Twitter!

Manchester RSS job feeds