Monday, January 03, 2011

OppenheimerFunds - Oracle DBA

OppenheimerFunds, Inc. has been helping investors achieve their financial goals since 1960.
We are one of the nation's largest and most respected asset management companies.

Principal Responsibilities:
On-going database administration * development and production support
Contribute substantially to the system architecture, and take ownership of the design and development of the data warehouse architecture
Establish coding standards for PL/SQL, ETL, Java, JDBC, stored procedures, triggers, and logical and physical schema design, and enforce them within the development staff
Participate in design and code reviews, documentation of design, and implementation of methodologies to ensure high quality software
Work as member of a DBA team responsible for maintaining database stability
Provide support to Development teams
Assist IT management with administrative policies and procedures related to technical problem resolution and priority management that relates to system support and maintenance
Recommend to IT management changes to database design to improve process throughput and ensure performance as identified above.
SUN Solaris OS Tuning and Management
EMC SAN Experience
3+ years previous experience in administering an Oracle Database Data Warehouse
3+ years experience in a 24x7 HA environment a must
Oracle PL/SQL programming
Additional Skills required
Database performance-tuning skills to record DBMS activity and identify bottlenecks
Recommend DBMS configuration changes to optimize server performance, implement cache, buffer pool, and configurable memory structure options for DBMS
SQL performance tuning skills to record query/procedure execution frequency, and execution plans, identify poorly performing queries, guide developer in rewriting SQL to reduce IO and CPU cost and assure index optimization
Software, patches, and patch set installation skills
Database security skills to design controls and monitoring capabilities for user access
Working knowledge of Partitioning, Materialized Views, Bitmap Indexes, and Parallel Execution
Experience with database replication to design and implement Oracle replication using trigger-based or event methodology using such tools as export, import, database links, Advanced Replication, Data Guard, or other third party tools


Competencies for Success/Requirements:
Three years of Oracle data warehouse DBA experience
Experience with Oracle 10g, RAC and ASM
Experience with databases interacting with Informatica PowerCenter*
PL/SQL experience
SQL Tuning experience
Experience with UNIX scripting
Capacity planning experience
Oracle performance tuning experience
Strong communication skills (listening, speaking, writing)

OFI Core Competencies

Leadership and Communication
Focuses on performance improvement; identifies opportunities for change and innovation; addresses conflict; does not place self before others; accepts ownership and accountability; inspires trust; fosters open communication.

Planning and Execution
Drives for results; follows through on commitments; aligns, plans, develops and deploys coherent goals; Provides consistently high levels of customer service.

Business Insight
Possesses broad understanding of financial services; effectively uses technology.

Personal Credibility
Is interpersonally savvy; clearly communicates; continuously learns and grows; develops self; grasps development opportunities; breaks out of silos; listens to others; has track record of consistent success and resilience.

Corporate Values
The candidate must be comfortable with continuous change and demonstrate commitment by abiding to OFI*s Corporate Values:

1. Excellence
2. Integrity
3. Team Spirit
4. Caring

OppenheimerFunds is a thriving organization which provides a positive work environment, professional challenges, competitive compensation, and work/life balance.

Please visit us at www.oppenheimerfunds.com to learn more about our company and career opportunities.