Raymond James Financial, Inc. Senior Database Administrator- Oracle in United States
About the role:
As a Senior Database administrator, you will be part of a dynamic team that administers and manages complex database systems. You will create, manage and monitor mission critical databases that are core to the firm. You will be responsible for database administration on Oracle Exadata, ODA and PCA appliance engineered systems, solving complex performance problems, capacity planning and automation. In this role, you are the primary on the most complex or escalated issues and may provide direction and guidance team members. This role is be based out of our headquarters in St. Petersburg, FL but we are open to remote candidates that are based out of other locations in the US as well.
Essential Duties and 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.
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.
Minimum of a Bachelor’s degree in Computer Science, MIS or related degree and five (5) years of relevant experience including database administration, database programming experience or combination of education, training and experience.
2-5 years experience with Exadata and performance tuning experience on Exadata systems
5-7 years experience as a hands on Senior Oracle database administrator.
Experience in Oracle 19c, 18c, 12c, Exadata, ASM, ZFS Appliance, database monitoring, Dataguard
Expert in RMAN backup/restore with optimization
Experience in Exadata/Oracle patching procedure with additional exposure to ODA and PCA systems preferred
5-7 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, Exadata and other engineered systems, Multitenant, Oracle Enterprise Manager (OEM)
Experience with PL/SQL code development and tuning
Experience in Linux OS and Korn/Bourne shell scripting
Extensive experience in performance tuning and analysis using AWR, ASH, wait analysis
Experience with automation and scripting skills using Perl, Python a strong plus
Strong ITIL principles a plus.
Capacity planning for all aspects of a database system (storage, compute, memory, etc.)
Understanding of networking and connectivity and how it relates to a database environment.
Ability to work non-standard shift including nights and/or weekend on-call responsibilities
Experience in Financial Services or other regulated industry preferred
Participates in application development processes and code reviews
Experienced in RMAN backup and recovery process
Analyzes long-term database performance trends to optimize database and application performance
- None required.
Primary Location: US-FL-St. Petersburg-Saint Petersburg
Other Locations: United States
Job Shift Day Job
Req ID: 2001788
Raymond James Bank is an EOE/AA and VEVRAA Federal Contractor
Priority will be given to protected veterans
EOE Protected Veterans/Disability
Raymond James Financial, Inc.
- Raymond James Financial, Inc. Jobs