SQL/MySQL DBA

Talent Corner Hr Services; Bengaluru; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Talent Corner Hr Services is seeking a Database Administrator to install, configure, and maintain SQL and MySQL databases in Bengaluru. The role emphasizes monitoring, optimization, and reliable backups, with DR planning to safeguard data assets.

Applicants should diagnose performance issues via profiling and event tools and automate routine tasks using PowerShell or Python. Strong problem-solving and user-facing communication are essential for success.

Qualifications

• Experience with SQL/MySQL databases, setup, and maintenance.
• Ability to monitor and optimize database health and performance.
• Proficient in backups, restores, and disaster recovery planning.
• Strong skills in query optimization and indexing.
• Experience troubleshooting deadlocks, blocking, and connection issues.
• Familiar with SQL Server Profiler, Extended Events, and Performance Monitor.
• Automation scripting using PowerShell or Python to streamline tasks.

Responsibilities

• Install, configure, and maintain SQL/MySQL databases.
• Monitor database health, including storage, indexing, fragmentation, and performance.
• Perform regular backups, restores, and disaster recovery (DR) planning.
• Analyse and optimize SQL queries, stored procedures, and indexing to improve performance.
• Investigate and resolve deadlocks, blocking, and connection issues.
• Troubleshoot and perform root cause analysis (RCA) for database performance issues.
• Monitor CPU, memory, disk I/O, and query execution plans to identify bottlenecks.
• Engage with users, identify their challenges, and deliver effective solutions.
• Configure SQL Server Profiler, Extended Events, and PerformanceMonitor for troubleshooting.
• Develop PowerShell/Python scripts or SQL Server Agent Jobs for automating routine tasks.

Skills

SQL

MySQL

Database health

Backups & DR

Query optimization

Root cause analysis

Troubleshooting

Monitoring

PowerShell

Python

Automation

SQL Server Agent

Tools

SQL Server Profiler

Extended Events

Performance Monitor

PowerShell

Python

SQL Server Agent

Job description

Job Description:

• Install, configure, and maintainSQL/MySQL databases.
• Monitordatabase health, including storage, indexing, fragmentation, and performance.
• Performregular backups, restores, and disaster recovery (DR) planning.
• Analyse and optimizeSQL queries, stored procedures, and indexingto improve performance.
• Investigate and resolvedeadlocks, blocking, and connection issues.
• Troubleshoot and Performroot cause analysis (RCA) for database performance issues.
• MonitorCPU, memory, disk I/O, and query execution plansto identify bottlenecks.
• Engage with users, identify their challenges, and deliver effective solutions.
• ConfigureSQL Server Profiler, Extended Events, and PerformanceMonitorfor troubleshooting.
• DevelopPowerShell/Python scriptsorSQL Server Agent Jobsfor automating routine tasks.