MS SQL DataBase Administrator
MS SQL Database Administrator | ThinkSys
MS SQL Server performance, security, and availability at ThinkSys. Manage databases, optimization, backups, and high-availability systems.
Key Responsibilities
1. Database Administration:
- Install, configure, and upgrade SQL Server instances.
- Create, modify, and manage databases, tables, statistics & indexes.
- Troubleshooting jobs
- Understand and develop SQL queries & stored procedures.
- Knowledge of PowerShell commands and scripting.
2. Backup and Recovery:
- Develop and maintain backup and recovery strategies.
- Perform regular backups and test restoration procedures.
- Ensure data consistency and minimize downtime during recovery.
3. Performance Tuning:
- Optimize database performance by analyzing query execution plans.
- Identify and resolve performance issues related to indexing, query design, and resource utilization.
- Index maintenance and updating stats
- Monitor server resources (CPU, memory, disk space) and adjust configurations as needed.
4. High Availability and Disaster Recovery:
- Configure and manage database clustering, and Always On Availability Groups.
- Always On - Plan and execute failover and failback procedures, troubleshoot latency and data
- consistency across replicas.
- SQL Cluster - Troubleshooting cluster issues, flipping cluster roles etc.
- Thorough knowledge of Transaction replication - setup, failures, latency and troubleshooting.
5. Good to have :
- Developing SQL queries & stored procedures
- Linux Basics
- PowerShell scripting skills
- PosgreSQL Database administration
Benefits Offered
- Flexible Work Hours.
- Work on impactful, industry-changing projects.
- Continuous learning and career growth opportunities..
- Collaborative, innovative, and inclusive environment.
- Insurance – Group Medical Coverage, Employee Personal Accident,
- Maternity and Paternity Leaves.
- Performance Feedback Sessions.
- Competitive Compensation.
- Rewards and Recognition Program, Employee Referral Program, Fun Events.