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%)

• Develops an in-depth understanding of the university's ERP systems & databases.

• Leads and/or participates in design, implementation, and assessment of database-related initiatives and projects, as assigned.

• Researches, recommends, and pilots innovations in database technology.

• Takes a lead role in documenting systems and common support procedures and encourages and facilitates cross-training.

• Stays current with emerging trends and advances in database administration that may have relevance to the university's evolving needs and goals. Proactively educates other team members on findings and new insights.

• Continuously evaluates internal processes, procedures, practices, and standards and proactively proposes changes to bring greater efficiencies.

• Mentors other database administrators and developers in their area.

ADDITIONAL DUTIES

Participation & Support (10%)

• Maintains awareness of current practices and future trends in database technologies, administration, and best practices.

• Represents IT Solutions and participate in the campus community by serving on working groups, project teams, and university committees.

• Performs other duties as requested.

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:

• Ability to maintain the security and integrity of the infrastructure.

• Extensive experience with Oracle databases (eg. Oracle 12c, 19c) in many of the following areas: database architecture and design, optimization, performance tuning, performance management (incl troubleshooting issues), patch management (incl application patching), administration, and support.

• Experience with Unix, Linux, web servers (eg. Weblogic, Tomcat, etc.) installing OEM products and performing administration tasks on those environments.

• In-depth knowledge of relational database concepts and design principles, and hands-on management and support experience using SQL, PL/SQL, UNIX shell scripting, and/or SQL scripting.

• Strong written and oral communication skills (including ability to present ideas in user-friendly, business-friendly and technical language) and interpersonal skills with a focus on rapport-building, listening and questioning skills.

• Proven analytical and problem-solving abilities, including ability to anticipate, identify, and solve critical problems.

• Ability to build effective relationships and strong commitment to working collegially and collaboratively with constituents at all levels in a diverse and distributed environment.

• Ability to use a personal computer and other office equipment, including related university software and email.

Additional/Desirable Skills & Abilities

• Oracle Database Administration certification.

• Experience managing and supporting Oracle database systems supporting ERP environments such as Oracle E-Business Suite (EBS) and/or Ellucian Colleague.

• Knowledge of ETL (Extract, Transform and Load) architecture and data warehousing technologies and tools (SAS Data Management platform, Informatica, DataStage, SSIS).

• Experience with data governance.

• Experience in a higher education setting.

• Hands on experience with data replication tools.

• Experience with database migration to the cloud.

• Familiarity with Texas Administrative Code (TAC 202).

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.