Job Description:
Position Description:
Designs, implements, and maintains the organization's database systems. Develops technical solutions to prevent cyber fraud using a wide range of technical and data management tools and technologies -- Snowflake, Oracle, Exadata, PostgreSQL, Goldengate, Veridata and HVR. Writes and optimizes SQL queries and stored procedures using SQL, PL/SQL and shell scripts languages for development of database. Works with Database Administrators and operations teams to support data need.
Primary Responsibilities:
- Ensures the scalability, reliability, performance, and security of the databases by performing database tuning and optimization.
- Troubleshoots and resolves issues with databases and related systems by continuously monitoring and optimizing database performance.
Want more jobs like this?
Get jobs in Westlake, TX delivered to your inbox every week.
- Collaborates with cross-functional teams to ensure data integrity and access.
- Assists with database applications and data sources dependency maps and reverse engineers of data flows.
- Maintains the performance, availability, and security of the databases.
- Builds automated processes that streamline and eliminate manually intensive data processes to provide higher operational excellence and efficiencies.
- Confers with systems analysts and other software engineers/developers to design systems and to obtain information on project limitations and capabilities, performance requirements and interfaces.
- Develops and oversees software system tests and validation procedures, programs, and documentation.
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 five (5) years of experience as a Principal Data Engineer (or closely related occupation) performing Oracle middleware and database administration in a financial services 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 three (3) years of experience as a Principal Data Engineer (or closely related occupation) performing Oracle middleware and database administration in a financial services environment.
Skills and Knowledge:
Candidate must also possess:
- Demonstrated Expertise ("DE") implementing, installing, and maintaining Oracle replication technologies -- Oracle GoldenGate (Active/Active and Active/Passive), Oracle Data Guard, and HVR.
- DE supporting database architecture, including designing physical and logical data models and performing capacity planning, indexing, partitioning, archiving, and compression; and designing and implementing High Availability/Disaster Recovery (HA/DR) strategies.
- DE designing and implementing highly resilient and performant Oracle databases with mega size (500+TB) databases on X9 Oracle Exadata appliances.
- DE designing, implementing, and maintaining Snowflake database platform with large number (50+) of databases and petabytes of data.
#PE1M2 #LI-DNI
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.