Database Administration - SQL Admin

Job description

**Job Description** **SN** **Required Information** **Details** 1 Role **L2 Database Administrator (MSSQL / Cloud / Automation)** 2 Required Technical Skill Set **Primary MSSQL, AWS RDS, Azure SQL** **Secondary – Oracle** 3 No. of Requirements **1** 4 Desired Experience Range **6 – 8 years** 5 Location of Requirement **Kochi/Chennai/Pune** **Desired Competencies (Technical/Behavioural Competency)** 1) **Must-Have** Key Responsibilities: - **Database Administration (MSSQL):** Install, configure, and administer SQL Server instances (2012–2022). Perform performance tuning, query optimization, index management, and storage planning. Manage HA/DR components: Always On AG, Log Shipping, Replication, Clustering. - **AWS RDS Administration:** Configure and maintain RDS SQL Server and PostgreSQL instances. Perform monitoring, snapshots, performance tuning, and parameter group management. Manage MultiAZ, read replicas, IAM authentication, and security controls. - **Azure SQL / Managed Instance:** Administer Azure SQL Database, MI, SQL on VM. Monitor performance using Query Store, Azure Monitor, Log Analytics. Configure firewalls, private endpoints, auditing, and security features. - **Automation:** Automate database tasks using **PowerShell**, **T-SQL**, . Build automated health checks, backup validations, index/maintenance routines. - **Disaster Recovery:** Implement and test DR strategies across on-prem, AWS, and Azure. Manage backup policies and recovery validation. - **Documentation:** Maintain SOPs, DR runbooks, configuration documents, migration plans. Required Skills and Qualifications: - Strong expertise in **MS SQL Server administration & performance tuning**. - Handson experience with **AWS RDS** and **Azure SQL** database services. - Experience with **cloud migrations**, modernization projects, and hybrid DB architectures. - Solid understanding of **Linux/Windows OS**, networking basics, and virtualization. - **Scripting:** PowerShell, T-SQL. - **Experience Level:** Typically, **6–8 years** in database administration. **Good-to-Have** - Knowledge of Oracle,MySQL & PostgreSQL Basics. - Experience with additional cloud DB engines (Aurora, Azure Oracle). - Exposure to monitoring tools: CloudWatch, Azure Monitor, SolarWinds, Dynatrace.**Role & responsibilities** **Preferred candidate profile**