At a Glance
- Tasks: Manage and optimise PostgreSQL and Oracle databases, ensuring high performance 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 your skills in a fast-paced, innovative environment.
- Qualifications: Hands-on experience with PostgreSQL and Oracle, plus AWS services is essential.
- Other info: Immediate consideration for applicants; don't miss out on this opportunity!
The predicted salary is between 72000 - 90000 £ 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.
Database Administrator employer: Fynity
Contact Detail:
Fynity Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Administrator
✨Tip Number 1
Make sure to showcase your hands-on experience with PostgreSQL and Oracle databases during any networking opportunities. Engage in discussions about your past projects, especially those involving migrations to AWS Aurora, as this will highlight your relevant expertise.
✨Tip Number 2
Connect with professionals in the FinTech industry on platforms like LinkedIn. Join groups or forums focused on database management and cloud technologies, where you can share insights and learn from others, which may lead to referrals for positions like the one at StudySmarter.
✨Tip Number 3
Stay updated on the latest trends and best practices in database security and compliance frameworks. This knowledge will not only prepare you for interviews but also demonstrate your commitment to maintaining high standards in your work.
✨Tip Number 4
Consider participating in online workshops or webinars that focus on AWS services and database performance tuning. This will enhance your skills and provide you with valuable connections in the industry, making you a more attractive candidate for the role.
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 PostgreSQL, as this is a key requirement for the role.
Craft a Strong Cover Letter: In your cover letter, emphasise your technical expertise and collaboration skills. Mention your experience with AWS services and how you have implemented security best practices in previous roles. This will show that you understand the importance of compliance and security in a FinTech environment.
Showcase Relevant Projects: If you have worked on projects involving database performance tuning or disaster recovery strategies, be sure to include these in your application. Highlight any experience with infrastructure automation tools like Terraform, as this is desirable for the position.
Proofread Your Application: Before submitting your application, take the time to proofread it for any errors or inconsistencies. A well-presented application reflects your attention to detail, which is crucial for a Database Administrator role.
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 compliance and other regulatory requirements. 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.