Metropolitan Transportation Authority (MTA)
Database Administrator Level 1-4 (TCU Represented)
Metropolitan Transportation Authority (MTA), New York, New York, us, 10261
Overview
Description JOB TITLE
: Database Administrator Level 1-4 (TCU Represented) SALARY RANGE
: Level 1 $62,812 - $89,731 Level 2 $69,092 - $98,703 Level 3 $76,001 - $108,573 Level 4 $83,601 - $119,430 DEPT/DIV
: Information Technology SUPERVISOR
: Senior Director, Product Development LOCATION
: 2 Broadway HOURS OF WORK
: 9:00 am - 5:00 pm/8 hrs. or as required. DURATION
: Open Until Filled This position is eligible for telework. New Hires are eligible to apply 30 days after their effective date of hire. 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. SQL Server Database Administrator is responsible for the administration of our SQL server footprint both on-site and in Azure. The DBA is pivotal for day-to-day configuration, maintenance, and performance of critical Microsoft SQL Server environments, ensuring integrity, performance, reliability, and recoverability of data for a wide variety of applications. Critical Skills: Hands-on experience as a SQL Server Database Administrator including Design, implementation, monitoring, and maintenance of Microsoft SQL Server on-prem and in the cloud. Strong experience implementing High availability, Disaster recovery solutions. Strong knowledge with all aspects of database administration including database installations, upgrades, migrations, backup and recovery, monitoring, performance and query tuning, database security, optimization, and troubleshooting. Strong knowledge in Windows Server, SQL Server, Azure cloud platform including Azure SQL Managed Instance, Azure Storage account and Azure security. Experience in data archival, table partitioning, monitoring system performance, database replication Strong Knowledge of SQL. Knowledge of Python is preferred. Familiarity with SSIS, SSRS, SSAS. Strong problem-solving skills with a focus on logical troubleshooting. Certifications in Microsoft technologies are preferred Ability to work independently, as well as in a team environment Strong verbal and writing skills Responsibilities: Level 1 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. 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 system availability targets are met. Design, configure, and install database software modules and applications. 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. 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: 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. Design, engineer, and document solutions and standards to be applied within the IT Department. Contribute to the planning and coordination of tasks associated with database installations, support, and maintenance. Qualifications 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 ... (see Level 2 qualifications in original) Level 3 ... (see Level 3 qualifications in original) Level 4 ... (see Level 4 qualifications in original) 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. 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.
#J-18808-Ljbffr
Description JOB TITLE
: Database Administrator Level 1-4 (TCU Represented) SALARY RANGE
: Level 1 $62,812 - $89,731 Level 2 $69,092 - $98,703 Level 3 $76,001 - $108,573 Level 4 $83,601 - $119,430 DEPT/DIV
: Information Technology SUPERVISOR
: Senior Director, Product Development LOCATION
: 2 Broadway HOURS OF WORK
: 9:00 am - 5:00 pm/8 hrs. or as required. DURATION
: Open Until Filled This position is eligible for telework. New Hires are eligible to apply 30 days after their effective date of hire. 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. SQL Server Database Administrator is responsible for the administration of our SQL server footprint both on-site and in Azure. The DBA is pivotal for day-to-day configuration, maintenance, and performance of critical Microsoft SQL Server environments, ensuring integrity, performance, reliability, and recoverability of data for a wide variety of applications. Critical Skills: Hands-on experience as a SQL Server Database Administrator including Design, implementation, monitoring, and maintenance of Microsoft SQL Server on-prem and in the cloud. Strong experience implementing High availability, Disaster recovery solutions. Strong knowledge with all aspects of database administration including database installations, upgrades, migrations, backup and recovery, monitoring, performance and query tuning, database security, optimization, and troubleshooting. Strong knowledge in Windows Server, SQL Server, Azure cloud platform including Azure SQL Managed Instance, Azure Storage account and Azure security. Experience in data archival, table partitioning, monitoring system performance, database replication Strong Knowledge of SQL. Knowledge of Python is preferred. Familiarity with SSIS, SSRS, SSAS. Strong problem-solving skills with a focus on logical troubleshooting. Certifications in Microsoft technologies are preferred Ability to work independently, as well as in a team environment Strong verbal and writing skills Responsibilities: Level 1 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. 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 system availability targets are met. Design, configure, and install database software modules and applications. 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. 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: 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. Design, engineer, and document solutions and standards to be applied within the IT Department. Contribute to the planning and coordination of tasks associated with database installations, support, and maintenance. Qualifications 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 ... (see Level 2 qualifications in original) Level 3 ... (see Level 3 qualifications in original) Level 4 ... (see Level 4 qualifications in original) 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. 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.
#J-18808-Ljbffr