Lead Data Base Administrator

We are a tribe of happy people obsessed with customer success “
Sample our work culture at Life at OptiSol Portal https://culture.optisolbusiness.com

Roles and Responsibilities:

Responsible for physical database architecture and design, capacity planning, development, performance tuning, implementation, and support of the applications from a database perspective.
Conduct T- SQL Code Reviews to ensure coding standards, best practices and avoid potential performance issues.
Attend CAB ( Change Advisory Board) meeting and get proper approvals from product owners to implement DB changes.
Document operational or newly engineered solutions properly to educate and inform the clients and DBAs from the various levels of the organization.
Work on Writing custom stored procedures, T-SQL queries , PowerShell scripts , views, and triggers based on requirements for DB maintenance and automate tasks.
Work on writing technical and RCA (Root Cause Analysis) documentation.
Join bridge calls to troubleshoot and fix P1(SEV1) and P2 (SEV2) incidents.
work on performance tuning like provide suggestions to create indexes and tune stored procedures.
Troubleshoot recurring problems and fix them permanently.
Conduct DB DR Drill activity , ensure to bring the DR site online if any outage at Primary site.
Preferred candidates with SQL certification
Key Skills: DBA – Design, Administration , Troubleshooting , Recovery | SQL Server 2016

About Optisol:
A Trusted digital transformation partner of global enterprises with expertise in Native Web and Mobile Applications, AI & ML services hosted on AWS and Azure Cloud and product implementations. We are a team of about 300+ Agile smart employees with a development centre in India and global offices in the US, UK, Australia, Ireland, Sweden, and Dubai. We have been in operations for about 13+ years now and we have built about 500+ digital solutions. We have 200+ happy and satisfied clients across 24 countries. We have been awarded a Bronze trophy at CII National competition on Digitization, Robotics & Automation (DRA) Industry 4.0 - 2020. We have been recognized under the Cloud Solutions category for 2024 at the 7th edition of Express IT awards as a runner-up. We are a top-rated service provider in People Per Hour and have an excellent review and rated high on Clutch and Guru. Our Key Differentiators are, 1. Consultative Engagement2. Design Thinking 3. Agility 4. Tool Driven Approach 5. Competitive Pricing 6. Resource Expertise We are a certified Microsoft Gold Partner and AWS Consulting Partner.

Benefits:

Flexible schedule
Food allowance
Health insurance
Internet reimbursement
Life insurance
Paid sick time
Provident Fund
Work from home
Job Type: Full-time

Salary: ₹1,500,000.00 - ₹1,800,000.00 per year

Schedule:

Day shift
Experience:

DBA-SQL: 6 years (Preferred)
License/Certification:

SQL Certification (Preferred)