At a Glance
- Tasks: Administer PostgreSQL and Oracle databases, ensuring performance and reliability in cloud and on-premises environments.
- Company: Join a public sector client with a focus on data governance and security.
- Benefits: Fully remote work, part-time hours, and potential for contract extension.
- Other info: Collaborative team environment with opportunities for professional growth.
- Why this job: Make a real impact by managing critical data structures in a regulated environment.
- Qualifications: Experience as a DBA with strong skills in data modelling and database administration.
The predicted salary is between 55000 - 65000 £ per year.
We are supporting a public sector client in hiring an experienced PostgreSQL and Oracle Database Administrator with strong data modelling expertise to join an established data platform team. This is a hands-on technical role requiring deep database administration experience across both PostgreSQL and Oracle environments, spanning cloud and on-premises infrastructure. The successful candidate will own core application data structures, drive database performance and reliability, and work closely with software engineers, data pipeline engineers and data scientists to design and maintain robust data models that support business-critical applications. This role suits an experienced DBA and Data Modeller comfortable managing complex, multi-environment database estates and contributing to data governance, security and platform evolution within a regulated public sector environment.
Key Responsibilities
- Own and administer PostgreSQL and Oracle database clusters across cloud and on-premises environments, ensuring high availability, scalability and reliability.
- Monitor, troubleshoot and optimise database performance across all environments, including production, testing and development.
- Design, maintain and evolve logical and physical data models to support application and data integration requirements.
- Manage database schema changes and migrations across development, testing, production and offline environments.
- Define and govern the life cycle of application data, ensuring data quality, consistency and compliance.
- Implement and manage database security controls including user roles, permissions, authentication mechanisms and Row-Level Security.
- Collaborate with data engineers and data scientists to onboard and integrate diverse internal and external data sources.
- Develop and maintain backup, recovery, disaster recovery and business continuity procedures.
- Support CI/CD-driven database deployments, schema versioning and automation of database-related activities.
- Contribute to capacity planning, database architecture recommendations and establishment of standards and best practices.
Essential Skills
- Proven enterprise-scale experience as both a PostgreSQL and Oracle Database Administrator.
- Strong expertise in database design, data modelling and schema architecture across logical and physical models.
- Oracle RDBMS experience across versions 10g, 11g, 12c and 19c including RAC, Data Guard and GoldenGate.
- Minimum 3 years of experience setting up and maintaining production Oracle RAC and Data Guard environments.
- Strong knowledge of Oracle performance tuning, RMAN backup and recovery, OEM and Oracle 12c Grid.
- Experience with PostgreSQL and Oracle high availability, replication and migration technologies.
- Good knowledge of SQL, PL/SQL, stored procedures and packages.
- Good knowledge of UNIX Shell or Perl Scripting.
- Experience managing database security including role management, permissions, encryption and Row-Level Security.
- Experience supporting CI/CD-driven database deployments and schema versioning.
Desirable Skills
- Infrastructure automation and Scripting experience across Python, Bash or PowerShell.
- Exposure to cloud platforms across AWS, Azure or GCP.
- Familiarity with data engineering, ETL and ELT pipelines and data warehousing concepts.
- Experience with monitoring and observability tooling for database environments.
- Understanding of DevOps practices and Infrastructure as Code frameworks.
StudySmarter Expert Advice🤫
We think this is how you could land Oracle & PostgreSQL Database Administrator (SC Cleared)
✨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 Montash 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 Montash 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 & PostgreSQL Database Administrator (SC Cleared)
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 Montash.
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 Montash. 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 Montash
✨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 Montash—they’ll appreciate your enthusiasm for both the role and their team!
