MS SQL Database Administrator
6 months ago
PLEASE NOTE: Candidates must be permanent in the civil service title Certified IT Administrator(Database) in order to be considered for this vacancy.
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 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 its required
-Perform other duties as assigned
Minimum Qualifications
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.
Preferred Skills
-7+ years’ experience in database administration of SQL Server database environments. -Working knowledge of Microsoft SQL Server //+-Thorough understanding of Relational Databases, T-SQL Scripting, Database Normalization best practices, database technologies, and concepts-Proficient in Database Design with ability to perform logical to physical database transformation-Proficient with SQL Development – ability to write and troubleshoot SQL Code as well as design and code stored procedures, functions, tables, views, triggers, indexes, constraints-Experience troubleshooting and resolving database integrity and performance issues-Proficient with Performance Tuning and Query Optimization-Experience working with database automation tools to support CI/CD database activities-Experience working on small, medium and largescale projects-Experience with SSIS, SSRS and SSAS-Experience in support of ETL applications-Experience in data modeling principles/methods including conceptual, logical & physical data models.-Experience with Microsoft Azure SQL Database-Demonstrated ability to work collaboratively and effectively in a team environment as well as independently-Ability to work with minimum supervision where required as well as ability to effectively perform work under specific direction-Prior experience leading small teams-Excellent written and verbal communication skills
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 class="jobad-residencyRequirement"> Residency RequirementNew York City Residency is not required for this position
-
Database Systems Specialist
4 weeks ago
Bronx, New York, United States City of New York Full timeJob Title: Database Administrator/ProgrammerJob Summary: The City of New York is seeking a skilled Database Administrator/Programmer to join our team. As a key member of our IT department, you will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance and security.Responsibilities:• Install and...
-
Administrative Associate
4 weeks ago
Bronx, New York, United States DreamYard Inc Full timeJob SummaryThe Administrative Associate will provide administrative support to the Art Center Programs team at DreamYard Inc. This part-time role will assist with basic administrative tasks, including calendar management, supply purchases, and database entry. The ideal candidate will have excellent interpersonal skills, strong computer skills, and experience...
-
Administrative Assistant
4 weeks ago
Bronx, New York, United States Vocational Instruction Project Community Services Full timeJob SummaryWe are seeking a highly organized and detail-oriented Administrative Assistant to join our team at the Vocational Instruction Project Community Services. The successful candidate will provide administrative support to the Chief Compliance Officer and assist with compliance-related tasks.Key ResponsibilitiesProvide administrative support to the...
-
Computer Specialist
4 months ago
The Bronx, United States City of New York Full timeAbout DCAS DCAS's mission is to make city government work for all New Yorkers. From managing New York City’s most iconic courthouses and municipal buildings, to purchasing over $1 billion annually in goods and services for more than 80 City agencies what we do ensures that all agencies can deliver on their mission. Our reach touches every facet of city...
-
Administrative Coordinator
4 weeks ago
Bronx, New York, United States BronxCare Health System Full timeJob Summary:As an Administrative Coordinator at BronxCare Health System, you will play a vital role in ensuring the smooth operation of our department. Your primary responsibility will be to serve as a personal secretary to the Director, handling confidential correspondence and office-related matters. You will also be responsible for maintaining the...
-
Administrative Support Specialist
1 month ago
Bronx, New York, United States BronxCare Health System Full timeJob SummaryThe Administrative Assistant plays a vital role in supporting the division's operations. This position provides essential assistance to the Vice President, including typing, statistical reporting, and diplomatic interactions with staff and external organizations. The ideal candidate will possess strong computer and secretarial skills, including...
-
Bronx, New York, United States CENTER FOR URBAN COMMUNITY SVC Full timeJob SummaryThe Center for Urban Community Services is seeking a Per Diem Office Manager to join our team at The Betances Residence. As a key member of our administrative staff, you will be responsible for ensuring the effective operation of all administrative support activities at our site. This includes working closely with our Program Director and...
-
Administrative Support Specialist
4 weeks ago
Bronx, New York, United States The Legal Aid Society Full timeJob SummaryThe Legal Aid Society is seeking an Administrative Assistant to support the Director of Interpreter Services in the Bronx Criminal Practice office. This role will provide administrative support, answer phone calls and emails, and perform various tasks to ensure the smooth operation of the office.Key ResponsibilitiesProvide administrative support...
-
Residency Program Administrator
4 weeks ago
Bronx, New York, United States MONTEFIORE MEDICAL CENTER Full timeThe Residency Program Administrator will report directly to the Residency Program Director and Department Administrator. The incumbent will coordinate and supervise all aspects of the Family Medicine residency training program, including cross-track activities for the Residency Program in Social Medicine.Key responsibilities include coordinating the...
-
Administrative Support Specialist
3 days ago
Bronx, New York, United States BronxCare Health System Full timeJob SummaryAs a skilled Office Administration Professional with the BronxCare Health System, you will be responsible for providing exceptional administrative support to our team. Key responsibilities include taking and transcribing dictation, performing skilled keyboarding and clerical work, and contributing to Performance/Quality Improvement activities. If...
-
Administrative Assistant
4 weeks ago
Bronx, New York, United States DreamYard Inc Full timeJob SummaryWe are seeking a highly organized and detail-oriented Administrative Assistant to support the Art Center Programs team at DreamYard Inc.The successful candidate will provide administrative support, manage calendars, and maintain program records, among other tasks.Key ResponsibilitiesManage calendars and schedule appointmentsMaintain program...
-
Administrative Coordinator
1 month ago
The Woodlands, United States Fred Astaire Dance Studios Full timeJob OverviewFred Astaire Dance Studios is seeking a highly organized and detail-oriented Administrative Assistant to support the day-to-day operations of our studio.The ideal candidate will have proven experience in administrative roles and excellent communication skills to provide exceptional customer service.Responsibilities:Assist with administrative...
-
Senior Data Analyst
4 weeks ago
Bronx, New York, United States Manhattan University Full timeSenior Data AnalystThe Office of Institutional Research at Manhattan University seeks a highly skilled Senior Data Analyst to support the university's efforts in data-driven decision-making. The successful candidate will have a strong background in data analysis, statistical modeling, and data visualization.Key Responsibilities:Coordinate and manage IPEDS...
-
Administrative Support Specialist
4 weeks ago
Bronx, New York, United States Vocational Instruction Project Community Services Full timeJob Title: Administrative AssistantVocational Instruction Project Community Services is seeking a highly skilled and organized Administrative Assistant to join our team. The successful candidate will provide administrative support to the Chief Compliance Officer and work closely with various programs, including residential and supportive housing, outpatient,...
-
CFO - Nonprofit
2 months ago
The Bronx, United States Creative Financial Staffing Full timeCFO - NonProfit About our Client: CFS of New York is working with a Nonprofit organization with a mission centered around serving individuals and families experiencing Homelessness in the community. This is a newly created role as they are experiencing tremendous growth within the organization. What you'll do as the CFO: Lead financial and accounting...
-
Enterprise Applications Manager
4 weeks ago
The Villages, Florida, United States The Villages Full timeJob SummaryAs an Enterprise Applications Manager at The Villages, you will be responsible for creating and maintaining multiple production Enterprise Application environments. This role requires delivering exceptional customer service to both internal and external customers while ensuring the highest level of application security and compliance.Key...
-
Data Management Specialist
4 weeks ago
Bronx, New York, United States POSTGRADUATE CENTER FOR MENTAL HEAL Full timeJob Summary:The Data Management Specialist plays a vital role in ensuring the accuracy and integrity of property management and related program records at the Postgraduate Center for Mental Health. This position requires strong communication and interpersonal skills to interact with residents, program staff, managers, and executive management. The successful...
-
Procurement Analyst
5 months ago
The Bronx, United States City of New York Full timeThe Department of Records and Information Services is seeking to hire a Procurement Analyst to work in the Administration division. The duties for this position will include but are limited to: Purchasing & Payments: -Preparing procurement documentation for the agency including purchase requisitions, memos and personal expense reimbursement. Processing...
-
Computer Operations Specialist
4 weeks ago
Bronx, New York, United States City of New York Full timeAbout the RoleDCAS's mission is to make city government work for all New Yorkers. From managing New York City's most iconic courthouses and municipal buildings, to purchasing over $1 billion annually in goods and services for more than 80 City agencies, what we do ensures that all agencies can deliver on their mission. Our reach touches every facet of city...
-
The Colony, Texas, United States RedRiver Systems, LLC Full timeJob SummaryWe are seeking a highly skilled Full Stack .NET Developer with expertise in Angular or React to join our team at RedRiver Systems, LLC. This is a direct hire, full-time opportunity with a hybrid remote work environment.Key ResponsibilitiesDevelop and refine features in our web-based EMR, PHR, and Enrollment systemsAnalyze and document client...