Oebs Database Admin

Title: OEBS Database Admin DSP02618

State Role Title: Information Technology Specialist III

Hiring Range: Negotiable and Commensurate with Experience

Pay Band: 6

Agency: Department of State Police

Location: North Chesterfield, Virginia

Agency Website: vsp.virginia.gov

Recruitment Type: General Public - G

Job Duties

We are seeking to expand our diverse team of change makers and innovators. As a member of the Virginia State Police family, you would make a difference by serving every city, county, town, resident, and visitor of the Commonwealth through supporting our vast public safety mission. Challenge yourself to make a difference today by applying for a career with the Virginia State Police!

Established in 1932, the Virginia State Police has grown to be the largest police department in the Commonwealth of Virginia. As the mission of the Department has continued to expand, our workforce continues to grow. We embrace our tradition of professionalism and excellence, and we are excited for our future as we continue our journey to become best in class. We are firmly committed to our family-like culture and are seeking to expand our diverse team. We provide an outstanding benefits package, including excellent health insurance, membership in the Virginia Retirement System, deferred compensation, paid leave starting on day one, and other benefits available to Commonwealth of Virginia Employees.

In addition, the Virginia State Police supports its personnel through a comprehensive, holistic Wellness Program. From our Therapy Dog, Piper, to full-time peer support, our wellness staff teaches and coaches "cognitive fitness" for all employees every step of the way. Our Wellness Program fosters a welcoming, peer-oriented, inclusive environment with the resources to support our employees throughout their entire VSP career. We are committed to providing the best so you can be at your best!

Contact Human Resources for additional details.

• Works with the eBusiness Functional Analysts to provide support for the eBusiness Suite production, test, and development environments.

• Provides consultation and recommendations for upgrades, backup, recovery, and technical issues.

• Works with the Department's Information Security Officer (ISO) and management to establish policy and procedures for security policies.

• Monitors and optimizes the performance of the systems and databases.

• Identifies and resolves problems.

• Works with the eBusiness Functional Analysts to troubleshoot and monitor systems for potential problems.

• Installs, configures, and maintains Oracle system software and related products to ensure correct upgrades, patches and fixes are in place.

• Works with the development team to provide support of the SQL Server relational database environment.

• Provides consultation on relational database design, implementation, and technical issues to our systems development team.

• Provides recommendations for upgrades to SQL Server relational databases.

• Provides recommendations for database security.

• Provides support for database backup and recovery.

• Works with the Department's ISO and management to establish policy and procedures for database security.

• Monitors and optimizes the performance of application systems databases.

• Identifies and resolves relational database problems.

• Contacts and informs development staff on proper design and implementation of relational databases.

• Works with development staff to troubleshoot and monitor systems for potential problems.

• Installs, configures, and maintains SQL Server system software and related products to ensure correct upgrades, patches and fixes are in place.

• Establishes and maintains a modern, robust, flexible, secure, reliable, and efficient technology environment.

• Ensures training, cross training/knowledge transfer occurs for self, team members, across teams and clients.

• Keeps up to date on database products and technologies.

• Assists and provides direction to co-workers in using new techniques and in solving their more complex technical problems.

Minimum Qualifications

• Considerable knowledge of and experience with Oracle Databases, Oracle eBusiness Suite, and UNIX environments to include day to day activities for Oracle eBusiness Suite such as cloning, patching, code migration, performance tuning, capacity planning, database monitoring, user management, backup/recovery management, and SR management is required.

• Experience with Oracle eBusiness modules is required.

• Experience with Oracle eBusiness 12.2 version is required.

• Experience using the Oracle Applications Framework (OAF) technology stack including JDeveloper, PL/SQL, Workflow, and Forms is required.

• Experience working independently to review Oracle notes and work with Oracle support is required.

• Excellent verbal and written communication skills are also required.

• Graduation from high school or equivalent.

Additional Considerations

• Experience with UNIX scripting is highly preferred.

Special Instructions

A BACKGROUND INVESTIGATION SHALL BE REQUIRED OF EACH SELECTED APPLICANT

Elements of the selection process include the screening of application(s); the interviewing of qualified candidate(s), to include pre-employment testing, a presentation and/or a work sample, if applicable; salary negotiation(s) if applicable; a background investigation; and a medical evaluation if applicable. The anticipated duration of the pre-employment process is determined by the successful completion of the above items.

Applications, cover letters and/or resumes shall only be accepted on-line through the PageUp recruitment management system at https://jobs.virginia.gov. This position is open until filled. Please limit resumes to four pages and cover letters to one page. Any additional attachments received in excess of this will not be considered.

PageUp provides a confirmation of receipt of your application, resume and/or cover letter submitted successfully. Please refer to your PageUp account to check the status of your application for this position. For questions, please contact the Employment Unit of the Human Resources Division at civilianemployment@vsp.virginia.gov.

The Department of State Police is an Equal Opportunity Employer. Our policy is to extend opportunities to qualified applicants and employees on an equal basis regardless of an individual's race, color, gender, age, national origin, religion, citizenship status, marital status, sexual orientation, gender identity or expression, transgender status, physical or mental disability, protected veteran status, genetic information, pregnancy, parental status, political affiliation, or any other categories protected by applicable federal, state or local laws.

REASONABLE ACCOMMODATIONS ARE AVAILABLE UPON REQUEST

(V)alor (S)ervice (P)ride