Oracle DBA (OCP/OCM) with PL/SQL, tuning, RMAN, Java/JDBC/ODBC, Linux and tomcat experience

IN001649  

Oracle DBA (OCP/OCM) with PL/SQL, tuning, RMAN, Java/JDBC/ODBC, Linux and tomcat experience

Location:  Raleigh, NC

Duration:  6 Months

Positons:  1

The Client  is seeking to fill a short term (approx. 6 month) contractor assignment for an Application Database Administrator. The selected candidate’s role will be to work with the development team on design, implementation and modification of application data systems, assist with the development and optimization of application data access and update requests, and manage monitor and performance tune production and development Oracle databases. This includes the systems analysis, maintenance, security, configuration, space management, database migrations, database and system tuning, database refreshes, backups and restores, and user resource management for various databases and components.

Expectations and Responsibilities will include the following:

• Design, optimize, create, modify and maintain application data systems in Oracle

• Assist developers with interactions with these data systems, including query formulation, optimization and troubleshooting

• Monitor database system details within the database

• Respond to and resolve database access and performance issues

• Monitor, optimize and allocate physical data storage for database systems

• Develop, implement, and maintain change control and testing processes for modifications to databases

• Establish appropriate end-user database access control levels

• Maintain user access privileges and the security set up of all databases

• Develop routines for end-users to facilitate best practices database use

• Respond to end-user requests for ad-hoc reports, updates and data repairs

• Work with agency staff to develop test plans and ensure successful testing and validation of all developed solutions

• Develop technical documentation that will be referenced for support of the delivered solution and subsequent enhancements

 

REQUIRED

• Current OCP or OCM certification in Oracle 9 or higher

• Expert-level ability with PL/SQL and ANSI SQL, including development and troubleshooting of queries, stored procedures, packages, triggers and data system creation and modification scripts

• Strong understanding of database structures, theories, principles, and practices

• Working technical experience with designing, building, installing, configuring and supporting database servers, including Oracle Database 11g

• Hands-on database tuning and troubleshooting experience

• Familiar with RMAN

• Proven analytical and problem-solving abilities

• Ability to effectively prioritize and execute tasks in a high-pressure environment

• Ability to conduct research into database issues, standards and products as required

• Experience working in a team-oriented, collaborative environment

• Minimum of five (5) years experience working with Oracle server 9 or newer

• Minimum of two (2) years experience as an Application database administrator working with a development team in an Oracle environment

• Knowledge of Java, JDBC and ODBC

• Excellent verbal and written communication skills; and must demonstrate

• Must be an independent self-starter having proven experience working successfully in a team environment.

Preferred

• Working knowledge of RedHat Enterprise Linux Server and Apache Tomcat application server platforms

Posted via email from innoSoul's posterous