Virginia Mountain View

SQL Developer

SQL Developer

  • https://jobs.vccs.edu/postings/94475
  • Fairfax County, Virginia, United States
  • Hold for NV280-VP of College Computing
  • Northern VA Community College
View favorites

Title: SQL Developer

Agency: Northern VA Community College

Location: Fairfax County - 059

FLSA: Exempt

Hiring Range: Commensurate With Experience ( Up to $115,000/yr max)

Full Time or Part Time: Full Time

Additional Detail


Job Description:
General Description:
The SQL Developer will serve as a key member of the enterprise application integration team, responsible for the design, development, optimization, and support of (Microsoft SQL and Oracle PeopleSoft) databases that support the organization’s academic and administrative operations. This role focuses on translating business, reporting, and integration requirements into efficient, secure, and scalable solutions. Systems in scope include Oracle databases supporting Enterprise Resource Planning (ERP) platforms leveraging PL/SQL and T-SQL Server–based systems leveraging SSIS packages, data warehouses, cloud-hosted applications, and other higher education technologies across hybrid cloud and on-premises environments.

Duties and Tasks:
  • Design, develop, and maintain complex Oracle SQL scripts and PL/SQL objects, including but not limited to: stored procedures, packages, functions, views, triggers, and materialized views to support application functionality, integrations, and reporting.
  • Maintaining and extending existing ETL solutions, such as SQL Server Integration Services (SSIS) packages to facilitate ETL processes, data synchronization, and batch workflows
  • Collaborate with application developers, integration engineers, and business stakeholders to translate functional requirements into robust database and data pipeline solutions.
  • Participate in code reviews, testing cycles, and cross-functional development efforts to ensure maintainable, high-quality solutions.
  • Troubleshoot and resolve data, performance, and integration issues across on-premises and cloud environments, performing root-cause analysis and implementing corrective actions.
  • Support ongoing database optimization, monitoring, and standards adherence to ensure reliability, scalability, and alignment with enterprise data governance and security practices.
Minimum Qualifications:

Required KSAs
  • Demonstrated ability to design, develop, and support enterprise‑level SQL‑based solutions, including database objects, queries, and data integrations, across complex academic and administrative systems.
  • Solid working knowledge of relational database design and development, with hands‑on experience in either: Oracle SQL and PL/SQL (e.g., supporting ERP systems such as PeopleSoft), OR Microsoft SQL Server using T‑SQL, along with the ability to work effectively with the other platform in a support, maintenance, or integration context.
  • Ability maintaining and extending existing ETL solutions, such as SQL Server Integration Services (SSIS) or comparable tools, including troubleshooting, enhancement, and operational support of established data pipelines.
  • Ability to work independently with minimal supervision while collaborating effectively in a team‑oriented, cross‑functional environment.
  • Demonstrated ability to produce clear technical documentation and to support users in a customer service–focused setting.

Minimum Work Requirements:
  • Experience developing in either: Oracle SQL and PL/SQL (e.g., supporting ERP systems such as PeopleSoft), OR Microsoft SQL Server using T‑SQL, along with the ability to work effectively with the other platform in a support, maintenance, or integration context.
Additional Considerations:

Additional Considerations
  • Relevant certifications such as Oracle PL/SQL Developer Certified Professional, Microsoft SQL Server / T‑SQL certifications, or Microsoft data engineering certifications are preferred.
  • Experience developing, supporting, and integrating solutions across hybrid cloud and on‑premises environments, including Oracle Cloud Infrastructure (OCI) or comparable platforms.
  • Experience with PeopleTools development, such as Application Designer, Application Engine, and related PeopleSoft tools, or demonstrated ability to support PeopleSoft database structures and processes in collaboration with functional or application development teams.
  • Experience developing and supporting PeopleSoft BI Publisher reports and data sources or supporting reporting solutions built on SQL Server–based platforms.
  • Knowledge of data security, governance, privacy, and compliance best practices, particularly within a higher education, government, or other regulated enterprise environment.
  • Experience in Higher Education
  • Experience in Community College environments

 

Each agency within the Commonwealth of Virginia is dedicated to recruiting, supporting, and maintaining a competent and diverse work force. Equal Opportunity Employer

Apply Now

Already applied for a job?

Similar Jobs

Assistant Director of Education

Richmond, Virginia, United States Dept of Veterans Services
Proudly Serving Our Veterans Across the Commonwealth!

Appeals Attorney

Remote, 1- Alternate Dept of Veterans Services
Proudly Serving Our Veterans Across the Commonwealth!

Veterans Services Representative

Fairfax County, Virginia, United States Dept of Veterans Services
Proudly Serving Our Veterans Across the Commonwealth!

PH Nurse #VDH01843

Norfolk, Virginia, United States Virginia Department of Health
Bold and catalytic, the Norfolk Department of Public Health is transforming the health landscape of our community through groundbreaking initiatives and strategic partnerships. We are committed to fostering a culture of radical collaboration, exce...

Research Specialist – Clinical Data and Digital Pathology

907 Floyd Avenue, MCV Main Campus, Virginia, United States, 23284 SVP Health Sciences SML
Virginia Commonwealth University (VCU) School of Medicine is a premier academic medical center located in the heart of Richmond. Accounting for almost half of VCU’s sponsored research, the School of Medicine is internationally recognized for patie...

Assistant Park Manager - Occoneechee State Park

Mecklenburg, Virginia, United States Dept Conservation & Recreation
The Virginia Department of Conservation and Recreation (DCR) protects access to the outdoors, natural habitats, open spaces, clean water, and safe infrastructure. We manage Virginia State Parks, including campsites, cabins, beaches, festivals, edu...