Database Administrator- Oracle SQL

Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans. Our comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more. Functional Title: Database Administrator Job Title: Database Administrator II Computer and Mathematical Shift: Day Additional Shift: Days (First) Telework Regular/Temporary: Full Time/Part Time: Full time Facility Location: Citizens and permanent residents. This onsite role requires the selected candidate to work from an HHS office in Austin, Texas. Performs complex (journey-level) Oracle database administration work. Work involves planning, developing, maintaining, monitoring, testing, and issue resolution for databases. Coordinates with service provider and application groups to install new versions, new enhancements, and newly released databases. Monitors applications for space utilization on test, development, and production environments. Monitors database performance and adjust as required to maximize efficiency. Works with service provider and IT Applications team to set up production jobs, schedule jobs, monitor jobs, and performance tune the jobs that run with job schedulers. Archives, restores, and recovers databases as required. Evaluates and recommends database software packages for potential acquisition. Evaluates and implements database policies and procedures; Develops goals and objectives for the use and improvement of an efficient and cost-effective database system. Works under the general supervision of the IT Application Services Director, with moderate latitude for the use of initiative and independent judgment. EJF1: Analyzes, designs, plans, and performs database upgrades and maintenance. Coordinates with service provider and application groups to install new versions, new enhancements, and newly released databases. Monitors database performance and implements efficiency improvements. Coordinates backup monitoring and fixes issues related to backups. Modifies existing databases and database management systems. Analyzes objects and databases. Performs database migration. Analyzes and reports the performance of database operations. EJF2: Coordinates with application development, customers, and support teams to ensure their needs are met from a database perspective. Participates in the planning, design, administration, operation, monitoring, maintenance, user security, and system parameter settings for databases. Coordinates backup, restore, and recover tasks that apply to production, development, and test databases (30%). EJF3: Evaluates users' requests for new data elements, data systems, data migration, and data integration. Provides input and analysis to other teams regarding database related topics and decisions. Sets-up views, roles, stored procedures, and database links to allow use of databases. Creates tables and provides the data required to fulfill requests. Assists customers and other groups in troubleshooting, testing, and resolving database issues. Evaluates and recommends database software packages for potential acquisitions. EJF4: Develops standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment. Ensures audit and security standards are adhered to and documented appropriately. Maintains data integrity and security. Creates and maintains data dictionaries. Participates in security and risk evaluations for applications. Maintains practices within established policies, regulations, and guidelines. (May include but are not limited to actively participating and/or serving in a supporting role to meet the agency’s obligations for disaster response and/or recovery or Continuity of Operations (COOP) activation. Such participation may require an alternate shift pattern assignment and/or location. Knowledge of the principles, practices, and techniques of computer databases, programming, and systems design. Knowledge of computer operations, systems, and procedures. Knowledge of project and cost estimating techniques. Knowledge of computer programming languages. Knowledge of data processing flowcharting techniques. Knowledge of database structures and theories. Knowledge of current database technologies. Knowledge of data analysis and evaluation techniques. Skill in use of a computer and applicable software. Skill in Database Administration of Oracle. Skill in monitoring database performance. Ability to proficiently manage relational databases (e.g., SQL Server, Oracle). Ability to communicate technical information effectively, both orally and in writing to establish and maintain effective working relationships with customers, coworkers, and vendors. Ability to anticipate risks and mitigate in the moment. Ability to conduct short-range and long-range project planning. Skill in maintaining skill, poise and focus under high-stress conditions with shifting priorities. Registrations, Licensure Requirements Or Certifications Three years of database administration experience in Oracle database. Bachelor’s degree or higher in a technology related field is preferred. Experience In Cloud Migration Preferred. Selected candidate must be willing to commute to the office on the required days. #Active Duty, Military, Reservists, Guardsmen, and Veterans : Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor’s Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions. In Compliance With The Americans With Disabilities Act (ADA), HHSC And DSHS Agencies Will Provide Reasonable Accommodation During The Hiring And Selection Process For Qualified Individuals With a Disability. If You Need Assistance Completing The On-line Application, Contact The HHS Employee Service Center At View phone number on click.appcast.io. Telework Disclaimer This position may be eligible for telework. Please note, all HHS positions are subject to state and agency telework policies in addition to the discretion of the direct supervisor and business needs. #J-18808-Ljbffr HEALTH AND HUMAN SERVICES COMMISSION