Full-Time Applications Systems Specialist
Job Description
DIT-DEQ Division of Water Resources is looking for a Data Specialist to support the management of drinking water data and submitting required compliance data to EPA’s new Drinking Water State-Federal-Tribal Information Exchange System (DW-SFTIES). Detailed information about the development of this new system along with the Concept of Operations document can be found at https://usepa.servicenowservices.com/sdwisprogram?id=sdwis_modernization_homepage .
The Applications Systems Specialist will be responsible for supporting the Public Water Supply Section with data submissions to EPA’s existing Safe Drinking Water Information System (SDWIS) and managing DEQ’s local installation of SDWIS State. Duties will include understanding what is needed to successfully transition to DW-SFTIES and preparing the relevant data systems and staff. This position also includes server administration functions and the deployment and maintenance of 3rd party web applications like Drinking Water Watch.
*This is a Flexible/Hybrid position that will report to on-site in Raleigh, NC two days per week during the first 6 months.
Duties include, but are not limited, to:
- Conducting business analysis, requirements gathering, and high-level system architecture design, with the ability to clearly communicate these things to the business in layman’s terms
- Administration and routine maintenance of Oracle database and Windows Tomcat web servers
- Perform relational data analysis and modeling, database design, querying, and stored procedure development in Oracle; Ability to write SQL and work with PL/SQL
- Testing and evaluation of new software versions as provided by EPA to ensure they meet the needs of the Public Water Supply Section
- Understanding the Public Water Supply Section’s portfolio of custom applications and how they relate to drinking water compliance and SDWIS/DW-SFTIES
- Developing Requirements/Specification documentation for applications
- Working with a team of developers, database administrators, business analysts and business stakeholders to build systems that improve the efficiency of day-to-day work and integrate well with enterprise-wide systems
About the Organization
The N.C. Department of Information Technology (NCDIT) serves as the Technology Center for the State of NC. Services that NCDIT provides reach a client base of state and local government agencies, as well as schools, colleges and universities. NCDIT’s mission is to enable trusted business-driven solutions that meet the needs of North Carolinians. NCDIT provides technology services to state agencies and is charged with closing the digital divide by expanding availability of broadband services and promoting the adoption of affordable, high-speed internet.
As NCDIT’s services reach North Carolina residents from all backgrounds, we believe that a diverse workforce is our most valuable asset to recognize, understand and meet the IT needs of our constituents across the state. Our agency culture intentionally values diversity, equity and inclusion through the implementation of thoughtful, practical, innovative and data-driven strategies. We are an Employment First state, ensuring that people with disabilities have equal opportunities to succeed in the state government workplace (Executive Order 92). NCDIT supports recent executive orders to address pay equity for women (Executive Order 93), establish paid parental leave for birth, adoption, and foster care (Executive Order 95), and implement fair chance policies (Executive Order 158). Join a team that welcomes, values, respects and supports all members of our work community.
If you have student loans, becoming a state employee includes eligibility for the Public Service Loan Forgiveness Program. Visit www.studentaid.gov to learn more.
Knowledge, Skills and Abilities / Competencies
Resumes/CVs are intended to be used as a complement to an application. Generally resumes/CVs are lacking the detail and breadth of an applicant’s full education and work history so applicants should complete the application with more detail than what their resume contains to show that they meet both the Education Requirements and ALL Knowledge, Skills and Abilities (KSAs) listed below in order to qualify. Click these links for additional information: Introduction to the Job Application and Addressing Knowledge, Skills and Abilities. (Note: These links refer to Dept. of Public Safety process; this process is the same for Dept. of Information Technology.)
To qualify for this position, applicants must document on the application that they possess ALL of the following:
- Demonstrated knowledge of enterprise database systems, such as Oracle, with the ability to provide administrative functions, write effective queries and develop data views
- Demonstrated knowledge of service-based architectures, security, and authentication methods
- Demonstrated ability to develop formatted reports
- Demonstrated ability to perform database reverse engineering
- Experience with verbal and written interpersonal communication skills with both technical and non-technical staff
The following Management Preferences are not required, but applicants that possess these skills are preferred:
- Experience in modern cloud-based solutions, standards, and best practices specifically targeting the Microsoft Power Platform and Azure cloud services
- Experience with Crystal Reports and Business Objects, and/or Power BI
- An interest and willingness to learn about water quality data.
Minimum Education and Experience Requirements
Some state job postings say you can qualify by an ‘equivalent combination of education and experience.’ If that language appears below, then you may qualify through EITHER years of education OR years of directly related experience, OR a combination of both. See the Education and Experience Equivalency Guide for details.
Bachelor’s degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and four years of progressive experience in business application consulting or development
OR
Associate degree in computer science or an IT related field or related technical degree from an appropriately accredited institution and five years of progressive experience in business application consulting or development
OR
High School or General Education Development (GED) diploma and eight years of experience in business application consulting or development; or an equivalent combination of education and experience
Supplemental and Contact Information
The North Carolina Department of Information Technology (DIT) is an Equal Opportunity Employer who embraces an Employment First philosophy which consists of complying with all federal laws, state laws and Executive Orders.
NCDIT uses the Merit-Based Recruitment and Selection Plan to fill posted positions. Hiring salary will be based on relevant qualifications, internal equity, and budgetary considerations pertinent to the advertised position.
- The Department of Information Technology will not accept “See Resume” or inserted text resumes in lieu of all work experience and education completed on the application.
- Employment at NCDIT is contingent upon a satisfactory background check.
- Applicants seeking Veteran’s Preference must attach a DD form 214, Certificate of Release or Discharge from Active Duty, along with your application.
- Applicants seeking National Guard Preference must attach a NGB 23A (RPAS) if you are a current member of the NC National Guard in good standing. If you are a former member of the NC National Guard who served for at least 6 years and was discharged under honorable conditions, you must attach either a DD256 or NGB 22.
- Applicants applying for positions that require specific coursework, must upload and attach a copy of the transcript with their application.
- Applicants with relevant professional certifications to the posted job must attach proof of active certification along with the information in the “Certificates and Licenses” section.
- If applicants earned college credit hours but did not complete a degree program, they must attach an official transcript to each application to receive credit for this education.
- If applicants earned a foreign degree, foreign degrees require an official evaluation for U.S. equivalency, and must be submitted to Human Resources for verification. There are several organizations that perform this specialized service, feel free to use any service of your choosing. The National Association of Credential Evaluation Services (NACES) has several options on their website that can provide credential verification: https://www.naces.org/members
REMOTE WORK:
We trust our employees to be self-motivated and successful in hybrid/remote roles, thus NCDIT offers robust work from home options and variable work schedule flexibility.
COMPENSATION & BENEFITS:
The state of North Carolina offers excellent comprehensive benefits. Employees can participate in health insurance options, standard and supplemental retirement plans, and the NCFlex program (numerous high-quality, low-cost benefits on a pre-tax basis). Employees also receive paid vacation, sick, and community service leave. In addition, paid parental leave is available to eligible employees.
Some highlights include:
- The best funded pension plan/retirement system in the nation according to Moody’s Investor’s Service
- Twelve (12) holidays/year
- Fourteen (14) vacation days/year which increase as length of service increases and accumulate year-to-year
- Twelve (12) sick days/year which are cumulative indefinitely
- Longevity pay lump sum payout yearly based on length of service
- 401K, 457, and 403(b) plans
Learn more about employee perks/benefits:
To apply for this position, please click the “Apply” link above (on the Government Jobs website) or visit https://www.governmentjobs.com/Applications/Index/northcarolina to complete an on-line application.
Due to the volume of applications received, we are unable to provide information regarding the status of your application over the phone. To check the status of your application, please log in to your account and click “Application Status.” If you are selected for an interview, you will be contacted by management. If you are no longer under consideration, you will receive an email notification. If there are any questions about this posting other than your application status, please contact:
NCDIT Human Resources
Yori Lucien
yori.lucien@nc,gov
For technical issues with your application, please call the GovernmentJobs.com Applicant Support Help Line at 855-524-5627.
How to Apply
Please apply here: Applications Systems Specialist | Apply tab | Career Pages (governmentjobs.com)46 total views, 0 today