Description

You will be responsible for maintaining and optimizing database infrastructure.

Responsibilities

• Enhance the scalability and performance of existing database architecture.
• Protect data by developing security and restoration policies, procedures, and controls.
• Conduct diagnostic tests and evaluate database performance metrics.
• Perform database maintenance, migration, and upgrading of hardware and software.
• Document processes and ensure compliance with database management best practices.

Required Skills

• Strong understanding of SQL Server (IaaS and PaaS on Azure) and on-premise SQL Server setups.
• Hands-on experience with Unix/Linux command line operations.
• Experience with Performance Tuning and Query Optimization using tools like SQLProfiler.
• Ability to detect and troubleshoot SQL Server resource contention (CPU, memory, I/O).
• Experience in troubleshooting database integrity issues, blocking, and deadlocking.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for Azure PaaS, MSSQL Server, and MongoDB.
• Experience with database migrations, maintenance, and optimization strategies.
• Familiarity with backups, restores, and various recovery models.
• Knowledge of physical design concepts, RAID/SAN, and index management.

Key Skills

Education

Any Graduate