Production DBA, MS SQL Server

Bangalore
Full-Time
Remote
Senior: 8 to 12 years
Posted on Nov 24 2024

Not Accepting Applications

About the Job

Skills

Database Administration
Performance Tuning
High Availability
SQL Query Optimization
Backup and Recovery
Troubleshooting
Security Management
Monitoring Tools

Company Size

Large-scale / Global

Experience Required

8 - 12 years

Working Days

5 days/week

Office Location

Remote Working

Role & Responsibilities

  • Manage multiple RDBMS platforms (MSSQL (Primary), MySQL, and Postgres, etc.) through multiple product lifecycle environments, from development to mission-critical production systems.
  • Configure and maintain database servers and processes, including monitoring of system health and performance to ensure high levels of performance, availability, and security.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Independently analyze, solve, and correct issues in real-time, providing problem resolution end-to-end.
  • Refine and automate regular processes, track issues, and document changes.
  • Assist developers with complex query tuning and schema refinement.
  • Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
  • Provide rotation-based 24/7 on-call support for unplanned outages and planned maintenance/release events.
  • Collect and report database performance KPIs on a regular basis.


Ideal Candidate

  • Bachelor’s degree in information technology or a related discipline.
  • 8+ years of database administration experience, preferably in MSSQL (primary), MySQL, and Postgres.
  • At least 2 years of cloud-based database administration experience.
  • Experience in troubleshooting and resolving database problems.
  • Experience in implementing operational automation using scripts.
  • Hands-on experience with SSIS, SSRS, SSAS, and PowerShell.
  • Extensive experience with Windows/SQL Server Clustering (On Physical & Cloud-based VMs), Always On, Replication, and Mirroring.
  • Experience with Performance Tuning and Optimization (PaaS & IaaS).
  • Experience with backups, restores, and recovery models.
  • Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
  • Experience working with Windows Server, including Active Directory.
  • Excellent written and verbal communication.
  • Flexible team player with a “get-it-done” personality.
  • Ability to organize and plan work independently.
  • Ability to work in a rapidly changing environment.
  • Ability to multi-task and context-switch effectively between different activities and teams.


About the company

TalentXO is a Recruitment-Tech Platform powered by a Network of "Domain Expert Recruiters" and Data Intelligence. We empower Recruiters to GO Independent, EARN as a Freelancer, & GROW your Domain Knowledge! Why Join TalentXO? 1. Work with TOP Product Companies - ( like OLA, Razorpay, Myntra, Directi, Byju's App, InMobi, Deloitte, Wipro, Nykaa, Pharmeasy, Delhivery) 2. CHOOSE your Domain - ...Show More

Industry

IT Services and IT Consul...

Company Size

201-500 Employees

Headquarter

Bangalore

Other open jobs from TalentXO