Friday, May 06, 2011

ClickBank - Oracle Data Warehouse Development DBA

JOB TITLE: Oracle Data Warehouse Development DBA
REPORTS TO: Data Warehouse Team Lead

ClickBank® is an online marketplace for digital information products that allows individuals and businesses to attract the customers they can’t find anywhere else online, and provides affiliate marketers with secure ways to be successful and profitable. With more than 46,000 digital products and 100,000 active affiliate marketers, ClickBank provides services in more than 200 countries around the world and is consistently ranked as one of the most highly trafficked sites on the web.

ClickBank has an opening for an Oracle Data Warehouse Development DBA in our Broomfield, Colorado office.


Job Summary: This position is an Oracle Development DBA that is part of the data warehouse development team to provide hands-on database and schema development, ETL performance tuning, evaluate and plan for future database environments, and administration of development and QA database instances. Activities to include schema and database maintenance, instance and query performance tuning, creation of data migration and archiving strategies and development of scripts and ETL jobs as needed to meet the data warehouse strategy.





KEY RESPONSIBILITIES INCLUDE, BUT ARE NOT LIMITED TO:



· Work with our Architect and ETL team members in the design, development, and ETL warehouse strategy

· Help maintain Data Warehouse strategy and ETL efficiencies for optimal reporting through Micro Strategy

· Query tuning

· Instance tuning

· Storage capacity and resource planning

· Bring new Oracle instances online

· Implement replication strategy between primary and reporting Oracle instances

· Work closely with the Production DBA to support daily operations including job monitoring and troubleshooting of the data warehouse environment

· Securing the data stored within the data warehouse

· Coordinate with production DBA activities related to data planning and recovery

· Work closely with other data warehouse team members to develop ETL jobs as needed





QUALIFICATIONS AND MINIMUM REQUIREMENTS:



· Must have minimum of 3 years Oracle DBA experience

· Must have a minimum of 5 years writing and tuning SQL queries

· Must have experience working in a data warehouse environment

· Must have production database instance tuning experience

· Must have production database backup and recovery experience

· Must have experience in logical and physical data modeling

· Must have ability to understand and debug Java code

· Must have ability to work in a team environment yet be self directed, proactive, and action oriented

· Must have excellent diagnostic and troubleshooting skills

· Must be willing to take on challenging assignments

· Must have strong verbal, written and organizational skills

· Must have experience writing Unix shell scripts

· 4-year college degree in Information Systems or Computer Science or comparable IT experience





PREFERRED SKILLS:


MySQL DBA and tuning experience
ETL job tuning experience
Java development experience
Talend Open Integration Development ETL experience
Oracle 11G RAC experience
NetApp Snap Manager for Oracle experience
Knowledge of version control systems, preferably Subversion
HaDoop experience is a plus
NOSQL database experience is a plus
ActiveMQ experience is a plus
Experience with Agile methodologies is a plus





EDUCATION:



· 4-year college degree in Information Systems or Computer Science or comparable IT experience



EXPERIENCE:



· Minimum of 3 years Oracle DBA experience

· Minimum of 5 years writing and tuning SQL queries

· Minimum of 3 years data warehouse experience





JOB CONDITIONS / WORK ENVIRONMENT:



The work environment characteristics described here are representative of those an employee encounters while performing the essential functions ofthis job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.


Job performed at a desk in front of a computer.
Requires heavy use of keyboard and mouse.
Requires sitting for long periods of time.
Casual work environment.


ClickBank offers excellent compensation and benefits packages. Qualified applicants should submit resumes to jobs@clickbank.com.


ClickBank is an Equal Opportunity Employer.