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
