SQL DBA

Company: ITAC Solutions, LLC
Location: Birmingham
Posted on: January 12, 2021

Job Description:

ITAC is helping a great organization in Birmingham, AL as they search for a SQL Database Administrator--to provide technical support for the database environment.What you'll be doing (duties of this position):* Manage SQL databases in development, QA and production environments* Resolve all database-related issues* Monitor databases both from a performance and capacity management perspective* Perform database maintenance activities such as backup/recovery and rebuilding/reorganizing indexes* Ensure that all database releases are assessed and measured from a functionality and performance perspective* Provide technical expertise on all database design (Logical and Physical modeling) and development project* Demonstrate SQL Development(T-SQL) expertise related to performance tuning of the database schema, stored procedures, etc.* Create and schedule SQL Server agent jobs.* Set-up and manage fail-over clusters (in partnership with Infrastructure)* Develop SSIS packages, database mirroring, and replications* Automate database management activities using PowerShell, SSIS, and other technologies* Perform system monitoring, metric reporting, and diagnosticsWhat you'll need to be considered (requirements): * 4+ years DBA experience with Microsoft SQL Server (2008 or greater) in a production environment is required.* Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler or other related tools* Ability to manage all DB maintenance plan activities including backups, indexing, integrity and consistency checks, etc.* Experience managing large numbers of databases in a real-time production environment* Understanding of Virtual Server environments.* Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler or other related tools* Experience resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, and data replication issues* Experience with database maintenance activities such as backup/recovery and capacity monitoring/management* Knowledge of how indexes work; management of index statistics and fragmentation* Deep, specialized domain expertise in deployed systems (i.e. distributed systems algorithms, storage allocation algorithms, and deep database skills)

Keywords: ITAC Solutions, LLC, Birmingham , SQL DBA, Other , Birmingham, Alabama