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
Top Skills
What We Do
Since 1972, Phoenix American has focused on empowering the alternative investment fund industry. The company offers an end-to-end fund operations suite: fund accounting, fund administration, transfer agency, 1099/K-1 production, financial and sales reporting, compliance services, printing, mailing and fulfillment services - all specifically designed for alternative investments.
Gus Constantin, Chairman and Chief Executive Officer, founded Phoenix American as an equipment leasing fund sponsor in Marin County, California. From the company’s origins as a fund sponsor, advanced technology platforms and operation procedures were developed and perfected that now make Phoenix American a premier back office service provider for alternative funds.
Today, Phoenix American has offices in California, New Hampshire, Great Britain, Ireland, India and Cuba. The company is an SEC registered transfer agent and provides a complete range of SOC 1, Type II audited back office outsourcing services performed by experienced operations staff trained in accord with Securities Transfer Association (STA) guidelines. Services include: fund administration, fund accounting, transfer agency, tax services, sales reporting, investor accreditation, CRM solutions, phone team support, printing and fulfillment. Phoenix American also provides administration and accounting services for securitization funds and is an industry leader in the commercial aircraft category.
Phoenix American clients include Hedge Funds, Private Equity, Venture Capital, Non-Traded REITs, BDCs, Securitization Funds, Commodity Pool Operators and Equipment Leasing Funds. The company provides services and consultation for every structure of alternative investment including: 506b funds, 506c funds, Regulation A+, Regulation D, 40 Act Funds, registered public offerings, private funds and Limited Partnerships.
