Jobs
>
New York City

    Database Administrator - New York, United States - City of New York

    City of New York
    City of New York New York, United States

    1 week ago

    Default job background
    Description

    Company Description

    Job Description


    THE AGENCY

    The Department of City Planning (DCP) plans for the strategic growth and development of the City through ground-up planning with communities, the development of land use policies and zoning regulations applicable citywide and sharing its perspectives on growth and community needs with sister agencies in collaboration with the Office of Management and Budget (OMB).


    DCP is a great place to work - cultivating intellectual inspiration, professional development, and creativity.

    Visit our website at to access the full listing of job opportunities and to learn more about the agency's services.



    THE DIVISION

    Information Technology Division's (ITD) vision is to become a dynamic and vibrant technology delivery organization of the New York City government that leads business transformations and technology innovations to enable citizen-centric smart urban planning, while promoting a culture of collaboration, talent development, and equity.

    ITD is responsible for developing technology solutions to support agency needs and citywide asks, including City Charter mandates.

    This includes grant funding requirements, citywide geospatial services, maintaining systems infrastructure and endpoint assets to optimize operational efficiency, promote innovation, and collaborate with other city agencies to enhance service accessibility to citizens.

    The division provides necessary computing infrastructure and productivity-enhancing technology tools in a hybrid mode (on premise and in the cloud), to support DCP's interdisciplinary staff across five boroughs, including planners, urban designers, project managers, and executive management.

    The division is comprised of experienced and talented software engineers, geographic specialists, service engineers, and technology leaders who specialize in managing system infrastructure, cyber security, geospatial data engineering, application services, and portfolio management.

    Within ITD, the Infrastructure and Security Management (ISM) unit is responsible for design, configuration, and maintenance of on-premise and cloud network infrastructure; physical and virtual server management, backup and recovery, security and access control, database administration, capacity planning, and incident response, facilitating the agency's computing needs and provisioning the infrastructure assets for the optimal of internal and external clients, systems, and applications.

    Staffed by a team of network engineers and infrastructure specialists, the ISM unit closely works with city's Office of Technology and Innovation (OTI) on identity and access management, compliance and governance, and security best practices.



    THE ROLE

    ITD's Infrastructure and Security Management (ISM) unit is seeking a Database Administrator who has strong background in on-premises SQL Server and cloud Azure SQL database administration, database design practices for web application development, scaling and performance tuning of production databases, and securing database instances and services.

    The candidate will be responsible for designing, implementing, and optimizing robust and secure database solutions that enable efficient application development, data management, and business intelligence.


    Under supervision and general direction, with considerable latitude for the exercise of independent judgment, the Database Administrator's responsibilities include, but may not be limited to:

    • Design, develop, and implement database solutions that support business applications, ensuring data integrity, availability, and performance.
    • Lead the migration of on premises SQL Server databases to Azure SQL Database, utilizing best practices for seamless transitions.
    • Collaborate closely with application developers, business analysts, and stakeholders to understand data requirements and design efficient database structures.
    • Design and implement security measures for databases, including access controls, encryption, and auditing, to protect sensitive data.
    • Monitor database performance and optimize query performance to enhance application responsiveness and efficiency.
    • Monitor and respond to production issues, outages, etc.
    • Implement strategies for database scalability, both vertically and horizontally, to accommodate growing data volumes and application demands.
    • Manage database backup, restoration, and disaster recovery processes to ensure data availability and business continuity.
    • Develop and maintain ETL processes and integration pipelines between different databases and systems.
    • Develop and optimize complex SQL queries, triggers, procedures, and will functions.
    • Implement SSRS, SSAS, SSIS, and data warehousing.
    • Utilize business intelligence and analytics tools to extract insights from data and support data driven decision making.
    • Collaborate with cross functional teams to ensure proper integration of databases with applications, APIs, and reporting systems.
    • Develop and maintain database documentation, including data dictionaries, schemas, and diagrams.
    • Stay current with the latest database technologies, best practices, and trends, and recommend improvements to existing systems.
    • Mentor and provide guidance to junior database administrators and developers, fostering skill development and knowledge sharing.

    Qualifications

    (1) A baccalaureate degree from an accredited college, including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) years of satisfactory full-time software experience in designing, programming, debugging, maintaining, implementing, and enhancing computer software applications, systems programming, systems analysis and design, data communication software, or database design and programming, including one year in a project leader capacity or as a major contributor on a complex project; or
    (2) A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described in "1" above, including one year in a project leader capacity or as a major contributor on a complex project; or
    (3) A satisfactory combination of education and experience that is 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 sixty (60) semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in (1) or (2) above. However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one (1) year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project.


    NOTE:

    In order to have your experience accepted as Project Leader or Major Contributor experience, you must explain in detail how your experience qualifies you as a project leader or as a major contributor.

    Experience in computer operations, technical support, quality assurance (QA), hardware installation, help desk, or as an end user will not be accepted for meeting the minimum qualification
    requirements.
    Special Note

    To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or on-line applications programming.



    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.

  • Manhattan District Attorney's Office

    Database Administrator

    5 days ago

    Manhattan District Attorney's Office New York, United States Full time

    Position Summary · : · The New York County District Attorney's Office (DANY) has an opening for a full-time Database Administrator in its Information Technology (IT) Department. Working with a Senior Database Administrator, the Database Administrator will be responsible for the m ...

  • automotiveMastermind Inc.

    Database Administrator

    1 week ago

    automotiveMastermind Inc. New York, United States

    Our organization is seeking a skilled and experienced Database Administrator. This position will be an instrumental member of the team, helping to ensure the security, availability, and performance of our databases. Ideally, candidates will possess a drive for thinking creatively ...

  • Priority Groups

    Database Administrators

    2 weeks ago

    Priority Groups New York, United States

    Job Description · Job DescriptionOverview: · ESO Consultants is currently seeking Database Administrators to join our team. This role entails various responsibilities including database technical design, storage configuration, backup and recovery, troubleshooting, and performance ...

  • Pyramid Consulting

    Database Administrator

    3 weeks ago

    Pyramid Consulting New York, United States

    Immediate need for a talented Database Administrator. This is a 06+ months Contract opportunity with long-term potential and is located in Bloomfield, CT (Onsite). Please review the job description below and contact me ASAP if you are interested. · Apply promptly A high volume o ...

  • Stone Search

    Database Administrator

    2 days ago

    Stone Search New York, United States

    Job Description · Job DescriptionDatabase Administrator · *US Citizens or GC Holders · Location: NYC- hybrid remote- a few days on-site · Skills:Develop, modify, and implement changes as needed to resolve user-reported issues (critical and non-critical basis). · Manage and monito ...

  • S&P Global

    Database Administrator

    1 week ago

    S&P Global New York, United States

    About the Role: · Grade Level (for internal use): · 10 · Our organization is seeking a skilled and experienced Database Administrator. This position will be an instrumental member of the team, helping to ensure the security, availability, and performance of our databases. Idea ...

  • QUANTEAM North America

    Database administrator

    1 week ago

    QUANTEAM North America New York, United States

    Analyse, and Test databases, make modifications and correct errors, Implement security measures to ensure that databases are secure against attack both intentional and accidental Ensure that all database systems are tested and functioning correctly.Identify, evaluate and recommen ...

  • KINESSO

    Cloud Database Administrator

    2 days ago

    KINESSO New York, United States

    Business Overview · KINESSO is the technology-driven performance marketing agency that sits at the very heart of IPG Mediabrands, providing actionable growth for both our agency partners and clients. We turn 'action' into 'outcome' for our clients, leveraging our unique capabili ...

  • Canon Business Process Services

    HR Database Administrator

    4 weeks ago

    Canon Business Process Services New York, United States

    Canon Business Process Services currently has an opening for a HR Database AdministratorThis role will be based at our Corporate Office (261 Madison Ave) in New York City. You will be required to be in the office on Tuesdays and Wednesdays. Canon Business Process Services ("Cano ...

  • Canon Business Process Services

    HR Database Administrator

    4 weeks ago

    Canon Business Process Services New York, United States

    Overview · The HR Database Administrator will be responsible for development, implementation, and maintenance of the human resources information systems (HRIS), human capital management (HCM) solution, and SQL databases for the HR department. This role will ensure internal proces ...

  • Canon Business Process Services

    HR Database Administrator

    3 weeks ago

    Canon Business Process Services New York, United States

    Overview · The HR Database Administrator will be responsible for development, implementation, and maintenance of the human resources information systems (HRIS), human capital management (HCM) solution, and SQL databases for the HR department. This role will ensure internal proces ...

  • Kinesso

    Cloud Database Administrator

    2 days ago

    Kinesso New York, United States

    Business Overview · KINESSO is the technology-driven performance marketing agency that sits at the very heart of IPG Mediabrands, providing actionable growth for both our agency partners and clients. We turn 'action' into 'outcome' for our clients, leveraging our unique capabil ...

  • adMarketplace

    Sr Database Administrator

    1 week ago

    adMarketplace New York, United States

    Design, develop, manage and maintain MySQL and Vertica databases that support development, testing and production operations. Perform and improve data replication using Tungsten and purging operations. Support software development with database operations including complex query ...

  • ResourceSys Inc

    Database Application Administrator

    3 weeks ago

    ResourceSys Inc Newark, United States

    Job Description · Job DescriptionJob Details · Requirement:Title: Application Administrator · Location: Newark, NJ (Hybrid)Duration: CTH (W2 - Role) · Skills: AWS RDS, Oracle/SQL, workato or any integration platforms, Scripting (Python, Powershell)Essential Functions:1. Strengthe ...

  • automotiveMastermind Inc.

    Database Administrator

    1 week ago

    automotiveMastermind Inc. New York, United States

    Our organization is seeking a skilled and experienced Database Administrator. This position will be an instrumental member of the team, helping to ensure the security, availability, and performance of our databases. Ideally, candidates will possess a drive for thinking creatively ...

  • Manhattan District Attorney

    Database Administrator

    3 weeks ago

    Manhattan District Attorney New York, United States

    Job Description · Division/Unit: Information Technology Department · CS Title: Community Coordinator · Position Title: Database Administrator · Salary Range: $72,779 - $95,735 · Position Summary: · The New York County District Attorney's Office (DANY) has an opening for a f ...

  • CyberTec

    Database Administrator

    4 weeks ago

    CyberTec New York, United States

    Role: Database Administrator / Analyst · Client: MTA · Location: New York City · Experience: up to 3 years · Rate : $40/HR C2C · The Safety & Security Department of the MTA IT is seeking the service of Database Administrator / Analyst "Counter" consultant.The Analyst/Counter ...

  • Experis

    Database Administrator

    1 week ago

    Experis New York, United States

    Our client is seeking a PostgreSQL DBA Engineer to join their team. · Title: PostgreSQL DBA Engineer · Permanent · Location: Jersey City, NJ (or White Plains, NY) · Hybrid: 2 days onsite, 3 days remote · Pay: $170k-$180k · Seeking a PostgreSQL Server Support Specialist for ...

  • Collabera

    SQL Database Administrator

    6 days ago

    Collabera Hoboken, United States

    Home · Search Jobs · Job Description · SQL Database Administrator · Direct Hire: Hoboken, New Jersey, US · Salary: $ Per Annum · Job Code: · End Date: · Days Left: 5 days, 3 hours left · Apply · Are you ready to take your career to the next level? Join us as a SQL Databa ...

  • Collabera

    SQL Database Administrator

    1 week ago

    Collabera Hoboken, United States

    Home · Search Jobs · Job Description · SQL Database Administrator · Direct Hire: Hoboken, New Jersey, US · Salary: $ Per Annum · Job Code: · End Date: · Days Left: 9 days, 3 hours left · Apply · Are you ready to take your career to the next level? Join us as a SQL Databa ...