Principal Database Administrator

Job Description:

Position Description:

Implements and supports financial database technology assets in an Amazon Web Services (AWS) Cloud environment. Builds database architecture and manages administration of Oracle database and replication technologies

• Golden Gate.

Drives technology product lifecycle management and delivers cross dependency application database infrastructure initiatives. Triages complex technical problems to restore services and implement actions to prevent recurring incidents. Automates and streamlines manual processes, using Python and AWS technologies. Modifies existing databases and database management systems or collaborates with programmers and analysts to make changes. Develops methods for integrating products so they work properly together

• customizing commercial databases to fit specific needs.

Primary Responsibilities:

Documents design, operational procedures, and standards for highly complex/business critical databases. Provides 7

• 24 first level database production support for enterprise critical applications.

Tests and implements new design features for general use. Defines and evaluates database maintenance tools and build processes. Establishes performance tuning criteria and methods in coordination with internal and external technical resources. Provides technology strategic roadmap for technology lifecycle management. Designs, evaluates, and executes highly complex database performance and functionality testing. Establishes full project life cycle plans for complex projects. Provides technical evaluation estimates on technology initiatives. Develops and maintains policies, procedures, and techniques in order to minimize future incident occurrence. Defines requirements and operational procedures to ensure network integrity, physical protection, and authorized access to the network and applications. Develops business cases to justify information security architecture initiatives. Enforces storage management standards. Defines the scope of change and impact to other interfaces. Develops high level architecture design for the enterprise. Performs independent and complex technical and functional analysis for multiple projects supporting several divisional initiatives. Advises senior management on technical strategy. Mentors junior team members.

Education and Experience:

Bachelor's degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and five (5) years of experience as a Principal Database Administrator (or closely related occupation) performing Oracle database administration in an IT solutions environment. Or, alternatively, Master's degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Principal Database Administrator (or closely related occupation) performing Oracle database administration in an IT solutions environment.

Skills and Knowledge:

Candidate must also possess: Demonstrated Expertise (DE) designing, developing, and implementing mission critical database infrastructure solutions to ensure compliance with business continuity ratings and audit access policies, using Oracle RMAN database backup and recovery utilities, Oracle Real Application Clusters (RAC), Delphix Appliances, and Oracle disaster recovery Data Guard technologies. DE providing production and non-production technical database support

• triaging, resolving, and providing root cause analysis
• in an integrated asset management trading environment, using Oracle Enterprise Manager (OEM) and Automatic Workload Repository (AWR) tools; and mining and analyzing Oracle database level data and server log files
• core dumps, Golden Gate database replication, Linux OS alert, and Oracle trace files and alert logs.

DE performing installation, configuration, and supporting Microsoft SQLServer and Neo4j graph Database technologies; Database backup / recovery, performance tuning, database resiliency testing and creation and configuration of Database Migration Service (DMS) for cross site database replication. DE assessing and testing database infrastructure changes

• service requests, automated incidents, and change management
• to evaluate business risk from a server, storage, network, and database perspective, using Service Now; assessing database capacity and performance management, using Oracle Automatic Workload repository and OEM; and ensuring infrastructure changes adhere to Information Technology Infrastructure Library (ITIL), and change management and security access procedures and policies.

#PE1M2 #

LI-DNI Certifications:

Category:

Information Technology Most roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles. Some roles may have unique onsite requirements. Please consult with your recruiter for the specific expectations for this position. Please be advised that Fidelity's business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories. 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 participate in the application or interview process. To initiate a request for an accommodation please contact the following: For roles based in the

US:

Contact the HR Leave of Absence/Accommodation Team by sending an email to accommodations@fmr.com, or by calling 800-835-5099, prompt 2, option 2 For roles based in

Ireland:

Contact AccommodationsIreland@fmr.com For roles based in

Germany:

Contact Accommodationsgermany@fmr.com Fidelity Privacy Policy