We are seeking a development DBA who has worked with Exadata previously. This person will help model databases based on a logical data structure created in conjunction with our Data Architects. Will also help create the physical data models, create tables, columns in support of Data Warehouse initiative. Will work alongside ETL and BI developers to tune COTS SQL for performance improvements, create scripts to resolve data quality issues and use AWR reports to help troubleshoot database issues.
Maintain and enhances legacy Oracle databases in support of production break fixes and application enhancements.
Works as part of a development team to perform the database tasks related to application enhancements, such as creating new tables and/or columns, writing and tuning PL/SQL, SQL scripts and stored procedures and debugging production database issues.
Builds and unit tests database scripts and works with Configuration Management to ensure the builds are successfully and accurately promoted to the QA environment for testing and then to the production environment.
Responsible for designing and building Oracle databases that comply with existing database standards and established design patterns.
Troubleshoots Oracle database issues and optimization issues using AWR reports and Explain Plans.
Performs work that is complex and varied in nature.
Must have good communication and teaming skills.
Must be a self-starter and be able to work independently or as part of a development team.
May provide guidance/training to more junior staff. Database Design Database Modeling SQL, PL/SQL SQL, PL/SQL tuning for performance Requires technical and business knowledge in multiple disciplines/processes.
Typically possesses 5 to 7 years of relevant work experience.