DCS - Sr. Oracle SQL Analyst

Key Description

Develop, maintain, and optimize complex Oracle SQL and PL/SQL programs.

Write and support simple to advanced SQL queries against normalized Oracle transactional databases.

Analyze business requirements and determine appropriate database tables, joins, relationships, and business rules needed to answer complex business questions.

Extract, validate, transform, and analyze operational data for reporting, research, grant-related activities, and executive requests.

Develop and maintain scheduled database jobs, automated SQL processes, and recurring data refresh routines.

Troubleshoot SQL scripts, query performance issues, automated processes, and data quality concerns.

Create efficient, reusable, maintainable, and well-documented SQL code.

Support operational reporting, KPI tracking, legislative reporting requirements, and research initiatives.

Collaborate with business stakeholders to gather requirements and communicate analytical findings.

Provide support for Tableau dashboards and other data visualization efforts as needed.

Required Qualification

• Minimum 5 years of experience developing Oracle SQL solutions against transactional databases.
• Minimum 5 years of experience writing complex SQL queries, including joins, CTEs, subqueries, CASE statements, aggregate functions, and analytic functions.
• Minimum 5 years of experience working with normalized relational database design and table relationships.
• Minimum 3 years of experience with SQL job scheduling and automated database processes.
• Minimum 3 years of experience translating business requirements into SQL-based solutions.
• Minimum 3 years of experience supporting operational reporting and data analysis.
• Demonstrated ability to write SQL solutions from scratch against normalized transactional databases.
• Ability to attend on-site interviews and report on-site on Day 1 for orientation and equipment pickup.

Preferred Qualification

• Minimum 3 years of Oracle PL/SQL experience, including procedures, functions, packages, and views.
• Experience with SQL troubleshooting, query optimization, performance tuning, and data validation.
• Experience supporting Tableau or other data visualization platforms.
• Experience working in criminal justice environments or other large-scale transactional database environments.
• Experience supporting executive reporting, legislative reporting, research initiatives, and KPI development.
• Strong ability to communicate technical findings to business stakeholders.
• Experience developing automated reporting and recurring data refresh processes.

About Varmoda

Varmoda is a federal IT solutions provider founded in 2020 and headquartered in McLean, Virginia, delivering citizen-centric public services across Financial Assistance, Public Benefits, and Security & Defense domains.

Varmoda's five-layer architecture — Salesforce (Engagement), Databricks (Data), ServiceNow (Orchestration), Pega (Decisioning), and Oracle HR (Capacity) — puts data at the common thread of every solution we build for federal agencies and the citizens they serve.

Varmoda holds CMMI Maturity Level 3, ISO 9001, ISO 20000, and ISO 27001 certifications, and is recognized as a V3 veteran-friendly employer.

Why Varmoda

Growth opportunity within a fast-scaling federal IT firm

Direct impact on citizen-facing federal programs

Competitive benefits including 401k, health insurance, Paid Time Off, Life Insurance and others — customize per role/location

Veteran-friendly (V3) workplace culture