Senior Data Engineer - Oracle Application DBA

Senior Data Engineer - Oracle Application DBA Fidelity Investments - 4.0 Salt Lake City, UT Job Details 19 hours ago Qualifications Data model design Performance tuning Computer science Data replication Azure Bachelor's degree in information technology Computer Science Continuous Delivery (CD) implementation Data modeling projects Query plan analysis Bachelor of Science UNIX Configuration management Public Cloud Enterprise software support Schema design Database server management Collaboration with product development teams AWS Analysis skills Bachelor's degree Application design Query execution time improvement Developing automated testing protocols Scalability Application Maintenance DevOps automation Senior level PL/SQL Bachelor's degree in computer science

Full Job Description Job Description:

Note:

Fidelity will not provide immigration sponsorship for this position. Senior Data Engineer - Oracle Application DBA The Role Fidelity Investments is looking to hire a Senior Data Engineer - Oracle Application DBA providing frontline Production support for our Development, Test, and Production environments. This position offers you the opportunity to be responsible for the creation and ongoing support of database infrastructure for multiple Fidelity business units and development teams. Key database platforms required to be successful in this role will include but not be limited to Oracle, SQL Server and Postgres. We are looking for top talent with strong troubleshooting skills as a crucial skill for this role. This role requires the participation in an on-call rotation. The Expertise and Skills You Bring Experience performing Oracle 19c database administration for high availability systems, within the financial services or similar industries. Experience with Microsoft SQL Server BS in Computer Science, Information Technology or related degree, or equivalent experience Perform applications database administration (Oracle, Postgres, and SQL Server) services including SQL code review, database performance analysis and optimization, query tuning, database application design, physical data modeling, development support & data engineering. Proven analytical, data mapping, and problem-solving abilities with strong judgment, issues management and process analysis skills. Proficiency in SQL and PL/SQL language Proven experience analyzing and implement database technology infrastructure solutions with minimal direction. Technical curiosity to fix and resolve technical issues quickly. Proficiency in Scripting languages and Unix Shell Scripting. Basic proficiency of programming languages (Python) is preferred. Expertise with Oracle Golden Gate, database replication and data movement strategies & tools Experience with 24/7 Production Enterprise support Familiarity with Public Cloud environments, preferably AWS and Azure. Experience with Oracle system as well as Application DBA support functions. Resolve issues that arise in day-to-day management of RPA/UDA program and provide timely responses and solutions as required Communicating at a business function level with technology personnel in both verbal and written communication Collaboration with developers, system administrators, and Application support engineers, participating in cross-functional teams and projects Deep understanding of Oracle database connectivity (Sqlnet, listeners, scan listeners, tnsnames) Advanced Continuous Integration & Continuous Delivery (CI/CD) practices including software configuration management, test automation, versioning. Provide knowledge leadership for development teams in terms of scalability and database growth, making recommendations for hardware and software upgrades The Team As part of the Advanced Process Solutions (APS) team you will work with teams that develops software which supports work flowing through and between Fidelity business units. Our software helps move work through Fidelity, providing a link between multiple coordinated applications that services Fidelity's customers.. Our team manages the databases used for both developing and supporting the software for the business units.

Certifications:

Category:

Information Technology Please be advised that Fidelity's business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.