Senior Data Engineer - Oracle Application DBA
About The Position
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.
Requirements
- 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
- 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.
- Experience with 24/7 Production Enterprise support
- Experience with Oracle system as well as Application DBA support functions.
- 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.
Nice To Haves
- Basic proficiency of programming languages (Python) is preferred.
- Expertise with Oracle Golden Gate, database replication and data movement strategies & tools
- Familiarity with Public Cloud environments, preferably AWS and Azure.
Responsibilities
- 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.
- 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
- Provide knowledge leadership for development teams in terms of scalability and database growth, making recommendations for hardware and software upgrades
Benefits
- Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
Associate degree
