
Website Prudent
Job Title : MS SQL DBA
Qualification : BE/Btech
Experience : 3 – 7 Years
Location : Ahmedabad
Company Profile :
Started in 2000, today Prudent is one of India’s fastest growing financial services Group. We commenced operations at the turn of millennium, with mutual fund distribution. We sensed the potential and under penetration of mutual funds, which laid the foundation of Prudent Group. Since then we have expanded to offer financial services and products such as Mutual Funds, Insurance, Equities, Bonds, PMS-AIF, Fixed Income Products, Properties and Loan Products.We deliver comprehensive and bespoke financial services to Individuals, Corporate, HNIs and UHNIs matching their investment aspirations and risk appetite through our team of 980+ highly skilled professionals & 17400+ well trained & qualified channel partners. Over a period of time, our market dominance has earned us not only trust and confidence but many accolades. We are present across India through our 105 branches over 20 states with our strong digital presence.
Responsibilities/Skills :
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring system health and performance to ensure elevated performance levels, availability, and Security.
- Analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
- Assist developers with complex query tuning and schema refinement.
- Performance Tuning and Optimization (PTO)
- Prevention of Deadlock and Timeouts
- Create a recovery model for disaster recovery.
- Manage ETL tools and Migration of the database from one server to another.
- Configure SQL databases on Azure cloud.
- Configuration of the database for on-premises and cloud
- Automation process for backup / restore / cleanup.
- Configure alerts for any DB related issues.
- Design indexing strategies
- Review database changes and design new database
- Maintain Database Access, Database Security and do an audit
- Configure Database Software
- Designing coding guideline for SQL programming
Join us on Telegram For More Updates: https://t.me/nareshit
To apply for this job please visit www.prudentcorporate.com.