Principal Database Developer

4 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, stored procedures, triggers, tables, and views
  • Write complex queries to retrieve data using SQL/PLSQL and Native Stored Procedures (NSPs) on DB2 Database
  • Perform ETL operations using Informatica according to Agile methodologies and CI/CD
  • Build complex data transformation workflows and procedures with Azure Cloud-based Oracle, on-prem Oracle, SQL Server, or DB2 Databases
  • Implement data storage designs using normalized forms and denormalized forms
  • Define system architecture and component interaction functionalities using Unified Modeling Language (UML)
  • Perform maintenance activities, including gathering statistics, analyzing database objects, and conducting data profiling and data mappings
  • Conduct database performance tuning of complex Oracle PL/SQL queries

Requirements:

  • Bachelor's degree in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field
  • Five years of experience as a Principal Database Developer (or a closely related occupation) developing data solutions using Oracle
  • Or, alternatively, Master's degree in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three 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
  • Experience with ETL operations using Informatica and CI/CD
  • Knowledge of data storage designs using normalized forms and denormalized forms
  • Experience with database performance tuning of complex Oracle PL/SQL queries

Why Join Fidelity:

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.

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.

  • 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 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...

  • 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...

  • 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

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

  • Database Systems Administrator

    12 hours 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...

  • Salesforce Developer

    2 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...

  • Java Software Engineer

    2 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

    3 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

    2 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

    4 weeks 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...

  • Business Analyst

    2 weeks ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    Job Title: Systems AnalystFidelity TalentSource is a leading provider of temporary staffing solutions for Fidelity Investments, a global financial services firm. We are currently seeking a skilled Systems Analyst to join our team in the Workplace Investing business unit in Smithfield, R.I.The RoleWe are looking for a highly motivated and detail-oriented...

  • Software Engineer in Test Specialist

    4 weeks ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    About the RoleFidelity TalentSource is seeking a skilled Software Engineer in Test to join our team. As a key member of our QA team, you will be responsible for ensuring the quality and reliability of our software applications.Key ResponsibilitiesContribute to the development and implementation of our QA automation strategyWork collaboratively with...

  • Software Engineer in Test

    2 weeks ago

    Smithfield, Ohio, United States Fidelity TalentSource LLC Full time

    About the RoleFidelity TalentSource is seeking a skilled Software Engineer in Test to join our team. As a key member of our QA team, you will be responsible for ensuring the quality and reliability of our software applications.Key ResponsibilitiesContribute to the development and maintenance of our QA automation strategyWork collaboratively with engineering...

  • Data Analyst

    3 days ago

    Smithfield, Ohio, United States Pyramid Consulting Full time

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Pyramid Consulting, Inc. in Smithfield, RI. This is a 15+ months contract opportunity with long-term potential.Job Summary:The successful candidate will have a strong background in data analysis, SQL, and ETL tools. They will be responsible for analyzing and interpreting...