Senior Technical Architect - Cloud SQL Server

Sr Technical Architect - Cloud - SQL Server, Azure SQL, Troubleshooting, SolarWinds, Powershell, Commvault

Scope:

• The Senior Technical SQL Server Architect will be responsible for managing and supporting mission-critical SQL Server database environments in a 24/7 enterprise setup.
• This role requires a strong hands-on DBA who can independently troubleshoot complex production issues, perform performance tuning, automate operational activities, and drive incidents to closure. The person will work closely with application, infrastructure, operations, and customer-facing teams to ensure database availability, stability, performance, and reliability.
• This role is critical to maintaining business continuity, improving operational efficiency, reducing recurring incidents, and ensuring a high-quality customer experience.

​What you will do:

• Own and operate mission-critical Oracle / SQL Server databases in a 24/7 environment.
• Troubleshoot complex issues, tune performance, automate operational tasks, support backup/recovery and HA/DR, communicate with stakeholders, and drive incidents to closure.
• Design, implement, and maintain SQL Server databases to ensure maximum performance, availability, and security.
• Develop and implement database backup and recovery strategies.
• Serve as SME (subject matter expert) for Microsoft SQL Server.
• Monitor database performance and proactively identify and resolve performance issues.
• Troubleshoot and resolve complex database issues, including database corruption and performance problems.
• Perform database tuning and optimization to improve performance and scalability.
• Develop and implement database security policies and procedures.
• Collaborate with other IT teams to ensure database integration with other systems.
• Participate in the planning and implementation of database upgrades and migrations.
• Develop and maintain database documentation and standards.
• Provide guidance and mentorship to junior DBAs.
• Problem management - analyze & fix reported problems, work with other team members in troubleshooting problems.
• Troubleshooting – Performance and other issues.
• Proactive database monitoring for performance and other problems
• Testing Upgrade packages
• Preparing Upgrade packages
• Performing non-prod restores/refreshes.
• Expanding data files
• Managing disk space and capacity planning
• Creating/adjusting SQL Agent Jobs
• Database migrations
• SQL Server installs (cluster and non-cluster) and builds
• Working with cluster systems and Virtual servers
• Creating stored procedures
• Responding and replying to database support tickets and emails
• On-call support – pager rotation, work weekends, evenings
• Team player, fast learner, work in a fasted paced environment, share knowledge.

What we are looking for:

• Bachelor’s degree (STEM preferred) and minimum of 10-13 years of relevant work experience as an Sr. MS SQL DBA 
• Strong understanding of cloud computing technologies; preferable hands-on experience in working with Azure
• Experience in handling customer escalations
• Experience in writing automation scripts, building application dashboards for proactive monitoring using PowerShell, Python scripting or similar technologies, ability to debug and optimize code and automate routine tasks.
• The right candidate should have knowledge of PowerShell, Ansible, Git Actions etc.
• Experience with DevOps methodologies and tools (Git, Jenkins, Docker, Kubernetes)
• Excellent problem-solving and analytical skills
• Strong communication and collaboration skills
• Ability to work independently and as part of a team.
• Strong attention to detail and ability to prioritize tasks effectively.
• Experience with monitoring and logging tools (Zabbix, Splunk, Solarwind).
• Solid understanding of cloud Infrastructure environments, specifically Windows based deployments.
• Excellent SQL skills and ability to write complex queries to pull and analyze data from multiple sources.
• Good understanding of different file formats such as YML, JSON, Parquet.
• Excellent organizational skills, able to take a systematic approach in resolving issues.
• Good communication and coordination skills and able to work efficiently under pressure.

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.

Experience Level

Senior Level