Enterprise Database Administrator

Location
San Antonio, TX
Posted
Jun 14, 2018
Administrative Jobs
Technology, Database Administration
Institution Type
Four-Year Institution

San Antonio TAMUSA

Full time
R-007606


Job Title
Enterprise Database Administrator

Agency
Texas A&M University - San Antonio

Department
Information Technology

Proposed Minimum Salary
Commensurate

Job Location
San Antonio, Texas

Job Type
Staff

Job Description

Responsibilities:
  • Responsible for the architecture design, installation, development, integration, testing, documentation, monitoring, configuration management, forecasting disaster recovery/business continuity and ongoing maintenance of Oracle and other databases (such as SQl, MySQL) required by A&M-SA applications, and ancillary software. Establish the standards and processes used to document database administration methods and security procedures. Establish standards for documenting database problems, recoveries, and repairs.
  • Schedule and implement major and minor software releases as well as emergency service and/or security packs. Work with appropriate Information Technology (IT) areas to maintain necessary security levels. Coordinate additional hardware, network, and/or software infrastructure components and their inter dependencies and works with project teams to provide hardware / software requirements.
  • Responsible for planning, developing, maintaining, supporting, and optimizing the supported databases and system application environments as well as implementing best practice methodologies.
  • Support and develop security for all database developers and users. Provide access by assigning roles and maintaining security for auditing purposes. Coordinate, administrate, and manage the database environments.
  • Develop and implement standards and guidelines for platform usage and administration.
  • Responsible for the database and all components disaster recovery and business continuity planning, procedures implementation/operations/maintenance, testing and documentation.
  • Responsible for development, implementation for scripting, processes and links that are required for the database to perform as required by the application(s) it supports. Implement databases, processes, monitoring tools and other Database related software required or related to Databases such as the Oracle Suite of products to include Oracle Enterprise Manager).
  • Establish standards, policies, and procedures for application and database construction and use. Implement and follows these procedures. Tune and integrate the physical database structures for the most efficient utilization of the database.
  • Collaborate with project teams to develop and implement hardware and software requirements and maintains a robust, highly available, and redundant infrastructure.
  • Develop and provide management reporting and dashboard of database performance and other key information as defined.
  • Coordinate enterprise-level database performance monitoring activities. Monitor environments proactively for capacity and performance related issues and takes steps necessary to address them. Monitor and respond to notification-related aspects of the Database environments. Develop, maintain, and document processes and procedures for 24/7 monitoring of health, utilization, and performance across all assigned platforms. Interface with central monitoring facility to coordinate installation and configuration of monitoring software across all assigned systems.
  • Generate and provide routine and ad hoc reports to management. Provide consulting to application owners and end users regarding the use of monitoring facilities on assigned systems.
  • Ensure system integrity by configuring and maintaining proper security safeguards. Monitor system resource usage and performance. Create and maintain user access accounts.
  • Maintain understanding of the IT architecture strategy and long-term goals. Assist in product evaluations of applications, tools, and utilities to support the enterprise architecture.
  • Act as an internal consultant, advocate, mentor, and change agent. Communicate openly and effectively with a large base of both internal and external customers. Establish standards for the development of plans for new databases or upgrades. Oversee input from clients, developers, systems administrators, and vendors to develop specifications and plans for enterprise-level databases.
  • Use A&M-SA IT ticketing system for managing work to includes Change, Incidents, and Requests.
  • Lead and participate in projects. Oversee and coordinate work of contractors as required.


This document represents the major duties, responsibilities, and authorities of this job, and is not intended to be a complete list of all tasks and functions. Other duties may be assigned.

Education & Experience:
  • Bachelor's degree in applicable field and eight years of related experience in data management.


KSAs:
  • Knowledge of word processing and spreadsheet applications.
  • Knowledge of Information Technology (IT) architecture, application of systems theory, advanced negotiation skills, enterprise-level operations, multi-team leadership/coordination, advanced project management, sourcing skills, advanced vendor relations, and advanced business acumen.
  • Ability to multitask and work cooperatively with others. Excellent written communication, analytical, interpersonal, and organizational skills.


APPLICATION PROCESS:

Applications are accepted only through the online job portal at:

http://www.tamusa.edu/humanresources/job-opportunities/index.html

For Internal Applicants:

Go to your Workday Profile to upload your resume:

1) Select CAREER

2) From top of bar, select EDUCATION

3) Upload your resume by selecting the button - UPLOAD MY EXPERIENCE

4) Select file and submit resume

Applicants must complete the online application by either downloading your resume to auto-populate the application, or manually complete the application fields.

After the Work History section in the application process, you can select UPLOAD to attach the following required documents.

1) Cover letter to include (3) professional references; and

2) Resume

For External Applicants:

Applicants must complete the online application by either downloading your resume to auto-populate the application, or manually complete the application fields.

After the Work History section in the application process, you can select UPLOAD to attach the following required documents.

1) Cover letter to include (3) professional references; and

2) Resume

Please ensure that all required documents are uploaded prior to submitting the application. Once application is submitted, no changes or revisions can be made.

In compliance with ADA, if accommodations are needed for the application process, please contact HR at (210) 784-2058.

All positions are security-sensitive. Applicants are subject to a criminal history investigation, and employment is contingent upon the institution's verification of credentials and/or other information required by the institution's procedures, including the completion of the criminal history check.

Equal Opportunity/Affirmative Action/Veterans/Disability Employer committed to diversity.

PI102928684