At a Glance
- Tasks: Manage and optimise SQL Server, Oracle, and PostgreSQL databases for peak performance.
- Company: Join a forward-thinking tech company focused on innovation and collaboration.
- Benefits: Enjoy competitive pay, flexible working options, and opportunities for professional growth.
- Other info: Dynamic team environment with mentorship opportunities and career advancement.
- Why this job: Be a key player in database management and make a real impact on business success.
- Qualifications: 5+ years of DBA experience with SQL Server, Oracle, and PostgreSQL.
The predicted salary is between 36000 - 60000 £ per year.
The SQL Server, Oracle and PostgreSQL DBA will be a key member of the DBA team, responsible for ensuring the availability, performance, and security of our organization\'s SQL Server, Oracle and PostgreSQL databases. They will work closely with other technical teams and stakeholders to develop and implement database strategies and systems that support our business applications and systems.
Specifically, the Senior DBA will manage installation, configuration, backup and recovery, patching, performance tuning, and capacity planning for our databases, while ensuring that databases and data are secure and have adequate backup and retention mechanisms in place. It will also be expected this professional to develop and use automation through different languages such as PowerShell or Python.
In addition, the Senior DBA will mentor junior team members and provide technical guidance to other teams and stakeholders.
Key Responsibilities
Database Design
- Designs and implements SQL Server, Oracle, and PostgreSQL instances and physical databases in line with business application needs. Assesses proposed changes which impact data storage and usage requirements, ensuring database infrastructure is appropriately updated to accommodate changes without loss of performance or data integrity.
Database administration
- Monitors database performance and activity across SQL Server, Oracle, and PostgreSQL platforms, proactively identifying and investigating problems and issues. Recommends solutions and implements database changes designed to address performance issues. Performs routine configuration, installation, and reconfiguration of database-related products. Automates regular database activity such as backups and test environment provision.
Automation
- Develop code to manage and monitor databases, data pipelines, and related infrastructure programmatically. This includes scripting and automating routine tasks and processes to improve efficiency, reliability, and scalability.
Key Tasks
Key Requirements
- Minimum of 5 years’ experience working with Oracle and PostgreSQL databases as a DBA.
- Minimum of 3 years’ experience as a MS SQL Database Administrator using Microsoft tools.
- Experience with various SQL Server version like 2012, 2014, 2016, 2017 and 2019, Oracle 10g/11g/12c/18c/19c, and PostgreSQL (latest supported versions).
- Expertise in database administration tasks such as backups, restores, and recovery models, database mirroring, replication, log shipping, etc.
- Experience in performance tuning, query optimisation, and troubleshooting performance issues in SQL Server, Oracle, and PostgreSQL databases.
- Knowledge of high availability and disaster recovery solutions for SQL Server, Oracle, and PostgreSQL.
- Experience in designing and implementing security policies and procedures for SQL Server, Oracle, and PostgreSQL databases.
- Experience with database migration and upgrade projects, including assessment, planning, and execution of migrations across SQL Server, Oracle, and PostgreSQL platforms.
- Experience with automation tools such as PowerShell and Python for managing and monitoring SQL Server, Oracle, and PostgreSQL databases.
Database Administrator employer: Utmost International
As a leading employer in the tech industry, we offer our Database Administrators a dynamic work environment that fosters innovation and collaboration. Our commitment to employee growth is evident through continuous training opportunities and mentorship programs, ensuring that you can advance your career while working with cutting-edge technologies. Located in a vibrant area, our company promotes a healthy work-life balance and provides competitive benefits, making it an ideal place for professionals seeking meaningful and rewarding employment.
StudySmarter Expert Advice🤫
We think this is how you could land Database Administrator
✨Tip Number 1
Network like a pro! Get out there and connect with folks in the industry. Attend meetups, webinars, or even local tech events. You never know who might have the inside scoop on job openings or can refer you to someone looking for a DBA.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your database projects, automation scripts, or any performance tuning you've done. This gives potential employers a tangible look at what you can bring to the table.
✨Tip Number 3
Don’t just apply blindly! Tailor your approach for each role. Research the company and mention how your experience with SQL Server, Oracle, and PostgreSQL aligns with their needs. It shows you’re genuinely interested and not just sending out mass applications.
✨Tip Number 4
Apply through our website! We’ve got a streamlined process that makes it easy for you to showcase your skills and experience. Plus, it helps us keep track of your application better, so don’t miss out!
We think you need these skills to ace Database Administrator
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Database Administrator role. Highlight your experience with SQL Server, Oracle, and PostgreSQL, and don’t forget to mention any automation skills you have with PowerShell or Python. We want to see how your background fits our needs!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about database administration and how your skills can help us at StudySmarter. Be specific about your achievements and how they relate to the responsibilities outlined in the job description.
Showcase Your Problem-Solving Skills:In your application, give examples of how you've tackled performance issues or implemented successful database strategies in the past. We love seeing candidates who can think critically and come up with effective solutions!
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining the StudySmarter team!
How to prepare for a job interview at Utmost International
✨Know Your Databases Inside Out
Make sure you brush up on your SQL Server, Oracle, and PostgreSQL knowledge. Be ready to discuss your experience with different versions and specific tasks like performance tuning and backup strategies. The more you can demonstrate your expertise, the better!
✨Show Off Your Automation Skills
Since automation is key for this role, prepare to talk about your experience with PowerShell and Python. Bring examples of scripts you've written or processes you've automated. This will show that you can improve efficiency and reliability in database management.
✨Prepare for Scenario-Based Questions
Expect questions that ask how you would handle specific database issues or scenarios. Think through common problems like performance bottlenecks or security breaches, and be ready to explain your thought process and solutions clearly.
✨Highlight Your Mentoring Experience
As a Senior DBA, you'll likely be mentoring junior team members. Be prepared to share examples of how you've guided others in the past, whether it's through training sessions or one-on-one support. This shows you're not just technically skilled but also a great team player.
