Azure Sql Data Base Administrator

• Basic idea on Windows Server platforms , features , functions , OS , Hardware and administration on Windows Server versions 2012 & 2012 R2 , 2016, 2019 , 2022 and 2025.
• IIS for websites and APIs
• Windows services installing, stopping, starting, managing, monitoring
• SSL certificate management and renewals
• Patching Windows and components on a regular basis
• Build new servers with Terraform and Puppet
• Replace older versions of Windows Server to newer images
• Monitoring resources and troubleshooting usage (CPU, memory, disk space, etc)
• Linux mainly used for Elasticsearch system, with some systems used for Rediscache
• Microsoft SQL Server – in addition to database maintenance activities, most of the time spent on SQL server is to investigate or answer customer requests / escalations
• Using SQL Server Management Studio (SSMS)
• Writing and running SQL queries to get and update data
• Query SQL data to check processing (check message processing or indexing step)
• Update the data in the database as needed for customer escalations or daily processes
• Monitor and troubleshoot SQL performance (disk latency, blocked sessions, caching issues, reindex needed, long running sessions, stored procedure issues, and so on)
• Monitor SQL backups that are going to Azure Blob Storage (full backups done once a week, incremental back ups every 15 mins)
• Monitor the SQL Always-On High Availability (HA) cluster (ensure replication in sync, fail over and fail back during maintenances, etc)
• Patching and SQL Server upgrades
• Monitor disk space usage, and add storage as needed (add disks in Azure, add to SQL clusters, add to HA, etc)
• Puppet – desired state configuration tool running on all Windows and Linux servers
• Running Puppet manually for deployments and hotfixes
• Review and update Puppet manifests
• Troubleshoot Puppet failures
• Updates to Puppet manifests for minor changes (use GitLab to create a branch, create a Merge Request, and get the Merge Request reviewed and approved)

• Deployments

• Help deploy quarterly releases or hotfixes (merge approved GitLab Merge Requests and run Puppet, ensure new packages are deployed properly)

• Min 8 to 10 Yrs of SQL DBA on Azure cloud.

• DBA administration on Azure cloud running some of the biggest servers in the enterprise
• Use of all new tools, to administrate the databases to different levels of access, configurations , managing and apply the standards of excellence.
• As a DevOps DBA work with minimally as a system administration.
• Complete idea and working experience on DevOps Tools for the DBA
• As a DBA Devops you are expected to build and maintain a docker container that includes the database, and can handle persistent storage properly. This requires understanding of new suite of tools.
• Docker/Kubernetes/Orchestrator
• Docker Containers
• Work Database servers as docker containers.
• In depth understanding on the docker file and the entrypoint script (likely a shell script).
• Building internal repository for containers.
• Knowledge on functioning database containers, keeping a copy of a container with up-to-date data for developers to spin up.
• In depth knowledge on Kubernetes/Orchestrator and Configuration Management
• In depth knowledge on traditional RDBS models and multi cloud DBA is desirable.
• Multi Job Scheduling with central administration and configuration.
• Backups on Databases.
• Future-Looking with AI injection into DBA operations on Azure cloud

  Role & responsibilities

Preferred candidate profile