At a Glance
- Tasks: Manage and optimise Oracle database clusters for performance and security.
- Company: Award-winning tech firm with a focus on security and inclusivity.
- Benefits: Competitive pay, flexible work arrangements, and a supportive environment.
- Other info: Opportunity for career growth in a collaborative and innovative setting.
- Why this job: Join a leading company and enhance your skills in a dynamic IT role.
- Qualifications: Experience with Oracle databases and strong troubleshooting skills.
The predicted salary is between 51750 - 63250 £ per year.
- Role Title: SQL - Oracle Database Administrator
- Duration: 6 initial months contract
- Rate INSIDE IR35 MARKET RATE
- SC Cleared
- Role Description
- Focusing on scalability, integrity, performance, availability, security, monitoring and troubleshooting of core DB clusters
- Owning core database clusters in Production as well as on a wide range of technologies
- Reporting into the Operations Manager and working alongside the Senior DBA
- Oracle schema object sizing.
- Monitor data block organisation.
- Monitor physical storage and contention.
- Monitor tablespace utilization
- Memory usage.
- Physical I/O tuning.
- Lock monitoring.
- Database resource utilization.
- Alert log, Backup status
- Database free space.
- Performance tuning ratios
- Check Invalid objects
- Monitor build-up of trace files.
- Monitor growth of alert logs.
- Purge log and trace files, which are no longer required.
- Database Monitoring
- Cache (Buffer Cache, Library Cache, Dictionary Cache) hit/miss ratios
- Point in time database recovery, using on-line redo logs.
- Provide advice during database restoration following a crash or media failure.
- Monitor Archive log retention period for database recoverability and highlight issues / limitations.
- Ensure database changes are reflected into the backup strategy.
- Your Skills And Experience
- Shared pool usage
- Customized DBMS_JOBS running
- Logical I/O on the database
- SAR on the database server
- Locks on the database
- Sessions and session queries
- Monitor database availability issues
- Monitor on-line and archived log file usage
- Monitor roll‑back segment usage
- EARS call handling for Oracle DBA team
- Change handling for Oracle DBA team
- Participate in implementation planning
- Export & Import data between production and test instances as required
LA International is an award-winning partner of choice for many of the world's most influential companies and government organizations.
Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance.
A multiple award-winning organisation, having secured the prestigious Queens Award for
Enterprise: International Trade over consecutive years.
We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported.
We welcome applications from all individuals, regardless of background or identity, and we encourage candidates who may not meet every listed requirement to still apply.
If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience.
Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.
#J-18808-Ljbffr
Oracle SQL Engineer (IT) / Contractor employer: Free-Work UK
Flotek Group is an exceptional employer, offering a dynamic work environment in Bridgend, St Asaph, or Plymouth, where employees are at the heart of our values-led business. With a focus on professional growth, we provide ample opportunities for learning and development within one of the UK's fastest-growing Managed Service Providers, alongside competitive benefits such as a staff share equity scheme and increasing holiday entitlement. Join us to be part of a passionate team dedicated to delivering world-class IT solutions while enjoying a supportive and collaborative culture.
StudySmarter Expert Advice🤫
We think this is how you could land Oracle SQL Engineer (IT) / Contractor
✨Get Social in the Data World
Join online communities like Stack Overflow or Reddit's r/Database to connect with others in database management. Share your insights and ask questions to get noticed by industry insiders who might know of temporary roles!
✨Showcase Your Skills
Create a small project using the database software you’re familiar with—maybe something fun like a personal book or music database. Having a project to demonstrate will make you stand out to companies like Free-Work UK when they see your hands-on approach!
✨Utilise Temporary Staffing Agencies
Many temp positions in database management are filled through staffing agencies. Get in touch with agencies that focus on tech roles, and let them know you're on the lookout for short-term opportunities. They can be a great bridge to finding your next gig.
✨Direct Applications are Key!
Don’t shy away from applying directly to Free-Work UK through our website. Temporary roles often get posted without fanfare, so check back frequently, and don’t hesitate to reach out if you see a position that fits your skills!
We think you need these skills to ace Oracle SQL Engineer (IT) / Contractor
Some tips for your application 🫡
Highlight Your Technical Skills:In the world of database management, it’s essential to showcase your technical skills upfront. Make sure your CV includes relevant programming languages, database systems you’ve worked with, and any data modelling tools you’re familiar with. We want to see how your skills align with the needs of Free-Work UK.
Document Your Projects:If you have completed any database projects, don’t forget to mention them! Include specific examples that demonstrate your problem-solving abilities and your experience with data migration or optimisation. Having a portfolio or a section on your CV detailing these projects can really set you apart in a temporary role.
Express Your Flexibility:Since this is a temporary position, it’s key to highlight your adaptability in your cover letter. Let us know that you’re ready to jump into different tasks and tackle challenges as they arise at Free-Work UK. This shows that you’re not just looking for another job, but you’re excited about contributing to our team.
Keep it Concise:For a temporary role like this, keep your application concise and focused. Use bullet points to list your relevant experience and skills, making it easier for us to absorb the info quickly. Your aim should be to grab attention without overwhelming us with unnecessary details. And remember, submit your application through our website!
How to prepare for a job interview at Free-Work UK
✨Get Hands-On with Tools
In database management, it’s crucial to be familiar with the tools of the trade like SQL, NoSQL, or even data visualisation software. Make sure you’ve got some practical examples ready to discuss how you’ve used these tools, and maybe even try to whip up a sample database to share in a discussion. This shows you're not just theory, but can get stuck in.
✨Brush Up on Technical Questions
Expect some technical questions that dive deep into your problem-solving skills. Be prepared to tackle scenarios where you might need to optimise a database query or explain data normalisation. This is a key area for database management roles, and demonstrating your understanding here can set you apart from other candidates.
✨Show Your Flexibility and Adaptability
Since this is a temporary role, showcasing your flexibility is key. Be ready to discuss past experiences where you quickly adapted to new systems or tasks. Emphasise your eagerness to hit the ground running and how easily you can familiarise yourself with the company’s database systems. Companies love a candidate who can dive right in without unnecessary handholding!
✨Pitching Yourself and Your Availability
In a temporary role, your availability is crucial. Be upfront about your schedule and how you can commit to the temporary demands of the job. Plus, don’t forget to express your keen interest in learning and contributing to Free-Work UK—they’ll appreciate your enthusiasm for both the role and their team!
