Title: Data Warehouse Night Support Analyst
Skills: Data Warehouse, Tier II Application Support, UNIX, Shell Scripting, Oracle, SQL
Date: 9-19-2007
Location: Broomfield, CO
Area code: 303
Tax term: FULLTIME
Pay rate: DOE
Length: Full Time
Position ID: 99455
Dice ID: corpexp
Job description: DATA WAREHOUSE NIGHT SUPPORT ANALYST
Job Requisition Number: 99455
Friendly Atmosphere; Competitive Salaries; Environmentally Conscious; Opportunity to Develop and Advance...Corporate Express is a place where technology melds with an innovative business strategy, a place of excitement, vision, integrity and dedication to a higher standard.
Corporate Express...opportunity in your hands!
Let's face it...EVERY business needs some level of office product and service support to run efficiently. What makes Corporate Express unique? Our broad product offering addresses our clients' requirements for an office to run smoothly. From office set up through daily office and facility supply maintenance, we position our clients for success by permitting them to focus on what's most important to their business. Our global presence, ease of online purchasing, competitive pricing and hands on approach to working with our customers sets us apart from our competitors.
Please apply online:
http://recruiter.kenexa.com/corpexp/cc/CCJobDetailAction.ss?command=CCViewDetail&job_REQUISITION_NUMBER=99455&ccid=bupJEdUjsTs%3D
ESSENTIAL DUTIES AND RESPONSIBILITIES
o Monitor automated system alerts, log files, and other Data Warehouse monitoring tools.
o Troubleshoot and resolve DW scheduled job failures, striving to meet established SLA's.
o Research problem tickets to resolve data, setup, code issues, and implement processes to prevent repetitive issues.
o Provide detailed report of nightly activities, as well as communicate timely updates when there are issues with the Data Warehouse or Apollo scheduled jobs.
o Maintain and improve performance, reliability and monitoring of all Data Warehouse systems; applications including Ab Initio, Apollo, Maestro, customized open-source components (Apache / Tomcat) and other 3rd Party vendor applications.
o Interact with Tier I support, other Application Support teams, as well as Operations and Development groups.
o Work on projects to better improve Apollo and DW Support model.
o Cross train with members of the Business Intelligence Operations team to provide nightly support and perform production fixes to the Apollo application
REQUIREMENTS
o 2+ years experience in a Tier II Application Support role, or equivalent.
o 2+ years of Unix experience, including VI editor and basic OS command structures to navigate many distributed systems.
o Knowledge of Unix Awk, shell scripting
o 2+ years of experience with Oracle or a similar RDBMS and supporting environments for large databases.
o 3+ Years of SQL and a good understanding of Explain Plans and Oracle database hints for improving on the fly query performance while troubleshooting.
o Excellent diagnostic, debugging, and problem solving skills.
o 1+ years working with a batch-scheduling tool such as Maestro, Autosys, or Control M.
o Understanding of servers, networks, security, client/server model.
o Ability to communicate with various levels of technical experience
(developers/ operations/ end users/ support staff).
o Ability to work in team environment.
o Must be self-directed, proactive and action oriented.
o Familiarity with Windows and MS Office Suite.
DESIRED SKILLS:
o 4-year college degree in IS or related field.
o Development/ programming experience.
o Knowledge of ticket tracking systems such as Remedy.
o Experience with ETL languages such as PL/SQL, Informatica, Ab Initio, or Pro*C, as well as Oracle, Export/Import, and Toad or SQLPLUS within Data Warehouse production environments.
o Basic understanding of Data Warehouse architectures and concepts.
o Experience with BI Tools including MicroStrategy.
o Experience with Data Warehouse appliances including Netezza.
EDUCATION
o Bachelor's degree in Computer Science or related technical field and/or equivalent combination of education, training, and experience.
Corporate Express is an Equal Employment Opportunity/Affirmative Action employer that promotes work force diversity and hires without regard to race, color, religion, national origin, age, gender, marital status, disability, sexual orientation, veteran status or other protected status.
Travel required: none
Telecommute: no
