MS SQL Database Administrator

3 months ago

The Bronx, United States City of New York Full time

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 Administrator

    1 week ago

    Bronx, New York, United States City of New York Full time

    About the RoleWe are seeking an experienced Database Administrator to join our IT team at the City of New York. As a key member of our team, you will be responsible for ensuring the availability, recovery, and performance of our Microsoft SQL Server databases.Key ResponsibilitiesDatabase Administration: Ensure system availability, recovery, and performance...

  • Database Administrator

    2 days ago

    Bronx, New York, United States City of New York Full time

    Job SummaryWe are seeking an experienced Database Administrator to join our IT Database unit in the Information Technology division of the City of New York. The successful candidate will possess strong technical skills in SQL Server database management and be able to effectively perform work independently as well as part of a team.Key ResponsibilitiesEnsure...

  • SQL Server Database Developer

    1 month ago

    The Colony, United States RedRiver Systems, LLC Full time

    THIS IS A HYBRID REMOTE - 3 DAYS ONSITE PER WEEKFULL-TIME / DIRECT HIRE OPPORTUNITY ONLYNO VISA SPONSORSHIP NOW OR IN THE FUTURECLIENT WILL NOT CONSIDER ANYONE THAT DOES NOT CURRENTLY RESIDE IN THE DFW AREAThis rapidly growing Healthcare company is seeking a SQL Server Database Developer that will play a primary role in all aspects of the Information...

  • Database Systems Administrator

    14 hours ago

    Bronx, New York, United States City of New York Full time

    Job DescriptionThe City of New York is seeking a highly skilled Database Administrator to join our team. As a key member of our IT department, you will be responsible for ensuring the smooth operation of our database systems.Key Responsibilities:Database Installation and Configuration: Install and configure databases with license compliance in coordination...

  • SQL Developer

    4 weeks ago

    The Woodlands, United States Tally Group Full time $95,000 - $120,000

    Job DescriptionJob DescriptionAt Tally Group, we put our energy into building world-leading utility technology. We aim to transform how people power their homes and businesses, so we're reinventing how energy retailers operate.We are a cloud-native SaaS provider with extensive experience and clients worldwide. We offer a comprehensive suite of innovative...

  • Data Analyst

    2 weeks ago

    The Colony, United States Insight Global Full time

    Must Haves:Bachelor's Degree in Business, Computer Science, Healthcare Management, or related field 3-5 years of experience working in a business intelligence (BI) related position. Healthcare revenue cycle experience preferred, but not required.Strong experience developing business-friendly decision models that source multiple data sources, formula-based...

  • Data Analyst

    2 weeks ago

    The Colony, United States Insight Global Full time

    Must Haves:Bachelor's Degree in Business, Computer Science, Healthcare Management, or related field 3-5 years of experience working in a business intelligence (BI) related position. Healthcare revenue cycle experience preferred, but not required.Strong experience developing business-friendly decision models that source multiple data sources, formula-based...

  • Data Analyst

    2 days ago

    The Colony, Texas, United States Insight Global Full time

    About the RoleThe Data Analyst will play a crucial role in supporting the business-case and technical requirements of the Revenue Strategy & Analytics department at Insight Global. This position will be responsible for capturing business requirements, developing ad-hoc queries and procedures, and constructing data models to build reports and dashboards.Key...

  • Computer Specialist

    2 months ago

    The Bronx, United States City of New York Full time

    About 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...

  • Computer Operations Specialist

    1 week ago

    Bronx, New York, United States City of New York Full time

    About the RoleThe Department of Citywide Administrative Services (DCAS) is seeking a highly skilled Computer Specialist to join our team. As a key member of our Human Capital Management (HCM) team, you will be responsible for troubleshooting and resolving system issues, performing data audits, and maintaining accurate documentation.Key ResponsibilitiesSystem...

  • Data Architect

    1 week ago

    Bronx, New York, United States Montefiore Medical Center Full time

    Data Engineer Role at Montefiore Medical CenterThe Data Engineer role at Montefiore Medical Center focuses on developing informatics capabilities to enhance patient outcomes and operational efficiency. Key responsibilities include designing and implementing data structures, technology architectures, and deploying data-driven solutions to address medical...

  • Mainframe Computer Operations Expert

    5 days ago

    Bronx, New York, United States City of New York Full time

    About the RoleThe City of New York is seeking a highly skilled Computer Operations Specialist to join our team. As a key member of our Human Capital Management (HCM) team, you will be responsible for troubleshooting and resolving system issues, identifying and diagnosing problems, and providing excellent customer service to our employees.Key...

  • Administrative Assistant

    2 weeks ago

    Bronx, United States Good Shepherd Services Full time

    About Us: Good Shepherd Services is a leading multi-service agency with more than 85 programs that serve over 30,000 youth and families each year and builds on their strengths to help them gain skills for success. At Good Shepherd we respect the dignity and worth of every person and reject intolerance, inequity and injustice in whatever form it may take....

  • Python Developer

    3 days ago

    The Bronx, United States NavitsPartners Full time

    Job Title: Python Developer - ExpertDuration: 30+ MonthsLocation: New York, NY (Onsite)Summary:We are looking for a seasoned Python Developer with over 7 years of experience to join our team. The ideal candidate will have extensive expertise in data modeling, predictive systems, and ETL processes, particularly within the insurance sector.Mandatory...

  • Administrative Paralegal

    5 days ago

    Bronx, New York, United States City of New York Full time

    Job SummaryThe City of New York is seeking a highly skilled Paralegal Aide to join our team. As a Paralegal Aide, you will provide administrative support to our legal team, assisting with a wide range of tasks related to case management, document preparation, and research.Key ResponsibilitiesConduct file reviews and provide guidance on case handling...

  • Administrative Assistant-(HRA) La Central

    1 week ago

    Bronx, United States Comunilife Full time

    Administrative Assistant-(HRA) La Central Job Details Job Location Bronx, NY Position Type Full Time Education Level High School Salary Range $16.60 - $16.92 Hourly Travel Percentage Negligible Job Category Admin - Clerical Description Comunilife Inc.is looking to fill anAdministrative Assistant positionin itscongregate program in the Bronx.The La...

  • Administrative Assistant

    2 weeks ago

    Bronx, United States BronxCare Health System Full time

    Overview: May Serve as personal/Confidential Secretary for the Director of department. Monitors and prepares confidential correspondence, handles all related matters. Schedules appointments, maintains the Directors calendar and prepares agenda. Responsibilities: - Establish and maintain positive relationships with patients, visitors, and other employees....

  • Administrative Assistant-SBX

    2 weeks ago

    Bronx, United States Career Systems Full time

    Job Type Full-time Description Job Summary: Performs complex administrative tasks using a personal computer. Coordinate's office services and administrative activities for Job Corps center; interprets operating policies and Core Values; exercises independent judgment in the resolution of administrative problems. Duties/Responsibilities: Must model the...

  • Administrative Assistant

    4 weeks ago

    The Woodlands, United States Fred Astaire Dance Studios Full time

    Job DescriptionJob DescriptionJoin the team at Fred Astaire Dance Studios and be part of an organization that is dedicated to enriching lives through the power of dance. As an Administrative Assistant, you will play a vital role in supporting the day-to-day operations of our studio.Responsibilities:Assist with general administrative tasks including answering...

  • CFO - Nonprofit

    7 days ago

    The Bronx, United States Creative Financial Staffing Full time

    CFO - NonProfitAbout 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...