Database Administrator and Analyst

The purpose of the Database Administrator & Analyst role is to ensure the availability, security, performance, and integrity of enterprise databases while designing and maintaining data warehouse solutions that support academic, medical, and administrative analytics.

The role combines hands‑on Oracle and SQL Server database administration with data warehouse design, ETL, and analytical reporting, enabling reliable operations and data‑driven decision‑making across the university.

• Administer, configure, and maintain Oracle Database and Microsoft SQL Servers and databases environments across production, test, and development on-prem and azure online databases.
  

• Monitor database performance, storage, and availability; perform proactive performance tuning and capacity planning.
  

• Design, implement, and maintain data warehouse architectures, including fact/dimension models and historical data structures.
  

• Develop and manage ETL processes to extract, transform, and load data from source systems (ERP, SIS, LMS, medical systems) into the data warehouse.
  

• Ensure data accuracy, consistency, and integrity across operational databases and analytical platforms.
  

• Implement and manage backup, recovery, disaster recovery, and business continuity strategies; regularly test recovery procedures.
  

• Enforce database security controls, including access management, roles, privileges, auditing, and encryption.
  

• Design, optimize, and maintain database objects (schemas, tables, views, indexes, stored procedures).
  

• Provide data analysis and reporting support, including Academic and student analytics, Operational and management reporting, Medical and hospital data analysis.
  

• Build and optimize complex SQL queries, views, and datasets to support dashboards and institutional reporting tools.
  

• Support application deployments, upgrades, and integrations by reviewing and validating database changes in coordination with application and DevOps teams.
  

• Maintain complete database and data warehouse documentation, including architecture diagrams, data models, ETL flows, and operational runbooks.
  

• Support audits, compliance reviews, and security assessments by providing required database evidence and reports.
  

• Participate in database upgrades, migrations, and modernization initiatives (on‑prem and cloud).
  

• Advanced administration skills in Oracle DB and SQL Server (installation, monitoring, tuning, backup, recovery). Proven hands‑on experience managing Oracle Database and Microsoft SQL Server.
  

• Advanced Database administration for Banner SIS, Oracle fusion ERP, sitecore, azure and other academic applications databases.

• Demonstrated experience as a Data Warehouse Specialist, including design, implementation, and maintenance.
  

• Strong experience with ETL processes and enterprise reporting environments.
  

• Experience supporting databases for academic, medical, and mission‑critical systems.
  

• Advanced SQL skills, including complex queries, performance optimization, and stored procedures.
  

• Experience integrating data from multiple enterprise systems into a centralized data warehouse.
  

• Knowledge of data governance, data quality, and data lifecycle management.
  

• Experience with reporting and analytics tools (e.g., Power BI, Argos, Tableau, or equivalent).
• Strong understanding of database security, access control, and compliance requirements.
  

• Excellent analytical, problem‑solving, and documentation skills.
  

• Strong communication skills with the ability to work effectively with technical and non‑technical stakeholders.

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.