Database Administrator (DBA)
Job Description
Location
Mohali, Punjab, India
Experience
3–5 Years
Function
IT / Enterprise Applications
Reporting Line
IT Manager / Senior Manager – Enterprise Applications (Mohali)
Role Purpose
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
• Support data migration activities during platform modernization projects
• Maintain documentation: runbooks, SOPs, DR plans, and change records
• Participate in on-call rotation for production incident support (P1/P2)

Required Skills & Experience
Area
Requirement
Core DB
MS SQL Server (mandatory); Oracle DB exposure preferred
Cloud
Azure (SQL DB/Managed Instance, Azure Monitor); Oracle Cloud exposure a plus
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, explicit documentation habits
Preferred / Nice-to-H

📌 Database Administrator (India)
🏢 Americana Restaurants
📍 India