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.
We seek a Sr. Oracle DBA to support our production and development environments, tune new and existing systems and work as a part of a team developing world-class Oracle applications.
This is a development DBA position, so experience developing with PL/SQL is a plus.
*Preferred method of hire for this position is Contract-Hire (W2).
Job Functions/Duties
* Production support of databases that support the enterprise. Production on-call rotation is required.
* Ongoing and proactive performance tuning of existing and new database applications. Recommend DBMS configuration changes to optimize server performance, implement cache, buffer pool, and configurable memory structure options for DBMS.
* Working collaboratively with agile development teams to tune the Oracle database as a part of the entire application stack. Experience with BEA WebLogic or web technologies a plus.
* Contribute substantially to the system architecture, and take ownership of the design and development of new Oracle database environments.
* Establish coding standards for PL/SQL, 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.
Qualifications
* 10+ years experience and demonstrated working knowledge and skills in Oracle database technologies.
* Experience with Oracle 10g, RAC and ASM
* Proven Oracle performance tuning expertise.
* Intermediate to advanced experience and skills in developing applications using:
Oracle PL/SQL.
* Cognos and/or reporting tools experience a plus.
* Prior development support.
* Experience with databases interacting with Informatica PowerCenter* a plus.
* SQL Tuning experience
* Experience with UNIX scripting
* Capacity planning experience
* Strong communication skills (listening, speaking, writing)
Additional Skills required
* 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 ensure 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.
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.
