*Reply to [EMAIL PROTECTED]
This is for my direct client opening for *Sr. Oracle Database Administrator
- New York, NY*. This is a *6 Months contract* position.
Overall Experience Required: 07-09 Yrs.
1. Supports the systems development process by providing logical database
design services, managing the transformation of the logical design to the
physical database, and participating in major application design reviews.
The Senior Database Administrator consults with developers on the design of
applications having complex database considerations, designs custom database
objects as required, and recommends data access solutions that best fit the
needs of the application. The Senior Database Administrator works in
conjunction with the developer and other DBA(s) to resolve database problems
during application testing and implementation.
2. Database Development - The Senior Database Administrator will use his
expertise in Database Procedural Languages (Oracle PL/SQL) to develop Stored
Procedures, Packages, Functions and Triggers as required to encapsulate and
localize/centralize business rules and process logic in the database for
more efficient code execution.
3. Database Standards Creation and Enforcement - The Senior Database
Administrator is responsible for creating and maintaining the corporate data
dictionary. The Administrator is responsible for creating and maintaining
Entity Relationship Diagrams as well as utilizing in-line, entity-level and
column-level commenting. The Administrator is responsible for defining and
enforcing naming standards and data type standards across the Enterprise.
4. Production Support - Participates in the resolution of production
problems that involve database issues. Oversees the migration of database
components between the test and production environments. Ensures the
continued cost effective performance of the database management system and
related applications. Provides ongoing support to other Operations and
Support components as needed.
5. Database System Support - Monitors database system performance in both
Development and Production environments. Researches and implements
enhancements to improve system performance. Maintains system tables
providing access to database system components. Works with other Technical
Services staff for database software installation and maintenance.
6. Environment Development - Participates in defining, implementing, and
enhancing an application development and operating environment that fosters
productivity and application quality. Develops, documents, and monitors
compliance with guidelines and standards for the use of database technology.
Conducts programming walk-through sessions to ensure compliance with
7. Data Access Support - Works with the users to evaluate requirements to
access data across various computing platforms. Installs and supports
various tools used to establish communication and data access between the
8. Architecture Support * Provides input to the IT Planning and Enterprise
Architecture Manager in analyzing, designing and *architecting* solutions to
meet internal and external process requirements from a database and
application integration perspective. This will include detailed process flow
diagrams, specifications and data mapping documentation in support of this
9. Planning and Administration - Provides input to the IT Planning and
Enterprise Architecture Manager in setting department goals and budgets as
requested. Participates and is accountable for the development of project
plans and the administration of these projects. Provides status reports.
Attends required meetings.
10. Training - Develops Database training documentation consisting of
logical/physical database design concepts, Structured Query Language (SQL)
and database optimization techniques. Provides on-going Database instruction
to the Applications Development staff, as required.
11. Database Environment - Requires in-depth Oracle9i/10g database
management system experience with advanced options, including Data Guard,
RAC, and BI. Extensive Stored Procedure, Package and Trigger experience is
required. Requires Logical and Physical Data Model and Design experience.
Familiarity with the Erwin or ER/Studio data-modeling tool is a plus.
Experience with Client/Server or Internet development environment comprising
of JSP, Java and Oracle10g AS is optimal. Ability to administer the
following is required: Oracle and Oracle OAS 10g, Oracle ID management and
Oracle Discoverer. Experience administering MySQL is a plus.
12. Database Replication/Data Transformation - Responsible for the analysis
and architecture associated with data replication between multiple SQL
Server or Oracle database servers. Experience with developing, configuration
and implementation of Data Transformation Service (DTS) packages between
database servers and environments.
13. Operating System Environment - Requires knowledge of Sun Solaris , Linux
and Microsoft Windows 2003 Server from an operating system, networking and
14. Database Backup/Recovery - Develops, implements and maintains stringent
backup/recovery processes for the development and production database
environments. Works closely with customers and Applications Development
Staff to ensure proper database recovery and backup strategies are
developed, implemented and tested. Continually monitors and improves
backup/recovery mechanisms as needed.
15. Project Management/Leadership - Responsible for the development of
Project Time and Cost estimates. Responsible for the management of computer
resources to ensure successful implementation and development of database
and data integration applications. Responsible for the on going monitoring
of Projects to ensure project timelines are met and costs are maintained
according to the estimate delivered.
Financial background is a plus. Prefer candidates with their current/last
jobs located in tri-state area.
Education Level Required: Masters Degree in Computer Science is required.
*Candidate should have the following skills and experience level:*
*Data Modeling - 04-06 Yrs.*
*Oracle DBMS - 07-09 Yrs*
*PL/SQL - 04-06 Yrs*
*Shell Scripting - 04-06 Yrs*
*Please complete the following skills-matrix and send back with your updated
*Total IT Experience:*
*Total Sr. Database Administrator exp:*
*Total Oracle9i/10g database management system exp:*
*Total exp with advanced options, including Data Guard, RAC, and BI: please
*Total Stored Procedure, Package and Trigger exp:*
*Total Logical and Physical Data Model and Design exp:*
*Total exp with the Erwin or ER/Studio data-modeling:*
*Total exp with Client/Server or Internet development environment comprising
of JSP, Java and Oracle10g: please specify*
*Total exp in Oracle and Oracle OAS 10g, Oracle ID management and Oracle
*Total MySQL exp:
Total Project Management/Leadership exp:*
*Total exp with developing, configuration and implementation of Data
Transformation Service (DTS) packages between database servers and
*Total Data Modeling exp:*
*Total Oracle DBMS exp:*
*Total PL/SQL exp:*
*Total Shell Scripting exp: *
*Daily Rate: *
*Whether is it C2C/1099/W2? *
*Day Phone #:*
*Evening Phone #:*
*Cell Phone #:*
*Have you applied recently for this requirement earlier through any one
* If you qualify for this position, are available immediately and are
interested, please send your resume, rate and contact information to
*mailto:[EMAIL PROTECTED] <[EMAIL PROTECTED]>Sr.
Database Administrator - New York, NY*
· Please ensure you complete and copy/paste the above-completed
matrix with your response
*Tel: 714-857-2002 - Ext -815*
[EMAIL PROTECTED] <[EMAIL PROTECTED]>*
You received this message because you are subscribed to the Google Groups
To post to this group, send email to email@example.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at