Mta Careers Nyc

Metropolitan Transportation Authority

Database Administrator

Summary

The primary purpose of this position is to design, implement, maintain, tune and optimize all MTA databases to meet current and future software application requirements.

Responsibilities
  • Assists in configuration, installation, testing, and maintenance of database technologies and resources to ensure that all application and systems availability targets are met.
  • Troubleshoots database errors and other problems to resolve immediate customer needs.
  • Assist with the development of system backup schedules, verification testing and all related documentation requirements to ensure accurate and timely information on policies and procedures is available.
  • Work with system administrators, network administrators, help desk staff and other IT technical resources to coordinate database infrastructure requirements.
  • Participate in the evaluation of new database products and technologies, under the direction and guidance of senior colleagues, to meet current and future software application requirements.
  • Experience with Oracle Real Application Cluster (RAC), Backup & Recovery using Oracle’s Recovery Manager (RMAN).
  • Experience with Oracle Dataguard, Oracle Enterprise Manager (OEM).
  • Experience of UNIX / Linux Shell Scripting.
  • Comfortable in work with SQLPLUS command line, SQL Developer and TOAD.
  • Experience of working with Oracle Release 11.2, 12.2 and Oracle 19c.
  • Experience of performing database upgrades and apply patches.
  • Knowledge of Oracle Multitenant database environment will be a plus.
  • Must not have any problem working on a 24/7 On-Call Shifts.

Level 2

Same as level 1 with the following additional responsibilities:

  • Provides ongoing support and troubleshooting for database issues including those escalated from more junior colleagues to resolve immediate customer needs.
  • Monitors associated software such as version upgrades, patches, and tools and performance tune databases and related servers to ensure consistent database performance.
  • Performs database backup on a regularly scheduled basis, and database recovery when required to provide users with minimal interruptions in service.
  • Assists in project roll-outs by executing data migration activities to ensure solutions meet business needs.
  • Investigates, evaluates, and tests new products and technologies to meet current and future software application requirements.
  • Familiarity with Oracle Database SQL Performance Tuning diagnostic utilities, i.e. SQL Trace, TKPROF, Explain Plans, SQL Profiles, AWR Reports, and ADDM reports.
  • Experience with Oracle Flashback feature.

Level 3

Same as level 2 with the following additional responsibilities:

  • Design, install, configure, and maintain database technologies and resources to ensure that all application and systems availability targets are met.
  • Implements change management/change control processes to improve database performance.
  • Provides counseling and guidance to developers during application development to suggest best approach for the design of files and systems.
  • Produces and maintains database documentation to ensure up to date information is available.
  • Performs capacity analysis and planning for databases on file to ensure sufficient resources are available to hold needed data.
  • Develop system backup schedules, verification testing and all related documentation requirements to ensure accurate and timely information on policies and procedures is available.
  • Research new technologies/products, prepares a preliminary evaluation of technologies/products and associated costs, and develops and presents recommendations to support anticipated future business needs.
  • Guide junior database staff in the performance of their tasks to develop technical talent.
  • Experience with Oracle Database Security utilities such as Data Masking, Transparent Data Encryption, TNS Network Encryption, and Data Redaction.

Level 4

Same as level 3 with the following additional responsibilities:

  • Expert knowledge of Oracle’s Database Administration functions i.e., Backup and Recovery, Performance Tuning and Database Security.
  • Provides expertise in enterprise reporting and data management tools to maximize and share learning.
  • Develops, documents, and maintains logical and physical data models for multi-phase development projects to support complex and critical organizational initiatives.
  • Establishes and documents data policies and standards for the enterprise to ensure information is available and up to date.
  • Formulates procedures to ensure that communications of data updates are distributed to all associates and that they are adhered to.
  • Consults to the IT community to understand customer data needs and requirements.
  • Provides guidance and technical coaching to less experienced staff to support effective workflow and develop technical talent
  • Expert Knowledge of Oracle Real Application Cluster (RAC), Backup & Recovery using Oracle’s Recovery Manager (RMAN)
  • Expert knowledge of Oracle Database Security utilities such as Data Masking, Transparent Data Encryption, TNS Network Encryption, and Data Redaction.
  • Experience of working with Oracle ASM and Exadata
  • Experience of working with Oracle Multitenant database environment will be a plus.

Level 5

Same as Level 4 with additional responsibilities

Design and oversee the installation, configuration, and maintenance of database technologies and resources to ensure that all MTA application and systems availability targets are met.

  • Perform database administration tasks including but not limited to defining data process flows, data modeling, data migrations, security and fine tuning database performance.
  • Design, configure and install database software modules and applications.
  • Develop system backup schedules, verification testing and all related documentation requirements.
  • Work with system administrators, network administrators, help desk staff and other IT technical resources to coordinate database infrastructure requirements and analyze / troubleshoot issues as they arise.
  • Ensure all required system documentation and record keeping requirements associated with maintaining and controlling IT assets are completed accurately, timely and in accordance with MTA policies and procedures and department requirements.
  • Take a lead role in the evaluation of new products and technologies and influence future direction while providing input into the overall impact of introducing the technology within the MTA environment.
  • Participate in the evaluation of new database products and technologies and influence future direction and provide input into the overall impact of introducing the technology in the MTA environment.
  • Guide less senior database technicians and staff in the performance of their tasks.
  • Plan, design, engineer and document solutions and standards to be applied within the IT Department.
  • Lead the planning and coordination of tasks associated with database installations, support and maintenance.
Qualifications

Level 1

Basic knowledge and familiarity with installing, maintaining and troubleshooting database technology including computer hardware, operating system software and storage area network equipment as it relates to the proper installation and performance of the databases.

  • Solid knowledge of MTA standard shell scripting used to automate database tasks.
  • Basic knowledge of general purpose programming languages used to support automation of database tasks.
  • Ability to troubleshoot and support technical issues both remotely and on-site using standard MTA tools and techniques.
  • Ability to read and understand schematic diagrams, technical manuals and documentation such that supported equipment and software can be maintained with minimal training.
  • Strong oral and written communications skills.
  • Strong analytical skills.

Level 2

Same as Level 1 with additional qualifications

Proven knowledge and familiarity with installing, maintaining and troubleshooting database technology, including computer hardware, operating system software and storage area network equipment as it relates to the proper installation and performance of the databases.

  • Proven knowledge of MTA standard shell scripting used to automate database tasks.
  • Solid knowledge of general purpose programming languages used to support automation of database tasks.
  • Ability to troubleshoot and support technical issues both remotely and on-site using standard MTA tools and techniques.
  • Ability to read and understand schematic diagrams, technical manuals and documentation such that supported equipment and software can be maintained with minimal training.
  • Strong oral and written communications skills.
  • Strong analytical skills.
  • Ability to provide technical direction to less senior staff members.

Level 3

Same as Level 2 with additional qualifications

Strong knowledge and familiarity with installing, maintaining and troubleshooting database technology, including computer hardware, operating system software and storage area network equipment as it relates to the proper installation and performance of the databases.

  • Proven knowledge of MTA standard shell scripting used to automate database tasks.
  • Solid knowledge of general purpose programming languages used to support automation of database tasks.
  • Ability to troubleshoot and support technical issues both remotely and on-site using standard MTA tools and techniques.
Ability to read and understand schematic diagrams, technical manuals and documentation such that supported equipment and software can be maintained with minimal training.

  • Strong oral and written communications skills.
  • Strong analytical skills.
  • Ability to provide technical direction to less senior staff members.
  • Ability to design & engineer solutions and standards.

Level 4

Same as Level 3 with additional qualifications

. Advanced knowledge and familiarity with installing, maintaining and troubleshooting database technology, computer hardware, operating system software and storage area network equipment as it relates to the proper installation and performance of the databases.

  • Advanced knowledge of MTA standard shell scripting used to automate database tasks.
  • Advanced knowledge of general purpose programming languages used to support automation of database tasks.
  • Ability to troubleshoot and support technical issues both remotely and on-site using standard MTA tools and techniques.
  • Ability to read and understand schematic diagrams, technical manuals and documentation such that supported equipment and software can be maintained with minimal training.
  • Strong oral and written communications skills.
  • Strong analytical skills.
  • Strong people skills.
  • Ability to plan activities and provide advanced technical direction to less senior staff members.
  • Ability to design & engineer solutions and standards.

Level 5

Same as Level 4 with additional qualifications

Advanced knowledge and familiarity with installing, maintaining and troubleshooting database technology, including computer hardware, operating system software and storage area network equipment as it relates to the proper installation and performance of the databases.

  • Advanced knowledge of MTA standard shell scripting used to automate database tasks.
  • Advanced knowledge of general purpose programming languages used to support automation of database tasks.
  • Demonstrated ability to troubleshoot and support technical issues both remotely and on-site using standard MTA tools and techniques.
  • Demonstrated ability to read and understand schematic diagrams, technical manuals and documentation such that supported equipment and software can be maintained with minimal training.
  • Strong oral and written communications skills.
  • Strong analytical skills.
  • Demonstrated leadership and people skills.
  • Demonstrated ability to plan activity and provide advanced technical direction to less senior staff members.
  • Must demonstrate highly developed knowledge of current industry standard IT technologies and market trends.
  • Demonstrated ability to plan, present and apply complex technology solutions to solve critical business requirements effectively and efficiently.
  • Proven experience working with senior level staff contributing to both short- and long-term technology related planning strategies.
Education and Experience

Level 1

. Bachelor’s degree in Computer Science, Information Technology or related discipline; or a minimum of 3 years’ experience with programming, systems administration and/or database administration disciplines.

  • Must possess a minimum of 2 years’ experience installing, maintaining, administrating and supporting, computer hardware, operating systems software (UNIX, LINUX & Windows) and database products such as Oracle and MS-SQL.

Level 2

. Bachelor’s degree in Computer Science, Information Technology or related discipline; or a minimum of 5 years’ experience with programming, systems administration and/or database administration disciplines.

  • Must possess a minimum of 3 years’ experience installing, maintaining, administrating and supporting, computer hardware, operating systems software (UNIX, LINUX & Windows) and database products such as Oracle and MS-SQL.

Level 3

. Bachelor’s degree in Computer Science, Information Technology or related discipline; or a minimum of 7 years’ experience with programming, systems administration and/or database administration disciplines.

  • Must possess a minimum of 5 years’ experience installing, maintaining, administrating and supporting, computer hardware, operating systems software (UNIX, LINUX & Windows) and database products such as Oracle and MS-SQL.

Level 4

. Bachelor’s degree in Computer Science, Information Technology or related discipline; or a minimum of 10 years’ experience with programming, systems administration and/or database administration disciplines.

. Must possess a minimum of 8 years’ experience installing, maintaining, administrating and supporting, computer hardware, operating systems software (UNIX, LINUX & Windows) and database products such as Oracle and MS-SQL.

Level 5

. Bachelor’s degree in Computer Science, Information Technology or related discipline; or a minimum of 12 years’ experience with programming, systems administration and/or database administration disciplines.

  • Must possess a minimum of 10 years’ experience installing, maintaining, administrating and supporting, computer hardware, operating systems software (UNIX, LINUX & Windows) and database products such as Oracle and MS-SQ
Other Information

This is a resume based position in the collective bargaining unit represented by the Transportation Communications Union (TCU) and will be governed by the terms of the associated TCU collective bargaining agreement for IT employees. As such, candidates selected for this position will be represented by TCU and be on MTA payroll. In addition, candidates selected may be required to work at any MTA Agency location.

As an employee of MTA Headquarters, you may be required to complete an annual financial disclosure statement with the State of New York, if your position earns more than $105,472 (this figure is subject to change) per year or if the position is designated as a policy maker.

To apply for this job please visit hcm.mymta.info.