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.
OppenheimerFunds' success has and will continue to be driven by our greatest asset: our people. For nearly 50 years, OppenheimerFunds' employees have helped shape a winning, entrepreneurial-based culture fueled by a commitment to our shareholders and our Corporate Values of Excellence, Integrity, Team Spirit and Caring.
Job Purpose:
Located in the Centennial/Englewood area, OppenheimerFunds is hiring a Sr. Oracle DBA to support our production and development environments, tune new and existing systems and works as a part of a team developing a world-class Oracle applications.
Principal Responsibilities:
§ 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.
§ 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
§ 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.
Competencies for Success/Requirements:
§ Strong communication skills (listening, speaking, writing)
§ 5+ years experience and demonstrated working knowledge and skills in Oracle database technologies.
§ Oracle performance tuning experience
§ Experience and skills in developing applications using Oracle PL/SQL a plus
§ Cognos and/or reporting tools experience a plus.
§ Proved experience in database tuning and development support.
§ Experience with Oracle 10g, RAC and ASM
§ Experience with databases interacting with InformaticaPowerCenter™ a plus.
§ PL/SQL experience
§ SQL Tuning experience
§ Experience with UNIX scripting
§ Capacity planning experience
§ 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.
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.
Attn: Search Firm Representatives
Please be advised that OppenheimerFunds is not seeking assistance or accepting unsolicited resumes from search firms for this employment opportunity. Regardless of past practice, a valid written agreement and task order must be in place before any resumes are submitted to OppenheimerFunds. All resumes submitted by search firms to any employee of OppenheimerFunds without a valid written agreement will be deemed the sole property of OppenheimerFunds and no fee will be paid in the event that person is hired by OppenheimerFunds.