Sr. SQL Server DBA

Pyramid Consulting; Atlanta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

Pyramid Consulting is seeking an experienced Database Administrator in Atlanta, Georgia. The ideal candidate will have a Bachelor's degree and 5-8 years of experience in database development and administration, with expertise in SQL Server. Responsibilities include configuring, maintaining, and optimizing database servers to ensure high performance and security.

Familiarity with .NET/C# and Oracle DBMS is a plus. The position offers a chance to work with cutting-edge technology in a confidential environment, adhering to EEO guidelines.

Qualifications

• 5-8 years of technical expertise in database development and administration.
• Experience in SQL Server query performance optimization and file manipulation.
• Experience in systems analysis, applications development, and systems architecture.

Responsibilities

• Configure and maintain database servers and processes.
• Design and implement database schema and process flow.
• Troubleshoot performance issues and optimize performance.

Skills

Database Administration

T-SQL

SQL Server

.NET/C#

Oracle DBMS

Education

Bachelor's degree in Computer Science or related discipline

Job description

Responsibilities

• 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.

Qualifications

• 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.

Primary Skill

SQL Server Admin

Additional Skills

• Technical Knowledge of Hardware & Software – Intermediate

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