At a Glance
- Tasks: Manage and optimise OLTP and OLAP servers while ensuring data integrity and security.
- Company: Join a dynamic team focused on innovative database solutions and client engagement.
- Benefits: Enjoy flexible working options, competitive salary, and opportunities for professional growth.
- Why this job: Be part of a collaborative environment that values creativity and problem-solving skills.
- Qualifications: 5+ years in SQL development, strong PL/SQL skills, and a Computer Science degree required.
- Other info: Ideal for those who thrive on challenges and enjoy working with complex systems.
The predicted salary is between 36000 - 60000 ÂŁ per year.
Manage company OLTP and OLAP servers. Responsibilities include maintaining the current database systems, supporting the design and implementation of changes to the databases, establishing policies and procedures pertaining to the management, security, maintenance, and use of the database management systems. The successful applicant will be involved in managing client enquiries and face-to-face client activities.
Main Tasks and Accountabilities:
- Data Insight / Data Mining
- Recoverability - Creating and testing Backups
- Integrity – Verify data integrity
- Security - Defining and/or implementing access controls to the data
- Updates and upgrades
- Availability - Ensuring maximum uptime
- Performance - Ensuring maximum performance given budgetary constraints
- Development and testing support - Assist programmers to efficiently utilise the database
Experience/Knowledge/Qualification required:
- Over 5 years of professional experience developing SQL software
- Advanced PL/SQL or similar
- Good experience SQL skills (experience with PostgreSQL / Greenplum is a plus)
- AWS (EC2, RDS, CloudWatch…)
- Linux (shell, crons…), Ansible / Terraform, replication, pgWatch
- Python is a plus
- Computer Science degree or related
Character and Personal Qualities:
- Enjoy working in a team
- Willingness to accept challenges
- Ability and desire to work with complex, integrated solutions
- Good problem solving skills with attention to details
- “Think outside the box” & “Can do” attitude
- Ability to work independently and with limited oversight
Experienced DBA/SQL Developer employer: TN United Kingdom
Contact Detail:
TN United Kingdom Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Experienced DBA/SQL Developer
✨Tip Number 1
Familiarise yourself with the specific database technologies mentioned in the job description, such as PostgreSQL and AWS services. Having hands-on experience or projects that showcase your skills in these areas can set you apart from other candidates.
✨Tip Number 2
Network with current or former employees of StudySmarter on platforms like LinkedIn. Engaging with them can provide insights into the company culture and expectations, which can be invaluable during interviews.
✨Tip Number 3
Prepare to discuss your problem-solving skills and how you've tackled complex database issues in the past. Be ready to share specific examples that demonstrate your ability to think outside the box and work independently.
✨Tip Number 4
Showcase your teamwork abilities by preparing examples of successful collaborations with developers or other teams. Highlighting your willingness to accept challenges and contribute to integrated solutions will resonate well with our hiring team.
We think you need these skills to ace Experienced DBA/SQL Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your relevant experience in SQL development and database management. Emphasise your skills in PL/SQL, PostgreSQL, and any experience with AWS or Linux, as these are crucial for the role.
Craft a Strong Cover Letter: Write a cover letter that showcases your passion for database management and your problem-solving skills. Mention specific projects where you've successfully implemented changes or improved database performance.
Highlight Relevant Experience: In your application, focus on your over 5 years of professional experience. Provide examples of how you've managed OLTP and OLAP servers, ensuring data integrity and security, as well as your experience with backups and recoverability.
Showcase Teamwork and Problem-Solving Skills: Since the role involves client interactions and teamwork, include examples that demonstrate your ability to work collaboratively and tackle complex challenges. Highlight any instances where you’ve had to think outside the box to find solutions.
How to prepare for a job interview at TN United Kingdom
✨Showcase Your Technical Skills
Be prepared to discuss your experience with SQL, PL/SQL, and any relevant database management systems. Highlight specific projects where you've successfully implemented changes or optimised performance, especially if you've worked with PostgreSQL or AWS.
✨Demonstrate Problem-Solving Abilities
Expect questions that assess your problem-solving skills. Prepare examples of challenges you've faced in previous roles, particularly those involving data integrity or security, and explain how you approached and resolved them.
✨Emphasise Team Collaboration
Since the role involves managing client enquiries and working closely with programmers, be ready to discuss your experience in team settings. Share examples of how you've effectively collaborated with others to achieve common goals.
✨Prepare for Scenario-Based Questions
You might be asked to solve hypothetical scenarios related to database management, such as ensuring maximum uptime or creating backups. Practice articulating your thought process and the steps you would take to address these situations.