Skip to main contentA logo with &quat;the muse&quat; in dark blue text.

Senior Database Administrator

AT Ensono
Ensono

Senior Database Administrator

Pune, India

About Us

Ensono is an expert technology adviser and managed service provider. As a relentless ally, we accelerate clients' digital transformation to achieve business outcomes that stand to last. Our dedicated team helps organizations optimize today's systems across any hybrid environment with services such as consulting, mainframe and application modernization, public cloud migration and cloud-native development. With certified experts in AWS, Azure and Google Cloud and recognized as Microsoft Datacenter Transformation Partner of the Year, Ensono has over 3500+ associates globally and is headquartered in greater Chicago.

We care about your success, offering comprehensive strategic and managed services for mission-critical applications. Our Advisory and Consulting services can help upfront with an application strategy or find the right places for your applications - whether it's public, multi or hybrid cloud, or mainframe. And because we span across all mission-critical platforms, we can meet you wherever you are in your digital transformation journey, with 24/7 support when you need it. We are your relentless ally, flexing with you when challenges emerge so you don't feel stuck in place. With cross-platform certifications and decades of experience, our technology experts have become an extension of your team so you're continuously innovating - doing more with less while remaining secure. And that's just the beginning.

Want more jobs like this?

Get jobs in Pune, India delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.


About Role

  • MS SQL Server DBA role largely responsible for providing operational database services to the organization.
  • Primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs,
  • Reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems.
  • Requires a service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues in alignment with the SLAs, establishing and maintaining communication with technology customers to keep them updated with status of their requests, initiating and performing changes on production systems and proactively escalating any issues that cannot be resolved within the established timeframes.

Mandatory Skill:

  • Strong experience in Database Administration in SQL Server 2008/2008R2/2012/2014/2016/2017/2019
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, clustering, Database mirroring, Replication and always on.
  • Should be strong in encryption, Log shipping with encryption, Backup encryption and TDE.
  • Experience in implementing operational automation.
  • Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
  • Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
  • Solid acquaintance with windows server, security delegation, SPNs, storage components.
  • Documentation skills for processes and procedures ( creating KBs, runbooks etc )
  • SQL Database Operational support to tech users

Good to have Skill:

  • Knowledge of 3rd party DBA tools and applications ( e.g Redgate, Idera, SCOM etc )
  • MCDBA / MCT certification
  • Knowledge in a scripting language like PowerShell, VBScript etc
  • Experience with Azure / AWS cloud
  • Shift - 24 X 7
  • On Call - As Per schedule or On Demand
  • Process Certification - ITIL Foundation certification preferred.
  • Major Incident Management - Should be able to drive the Major Incident/P1 calls.
  • Incident Management - Excellent exposure and experience in Incident Management
  • Change Management - Excellent exposure and experience in Change Management
  • Problem Management -Excellent exposure and experience in Problem Management
  • Communication Skill - Excellent Written & Verbal English communication Skill
  • Data Center Experience - Good to have

JR010054

Client-provided location(s): Pune, Maharashtra, India
Job ID: Ensono-JR010054_204304511
Employment Type: Other

Perks and Benefits

  • Health and Wellness

    • Health Insurance
    • Dental Insurance
    • Vision Insurance
    • Life Insurance
    • Short-Term Disability
    • Long-Term Disability
    • FSA
    • HSA
    • On-Site Gym
    • Mental Health Benefits
    • Pet Insurance
  • Parental Benefits

    • Birth Parent or Maternity Leave
    • Non-Birth Parent or Paternity Leave
    • Family Support Resources
    • Adoption Leave
  • Work Flexibility

    • Flexible Work Hours
    • Remote Work Opportunities
    • Hybrid Work Opportunities
  • Office Life and Perks

    • Casual Dress
    • Snacks
    • On-Site Cafeteria
    • Holiday Events
    • Commuter Benefits Program
    • Happy Hours
  • Vacation and Time Off

    • Paid Vacation
    • Unlimited Paid Time Off
    • Paid Holidays
    • Personal/Sick Days
    • Sabbatical
    • Leave of Absence
    • Volunteer Time Off
  • Financial and Retirement

    • 401(K) With Company Matching
    • Company Equity
    • Performance Bonus
    • Relocation Assistance
    • Financial Counseling
    • 401(K)
  • Professional Development

    • Tuition Reimbursement
    • Learning and Development Stipend
    • Promote From Within
    • Mentor Program
    • Shadowing Opportunities
    • Access to Online Courses
    • Lunch and Learns
    • Internship Program
    • Work Visa Sponsorship
    • Leadership Training Program
    • Associate or Rotational Training Program
    • Professional Coaching
  • Diversity and Inclusion

    • Diversity, Equity, and Inclusion Program
    • Employee Resource Groups (ERG)
    • Unconscious Bias Training