| Job Description |
seeking a senior Oracle data warehouse engineer who
will supervise the design and delivery of a data warehouse product
. This resource will work closely to develop a high-performance, heavily-loaded data warehouse based on Oracle RAC, which will service analytical queries for
operational and marketing needs, with the possibility of future
expansion of scope. The warehouse may have complex needs for storage
of historical data and updating of data.
KEY RESPONSIBILITIES
--------------------
* Design and implement a data warehouse for Comcast.
* Assist in the design and development of the ETL system for
loading data into the warehouse.
* Analyze, design, recommend and implement the optimization
strategy for the data warehouse, including:
* Indexes
* Denormalization strategy
* Partitioning strategy
* Assist in designing and reviewing the design of the warehouse
data model, and implement the design that is developed.
* Write all database software to support the data warehouse,
including:
* PL/SQL procedures,
* Triggers,
* Periodic processes, and
* Other software support as needed.
* Work with other programming resources to facilitate any
software development external to the database.
* Work with end customers to design and optimize analytical
queries within Conrep.
* Assist the DBA in the development and implementation of the
data warehouse's storage policy.
* Create and maintain documentation on the development
internals and operation of all products that are developed.
* Other functionality as required.
KEY QUALIFICATIONS
------------------
* Minimum 3 years experience with Oracle data warehouses,
preferably data warehouses in excess of 1 TB, including:
* Experience designing and implementing ETL strategies for
data warehouses
* Experience designing and optimizing queries against data
warehouses
* Minimum 5 years experience writing Oracle PL/SQL software,
including PL/SQL procedures, functions, packages and triggers.
* Background in a consultative and contract environment
preferred.
* Experience working in small teams in a fast-paced environment.
* Undergraduate degree in a computer-related field or equivalent
experience.
* Knowledge of software architecture and design patterns.
* Experience with complex SQL for data extraction.
* Ability to write technical and business documentation. A short
writing sample should be included in your application.
* Experience with source code control systems, in particular
Subversion.
KEY TECHNOLOGIES
----------------
* PL/SQL
* Oracle 10g (10.2.0.3)
* Oracle RAC, RMAN, DataGuard, and Veritas/SAN technologies
* Subversion source code control system.
Creates Python applications to automate the retrieval,
transformation, and storage of data, to automate basic system
administration or maintenance tasks, and to deliver additional
functionality as required. Takes general direction from project
manager and implements necessary application source code. Familiar
with test-driven development approach and rapidly iterative
development life cycles. Works with other team members and uses
version control to track changes to application code. Capable of
basic system administration tasks required to install Python and
related applications in a Linux environment. Acts as subject matter
expert for Python applications development.
Key qualifications:
* Minimum 3 years experience building, deploying, and maintaining
Python applications preferably with experience in multi-tier Oracle
environment.
* Background in a consultative and contract environment preferred.
* Experience working in small teams in a fast-paced environment.
* Undergraduate degree in a computer-related field or equivalent
experience.
* Knowledge of software architecture and design patterns.
* Experience with complex SQL for data extraction.
* Ability to write technical and business documentation. A short
writing sample should be included in your application.
* Experience with source code control systems, in particular
Subversion.
Job requirements:
* Participate in planning/design meetings with team. Determine
appropriate application design for requirements presented.
* Install and upgrade Python and third-party libraries.
* Respond to application failures, troubleshoot problems, and
respond with mitigation plan.
* Deploy Python code in production environment.
* Document application operational tasks and key technical
decisions.
* Other development activities as needed.
Key technologies:
* Python (and object-oriented development)
* SQL, particularly for Oracle, particularly for RAC
* Interprocess communication, particularly via sockets
* Subversion source code control system.
|