# Database Analyst /Administrator **Company**: GDIT **Location**: VA Home Office, VA **Work arrangement**: remote **Experience**: senior **Job type**: full-time **Salary**: $107,744 - $138,000 **Category**: IT **Industry**: Technology **Apply**: https://gdit.wd5.myworkdayjobs.com/en-US/External_Career_Site/job/USA-VA-Home-Office-VAHOME/Senior-Database-Analyst---Administrator_RQ226567-1?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply **Canonical**: https://yubhub.co/jobs/job_c54bd790-fc2 ## Description 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. 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 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. - Experienced with completing database environment installation, configuration, on-going administration support. - 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. The likely salary range for this position is $107,744 - $138,000. ## Skills ### Required - Business Intelligence (BI) - Database Architecture - Data Warehousing (DW) - Relational Data Modeling - Microsoft SQL Server - Informix - Oracle - Snowflake - Azure cloud platform - Data modeling - data mapping - data flow diagrams - data marts ### Nice to have - Experience creating and managing database reports, visualizations, and dashboards - Knowledge of court operations and law enforcement business data --- Source: [Apply at gdit.wd5.myworkdayjobs.com](https://gdit.wd5.myworkdayjobs.com/en-US/External_Career_Site/job/USA-VA-Home-Office-VAHOME/Senior-Database-Analyst---Administrator_RQ226567-1?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)