Role: Oracle Database Management Specialist (Senior) Location: Pikesville, MD A qualified resource will possess knowledge of Oracle Engineered Systems, Oracle Linux, and Oracle Databases. Candidate will ensure the availability and stability of the Oracle database environment to support mission-critical applications maintained by Maryland State Police. The candidate will provide enterprise-wide, documented server support for Test, Development, Staging, and Production Oracle servers at the direction of his/her supervisor and will follow MSPs standard operating procedures. Must be capable of providing highly technical expertise and support in the use of DBMS. Must be able to evaluate and recommend available DBMS products to support validated user requirements. Defines file organization, indexing methods, and security procedures for specific user applications. The candidate will monitor and optimize the performance of the databases and database servers, maintain and monitor Data Guard, plan for backup and recovery of databases, and ensure availability of the Oracle Database Appliance system (ODA) across all environments. Education: A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or three (3) years of equivalent experience in a related field. Two (2) additional years of specialized experience may be substituted for the required education. General Experience: Must have six (6) years of experience in DBMS systems analysis and programming. Preferred: Experience with Oracle Engineered Systems and their related technologies (Specifically Oracle Data Appliance) Oracle Certified Associate/ Master (OCA or OCM) or related certifications. In-Depth knowledge or Oracle Linux. Experience with Oracle 12c and Oracle 19c to include Oracle Multi-tenancy as well as the management and maintenance of Container and Pluggable databases (link removed) Experience with any of the following: Oracle Data Guard, Oracle Enterprise Manager (OEM), RMAN, Oracle Audit Logs, Oracle TDE, Oracle database migration methodologies including data pump export/import, cloning, RMAN transportable tablespaces, and cross-platform migration. Duties, Responsibilities and Tasks: Installation, configuration, patching, monitoring, upgrading, troubleshooting of issues, and overall management of MSPs Oracle Linux and Oracle ASM systems in the Oracle Database Appliance (ODA) environment. Managing Storage: Partitioning disks, creating filesystems, and setting up storage solutions like LVM or RAID for data redundancy and performance. Optimization of data security tools/processes including, but not limited to: Oracle Transparent Data Encryption (TDE); Oracle Data Guard to ensure no loss of data; remediation of security vulnerabilities. Working with Oracle Support: Collaborating with Oracle support teams to troubleshoot complex issues or seek guidance on best practices. Management and configuration of Oracle Unified Auditing. Implementation and management of Oracle database backup and recovery (RMAN); periodic review of data recovery procedures to ensure quick, reliable, and repeatable database restoration. Recommend infrastructure configurations and updates. Develop and maintain detailed documentation of Oracle support processes and instructional procedures. Attendance at MSP ITD meetings (as required). Regular status reporting of assigned tasks to MSP supervisor. After-hours support (as required). timely response to help desk tickets all systems maintained and updated Concise, clearly written documentation daily monitoring of the ODA environment configuration and documentation of Oracle Data Guard between data centers documentation and periodic review of data backup and restore procedures; confirmation of current, validated backups identify, report, document and resolve security vulnerabilities and server upgrades/changes