The New York City Employees’ Retirement System (NYCERS) is seeking an experienced Certified IT Administrator (DATABASE) to join our IT Database unit in the Information Technology division.
This position encompasses highly technical and supervisory responsibilities in SQL Server database administration, including monitoring, maintaining, enhancing, conducting security management, data modeling, auditing, and supporting complex on-prem and cloud database systems and related functions. The successful candidate will not only possess strong technical skills in the areas of SQL Server database management but will also be exceptionally "hands on" and able to effectively perform work independently as well as part of a team, that may often require collaboration with members of other IT units and business users.
In this capacity, the successful candidate will:
- Ensure system availability, recovery
- Execute performance tuning, backup, and restoration of databases
- Provide daily management of Microsoft SQL Server, infrastructure and service availability
- Maintain over 60 database servers across multiple environments (Development, Integration, QA, UAT and Production)
- Work with developers and infrastructure teams to provide world class services to the business community and NYCERS clients
- Develop and maintain procedures, best practices and standards documentation
- Enforce policies and procedures to ensure regulatory compliance
- Keep SQL servers up to date with necessary patches
- Promote application database changes to higher environments
- Perform server migration/upgrade activities
- Manage database storage based on design and determine operating system requirements. Estimate file sizes and growth
- Research, evaluate, and provide feedback on problematic trends and patterns.
- Diagnose and resolve problems in response to reported incidents.
- Assist in the preparation and support of data conversion, migration and Extract, Transform, Load (ETL) tools.
- Lead by example and provide technical guidance to other IT DATABASE team members when it’s required
- Perform other duties as assigned
CERT IT ADMINISTRATOR (DB) - 13644
Professional/Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following:
1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;
2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in "1" above; OR
3. A satisfactory equivalent of education and/or experience equivalent to “1” or “2” above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from
an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" above.
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.
The City of New York is the most iconic and dynamic city on the planet. With a population of more than 8.4 million people, New York is not only the largest city in the United States — it is the academic, cultural, commercial, and financial capital of the world.
City government is filled with opportunities for talented individuals seeking to improve their communities and make a meaningful difference in the lives of their fellow New Yorkers. Every day, the City’s more than 300,000 employees improve infrastructure, provide vital social services, build technology, protect health and safety, and so much more. Join us today at: http://www1.nyc.gov/jobs
The City of New York offers its employees:
• A chance to build the future of this city. New York City government is at the crossroads of where policy, great ideas, city services, and smart urban planning meet the lives and needs of every day New Yorkers.
• Competitive salary and benefits. Hiring packages include a competitive salary, health benefits, various pension plans, employee assistance programs, and individual retirement accounts.
• Diverse career opportunities. As the largest local government in the United States with more than 40 agencies, the City of New York offers a broad spectrum of opportunities — from education, housing development, and public health to sustainability, economic growth, technology, and emergency management.
• Career Satisfaction. As a City employee, you will have the chance to shape the future of New York City and improve the quality of life for your family, neighbors, and fellow New Yorkers.
• Equal Opportunity and Inclusion. The City of New York is an equal opportunity employer that prohibits discriminatory action against City employees and applicants for employment based on their actual or perceived race, color, national origin, ethnicity alienage, citizenship status, gender, religion, creed and all other protected categories.
