Database Administrator (Junior)

Aegis Corps

Full-time - Entry Level

Administrative and Support Services

About the position

The Junior Database Administrator at ACI will provide essential organizational support for a high-profile project in Washington DC. This role involves testing, implementing, maintaining, and controlling databases across various platforms and technologies within an Azure cloud environment. The position requires strong functional and technical knowledge, along with programming skills, to ensure high data quality and effective problem resolution.

Responsibilities

• Test, implement, maintain, and control the organization's databases across multiple platforms and technologies.
• Perform disciplined execution of established data warehouse ETL programs and refresh procedures.
• Execute manual data extractions, downloads, and pre-processing of FTP data files for the data mart.
• Test and implement new releases to the data mart.
• Contribute to the development of new methods, procedures, processes, or systems and understand their impact.
• Provide support and expertise in investigating and resolving performance-related issues in warehousing environments.
• Proactively monitor and remedy data quality failures in ETL and refresh processes.
• Support the installation and upgrading of database software and resolve related problems.
• Evaluate potential tools and utilities for database management.
• Automate database tasks via scripting or tools.
• Configure, monitor, and review statistics for errors, capacity, and performance issues.
• Tune and troubleshoot software and database performance issues.

Requirements

• College degree in computer science from an accredited university.
• Basic knowledge and experience in SQL Server programming is mandatory.
• Some experience in programming languages such as Python, Java, PL/SQL, .NET, and SAS is highly preferred.
• Background and prior experience in working with databases in data warehousing environments is desirable.

Nice-to-haves

• Experience with multiple programming languages is preferred.

Benefits

• Health insurance
• Dental insurance
• Disability insurance
• Paid time off
• 10 paid holidays
• Company provided life insurance
• 401K