Sr. SQL Server Database Administrator in Atlanta, GA at HUNTER Technical Resources

Date Posted: 11/11/2018

Job Snapshot

Job Description


Sr. SQL Server Database Administrator
Fulltime role in Atlanta, GA


Responsibilities:

Diagnose and Resolve problems around database performance, capacity, replication, T-SQL, etc.
Proactively monitor databases for errors and respond quickly and effectively to troubleshoot and resolve DB on-going issues on all environments.
Coordinate and schedule DB downtimes to perform DB maintenance procedures. i.e DB patching, upgrades, etc.
Define Backup and Recovery strategies using technologies used at CAI. Netapp Snapshots, SnapManager for SQL, Native SQL Server Backup/recovery Tools, Idera SQl Safe.
Performs advanced database administration activities including but not limited to; DB Performance Tuning, T-SQL tuning, Backup and recovery and DB disaster recovery solutions.
Stay current with changes in the technical area of expertise.
Design and implement highly available production systems using the following technologies: Database Mirroring, Log Shipping, Windows/SQL clustering and availability groups.
Review scripts submitted by the Development team for performance and standard adherence.
Work with development teams to deploy code in production when needed.
Participate in on-call rotations.

Requirements:

Bachelor’ s degree or equivalent work experience
5+ years’ experience in Microsoft Windows/ SQL Server Technologies,
Experience with ETL, DTS, T-SQL, SQL Server, and SSRS, SSIS.
Ability to work with minimal direction, yet also able to work in team environment.
Performance tuning for SQL server, queries, stored procedures, views, etc.

Experience with SQL in virtual, physical and cloud based environments.
Proven ability to quickly learn and implement new technologies
Experience migrating databases in the cloud (AWS/Azure)