Cloud DevOps -Operations Support-Puppet

Job description

- 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 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