Oracle Developer III - Monitoring ETL Developer
JMA - Bothell, WA

This job posting is no longer available on JMA. Find similar jobs: Oracle Developer jobs - JMA jobs

Job Description: The IT Monitoring Solutions team is looking for an ETL developer to help bridge the gap between a flexible set of monitoring tools with diverse storage technologies, and a consolidated service metrics portal that we are developing over an Oracle database. This role will involve reviewing requirements for data presentation, and from there designing an output schema in an Oracle database, as well as designing and writing the code to populate that schema and writing the SQL for the UI layer to consume the data. It also requires clear documentation skills for the schema and code generated, and good communication skills to carry projects from requirements gathering through execution and documentation.

Primary Duties and Responsibilities:
Designs and develops internal and external business systems/applications, systems interfaces, databases, reporting, or business intelligence systems, as required to deliver new systems functionality supporting corporate business objectives

Team with and support Business and Systems Analysts responsible for completing detailed functional specifications.

Translate business and functional specifications into detailed technical specifications.

Document technical impact assessments to include details about applications impacts and resource requirements for developing and unit testing new software solutions.

Develop and unit test software solutions based on detailed technical specifications. Document detailed unit test cases and test results.

Team with Project Managers, Release Planning, Management, and other stakeholders to ensure project deliverables are completed on time, within budget, and meet or exceed customer expectations.

Conduct code reviews with peers and technical specifications reviews with project stakeholders.

Assist Test teams responsible for test environment configuration management duties. Assist Test teams with identifying, prioritizing, and correcting software solutions defects.

Document detailed implementation steps for deploying software solutions into production.

Document detailed application support documentation. Train Operations and Application Support personnel responsible for supporting new software solutions.

Assist Data Quality Analysts, Business and Systems Analysts, Business users, and Application Support Analysts with identifying, analyzing, prioritizing, and correcting production systems defects.

Minimum Required Skills / Competencies: Functional/Technical Skills:

4-6 years of experience designing and developing large-scale and complex Oracle SQL and PL/SQL

4-6 years Unix development experience.

4-6 years experience designing and developing Data Warehouse / Business Intelligence systems >= 5 Terabytes.

Oracle expertise in performance tuning concepts and practices involving large-scale complex databases:

Ability to interpret Oracle trace files

Experience with performance tuning utilities

Experience in SQL optimization techniques

Education: B.S. Computer Science or Management Information Systems or equivalent experience.

Preferred skills: Wireless and Retail Industry experience is a plus.

Sybase IQ or other columnar databases

Monitoring tools, especially HP BSM, Extrahop, Splunk, Wily

JMA - 8 months ago - save job
About this company
7 reviews
About JM&A Group For more than 30 years, JM&A Group has helped automobile dealers achieve unsurpassed levels of finance and...