Senior Oracle Database Administrator

JD:- Key Result Areas: · Administer the campus wide relational database for production, instructional, and development systems, collectively described as the Enterprise Computing Systems. Perform database object and security administration such as creating indexes, schemas, table spaces, views, queries, stored procedures, user roles and profiles, and control and monitor data access. Diagnose and correct database and system problems while maintaining high availability for Enterprise Systems. Design and maintain data warehouse and data marts with ETL tools. Design, develop, implement, tune, plan capacity and recover Enterprise Systems databases. Provide data modelling such as entity relationship diagrams for new systems to meet end-user requirements. Provide database expertise to add or modify tables, fields, indexes and stored procedures as needed for additional system functionality or upgrades to Enterprise Systems on campus. Ensure that the database is backed up and that routine database maintenance and administration is done in a manner that provides data integrity and is consistent with high availability performance. Ensure databases are always updated to the latest stable version Manage, and monitor the current database deployed security tools to ensure high database security maintained Monitor audit logs and other logs and ensure disk space availability. Implement ETL and BI reporting using latest tools Develop and monitor compliance with policies and procedures controlling the integrity of and access to data. Provide for data integration between Enterprise System databases and other third-party systems as needed to maintain the integrity of the Enterprise Computer Systems and ongoing campus system user needs. Perform disk management for the installation and configuration of database management system software. · Analyse and determine the optimal location of system executables, redo and manage log files, manage system data files, application data files and index files. · Other reasonable tasks as assigned by supervisor Minimum Knowledge, Skills & Experience: · Bachelor’s Degree in a technology related field from an Accredited College or University · 6-8 years of academic and research application development experience · Experience in installing, configuring, fine tuning, and managing Oracle Database, Microsoft SQL, PostgreSQL · Expertise in developing, implementing and maintaining disaster recovery and business continuity operations for enterprise data bases · Experience with Power BI, DataMart’s, Data Lake is a plus · AI Tools and Gen AI knowledge is a plus · Experience with system design concepts