Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in bengaluru
>
Consilio
>
Sr Database Administrator

Sr Database Administrator

Consilio

7 - 12 years

9 - 14 Lacs

bengaluru

Posted:None| Platform:

Apply

Skills Required

performance tuning automation data management ssrs disaster recovery flex database administration ssis troubleshooting capacity planning

Work Mode

Work from Office

Job Type

Full Time

Job Description

Job Summary:

We are seeking a highly skilled and experienced MSSQL Senior Database Administrator (DBA) to manage, maintain, and optimize our organizations Microsoft SQL Server databases. The ideal candidate will ensure the performance, availability, and security of critical database systems, supporting various applications and business operations 24 /7/ 365. This role requires a proactive individual with an understanding of database architecture, best practices, and troubleshooting. This individual should have a deep understanding of MSSQL.

Responsibilities

Essential Responsibilities:

Database Installation & Configuration: Install, configure, and upgrade SQL Server instances (all versions) across various environments (Dev, QA, UAT, Prod).

Performance Tuning & Optimization: Monitor database performance, identify bottlenecks, and implement solutions for query optimization, indexing strategies, and database configuration to ensure optimal performance.

Backup & Recovery: Design, implement, and maintain robust backup and recovery strategies to ensure data integrity and availability, including disaster recovery planning and execution.

Security Management: Manage database security, including user permissions, roles, authentication, and encryption, adhering to security policies and compliance requirements.

High Availability & Disaster Recovery: Implement and manage high availability solutions such as AlwaysOn Availability Groups.

Troubleshooting & Support: Provide expert-level troubleshooting for database-related issues, including connectivity, performance, and data corruption, offering timely resolution.

Monitoring & Alerting: Implement and maintain database monitoring tools and alerts to proactively identify and address potential issues.

Capacity Planning: Monitor database growth and resource utilization, performing capacity planning to ensure scalability and future needs are met.

Data Integrity & Corruption Checks: Implement and regularly perform data integrity checks to detect and resolve database corruption, ensuring data consistency and reliability.

Standard Operating Procedures (SOPs): Develop, maintain, and regularly update Standard Operating Procedures (SOPs) for all database administration tasks and processes.

Additional Responsibilities

Collaborate with development teams to optimize database designs and SQL queries for new applications and features.

Participate in on-call rotation for after-hours and holiday support of critical production systems.

Stay current with the latest SQL Server technologies, features, and industry best practices.

Assist in the evaluation and implementation of new database technologies and tools.

Provide mentorship and guidance to junior team members or developers on database best practices.

Develop, refine, and maintain SQL scripts for automation of routine DBA tasks.

Participate in auditing and compliance activities related to data management.

Support multiple concurrent projects, managing priorities and deadlines effectively.

Collaborate with other teams during incident calls to diagnose and resolve database-related issues.

Manage and prioritize database-related tickets through a formal ticketing system, ensuring timely resolution.

Bonus Skills:

Experience with SSAS, SSIS, and SSRS

Experience with transactional replication

Experience with Powershell

Experience with version control (ie: Github)

Qualifications

Minimum Education Requirements:

Bachelor degree required or equivalent experience

Minimum Experience Requirements:

Working experience with MS Office tools (such as Outlook, MS Teams, Excel, PowerPoint, etc)

7+ years of experience as a SQL Server DBA or similar role

7+ years of experience with Performance Tuning and Optimization (PTO)

7+ years of TSQL experience

Other Requirements:

MCTS, MCITP, and/or MVP certifications a plus

MS SQL Server certifications and/or experience writing advanced T-SQL queries

Experience working with/supporting other eDiscovery applications

Sense of ownership and pride in your performance and its impact on company s success

Critical thinker and problem-solving skills

Team player

Great time-management skills

Great interpersonal and communication skills

Consilio s True North Values

Excellence We strive to make every client our advocate

Passion We DO because we CARE

Collaboration

More Jobs at Consilio

Senior Analyst, Data Operations

Gurugram

3 - 7 yrs

INR 4 - 8 Lacs

Admin,BH

Bengaluru

2 - 7 yrs

INR 2 - 5 Lacs

Concierge Partner

Gurugram

2 - 3 yrs

INR 4 - 8 Lacs

DB - Engineer

Bengaluru

2 - 4 yrs

INR 3 - 7 Lacs

Docusign Developer

Pune

4.0 - 8.0 yrs

INR 10 - 18 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Consilio

Legal Services & Technology

Roseville

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Sr Database Administrator