Overview
On Site
USD 110,748.00 - 130,719.00 per year
Full Time
Skills
Work in process
Rapid application development
C++
Agile management
Attention to detail
Microsoft SQL Server
Information Technology
Control system
Database administration
Performance tuning
Database security
System integration
Systems analysis
SQL
Software design
Test plans
Test cases
Functional requirements
Business process
User stories
Business rules
Application Support
Software management
Customer satisfaction
Market intelligence
Software engineering
Decision-making
Project management
Systems engineering
Service level
Extreme programming
Test methods
Unit testing
Integration testing
System testing
Acceptance testing
Regression testing
Version control
Programming languages
Software testing
Microsoft Windows Server
Web development
Operating systems
Cloud computing
Soft skills
Active listening
Customer service
Problem solving
Customer focus
Customer relationship management
Oracle
Preventive maintenance
Telecommuting
MTA
Applicant tracking system
Data marts
Database
Backup
Recovery
Optimization
Virtualization
Testing
Interfaces
SAP BASIS
Regulatory Compliance
Acquisition
Documentation
Scripting
Modeling
Usability
Accessibility
Statistics
Management
Finance
Mentorship
Specification
Software development
Waterfall
Agile
Scrum
DevOps
Kanban
Lean methodology
Collaboration
Design
Communication
Java
.NET
JavaScript
Microsoft Azure
RESTful
Linux
Cyber security
Encryption
Authentication
Partnership
Innovation
Law
FDS
Military
Job Details
Description
JOB TITLE: Specialist Software Engineer (MS-SQL Server, ORACLE))
SALARY RANGE: $110,748 - $130,719
HAY POINTS: 451
DEPT/DIV: Information Technology / Products
SUPERVISOR: Product Manager
LOCATION: Vario 2 Broadway New York, NY 10004
HOURS OF WORK: 9:00 am - 5:30 pm
DEADLINE:
This position is eligible for telework which is currently two 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 Train Control Systems: ATS-A, CBTCATS Canarsie and DataMart. The candidate will perform and coordinate database administration tasks such as performance tuning, database backup & recovery, database security, optimization, virtualization, and patching. The Software Engineer Specialist will perform system integration, 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 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.
RESPONSIBILITIES:
Item
Responsibilities and Accountabilities
1
Defines and manages scoping and requirements definition and ensures traceability to source.
2
Designs, codes, verifies, tests, documents, amends, and refactors complex programs/scripts and integration software services. Uses appropriate modelling techniques following agreed software design standards, guidelines, patterns, and methodology.
3
Develops and executes test plans and test cases; implements scalable and reliable automated tests and frameworks.
4
Develops acceptance criteria related to functional and non-functional requirements, business processes, features, user stories and business rules.
5
Selects appropriate tools and techniques to evaluate user experiences of systems, products, services, or devices, and validates that security, usability and accessibility requirements have been met.
6
Develops, configures, and maintains tools to identify, track, log and maintain accurate, complete, and current system information; develops and maintains associated operational documentation.
7
Maintains application support processes and uses application management software tools to investigate issues, prioritize and diagnose incidents, collect performance statistics, and create reports.
8
Defines, documents, and executes small projects or sub-projects. May act as product owner for one or more lower-value products or services, managing elements of the product life cycle to meet customer/user needs and achieve financial or other targets.
9
Plans, organizes, and conducts quality and safety assessments, and suggests opportunities for improvement. Contributes to identifying, analyzing, and documenting hazards and safety risks.
10
Monitors and reports on supplier performance, customer satisfaction, adherence to security requirements and market intelligence.
11
Continuously develops and maintains personal knowledge of software engineering practices, emerging trends, and technologies.
12
May mentor less experienced staff
13
Performs other duties and tasks
14
May need to work outside of normal work hours (i.e., evenings and weekends)
15
Travel may be required to other MTA locations or external sites
16
Successfully troubleshoots most applications problems independently, whenever they occur
17
Analyzes a chain of events and applies technical knowledge following established procedures and/or detailed specifications
18
Seeks advice from more experienced co-workers as needed.
KNOWLEDGE, SKILLS, AND ABILITIES
Successfully troubleshoots most applications problems independently, whenever they occur.
Analyzes a chain of events and applies technical knowledge following established procedures and/or detailed specifications.
Seeks advice from more experienced co-workers as needed.
May choose an approach or procedure for addressing a work task, under guidance.
Receives general direction, work in progress is reviewed routinely.
Uses a business risk-based approach to the decision-making process.
Incumbent should adhere to and be guided by all appropriate MTA IT procedures and standards (e.g., project management methodology, systems development lifecycle, service level agreements)
Technical Skills:
Strong proficiency in MS-SQL Developer, Oracle databases
Hands-on programming experience in a business setting.
Proficiency in at least one software engineering methodology, including but not limited to: Waterfall, Agile, Scrum, DevOps, Extreme Programming (XP), Kanban, Lean, Rapid Application Development (RAD).
Experience applying a structured validation and testing method, including but not limited to: Unit Testing, Integration Testing, System Testing, Acceptance Testing, Regression Testing.
Proficient collaboration skills to ensure design specifications are seamlessly implemented by the development team.
Proficient with version control
Demonstrated ability to work independently and navigate organizational ambiguity.
Effective written and verbal communication skills
Proficient Programming Languages
Proficient Software Testing
Programming experience with the following language(s): including but not limited to, Java, C++, MS-SQL Developer, Oracle, .Net, DBA, JavaScript.
Familiarity with the following vendor-specific platforms: including but not limited to, List here (e.g., Azure, Windows Server platforms, RESTful APIs, or Linux)
EDUCATION AND EXPERIENCE
Qualifications:
Education: bachelor's degree
Experience: At least 3 years of relevant experience. An equivalent combination of education and experience may be considered in lieu of a degree.
Preferred Qualifications/Knowledge:
Certified Software Engineer or equivalent, Agile Project Management, technical certifications relevant to the specific position (and software products and toolsets used in that position), experience with System Development Life Cycle with the specific methodologies in use in the Department.
Preferred Technical Skills:
MS-SQL Developer, Oracle, Java skills (Thorough Knowledge/Fully Proficient)
Database Management (Thorough Knowledge/Fully Proficient)
Web Development (Thorough Knowledge/Fully Proficient)
DevOps (Thorough Knowledge/Fully Proficient)
Operating Systems (Thorough Knowledge/Fully Proficient)
Cybersecurity, including encryption and authentication (Thorough Knowledge/Fully Proficient)
Cloud Computing (Thorough Knowledge/Fully Proficient)
Soft Skills:
Active Listening, Attention to Detail, Customer Service,
Prioritization, Problem Solving, Effective Verbal and Written Communication
Competencies:
Collaborates
Building partnerships and working collaboratively with others to meet shared objectives
Cultivates Innovation
Creating new and better ways for the organization to be successful
Customer Focus
Building strong customer relationships and delivering customer-centric solutions
Values Diversity
Recognizing the value that different perspectives and cultures bring to an organization
Communicates Effectively
Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences
Tech Savvy
Anticipating and adopting innovations in business-building digital and technology applications
OTHER INFORMATION:
Pursuant to the New York State Public Officers Law & the MTA Code of Ethics, all employees who hold a policymaking position must file an Annual Statement of Financial Disclosure (FDS) with the NYS Commission on Ethics and Lobbying in Government (the "Commission").
Equal Employment Opportunity
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.
JOB TITLE: Specialist Software Engineer (MS-SQL Server, ORACLE))
SALARY RANGE: $110,748 - $130,719
HAY POINTS: 451
DEPT/DIV: Information Technology / Products
SUPERVISOR: Product Manager
LOCATION: Vario 2 Broadway New York, NY 10004
HOURS OF WORK: 9:00 am - 5:30 pm
DEADLINE:
This position is eligible for telework which is currently two 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 Train Control Systems: ATS-A, CBTCATS Canarsie and DataMart. The candidate will perform and coordinate database administration tasks such as performance tuning, database backup & recovery, database security, optimization, virtualization, and patching. The Software Engineer Specialist will perform system integration, 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 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.
RESPONSIBILITIES:
Item
Responsibilities and Accountabilities
1
Defines and manages scoping and requirements definition and ensures traceability to source.
2
Designs, codes, verifies, tests, documents, amends, and refactors complex programs/scripts and integration software services. Uses appropriate modelling techniques following agreed software design standards, guidelines, patterns, and methodology.
3
Develops and executes test plans and test cases; implements scalable and reliable automated tests and frameworks.
4
Develops acceptance criteria related to functional and non-functional requirements, business processes, features, user stories and business rules.
5
Selects appropriate tools and techniques to evaluate user experiences of systems, products, services, or devices, and validates that security, usability and accessibility requirements have been met.
6
Develops, configures, and maintains tools to identify, track, log and maintain accurate, complete, and current system information; develops and maintains associated operational documentation.
7
Maintains application support processes and uses application management software tools to investigate issues, prioritize and diagnose incidents, collect performance statistics, and create reports.
8
Defines, documents, and executes small projects or sub-projects. May act as product owner for one or more lower-value products or services, managing elements of the product life cycle to meet customer/user needs and achieve financial or other targets.
9
Plans, organizes, and conducts quality and safety assessments, and suggests opportunities for improvement. Contributes to identifying, analyzing, and documenting hazards and safety risks.
10
Monitors and reports on supplier performance, customer satisfaction, adherence to security requirements and market intelligence.
11
Continuously develops and maintains personal knowledge of software engineering practices, emerging trends, and technologies.
12
May mentor less experienced staff
13
Performs other duties and tasks
14
May need to work outside of normal work hours (i.e., evenings and weekends)
15
Travel may be required to other MTA locations or external sites
16
Successfully troubleshoots most applications problems independently, whenever they occur
17
Analyzes a chain of events and applies technical knowledge following established procedures and/or detailed specifications
18
Seeks advice from more experienced co-workers as needed.
KNOWLEDGE, SKILLS, AND ABILITIES
Successfully troubleshoots most applications problems independently, whenever they occur.
Analyzes a chain of events and applies technical knowledge following established procedures and/or detailed specifications.
Seeks advice from more experienced co-workers as needed.
May choose an approach or procedure for addressing a work task, under guidance.
Receives general direction, work in progress is reviewed routinely.
Uses a business risk-based approach to the decision-making process.
Incumbent should adhere to and be guided by all appropriate MTA IT procedures and standards (e.g., project management methodology, systems development lifecycle, service level agreements)
Technical Skills:
Strong proficiency in MS-SQL Developer, Oracle databases
Hands-on programming experience in a business setting.
Proficiency in at least one software engineering methodology, including but not limited to: Waterfall, Agile, Scrum, DevOps, Extreme Programming (XP), Kanban, Lean, Rapid Application Development (RAD).
Experience applying a structured validation and testing method, including but not limited to: Unit Testing, Integration Testing, System Testing, Acceptance Testing, Regression Testing.
Proficient collaboration skills to ensure design specifications are seamlessly implemented by the development team.
Proficient with version control
Demonstrated ability to work independently and navigate organizational ambiguity.
Effective written and verbal communication skills
Proficient Programming Languages
Proficient Software Testing
Programming experience with the following language(s): including but not limited to, Java, C++, MS-SQL Developer, Oracle, .Net, DBA, JavaScript.
Familiarity with the following vendor-specific platforms: including but not limited to, List here (e.g., Azure, Windows Server platforms, RESTful APIs, or Linux)
EDUCATION AND EXPERIENCE
Qualifications:
Education: bachelor's degree
Experience: At least 3 years of relevant experience. An equivalent combination of education and experience may be considered in lieu of a degree.
Preferred Qualifications/Knowledge:
Certified Software Engineer or equivalent, Agile Project Management, technical certifications relevant to the specific position (and software products and toolsets used in that position), experience with System Development Life Cycle with the specific methodologies in use in the Department.
Preferred Technical Skills:
MS-SQL Developer, Oracle, Java skills (Thorough Knowledge/Fully Proficient)
Database Management (Thorough Knowledge/Fully Proficient)
Web Development (Thorough Knowledge/Fully Proficient)
DevOps (Thorough Knowledge/Fully Proficient)
Operating Systems (Thorough Knowledge/Fully Proficient)
Cybersecurity, including encryption and authentication (Thorough Knowledge/Fully Proficient)
Cloud Computing (Thorough Knowledge/Fully Proficient)
Soft Skills:
Active Listening, Attention to Detail, Customer Service,
Prioritization, Problem Solving, Effective Verbal and Written Communication
Competencies:
Collaborates
Building partnerships and working collaboratively with others to meet shared objectives
Cultivates Innovation
Creating new and better ways for the organization to be successful
Customer Focus
Building strong customer relationships and delivering customer-centric solutions
Values Diversity
Recognizing the value that different perspectives and cultures bring to an organization
Communicates Effectively
Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences
Tech Savvy
Anticipating and adopting innovations in business-building digital and technology applications
OTHER INFORMATION:
Pursuant to the New York State Public Officers Law & the MTA Code of Ethics, all employees who hold a policymaking position must file an Annual Statement of Financial Disclosure (FDS) with the NYS Commission on Ethics and Lobbying in Government (the "Commission").
Equal Employment Opportunity
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.