Database Administrator II
Database Administrator II
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 84353 - 126529
1 Vacancy
Job Description
Description of Work
- Are you ready to take the next step in your careerDiscover why NCDIT is the ideal destination for your professional growth -Why Work for NCDIT.We currently have an opening for aDatabase Administrator II(Flexible/Hybrid)The position is designated StatutoryExempt and is exemptfrom the State Human Resources Act.This position may be eligible for hybrid remote work in accordance with state policy and the agencys remote work program but does require weekly onsite work
The Database Administrator II is responsible for serving as the primary Oracle and SQL Server Enterprise DBA. This is a critical role within the Applications and Database Development group and is responsible for maintaining the integrity design and security of multiple databases serving data to DEQ applications. This role is also critical in the transition to cloud technologies and the agencys digital transformation efforts.
Duties include but are not limited to:- Serves as the primary lesion to the Central DIT Database team and partners closely with this group in the overall administration of Oracle and SQL Server Databases instances. This includes ongoing and planned upgrades patches and migrations in addition to ensuring secure access to the databases. Coordinate the setting up of new databases and maintain existing databases ensuring that the databases function properly and align with the organizations needs
- Performs data modeling analysis by maintaining enhancing and streamlining the data models as the requirements are identified throughout the agencys multiple projects. Constantly works to keep data organized and ready for data analysts to mine and applications to access
- Partners with agency application developers and execute tasks related to application development
- Serves as the backup to the primary DB2 Database administrator
- Create and maintain comprehensive documentation for database systems including design specifications operational procedures and security guidelines
- Assesses customer needs develops technical solutions to increase program operating efficiency and adapts to new requirements as necessary
- Identifies opportunities for integration points with other core technology platforms
About the DivisionThe IT Division of the North Carolina Department of Environmental Quality (DEQ) leads IT professionals in supporting the departments mission. The division develops IT strategic plans policies and programs that align with business strategies integrates security controls and best practices and manages a complex portfolio of over 100 applications. It also implements short and long-term IT goals assesses new technologies and plans IT roadmaps and architecture. The division is responsible for creating and implementing solutions for the departments business needs including the design and development of internet intranet server-based and cloud applications. Additionally it provides training troubleshooting and recommendations for new or upgraded systems. The IT Division ensures day-to-day support for applications websites and other IT services such as desktop support LAN/WAN hosting and printers.
About the Organization
TheN.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. NCDITsmission is to enable trusted business-driven solutions that meet the needs of North Carolinians. NCDIT provides technology services to state agencies and is charged withclosing the digital divide by expanding availability of broadband services and promoting the adoption of affordable high-speed internet.As NCDITs services reach North Carolina residents from all backgrounds we believe that our workforce should reflect the demographics of the state. The workforce is our most valuable asset to recognize understand and meet the IT needs of our constituents across North Carolina. Our agencys culture is derived 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). NCDIT also has several initiatives designed to help past and current military personnel and their spouses find rewarding careers with us. 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 to learn more. Knowledge Skills and Abilities / Competencies
The following Management Preferences are not required but applicants that possess these skills are preferred:
- Working knowledge of Azure SQL or other cloud-based database technologies
- Working knowledge of creating implementing and maintaining Azure Pipelines and other migration tools that standardize and streamline the flow of data from all source systems
- Working knowledge with the other core technology platform components used within DEQ including Microsoft Azure Services and the Power Platform
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 theEducation and Experience Equivalency Guidefor details.
Bachelors degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and three years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system
OR
Associate degree in computer science or an IT related field or a related curriculum from an appropriately accredited institution and four years of progressive experience in programming and applications analysis including the design and maintenance of an integrated database system
OR
High School or General Educational Development (GED) diploma and seven years of relevant experience in programming and applications analysis including the design and maintenance of an integrated database system; or an equivalent combination of education and experience.Supplemental and Contact Information
TheNorth Carolina Department of Information Technology (DIT)is anEqual Opportunity Employerwho embraces anEmployment Firstphilosophy which consists of complying with all federal laws state laws and Executive Orders.
- 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 seekingVeterans Preferencemust attach a DD form 214 Certificate of Release or Discharge from Active Duty along with your application.
- Applicants seekingNational Guard Preferencemust 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: WORK SCHEDULES:
At NCDIT we are dedicated to fostering a collaborative and flexible work environment offering a hybrid remote work option for positions that are conducive to remote flexibility. If you do not currently reside within a reasonable commuting distance of the assigned duty station new hires are granted up to 120 days from their start date to relocate. This relocation ensures the ability to work onsite multiple days per week. If youre eager to contribute to a dynamic workplace we encourage you to apply!
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 addition paid parental leave is available to eligible employees.
Some highlights include:- The best funded pension plan/retirement system in the nation according to Moodys Investors 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 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
For technical issues with your application please call the Applicant Support Help Line at .
Required Experience:
Unclear Seniority
Employment Type
Full-Time
