Senior Database Administrator

Job Description:

Position Description:

• Applicants are permitted to work from at-home worksite anywhere in the United States*

Provides end-to-end support of physical database design, deployment, data replication, performance tuning and security using Db2 on z/OS, Oracle, and Kafka. Deploys and maintains the database virtualization environment across the enterprise and protects sensitive data. Performs application deployment and analyzes Cloud database management systems usage patterns using database technologies -- SQL, IBM, and Db2. Performs application database administration using Oracle services, SQL, REXX, JCL, COBOL code review, and Linux shell scripting. Modifies existing databases and database management systems. Collaborates with programmers and analysts to make changes as necessary.

Primary Responsibilities:

• Designs and implements complex databases and business critical designs.

• Automates recoverability for non-highly available databases.

• Provides expertise to define complex database and data warehousing methodologies.

• Ensures capacity management and performance tuning of assigned database.

• Establishes project plans for projects of moderate scope.

• 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.

• Monitors and reports on the progress of change implementation efforts.

• Assesses readiness of the 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.

Education and Experience:

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 as a Senior Database Administrator (or closely related occupation) performing Db2 z/OS Database Administration using CA tools or replication methods (CDC/Qrep).

Or, alternatively, 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 as a Senior Database Administrator (or closely related occupation) performing Db2 z/OS Database Administration using CA tools or replication methods (CDC/Qrep).

Skills and Knowledge:

Candidate must also possess:

• Demonstrated Expertise ("DE") performing Database design and engineering, using SQL, REXX, JCL, and COBOL.
• DE configuring and supporting QREP, IBM CDC replication products between DB2's, or Cloud tools (GITHUB, JENKINS, S3, and DevOps CI/CD pipeline) within a z/OS and distributed environment.
• DE performing DBA activities using CA/Broadcom Database tools; writing and tuning Native Stored Procedure, or performing SQL performance tuning; and performing release and version upgrades.
• DE monitoring and tuning Database 2 and Distributed Data Facility (DDF) workloads, using distributed technologies and Linux.

#PE1M2

Certifications:

Company Overview

Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients' money.

Join Us

At Fidelity, you'll find endless opportunities to build a meaningful career that positively impacts peoples' lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees' Choice Award, we have been recognized by our employees as a top 10 Best Place to Work in 2024. And you don't need a finance background to succeed at Fidelity-we offer a range of opportunities for learning so you can build the career you've always imagined.

Fidelity's working model blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).

At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation, detailed in this document, and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.

We invite you to Find Your Fidelity at fidelitycareers.com.

Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.

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, contact the HR Accommodation Team by sending an email to accommodations@fmr.com, or by calling 800-835-5099, prompt 2, option 3.