Database Administrator Backup/Recovery Performance Tuning RDBMS SQL Server T-SQL Failover

Profile

SC-10629-1
Daily duties / responsibilities:
Primarily, this position will provide senior-level support and guidance to our Child Care team.
In addition to this, this position will assist (at a senior-level) with the support, maintenance, security, and availability of our SQL environment. Designs, develops, implements, and maintains database, procedures, and functions that accommodate changing business priorities and technological changes while providing availability, scalability, performance, recoverability, reliability, and security.
Acts as liaison for SQL Server DB performance, integration, migration, upgrade, storage, and replication strategies.
Focuses on Performance Tuning of database instance across various applications/systems, to include indexing and optimizer strategies, stored procedures/triggers, partitioning, locking schemes, temporary spaces/sort area, and memory management.
Monitors the database systems to ensure secure services with minimum downtime.
Interacts with project management and Agile development teams to develop a strong understanding of the project and database development objectives.
Participates in troubleshooting and triaging of issues with different team members to drive towards root cause identification and resolution.
Documents, tracks and escalates issues as appropriate.
Participates in Scrum teams in support of Agile projects; end-to-end support for build, deployment, and operational activities.
Exercises considerable latitude, discretion, and independent judgment in determining technical objectives of assignments.
Routine operation maintenance including installations, upgrades, patching, monitoring, auditing, issue resolution.
Manage and prioritize multiple, diverse tasks simultaneously.
Must be flexible, independent and self-motivated.
Work collaboratively to meet team goals/mission.
Provide after-hours or weekend maintenance as needed.
Perform other duties as assigned.
Database Administrator:
Required skills: Database Administration Expert 6 Years
Backup/Recovery Expert 6 Years
Performance Tuning Expert 6 Years
RDBMS Expert 6 Years
SQL Server Expert 6 Years
T-SQL Expert 6 Years
Failover Clusters Expert 2-4 Years
High-Availability Expert 2-4 Years
DMVs Expert 2-4 Years
SSIS Expert 2-4 Years
SSRS Expert 2-4 Years
Profiler Expert 2-4 Years
SQL Tuning Expert 2-4 Years
Database planning, scaling, and capacity planning Expert 2-4 Years
SQL Server 2008R2 Expert 1-2 Years
SQL Server 2012 Expert 1-2 Years
SQL Server 2014 Expert 1-2 Years
SQL Server 2016 Expert 1-2 Years
SQL Server 2019 Expert 1-2 Years
ETL Advanced 2-4 Years
SSAS Advanced 2-4 Years
Verbal Communication Advanced 2-4 Years
Written Communication Advanced 2-4 Years
PowerShell Intermediate 1-2 Years
RedGate Toolset Intermediate 1-2 Years
SDLC Intermediate 1-2 Years
Required education: Bachelor's Degree or years of experience
****
Local:
518-218-1700
Map
& visit our office
Corporate - Albany NY
435 New Karner Rd, Ste 202
Albany NY 12205
Chicago
63E Lake Street, Ste 201
Chicago, IL 60601
Florida
17258 SE 121st Ave
Summerfield, FL 34491
© 2018 MVP Consulting Plus. All Rights Reserved.

Company info

Sign Up Now - DBACrossing.com