Enterprise Database Administration Intermediate

Department Contact:

Arianna Meraz, 575-646-5633, ariannam@nmsu.edu

Internal or External Search:

External

• Open to all applicants

Advertising Summary:

Be at the center of a high-impact data environment where you'll optimize and maintain Oracle databases, support Banner ERP systems, and ensure performance, security, and reliability across critical platforms. In this role, you'll manage upgrades, backups, and cloud infrastructure (OCI), while enabling reporting through data warehouse support and collaborating with teams to solve complex challenges. If you're driven to keep systems running smoothly and make data work smarter, this is your opportunity to make a meaningful impact.

Position Details Position Title:

Enterprise Database Administration Intermediate College/Division:

Information Technology Department:

450270-IT

DATABASE ADMINISTRATION

Location:

Las Cruces Offsite Location (if applicable):

Target Hourly/Salary Rate:

$53,165.80; Commensurate with experience

Appointment Full-time Equivalency:

1.0

FLSA Status :

Exempt Bargaining Unit Announcement:

This is NOT a bargaining unit position with American Federation of State, County & Municipal Employees (AFSCME).

Contingent Upon Funding:

Not Applicable Standard Work Schedule:

Standard (M-F, 8-5) If Not a

Standard Work Schedule:

Job Duties and Responsibilities:

The Database Analyst is responsible for the administration, maintenance, and optimization of Oracle database environments, ensuring high availability and performance through proactive monitoring, indexing, and query optimization. This role involves cloning, exporting, and importing databases, schemas, and software code repositories, as well as executing backups and restore procedures to safeguard data integrity and business continuity. The analyst manages Banner ERP (Ellucian) software upgrades and patches, along with database server updates, ensuring compliance with Federal and State regulations and security policies. Additional responsibilities include administering ERP application servers (e.g., Apache Tomcat) and Oracle Cloud Infrastructure (OCI), leveraging Oracle Enterprise Manager for performance monitoring, diagnostics, and lifecycle management. Additional responsibilities include creating and maintaining technical documentation, as well as supporting data warehouse and Operational Data Store (ODS) maintenance to enable reporting and analytical capabilities across the institution. The analyst is also responsible for creating and maintaining technical documentation, troubleshooting database-related incidents, and collaborating with IT teams and NMSU departments to align database solutions with ongoing institutional needs.

Qualifications Required Education and Experience:

Associate's Degree + 4 years of relevant experience or a Bachelor's degree + 2 years of relevant experience.

Equivalent Qualifications:

Preferred Qualifications:

• Proficiency in Oracle Database (12c/19c or later), including PL/SQL development.
• Experience with cloud infrastructure platforms, preferably Oracle Cloud Infrastructure (OCI), Automatic Storage Management and Oracle Multi-tenant.
• Strong understanding of relational database design, normalization, and data modeling.
• Experience with performance tuning, indexing strategies, and query optimization.
• Familiarity with database backup/recovery strategies and disaster recovery planning.
• Knowledge of scripting languages such as Python, PowerShell, or Bash for database automation.
• Oracle Certified Associate (OCA) or Oracle Certified Professional (OCP) certification.
• Hands-on experience with Oracle Enterprise Manager (OEM) for monitoring and lifecycle management.
• Familiarity with Ellucian Banner modules and Banner upgrade methodology.
• Experience with cloud database services on

OCI, AWS

RDS, or Azure SQL.

• Familiarity with ETL tools and data warehousing concepts.
• Working experience with Microsoft SQL Server, MySQL, and PostgreSQL.

Special Certification/Licensure:

Working Conditions and Physical Effort Environment:

Work is normally performed indoors.

Physical Effort:

No or very limited physical effort required.

Lifting Requirements:

Requires handling of average-weight objects up to 10 pounds or some standing or walking.

Risk:

Work environment involves exposure to potentially dangerous materials and situations that require following extensive safety precautions and may include the use of protective equipment.