SQL Engineernbsp

Title: 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.
• Identify any issues such as performance bottlenecks fragmentation or inconsistencies.
• Perform routine maintenance tasks such as index rebuilds statistics updates and database integrity checks.

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

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

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

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

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

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

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

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

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 databaserelated 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