ENTMATRIX is a staffing and recruiting company.
"Consultant who can work on W2
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.
a. Model databases based on a logical data structure created in conjunction with our Data Architects
b. Create the physical data models
c. Create tables, columns, etc. in support of Data Warehouse initiatives, i.e., our new Enterprise Data Model
d. Work alongside ETL and BI developers to tune COTS SQL for performance improvements
e. Create scripts to resolve data quality issues
f. Use AWR reports to help troubleshoot database issues
g. Handle data load and other Tier 2/3 production support issues."