NG911 SQL Engineer

1 month ago

New York, United States Comprehensive Resources Inc Full time

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 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 Note:

  • Minimum 10 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

  • NG911 SQL Engineer

    1 month ago

    New York, United States Comprehensive Resources Inc Full time

    Role:NG911 SQL EngineerExp:10+YearsLocation:Brooklyn,NY(Hybrid)NOTE : NG911 is MandatoryJob Description:TASKS:Database Review and MaintenanceReview 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...

  • NG911 SQL Engineer

    1 month ago

    New York, United States Comprehensive Resources Full time

    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 inconsistencies. Perform routine maintenance tasks such as index rebuilds, statistics updates,...

  • SQL Server Data Engineer

    4 weeks ago

    New York, United States Connvertex Technologies Inc. Full time

    Job DescriptionJob DescriptionKey skills: SQL Server, SSIS, C#, Python (Numpy, Pandas), financial experience SQL Server Data EngineerJob description:5+ years' experience requiredStrong knowledge of Microsoft SQL Server, including designing, developing, and implementing complex SQL queries, stored procedures, and functions.Expertise in Python programming,...

  • MS SQL Engineer

    1 month ago

    New York, United States Crescens Full time

    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. Identify any issues such as performance bottlenecks, fragmentation, or inconsistencies. ...

  • MS SQL Engineer

    1 month ago

    New York, United States Crescens Full time

    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. Identify any issues such as performance bottlenecks, fragmentation, or inconsistencies. ...

  • Sr. Data Engineer

    1 month ago

    New York, United States Planet Technology USA Full time

    Sr. Data Engineer- SQL Server Expert with Investment experience Fulltime Job in NY - Hybrid-Please do not apply if not local to NY No C2C - Must be able to work without sponsorship Position: Sr Data Engineer - Strong SQL Application Development You will be working with a skilled team and help in defining the future of their data platform environment. You...

  • Sr. Data Engineer

    1 month ago

    New York, United States Planet Technology Full time

    Sr. Data Engineer- SQL Server Expert with Investment experienceFulltime Job in NY - Hybrid-Please do not apply if not local to NYNo C2C - Must be able to work without sponsorshipPosition: Sr Data Engineer - Strong SQL Application DevelopmentYou will be working with a skilled team and help in defining the future of their data platform environment. You will be...

  • Sr. Data Engineer

    4 weeks ago

    New York, United States Planet Technology Full time

    Sr. Data Engineer- SQL Server Expert with Investment experienceFulltime Job in NY - Hybrid-Please do not apply if not local to NYNo C2C - Must be able to work without sponsorshipPosition: Sr Data Engineer - Strong SQL Application DevelopmentYou will be working with a skilled team and help in defining the future of their data platform environment. You will be...

  • Lead SQL Server Data Engineer

    3 weeks ago

    New York, United States HatchPros Inc Full time

    Job DescriptionJob DescriptionUSC/OPT-EAD/H4-EADZoomHybridNeed LinkedInKey skills: SQL Server, SSIS, C#, Python (Numpy, Pandas), financial experience (Investment Banking)Job description:5+ years' experience requiredStrong knowledge of Microsoft SQL Server, including designing, developing, and implementing complex SQL queries, stored procedures, and...

  • Lead SQL Server Data Engineer

    3 weeks ago

    New York, United States HatchPros Inc Full time

    Job DescriptionJob DescriptionUSC/OPT-EAD/H4-EADZoomHybridNeed LinkedInKey skills: SQL Server, SSIS, C#, Python (Numpy, Pandas), financial experience (Investment Banking)Job description:5+ years' experience requiredStrong knowledge of Microsoft SQL Server, including designing, developing, and implementing complex SQL queries, stored procedures, and...

  • SQL Developer

    1 month ago

    New York, United States Mondo Full time

    Apply now: SQL Developer, this is a 100% remote opportunity. The start date is ASAP for this long-term contract positio n Job Title: SQL Developer Location-Type: 100% Remote Start Date Is: ASAP Duration: Contract Compensation Range: $55-65 Per Hour W2 The estimate above represents the candidate's typical compensation range at the time of hire. Several...

  • SQL Developer

    1 month ago

    New York, United States Mondo Full time

    Job DescriptionJob DescriptionApply now: SQL Developer, this is a 100% remote opportunity. The start date is ASAP for this long-term contract positio nJob Title: SQL DeveloperLocation-Type: 100% RemoteStart Date Is: ASAPDuration: ContractCompensation Range: $55-65 Per Hour W2 The estimate above represents the candidate's typical compensation range at...

  • SQL Developer

    1 month ago

    New York, United States Mondo Full time

    Job DescriptionJob DescriptionApply now: SQL Developer, this is a 100% remote opportunity. The start date is ASAP for this long-term contract positio nJob Title: SQL DeveloperLocation-Type: 100% RemoteStart Date Is: ASAPDuration: ContractCompensation Range: $55-65 Per Hour W2 The estimate above represents the candidate's typical compensation range at...

  • Development support Engineer

    3 weeks ago

    New York, United States HCLTech – Engineering and R&D Services Full time

    For better understanding here is the job descriptionRole: Development support EngineerLocation: EST Zone (Remote)Job Description: Pref skills : Python, SQL, Linux,Good to have : Dev / User support experienceRequired hand on Coding Experience into Python & SQLProvide Development support to Software development community across the organization by managing,...

  • SQL Developer

    3 weeks ago

    New York, United States ATD Technology LLC Full time

    Job DescriptionJob DescriptionJOB DESCRIPTION: Title: SQL Developer Reports To Senior Manager ERP/Reporting Location: Hauppauge, NY (Onsite Hauppauge, Long Island to start then Garden City, Long Island ( Company will be moving within the next year)Job Summary: In the SQL Developer role, you will be working directly under the supervision of Sr. Manager of...

  • SQL Developer

    3 weeks ago

    New York, United States ATD Technology LLC Full time

    Job DescriptionJob DescriptionJOB DESCRIPTION: Title: SQL Developer Reports To Senior Manager ERP/Reporting Location: Hauppauge, NY (Onsite Hauppauge, Long Island to start then Garden City, Long Island ( Company will be moving within the next year) - 3 days onsite/2 days remote Job Summary: In the SQL Developer role, you will be working directly under the...

  • SQL Developer

    2 weeks ago

    New York, United States ATD Technology LLC Full time

    Job DescriptionJob DescriptionJOB DESCRIPTION: Title: SQL Developer Reports To Senior Manager ERP/Reporting Location: Hauppauge, NY (Onsite Hauppauge, Long Island to start then Garden City, Long Island ( Company will be moving within the next year)Job Summary: In the SQL Developer role, you will be working directly under the supervision of Sr. Manager of...

  • SQL Developer

    2 weeks ago

    New York, United States ATD Technology LLC Full time

    Job DescriptionJob DescriptionJOB DESCRIPTION: Title: SQL Developer Reports To Senior Manager ERP/Reporting Location: Hauppauge, NY (Onsite Hauppauge, Long Island to start then Garden City, Long Island ( Company will be moving within the next year) - 3 days onsite/2 days remote Job Summary: In the SQL Developer role, you will be working directly under the...

  • Senior Data Engineer

    1 month ago

    New York, United States Synechron Full time

    We are At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • SQL Developer

    1 month ago

    New York, United States Petadata Full time

    Job DescriptionJob DescriptionPosition: SQL DeveloperLocation: New York City, NY- only local (Hybrid)Experience: 10+ YearsWork type: C2CPETADATA is currently looking to hire for the position of SQL Developer for one of their clients.Roles & Responsibilities:Must collaborate with application developers and business analysts to design and implement efficient...