Closing Date: 2/14/2012 5:00 PM
Category: Computer Systems Analysis Services
From Date: 3/1/2013 To Date: 2/28/2014
Logic House is seeking to fill a short term (6 month maximum) contractor. The primary responsibility of this position is the administration of the agency's Oracle databases. Duties include all database administration and database design activities as they apply to Oracle, and the ability to work in a project-based, team-oriented environment.
Knowledge, Skills, and Abilities Requirements:
•Minimum of (7) years of recent experience as an Oracle Database Administrator in a 24x7 Solaris environment; skills with Oracle Enterprise Edition RDBMS 10g and 11g.
•Expert with installation, configuration, and patch management of Oracle 10g and 11g; SQL (DML and DDL) and PL/SQL; assist development staff with writing PL/SQL Stored Procedures, Functions, and Packages; Ability to create/replace insert/update/delete triggers.
•managing and implementing database/schema changes, including creating/altering tables, constraints, indexes, grants, and sequences; able to write DDL and DML via command line tools (SQL*Plus, Toad, etc.) as well as GUI tools (OEM, Oracle SQL Developer, etc).
•Oracle Recovery Manager (RMAN) via both the command-line and OEM;Oracle Automatic Storage Management (ASM)(10g and 11g); Oracle Enterprise Manager (OEM) Grid Control (10g and 11g); Oracle Data Guard.
•Quest Software TOAD for Oracle (including DBA module).(TOAD Team Coding is a plus).
•Database change control; coordinate and implement database/schema changes to various environments (Development, Test, Training, QA, and Production).
•Coordinate and implement schema changes to various environments (Development, Test, Training, QA, and Production).
•Assist various projects with performance tuning PL/SQL Stored Procedures and SQL statements. Experience using Explain Plan •Ability to assist other teams in stress-testing applications, locating bottlenecks, and recommending solutions.
•Willing to provide after-hours support.
•Excellent interpersonal communication skills.
•Experience with Oracle Real Application Clusters; UNIX commands and shell scripting and Solaris 10; database/schema design and data modeling tools; CA ERwin (7.x or higher); scheduling and propagating messages to/from legacy systems via Oracle Advanced Queuing and Oracle Message Gateway;and SAN environments.
About Logic House Ltd:
Logic House Ltd., was incorporated in the Commonwealth of Pennsylvania in 1990. It is a small business which provides a comprehensive range of management and technical services for the development of information systems. Logic House has experienced continuous growth, due in large measure to our history of successful service engagements. Operating from Pennsylvania and California, Logic House has earned a reputation for providing quality professional services in a timely and cost effective manner.