Scope:
The SQL Server Database Administrator will be responsible for managing and optimizing enterprise-scale SQL Server environments, with a strong focus on Azure SQL Database. The role encompasses end-to-end database administration, including design, security, performance optimization, and support of large-scale production workloads in the cloud. The candidate will play a key role in strategic planning and architectural decision-making while driving automation, modernization, and compliance initiatives. Additionally, this role involves providing leadership, mentoring, and guidance to the DBA team to establish and maintain best practices across hybrid database platforms.
Our current technical environment:
• Database Design & Architecture (Advanced): Expertise in designing robust and scalable database solutions that align with business needs.
• Performance Tuning & Optimization (Advanced): Skilled in analyzing and optimizing queries and database structures for peak performance.
• Security Management (Advanced): Proficient in implementing security protocols to protect data integrity and privacy.
• Backup & Recovery (Advanced): Experienced in developing and executing reliable backup and recovery strategies.
• High Availability & Disaster Recovery (Advanced): Capable of ensuring database availability through solutions like Always On and replication.
• Azure SQL Management (Advanced): Competent in managing Azure SQL Databases and leveraging Azure services for enhanced operations.
• Automation & Scripting (Proficient): Utilizes PowerShell and T-SQL to automate routine database tasks and processes.
• Monitoring & Troubleshooting (Advanced): Adept at setting up monitoring systems and resolving database issues efficiently.
Tools & Technologies:
• Azure Portal & Azure CLI (Proficient): Navigates and manages Azure resources effectively.
• PowerShell & T-SQL (Proficient): Scripts for automation and advanced database operations.
What you’ll do:
• Lead the architecture, design, and implementation of SQL Server environments (on-premises and Azure Cloud).
• Design and implement scalable and cost-optimized Azure SQL Database solutions, including elastic pools and serverless models.
• Own and enforce database governance, standards, and best practices across the organization.
• Perform capacity planning, performance tuning, and cost optimization for Azure SQL workloads.
• Lead and oversee HA/DR implementations (Always On, Clustering, Log Shipping, Replication, cloud-based DR).
• Define and implement database security, auditing, and compliance.
• Provide expert-level performance tuning and query optimization for mission-critical systems.
• Lead migration projects from on-prem SQL Server to Azure SQL Database (PaaS).
• Automate complex administrative and monitoring tasks using T-SQL, PowerShell, or DevOps pipelines.
• Manage backup/restore strategies and disaster recovery drills for enterprise databases.
• Collaborate with architects, application teams, and infrastructure leaders to align database solutions with business needs.
• Mentor, coach, and provide technical guidance to mid-level and junior DBAs.
• Act as the primary escalation point for critical production incidents.
• Stay ahead of industry trends and recommend emerging technologies for continuous improvement.
What we are looking for:
• Bachelor’s degree in IT/Computer Science/Electronics (preferred) or equivalent diploma.
• 7 - 10 years of progressive experience as a SQL Server DBA in enterprise environments including OnPrem and Azure SQL.
• Deep expertise in SQL Server 2012/2014/2016/2017/2019/2022 administration and strong knowledge of Azure SQL Database features: DTU/vCore models, Elastic Pools, Serverless, Hyperscale.
• Experience with Azure SQL HA/DR options (Geo-Replication, Failover Groups).
• Proven experience with large-scale database environments (VLDBs, high concurrency systems).
• Proficiency in monitoring, alerting, and troubleshooting using Azure Monitor, Log Analytics, and Query Store.
• Advanced knowledge of HA/DR architectures and performance tuning at scale.
• Proven problem-solving and decision-making abilities, with a focus on driving results and delivering high-quality software solutions.
• Troubleshooting – Performance and other issues. Ensure high levels of performance, availability, sustainability and security
• Strong experience in High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Refine and automate regular processes, track issues, and document changes
• Planning, Preparation and execution of upgrade and migrations
• Performing prod and non-production restores/refreshes both Private Cloud and Azure
• Managing capacity planning – Disk and Compute
• Experience in GitHub and repositories
• Passion for technology, innovation, and staying up to date with industry trends and advancements.
• Team player, fast learner, work in a fasted paced environment and share knowledge.
• Hands-on experience with database monitoring, profiling, and performance tools (e.g., Redgate, SQLSentry, SolarWinds, Idera etc).
• Strong proficiency in scripting and automation (T-SQL, PowerShell, CI/CD tools).
• Expertise in database security, encryption, auditing, and compliance.
• Experience managing end-to-end migration projects (on-prem ↔ cloud).
• Solid understanding of Windows Server, storage, networking, and virtualization technologies.
• Strong communication, stakeholder management, and leadership skills.
• This role involves rotational shifts, including night shifts, to provide 24/7 application support.
• Flexibility to work weekends and public holidays as per shift schedule.
• Ability to handle responsibilities independently during off-hours. (ID103)
Our Values
If you want to know the heart of a company, take a look at their values. Ours unite us. They are what drive our success – and the success of our customers. Does your heart beat like ours? Find out here: Core Values
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.
Top Skills
What We Do
Blue Yonder is the world leader in digital supply chain and omni-channel commerce fulfillment. Our intelligent, end-to-end platform enables retailers, manufacturers and logistics providers to seamlessly predict, pivot and fulfill customer demand. With Blue Yonder, you can make more automated, profitable business decisions that deliver greater growth and re-imagined customer experiences. Blue Yonder - Fulfill your Potential
Blue Yonder’s tagline “Fulfill Your Potential” reflects the company’s mission to empower every organization and person on the planet to fulfill their potential. Each day, our global teams of associates and business partners work together to accelerate global economic growth, increase sustainability and prosperity with a Sonoran Spirit.
