*Reply to [EMAIL PROTECTED] ** Hi,
This is for my direct client opening for *Sr. Oracle Database Administrator - New York, NY*. This is a *6 Months contract* position. *Job Description:* 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 database standards. 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 platforms. 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 requirement. 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 administration perspective. 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 resume.* * * *Full Name:* *Degree Major:* *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 specify* *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 Discoverer:* *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 environments:* *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 #:* *Availability:* *Current City/State:* *Work authorization:* *Have you applied recently for this requirement earlier through any one else? Y/N:* * * * 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 *Vasu* *BeyondTekIT* *Tel: 714-857-2002 - Ext -815* *Fax: 714-364-9705* [EMAIL PROTECTED] <[EMAIL PROTECTED]>* http://www.beyondtekit.com/* --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "zilliontechnologies" group. To post to this group, send email to zilliontechnologies@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/zilliontechnologies?hl=en -~----------~----~----~----~------~----~------~--~---