Assistant Manager - SQL Database Administration

<p><p><b>Description :</b> <br/><br/></p><p>Role : SQL DBA <br/><br/>- BE/B.Tech/MCA with 56 years of experience and a strong understanding of database management, performance tuning, and high-availability setups.<br/><br/><b>Key Skills & Responsibilities :</b> <br/><br/>- Strong proficiency in SQL Server / MySQL database administration, maintenance, and optimization.

<br/><br/>- Experience with database design, schema management, indexing, and query optimization.

<br/><br/>- Expertise in backup, restore, disaster recovery strategies, and database archiving.

<br/><br/>- Experience with data retention policies, purging, and archiving large datasets.

<br/><br/>- Performance monitoring, tuning, and troubleshooting of production databases.

<br/><br/>- Knowledge of high availability, replication, clustering, and failover mechanisms.

<br/><br/>- Familiarity with security, user management, and data access control.

<br/><br/>- Experience in writing and optimizing complex SQL queries, stored procedures, and triggers.

<br/><br/>- Familiarity with automation scripts and CI/CD pipelines for database deployments.

<br/><br/>- Sound understanding of Agile methodologies and collaboration with development teams.

<br/><br/><b>Nice-to-Have / Optional:</b> <br/><br/>- Exposure to cloud databases (Azure SQL).

<br/><br/>- Experience with NoSQL databases (MongoDB, Cassandra, etc.).

<br/><br/>- Experience working with Data Lakes, large-scale data platforms, and data archival solutions.</p><br/></p> (ref:hirist.tech)