Database Administrator
Remote
London, United Kingdom
Freelance
13-02-2025
Job Specifications
Job Role : Database Administrator
Experience : 10 - 12 Years
Hybrid Mode
Location : London OR Edinburgh
Contract Role
Job Overview:
We are seeking an experienced Database Administrator (DBA) with strong knowledge of SQL Server, Teradata, Snowflake, and AWS to ensure the stability, performance, and security of our data infrastructure. In this role, you will be responsible for managing databases, optimizing queries, performing backups, and ensuring high availability across various systems. You will collaborate with cross-functional teams to ensure data integrity, implement best practices, and manage cloud-based database solutions effectively.
Responsibilities:
· Administer and maintain SQL Server, Teradata and Snowflake databases, ensuring optimal performance, availability, and security.
· Implement database backups, recovery strategies, and data protection practices.
· Monitor and optimize database performance, including query optimization, indexing, disk usage, data retention policies, and troubleshooting.
· Collaborate with data engineers and other stakeholders to design and implement database solutions in AWS environments.
· Oversee database migration projects, including moving data from on-premise systems to Teradata, Snowflake and AWS cloud environments.
· Ensure compliance with security standards, managing access controls, and implementing best practices for data encryption.
· Create and maintain scripts for automation of routine DBA tasks using SQL, AWS tools, and other relevant technologies.
· Troubleshoot and resolve database issues in a timely manner to minimize downtime.
· Develop and maintain documentation for database architecture, performance metrics, and troubleshooting procedures.
· Work closely with development teams to implement changes and monitor production database environments.
Required Skills and Qualifications:
· Proven experience as a Database Administrator (DBA) with expertise in SQL Server (T-SQL, Stored Procedures, Indexing, Query Optimization).
· Experience with Snowflake cloud data platform, including database administration, data loading, and performance tuning.
· Strong knowledge of AWS cloud services, including EMR, RDS Postgres, Athena, S3, and IAM.
· Experience with database backups, disaster recovery, and high-availability setups.
· Proficiency in writing and optimizing SQL queries.
· Familiarity with database monitoring tools and performance tuning.
· Experience in data migration, including moving data from on-premise databases to cloud platforms.
· Knowledge of security best practices for cloud-based and on-premise databases.
· Strong problem-solving, analytical, and troubleshooting skills.
Excellent communication skills and ability to collaborate with cross-functional teams
About the Company
N Consulting is a global professional services company with leading capabilities in data analytics, digital, cloud and security. We come with experience and specialized skills across industries segments, we offer Consulting , IT Services, Technology and Operations services across the globe. Our quality of people is key to our success who deliver on time, serving clients across America, Europe and Asia. We embrace the power of change to create value and sustainable communities. Visit us at www.n-cons.co.uk. Know more
Related Jobs
- Company Name
- Vallum Oy
- Job Title
- Data Engineer - Power Platform
- Job Description
- The role is open for various locations London, Manchester, Birmingham and Newcastle Upon Tyne 5+ years of experience in data engineering, ETL development, and workflow automation. Expertise in Power Platform (Power Automate, Power BI, Power Apps) for automation and data processing. Strong experience with SQL, Python, or Power Query (M language) for data transformation. Familiarity with cloud platforms (Azure, AWS, or GCP) and services like Azure Data Factory, Azure SQL, Dataverse, and Databricks. Experience integrating APIs, web services, and third-party connectors into automated workflows. Knowledge of data governance, security, and compliance best practices. Strong problem-solving, analytical, and communication skills.
- Company Name
- Certain Advantage
- Job Title
- Data Engineer
- Job Description
- Analytics Engineer Certain Advantage are hiring for an Analytics Engineer based in London This role is on an initial 6-month contract basis and is hybrid The Company We’re working with a business that’s on a strong growth trajectory, backed by ambitious plans. With a commitment to innovation and excellence, they are poised to make a significant impact in the industry. The role As a Senior Analytics engineer you are a subject matter expert, who designs & builds analytics solutions and mentors junior engineers. You are also the key person to convert the Vison and Data and Analytics Strategies into IT solutions and deliver them. Design, build and implement POCs, prototypes and full-fledged UX solutions and strategies Communicate with key stakeholders to drive clarification of requirements and to promote UX designs and solutions Support the design, e.g., by analysing user journeys and drive towards simplification and automation Enable high quality & compelling story telling through creation of strong, simple to understand data visualizations Document technical solution design and strategy documentation Run quality assessments of counterparts’ design Coach and develop other UX analysts Adhere to the organisations Release and Change process Pursue knowledge enhancement The individual: Expert knowledge in QlikSense & Qlik Cloud Analytics to deliver complex, fast-moving datasets to high value trading teams. Expert knowledge of authoring/troubleshooting SQL/Azure/Databricks queries Expert knowledge and application of general and tool specific connectivity, data modeling, source data procurement strategies (Database, import/cached), security configuration, performance tuning, usage of right visuals, layout optimization, mobility, scripting and integrating advanced analytics Knowledge of upcoming trends in tools and technology Does this sound like your next career move? Apply today. Working with Certain Advantage We go the extra mile to find the best people for the job. If you’re hunting for a role where you can make an impact and grow your career, we’ll work with you to find it. We work with businesses across the UK to find the best people in Finance, Marketing, IT and Engineering. If this job isn’t for you, head to certainadvantage.co.uk and register for job alerts and career guidance tips.
- Company Name
- Stott and May
- Job Title
- Data Engineer | £450-£550pd | Outside IR35 | HealthTech
- Job Description
- Data Engineer | £450-£550 per day | Outside IR35 | 6 months | HealthTech Role: Data Engineer Day Rate: £450-£550 per day Type: Contract Location: Remote IR35 status: Outside My client in the HealthTech sector are looking for a Data Engineer on an initial 6-month contract with a view to extend. This will be helping build and scale their data infrastructure working fully remote. The day rate on offer is £450-£550 per day (Outside IR35). Key Skills: - Python - SQL - Snowflake - Azure/AWS - ETL - Data Warehousing - Previous HealthTech experience (desirable) If you are interested in the Data Engineer position, please apply with an up to date CV as soon as possible. Data Engineer | £450-£550 per day | Outside IR35 | 6 months | HealthTech
- Company Name
- Lloyds Banking Group
- Job Title
- SAP Data Architect
- Job Description
- Job Title: SAP Data Architect Location: Warwick (2 days a week on site) Remuneration: Up to £800 per day Contract Details: 12 Month Contract + Extensions Responsibilities: Dive into complex datasets to uncover trends, patterns, and actionable insights. Capture and maintain robust data models that align with business needs. Investigate and resolve data-related issues and discrepancies like a pro. Map data flows across diverse systems and processes with precision. Contribute to the creation and execution of analytics and reporting strategies. Prepare the data architecture for the exciting evolution of AI integration. Collaborate seamlessly with cross-functional teams to ensure data integrity and consistency. Provide technical guidance and support to fellow team members, fostering a collaborative environment. Qualifications and Experience: Proven experience as an SAP Data Architect or in a similar role. Extensive experience with S/4 HANA is a must! Strong background in utilities, finance, procurement, or HR preferred. Proficiency in data modelling, data analysis, and data mapping. Experience with analytics and reporting tools is essential. Knowledge of AI and machine learning concepts? That's a bonus! Excellent problem-solving skills and an eye for detail. Strong communication and collaboration skills to work effectively in a team. Preferred Skills: Experience with SAP BW/4HANA, SAP Analytics Cloud, or similar tools is advantageous. Familiarity with data governance and data quality management practises. Understanding of cloud-based data solutions and architectures will set you apart! Join our client's dynamic team and make a difference in the world of data! If you're a passionate SAP Data Architect ready to tackle exciting challenges in the utilities, finance, procurement, or HR sectors, we want to hear from you! Apply today and step into a role where your expertise will shine and your contributions will be valued! Adecco is a disability-confident employer. It is important to us that we run an inclusive and accessible recruitment process to support candidates of all backgrounds and all abilities to apply. Adecco is committed to building a supportive environment for you to explore the next steps in your career. If you require reasonable adjustments at any stage, please let us know and we will be happy to support you.