Title: Application Database Administrator State Role Title: Info Technology Specialist III Hiring Range: $126,513-$140,568 Pay Band: 6 Agency: Department of Juvenile Justice Location: DJJ Training Academy Agency Website: www.djj.virginia.gov Recruitment Type: General Public - G Job Duties The Virginia Department of Juvenile Justice (DJJ) protects the public by preparing court-involved youth to be successful citizens. DJJ is committed to excellence in public safety by providing effective interventions that improve the lives of youth, strengthening both families and communities within the Commonwealth. The Virginia Department of Juvenile Justice is seeking an experienced Database Administrator to support the ongoing implementation and support of complex technology solutions in an Oracle 19c database environment. The successful candidate will provide a technical role in maintaining DJJ Oracle databases and application servers to meet agency strategic goals, implementing effective support operations using agency approved technologies, and execute database administration tasks to maintain the agency's database and application server capabilities. The incumbent will participate in Database Administration efforts on an ongoing basis. Additional duties include assisting in the design and planning of projects and standards and supporting team efforts to continually improve skills and delivery practices. Minimum Qualifications * Ability to interpret data models and to develop database structures. * Ability to use standard diagramming techniques to design and develop computer data models. * Ability to implement and troubleshoot programming changes and modifications. * Ability to program, configure, manage, and maintain the operation of complex relational databases. * Ability to develop and manipulate large, complex data sets. * Knowledge of computer and/or network security systems, applications, procedures & techniques. * Knowledge of data integrity methods and techniques. * Ability to install, maintain, modify, and upgrade database software. * Ability to use logic and reasoning to identify strengths and weaknesses of alternative solutions, conclusions of approaches to problems. * Knowledge of Change Management principles * Oracle DBA: Considerable experience administering Oracle databases in a Linux environment * Oracle Database Management (19c+): Extensive experience managing Oracle databases using multi-tenant architecture (CDB/PDB), backups/restores, PL/SQL, OEM, RMAN, Data Guard, and handling production environments. * Backup and Recovery: Strong experience in backing up and recovering large databases from RMAN online backups Additional Considerations * Experience with ASP.NET, MVC 5, C#, RDLC Reports, VB.NET, Bootstrap v5, JQUERY 3.7, Datatables.NET. * .Net Web Services: Experience with .Net web services. * Cloud Experience: Proven understanding of cloud environments (OCI/AWS/Azure) and managing large-scale environments on cloud platforms. * OCI Expertise: Hands-on experience with Oracle Cloud Infrastructure (OCI) and migrating applications from on-premises to OCI. * Demonstrated knowledge / training in Software applications, engineering, or equivalent experience. * OCI / AWS - Developer / DBA Special Instructions You will be provided a confirmation of receipt when your application and/or résumé is submitted successfully. Please refer to "Your Application" in your account to check the status of your application for this position. Lay off Policy 1.3: If you have been affected by DHRM Policy 1.3 layoff and possess a valid Interagency Placement Screening Form (Yellow Card) or a Preferential Hiring Form (Blue Card), you must submit the card before the closing date for this position. The Card may be submitted with the state application as an attachment. DJJ Welcomes Veterans: DJJ is committed to hiring and retaining veterans. If applicable, please submit form DD-214 with your state application. Please include your name and the position number in which you are applying along with the DD-214. Supplemental Questions: You may be required to respond to position-specific questions at the end of this application. This information may help us evaluate your credentials and qualifications for the job. Failure to respond to any questions may disqualify you from further consideration. Status Updates/Confirmation: Once you submit your online application, you will instantly receive an application confirmation number. You may use this number to track the status of your application during the recruitment process. Please refer to your account for the status of your application. Updates will not be provided via telephone. Reasonable accommodations are available to persons with disabilities during application and/or interview processes per the Americans with Disabilities Act. Contact our Human Resources Department for further assistance. Equal Opportunity Employer: The Department of Juvenile Justice practices fair and equal employment opportunities to all employees and applicants in accordance with applicable laws and regulations. It is our policy to prohibit discrimination on the basis of race, sex, color, national origin, religion, sexual orientation, gender identity, age, veteran status, political affiliation, genetics, or disability in the recruitment, selection, and hiring of its workforce. Qualified individuals with disabilities are encouraged to apply. Contact Information Name: Bianca D. Stewart Williams, Talent Acquisition Consultant Phone: 804-588-4410 Email: [email protected] In support of the Commonwealth's commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their AHP Letter (formerly COD) provided by the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Service-Connected Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their AHP Letter. Requesting an AHP Letter can be found at AHP Letter or by calling DARS at 800-552-5019. Note: Applicants who received a Certificate of Disability from DARS or DBVI dated between April 1, 2022- February 29, 2024, can still use that COD as applicable documentation for the Alternative Hiring Process.