At a Glance
- Tasks: Manage and optimise PostgreSQL and Oracle databases, ensuring high availability and security.
- Company: Join a leading global FinTech company on an exciting 6-month contract.
- Benefits: Enjoy remote work flexibility with competitive daily rates and potential for extension.
- Why this job: Be part of a dynamic team, enhancing data infrastructure and making a real impact.
- Qualifications: Hands-on experience with PostgreSQL and Oracle in production environments is essential.
- Other info: Immediate consideration for applicants; don't miss out on this opportunity!
The predicted salary is between 90000 - 120000 £ per year.
To join a global FinTech on a 6-month contract with possible extension. Rate - £450 - £500 Per day Inside IR35 - Remote.
The role requires hands-on technical expertise and strong collaboration with developers, architects, and DevOps teams to ensure our data infrastructure aligns with business needs and industry standards.
Your Responsibilities
- Manage, configure and optimise PostgreSQL databases hosted on Amazon Aurora and Oracle databases hosted on on-premise Exadatas and AWS RDS.
- Support the migration of high-performance, mission-critical databases from on-premise Exadata's to AWS Aurora Postgres.
- Support workloads on other database engines in AWS, including MySQL, MariaDB and SQL Server.
- Implement and maintain strong security standards to ensure compliance with PCI DSS and other regulatory requirements.
- Implement security best practices, including user management, encryption and auditing.
- Design and implement database schemas, partitioning strategies and indexing solutions.
- Ensure high availability, disaster recovery and scalability of database systems.
- Configure strong monitoring and management processes and tooling to help troubleshoot and resolve complex database issues in Real Time.
Your profile
Essential
- Hands-on experience as a PostgreSQL and Oracle DBA in production environments.
- Significant experience of migrating database workloads to Postgres from Oracle.
- Deep understanding of PostgreSQL architecture, including replication, clustering and indexing strategies, and a strong understanding of Postgres' vacuum/MVCC process.
- Proven experience with query optimization and database performance tuning.
- Hands-on experience with AWS services such as EC2, S3, VPC, and IAM.
- Solid understanding of database security principles and compliance frameworks.
- Experience implementing robust backup and recovery strategies.
Desirable
- Proficiency with infrastructure automation tools like Terraform or CloudFormation.
- Familiarity with monitoring tools such as CloudWatch, Datadog, or similar.
- Experience of database replication tooling such as AWS DMS and Goldengate.
- Experience of collaborating with DevOps teams to integrate databases into CI/CD pipelines and infrastructure-as-code (IaC) frameworks like Terraform.
Please APPLY NOW for immediate consideration!
Contact Detail:
Fynity Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Administrator
✨Tip Number 1
Familiarise yourself with PostgreSQL and Oracle database management. Since the role requires hands-on experience, consider setting up a personal project or contributing to open-source projects that involve these databases to showcase your skills.
✨Tip Number 2
Brush up on your AWS knowledge, particularly services like EC2, S3, and RDS. Being able to discuss how you've used these services in past projects will demonstrate your capability to manage cloud-based databases effectively.
✨Tip Number 3
Prepare to discuss your experience with database migration, especially from Oracle to PostgreSQL. Be ready to share specific challenges you faced and how you overcame them, as this is a key requirement for the role.
✨Tip Number 4
Highlight any experience you have with security best practices and compliance frameworks. Given the importance of PCI DSS compliance in this role, being able to articulate your understanding and implementation of security measures will set you apart.
We think you need these skills to ace Database Administrator
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your hands-on experience with PostgreSQL and Oracle databases. Include specific examples of database migrations you've managed, especially from Oracle to Postgres, as well as any relevant AWS services you've worked with.
Craft a Strong Cover Letter: In your cover letter, emphasise your technical expertise and collaboration skills. Mention your experience with security standards like PCI DSS and how you have implemented best practices in previous roles.
Showcase Relevant Projects: If you have worked on projects involving database performance tuning, query optimisation, or disaster recovery strategies, be sure to include these in your application. This will demonstrate your practical knowledge and problem-solving abilities.
Highlight Soft Skills: Since the role requires collaboration with developers and DevOps teams, mention any experience you have in working within cross-functional teams. Highlight your communication skills and ability to troubleshoot complex issues in real-time.
How to prepare for a job interview at Fynity
✨Showcase Your Technical Expertise
Be prepared to discuss your hands-on experience with PostgreSQL and Oracle databases. Highlight specific projects where you managed, configured, or optimised these databases, especially in production environments.
✨Demonstrate Migration Experience
Since the role involves migrating databases from Oracle to PostgreSQL, be ready to share detailed examples of past migrations you've handled. Discuss the challenges you faced and how you overcame them.
✨Understand Security Standards
Familiarise yourself with PCI DSS and other regulatory requirements relevant to database security. Be prepared to explain how you've implemented security best practices in previous roles, including user management and encryption.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving skills. Think about complex database issues you've resolved in real-time and how you approached monitoring and management processes.