Job Description:
Position Description:
Translates the project requirements and implements database technology solutions using Oracle databases and replication technologies - Golden Gate. Provides expertise to define complex database and data warehousing methodologies. Ensures capacity management and performance tunes of assigned databases. 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.
Primary Responsibilities:
Want more jobs like this?
Get jobs in Westlake, TX delivered to your inbox every week.
- Analyzes and implements database technology infrastructure solutions to triage and resolve technical issues quickly.
- Modifies exists databases and database management systems or collaborate with programmers and analysts to make changes.
- Automates recoverability for non-highly available databases.
- Supports databases in an AWS Cloud Infrastructure environment.
- Evaluates industry trends in database systems to serve as a source of information and advice for upper management.
- Develops methods for integrates different products so they work properly together such as customizes commercial databases to fit specific needs.
- Designs and implements complex databases and business critical designs.
- Assesses and communicates the impact of changes to the existing systems.
- Monitors and reports on the progress of change implementation efforts.
- Assesses readiness of the new system for conversion, includes 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 Oracle database administration in an IT solutions environment.
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 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), and Oracle disaster recovery Data Guard technologies.
- DE evaluating, testing, and certifying Oracle and Golden Gate database product features; implementing and supporting heterogenous data replication; assessing the impact of Oracle database parameters, Golden Gate database replication, Oracle database optimizer changes, and Oracle database partitioning techniques and impacts; performing performance analysis, using Oracle XPLAN and SQL optimizer trace; and implementing SQL profiles and baselines using SQL plan management.
- 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 Oracle Enterprise Manager (OEM); and ensuring infrastructure changes adhere to Information Technology Infrastructure Library (ITIL), change management, and security access procedures and policies.
- DE performing installation, configuration, and supporting Microsoft SQLServer Database technology; Database backup / recovery, performance tuning, database resiliency testing and creation and configuration of Database Migration Service (DMS) for cross site database replication.
#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 hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite all business days of every other week in a Fidelity office.
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.