City Of New York

Data Architect

City Of New York$90K — $130K *
Education, Government & Non-Profit
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree from an accredited institution
  • 4 years of relevant full-time experience in IT security and database administration
  • Familiarity with SQL Server environments
  • Experience with SSIS and SSRS deployment
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) architectures

Responsibilities

  • Perform SQL Server database administration and maintenance tasks
  • Monitor and analyze data platforms to ensure availability and security
  • Implement capacity planning for mission-critical databases
  • Collaborate with application owners for schema and data migration
  • Partner with development teams to deliver timely solutions
  • Manage HA and DR architectures, including Clustering and Replication

Benefits

  • Comprehensive health insurance for employees and dependents
  • Union benefits including dental and vision coverage
  • Paid annual and sick leave with paid holidays
  • Pension plan
  • Optional savings programs, including Deferred Compensation and flexible spending accounts
Full Job Description
ITSD is seeking a qualified candidate in the position of IT Security Specialist to act as a Data Architect who will complete duties including but not limited to the following: 1. Perform SQL Server database administration functions, including maintenance of multiple environments (development, testing, and production), patching, troubleshooting, SSIS & SSRS deployments and security management. 2. Monitor and analyze data platforms to ensure database is available, secure, healthy, efficient and recoverable as per expectations. 3. Implement and manage the physical databases of mission critical systems capacity planning to determine future storage needs. 4. Collaborate with application owners to develop a seamless process to migrate their schema and data to data platform. 5. Partner with development and quality assurance teams to deliver robust, quality and on-time solutions. 6. Build and manage HA & DR architecture like Clustering, Replication and Always on. WORK LOCATION: 1 POLICE PLAZA TO APPLY: To apply, please visit: https://cityjobs.nyc.gov and search for Job ID #771240 The City of New York offers a comprehensive benefits package including health insurance for the employee and his or her spouse or domestic partner and un-emancipated children under age 26, union benefits such as dental and vision coverage, paid annual leave and sick leave, paid holidays, a pension, and optional savings and pre-tax programs such as Deferred Compensation, IRA, and a flexible spending account. IT SECURITY SPECIALIST - 95622 Qualifications A baccalaureate degree from an accredited college and four years of satisfactory full-time experience related to projects and policies required by the particular position; or, Education and/or experience which is equivalent to "1" above.

About City Of New York

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.

City of New York Careers

There has never been a better time to explore the diverse job opportunities at the City of New York—the hub of professional growth and innovation in the public sector.

Work You’ll Do

Join the City of New York’s dynamic team to contribute to the community and enhance the city’s services across a broad spectrum of disciplines. The City of New York offers a unique opportunity to engage in meaningful work that impacts the lives of millions while navigating through a career filled with learning and growth. Transform the metropolitan landscape and enrich the lives of its residents with the best minds in public administration, urban planning, and community services. The City of New York stands at the forefront of urban management and innovation. Lead with a unique position in public service, at the intersection of technology, community needs, and sustainable development. Work alongside a diverse team of professionals dedicated to improving city operations and enhancing the quality of urban life. Collaborate with the largest network of public service experts in the nation, fostering leadership, diversity training, and professional development.

Introducing the City of New York Public Service Careers

The team is building a market-leading public service career path to help professionals master their roles and contribute effectively to the city’s development.

Do Innovative Work

Join a vast network of experts—dedicated professionals at the intersection of governance, community service, and urban innovation.

Drive Change in Public Service

Deliver targeted solutions and policies that enhance city living and maintain New York as a leading global city through a depth and breadth of expertise that’s second to none.

Be Part of a Great Team

Engage in a wide range of city projects utilizing cutting-edge technology and strategies, harnessing the unparalleled capabilities, scale, and collaborative spirit of a dedicated public service team.

Future-proof Your Career

Advance your career with limitless opportunities in the public sector, supported by unmatched training, development programs, and certification support.

Explore

From improving city infrastructure to enhancing public safety, the City of New York offers a platform for professionals to apply their skills, innovate, and lead.

The City of New York Public Service Initiative

The combined efforts of various departments help overcome urban challenges and lead transformation in city management. Professionals around the globe look to the City of New York for new strategies and solutions to drive significant change and growth in urban living. ## Stay Connected

Join the Team

Search open positions that match your skills and interests. The City of New York looks for passionate, curious, creative, and solution-driven team players. SEARCH CITY OF NEW YORK JOBS

Keep Up to Date

Stay ahead with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the people who serve here.

READ CAREERS BLOG

Job Alert Emails

Personalize your subscription to receive job alerts, latest news, and insider tips tailored to your preferences. Discover what exciting and rewarding opportunities await in the City of New York.
Learn more about City Of New York

Similar Jobs

More Jobs at City Of New York

More Education, Government & Non-Profit Jobs

Find similar Data Architect jobs: