SRE - SQL Server DBA

1. Database Administration (DBA) Skills
Relational Databases: MySQL, PostgreSQL, Oracle, MS SQL Server. Database Backup & Recovery: Tools and strategies for database backupsand disaster recovery. Performance Tuning: Query optimization, indexing strategies, and databaseperformance troubleshooting. Database Security: User management, roles, access control, and auditing.2. Infrastructure as a Service Knowledge Infrastructure as Code (IaC): Terraform, CloudFormation, Kubernetes. Kubernetes & Containers: Good Knowledge and Understanding ofKubernetes and usage of Containers. Observability Tools: ELK stack (Elasticsearch, Logstash, Kibana) Database Migration: Migrating databases across different platforms or cloudenvironments. Infrastructure Scaling: Vertical and horizontal scaling techniques in cloudenvironments.3. SRE Principles and knowledge (Site Reliability Engineering) Strong hands-on experience in AWS and Azure cloud, and a fairunderstanding of Google Cloud would be required. Experience in handling APIs, troubleshooting API calls, and ensuringseamless integration and performance. Incident Management: Handling database outages, incident response, andon-call rotations. Monitoring and Alerting: Tools like Prometheus, Grafana, Datadog,CloudWatch , suggest proactive monitoring for the application stack Understanding on core SRE principles: SLA, SLI, SLO, Error budgets etc Disaster Recovery Planning: Ensuring high availability (HA) and disasterrecovery (DR) solutions. Performance Optimisation :- Track latency, slow performance , highutilisation issues and recommend optimisation as required.4. Scripting and Automation Scripting Languages: Python, Shell scripting, Bash, PowerShell. Automation Tools: Ansible, Puppet, Chef. Infrastructure Automation: Automating database deployment, patching, andscaling.

5. Networking and Infrastructure
Networking Basics: TCP/IP, DNS, Firewall, Load Balancers.
Database Connectivity: Connection pooling, failover strategies, and multi-region deployment. Storage and Disk Management: Understanding IOPS, latency, andthroughput. Infrastructure: Familiarity with AWS services like EC2, S3, VPC, SecurityGroups, Private and Public subnets,IAM, CloudWatch, Cloudtrail etc andAzure services like Virtual Machines, Azure functions, Virtual Network,Resource Manager, etc.6. OS SkillsExpertise in Linux OS ( RHEL, Ubuntu, Centos) Understanding of file systems (ext4, XFS, etc.), permissions, and ownerships Knowledge of process monitoring, management, and troubleshooting Proficiency with tools like top, htop, vmstat, iostat, sar, and dstat to monitorCPU, memory, disk I/O, and network usage. Ability to analyze system logs (/var/log/, journalctl, dmesg) for troubleshooting. Understanding of resource limits (CPU, memory, disk, network) and how theyimpact database performance. Knowledge of partitioning tools (fdisk, parted) and file system management(mkfs, mount, umount). Understanding of RAID configurations and Logical Volume Management(LVM) for storage scalability.

7. Troubleshooting and Debugging
Log Analysis: Reading and analysing database and system logs.
Root Cause Analysis (RCA): Performing in-depth analysis after majorincidents and sharing RCA with customers. Query Performance: Analysing slow queries, deadlocks, and resourcecontention.8 . Soft Skills Communication Skills: Clear written and verbal communication with internaland external stakeholders. Problem-Solving: Ability to prioritise, troubleshoot critical issues and bringthem to closure.. Collaboration: Working closely with DevOps, Infrastructure, and Engineeringteams.