Junior Azure Data Warehouse DBA (ETL & SQL)

Aegis Corps, Inc.; Washington (District of Columbia); On-site; USD 65,000 - 90,000; Full time

Job summary

Aegis Corps, Inc. is seeking a Junior Database Administrator to support a high profile project in Washington DC.

The role involves testing, implementing, maintaining and controlling databases across platforms in an Azure cloud environment, applying technical knowledge to ensure data quality and resolve issues. Responsibilities include ETL execution, data extractions, data mart testing, and improving methods and processes.

Qualifications

• College degree in computer science from an accredited university.
• Solid knowledge of SQL Server programming.
• Experience with Python, Java, PL/SQL, .NET, or SAS is highly preferred.
• Experience in data warehousing environments is desirable.

Responsibilities

• Perform disciplined, auditable execution of established data warehouse ETL (extract/transform/load) programs and refresh procedures.
• Execute disciplined, recurring manual data extractions, downloads, and pre-processing of FTP data files as inputs to datamart.
• Test and implement new releases to data mart.
• Contribute to the development of new methods, procedures, processes or systems and understand the impact of these changes.
• Provide support and expertise in investigation and resolution of performance related issues for warehousing environments.
• Proactively monitor and remedy data quality failures in recurring data mart ETL and refresh processes.
• Provide support in installing & upgrading database software and resolving database software problems.
• Perform evaluations of potential tools & utilities.
• Automate database tasks via scripting or through the use of tools.
• Proactively configure, monitor, and review statistics for errors, capacity and performance issues.
• Tune and troubleshoot software & database performance issues.

Education

College degree in computer science

SQL Server programming

Python

Java

PL/SQL

.NET

SAS

Azure

Tools

Azure

Job description

Aegis Corps, Inc. is seeking a Junior Database Administrator to support a high profile project in Washington DC.

The role involves testing, implementing, maintaining and controlling databases across platforms in an Azure cloud environment, applying technical knowledge to ensure data quality and resolve issues. Responsibilities include ETL execution, data extractions, data mart testing, and improving methods and processes.