Principal Database Developer

17 hours ago

Smithfield, Ohio, United States Fidelity TalentSource LLC Full time
Job Description:

Position Overview:

As a Principal Database Developer at Fidelity Investments, you will be responsible for designing and implementing database solutions using Oracle. Your expertise will be crucial in developing data-intensive applications, data integration, and data pipeline design patterns on a distributed platform.


Key Responsibilities:
  • Establish full project lifecycle plans for complex projects.
  • Document designs, operational procedures, and standards for highly complex business-critical databases.
  • Build data pipelines optimized for scaling.
  • Troubleshoot potential platform issues.
  • Collaborate with data architects to craft and implement solutions and improvements to ingest, transform, connect, store, and expose data to a range of users.
  • Incorporate new data sources by building pipelines for automated and semi-automated data ingestion and data refresh.
  • Develop and implement tests to ensure data quality and proper governance across all integrated datasets.
  • Provide insights on data warehouse technical architectures, infrastructure components, ETL/ELT, and design and reporting/analytic tools and environments.
  • Confers with systems analysts and software engineers/developers to design systems and obtain information on project limitations and capabilities, performance requirements and interfaces.
  • Develop and oversee software system testing and validation procedures, programming, and documentation.
  • Mentors junior team members.

Requirements:

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 Database Developer (or a closely related occupation) developing data solutions using Oracle.

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 Database Developer (or a closely related occupation) developing data solutions using Oracle.


Preferred Skills and Knowledge:

Demonstrated expertise in designing and implementing database packages, functions, stored procedures, triggers, tables, and views; and writing complex queries to retrieve data using SQL/PLSQL and Native Stored Procedures (NSPs) on DB2 Database to perform ETL operations using Informatica according to Agile methodologies and CI/CD.

Demonstrated expertise in building complex data transformation workflows and procedures with Azure Cloud-based Oracle, on-prem Oracle, SQL Server, or DB2 Databases.

Demonstrated expertise in implementing data storage designs using normalized forms Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF), Key Value Pair, and denormalized forms; and defining system architecture and component interaction functionalities using Unified Modeling Language (UML) State Diagram, Flow Charts, and Sequence and Activity Diagrams.

Demonstrated expertise in performing maintenance activities gathering statistics, analyzing database objects, and conducting data profiling and data mappings; and conducting database performance tuning of complex Oracle PL/SQL queries by analyzing query plans and generating SQL Trace and TKProf.


Salary:
$144, $148,700.00/year.

Certifications:
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.

At Fidelity, you'll find endless opportunities to build a meaningful career that positively impacts people's 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.

  • Principal Database Developer

    5 days ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    Job Description:Position Overview:Fidelity Investments is seeking a highly skilled Principal Database Developer to join our team. As a key member of our database development team, you will be responsible for designing, implementing, and maintaining complex database solutions using Oracle.Key Responsibilities:Design and implement database packages, functions,...

  • Principal Database Developer

    1 week ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    Job Description:As a Principal Database Developer at Fidelity Investments, you will play a critical role in designing and implementing database solutions that drive business growth and innovation. Your expertise in database development, data integration, and data warehousing will enable you to develop and maintain complex database systems, ensuring high...

  • Graph Database Engineer

    4 weeks ago

    Smithfield, Ohio, United States Qualitative Financials Full time

    Job Title: Graph DB/AI Engineer SMTAt Qualitative Financials, we are seeking a highly skilled Graph DB/AI Engineer to join our team. As a key member of our engineering team, you will be responsible for designing and implementing graph data models, developing applications with Python, and integrating graph data from various sources.Key Responsibilities:Design...

  • Graph Database Engineer

    4 weeks ago

    Smithfield, Ohio, United States Qualitative Financials Full time

    Job Title: Graph DB/AI Engineer SMTWe are seeking a highly skilled Graph DB/AI Engineer to join our team at Qualitative Financials. As a key member of our engineering team, you will be responsible for designing and implementing graph data models, developing applications with Python, and integrating graph data from various sources.Key Responsibilities:Design...

  • Database Systems Administrator

    1 week ago

    Smithfield, Ohio, United States Neighborhood Health Plan of RI Full time

    Job Title: Database AdministratorNeighborhood Health Plan of RI is seeking a skilled Database Administrator to join our team.Job Summary:The Database Administrator will be responsible for the installation, implementation, configuration, maintenance, security, integrity, and performance of critical Microsoft SQL Server systems. This is a hands-on position...

  • Database Systems Administrator

    2 days ago

    Smithfield, Ohio, United States Neighborhood Health Plan of RI Full time

    Job SummaryWe are seeking a highly skilled Database Administrator to join our team at Neighborhood Health Plan of RI. The successful candidate will be responsible for the installation, implementation, configuration, maintenance, security, integrity, and performance of critical Microsoft SQL Server systems.Key ResponsibilitiesEnsure all database servers are...

  • Database Systems Administrator

    4 weeks ago

    Smithfield, Ohio, United States Neighborhood Health Plan of RI Full time

    Job SummaryWe are seeking a highly skilled Database Administrator to join our team at Neighborhood Health Plan of RI. The successful candidate will be responsible for the installation, implementation, configuration, maintenance, security, integrity, and performance of critical Microsoft SQL Server systems.Key ResponsibilitiesEnsure all database servers are...

  • Graph Database and AI Engineer

    21 hours ago

    Smithfield, Ohio, United States Qualitative Financials Full time

    Job Title: Graph Database and AI Engineer - SMTLocation: Remote or Onsite (Smithfield RI or Westlake Texas)Job Summary:We are seeking a highly skilled Graph Database and AI Engineer to join our team at Qualitative Financials. The successful candidate will have experience in designing and implementing graph data models, developing applications with Python,...

  • Senior Salesforce Developer

    19 hours ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    About the RoleFidelity TalentSource is seeking a skilled Salesforce Developer to join our Platform Squad. As a critical part of the Salesforce CRM cohort, you will be responsible for building and maintaining a secure and reliable CRM platform that fosters innovation and enables partner teams to deliver exceptional customer experiences.Key...

  • Salesforce Developer

    4 days ago

    Smithfield, Ohio, United States Qualitative Financials Full time

    Job Title: Salesforce DeveloperWe are seeking a highly skilled Salesforce Developer to join our team at Qualitative Financials.Key Responsibilities:Design and develop custom Salesforce applications using Apex, Visualforce, and Lightning ComponentsIntegrate Salesforce with other systems and APIs using RESTful APIs and microservices developmentConfigure and...

  • Senior Software Developer

    24 hours ago

    Smithfield, Ohio, United States JobRialto Full time

    Job Overview:We are seeking a highly skilled Senior Software Developer to join our core team. As a key member, you will be responsible for designing and developing microservices capable of handling large volumes of data and integrating with other distributed systems in a scalable manner.You will adopt a Fintech mindset to help build modern data platforms and...

  • Java Software Engineer

    3 days ago

    Smithfield, Ohio, United States RIT Solutions, Inc. Full time

    Job SummaryWe are seeking a highly skilled Java Software Engineer to join our team at RIT Solutions, Inc. as an API Developer. The successful candidate will be responsible for designing and developing microservices that can handle large volumes of data and integrate with other distributed systems in a scalable manner.The ideal candidate will have a strong...

  • Senior Software Engineer

    4 weeks ago

    Smithfield, Ohio, United States JobRialto Full time

    Job Title: Full Stack DeveloperJobRialto is seeking a highly skilled Full Stack Developer to join our team. As a Full Stack Developer, you will be responsible for designing, developing, and maintaining our REST Web Services.About the RoleThis is a challenging and rewarding role that requires a strong understanding of software development principles, as well...

  • Senior Data Engineer

    3 weeks ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    Job DescriptionAt Fidelity Investments, we are seeking a highly skilled Senior Data Engineer to join our team. As a key member of our data infrastructure team, you will be responsible for designing and developing resilient data infrastructure for our 401k recordkeeping platform.Key ResponsibilitiesDesign and develop data infrastructure for our 401k...

  • Senior Data Engineer

    4 weeks ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    Job Description:Position Overview:We are seeking a highly skilled Senior Data Engineer to design and develop resilient data infrastructure for our 401k recordkeeping platform. The successful candidate will have expertise in Oracle and Azure technologies, with a focus on developing ETL solutions and data movement frameworks.Key Responsibilities:Design and...

  • Director, Business Solutions Architect

    4 days ago

    Smithfield, Ohio, United States Fidelity Investments Full time

    Job Description:Fidelity Investments is seeking a highly skilled Director, Business Analyst to join our team. As a key member of our operations team, you will be responsible for designing and implementing end-to-end software solutions using .NET Technology stack, SQL Server Database, Oracle Datawarehouse, Snowflake EDL, Business Intelligence Tools,...

  • Help Desk Analyst II

    3 weeks ago

    Smithfield, Ohio, United States Johnston Community College Full time

    Job SummaryWe are seeking a highly skilled and customer-focused Help Desk Analyst II to join our team at Johnston Community College. As a key member of our IT department, you will provide advanced first-level technical support to faculty, staff, and students, ensuring seamless access to technology and resources.Key ResponsibilitiesProvide courteous and...

  • Java Software Engineer

    3 days ago

    Smithfield, Ohio, United States Yoh, A Day & Zimmermann Company Full time

    Job DescriptionYoh, a Day & Zimmermann company, is seeking a skilled Java Software Engineer to join our team. As a key member of our team, you will be responsible for designing and developing cloud-based applications using Java, AWS, and other cloud technologies.Key Responsibilities:Design and develop cloud-based applications using Java and AWSCollaborate...

  • Senior Software Engineer

    1 month ago

    Smithfield, Ohio, United States JobRialto Full time

    About the RoleWe are seeking a highly skilled and experienced professional to join our REST Web Services Development Team as a Full Stack Developer. In this role, you will be responsible for designing, developing, and supporting our cloud-based applications, working closely with our team to deliver high-quality solutions.Key ResponsibilitiesDesign and...

  • Business Analyst

    1 month ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    About the RoleFidelity TalentSource is seeking a skilled Systems Analyst to work in Fidelity's Workplace Investing business unit in a dynamic agile engineering position. The successful candidate will partner with the development team and peer data scientists to design, develop, and deploy full-stack AI search and process automation solutions.Key...