SQL Database Administrator

Profile 29; Chigwell; On-site; GBP 60,000 - 90,000; Full time

Job summary

An established industry player is looking for a talented SQL Database Administrator to join their dynamic team. This role involves designing, implementing, and optimizing SQL databases to ensure high performance and security. You will work closely with cloud database solutions and utilize advanced tools to monitor and enhance database efficiency. If you are passionate about data management and thrive in a collaborative environment, this opportunity is perfect for you. Join a company that values customer satisfaction and employee growth, and contribute to innovative projects that make a difference.

Benefits

Pension Scheme

Health Insurance

Free Onsite Gym

Free Parking

Qualifications

• Proficiency in SQL database design and management.
• Experience with Redgate SQL Monitor and cloud solutions.

Responsibilities

• Develop and implement database schemas and tables.
• Optimize SQL queries and perform database maintenance.
• Manage cloud database solutions and automate tasks.

Skills

SQL Database Design

Query Development

Database Maintenance

Database Security

Performance Tuning

Scripting (Python, PowerShell, Bash)

Cloud Database Management

Tools

Redgate SQL Monitor

SQL Azure

Job description

Job Description

Job: SQL Database Administrator (Debden IG10)

• Mon-Fri onsite in Debden IG10

• Offices a 5 mins walk from Debden tube station (Central line)

• Salary to £90k + pension scheme + health

• Free onsite gym & parking

Please only apply if you are able to work from their Debden offices Monday-Friday. Hybrid or remote working is not available.

Company

Established in 2009 and regulated by the FCA, this multi-award-winning finance & credit company has a proven track record for customer and employee satisfaction. With a Trustpilot rating of 4.8/5 and over 33,500 combined online reviews, they pride themselves on their customer service and their duty as a responsible lender.

Job

They are seeking a skilled SQL Database Specialist to design, implement, maintain, and optimize SQL databases for performance, security, and reliability. Their ideal candidate will possess expertise in query development, database maintenance, security measures, and cloud database management, and will contribute to database migration, automation, and capacity planning projects.

Responsibilities

Database Design and Implementation: Develop database schemas, tables, views, and indexes to support application requirements.

Query Development and Optimization: Create and enhance complex SQL queries, stored procedures, and functions for efficient data manipulation.

Database Maintenance: Perform backups, indexing, and performance tuning to ensure optimal database functionality.

Performance Monitoring: Utilize tools such as Redgate SQL Monitor to identify and resolve bottlenecks.

Troubleshooting: Analyse and resolve database issues such as deadlocks, contention, and slow queries.

Security: Implement measures to safeguard sensitive information and ensure compliance with data protection regulations.

Disaster Recovery: Establish and test backup and recovery plans for business continuity.

Capacity Planning: Monitor storage usage and plan database scaling for future growth.

Training and Support: Share knowledge and best practices with team members and stakeholders.

Cloud Database Management: Manage and optimize solutions like SQL Azure and Azure Managed Instance.

Automation: Use scripting languages to automate routine tasks and improve efficiency.

Standards and Best Practices: Develop and enforce database standards and industry best practices.

Database Migration: Plan and execute database migration projects with minimal downtime.

Report Database: Create a separate report database to remove overhead on production DB.

Qualifications

Proficiency in SQL database design, implementation, and management.

Experience with tools like Redgate SQL Monitor.

Strong knowledge of scripting languages (Python, PowerShell, Bash).

Familiarity with cloud-based database solutions like SQL Azure.

Expertise in database security and disaster recovery planning.

Proven ability to optimize database performance and scalability.

Other Stuff

Please only apply if you are able to work from their Debden offices Monday-Friday. Hybrid or remote working is not available.

NB: for non-UK Citizens: we cannot accept applications from anyone requiring sponsorship (now or in the future) for UK permanent employment status. If you are using a work visa this must allow you to work in the UK unrestricted for at least the next 5 years.

In accordance with GDPR by applying you give Profile 29 consent to use your data for recruitment purposes only (details of Profile 29’s privacy policy can be found at: profile-29 .com/privacy)

Profile 29 recruitment keywords: sql dba sql database administrator redgate python powershell bash azure Loughton Debden essex London