Job Opportunities in India
September 25, 2024
LyfLeap Talent Solutions Private Ltd
FULL TIME
SQL Server Database Administrator
SQL DBA:
Relevant 4+ yrs
Budget:10.5-11.5 LPA
N.P: Immediate or not more than 1 month
Look only for male candidates
Position: Level 2 SQL Server Database Administrator
Key Responsibilities:1. Database Administration:
Pay: ₹800,000.00 - ₹1,100,000.00 per year
Schedule:
Relevant 4+ yrs
Budget:10.5-11.5 LPA
N.P: Immediate or not more than 1 month
Look only for male candidates
Position: Level 2 SQL Server Database Administrator
Key Responsibilities:1. Database Administration:
- Manage and maintain SQL Server instances and databases across multiple environments.
- Perform installation, configuration, and upgrades of SQL Server databases.
- Implement and enforce database security policies and procedures.
- Proactively monitor and optimize database performance using diagnostic tools and scripts.
- Design, implement, and maintain effective backup and recovery strategies.
- Execute scheduled database backups and conduct regular restore testing to validate backup integrity.
- Troubleshoot backup issues and ensure robust recovery capabilities.
- Continuously monitor database performance metrics and identify bottlenecks.
- Use advanced performance tuning techniques to optimize queries, indexing, and database configuration.
- Troubleshoot and resolve performance issues promptly to maintain high database efficiency.
- Configure, manage, and support SQL Server high availability solutions (e.g., Always On Availability Groups, replication, mirroring).
- Implement and maintain disaster recovery plans, including failover procedures.
- Regularly test HA/DR solutions to ensure their effectiveness during actual outages.
- Set up and maintain real-time monitoring tools for database health, performance, and system resources.
- Create alerts for system anomalies and respond to incidents swiftly to prevent or mitigate downtime.
- Investigate system logs and troubleshoot errors to maintain optimal database health.
- Ensure that databases comply with organizational security standards and regulatory requirements.
- Manage and audit database users, roles, and permissions while enforcing access controls.
- Conduct periodic security audits and implement database security best practices to safeguard sensitive data.
- Maintain comprehensive documentation of database configurations, processes, and troubleshooting guides.
- Develop knowledge-sharing resources, such as runbooks, to improve team efficiency.
- Mentor junior team members and provide expertise on database-related projects.
- Serve as the first point of contact for database-related incidents, troubleshooting, and resolutions.
- Provide on-call support as part of a rotational schedule for critical incidents or outages.
- Ensure timely and effective resolution of database-related issues to maintain high availability.
- Strong knowledge of SQL Server database administration (installation, configuration, maintenance).
- Expertise in performance tuning and query optimization techniques.
- Experience with high availability (HA) and disaster recovery (DR) solutions (e.g., Always On, mirroring).
- Proficiency in T-SQL scripting for writing and optimizing queries, triggers, and stored procedures.
- In-depth understanding of database security principles (roles, permissions, encryption).
- Excellent problem-solving and troubleshooting skills in high-pressure environments.
- Ability to work independently, with a proactive approach to managing complex database environments.
- Microsoft Certified Solutions Associate (MCSA): SQL Server
- Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics
- Microsoft Certified IT Professional (MCITP): Database Administrator
Pay: ₹800,000.00 - ₹1,100,000.00 per year
Schedule:
- Rotational shift
- Are you ready to work 6 days a week ?
- total work: 4 years (Required)
- Night Shift (Required)
- Day Shift (Required)
- Overnight Shift (Required)
We regret to inform you that this job opportunity is no longer available
Latest Job Opportunities
October 19, 2024
Quincare Pharmaceuticals Private Limited
Medical Representative
Bankura
FULL TIME
View DetailsSimilar Jobs
September 20, 2024
Radisson Blu Marina Hotel Connaught Place - Food & Beverage
Server/Waiter/Waitress
FULL TIME
View Details