Drag

SQL DBA

Location : ,

Job Description

SQL Database Administrator – Local Candidates only

 

C2H 

Years of experience: 3-5 3-5 years of experience as a SQL Server Database Administrator, preferably in a high-traffic web environment.

Core Duties and Responsibilities:

  • Manage and maintain SQL Server and MongoDB database systems, ensuring high performance, availability, and security in a clustered database environment.
  • Deploy, configure, and manage SQL Server and MongoDB databases in cloud environments (e.g., Azure, AWS, Google Cloud).
  • Monitor database performance and proactively tune and optimize SQL queries, MongoDB operations, and cloud database instances.
  • Implement and maintain database backup and disaster recovery solutions in the cloud.
  • Collaborate with developers, system administrators, and other stakeholders to gather and review requirements and create functional specifications.
  • Ensure compliance with cloud security best practices and standards.
  • Troubleshoot and resolve database-related issues in cloud and on-premises environments.
  • Create and maintain database documentation, including data models, schema designs, and system configurations.
  • Stay current with industry trends and best practices in database administration, cloud technologies, and DevOps practices.
  • Self-motivated, independent, detailed oriented team player.
  • Performs on-call duties and system implementations and upgrades that may occur after normal business hours and weekends as required to minimize business impact.
  • Performs a variety of tasks. A certain degree of creativity and latitude is required.

 

Position Requirements:

  • Master’s degree in computer science – Preferred
  • Understanding of Marketing Company & Data.
  • Certifications and/or significant experience as a DBA.
  • 3-5 years of experience as a SQL Server Database Administrator, preferably in a high-traffic web environment.
  • Strong knowledge of SQL Server database administration, including installation, configuration, performance tuning, and troubleshooting.
  • Experience working on 24x7 environments oriented towards a zero-downtime target.
  • Experience with MongoDB administration, including installation, configuration, and maintenance.
  • Experience with cloud platforms such as Azure, AWS, or Google Cloud.
  • Familiarity with cloud database services (e.g., Azure SQL Database, Amazon RDS for SQL Server, MongoDB Atlas).
  • Proficiency with SQL server SSRS reporting.
  • Expert level knowledge of ETL process using SSIS and other toolsets.
  • Expert in TSQL, Star Schema and Data Modelling.
  • Proficiency with storage and capacity planning.
  • Solid understanding of database backup and recovery strategies in cloud environments.
  • Excellent problem-solving and communication skills.
  • Ability to work independently and as part of a team in a fast-paced environment.