Doryo Technologies India logo

Senior DBA MS SQL Server | Patona Enterprise-Remote

Doryo Technologies India

7 - 12 years

India

Posted:1 day ago

Job Description

About Patona Enterprise

Patona Enterprise is an IT services and consulting company specializing in Cloud, Data, Networking and Infrastructure solutions, with operations across Australia and India.

Role Overview

Senior DBA MS SQL Server

The role requires strong hands-on expertise in SQL Server database administration, performance optimization, backup and recovery, high availability, disaster recovery and Azure SQL environments.

The successful candidate will act as the primary database subject matter expert (SME), independently managing day-to-day database operations, troubleshooting complex database issues, supporting business-critical applications and ensuring database environments remain secure, stable and highly available.

The role will also involve supporting database migrations, implementing automation, managing production incidents and collaborating with application, infrastructure and cloud teams.

Role & responsibilities

SQL Server Database Administration

  • Administer and maintain Microsoft SQL Server databases across development, testing, UAT and production environments.
  • Install, configure, upgrade, patch and maintain SQL Server instances (2016, 2019 and 2022).
  • Monitor database availability, integrity, performance and overall health.
  • Manage database storage, capacity planning, data files, transaction logs and TempDB.
  • Manage SQL Server Agent jobs, maintenance plans, alerts and scheduled activities.

Performance Monitoring & Optimization

  • Monitor database performance and proactively identify performance bottlenecks.
  • Optimize SQL queries, stored procedures, indexes and execution plans.
  • Troubleshoot blocking, deadlocks, long-running queries and resource-intensive processes.
  • Perform index optimization, statistics updates and query tuning.
  • Investigate CPU, memory, disk I/O and database performance-related issues.

Backup & Recovery Management

  • Design, implement and maintain database backup and recovery strategies.
  • Perform full, differential and transaction log backups and database restores.
  • Conduct database recovery testing and ensure backup integrity.
  • Support point-in-time recovery and disaster recovery activities.
  • Ensure backup and recovery processes meet business recovery objectives (RPO/RTO).

High Availability & Disaster Recovery

  • Configure, manage and troubleshoot SQL Server Always On Availability Groups.
  • Manage Failover Cluster Instances (FCI), database mirroring, replication and log shipping.
  • Monitor database synchronization, failover and availability.
  • Participate in disaster recovery planning, testing and implementation.
  • Troubleshoot high-availability and database connectivity issues.

Azure SQL & Cloud Database Administration

  • Administer and support Azure SQL Database and Azure SQL Managed Instance environments.
  • Support SQL Server database migrations from on-premises environments to Azure.
  • Work with Azure Migrate and Azure Database Migration Service (DMS).
  • Monitor Azure database performance, availability, security and resource utilization.
  • Support cloud database migration, configuration and troubleshooting activities.

Database Security & Compliance

  • Manage SQL Server logins, users, roles and database permissions.
  • Implement role-based access controls and database security best practices.
  • Identify and remediate database security vulnerabilities.
  • Monitor database access and support audit and compliance requirements.
  • Ensure adherence to organizational security standards.

Incident & Problem Management

  • Independently troubleshoot and resolve complex database incidents.
  • Participate in Priority 1 (P1) incident management and production support activities.
  • Perform root cause analysis (RCA) and implement permanent corrective actions.
  • Investigate recurring database issues and recommend preventive measures.
  • Provide after-hours on-call support for critical production incidents.

Change & Release Management

  • Review and implement database changes through established change management processes.
  • Participate in ServiceNow change requests and CAB activities where required.
  • Validate database changes following implementation.
  • Prepare rollback plans and recovery procedures for production changes.
  • Coordinate database deployments with application and infrastructure teams.

Application & Integration Support

  • Collaborate with ERP, CRM, integration and .NET application teams.
  • Support database-related application issues and production deployments.
  • Assist application teams with SQL queries, database design and performance optimization.
  • Support SSIS packages, SSRS reports, SSAS and Azure Data Factory integrations.

Documentation & Continuous Improvement

  • Maintain database administration procedures, technical documentation and operational runbooks.
  • Document backup, recovery, monitoring and disaster recovery procedures.
  • Identify opportunities to automate routine DBA activities using PowerShell.
  • Improve database monitoring, alerting and operational efficiency.
  • Recommend database architecture and performance improvements.

Required Skills & Experience

  • Minimum 6+ years of hands-on experience in Microsoft SQL Server Database Administration.
  • Strong experience with Microsoft SQL Server 2016, 2019 and 2022.
  • Excellent knowledge of SQL Server installation, configuration, administration and maintenance.
  • Strong expertise in SQL query optimization, performance tuning, indexing and stored procedures.
  • Hands-on experience with backup, recovery, database restoration and disaster recovery.
  • Strong experience with SQL Server Always On Availability Groups, Failover Clustering, Replication and Log Shipping.
  • Experience in database security, user management, permissions and access controls.
  • Practical experience troubleshooting blocking, deadlocks, CPU, memory and database performance issues.
  • Experience managing SQL Server Agent jobs, maintenance plans and database monitoring.
  • Hands-on experience with Azure SQL Database and Azure SQL Managed Instance.
  • Experience with PowerShell scripting and database automation.
  • Strong troubleshooting, analytical and problem-solving skills.
  • Ability to independently manage production database environments and critical incidents.

Preferred / Advantageous Experience

  • Experience with SSIS, SSRS and SSAS.
  • Experience with Azure Data Factory (ADF).
  • Exposure to Redgate database tools.
  • Experience with SolarWinds Database Performance Analyzer (DPA).
  • Knowledge of AWS and Google Cloud Platform (GCP).
  • Experience with Azure Migrate and Database Migration Service (DMS).
  • Familiarity with ServiceNow, ITIL processes, incident management and change management.
  • Experience supporting enterprise ERP, CRM and .NET applications.
  • Experience working in multi-cloud and hybrid infrastructure environments.

What Success Looks Like

  • Stable, secure and highly available SQL Server database environments.
  • Proactive identification and resolution of database performance issues.
  • Reliable backup, recovery and disaster recovery processes.
  • Successful database migrations and cloud database operations.
  • Timely resolution of production incidents and effective root cause analysis.
  • Improved database performance, monitoring and operational efficiency.
  • Effective collaboration with application, infrastructure and cloud teams.

Preferred candidate profile

We are looking for an experienced Senior SQL Server DBA who can independently manage enterprise database environments and take ownership of database administration, performance optimization, high availability, disaster recovery and Azure SQL operations.

The ideal candidate will have strong technical expertise in Microsoft SQL Server, hands-on Azure database experience and the ability to troubleshoot complex production issues with minimal supervision.

The candidate must be comfortable working Australian business hours (AEST) and providing after-hours on-call support for Priority 1 production incidents.

If you are interested in exploring this opportunity, please share your updated CV along with the following details to my email ID- ishita.majumder@patonaenterprise.com.au

(Candidates are required to answer all questions in detail.)

  1. Total IT experience and relevant SQL Server DBA experience?
  2. Years of hands-on experience in MS SQL Server (2016/2019/2022)?
  3. Experience in SQL Server administration, installation, configuration and maintenance?
  4. Experience in SQL query optimization, performance tuning, indexing and stored procedures?
  5. Experience with SQL Server Backup & Recovery, Always On Availability Groups, Failover Clustering, Replication and Log Shipping?
  6. Hands-on experience with Azure SQL Database and Azure SQL Managed Instance? Please specify migration and administration experience.
  7. Experience with PowerShell scripting, SSIS, SSRS, SSAS and Azure Data Factory?
  8. Experience with database security, monitoring, troubleshooting, incident management and Root Cause Analysis (RCA)?
  9. Have you independently handled production database environments, critical incidents and disaster recovery activities?
  10. Current CTC:
  11. Expected CTC:
  12. Notice period: If Immediate joiner Please mention your Last working date and Reason for Leaving the company.
  13. Earliest joining date:
  14. Reason for job change:
  15. Current location:
  16. Are you comfortable working Australian business hours (AEST) and providing after-hours on-call support for P1 incidents?

Looking forward to hearing from you.

Regards

Ishita Majumder- Senior HR Consultant

Patona Enterprise (Formerly Known as Doryo Technologies Pvt Ltd.)

Skills Required

Backup And Recovery Shipping SQL Ssa T-SQL Indexing Microsoft Performance tuning

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Work Mode

Remote

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific 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.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Doryo Technologies India logo
Doryo Technologies India

RecommendedJobs for You