Database Administrator (DBA)

Americana Restaurants; Mohali; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Americana Restaurants in Mohali, India, seeks a seasoned Database Administrator to manage, maintain, and optimize critical databases across on-premises and cloud (Azure/Oracle) environments. You will ensure high availability, security, and performance for business applications.

Responsibilities include administering MS SQL Server and Oracle, monitoring performance, implementing backup and DR strategies, handling patching, and collaborating with Flutter/.NET teams on data modeling and

Qualifications

• Experience managing MS SQL Server and Oracle databases across prod, UAT, and dev
• Proven ability to monitor performance and tune queries to resolve bottlenecks
• Implement and maintain backup, recovery, and DR strategies with periodic drills
• Ensure database security incl. access controls, encryption, logging, and audits

Responsibilities

• Administer MS SQL Server and Oracle databases across environments
• Monitor performance, tune queries and indexes; resolve bottlenecks
• Manage backup, recovery, DR strategies and drills
• Implement security controls, encryption, and audits
• Support Azure SQL/MI provisioning, scaling, cost optimization
• Collaborate with Flutter/.NET/Oracle OIC teams on schema design
• Handle patching, upgrades, and capacity planning
• Set up monitoring/alerting (Azure Monitor, SQL Profiler, OEM)
• Maintain runbooks, SOPs, DR plans, and change records
• Participate in on-call rotation for production incidents

Skills

Backup/recovery

HA/DR

Performance tuning

T-SQL/PL-SQL

Education

B.E./B.Tech./MCA in CS/IT

DP-300

Oracle OCP

Tools

SSMS

Oracle Enterprise Manager

Monitoring/alerting tools

Job description

Manage, maintain, and optimize database systems supporting Americana's business-critical applications, ensuring high availability, performance, security, and compliance across on-premise and cloud (Azure/Oracle) environments.

Key Responsibilities

• Administer and maintain MS SQL Server and Oracle Database instances across production, UAT, and dev environments
• Monitor database performance, tune queries/indexes, and resolve bottlenecks proactively
• Manage backup, recovery, and disaster recovery (DR) strategies; conduct periodic DR drills
• Implement and maintain database security — user roles, access controls, encryption, audit logging
• Support Azure SQL Database / Managed Instance provisioning, scaling, and cost optimization
• Collaborate with application teams (Flutter/.NET/Oracle OIC) on schema design, data modeling, and integration performance
• Manage patching, version upgrades, and capacity planning
• Set up and maintain monitoring/alerting (Azure Monitor, SQL Profiler, OEM) for proactive issue detection
• Maintain documentation: runbooks, SOPs, DR plans, and change records
• Participate in on-call rotation for production incident support (P1/P2)

Required Skills & Experience

Skills - Backup/recovery, HA/DR (Always On, replication), performance tuning, T-SQL/PL-SQL

Tools - SSMS, Oracle Enterprise Manager, monitoring/alerting tools

Domain - Retail/QSR or FMCG industry experience preferred (not mandatory)

Soft Skills - Incident ownership, cross-team collaboration, clear documentation habits

Preferred / Nice-to-Have

• Exposure to Oracle Fusion HCM/SCM/Finance data structures
• Scripting for automation (PowerShell/Python)
• ITIL-based incident/change management exposure
• Basic understanding of application layer (Flutter/.NET) to support integration troubleshooting

Education & Certifications

• B.E./B.Tech/MCA in Computer Science, IT, or related field
• Certifications (preferred, not mandatory): Microsoft Azure Database Administrator Associate (DP-300), Oracle OCP