Application Development Specialist Levels 1-6, Oracle DBA

19 Apr 2024

Vacancy expired!

Description Job Title:

Application Development Specialist Levels 1-6, Oracle DBA

Salary Range:

Level 1 -

$67,449 - $94,429

Level 2 - $72,119- $100,966

Level 3 - $76,088 - $106,523

Level 4 - $82,781 - $115,894

Level 5 - $89,941 - $125,918

Level 6 - $96,634 - $135,288

Hay Points:

Level 1 -

282

Level 2 - 342

Level 3 - 393

Level 4 - 479

Level 5 - 571

Level 6 - 657

Dept/Div: MTA Information Technology/IT Product Management

Supervisor:

Product Manager Public Address Systems

Location:

2 Broadway and other locations as required

Hours of Work:

9:00 AM -5:30 PM (7.5 hours/day) or as required

This position is eligible for telework which is currently one day per week. New hires are eligible to apply 30 days after their effective date of hire.

The selected candidate will perform information technology functions related to the development and maintenance of the MTA's complex and mission critical Public Address and Train Control Systems in Rail Control Center: primarily PACIS but also ATS. The candidate will prepare and coordinate system deliverables for various products such as database. The candidate will perform programming, system analysis, troubleshooting, testing; modify system configuration settings; develop interfaces, prepare ad-hoc SQL queries/reports and investigate/address time sensitive production issues. The position will require supporting critical Public Address and Train Control Systems for NYC Subway that are located mainly in the RCC on a 24x7 basis. The candidate will adhere to MTA-IT standards and work with vendor teams to ensure compliance to those standards. The candidate will work in all life cycle phases from acquisition to maintenance.

The purpose of this position is to manage and maintain legacy Oracle 10g databases in a RAC environment and migrate them to an intermediate Oracle 12c environment and eventually to Oracle 19c and beyond. The selected candidate must be able to manage network storage for the databases, quickly diagnose anomalies, and return the databases to operational status after a hardware or software failure.

Level 1
  • Develops, codes, and configures programs from clear specifications to meet business requirements.
  • Provide analysis to ensure adherence to application/system specifications
  • Document operating and maintenance process and procedures for analysis and review.
  • Perform system diagnostics and maintenance for system health check evaluation.
  • Develops tests programs to validate and verify application functionality.
  • Prepares documentation of system functionality to aid in user training and development.
  • Develops detailed flowcharts to show program processing logic.
  • Performs daily database system health checks to ensure uninterrupted availability.
  • Provides off-hours, on-call support as needed.
  • Troubleshoots database errors and other problems to resolve immediate issues.
  • Performs backups and restores of critical database data. Replicates database schema and data to Disaster Recovery (DR), test, and training environments. Must be proficient with RMAN and other Oracle file maintenance utilities.
  • Develops SQL Scripts to perform mass item changes or other enhancements as required.
  • Reviews, tests, and approves SQL Scripts written by Software Developers to ensure they are safe to execute in the production environment.

Level 2

Same as Level 1 with the following additional responsibilities:

  • Under guidance, analyzes, debugs, and troubleshoots production system's operational issues.
  • Provides on-call operational support for production systems.
  • Interfaces with business analysts, vendors, and/or clients to clarify requirements.
  • Contributes to post-implementation reviews to ensure requirements are met.
  • Provides ongoing support and troubleshooting for database issues including those escalated from more junior colleagues.
  • Monitors Oracle Streaming utility and rebuilds/resets as needed.
  • Proactively monitors Oracle RAC environment and troubleshoots issues as they arise.
  • Writes documentation that describes installation and operating procedures to aid in user training and troubleshooting issues.

Level 3

Same as level 2 with the following additional responsibilities:
  • Document operating and maintenance procedures and assist in troubleshooting of complex issues.
  • Contributes to the development of test plans and participates in post-implementation reviews to ensure requirements are met.
  • Participates in systems design, working within an established framework to maximize system efficiency.
  • Coordinates with clients and colleagues to identify and resolve system issues
  • Resolve systems issues and advance development projects. May develop materials to support user training on new or revised systems/applications.
  • Proficient at working with Oracle Technical Support to open and manage support incidents; must be able to clearly and properly describe troubles, locate and supply appropriate logs and other files to vendor.
  • Performs capacity analysis and planning for databases on file to ensure sufficient resources are available to hold needed data.
  • Implements change management/change control processes to improve database performance.
  • Implements Oracle Golden Gate in intermediate Oracle 12c environment; research/suggest future use of other Oracle utilities.
  • Works closely with developers, support, and QA teams to design and optimize all DB environments.

Level 4

Same as level 3 with the following additional responsibilities:
  • Participates in the analysis of production systems/applications to determine how applications and processes can be improved.
  • Monitors the operating efficiency of existing application systems and provides (or arranges for) proactive maintenance to prevent application or system issues.
  • Reviews, analyzes, and modifies systems, including encoding, testing, debugging, and installing for a large-scale system. Maintains records to document the system and revisions.
  • Provides and/or arranges for technical support and problem resolution for client inquiries and to resolve production issues.
  • Participates in user training as appropriate, on new or revised systems/applications.
  • Rebuilds Oracle RAC environment on legacy equipment.
  • Troubleshoots replication issues between production and DR sites as well as test and training facilities.
  • Monitors the operating efficiency of existing application systems and provides (or arranges for) proactive maintenance to prevent application or system issues.
  • Reviews, analyzes, and modifies systems, including encoding, testing, debugging, and installing for a large-scale system. Maintains records to document the system and revisions.
  • Participates in user training as appropriate, on new or revised systems/applications.

Level 5

Same as level 4 with the following additional responsibilities:

  • Performs feasibility analysis for new systems/applications including understanding implications for the current and future architecture to determine how applications and processes can be improved.
  • Develops a user training plan for new or revised systems/applications, leveraging vendors and business resources as appropriate to streamline new user or new application adoption.
  • Provides technical support and problem resolution for client inquiries and production issue resolution meets business needs, making changes to process as needed. Maintains awareness of projects or changes to other systems that may affect their applications/systems, to ensure there is no degradation of service.
  • Serves as a technical resource on projects that involve multiple technologies, great operational or implementation risks, complex business functionality, and broad implications for the business and/or the IT architecture. Migrates databases from Oracle 10g to intermediate Oracle 12c environment.
  • Plays a leading role in working with MTA-IT Security to ensure the security and integrity of database information.
  • Plays a leadership role in the feasibility analysis for new systems/applications including understanding implications for the current and future architecture to determine how applications and processes can be improved.
  • Serves as a technical lead or project manager on small sized projects and/or technical lead on large sized projects. Mentors less experienced staff.
  • Develops a user training plan for new or revised systems/applications, leveraging vendors and business resources as appropriate to streamline new user or new application adoption.

Level 6

Same as level 5 with the following additional responsibilities:

  • Serves as a technical lead and/or project manager on small or large sized projects. This includes leading or contributing to the technical design, tracking, and resolving technical issues, ensure unit tests are conducted and documented and guiding technical resources throughout the project.
  • Provides leadership and technical guidance on the most complex coding/ development, configuration, and implementation efforts to enhance the expertise of colleagues.
  • Establishes systems to monitor the operating efficiency of existing application systems and provides (or arranges for) proactive maintenance to keep systems operational.
  • Plans day to day application and system support, factoring in an understanding of future directions of the business area as well as changes in the technology landscape.
  • Migrates databases from Oracle 12c to Oracle 19c or later environments, under a High Availability (HA) model, with replication to Disaster Recovery (DR) site. Performs same at test and training sites.
  • Leads in the feasibility analysis for new Oracle utilities and applications including understanding implications for the current and future architecture to determine how applications and processes can be improved.
  • Serves as a technical lead and/or project manager on small or large sized projects. This includes leading or contributing to the technical design, tracking, and resolving technical issues, ensure unit tests are conducted and documented and guiding technical resources throughout the project.
  • Serves as a technical resource on projects that involve multiple technologies, great operational or implementation risks, complex business functionality, and broad implications for the business and/or the IT architecture.
  • Provides leadership and technical guidance on the most complex SQL Scripting, configuration, and implementation efforts to enhance the expertise of colleagues.
  • Establishes systems to monitor the operating efficiency of existing database systems and provides (or arranges for) proactive maintenance to keep systems operational.
  • Ensures technical support and problem resolution for all production issues. Maintains awareness of projects or changes to other systems that may affect Train Control applications/systems and ensures there is no degradation of service.
  • Develops a long-term plan (3-5 years) for applications and systems in the area(s) supported, factoring in an understanding of future directions of the business area as well as changes in the technology landscape.

Level 1
  • Possesses basic understanding in one or two programming languages, tools and/or technology environments, with the ability to learn and apply knowledge quickly.
  • Ability to resolve production issues where the problem is readily identifiable.
  • Ability to choose an approach or procedure for addressing a work task, under guidance.
  • Possesses working knowledge Oracle SQL, tools and/or technology environments.
  • Ability to resolve production issues where the problem is readily identifiable.

Level 2

Same as Level 1 with the following additional qualifications:
  • Possesses working knowledge of Oracle RAC and other Oracle utilities.
  • Has demonstrated an understanding of fundamentals of requirement specification, design, coding, and testing of information systems.
  • Ability to successfully troubleshoot applications problems independently.
  • Ability to analyze a chain of events and applies technical knowledge following procedures and/or detailed specifications.

L evel 3

Same as level 2 with the following additional qualifications:
  • Excellent communication skills, to be able to work with global vendor personnel to troubleshoot critical system issues.
  • Demonstrates an understanding of application development methods, the Project Execution Process, as well as the fundamentals of requirement specification, design, development/configuration, and testing of business applications systems.
  • Ability to participate and contribute to technical design reviews.
  • Ability to successfully troubleshoots most applications problems independently by determining and addressing the root cause.

  • ID: #49731026
  • State: New York New york city 10001 New york city USA
  • City: New york city
  • Salary: USD TBD TBD
  • Job type: Permanent
  • Showed: 2023-04-19
  • Deadline: 2023-06-17
  • Category: Et cetera