
Lead Database Administrator
FIS
full-time
Posted on:
Location Type: Office
Location: Jacksonville • Florida • New York • United States
Visit company websiteExplore more
Salary
💰 $119,560 - $200,840 per year
Job Level
About the role
- Responsible for the administration, performance, and security of Oracle databases.
- Collaborate with teams to ensure high availability and disaster recovery of databases.
- Develop and maintain backup and recovery strategies for critical databases.
- Monitor and optimize database performance, application response times, and data integrity.
Requirements
- Oracle 19c Administration: Install, configure, patch, and upgrades of Oracle 19c databases.
- Knowledge and experience with High Availability and Disaster Recovery (HA/DR) technologies, such as ODA and Exadata.
- Expertise in database migration, including transitions from older versions to Oracle 19c.
- Demonstrate strong proficiency in SQL and PL/SQL for developing and maintaining database objects and code.
- Utilize tools like Data Pump, RMAN, and AWR/ADDM for effective data movement and analysis.
- Capable of writing and maintaining shell scripts for monitoring and automation purposes.
- Skilled in modeling and creating both logical and physical database models.
- Develop PLSQL packages, functions, and procedures.
- Strong expertise in Star-Schema data transformation.
- Perform performance tuning for OLTP and batch workloads using tools like EXPLAIN PLAN, TKPROF, AWR, and ADDM.
- Optimize SQL and queries to enhance application response times.
- Design and execute robust backup and recovery strategies.
- Implement and validate automated backup policies.
- Implement security measures, user roles, and auditing to ensure data integrity and protection.
- Experience with Transparent Data Encryption (TDE) and Oracle Advanced Security.
- Manage databases on cloud platforms such as Azure or AWS EC2/RDS.
Benefits
- A voice in the future of fintech
- Always-on learning and development
- Collaborative work environment
- Opportunities to give back
- Competitive salary and benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
Oracle 19c AdministrationSQLPL/SQLDatabase MigrationPerformance TuningBackup and Recovery StrategiesShell ScriptingData TransformationDatabase ModelingHigh Availability and Disaster Recovery