DatabaseAdministrator

Saragoça da Matta & Silveiro de Barros - Sociedade de Advogados, R.L.; Leeds; On-site; GBP 65,000 - 100,000; Full time

Job summary

DLA Piper is seeking a Database Administrator Engineer to maintain secure, scalable cloud-based databases in a global legal environment. You will implement backups, security controls, and design databases to support enterprise applications and analytics.

The role involves proactive monitoring, performance tuning, and collaboration with cross-functional teams to ensure reliability, resilience and cost efficiency of our data platforms.

Qualifications

• 5+ years of experience in database administration, preferably in a cloud environment.
• Proficiency in cloud platforms (AWS, Azure, Google Cloud).
• Strong SQL, Python and database management tool skills.
• Experience with SecDevOps/CloudOps practices to build and operate cloud platforms.

Responsibilities

• Implement and manage backup procedures to safeguard data and ensure recoverability.
• Implement robust database security measures including access controls, encryption and monitoring.
• Design and structure databases with schemas, tables, indexes to meet application needs.
• Collaborate with developers to support applications and reporting requirements.
• Monitor database performance and tune queries, indexes, and resources to optimise reliability.

Skills

Cloud platforms (AWS, Azure, Google)

SQL

Python

Database management tools

SecDevOps / CloudOps practices

Windows & Linux command line

Database design

Database management systems

Performance tuning & monitoring

Tools

SQL tooling

Job description

The platform is a set of technologies, tools, and services that enable others to build on top of it.

The Database Administrator Engineer (DBA) is responsible for the on-going deployment, management and maintenance of development and production environments within cloud native infrastructure.

Working within the Platform Team, alongside colleagues from across complimentary Platforms and Products lines, as well as Enterprise Architecture, Compliance, Information Security, Customer IT, the Senior Platform Engineer drives quality and repeatability into their work through a mixture of SecDevOps methodologies and Reliability Engineering.

Create consistent, automated environments across all tiers, proactively test and tune all aspects of the infrastructure, streamline CI/CD processes, monitor and respond to system alerts and continually work to optimise the performance, security, reliability and cost management elements of our systems.

Main duties and responsibilities

The Database Administrator Engineer is pivotal in ensuring the efficient, secure, and reliable operation of an organization's databases. The scope of their responsibilities is extensive and involves a variety of tasks aimed at maintaining the integrity and performance of database systems.

Database Backup

• Implement and manage comprehensive backup procedures to safeguard against data loss. Regular backups are essential for data recovery in case of hardware failures, data corruption, or other disasters


• Verify the integrity of backups and periodically test restore processes to ensure they can be executed smoothly when needed

Database Security

• Implement robust security measures to protect databases from unauthorized access, breaches, and other threats. This includes setting up firewalls, encryption, and access controls


• Continuously monitor for security vulnerabilities and apply necessary patches and updates to maintain a secure environment

Design

• Design and structure databases to efficiently store, retrieve, and manage data. This involves creating schemas, tables, indexes, and other database objects that meet the organization’s needs


• Collaborate with developers and data analysts to design databases that support the organization's applications and reporting requirements


• Ensure designs are maintained in conjunction with Design Engineering standards and practices

Monitor Database Performance

• Continuously monitor database performance to identify and resolve issues proactively. Performance monitoring tools and scripts help in tracking metrics like query execution times, CPU usage, and disk I/O


• Optimize database operations by tuning SQL queries, adjusting indexes, and configuring hardware resources

Set and Maintain Database Standards

• Establish and enforce database standards and best practices to ensure consistency and reliability across all database environments


• Develop guidelines for database design, development, and maintenance to be followed by the team

About You

You’ll be a technologist at heart, with a passion for learning and an eagerness to share knowledge with others.

Previous experience (5 years minimum) working with large scale cloud infrastructure and services within Azure.

• Technical Skills: Proficiency in cloud platforms (AWS, Azure, Google Cloud), SQL, Python, and database management tools


• Demonstrable experience utilising modern SecDevOps/CloudOps practices and processes to build and operate the cloud platform with prevention, resilience and reliability as core principles


• Experience: 5+ years of experience in database administration, preferably in a cloud environment


• Excellent communication abilities


• Excellent problem-solving abilities


• Excellent knowledge of query language(s) for database operations


• Knowledge of Windows and Linux command operations are required


• Adequate database design knowledge


• Knowledge of database management systems is required


• Excellent knowledge of database tools


• Design of services to drive the use of technology to keep services safe and available


• Knowledge of modern industry practices and adption

About Us

We’re a global law firm helping our clients achieve their goals wherever they do business. Our pursuit of innovation has transformed our delivery of legal services. With offices in the Americas, Europe, the Middle East, Africa and Asia Pacific, we deliver exceptional outcomes on cross-border projects, critical transactions and high-stakes disputes.

At DLA Piper, we understand that inclusion is not a one-size-fits-all concept. We embrace and celebrate the range of perspectives, backgrounds and experiences that each individual brings to our firm. By fostering a culture that welcomes and appreciates all aspects of our individuality, we ensure that everyone has the opportunity to succeed.

Our commitment to inclusion and positive social impact enables us to provide exceptional service to our clients and communities, while nurturing a unique and inclusive culture for all our people. We welcome the unique contribution that you will bring to our firm and actively encourage applications from all talented people – however your talent is packaged, whatever your background or circumstance and regardless of how you identify.

We are committed to being accessible and accommodating any reasonable adjustments needed throughout the recruitment process to ensure an inclusive experience for all. If you need any support or adjustments, please let us know.

Where local legislation permits, we will conduct relevant pre-engagement screening checks prior to your first day.