Jobless Developer
Pyramid Consulting logo

Posted 1 month ago

Open

Sr. SQL Server DBA

AtlantaOn-siteFull-time

AI Summary

Senior SQL Server DBA responsible for configuring, maintaining, and tuning SQL Server database servers for performance, availability, and security; designing database schemas and ETL processes; and troubleshooting issues.

About this role

Sr. SQL Server DBA

Confidential

Job Title: Sr. SQL Server DBA

Location:Atlanta, GA

Duration: Long Term Contract

Job Description:-

·Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

·Design and implement database scheme and process flow; Analyse Client data to determine necessary data constraints.

·Troubleshoot performance issues and determine the most effective way to increase performance including server configuration changes, index/query changes, statistic updates or partitioning.

·Ensure proper backup and recovery processes are in place.

·Maintain security and integrity controls.

·Build robust ETL solutions to gather data from multiple systems and cleanse and de-dupe the data.

·Bachelor's degree in Computer Science, Mgmt. Information Systems, Mathematics or related discipline; 5-8 years technical expertise in database development and administration.

·Additionally, although not required, experience/familiarity in the following is a plus: .NET/C# language and Oracle dbms.

·Administration setup and optimization; SQL Server query performance optimization, file manipulation, exception handling; 5-8 years of experience in systems analysis, applications development and systems architecture;

Management Skills:

·A minimum 5+ years of database administration and T-SQL experience - performance tuning, DTS/SSIS, stored procedures, triggers, views.

·Microsoft SQL Server dbms expertise required, familiarity with or additional skill set including Oracle dbms is a significant benefit.

·Job's primary skill is database administration, but note that SQL Server programming is a highly desirable secondary skill or prior work experience.

Primary Skill: SQL Server Admin

Additional Skills:

·SQL Server Admin – Advanced

·SQL Language – Advanced

·SQL Programming – Advanced

·XML – Beginner

·Data Modeling – Intermediate

·Windows Operating System – Intermediate

·Technical Knowledge of Hardware & Software – Intermediate

·Microsoft Office – Beginner

·VB Script - Intermediate

Additional Information

All your information will be kept confidential according to EEO guidelines.

Skills

C++Data ModelingETLHardware And Software Technical KnowledgeMicrosoft Office.NETOracleSQL ServerSSISStored ProceduresTriggersT-SQLVBScriptViewsWindows Operating System

Explore related jobs

Browse these categories