Database Administrator Expert #W4396 in Richmond, VA

Database Administrator Expert #W4396 - Virginia Government - Richmond, VA - work from home job Company: Virginia Government Job description: Information Technology Search by job title, location, department, category, etc. Search Jobs Near Me Database Administrator Expert #W4396 • 516976 • Richmond, Virginia, United States • Department of Social Services • Information Technology • Full-Time (Salaried) • Closing at: Sep 22 2023 at 23:55 EDT • Department of Social Services Title: Database Administrator Expert #W4396 State Role Title: Info Technology Specialist III Hiring Range: $120,000 to $130,000 per year (salary commensurate with experience) Pay Band: 6 Agency: Department of Social Services Location: DSS HOME OFFICE Agency Website: https://www.dss.virginia.gov/ Recruitment Type: General Public - G Job Duties NOTE: This position may not be 100% telework. This position may be eligible for telework opportunities; availability, hours, and duration will be in accordance with the Commonwealth's Teleworking policy. The employee may be required to work a schedule that is split between remote and onsite. At the Virginia Department of Social Services, we put people at the center of everything we do. We believe that every Virginian can live a life of dignity and that all voices, ideas and experiences contribute greatly to our pursuit of excellence. Inspired by continuous improvement, we commit ourselves to listening, learning and cultivating environments of trust, respect and positive engagement. Together, we are mission-driven, eager to achieve, and passionate about bringing the best of who we are to those we serve. We design and deliver high-quality human services that help Virginians achieve safety, independence and overall well-being. We are a $2 billion agency - one of the largest in the Commonwealth of Virginia - partnering with 120 local departments of social services and 31 community action agencies, along with faith-based and non-profit organizations, to promote the well-being of children, adults, and families statewide. We proudly serve alongside 1,650 (state) and 12,200 (local) human services professionals throughout the Social Services System, who ensure that thousands of Virginia's most vulnerable citizens have easy access to the services and benefits available to them. This position is responsible for database support and maintenance and will provide direct support to agency databases. Database Administrator will assist in ITS goal 'To Improve Operation availability and Performance'. The Database Administrator will be responsible for 7X24 production support for Oracle and SQL Server environment and related activities. Candidate should be proficient at a Senior DBA level, with all aspects of Oracle and SQL Server database administration, and Application Development Support. Candidate should show proficiency in server administration, and competency in ITIL and Security Policies and Procedures. Candidate must have the ability to lead a team, and excellent communication and inter-personal skills, as well as experience in cloud and LCAP platforms. Minimum Qualifications • Experience with Oracle RAC databases. • Experience in Cloud platforms such as Oracle, Azure, and AWS. • Experience in PL SQL programming. • Experience in the analysis, design, development, testing, and implementation of large systems. • Experience working with high level and detailed designs, system architecture, production systems, online and batch processing environments. • Database Administration: Experience in installing, configuring and administering Oracle and SQL Server Databases, experience with Oracle's Real Application Cluster (RAC), and Oracle Enterprise Management (OEM) Grid and SQL Server management Studio. • Ability to write SQL scripts, troubleshoot and resolve Oracle/SQL server database/application problems. Ability to create and document Oracle/SQL Server DBA processes, procedures, policies, and tasks. Experience in migrating and supporting databases in cloud. • Extensive experience in upgrading and applying security patches to Oracle and SQL Server databases. Experience with RAC and Automatic Storage Management (ASM), RMAN, Oracle Data Guard, and Database cloning/overlay. • Experience in database security, backup, recovery, and archival concepts and procedures. Has worked in diverse platforms on Oracle databases covering Red Hat Linux, Oracle Linux, IBM AIX supporting very large databases in 24/7 production environment. • Hands-on experience in planning, designing SQL Server and Oracle Backups and Recovery strategies using RMAN, export/import - logical and physical backups. Experience with RAC and ASM. • Experience with Container Database (CDB) and Pluggable Database (PDB) technology/concept. • Hands-on experience in tuning SQL queries of Oracle and SQL Server databases. • Ability to implement the database with ASM and have SAN storage associated special commands. • Familiar with use of CNAME concept. • Familiar with database security audits (internal and external). Additional Considerations • Oracle Database Administration Professional Certification • Experience in Data Masking and Scrubbing • Experience in LCAP Platforms like Salesforce Lightening • Experience in Database as a Service in Cloud/Hybrid cloud or on premises. • Considerable experience in multiple IT areas with relevant subject matter expertise. 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. Selected candidate(s) must successfully pass a fingerprint-based criminal history background check. A record of criminal history does not automatically bar an applicant from consideration. Employment verification will be conducted to include current/previous supervisory employment reference checks. VDSS will record information from each new employee's Form I-9 (Employment Eligibility Verification) into the Federal E-Verify system to confirm identity and work authorization. This position may be eligible for telework opportunities; availability, hours, and duration will be in accordance with the Commonwealth's Teleworking policy. To be considered for this position, you must submit a Commonwealth of Virginia application or resume through the on-line “Virginia Jobs” (PageUp) employment site no later than 11:55 p.m. on the closing date listed. Each application is reviewed for documentation that shows the applicant meets the minimum and additional considerations as stated in the job announcement. The decision to interview an applicant is based on the information provided. Multiple positions may be filled from this recruitment within 90 days of the closing date. In addition to a rewarding work experience, VDSS offers excellent health and life insurance benefits, pre-tax spending accounts, state funded Short and Long Term Disability, paid holidays, vacation, tuition assistance, free wellness programs, and a state retirement plan with options for tax-deferred retirement savings including employer matching - Employee Benefits. The Virginia Department of Social Services (VDSS) is an Equal Opportunity Employer and encourages diversity within its workforce. VDSS does not provide sponsorship. VDSS is an official certified state agency that values the service and experience of our Veterans. As such, Veterans are encouraged to apply and receive preference in the hiring process. AmeriCorps, Peace Corps and other national service alumni also are encouraged to apply. Reasonable accommodations are available to applicants, if requested, during the application and/or interview process. If you have been affected by Policy 1.30 Layoff as a state employee and possess a valid Interagency Placement Screening Form (Yellow Form) or a Preferential Hiring Card (Blue Card), you must submit this document through the “Virginia Jobs” (PageUp) employment site when you apply. Contact Information Name: VDSS - Division of Human Resources Phone: dssrecruitment@dss.virginia.gov Email: dssrecruitment@dss.virginia.gov 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 Certificate of Disability (COD) provided by a Vocational Rehabilitation Counselor within the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their Certificate of Disability. If you need to get a Certificate of Disability, use this link: for Individuals with Disabilities, or call DARS at 800-552-5019, or DBVI at 800-622-2155. Database Administrator Expert #W4396 - Virginia Government - Richmond, VA - work from home job Expected salary: $120000 - 130000 per year Location: Richmond, VA Database Administrator Expert #W4396 - Virginia Government - Richmond, VA - work from home job Job date: Tue, 12 Sep 2023 23:09:41 GMT Apply for the job now! Database Administrator Expert #W4396 - Virginia Government - Richmond, VA - work from home job Apply tot his job Apply To this Job