Senior Oracle DBA
Job Requisition Number: 116304
Job Title: Senior Oracle DBA
Employment Status: Full-Time
Location:
1 Environmental Way
Broomfield, Colorado 80021-0000
External Description:
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.
SENIOR ORACLE DATABASE ADMINISTRATOR
ESSENTIAL DUTIES AND RESPONSIBILITIES
The ideal candidate will be skilled in the areas of data modeling, physical
database design, troubleshooting, performance tuning, monitoring, maintenance,
migrations, recovery methodologies and contingency options. The job will also
involve the challenge of auditing the current environments, capacity planning,
and providing best practices for the future production/development/test
environments, which may include establishing new standards and procedures.
REQUIREMENTS
o Minimum 6+ years experience supporting Production/Development Oracle databases
in a UNIX/Linux environment
o Hands-on experience with Oracle 9i and 10g
o Data Modeling, SQL, PL/SQL, UNIX Shell, PERL & JDBC programming skills
o Recovery Manager (RMAN)
o Excellent problem solving skills
o Excellent written and verbal communication skills
o Knowledge of AIX & Linux
o Embarcadero or ERWin
o OLTP/DSS
o Design and Tuning
o PeopleSoft Application DBA Experience
o Netbackup
o Clustering Solutions
o J2EE
o Persistence Solutions
o XML
o NAS/SAN
o MySQL
o SQL Server DBA Experience
COMPETENCIES
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.
------------------------------------------------------------
Data Warehouse ETL Developer
Job Requisition Number: 98555
Job Title: Data Warehouse ETL Developer
Employment Status: Full-Time
Location:
1 Environmental Way
Broomfield, Colorado 80021-0000
External Description:
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.
DATA WAREHOUSE ETL DEVELOPER
ESSENTIAL DUTIES AND RESPONSIBILITIES
o The individual will be a member of the Data Warehouse team. This team is
responsible for all development work, maintenance and 3rd tier support performed
on the Data Warehouse.
o Design, develop and maintain several different load programs in various
program languages (Ab Initio, SQR, PL/SQL). Ab Initio and PL/SQL is a must and
SQR background is a plus.
o Works with business requirements analyst to identify and understand source
data systems.
o Responsible for creating and maintaining standard development life cycle
documentation as part of all development project tasks.
o Adapts ETL processes to accommodate changes in source systems and new business
user requirements.
o Performance tune new/existing programs that load data into the data warehouse.
o Technical resource for the data warehouse and Business Analyst team.
o Work closely with other data warehouse team members and the internal
architecture group to work through scalability issues, new sourcing
architectures, and processing standards.
o Maps source system data to data warehouse models.
o Meets with DSS Data Modeler and DBA to review design strategies for new ETL
processes.
o 1st Tier nightly support on-call rotation required of all DW ETL developers
(~2 weeks daily once every other month).
REQUIREMENTS
o Minimum 2+ years proficient development background in one or more of the
following ETL tools: Informatica, Ab Initio or Data Stage. Candidates with Ab
Initio experience are preferred.
o Extensive Oracle 9i or 10g experience, specifically in the areas of
Partitioning, Index types, SQL*Loader and other Oracle storage parameters that
are useful for loading and utilizing large databases.
o 3+ years experience working with relational databases.
o 3+ years of advanced SQL use (Correlated sub-queries, Unions, Minus,
Outer/Inner Joins, Aggregate Functions, group by and having syntax). Must be
able to read Oracle Explain plans and react to adverse performance plans
accordingly.
o 1+ years experience with PL/SQL, Stored Procedures & Packages and DB
triggers.
o 2+ years experience with an ETL development tool.
o 2+ years working on various types of Unix operating systems.
o Solid background in 3GL/4GL programming languages.
o Unit test skills along with good knowledge of unit testing techniques.
o Strong troubleshooting skills.
o Working knowledge of several partitioning concepts (Hash, Round-Robin, Range,
etc.) and parallel processing depths.
o Experience working with data warehouses; understands data warehouse theory.
o Must be proficient in the Unix VI editor.
o Understands Unix File Systems, Mount Points, Directory Permissions, Soft &
Hard file links
o Must have strong Unix shell scripting skills in (KSH, Bourne or CSH).
o Industry knowledge in marketing concepts such as closed loop sourcing, data
augmentation from external sources, and campaign management processes is a big
plus.
Professional
o Strong data analysis/analytical skills
o Detail oriented, strong self-testing skills
o Enjoys working in a small team environment
COMPETENCIES
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.
