Senior Database Administrator

5 years

0 Lacs

Posted:1 day ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

We are seeking an experienced Database Administrator (DBA) to manage, maintain, and optimize all existing database systems — including Microsoft SQL Server, MySQL, and Azure SQL Managed Instances.The ideal candidate will be responsible for ensuring high availability, performance, security, and data integrity across all database environments.This role requires deep technical expertise in database administration, T-SQL development, backup/recovery strategies, and monitoring/troubleshooting.Key ResponsibilitiesDatabase Administration & MaintenanceManage and maintain MS SQL Server, MySQL, and Azure SQL Managed Instance environments (production, UAT, and development).Install, configure, patch, and upgrade database servers and tools.Implement and manage database backup and recovery strategies (native backups, BCP, export/import utilities, and automated backup jobs).Ensure databases are highly available, secure, and performant.Regularly perform health checks, index optimization, statistics updates, and space management.Performance Monitoring & TroubleshootingMonitor database performance using tools such as SQL Profiler, Azure Monitor, SSMS Performance Dashboard, SolarWinds, Redgate SQL Monitor, Nagios, or similar.Identify and resolve performance bottlenecks, blocking/deadlock issues, and slow-running queries.Perform root cause analysis (RCA) for database outages or performance issues and implement preventive measures.Development & Query OptimizationWrite and optimize T-SQL queries, stored procedures, functions, views, and triggers.Collaborate with developers to ensure efficient database design and query performance tuning.Support deployment of scripts and changes across environments following best practices.Security & ComplianceManage database users, roles, and permissions in alignment with company security policies.Ensure data encryption, auditing, and compliance with regulatory standards (e.g., GDPR, HIPAA if applicable).Automation & DocumentationAutomate routine DBA tasks (e.g., backups, monitoring, alerts, and maintenance plans).Maintain up-to-date documentation for all databases, configurations, procedures, and change logs.Support disaster recovery planning and testing.

Required Skills & Experience

5+ years of experience as a Database Administrator managing SQL Server and MySQL environments.

Strong Expertise In

T-SQL (queries, stored procedures, triggers, views)Database backup/restore (native, maintenance plans, BCP, logical/physical)Performance tuning and query optimizationSQL Agent Jobs and automationWorking knowledge of Azure SQL Managed Instance or other cloud-based database services.Experience with monitoring and alerting tools (Redgate, SolarWinds DPA, Azure Monitor, etc.).Strong understanding of replication, mirroring, Always On Availability Groups, and log shipping.Familiarity with MySQL administration, including replication and backup utilities.Ability to diagnose and troubleshoot complex database and performance issues.

Preferred Qualifications

Microsoft Certified: Azure Database Administrator Associate or SQL Server Database Administrator.Experience with PowerShell or Python scripting for automation.Familiarity with DevOps tools and CI/CD pipelines for database deployments.Knowledge of Linux/Windows Server administration related to DB operations.Soft SkillsStrong analytical and problem-solving skills.Excellent communication and documentation abilities.Ability to work under pressure in production environments.Collaborative mindset with cross-functional teams (Developers, DevOps, Infrastructure).Skills: mysql,optimization,sql,database,sql server,azure,maintenance,security

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

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

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.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You