Lead Engineer, Database Admin

Job Description Summary

Job Description

DUTIES:                                

• Responsible for database administration on Oracle Exadata appliance engineered systems, solving complex performance problems, capacity planning and automation.
• Perform SQL code development and tuning.
• Ensure availability, security and integrity of assigned databases.
• Resolve database performance, capacity, replication, and other distributed data issues.
• Install and configure database management software (DBMS) and applicable service packs and/or patches.
• Develop and implement database maintenance plans, including performing integrity checks, updating statistics and monitoring security and hardware resource utilization.
• Establish regular backups of databases and archive logs.
• Advanced knowledge of RAC and DataGuard.
• Manage logins and user accounts, including assigning database object permissions and ancillary privileges.
• Schedule and manage jobs for data transfers and sundry procedures and monitors performance and impact on operations.
• Participate in data modeling and database logical and physical design.
• Participate in application development processes and code reviews of database objects.
• Analyze long-term database performance trends to optimize database and application performance.
• Configure database server to work with middleware, web servers and OnLine Analytical Processing (OLAP) tools.
• Configure, support, and optimize replication.
• Perform acceptance testing on computer systems, applications and hardware.
• Perform other duties and responsibilities as assigned.

REQUIREMENTS:                

• Bachelor’s degree in Computer Science, Management Information Systems, or related.
• Five (5) years in any occupation with database administration, database programming, or related experience.
• Five (5) years in any occupation with database administration, database programming, or related experience must include:
• Five (5) years of experience as a hands-on Senior Oracle Database Administrator with the following Oracle products:
• Oracle RDBMS Enterprise Edition, Real Application Clusters (RAC), Replication solutions including Data Guard and Golden Gate, Exadata and other engineered systems, Multitenant, Oracle Enterprise Manager (OEM).
• Experience must also include: Oracle 19c, 18c, 12c, ASM, database monitoring, and Linux OS; RMAN backup/restore with optimization;
• Exadata/Oracle patching procedure;
• Performance tuning and analysis using AWR, ASH, wait analysis;
• Automation and scripting using Ansible Shell Scripting and Python.

SALARY:                               

$155,500 per year

Education

Work Experience

Certifications

Travel

Workstyle

The total compensation for this position includes base salary or wages, and may include components such as additional compensation (cash or equity), discretionary bonuses, or commissions. This position is eligible for a benefits package that may include medical, dental, and vision; life insurance; critical illness insurance and accident insurance; disability benefits; retirement savings; paid time off (including vacation, holidays, and sick leave); and parental leave.  Eligibility for benefits and specific offerings may vary based on position and employment status. To view more details of the benefits offered, visit Myrjbenefits.com.

At Raymond James our associates use five guiding behaviors (Develop, Collaborate, Decide, Deliver, Improve) to deliver on the firm's core values of client-first, integrity, independence and a conservative, long-term view. 

We expect our associates at all levels to:
•  Grow professionally and inspire others to do the same
•  Work with and through others to achieve desired outcomes
•  Make prompt, pragmatic choices and act with the client in mind
•  Take ownership and hold themselves and others accountable for delivering results that matter
•  Contribute to the continuous evolution of the firm

At Raymond James – as part of our people-first culture, we honor, value, and respect the uniqueness, experiences, and backgrounds of all of our Associates.  When associates bring their best authentic selves, our organization, clients, and communities thrive. The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs.