"Alerted.org

**Req ID:** RQ211919

**Type of Requisition:** Regular

**Clearance Level Must Be Able to Obtain:** None

**Public Trust/Other Required:** None

**Job Family:** IT Infrastructure and Operations

Skills:

Database Performance,Data Modeling,Data Operations,Data Warehouse,Enterprise Data

Experience:

7 + years of related experience

Job Description:

Seize your opportunity to make a personal impact supporting the **Case Management Modernization (CMM) Program.** The CMM program is an initiative to support the Administrative Office of the US Courts (AO) in developing a modern cloud-based solution to support all 204+ federal courts across the United States.

GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career. The **Snowflake Administrator** will work as part of the CMM Enterprise Data Warehouse (EDW) team to deploy a secured cloud-native EDW platform and support the statutory and operational reporting, data cataloging, and other analytical objectives.

The **Snowflake Administrator** is responsible for the design, administration, optimization, and secure operation of the Snowflake DWaaS environment supporting the CMM EDW. This role ensures high availability, performance, cost efficiency, security compliance, and seamless support to data engineering, BI, and analytics teams in a federal cloud environment.

Key Responsibilities

+ Manage and optimize **Snowflake environments** including account setup, configuration, scaling, performance tuning, and warehouse management to ensure reliable and efficient data operations.

+ Create, maintain, and govern **databases, schemas, roles, and RBAC access controls** aligned with AO security, IAM, and compliance policies.

+ Monitor and troubleshoot **data pipelines, query performance, concurrency, and resource utilization** to maintain uptime and cost efficiency.

+ Implement **cost-optimization strategies** (auto-suspend/resume, right-sizing, workload isolation) and contribute to financial reporting, forecasting, and TCO analysis.

+ Automate and document administrative activities such as **environment provisioning, user/role management, data loading, and monitoring** using Terraform, dbt, SQL, Python, or equivalent tooling.

+ Collaborate with **data engineers, BI developers, and architects** to design efficient data models, optimize ELT workflows, and improve overall platform performance.

+ Support **security audits, ATO artifacts, incident response, DR/HA testing** , and operational runbooks related to Snowflake services.

+ Documentation of **data architectures, data models, performance metrics, runbooks, and progress reports**

+ **Cloud monitoring dashboards** , capacity planning, KPI metrics, and optimization recommendations

+ **Design and testing of DR and High Availability strategies** for Snowflake DWaaS

+ Support for **incident reports, root cause analysis, and vulnerability reports** related to database access

+ **Performance Outcomes**

+ High-availability, secure Snowflake operations with measurable improvements in **performance, cost efficiency, and reliability**

+ Timely delivery of operational documentation, metrics, and remediation actions supporting EDW governance

REQUIRED EXPERIENCE

+ Strong experience with database or cloud data platform administration, including **hands-on Snowflake experience**

+ Strong expertise in **SQL** , performance tuning, and workload management

+ Experience operating data platforms in **AWS-based or hybrid cloud environments**

+ Proven ability to automate infrastructure and administration using **IaC and scripting**

+ Experience with **Terraform, dbt, Python** , or similar automation frameworks

+ Familiarity with **federal security, compliance, and audit processes**

+ Snowflake SnowPro Core or higher certification

+ **Tools & Technologies** : Snowflake, AWS, Terraform, dbt, SQL, Python, CI/CD pipelines, monitoring/observability tools

QUALIFICATIONS

+ 7+ years’ experience in Server database maintenance and database administration or similar role.

+ Bachelor's degree in Computer Science, Information Technology, or related field.

+ Excellent presentation and communication (oral and written) skills.

+ Consultant mindset with the ability to work with high level customer stakeholders and build excellent customer relationship.

+ Experience identifying and applying industry tools, solutions, methods best practices, and emerging technologies.

+ Strong analytical skills and problem-solving skills with the ability to formulate and communicate recommendations for improvement.

+ Demonstrated ability to work effectively, independently, and as part of a team.

The likely salary range for this position is $102,000 - $138,000. 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.

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 the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 50 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.

Join our Talent Community to stay up to date on our career opportunities and events at https://gdit.com/tc.

Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans