We are seeking an Oracle DBA. The ideal candidate will be working on the development and implementation of modifications and enhancements to the Financial Data Warehouse. This position will perform the duties of database development and will perform advanced database development tasks for databases used by an application with complex data models, workflows, and reports. May be required to create new logical and physical data models. The role will involve working with Oracle databases.
Location:
Responsibilities:
- Optimize database performance during and after migration, identify and resolve performance bottlenecks, and implement monitoring solutions to track database health and performance metrics.
- Will work on activities including, but not limited to the design, development, and testing of new tables, views, PL/SQL stored procedures and functions, and necessary loaders to support the project news.
- Will develop and test Linux shell scripts to invoke database calls.
- Will develop and test scheduled jobs and shell scripts.
- May perform performance tuning of new and existing tables, views, PL/SQL code.
Mandatory Qualifications:
- Experience in Oracle database design, analysis, and performance tuning
- Experience in Oracle database structures and data analysis
- Experience designing enterprise applications and/or services
- Experience creating technical and functional design documentation
- Experience within software development lifecycle using Agile methodology – (Scrum, for example)
- Experience with multi-tier system/application development – (SOA, Microservices, 3-Tier applications, for example)
Preferred Qualifications:
- Jira experience
- Oracle Certification
- Experience with data warehouse applications and/or database reporting features