Database Administrator (DBA)

nLocation - Mohali, Punjab, India

nExperience - 3–5 Years

n

nRole Purpose

nManage, 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.

n

nKey Responsibilities

n

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



DR plans, and change records
n
- Participate in on-call rotation for production incident support (P1/P2)
n

n

nRequired Skills & Experience

n

nCore DB - MS SQL Server (mandatory); Oracle DB exposure preferred

nCloud - Azure (SQL DB/Managed Instance, Azure Monitor); Oracle Cloud exposure a plus

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

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

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

nSoft Skills - Incident ownership, cross-team collaboration, explicit documentation habits

n

nPreferred / Nice-to-Have

n

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

n

nEducation & Certifications

n

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

n

📌 Database Administrator (DBA) (Sahibzada Ajit Singh Nagar)
🏢 Americana Restaurants
📍 Sahibzada Ajit Singh Nagar