NYC Staffing
Database Administrator Level 1-4 (TCU Represented)
NYC Staffing, New York, New York, United States, 10001
Database Administrator Level 1-4
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 include: Assist with the design, installation, configuration, and maintenance of database technologies and resources to ensure that all MTA application and system 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. 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 the 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 communication 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 the 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 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 the automation of database tasks. Ability to plan activities and provide advanced technical direction to less senior staff members. 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, administering, 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, administering, 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, administering, 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. 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 the MTA payroll. In addition, candidates selected may be required to work at any MTA Agency location. 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.
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 include: Assist with the design, installation, configuration, and maintenance of database technologies and resources to ensure that all MTA application and system 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. 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 the 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 communication 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 the 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 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 the automation of database tasks. Ability to plan activities and provide advanced technical direction to less senior staff members. 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, administering, 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, administering, 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, administering, 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. 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 the MTA payroll. In addition, candidates selected may be required to work at any MTA Agency location. 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.