Sr. Oracle DBA, Oracle 10g (Full Time or Contract)
We are seeking a Sr. Oracle DBA to support our production and development environments, tune new and existing systems and work as a part of our DBA team. For this position we are looking for deep SQL tuning experience and the ability to support and work with developers. A development background is a strong plus.
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 Web Logic 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 and mentor to Development teams.
Qualifications
§ 10+ years experience and demonstrated working knowledge and skills in Oracle database technologies.
§ Demonstrated Oracle SQL tuning experience.
§ Intermediate to advanced experience and skills in developing applications using:
Oracle PL/SQL.
§ Cognos and/or reporting tools experience a plus.
§ Proven experience in database tuning and development support.
§ Experience with Oracle 10g, RAC and ASM
§ Experience with databases interacting with Informatica PowerCenter™ a plus.
§ 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 assure index optimization.
§ 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.
Contact: cbinder@oppenheimerfunds.com
