Job 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:
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.
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.
Certifications:
Category:
Information Technology
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 every other week (all business days, M-F) in a Fidelity office.
