Senior SQL Server DBA: Performance & ETL Architect

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

· 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:

· Technical Knowledge of Hardware & Software – Intermediate

Additional Information

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

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply