Job for SQL Engineer

1 Open Positions

Brookyln , NY
Estimated Best In Industry
12 Months
Posted on: 05/22/2024
Job Description:

Hybrid: Work location & Remote (2 days in office/3 days remote)

 

  • 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 data-driven solutions and opportunities for improvement.
  • 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.
  • 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.

Responsibilities:

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.

Requirements:

  • Knowledge of MySQL, Oracle, MongoDB, VMWare, AD, DNS

Copyright @2023 RighTalents. All Rights Reserved by RightTalents LLC | Developed by devGroves Technologies