Get new jobs for this search by email

Company Description

Phoenix American Incorporated is made up of a diversified group of companies providing financial services to clients since 1972. We are a leader in the field of securitization administration and accounting managing over $14 billion of aviation assets at original issuance. We are an industry leader in asset management data offering sales reporting for the Mutual Fund Industry and data monitoring and cleaning services. We have a reputation for excellence providing distinctive quality, superior technology and committed customer service to our clients for more than forty years.

Job Description

This role entails providing expertise in Linux system administration and Oracle database management within the Information Technology department while also serving as a liaison to the software development team. The ideal candidate will be a seasoned Senior DBA with experience managing databases exceeding 1TB in a highly available Production environment. Primary responsibilities will include environment setup, production support, and overseeing software upgrade deployments in the production environment.

Core Responsibilities and Expertise ( including the following other duties may be assigned). :

Oracle Enterprise Linux Administration:

Installs, configures, and maintains

Oracle Enterprise Linux (OEL)

environments, ensuring secure, stable, and optimized performance.

Database Installation and Management:

Installs Oracle software, creates and configures databases, and maintains database instances. Develops and manages database objects, user accounts, roles, and security policies.

Backup, Recovery, and Disaster Management:

Designs and implements reliable

backup and recovery processes

using tools such as

RMAN

and

Data Guard . Actively participates in the

disaster recovery process

to ensure business continuity.

Performance Tuning and Optimization:

Conducts in-depth Oracle database performance analysis, system sizing, and capacity planning. Continuously tunes and optimizes database performance, including stored procedures and dynamic SQL, leveraging Oracle-specific features. Performs ongoing analysis, refactoring, and tuning of OLTP/DSS schemas to ensure high performance.

Standards, Best Practices, and Leadership:

Develops, enforces, and communicates Oracle database standards, procedures, and best practices. Provide senior-level technical leadership to the DBA team and act as a

lead DBA

for critical projects.

Technical Support and Troubleshooting:

Provides DBA and Linux system administration support across multiple applications in test and production environments. Diagnoses, troubleshoots, and documents database issues efficiently to minimize downtime. Assists the support team in diagnosing and resolving performance problems in customer production environments.

Mentoring and Developer Collaboration:

Mentors application developers on designing high-performance, scalable data models and optimizing interactions with persistence layers. Specifies, designs, and implements load tests and performance diagnostic tools to identify bottlenecks and improve system performance.

Project Management and Multi-tasking:

Manages multiple projects concurrently and adapts to shifting priorities while ensuring timely completion. Participates in

on-call rotations

and is available for off-hours and weekend support during upgrades, maintenance, or troubleshooting.

Cross-Platform Database Support:

Provides support for multiple database platforms, ensuring consistent performance, security, and stability across environments.

Experience as Oracle EBS Database Administrator

Experience with upgrading, patching, and maintaining Oracle EBS applications. Experience with Oracle WebLogic, Concurrent Manager, and Workflow administration is a plus. Familiarity with Linux/Unix administration for Oracle EBS environments.

Qualifications

10+ years

of extensive experience in the IT industry, specializing in database administration and Linux system management. 7+ years

of proven expertise as an

Oracle DBA , managing Oracle versions

19c, 21c, 23c, and 23ai

in highly available production environments. 5+ years

of experience in

Linux system administration , with a focus on

RHEL/Oracle Enterprise Linux (OEL) 7/8/9 , managing enterprise-level database infrastructure. 5+ years

of SQL Server DBA experience (including SQL Server 2022) is highly desirable. Strong background in

database design and programming , with proficiency in SQL, PL/SQL, T-SQL, and bulk/batch processing. Recent hands-on experience managing large-scale Oracle and SQL Server databases, ensuring performance, security, and high availability. Adept at supporting Oracle on

Oracle Enterprise Linux and Windows platforms , with deep expertise in the following areas:

Setting up and configuring new production environments. Installing Oracle Enterprise Linux, Oracle database software, and creating/configuring large databases (up to

5 TB ). Configuring large server environments, backup and recovery strategies, and standby databases using

RMAN

and

Data Guard . Performance tuning, query optimization, and troubleshooting in large-scale environments. Automating tasks using Unix shell scripts. Managing and maintaining servers deployed in

VMware virtualized environments .

Proficient in designing and supporting large database architectures with partitioning for high-volume environments. Oracle DBA certification

is a plus, reflecting validated expertise in Oracle database administration. Core Technical Skills required:

Database Platforms:

Oracle 19c/21c/23c/23ai, MS SQL Server 2022 Operating Systems:

RHEL, Oracle Enterprise Linux (OEL 7/8/9), Windows Server 2016/2019/2022 Virtualization Platforms:

VMware ESXi, vSphere Scripting & Automation:

Unix Shell scripting, PL/SQL, T-SQL Data Management:

Backup/Recovery (RMAN), High Availability, Data Guard, Partitioning and ASM Performance Tuning Tools:

Statspack, AWR, ADDM, SQL Trace, TKPROF

Additional Information

Must be US Citizen or permanent US Resident

EQUAL OPPORTUNITY EMPLOYER