Part-Time Oracle DBA

Summary

The Senior Database Administrator is an expert in maintaining the performance, integrity, and security of the organization’s databases.

This role will work within IS Department to provide database administration and software deployment support. This role will work very closely with Business stakeholders, Software developers, and other IS Department teams.

Duties / Responsibilities :

• Administer Oracle database management systems, ensuring the integrity, reliability and performance for development, test and production systems.
• Administer and troubleshoot start-up, shutdown, performance, error resolution, storage structures, stored procedures, queries, users and security.
• Manage schema objects, such as tables, indexes, and views
• Perform database backup, monitoring, validation, and recovery procedures.
• Perform database restores in non-production environments for software development and troubleshooting purposes.
• Assist with Oracle Cloud, SQL Server, PostgreSQL and MySQL administration as needed.
• Assist with database upgrades, replacements, and migrations, including the installation and configuration of all related software components.
• Administer Oracle Enterprise Manager (OEM), and its application Server (WebLogic), including installation and configuration of components, and coordinating maintenance and patches.
• Support development teams by reviewing proposed data models, optimizing database queries / stored procedures, and assisting with development solutions (GIT, Bugzilla, Jira, etc.)
• Provide mentorship and code assessments for DBA’s and software developers.
• Support deployment scripts for database object updates.
• Work with Enterprise Architecture, Software Development, Infrastructure, and Business Analyst teams to estimate and architect solutions for growth and resource allocation.
• Investigate new database and related technologies and assess their viability and usefulness in current and future projects.
• Improve process, performance, and security of database systems and integrations.
• Simplify and optimize database management practices.
• Contribute new viewpoints and strategies to stimulate growth.
• Provide on-call support as needed.
• Other duties as assigned.

Hands-on experience with :

• Oracle version 12c, 19c, or 23c in on-premise and cloud Microsoft Windows Server and Linux environments.
• SQL*Plus and PL / SQL programming, as well as SQL query tuning
• Oracle backup and recovery using export Data Pump, RMAN and hot backup.
• Oracle Database Performance Tuning using various Oracle and 3rd party tools.
• Relational databases, including Oracle DB, SQL Server, and MySQL databases.
• Tools for Oracle Administrator (TOAD) from Quest Software.
• Creating Oracle packages, stored procedures and triggers in Oracle databases
• Understanding entity relationship diagrams and principles of database design and implementation
• Loading raw data from CSV, XML and JSON
• JDBC, ODBC Oracle Gateway and other connectivity APIs
• Version control systems such as GIT
• PowerShell and Bash Shell

Additional applicable industry experience may be substituted for a college degree.

Education and Experience :

Bachelor’s degree in computer science, Data Science, MIS, Mathematics, or related field and a minimum of at least 7 years of hands-on experience as Oracle Database Administrator in production support role.