Database Developer/Oracle DBA Developer
MTA
12 months
Negotitable
Midtown NYC
SUMMARY OF THE FUNCTION/ROLE
MTA IT requires an experienced consultant to perform various aspects of Oracle database administration encompassing design of database objects, establishment and maintenance of a suitable development environment, coordination with application developers, design and implementation of external data interfaces and support of both development and production databases.
RESPONSIBILITIES
Design database architecture
Document all aspects of objects within database architecture
System test of application
2
Version 9/21/16
Support desktop development and interfaces as needed
RISKS
The work setting is an office environment. Minimum risk will be exposed for this position.
DELIVERABLES & DUE DATES
ERD, Data Dictionary and documentation supporting test plans are required during various
phases of development according to the project timeline
Documents are needed as draft at the end of systems testing and final version upon completion
of UAT
QUALIFICATIONS EXPERIENCE & EDUCATION
1) Skills in Oracle database administration, design and programming directed mainly toward
support of application development. Included in particular are:
• Expertise in Oracle and generic database techniques and practices; currency in Oracle
releases, patches and compatibility issues.
• Understanding of Oracle security, synonyms, permissions and grants.
• Experience in database design, creation and debugging of stored procedures and triggers,
indexes, queries, views, timed as implemented using Oracle 10g.
• Skills in data manipulation into and out from Oracle tables, including import to, export
from diverse external structures, creation and support of interfaces with both Oracle and
non-Oracle databases
• Knowledge of ERD database design software and the TOAD database development tool.
• Familiarity with client-server applications and Windows ODBC in the context of
establishing and supporting connectivity and database interaction with Oracle.
• Ability to assist and support web based PHP and .NET application development and
maintenance.
2) Skills in all phases of project / application design, development, testing, quality assurance and
implementation. This includes familiarity with modification of existing applications and
response to mid-course corrections and changes in project requirements.
3) Ideally, the candidate will possess some understanding of railroad terminology and practices
•
Last updated on Mar 14, 2018