Lead Database Administrator

Raymond James & Associates • Denver, CO

440d • $140,338 - $140,338

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 various database issues, managing database performance, and implementing maintenance plans. The position requires advanced knowledge of Oracle products and involves participation in application development processes, data modeling, and performance optimization.

Requirements

• Bachelor's degree in Computer Science, MIS, or related field.
• Six (6) years in any occupation with database administration 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.
• Experience in RMAN backup and recovery process.
• Analyzing long-term database performance trends to optimize database and application performance.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Securities, Commodity Contracts, and Other Financial Investments and Related Activities
• Education Level: Bachelor's degree