Senior Database Analyst / Administrator

Type of Requisition:
Regular
Clearance Level Must Currently Possess:
None
Clearance Level Must Be Able to Obtain:
None Public Trust/Other Required:
None
Job Family:
IT Infrastructure and Operations Job Qualifications:
Skills:
Business Intelligence (BI), Database Architecture, Data Warehousing (DW), Relational Data Modeling Certifications:
None Experience:
7 + years of related experience US Citizenship Required:
No
Job Description:
Database Analyst /Administrator

GDIT has an opportunity for a dynamic and talented candidate to join our team supporting the Administrative Office of the US Courts (AOUSC) Mission Support Systems Division (MSSD) in one of its mission-critical applications that is used by all federal courts’ community. MSSD has a mature agile practice using the Scaled Agile Framework (SAFe) and supports a broad range of complex business systems which are instrumental to the AOUSC mission.

The Database Analyst/ Administrator will execute the following responsibilities:

- Works within an Agile solution development environment with daily scrums, biweekly sprint planning and quarterly Program Increment planning.

- Develops operating standards and best practices, including performance, security, scalability, and maintainability.

- Ensures the proper definition, control, and coordination of data elements and standards, and the facilitation of efficient data relationships, systems integration, and physical structure.

- Participates in the development and implementation of database management policies and standards for efficient quality control and data administration.

- Collaborates with Product Owners and users to gather business requirements and define and maps them to technical requirements. Meets with agency leaders and stakeholders, collaborating with other consultants and program/agency personnel regarding the development of innovative data analysis techniques.

- Demonstrates ability to document complex workflow designs to present to project team and stakeholders.

- Demonstrates ability to work on complex problems where analysis of situations or data requires an in-depth evaluation of multiple factors and frequently contributes to the development of new business strategy, ideas, and methods adhering to best practices within the Agile framework.

- Collects, analyzes, and interprets large amounts of data to help guide business decisions. Experience with using advanced statistical analysis, data mining, and predictive modeling techniques.

- Synthesizes disparate information and recognizes patterns and relationships across data; synthesizes large sets of data from multiple sources, develops data visualizations for the purposes of tracking key performance indicators and other critical metrics tied to program outcomes.

- Hosts and conducts peer reviews of the code of other developers on the team. Performs data validation and ensures data accuracy and integrity.

- Develops stored procedures, jobs, views, tables, and other database objects in SQL Server Management Studio.

- Designs and develops dimensional data models including start and snowflake schemas, fact and dimension tables, and enterprise data marts to support analytics, reporting and business intelligence solutions.

- Develops and deploys ETL packages using CI/CD pipeline. Exposure to core configuration management systems for version control.

- Works with Atlassian Suite of software development management tools.

- Indexes system and application logs in to the Splunk system monitoring application, then creates dashboards, alerts, and reports from those logs.

REQUIRED QUALIFICATIONS

- At least seven (7+) years of Server database maintenance and database analysis or similar role.

- Bachelor's degree in Computer Science, Computer Programming, Computer Engineering or relevant computer-based major. Experience may be considered in lieu of degree.

- Database or cloud certification preferred such as Microsoft Certified Azure Database Admini