Senior Database Analyst/Administrator

General Dynamics Information Technology; Virginia; On-site; USD 110,000 - 150,000; Full time

Job summary

General Dynamics Information Technology (GDIT) invites applications for a Database Analyst/Administrator to support the AOUSC Mission Support Systems Division. The role involves agile development practices, data modeling, DW concepts, and cloud-based database solutions across SQL Server, Informix, Oracle, Snowflake, and Azure.

The candidate will design data warehouses, develop ETL pipelines, and produce dashboards and reports to drive program outcomes, with strong emphasis on data quality and

Qualifications

• 7+ years of server database maintenance or related role.
• Degree in CS/Engineering or equivalent experience.
• Database certifications preferred (Azure, SQL Server).
• Proficient with SQL Server, Informix, and Oracle.
• Experience with Snowflake and Azure cloud platforms.
• Understanding of data warehousing concepts.
• Adept in data modeling, mapping, flows, and data marts.
• Experience building cloud-based database solutions.
• Experience migrating data from on-prem to multi-cloud.
• Strong problem-solving, communication, and time management.

Responsibilities

• Participate in Agile SCRUM rituals with daily stand-ups and sprint planning.
• Develop operating standards for performance, security, and scalability.
• Define data elements and ensure proper data relationships and integration.
• Gather business requirements from Product Owners and stakeholders.
• Document complex workflow designs for the project team.
• Analyze complex data problems and contribute to new business strategies.
• Collect, analyze, and interpret large data sets to guide decisions with stats and data mining.
• Create data visualizations and dashboards to track KPIs and metrics.
• Review code with peers and validate data accuracy and integrity.
• Develop stored procedures, views, tables, and database objects in SSMS.
• Design dimensional models (star/snowflake) and data marts for BI.
• Develop and deploy ETL packages using CI/CD; manage version control.
• Work with Atlassian tools for project management.
• Index logs in Splunk and create dashboards, alerts, and reports.

Skills

Database maintenance

Database analysis

Data modeling

Data mapping

Data flow diagrams

Data marts

Analytical skills

Communication skills

Time management

Independent work

Education

Bachelor's degree in Computer Science/Engineering

Tools

SQL Server

Informix

Oracle

Snowflake

Azure

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.
• 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 Administrator Associate, Microsoft Azure Solutions Architect Expert or equivalent industry recognized database certification.
• Proficient experience with Databases like Microsoft SQL Server, Informix, Oracle.
• Experience with Snowflake and exposure to cloud platforms, Azure cloud platform.
• Demonstrated understanding of standard Data warehouse concepts.
• Adept with data modeling, data mapping, data flow diagrams and data marts.
• Previous experience architecting and implementing cloud-based database solutions on various platforms.
• Experience with Data migration from legacy on-premises database to multi-cloud/hybrid cloud platforms.
• Proven ability to spearhead and work independently, prioritize, and get things done.
• Strong analytical, technical, problem-solving skills.
• Excellent organization and time management skills and ability to identify priorities to accomplish a variety of tasks on schedule.
• Excellent written and oral communication skills and ability to work with people at every level. Comfortable writing down ideas, implementation plans and status reports.

PREFERRED QUALIFICATIONS

• Experience creating and managing database reports, visualizations, and dashboards.
• Knowledge of court operations and law enforcement business data.