Lead Database Administrator

About the position

The Lead Database Administrator at Raymond James & Associates, Inc. is responsible for ensuring the availability, security, and integrity of assigned databases. This role involves resolving performance and capacity issues, installing and configuring database management software, and developing maintenance plans. The position requires advanced knowledge of Oracle products and involves participation in data modeling, application development processes, and performance optimization.

Responsibilities

• 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.
• 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.

Requirements

• Bachelor's degree in Computer Science, MIS, or related field.
• Six (6) years in any occupation with database administration experience including relational database programming experience.
• Five (5) years of experience with 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 in Oracle 19c, 12c, ASM, database monitoring, and Linux OS.
• Experience with 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.