Sql Manager Jobs in Springfield, OH (NOW HIRING)

Recruiters please do NOT contact Advent Services

A leader in supporting clients in technically demanding industries, Advent's capabilities and services promote innovation & empower our partners to manage risk, protect the information, and achieve organizational objectives. We are proud of our ability to support mission-critical systems in every phase of their lifecycle to ensure our nation's forces can accomplish their mission.

Position:Web Developer

Location:Remote but occasional on-site work at Wright Patterson AFB, OH

Schedule:Monday-Friday, 0730-1630

Mandatory Qualifications:

Minimum Education and Work Experience (one of the following):

• S. in Computer Science and/or CIS and 4 years Web development experience working with Adobe ColdFusion web applications and Oracle relational databases.
• Any bachelor's degree and 6 years' Web development experience working with Adobe ColdFusion web applications and Oracle relational databases.
• Any post-secondary education and 8 years of Web development experience working with Adobe ColdFusion web applications and Oracle relational databases.

• The Web developer shall have work experience creating and updating Web applications using Adobe ColdFusion, HTML, CSS, JavaScript, and jQuery.
• The Web developer shall have work experience creating, reading, and understanding Oracle and Microsoft SQL Server procedural language (PL/SQL and T-SQL).
• The Web developer shall have work experience designing, building, and working with relational databases, both Oracle and Microsoft SQL Server.
• The Web developer shall have work experience designing, building, and modifying relational database objects, including tables, views, sequences, triggers, procedures, and functions
• The Web developer shall have work experience creating, reading, and understanding complex SQL queries.
• The Web developer shall have experience working with JavaScript and jQuery within Web applications, especially using jQuery AJAX transactions.
• The Web developer shall have work experience performing system analysis and reverse engineering of existing systems.
• The Web developer shall have work experience working throughout the entire software development lifecycle; from collecting and documenting requirements, to designing, building, testing, and deploying a complete web application.
• The Web developer shall be able to communicate clearly and effectively in both written and spoken English. This includes being able to convey technical or complex information concisely and accurately through written reports, emails, and verbal presentation.

Responsibilities:

• The Web developer shall write web application code using Adobe ColdFusion, Oracle PL/SQL, HTML, CSS, JavaScript, and jQuery, to create new modules or to enhance existing modules within HPWS. This code shall be clean, understandable, and shall conform to standards established by the HPWS Program Office.
• Web developers who are new to HPWS shall be required to complete a two to four-week orientation period to introduce and acclimate them to the HPWS application framework. This period will include a small project where the Web developer shall be required to demonstrate their technical ability writing ColdFusion, JavaScript, jQuery, and Oracle SQL directly within the HPWS development environment.
• The Web developer shall interact with USAFSAM/OE and the HPWS Program Office to obtain technical requirements for HPWS Web Development projects.
• The Web developer shall participate in the creation of technical documentation for new projects within HPWS. This includes writing requirements, creating system design documents, relational database diagrams (ERDs), test plans, deployment plans, training material, and other project management artifacts.
• The Web developer shall produce new capabilities within HPWS modules, based upon information contained within functional requirement specifications provided by USAFSAM/OE and the HPWS Program Office.
• The Web developer shall design, build, and assist with maintenance of Microsoft SQL Server databases and database code. This includes remote work connected by VPN and also in-person work within the USAFSAM/OE enclave.
• The Web developer shall complete Web development projects in HPWS modules that comply with HPWS Program Office coding standards, design styles, and project management methodologies for all projects.
• The Web developer shall support 508 Accessibility standards (W3C WCAG 2.0) in the design, production, and maintenance of all user interfaces within HPWS.
• The Web developer shall implement secure Web development and coding practices that are aligned with the Risk Management Framework (RMF) certification of the HPWS web application.
• The Web developer shall implement secure Web development and coding practices that are in alignment with DoW, USAF, and/or HIPAA information assurance controls.
• The Web developer shall produce training content for HPWS web application screens and processes. This may also include conducting training (in-person or via Microsoft Teams) and demonstrations for end users if needed.
• The Web developer shall participate in regularly scheduled and ad hoc project meetings with USAFSAM/OE personnel and the HPWS Program Office. These may be in person, over the telephone, or using DAF365 Microsoft Teams.
• The Web developer shall communicate project status weekly to USAFSAM/OE stakeholders and the HPWS Program Office using government-specified tools and documentation.
• The Web developer shall document and initiate Change Requests with the HPWS Program Office. This requires interaction with stakeholders (Module Managers and Module POCs) in order to obtain authorization for any changes to code within HPWS.
• The Web developer shall initiate code review requests and shall document deployment specifications for any new capabilities built or added to HPWS modules. Any requested code changes identified through the code review process shall be adjusted as requested by the HPWS Program Office.
• The Web developer shall be able and willing to complete development projects working on their own or with other Web development team members and team leaders. This includes personal project management or adjusting to working with other developers if needed.
• The Web developer shall complete government-furnished training on operational security, information assurance, HIPAA, Privacy Act, records management, and other training specified for 711 HPW contract personnel.
• The Web developer shall be available for work during the core working hours of 0900-1500 EST, M-F, except Federal holidays, unless stipulated otherwise by the HPWS Program Office. Regardless of the contract employee's preferred daily start and end times, they must be working and available to the HPWS Program Office and Wing customers during those core hours. This means being online (DAF365 Teams) and responsive to ad hoc voice communication, instant messages, and email.
• The Web developer must be available for scheduled and ad hoc meetings and tele-conferences via DAF365 Microsoft Teams during core working hours. Work schedules shall not exceed 40 hours per week.
• For tasks completed remotely, the Web developer shall use both Microsoft Teams and Microsoft Outlook (DAF365 tenant) for daily (weekdays) communication with USAFSAM/OE, HPWS Program Office staff and other members of the HPWS Web development team.
• For tasks requiring work on USAFSAM/OE enclave resources, such as Microsoft SQL Server or other applications, the Web developer will need to be available to occasionally work on-site at Wright-Patterson AFB in Dayton Ohio.
• Web developers who work remotely shall perform all work on government-furnished equipment (GFE).
• Contract employees who work remotely shall be required to supply their own Internet bandwidth in order establish a virtual private network (VPN) connection to the AF information network (AFIN).
• Web developers who are teleworking will not be allowed to connect personally owned equipment (POE) to government furnished equipment (GFE). The exception to this rule is a hard-wired or wireless connection to a personal router for VPN connections to DoD networks.
• No work performed by the Web developer on government-furnished equipment can be completed without first establishing a VPN connection using an approved Air Force VPN client. Government-furnished equipment is to be used for official US government purposes only. No work shall be performed on privately-owned equipment.
• Contract employees who are teleworking shall not be permitted to print government information or materials on privately-owned printers. No privately-owned printer may be connected to government-furnished equipment, either wirelessly or through a hard-wired connection.
• Government information and materials are not permitted to be stored on privately-owned, peripheral storage media such as CDs, and DVDs, and USB-connected devices. At no time may non-government-approved storage devices such as optical drives, SSD drives or portable hard disks be connected to government equipment.

Advent's benefits program includes comprehensive medical, dental and vision care, matching 401K, vacation time, sick time, life insurance, disability coverage, and other benefits that help provide financial protection for you and your family.

Advent is an Equal Opportunity Employer. Employment decisions are not based on race, color, religion, sex, national origin, disability status, genetics, protected veteran status, or any other characteristic protected by federal, state or local laws.