Fidelity Investments
Senior Database Administrator
Fidelity Investments, Roanoke, Texas, United States, 76299
Job Description:
Position Description:
Translates the project requirements and implements database technology solutions using Oracle databases and replication technologiesGolden 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:
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 changesservice requests, automated incidents, and change managementto 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:
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.
Position Description:
Translates the project requirements and implements database technology solutions using Oracle databases and replication technologiesGolden 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:
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 changesservice requests, automated incidents, and change managementto 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:
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.