[Hiring] Cloud DevOps -Operations Support-Puppet @Zensar

Role Description

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 Redis cache
• 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, etc)
• Monitor SQL backups that are going to Azure Blob Storage (full backups done once a week, incremental backups 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)
• 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

Qualifications

• 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.
• Complete idea and working experience on DevOps Tools for the DBA.

Requirements

• In depth understanding on the docker file and the entrypoint script (likely a shell script).
• In depth knowledge on Kubernetes/Orchestrator and Configuration Management.
• In depth knowledge on traditional RDBS models and multi cloud DBA is desirable.

Benefits

• Future-Looking with AI injection into DBA operations on Azure cloud.