Ensures availability, security and integrity of assigned databases.
Resolves database performance, capacity, replication, and other distributed data issues.
Installs and configures database management software (DBMS) and applicable service packs and/or patches.
Develops and implements database maintenance plans, including performing integrity checks, updating statistics and monitoring security and hardware resource utilization.
Establishes regular backups of databases and archive logs.
Advanced knowledge of RAC and DataGuard.
Manages logins and user accounts, including assigning database object permissions and ancillary privileges.
Schedules and manages jobs for data transfers and sundry procedures and monitors performance and impact on operations.
Participates in data modeling and database logical and physical design.
Participates in application development processes and code reviews of database objects.
Analyzes long-term database performance trends to optimize database and application performance.
Configures database server to work with middleware, web servers and OnLine Analytical Processing (OLAP) tools.
Configures, supports, and optimizes replication.
Performs acceptance testing on computer systems, applications and hardware.
Performs other duties and responsibilities as assigned.
Qualifications: REQUIREMENTS:
Bachelor's degree in Computer Science, MIS, or related.
Six (6) years in any occupation with database administration experience including relational database programming experience must include: Five (5) years of experience with the following Oracle products and options: Oracle RDBMS Enterprise Edition, Real Application Clusters (RAC), Replication solutions such as Data Guard and Golden Gate, Multitenant, Oracle Enterprise Manager (OEM).
Five (5) years of experience as a hands on Senior Oracle Database Administrator.
Experience must also include: Experience in Oracle 19c, 12c, ASM, database monitoring, and Linux OS; RMAN backup/restore with optimization; Experience in Oracle patching procedure; Experience with PL/SQL code development and tuning; Experience in performance tuning and analysis using AWR, ASH, wait analysis; Capacity planning for all aspects of a database system (storage, compute, memory, etc.
); Networking and connectivity and how it relates to a database environment; Application development processes and code reviews; Experience in RMAN backup and recovery process; and Analyzing long-term database performance trends to optimize database and application performance.