Basic idea on Windows Server platforms, features, functions, OS, Hardware and 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 failuresUpdates 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 4 to 6 Yrs of SQL DBA on Azure cloud. :

- DBA administration on Azure cloud running some of the biggest servers in the enterprise

- As a DevOps DBA work with mínimally 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 current 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

📌 Cloud DevOps-operations Support-puppet (Pune)
🏢 Zensar Technologies
📍 Pune