Senior technical resource for Oracle Database Administration in the Information Technology Services Division of the Texas Education Agency. Work involves planning for effective and efficient storage, management of daily/routine operations and maintenance, developing, and implementing database policies and procedures; and maintaining data integrity. Provides senior level support for Oracle database environments, ensuring their performance, availability and security. Designs, analyzes, and maintains database structures for Oracle database systems. Designs and implements backup procedures to provide for the recoverability of Oracle databases from hardware and software failures. Develops database processes, procedures, utilities and services as needed to support database integrity. Performs Oracle database performance monitoring, implements efficiency improvements, and modifies existing databases and database management systems. Plans, coordinates, and supports implementations, upgrades and patches for agency Oracle database systems. Consults with project teams on Oracle database requirements for new development including functional and resource requirements. Provides technical support for Oracle database issues including troubleshooting database, system, application, and client connectivity issues. Establishes and implements necessary database security standards and controls for management of the internal and external Oracle database security. Evaluates and recommends database software packages for potential acquisition. Assists with development of disaster recovery plans and participates in disaster recovery testing and execution. Assists in developing policies and procedures designed to ensure the integrity of the database environments. Provide after hours support for database systems as needed. Maintain current knowledge and expertise in database technology. Performs other related duties as assigned.
Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
Education: Graduation from an accredited four year college or university.
Experience: Four (4) years experience as an Oracle DBA. Prefer six (6) to ten (10) years experience as an Oracle DBA. Prefer experience with Oracle ExaData.
Substitution: Each additional year of related experience above the required minimum may substitute for education on a year-for-year basis.
Knowledge, Skills and Abilities (KSA's):
Knowledge of: Relational database design, maintenance, optimization, backup and recovery; writing and tuning complex stored procedures, views and triggers.
Skill in: Analyzing access plans and indexing; monitoring and analyzing database performance; troubleshooting database and client connectivity errors; analyzing resource utilization, system requirements, and capacity planning; using Oracle RAC, 11g. Prefer experience with Oracle ExaData.
Ability to: Manage program activities; to establish goals and objectives; to devise solutions to technical and administrative problems; to develop and evaluate technical and administrative policies and procedures; to prepare reports; to communicate effectively; and to plan, assign, and supervise the work of others. Ability to work with software vendors, outsourced service providers, and application developers to analyze and resolve database problems.
This job description is not an employment agreement or contract. Management has the exclusive right to alter this job description at any time without notice.
Salary is dependent on qualifications.
Positions exempt from the Fair Labor Standards Act (FLSA) will earn compensatory time off rather than overtime for hours in excess of 40 per week. May be required to work hours other than 8 to 5. May be required to work weekends and holidays.
In accordance with applicable federal and state equal opportunity laws, it is TEA's policy that no person shall be excluded from consideration for recruitment, selection, appointment, training, promotion, retention or any other personnel action, or be denied any benefits or participation in any educational programs or activities which it operates on the grounds of race, religion, color, national origin, sex, disability, age or veteran status (except where age, sex, or disability constitutes a bona fide occupational qualification necessary to proper and efficient administration).
The Immigration Reform and Control Act requires all new employees to present proof of identity and eligibility to work in the United States. TEA does not sponsor H1-B work visas. Males, 18 to 25 years of age, are required to present proof of selective service registration (or exemption) prior to being employed by any state agency.
There is a 90-day waiting period for health insurance coverage and retirement contributions for new hires and re-hires.
This position requires the applicant to meet Agency standards and criteria which may include passing a pre-employment criminal background check, prior to being offered employment by the Agency.
Texas Education Agency - 21 months ago