Please mention DailyRemote when applying
AI Summary
Manage and maintain Azure-based SQL databases and Windows/Linux server environments using DevOps tools. Responsible for server builds, patching, performance monitoring, and leading a team of 10 members in an enterprise SRE/DevOps capacity.
- 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
Automatically Apply to the Best Remote Jobs
Stop the endless job search. Our AI finds and applies to the best jobs for you.
