Senior Database Administrator - IT Solutions

TITLE

Senior Database Administrator

JOB SUMMARY

The Senior Database Administrator is responsible for managing and supporting university-wide ERP application, file and database systems including the performance, integrity and security of those systems. In this role they are involved in installing, upgrading, cloning, and patching of ERP applications. They will plan and develop database architecture, logical and physical design, automation, documentation, installations, shell scripting, backup and recovery concepts, as well as the troubleshooting of any database performance or data integrity issues.

As a member of the IT Solutions (ITS) team, the Senior Database Administrator is expected to uphold the division's mission to "empower an agile, digital university and elevate technology as a strategic institutional asset" and contribute positively to a collaborative, human-centered, innovative, accountable, transparent, and inclusive culture within ITS.

ORGANIZATIONAL RELATIONSHIPS

Reports to : Manager, Data Warehouse & Integrations

Supervises : No supervisory responsibilities

ESSENTIAL DUTIES

May include, but not limited to the following :

Database Management & Support (75%)

• Designs, develops, implements and clones Oracle file systems, application servers, and databases.
• Monitors and maintains maximum performance of databases and applications, including Oracle configuration and change controls, components, concurrent requests, system alerts and metrics.
• Administers and troubleshoots Oracle database, including patching (security, critical, service patching), SQL tuning, capacity planning, and schema design.
• Develops, manages, and tests back-up and restoration plans as well as disaster recovery plans.
• Maintains proper configuration management and change controls for database, applications, and file systems.
• Actively contributes to the creation, development, and maintenance of technical documentation, data standards, procedures and definitions for a university data dictionary.
• Supports developers with SQL tuning, indexing, partitioning approach to achieve read / write efficiency.
• Develops administration automation and monitoring scripts as needed.
• Creates alert and diagnostic monitoring.
• Supports the organization as needed in a transition from on-premise database systems to cloud database systems.
• Assumes the additional tasks and skills as needed to support a cloud-based data warehouse, business intelligence, or analytics system.
• Partners with ITS security to design access permissions and privilege controls.
• Performs off-hours production support, as needed.

Technical Innovation & Project Leadership (15%)

ADDITIONAL DUTIES

Participation & Support (10%)

EDUCATION

Bachelor's degree required. Additional job-related experience may substitute for the required education on a year-for-year basis.

EXPERIENCE

Seven years of relevant experience in database development and / or administration. Additional job-related education may substitute for the required experience on a year-for-year basis.

REQUIREMENT

Regular and reliable attendance at the University during regular scheduled days and work hours is an essential function of this position.

Work is performed under minimal supervision and performance is based on the effective operation of the administrative function. The performance evaluation is conducted through the performance evaluation system and in accordance with the University Policies & Procedures.

All employees share the responsibility of maintaining information security and privacy requirements within the university by adhering to Federal and State regulations, and TWU Policies & Procedures.

KNOWLEDGE, SKILLS, AND ABILITIES - The following are essential :

Additional / Desirable Skills & Abilities

PHYSICAL DEMANDS

The physical demands described in the Essential Duties and below are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.

The employee may be required to travel. May be required to work a flexible schedule, including

nights, weekends and holidays.

WORK ENVIRONMENT

All employees are responsible for maintaining an environment that is free from discrimination, intimidation, harassment, including sexual harassment. Work is normally performed in a typical interior work environment.

SAFETY

TWU promotes a safe working environment. Employees are responsible for completing assigned tasks safely and efficiently, and supervisors are responsible for creating and maintaining a safe work environment. Employees must report any unsafe work conditions or practices, as well as any near-miss incidents, to their supervisor and Risk Management. Supervisors and employees should ensure that injury / accident reports are submitted to the Office of Human Resources and Risk Management within 24 hours of the incident.

The job description does not constitute an employment agreement between the employer and employee and is subject to change by the employer as the needs of the employer and requirements of the job change.

Texas Woman's University, an AA / EEO employer, provides equal opportunity to all employees and applicants for employment and prohibits discrimination on the basis of race, color, national origin, religion, gender, age, disability, veteran status, sexual orientation, or any other legally protected category, class or characteristic.

All offers of employment will be contingent on the candidate's ability to provide documents which establish proof of identity and eligibility to work in the United States. Positions at Texas Woman's University deemed security-sensitive require background checks and verification of all academic credentials.

If you are a male between the age of 18 and 25, federal law requires that you must be registered with the U.S. Selective Service System, unless you meet certain exemptions under Selective Service law. Under HB 558, enacted by the 76th Texas State Legislature, if you are currently of the age and gender requiring registration with Selective Service, but knowingly and willfully fail to do so, you are ineligible for employment with an agency in any branch of Texas state government. For additional information regarding registration or status, you can contact the Selective Service System at 847-688-6888 or www.sss.gov

J-18808-Ljbffr