Xceedance
Website:
xceedance.com
Job details:
NOTE: This opening is for IMMEDIATE joiners only. Kindly refrain for applying if you have a notice period more than 30 days.
About Xceedance
Xceedance provides strategic operations support, technology, and data services to drive efficiencies for insurance organizations worldwide. The company helps insurers launch products, implement intelligent technology, deploy advanced, and achieve business process optimization. We are committed to adding direct value in the business of insurance and help insurers launch new products, drive operations, implement intelligent technology, deploy advanced analytic capabilities, and achieve business process optimization.
For more information, visit www.xceedance.com.
Our Vision & Strategic Focus:
To help catalyze insurance ecosystems for the benefit of the society.
· Global Insurance expertise and a customer centric approach
· Vertical focused and technology enabled
· Learning Organization
· People – First Culture
Job-Summary:
We are seeking a highly skilled and experienced SQL – Sr System Admin to join our dynamic team. The ideal candidate will have a strong background in database administration and management, with a total experience of over 8 years, including 6 years of relevant experience. The SQL Tech Lead will be responsible for overseeing various DBA related tasks and ensuring the optimal performance, security, and reliability of our SQL databases.
Key Responsibilities
The key focus areas of this role are:
- Manage and maintain Azure SQL Database and Azure SQL Managed Instances.
- Perform regular backup and restore operations to ensure data integrity and availability, including testing recovery strategies and automating backup processes.
- Write, optimize, and troubleshoot stored procedures to enhance database functionality and performance, ensuring efficient query execution plans and minimizing resource usage.
- Oversee the management and maintenance of database clusters, including setup, configuration, and monitoring of cluster health and performance.
- Implement and manage comprehensive user and role management strategies along with Role-Based Access Control (RBAC) to ensure secure access and compliance with internal policies.
- Set up, configure, and manage Disaster Recovery (DR) and High Availability (HA) solutions to ensure business continuity, including regular testing and documentation of DR plans.
- Plan and execute the migration of SQL databases to newer environments or cloud platforms, ensuring minimal downtime and data loss.
- Optimize and maintain databases using advanced techniques such as indexing, partitioning, and query optimization to improve performance and efficiency.
- Work with on-premises SQL Servers 2014, 2016, and 2022, ensuring their optimal performance and security through regular updates, patching, and monitoring.
- Conduct query optimization and performance tuning to enhance database performance, including analyzing query execution plans, identifying bottlenecks, and implementing improvements.
- Schedule and manage database jobs to automate routine tasks and maintenance, ensuring timely execution and monitoring of job outcomes.
- Collaborate with development teams to design and implement database solutions that meet application requirements and performance goals.
- Monitor database performance and provide proactive recommendations for improvements, including capacity planning and trend analysis.
- Provide technical leadership and mentorship to junior DBAs and other team members, fostering a culture of continuous learning and improvement.
- Stay current with industry trends and best practices in database administration and management and apply this knowledge to improve our database systems.
Qualification & Experience:
- Bachelor’s degree in computer science, Information Technology, or a related field.
- 8+ years of total experience in the field of database administration and management.
- 6 years of relevant experience working with SQL databases, particularly with Azure SQL DB and Azure SQL Managed Instances.
- In-depth knowledge of database backup, restore, and recovery procedures.
- Proficiency in writing and troubleshooting stored procedures.
- Experience in managing database clusters and implementing user and role management with RBAC.
- Expertise in setting up DR and HA solutions.
- Proven experience in migrating SQL databases and optimizing their performance.
- Strong knowledge of on-premises SQL Servers 2014, 2016, and 2022.
- Advanced skills in query optimization, performance tuning, and job scheduling.
- Excellent problem-solving and analytical skills.
- Strong communication and teamwork abilities.
Preferred Skills:
- Certification in SQL Server or related technologies.
- Familiarity with cloud platforms other than Azure, such as AWS or Google Cloud Platform.
- Knowledge of additional database systems and technologies.
- Experience with database security best practices.
What We Offer You
At Xceedance, you will discover the possibility to exceed yourself and grow persistently with us. We offer career development opportunities to our members for a well-rounded development throughout their journey with us.
Xceedance is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, national origin, disability, protected veteran status, sexual orientation, gender expression, gender identity or any other characteristic protected by law.
Click on Apply to know more.