Title: Oracle Consultant
Location: Aurora, CO
Duration: through 9/3/2014
Manager notes:
Equipment interfaces with backend systems. Build database to measure performance of the products.
DBA to monitor and manage database and create ad-hoc reporting from the database and ongoing reporting. Modifications and additions to the data fields.
DB will be in production functional and operational. DO need someone with DBA experience. Admin take lower tier on day to day responsibilities.
Expectations:
Skillset high in informatica. BI and analysis. Strong SQL
Build reports generated systematically.
Flexible enough and familiar enough with the data, so when they're called for specific data that is needed, they can deliver
Add additional fields to the database in a development environment and work with onsite IT BA/ DW team in Boca to implement
changes.
Onboarding in Boca to learn procedures with the team. Procedures are iron clad.
Oracle OBIEE---
Size of team---based in Aurora--reporting structure where they would report to Derrick Booth.
Onboarding in Boca---Spend initial time in Aurora--when it comes time to actually get into policies and procedures,
and how everything functions, they'll requested to go to Boca 1-2 weeks head down with Boca team learning everything they need
to know to come back to Aurora to be successful. Aurora mandated. Boca Raton a 5% option but they'd highly prefer a Denver
resource.
Expenses not reimburseable in relation to relocation.
Not Top Secret--Levels of clearance when dealing with government information. Clearance below secret. Cleared and able to review
information sensitive to the United States.
Description:
Senior Oracle BI DBA Assignment:
- The successful candidate will be responsible for leading business intelligence, progressive trend modeling, ad-hoc and in-depth data reporting development, and Oracle database administration
Requirements:
- Must have a minimum of 3 years Oracle DBA experience and clear understanding of Oracle Databases including current 10g/11g
- Hands on experience with Oracle BI applications/tech stack/database upgrades, cloning, patching, Catalog/Repository Migrations, and backups/recovery
- Good understanding & exposure on Storage, Network, server technology, operating systems
- Good interpersonal, communication and documentation skills
- Oracle DBA relevant experience supporting Oracle E-Business applications and Database systems in fast paced environment
- Ability to administer, troubleshoot, backup, restore, move, upgrade, patch & tune Oracle application databases
- Extensive experience with Informatica / ECL
- Experience in learning and adhering to established IT BI DW standards, policies, and procedures
Key job functions include but not limited to:
- Configuration, patching and upgrades of Oracle Core technology products Database, Application servers, Middleware and Security Management
- Support the efforts of the infrastructure planning, environments sourcing during plan, design, build, test, deployment phases
- Support performance test plan, design and execution activities
- Responsible for creating business intelligence tools, systems and reports, including design, development and management of a data warehouse environment used for analytics and reporting
- Identify opportunities to optimize the ETL environment, implement monitoring, quality and validation processes to ensure data accuracy and integrity
- Conduct or coordinate tests to ensure that intelligence is consistent with defined needs
- Synthesize current business intelligence or trend data to support recommendations for action
- Maintain and update business intelligence tools, databases, dashboards, systems, or methods
- Creating schema data models, performing ETLs and validating results with business representatives
- Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
- Work closely with the IT BI DW team to ensure that the data warehouse is tuned for optimal performance
- Responds to problems quickly and provides both short and long term resolutions
- Provides business stakeholder support including business queries and requests
Required Skills:
- Must have excellent analytical problem solving skills and be able to dig into details and summarize trends to provide critical business intelligence
- Working knowledge of Oracle development tools and languages such as PL/SQL, and SQL Plus
- Experience working with project stakeholders to define business enhancing strategy modeling and reporting, design, develop and maintain business objects, universes, and reports
- Advanced interpersonal skills and primary business objectives success driven motivational desire to take initiative in building ongoing relationships with key business project stakeholders to define reporting and information needs, and develop intuitive reports to meet those needs
- Experience with building data models necessary for enterprise data management and reporting encompassing conceptual, logical and physical models
- Substantive experience using Oracle OBIEE and designing dimensional databases (e.g. star schemas)
- Excellent SQL skills; comfortable using a data access tool such as Toad or SQL Workbench
- Detail-oriented and results driven
- Demonstrate excellent understanding of Oracle ERP application's architecture, data structures and functionality
- Experience with on-going maintenance of the data models and metadata
- Experience with source system analysis and data maps linking source and target systems
- Experience with hands-on technical support for solution development and deployment
- Experience and desire to participate as appropriate with project team and key Business executive stakeholders to define requirements and solutions
- Extensive experience with relational database management systems; Oracle Server preferred
- Significant experience with data modeling tools
- Significant SQL development experience
- Experience interfacing data from multiple systems using both message-based and batch ETL methods
Qualifications-Education and Experience Required:
- Bachelors' degree in Business, Accounting, or Business Information Systems preferred
- 4 - 7 years BI and data analytical skills
- Solid business analyst and requirements definition skills
- Experience with data modeling/architecture for BI
- 5 – 7 years Business Objects development experience required
- Oracle DBA experience
Strong SQL querying skills Skills/Qualities Required:
- Great attention to detail
- Effective communicator with all audience levels: field level technicians up to executive VPs
- Effectively modifying granular detail level in communications based on the audience
- Excellent interpersonal skills
- collaborative self-starter
- Ability to problem-solve with positive results
- Able to relate well with both business and technical sides Non-technical skills essential for this assignment:
- Bachelor's degree at a minimum is highly desirable for this position
- Excellent written and verbal communication skills are required
- Willingness to help where needed, to be flexible with work assignments, and to understand and assist with the diversity of user requests
- Strong analytical, organizational and prioritizing abilities
- Excellent customer service and problem solving skills are also required
- Must be prompt, courteous and a good listener
Regards,
Shankar
248-522-6879
Technology consultanst inc
You received this message because you are subscribed to the Google Groups "ASP._NET_jobs" group.
To post to this group, send an email to asp_net_jobs@googlegroups.com.
To unsubscribe from this group, send email to asp_net_jobs+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/asp_net_jobs?hl=en-GB.
No comments:
Post a Comment