At a Glance
- Tasks: Design, build, and support Oracle databases while ensuring optimal performance and compliance.
- Company: Join a leading banking client focused on innovation and efficiency in database management.
- Benefits: Enjoy remote work flexibility, compensatory time off, and opportunities for professional growth.
- Why this job: Be part of a dynamic DevOps team, tackling real-world challenges with cutting-edge technology.
- Qualifications: Strong experience with Oracle RDBMS, RAC, Dataguard, and Linux required; scripting skills a plus.
- Other info: 24/7 support role with on-call duties; ideal for those seeking hands-on experience in a fast-paced environment.
The predicted salary is between 48000 - 72000 Β£ per year.
Location: Remote, UK
Duration: 6 months+
Banking client experience required
Job Description
Responsible for the design, build and day-to-day support of the Oracle databases. These databases are each 100TB in size (and growing), hold over 13 billion rows of data each and together process circa 1 billion SQL statements per day. As part of a DevOps team, you will work closely with the application and infrastructure POD SMEs to ensure these critical services function to the required standards. Maintain and improve SLAβs and ensure compliance to client policies at all times. Actively participate to achieve organisation objectives for efficiencies, innovations, and quality delivery. Perform pro-active analysis on day-to-day work, identify areas for automation, report and follow up on process or technical gaps, reduce repeat or false incidents, and standardise tasks/processes. Support is required 24 hrs. x 7 days a week x 365 days from office or on call depending on business needs (usually 1 week in 4 on-call). Required to work on weekends (usually 1 in 4) often at short notice. Resource will get compensatory time-off as per HR guidelines.
Responsibilities
- All aspects of the Oracle DBA Support including the design, build, ongoing enhancements (e.g. automation) and 24*7 support
- RAC, Oracle 19, Database Restoration, Troubleshooting
- Must have strong experience of Oracle (v19c) RDBMS, RAC and Dataguard on a LINUX platform including:
- Perform Database software installation, upgrades and apply relevant patches
- Perform Database migrations β intra platform or inter platform
- Build and Deploy/Implement Solutions. Perform Capacity Planning and DR Planning.
- Troubleshooting and fixing incidents
- Creating / altering / dropping tablespaces
- Clone one environment from another
- Database backup / restore
- Data Archival activities
- Assist the development community with the resolution of miscellaneous queries and problems
- Database space management
- Implementing releases / service requests
- Server monitoring including health checks at server level and database level
- Keeping the systems up and running cleanly
- Timely escalation of issues to Team Lead
- Performance and Tuning of database
- Scripting Skills
- Customer Service and Problem Resolution
- Actively participate in crisis calls taking the lead from an Oracle DB perspective
- Participate in identifying problem situations and resolve to give maximum customer satisfaction
Locations
Oracle DBA- Banking client exp required employer: Vallum Associates
Contact Detail:
Vallum Associates Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land Oracle DBA- Banking client exp required
β¨Tip Number 1
Familiarise yourself with the specific requirements of Oracle DBA roles, especially in a banking context. Understanding the unique challenges and compliance standards in the banking sector will help you stand out during discussions.
β¨Tip Number 2
Network with professionals already working in Oracle DBA roles within the banking industry. Engaging with them on platforms like LinkedIn can provide insights into the role and potentially lead to referrals.
β¨Tip Number 3
Stay updated on the latest trends and technologies related to Oracle databases, particularly version 19c and RAC. Demonstrating your knowledge of current best practices during interviews can significantly boost your chances.
β¨Tip Number 4
Prepare for technical interviews by practising common DBA scenarios, especially those involving troubleshooting and performance tuning. Being able to articulate your problem-solving process will impress potential employers.
We think you need these skills to ace Oracle DBA- Banking client exp required
Some tips for your application π«‘
Tailor Your CV: Make sure your CV highlights your experience with Oracle databases, particularly with RAC, Dataguard, and Linux platforms. Include specific examples of your work in banking environments to demonstrate relevant expertise.
Craft a Strong Cover Letter: In your cover letter, emphasise your understanding of the responsibilities outlined in the job description. Mention your experience with database support, automation, and any relevant projects that showcase your problem-solving skills.
Highlight Relevant Skills: Clearly list your technical skills related to Oracle DBA tasks, such as database restoration, troubleshooting, and performance tuning. Make sure to include any scripting skills and customer service experience, as these are crucial for the role.
Proofread Your Application: Before submitting your application, carefully proofread all documents for spelling and grammatical errors. A polished application reflects your attention to detail, which is essential for a role that involves managing large databases.
How to prepare for a job interview at Vallum Associates
β¨Showcase Your Technical Skills
Be prepared to discuss your experience with Oracle databases, particularly version 19c, RAC, and Dataguard. Highlight specific projects where you've successfully implemented solutions or resolved complex issues, as this will demonstrate your hands-on expertise.
β¨Understand the Banking Sector
Since the role requires banking client experience, make sure you understand the unique challenges and regulations in the banking industry. Be ready to discuss how your previous experience aligns with these requirements and how you can contribute to maintaining compliance and improving SLAs.
β¨Emphasise Problem-Solving Abilities
Prepare examples of how you've identified and resolved technical gaps or inefficiencies in past roles. Discuss your approach to troubleshooting and how you ensure customer satisfaction, especially during crisis situations, as this is crucial for a DBA role.
β¨Demonstrate Team Collaboration
As you'll be working closely with application and infrastructure teams, highlight your experience in collaborative environments. Share examples of how you've effectively communicated and worked with cross-functional teams to achieve common goals, particularly in a DevOps setting.