Job Description :
Sr. SQL Server DBA
6+ Months Contract
Alpharetta, GA
The Senior Database Administrator is responsible for managing the development and support of multiple databases. The Senior Database Administrator is a hands-on senior database developer and provides advice and instruction on technical matters to database analysts and application developers. The position requires proficiency in most areas of SQL Server, including database modeling, programming, advanced query-writing, ETL, reporting, and SQL internals. Interpersonal skills are important as this individual is required to frequently interact with teammates, managers and personnel in various departments.
Duties & Responsibilities Include:
· Administration and management of SQL databases in development, quality assurance and production environments.
· Ability to exude calmness and present effective solutions in high-pressure situations.
· Troubleshoot and handle all database-related issues through to resolution.
· Proactive monitoring of 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 properly assessed and measured from a functionality and performance perspective.
· Provide technical subject matter expertise on all database design and development projects.
· SQL Development and performance tuning of database schema, stored procedures, etc.
· Additional responsibilities will involve system monitoring, metric reporting, and diagnostics.
· Will setup and manage fail-over clusters, developing and managing SSIS packages, database mirroring, and replications.
· Automate database management activities using PowerShell, SSIS, and other technologies as appropriate.
Knowledge & Experience:
· Experience managing large numbers of databases in a real time production environment required.
· Experience with database technologies such as MS SQL Server (2016 onwards) required
· Experience troubleshooting and resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, and data replication issues required
· Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler or other related monitoring/troubleshooting tools required
· Experience with database maintenance activities such as backup/recovery & capacity monitoring/management required
· Strong knowledge of how indexes work and management of index statistics & fragmentation required
· Experience in managing and making software deployments/changes in real time production environments preferred
· Experience collaborating with development teams on physical database design activities and performance tuning preferred
· Experience with Microsoft SQL Server Clustering, Replication, and Always on required.
· A deep specialized domain knowledge and expertise in deployed systems, i.e., scalable distributed systems algorithms, storage allocation algorithms, and deep database skills required
· Experience with PostgreSQL is a plus.
· Experience managing large databases desired.
Skills:
SQL programming, Problem Solving, Oral Communication Skills, Database Proficiency Computer Literacy, Math Aptitude, Critical Thinking, Analytic, Time Management
Education & Training:
Bachelor’s degree in computer science, related field or equivalent work experience required