Application Development Specialist Levels 1- 6

Description Job Title:

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

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

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

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

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

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

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

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

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

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

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

• 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).