Jobs
>
Brooklyn

    NG911 SQL Engineer - New York, United States - Princeton IT Services

    Princeton IT Services
    Princeton IT Services New York, United States

    3 weeks ago

    Default job background
    Description

    Job Description

    Job Description

    Job Title: NG911 SQL Engineer
    Location: Brooklyn, NY (2 days in office)
    Duration: 12 Months Months
    Responsibilities:
    Database Review and Maintenance

    • Review all Microsoft SQL Server databases.
    • Identify any issues such as performance bottlenecks, fragmentation, or inconsistencies.
    • Perform routine maintenance tasks such as index rebuilds, statistics updates, and database integrity checks.

    Always On Availability Group Maintenance

    • Monitor and maintain Always On Availability Groups for SQL Clusters.
    • Ensure synchronization state across replicas.
    • Perform failover testing and handle failover scenarios as necessary.

    Best Practice Recommendations

    • Review SQL Server and database requests as part of the build cycle.
    • Provide best practice recommendations for database design, performance tuning, and security.

    SQL Updates and Patching

    • Schedule and perform SQL Server updates and patches.
    • Coordinate with stakeholders to minimize downtime and ensure updates are applied in a timely manner.

    Application Migration to SQL 2019

    • Assess existing applications and databases.
    • Work with application owners to plan and execute migrations to SQL Server 2019.
    • Ensure compatibility and performance optimization during the migration process.

    SQL Server Consolidation

    • Identify opportunities to consolidate SQL servers into shared instances.
    • Evaluate resource utilization and performance impact.
    • Plan and execute server consolidation efforts while minimizing disruption to existing services.

    Root Cause Analysis

    • Perform root cause analysis on internal and external data and processes.
    • Identify patterns, trends, and anomalies to answer specific business questions.
    • Propose data-driven solutions and opportunities for improvement.

    Project Management Support

    • Provide project management support for SQL-related initiatives.
    • Coordinate tasks, timelines, and resources to ensure successful project delivery.
    • Communicate effectively with stakeholders to provide updates and manage expectations.

    Backup and Recovery Management

    • Review and optimize SQL backup schedules and technologies.
    • Implement backup strategies to ensure data integrity and disaster recovery readiness.
    • Monitor backup jobs, troubleshoot failures, and perform periodic recovery tests.
    • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

    MANDATORY SKILLS/EXPERIENCE:

    • Minimum 12 years of experience in the following:
    • Microsoft SQL Engineer/DBA must possess advanced SQL querying skills, including expertise in writing complex SQL queries, stored procedures, triggers, and optimizing SQL performance.
    • Proficiency in database administration tasks such as database creation, configuration, monitoring, backup and recovery, security management, user access control, and database optimization.
    • Knowledge and experience in implementing and maintaining high availability solutions such as Always On Availability Groups, database mirroring, failover clustering, and disaster recovery planning.
    • Ability to diagnose and troubleshoot database-related issues effectively, using tools such as SQL Server Profiler, Dynamic Management Views (DMVs), and Extended Events.

    DESIRABLE SKILLS/EXPERIENCE:
    Knowledge of MySQL, Oracle, MongoDB, VMWare, AD, DNS

  • Abidi Solutions

    SQL Engineer

    3 weeks ago

    Abidi Solutions New York, United States

    Job Description · Job DescriptionJob Title: NG911 SQL Engineer - Specialist 3 Work Setting: Hybrid Hours Per Week: 35 Location: Brooklyn, New York, 11201 Start Date: June 17, 2024 Contract Length: 52 weeks Must have : Minimum 12 years of experience Scope of Services Database Revi ...

  • Abidi Solutions

    SQL Engineer

    3 weeks ago

    Abidi Solutions New York, United States

    Job Description · Job DescriptionJob Title: SQL Engineer (NG911 Call Handling Support) - Specialist 3 Work Setting: Hybrid Hours Per Week: 35 Location: Brooklyn, New York, 11201 Number of Positions: 2 Scope of Services: Database Review and MaintenanceReview all Microsoft SQL Serv ...

  • RightTalents LLC

    SQL Engineer

    4 weeks ago

    RightTalents LLC New York, United States

    Job Description · Job DescriptionTitle: SQL Engineer · Duration: 12 Months · Location: Brooklyn, NY (Hybrid) · Working Hours: 35 Hrs/Week · Hybrid: Work location & Remote (2 days in office/3 days remote) · JOB DESCRIPTION: · Review all Microsoft SQL Server databases. · Identif ...

  • Comprehensive Resources Inc

    NG911 SQL Engineer

    3 weeks ago

    Comprehensive Resources Inc New York, United States

    Role:NG911 SQL Engineer · Exp:10+Years · Location:Brooklyn,NY(Hybrid) · NOTE : NG911 is Mandatory · Job Description: · TASKS: · Database Review and Maintenance · Review all Microsoft SQL Server databases. · Identify any issues such as performance bottlenecks, fragmentation, or in ...

  • Ariel Partners

    Public Safety SQL Engineer

    4 weeks ago

    Ariel Partners New York, United States

    Job Description · Job DescriptionSalary: up to $102 · This position is Hybrid (2 days in office/3 days remote) · SCOPE OF SERVICES: · Ariel Partners is looking for a Public Safety SQL Engineer. The Public Safety SQL Engineer (NG911 Call Handling Support) is urgently needed to pro ...

  • IS3 Solutions

    Nextgen911/SQL Engineer SP3

    4 weeks ago

    IS3 Solutions Brooklyn, United States

    Location: Brooklyn, NY - Hybrid (3-Days Remote) · SQL Engineer (NG911 Call Handling Support) is urgently needed to provide critical support for life-safety databases utilized in Next Generation 911 (NG911) call delivery. Engineers are required to configure, manage, maintain, and ...

  • Compu-Vision Consulting

    nextgen 911 sql engineer

    3 weeks ago

    Compu-Vision Consulting Brooklyn, United States

    Title: NEXT GEN 911/SQL ENGINEER · Location: Brroklyn, NY · Hybrid: Work location & Remote (2 days in office/3 days remote) · Duration: 1 year · Job Description: · SQL Engineer is urgently needed to provide critical support for life-safety databases utilized in Next Generation 91 ...

  • Connvertex Technologies Inc.

    SQL Server Data Engineer

    2 days ago

    Connvertex Technologies Inc. New York, United States

    Job Description · Job DescriptionKey skills: SQL Server, SSIS, C#, Python (Numpy, Pandas), financial experience · SQL Server Data Engineer · Job description: · 5+ years' experience required · Strong knowledge of Microsoft SQL Server, including designing, developing, and implemen ...

  • St. Mary's Healthcare System for Children

    Senior SQL Data and Systems Engineer

    3 weeks ago

    St. Mary's Healthcare System for Children New York, United States

    St. Mary's Hospital for Children, in Bayside, Queens, NY, a technologically innovative healthcare system providing state-of-the art care to children with complex medical conditions in our inpatient and community programs, is seeking an expert SQL developer with proven knowledge o ...

  • Crescens

    MS SQL Engineer

    3 weeks ago

    Crescens New York, United States

    Job title : MS SQL Engineer / DBA · Location: NYC (2 days in office/3 days remote) · Duration : 12+ months · Type : Contract · ****** This is 35 work hours per week****** · SCOPE OF SERVICES · 1. Database Review and Maintenance Review all Microsoft SQL Server databases. · Ident ...

  • Expert In Recruitment Solutions

    SQL Engineer

    3 weeks ago

    Expert In Recruitment Solutions Iselin, United States

    ROLE: SQL Engineer · TASKS: · Database Review and Maintenance · o Review all Microsoft SQL Server databases. · o Identify any issues such as performance bottlenecks, fragmentation, or inconsistencies. · o Perform routine maintenance tasks such as index rebuilds, statistics updat ...

  • Career Developers, Inc.

    SQL Data Engineer

    3 weeks ago

    Career Developers, Inc. Montvale, United States

    SQL Data Engineer (4-6 years of experience) · Location : Montvale, NJ - Hybrid 2 days a week · Salary : K · Summer hours, great perks, and benefits · Please note the following:This person must be a US Citizen or be a Green Card holder to be considered for this role. · Relocation ...

  • eTeam

    BI Engineer-SQL+Tableau

    1 week ago

    eTeam Secaucus, United States

    Required Skill: SQL, Snowflake, Tableau. · Good to have: Matillion, Power BI. · Job Details: · Develop key product features within existing large-scale enterprise applications and new strategic initiatives that will drive system and operational efficiencies, measure system p ...

  • St. Mary's Healthcare System for Children

    Senior SQL Data and Systems Engineer

    3 weeks ago

    St. Mary's Healthcare System for Children New Hyde Park, United States

    St. Mary's Hospital for Children, in Bayside, Queens, NY, a technologically innovative healthcare system providing state-of-the art care to children with complex medical conditions in our inpatient and community programs, is seeking an expert SQL developer with proven knowledge o ...

  • City of New York

    it project manager

    1 week ago

    City of New York Brooklyn, United States Full time

    New York City Emergency Management (NYCEM) helps New Yorkers before, during, and after emergencies through preparedness, education, and response. NYCEM is responsible for coordinating citywide emergency planning and response for all types and scales of emergencies. We are staffed ...

  • KeyBank

    Data Science Senior Manager, Financial Crimes

    2 weeks ago

    KeyBank Brooklyn, United States Full time

    Location: · 4900 Tiedeman Road - Brooklyn, Ohio ABOUT THE JOB (JOB BRIEF) · The Data Science Senior Manager is primarily responsible for leading a quantitative analytics team in support of quantitative analysis including model development, validation, and maintenance. This ro ...

  • JPMorgan Chase Bank, N.A.

    Python Lead Software Engineer

    2 weeks ago

    JPMorgan Chase Bank, N.A. Brooklyn, United States

    We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible. · As a Lead Software Engineer at JPMorgan Chase within the Corporate Sector in Risk Technology space , you are an integral part of an agile team that works to ...

  • Shaped

    Senior Solutions Engineer

    2 days ago

    Shaped Brooklyn, United States Full time

    Company Description · Shaped is a machine-learning platform for data teams to build real-time personalized recommendation systems and search. We want to give any company the same superpowers that TikTok, Meta and Amazon use to power their personalization. · We're based in Brook ...

  • Amplify

    Analytics Engineer

    1 week ago

    Amplify Brooklyn, United States

    A pioneer in K-12 education since 2000, Amplify is leading the way in next-generation curriculum and assessment. Our core and supplemental programs in ELA, math, and science engage all students in rigorous learning and inspire them to think deeply, creatively, and for themselves. ...

  • Amplify

    Associate Analytics Engineer

    1 week ago

    Amplify Brooklyn, United States Freelance

    A pioneer in K-12 education since 2000, Amplify is leading the way in next-generation curriculum and assessment. Our core and supplemental programs in ELA, math, and science engage all students in rigorous learning and inspire them to think deeply, creatively, and for themselves. ...