27 days old

Database Administrator Levels 1-5

MTA Headquarters
New York, New York 10004
  • Job Code
    96534
  • Job Type
    Employee
  • Job Status
    Full Time

Database Administrator Levels 1-5

JOB ID: 96534

Salary:            Level 1- Min.: $57,183.07                    Max.: $81,690.10

                        Level 2- Min.: $62,901.38                   Max.: $89,859.11

                        Level 3- Min.: $69,191.51                   Max.: $98,845.02

                        Level 4- Min.: $76,110.34                   Max.: $108,729.06

                        Level 5- Min.: $83,722.03                   Max.: $119,602.89

Dept./Div.:     Information Technology/Enterprise Applications

Agency:          MTA Headquarters

Location:        2 Broadway or various locations as required

Hours:          M-F, 9 A.M. – 5:30 P.M. (8 hour work day) or various as required

Reports To:     Lead Database Administrator

Summary

Playing a vital role in the economy of New York State and Connecticut, the Metropolitan Transportation Authority (MTA), consists of the busiest commuter railroad, subway and bus systems in the nation, with an annual ridership of over 2.6 billion. The MTA is comprised of MTA Headquarters/Police and the following MTA Agencies: Long Island Railroad, Metro-North Railroad, NYC Transit, Bus, Bridges and Tunnels, and Capital Construction. This position is in the Enterprise Applications Division of the MTA Headquarters Information Technology (IT) Department.

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

Level 1

  • Assist with the design, 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.
  • Assist with the installation, configuration and maintenance of database software modules and applications.
  • Assist with the development of 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.
  • Participate in the evaluation of new database products and technologies.

Level 2

Same as Level 1 with the following additional responsibilities:

  • Design, installation, configuration, and maintenance of database technologies and resources to ensure that all MTA application and systems availability targets are met.
  • Design, configure and install database software modules and applications.
  • Assist with the development of 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.
  • Guide less senior database technicians and staff in the performance of their tasks.

Level 3

Same as Level 2 with the following additional responsibilities:

  • 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.
  • Design and engineer solutions and standards to be applied within the IT Department.
  • Assist with the physical planning associated with the installation of database technology.

Level 4

Same as Level 3 with the following 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.
  • 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.
  • Contribute to the planning and coordination of tasks associated with database installations, support and maintenance.

 

Level 5

Same as Level 4 with the following additional responsibilities:

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

 

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

 

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 the following 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 provide technical direction to less senior staff members.  

Level 3

Same as Level 2 with the following 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.
  • Ability to provide technical direction to less senior staff members.
  • Ability to design & engineer solutions and standards.

Level 4

Same as Level 3 with the following 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 plan activities and provide advanced technical direction to less senior staff members.

Level 5

Same as Level 4 with the following additional qualifications:

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

 

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 $99,394 (this figure is subject to change) per year or if the position is designated as a policy maker

 

How To Apply

Qualified individuals interested in MTA Headquarters employment opportunities must apply through the MTA's online application and recruitment system. Please visit our website at https://new.mta.info/careers

 

MTA is an Equal Opportunity Employer.

 

Categories

Posted: 2019-10-18 Expires: 2019-11-17

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Database Administrator Levels 1-5

MTA Headquarters
New York, New York 10004

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast