Talent.com
Database Administrator, Princial

Database Administrator, Princial

YourCauseCharleston, South Carolina, US
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

We are seeking an experienced SQL Server Database Administrator (DBA) who possesses a strong background in On-Premises SQL administration, PowerShell automation, Azure Infrastructure as a Service (IaaS), and cloud migration to join our team. As a Principal SQL Server DBA, you will play a crucial role in managing and maintaining our organization's SQL Server databases for our various products and services, ensuring their optimal performance, security, and availability. You will be a thought leader who will influence key stakeholders in adopting industry best practices, bring innovative ideas and be a subject matter expert.

What you’ll be doing :

  • Database Management : Install, configure, and upgrade SQL Server instances (on-premises and Azure IaaS); create and maintain database objects; monitor and optimize performance; implement security; perform backups and disaster recovery; troubleshoot issues; maintain documentation.
  • Cloud Migration : Develop and execute cloud migration strategies; assess and determine migration approaches; plan and coordinate migration processes; ensure smooth migration with minimal downtime; validate and test migrated databases.
  • Azure Integration : Deploy and manage SQL Server databases in Azure IaaS; utilize Azure features for data storage and integration; implement and manage Azure SQL Database features; monitor and optimize performance.
  • Automation : Develop PowerShell scripts for database administration tasks; use PowerShell to interact with SQL Server and Azure resources; schedule PowerShell jobs for recurring tasks.
  • Performance Optimization and Troubleshooting : Optimize query performance and server configuration; monitor and analyze database performance; resolve incidents; provide on-call support during critical windows.
  • Technical Leadership : Mentor and coach team members; lead design and implementation of programs; represent the team in technical discussions; influence technical roadmap and strategy for SQL Server infrastructure.

What we’ll want you to have :

  • Proven experience (minimum 8+ years) as a SQL Server Database Administrator, with expertise in On-premises SQL, PowerShell automation, Azure IaaS, and cloud migration.
  • Strong knowledge of SQL Server database administration, including installation, configuration, backup and recovery, security, and performance tuning.
  • Experience with Azure SQL Database and Azure SQL Managed Instance in an Azure IaaS environment.
  • Strong knowledge and understanding of SDLC, CI / CD practices
  • Highly proficient in Python, PowerShell or C# for automation and scripting tasks
  • Extensive experience in T-SQL and SQL
  • Experience in database engineering / software engineering.
  • Experience in technical leadership of small, focused teams to deliver projects.
  • Experience using tools like SQL Sentry, Azure monitors etc. to monitor performance.
  • Understanding of database performance monitoring and tuning techniques.
  • Experience with Azure Infrastructure as a Service (IaaS) and managing SQL Server databases on Azure virtual machines.
  • Proven track record of successful cloud migration projects, including assessing, planning, and executing migrations from on-premises to the cloud.
  • Excellent problem-solving skills, big picture thinking and ability to troubleshoot complex database issues.
  • Effective communication and collaboration skills to work effectively with cross-functional teams.
  • Able to work flexible hours as required by business priorities
  • Able to deliver work that meets quality, security and operability standards.
    • serp_jobs.job_alerts.create_a_job

    Database Administrator • Charleston, South Carolina, US