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.