ERS - Oracle Database Administrator

Our mission is simply stated: ERS offers competitive benefits to enhance the lives of its members. Each team member across the agency contributes to our ongoing success. ERS is open for business five days a week, 8:00 am to 5:00 pm, to meet customers where they need us: in person, on the phone, in their communities, and online. ERS currently offers opportunities that include flexible work schedules.

ERS is seeking an Oracle Database Administrator to perform highly complex to advanced (senior-level) database and application administration work for ERS systems. Work involves monitoring, maintaining, developing and tuning integrated database system environments for ERS application areas. Works primarily within PeopleSoft environments running on IBM’s AIX platform utilizing Oracle RDBMS. May also support SQL Server databases.  Works under limited to minimal direction of the Database Administrators Manager with considerable latitude for the use of initiative and independent judgment.

Essential Responsibilities include, but are not limited to:

• Performs highly complex to advanced system and database administration for ERS applications, including installing, configuring, upgrading, patching, and maintaining Oracle databases and supporting software in accordance with established standards and best practices.
• Monitors database performance, conducts tuning, and resolves operational issues to ensure reliability and availability in development, test and production environments; executes database backup, recovery, cloning and maintenance activities; participates in disaster recovery testing and assists with implementation.
• Supports application teams by providing technical guidance and resolving database-related issues in single or multitier environments; assists in collecting, validating, and preparing data to support AI and analytics initiatives, ensuring databases are optimized for reporting and analytical workloads
• Evaluates and recommends database and system management tools to improve operational efficiency.
• Develops and maintains standard operating procedures, technical guidelines, and performance metrics.
• Provides on-call and after-hours support as required, ensuring compliance with agency policies, procedures and standards.
• Attends work regularly in accordance with agency leave and attendance policies. Complies with all applicable agency policies and procedures, including safety and standards of conduct.
• Performs other duties as assigned.

As Database Administrator IV, will complete all essential functions of Database Administrator III in addition to the following:

• Leads enterprise-level database initiatives, including capacity planning, disaster recovery strategy, high-availability solutions, and optimization for AI, machine learning, and analytics workload.

• Designs scalable, high-performance, and reliable Oracle database architectures for enterprise applications across development, test and production environments.

• Provides strategic technical guidance to developers, IT staff, and management, influencing long-range planning, architecture standards, and system improvements.

• Evaluates and recommends enterprise database management tools, emerging technologies, and data platforms to support advanced analytics, AI, and business intelligence initiatives.

• Establishes and maintains best practices, policies, and standards for database administration, AI, and analytics data pipelines.

• Participates in strategic planning and decision-making for enterprise IT initiatives and ensures alignment with agency goals, AI initiatives, and technology strategies.

Required Minimum Qualifications: Your application for employment must reflect how you meet each of the following minimum qualifications:

1.      Graduation from an accredited four-year college or university with a degree in data processing, computer science, management information systems, business or related field. Attainment of a diploma from a two-year technical school with specialization in computer technology may substitute for 60 semester college credit hours. Qualifying experience beyond the minimum required may substitute for education.

2.      Six (6) to eight (8) years’ experience (depending on classification level) in progressively difficult technical computer systems support roles. 

3.      Five (5) years’ experience performing Oracle Database Administrator work on a UNIX platform.

4.      Two (2) to four (4) years’ experience (depending on classification level) in the performance tuning of Oracle database environments.

Preferred Qualifications: Your application for employment should reflect how you meet the following preferred qualifications:

5.      Prefer four (4) years’ experience working with system and database management tools.

6.      Prefer one (1) years’ experience supporting PeopleSoft environments on an AIX UNIX platform.

7.      Prefer one (1) years’ experience supporting PeopleSoft environments by using PSADMIN tool.

8.      Prefer experience with Oracle Enterprise Manager, RMAN, and Oracle SQL Developer.

9.      Prefer one (1) years’ experience as a Microsoft SQL Server database administrator.

10.   Prefer experience with AI and data analysis.

PLEASE NOTE: All submissions should contain complete job history entries, which includes job title, dates of employment, name of employer, and a description of duties performed as related to the position you are applying for. Resumes lacking sufficient detail, such as a summary of experience in lieu of progression of work history may not meet minimum qualifications.

Other Information: In accordance with state law, authorization for telework may not be awarded to an employee as a condition of hiring. As an agency process, new employees complete a 30 day fully onsite period before evaluation for a telework agreement. This position may require access to privileged, confidential, or sensitive data. ERS will conduct either a TXDPS or FBI criminal history check on all new hires. For more information about this policy inquiries can be made to employment@ers.texas.gov. Please note: Internal applicants in the same salary group and classification as the posted position are eligible to receive an increase in salary where applicable up to the posted maximum.

Military Occupational Specialty Codes:

Veterans, Reservists or Guardsmen with experience in the Military Occupational Specialty (https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_InformationTechnology.pdf) along with the minimum qualifications listed above may meet the minimum requirements and are highly encouraged to apply. Please contact Human Resources at employment@ers.texas.gov with questions or for additional information.

How to Apply: Ready to join the dedicated, customer-focused team at ERS? Submit the following to the ERS Human Resources Office:

A State of Texas Application for Employment submitted online through CAPPS Recruit.

• Use the link below to create a CAPPS Recruit account and build your profile on the “My JobPage” tab in the upper left corner of the screen.

• https://capps.taleo.net/careersection/327/jobsearch.ftl?lang=en

• Once your profile is complete, click on the “Job Search” tab in the upper left corner of the screen to view available career opportunities and submit your application.

Applications submitted through Work in Texas:

If you apply for an ERS position via Work in Texas https://www.workintexas.com/vosnet/Default.aspx, you will also need to complete a supplemental questions form. For more details, refer to the instructions in the email you receive from CAPPS Recruit.

Please contact a Human Resources representative if you need assistance or require accommodation during the application process.

Email: Employment@ers.texas.gov         

Web: www.ers.texas.gov

Relay Texas TDD: (800) 735-2989

LinkedIn: https://www.linkedin.com/company/employees-retirement-system-of-texas/

.