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
Job Identification: 137827_2
Locations: 8th Floor, Block 3, Hyderabad, Telangana, 500019, IN
Work from Anywhere: Yes
Minimum Experience (In Years): 6
Maximum Experience (In Years): 12