Database Administrator (DBA)

Posted 5 days 8 hours ago by N Consulting Limited

Permanent
Not Specified
Other
London, United Kingdom
Job Description

Role: Database Administrator

Work Mode: Hybrid

Contract Role

Location: London OR Edinburgh

Experience: 10 -12 Years

Job Description:

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:

  1. Administer and maintain SQL Server, Teradata and Snowflake databases, ensuring optimal performance, availability, and security.
  2. Implement database backups, recovery strategies, and data protection practices.
  3. Monitor and optimize database performance, including query optimization, indexing, disk usage, data retention policies, and troubleshooting.
  4. Collaborate with data engineers and other stakeholders to design and implement database solutions in AWS environments.
  5. Oversee database migration projects, including moving data from on-premise systems to Teradata, Snowflake and AWS cloud environments.
  6. Ensure compliance with security standards, managing access controls, and implementing best practices for data encryption.
  7. Create and maintain scripts for automation of routine DBA tasks using SQL, AWS tools, and other relevant technologies.
  8. Troubleshoot and resolve database issues in a timely manner to minimize downtime.
  9. Develop and maintain documentation for database architecture, performance metrics, and troubleshooting procedures.
  10. Work closely with development teams to implement changes and monitor production database environments.

Required Skills and Qualifications:

  1. Proven experience as a Database Administrator (DBA) with expertise in SQL Server (T-SQL, Stored Procedures, Indexing, Query Optimization).
  2. Experience with Snowflake cloud data platform, including database administration, data loading, and performance tuning.
  3. Strong knowledge of AWS cloud services, including EMR, RDS Postgres, Athena, S3, and IAM.
  4. Experience with database backups, disaster recovery, and high-availability setups.
  5. Proficiency in writing and optimizing SQL queries.
  6. Familiarity with database monitoring tools and performance tuning.
  7. Experience in data migration, including moving data from on-premise databases to cloud platforms.
  8. Knowledge of security best practices for cloud-based and on-premise databases.
  9. Strong problem-solving, analytical, and troubleshooting skills.
  10. Excellent communication skills and ability to collaborate with cross-functional teams.