Database Administrator

Apply

Database Administrator

• Agency: OFFICE OF THE COMPTROLLER

Posted on: 06/29/2024

• Job type: Full-time

Location

MANHATTAN

• Title Classification: Exam may be required

Department

Information Systems

Salary range: $103,000.00 - $113,300.00

Job Description

Note: This position is open only to the current City of New York employees serving in a permanent Civil Service Computer Associate (Software) title. Please clearly state your permanent civil service title on your resume and cover letter.

The Bureau of Information Systems and Technology provides a full range of technology support services for key business functions and Charter mandated responsibilities of the Comptroller's Office. These service include: technology strategic planning, web site development, graphic design, disaster recovery, systems development, network administration, audio/visual services, business process re-engineering, change management, program management, security administration, help desk, computer operations, telecommunications, and document management.

Under the direction of the Director of Network and Operations, the Database Administrator is responsible for the performance, integrity and security of the Database Management System. They will also be involved in the planning and development of the database as well as troubleshooting any issues. Tasks include, but are not limited to, the following:

• Developing SQL Server Integration Services (SSIS) packages for ETL and SQL Server Reporting Services (SSRS) for report generation;

• Monitoring and optimizing the performance of the database;

• Mapping out the conceptual design for a planned database;

• Installing, upgrading and testing new versions of the DBMS;

• Maintaining data standards;

• Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);

• Controlling access permissions and privileges;

• Developing, managing and testing back-up and recovery plans;

• Capacity planning;

• Working with infrastructure teams to allocate system storage and planning future storage requirements for the database system;

• Modifying the database structure, as necessary, from information given by application developers;

• Contacting database vendor for technical support;

• Generating various reports by querying from database as needed; and,

• Perform related assignments and special projects, as may be required.

SKILLS/QUALIFICATION REQUIREMENTS: All applicants must be current City of New York employees serving in a permanent Civil Service title of Computer Associate (Software) and preferably, possess a BA/BS degree from an accredited college in computer science, information systems or a related field, and four (4) or more years of progressively responsible full-time experience as a Database Administrator or Developer, preferably, performing functions in the nature of what is listed in the bulleted list of the above job description; or possess equivalent education and/or experience. Please clearly state your permanent civil service title on your resume and cover letter.

Minimum Qualifications

1. A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory full-time computer software experience in computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design; or

2. A four-year high school diploma or its educational equivalent and five years of satisfactory full-time computer software experience as described in "1" above; or

3. Education and or/or experience equivalent to "1" or "2" above. College education may be substituted for up to two years of the required experience in "2" above on the basis that 60 semester credits from an accredited college is equated to one year of experience. In addition, 24 semester credits from an accredited college or graduate school in computer science or a related field, or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school), may be substituted for one year of experience. However, all candidates must have at least a four-year high school diploma or its educational equivalent and at least one year of satisfactory full-time experience as described in "1" above.

Preferred Skills

- 1-2 years serving as Database Administrator of MS SQL Server environment (2008 and higher) - Strong in SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS) for report generation - Experience in Data Modeling, Database design and well versed with SQL Server best practices

• Experience creating and maintaining an extraction, transformation and leading process from source systems or files to a database - Ability to extract data (manually and automated) according to specified requirements, business logic and output format - Knowledge and experience with MySQL and Oracle - Ability to work in a team environment, plan, organize, and work on multiple tasks simultaneously and strong communication skills are required.

55a Program

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education's website at https://studentaid.gov/pslf/.

Residency Requirement

New York City Residency is not required for this position

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Minimum Qualifications

1. A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory full-time computer software experience in computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design; or

2. A four-year high school diploma or its educational equivalent and five years of satisfactory full-time computer software experience as described in "1" above; or

3. Education and or/or experience equivalent to "1" or "2" above. College education may be substituted for up to two years of the required experience in "2" above on the basis that 60 semester credits from an accredited college is equated to one year of experience. In addition, 24 semester credits from an accredited college or graduate school in computer science or a related field, or a certificate of at least 625 hours in computer programming from an accredited technical school (post high school), may be substituted for one year of experience. However, all candidates must have at least a four-year high school diploma or its educational equivalent and at least one year of satisfactory full-time experience as described in "1" above.

Preferred Skills

• \t1-2 years serving as Database Administrator of MS SQL Server environment (2008 and higher)\n\n-\tStrong in SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS) for report generation\n\n-\tExperience in Data Modeling, Database design and well versed with SQL Server best practices\n\n-\tExperience creating and maintaining an extraction, transformation and leading process from source systems or files to a database\n\n-\tAbility to extract data (manually and automated) according to specified requirements, business logic and output format\n\n-\tKnowledge and experience with MySQL and Oracle\n\n-\tAbility to work in a team environment, plan, organize, and work on multiple tasks simultaneously and strong communication skills are required.

55a Program

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education's website at https://studentaid.gov/pslf/.

Residency Requirement

New York City Residency is not required for this position

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Job ID

639614

Title code

13631

Civil service title

COMPUTER ASSOC (SOFTWARE)

Title classification

Competitive-1

Business title

Database Administrator

Posted until

2024-09-26

• Experience level: Experienced (non-manager)

Number of positions

1

Database Administrator

Apply

Database Administrator

• Agency: OFFICE OF THE COMPTROLLER

Posted on: 06/29/2024

• Job type: Full-time

Location

MANHATTAN

• Title Classification: Exam may be required

Department

Information Systems

Salary range: $103,000.00 - $113,300.00

Job Description

Note: This position is open only to the current City of New York employees serving in a permanent Civil Service Computer Associate (Software) title. Please clearly state your permanent civil service title on your resume and cover letter.

The Bureau of Information Systems and Technology provides a full range of technology support services for key business functions and Charter mandated responsibilities of the Comptroller's Office. These service include: technology strategic planning, web site development, graphic design, disaster recovery, systems development, network administration, audio/visual services, business process re-engineering, change management, program management, security administration, help desk, computer operations, telecommunications, and document management.

Under the direction of the Director of Network and Operations, the Database Administrator is responsible for the performance, integrity and security of the Database Management System. They will also be involved in the planning and development of the database as well as troubleshooting any issues. Tasks include, but are not limited to, the following:

• Developing SQL Server Integration Services (SSIS) packages for ETL and SQL Server Reporting Services (SSRS) for report generation;

• Monitoring and optimizing the performance of the database;

• Mapping out the conceptual design for a planned database;

• Installing, upgrading and testing new versions of the DBMS;

• Maintaining data standards;

• Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);

• Controlling access permissions and privileges;

• Developing, managing and testing back-up and recovery plans;

• Capacity planning;

• Working with infrastructure teams to allocate system storage and planning future storage requirements for the database system;

• Modifying the database structure, as necessary, from information given by application developers;

• Contacting database vendor for technical support;

• Generating various reports by querying from database as needed; and,

• Perform related assignments and special projects, as may be required.

SKILLS/QUALIFICATION REQUIREMENTS: All applicants must be current City of New York employees serving in a permanent Civil Service title of Computer Associate (Software) and preferably, possess a BA/BS degree from an accredited college in computer science, information systems or a related field, and four (4) or more years of progressively responsible full-time experience as a Database Administrator or Developer, preferably, performing functions in the nature of what is listed in the bulleted list of the above job description; or possess equivalent education and/or experience. Please clearly state your permanent civil service title on your resume and cover letter.

Minimum Qualifications

1. A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory full-time computer software experience in computer systems development and analysis, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design; or

2. A four-year high school diploma or its educational equivalent and five years of satisfactory full-time computer software experience as described in "1" above; or

Work location

1 Centre St., N.Y.

• Category: Technology, Data & Innovation