Important: If you applied for a position before March 24, 2023, please check the status of your application here. MTA employees, click here to check your job application status.

Join our Talent Network
Skip to main content
Back to job search

Application Development Specialist Levels 1- 6

Job ID: 1103
Business Unit: MTA Headquarters
Location: New York, NY, United States
Regular/Temporary:
Department: IT Product Management
Date Posted: Sep 22, 2023

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.

SUMMARY

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.

RESPONSIBILITIES

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.
QUALIFICATIONS

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.

Level 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.
  • Intimate knowledge of Oracle File System as well as iSCSI and NetApp data storage environments.
  • Demonstrates an understanding of Oracle Golden Gate and other replication utilities.
  • Demonstrates an understanding of Software Development Lifecycle.

Level 4

Same as level 3 with the following additional qualifications:

  • Ability to participate in technical design proactively anticipating potential roadblocks.
  • Ability to conduct complete diagnosis of business problems through a strong understanding of technical architecture.
  • Demonstrates a strong understanding of all relevant application development processes.
  • Understands architectural issues, and factors them into decisions and recommendations.Demonstrates ability to manage and rebuild the Oracle RAC environment, which is now obsolete and for which there will be no support from the vendor.
  • Demonstrates ability to work with multiple vendors to maintain existing databases and plan for future implementation.
  • Demonstrates ability to communicate effectively verbally and in writing to create, or assist in the creation of database system documentation.
  • Understands architectural issues, and factors them into decisions and recommendations.

Level 5

Same as level 4 with the following additional qualifications:

  • Demonstrates ability to migrate legacy databases to an intermediate version of Oracle to support legacy clients.
  • Demonstrates a broad understanding of the applications and technical architectures related to their area(s) with the ability to work with security personnel to ensure the security and safety of all critical system data.
  • Serves as a technical expert on existing applications supporting the business area, along with other inter-related / adjacent systems and applications.

Level 6

Same as level 5 with the following additional qualifications
  • Demonstrates ability to migrate legacy/intermediate databases to most recent version of Oracle, or the most recent version which the train control applications can support.
  • Demonstrates the ability to independently research and suggest new and improved Oracle or third-party utilities.
  • Recognized as a leader in the design and execution of business solutions, demonstrating a broad understanding of the applications and technical architectures.
  • Has designed database systems with high level of complexity (e.g., many interfaces, multiple packages, platforms).
EDUCATION & EXPERIENCE

Level 1

Typical candidates will possess 0-1 year of relevant experience and BS in Computer Science or related fields or equivalent experience.

Level 2

Typical candidates will possess 2+ years of relevant experience and BA/BS Degree in Computer Science or related fields or equivalent experience or M.S. in a related field.

Level 3

Typical candidates will possess 3+ years of relevant experience and BS in Computer Science or related fields or equivalent experience or M.S. in a related field and 1+ years of relevant experience.

Level 4

Typical candidates will possess 4-7 years of relevant experience and BS in Computer Science or related fields or equivalent experience or an M.S. and 2-5 years of relevant experience.

Level 5

Typical candidates will possess 8+ years of relevant experience and BS in Computer Science or related fields or equivalent experience or an M.S. and 6+ years of relevant experience.

Level 6

Typical candidates will possess 10 years of relevant experience and BS in Computer Science or related fields or equivalent experience or an M.S. and 8+ years of relevant experience.



OTHER INFORMATION

Please be advised that in accordance with the MTA Code of Ethics, you are subjected to financial disclosure filing requirements either because your position is designated as a policymaker pursuant, or your job title earns an annual salary in excess of the threshold rate of $108,638.

Therefore, you will be required to file an annual financial disclosure statement with the Commission on Ethics and Lobbying in Government. The Commission will notify you of this filing requirement via your work email. Upon receipt of notification from the Commission you will have 30 days to complete your financial disclosure statement.

HOW TO APPLY

MTA employees must apply via My MTA Portal. You can submit an online application by logging into My MTA Portal, clicking the My Job Search ribbon, and selecting the “Careers” link.

 

Logging in through My MTA Portal will link your BSC ID number to your job application to identify you as an internal applicant.


 EEO

MTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including with respect to veteran status and individuals with disabilities.

The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.

Save Job Saved
Similar Jobs
mail