Posted 109 months ago
Sr. SQL Server DBA
AI Summary
Sr. SQL Server DBA Confidential Job Title: Sr. SQL Server DBALocation:Atlanta, GADuration: Long Term ContractJob 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 increas
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.
Explore related jobs
More jobs at Pyramid Consulting
Jobs in Atlanta
Sales - US Junior Account ManagerYoulend · Atlanta- AService Delivery ManagerAmerican Technology Services LLC · Atlanta, Gabon
- Partner Manager7factor Software · Atlanta, Gabon
Service Delivery ExecutiveCyderes · Atlanta, Gabon- WStaff Engineer (Geotechnical)Willmer Engineering · Atlanta, United States
- WGeotechnical Project EngineerWillmer Engineering · Atlanta, United States