Must have minimum of 12+ years of experience.
Job Description –
Job Title: NG911 SQL Engineer
NG911 SQL Engineer HYBRID
Location: Brooklyn, NY 11201
Duration: 12 Months
Job Description:
Hybrid – 2 days in office/3 days remote
Must Have LinkedIn.
SCOPE OF SERVICES
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. o 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
- Must have 12 years’ Experience.
- 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
- SQL querying
- database administration
- high availability solutions
- troubleshooting
- Always On Availability Groups
- SQL Server Profiler
- database mirroring
- failover clustering
From:
Harsh Goyal,
Vizon Inc
harsh@vizoninc.com
Reply to: harsh@vizoninc.com