Senior Database Analyst / Administrator

About this role

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 Administrator Associate, Microsoft Azure Solutions Architect Expert or equivalent industry recognized database certification. • Proficient experience with Databases like Microsoft SQL Server, Informix, Oracle. • 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 with Snowflake and exposure to cloud platforms, Azure cloud platform preferred. • 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 $114,750 - $155,250. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Scheduled Weekly Hours: 40

Travel Required: None

T elecommuting Options: Remote

Work Location: Any Location / Remote

Additional Work Locations:

Total Rewards at GDIT: Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering

Similar jobs

• Senior Database Administrator — DXC Technology · Remote
• Senior Database Administrator — Maricopa County · Phoenix, AZ
• Senior Database Administrator — Universal Logistics Holdings · Warren, MI
• Senior Database Developer — Devtechnology · Ashburn, VA (Hybrid)
• Senior Database Engineer — Crunchyroll · San Francisco, CA, United States
• Senior Database Engineer — Leidos · Tampa, FL
• Senior Database Engineer — LSEG · USA-New York-28 Liberty Street | USA-St. Louis-795 Office Pkwy
• Senior Database Engineer — Meridianlink · Remote