SQL Developer

SQL Developer

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 stored procedures, packages, functions, views, triggers, and materialized views to support application functionality, integrations, and reporting.
• Maintain and extend 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.

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 to maintain and extend 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

• 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, and specifically in Community College environments.

For further information and to Apply

https://jobs.vccs.edu/postings/94475

Background Check Statement

The selected candidate’s offer is contingent upon the successful completion of a criminal background investigation, which may include fingerprint checks, local agency checks, employment verification, verification of education, credit checks (relevant to employment). Additionally, selected candidates may be required to complete the Commonwealth’s Statement of Economic Interest. For more information, please follow this link: http://ethics.dls.virginia.gov/

EEO STATEMENT

The Virginia Community College System (VCCS) provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, political affiliation, veteran status, sexual orientation, gender identity or other non‑merit factors.