If you interested, So plz share me your CV at.
hrcps9@gmail.com
Job Title:
Job Summary
Key Responsibilities
o Install, configure, administer, and maintain Microsoft SQL Server databases. o Manage SQL Server instances hosted on-premises and AWS RDS. o Configure and manage database backups, restores, disaster recovery, and maintenance plans. o Monitor database health, performance, and availability using SQL Server monitoring tools. o Identify and resolve database bottlenecks at both the infrastructure and application/query levels. o Perform query optimization, execution plan analysis, and performance tuning. o Design, implement, and maintain database objects, including:
Tables Views Stored Procedures
Functions
Triggers Indexes Constraints o Configure and manage SQL Server Agent Jobs. o Configure and troubleshoot Linked Servers. o Manage TempDB configuration and optimize its performance. o Monitor blocking, deadlocks, waits, and resource utilization. o Perform index analysis, maintenance, fragmentation management, and statistics updates.
o Troubleshoot database issues using:
- Support database deployments, schema changes, and release activities.
o Ensure database security by managing users, roles, permissions, auditing, compliance and encryption where applicable. o Production Incident Handling, Root cause analysis (RCA), performance troubleshooting and proactive monitoring. o Work closely with development teams to improve database performance and application scalability. Prepare and maintain database documentation, SOPs, and operational runbooks. Required Technical Skills
o SQL Server Administration o Microsoft SQL Server 2016/2019/2022 o Installation and configuration o Backup and Restore o Database maintenance o SQL Server Agent o Linked Servers o TempDB optimization o Database Migrations & Upgrades: Experience upgrading SQL Server versions and migrating databases -
AWS
o AWS RDS for SQL Server o Snapshot management o Parameter Groups o Option Groups o Performance Insights o CloudWatch monitoring Performance Tuning
o Query optimization o Execution Plan analysis o Index tuning o Statistics management o Wait Statistics Analysis: Understanding waits such as `PAGEIOLATCH`, `CXPACKET`, `CXSYNC_PORT`, `ASYNC_NETWORK_IO`, etc o Blocking and deadlock troubleshooting o CPU, Memory, and I/O performance analysis o Monitoring & Troubleshooting Extended Events SQL Profiler Query Store Activity Monitor Dynamic Management Views (DMVs): Strong hands-on experience using DMVs for troubleshooting Performance Monitor (PerfMon)
Windows Event Viewer
Resource Monitoring: CPU, memory, disk I/O, and storage performance analysis.
Database Development Knowledge
T-SQL Stored Procedures Functions Triggers Constraints Indexes Views CTEs Window Functions Database Concepts
OLTP and OLAP Database normalization and denormalization Database design and data modelling Transaction management Isolation levels Locking and blocking Concurrency management Good to Have
High Availability & Disaster Recovery (HA/DR), Always On Availability Groups, Log Shipping, Replication, Database Mirroring, Failover Clustering Automation: PowerShell and SQL scripting for routine DBA tasks Experience with CI/CD for database(dacpac) deployments Database security and auditing Capacity planning
Partitioning and compression
Experience with large databases (VLDB) Familiarity with Azure SQL is an added advantage
- Soft Skills
Strong analytical and troubleshooting skills Excellent problem-solving ability Good communication and documentation skills Ability to work independently in production support environments Experience working with cross-functional teams
