Location: Dehradun, Uttarakhand

Experience: 4+Year

Employment Type: Full time

About the Role

Key Responsibilities
- Administer Oracle 19c, 12c, 11g, and 10g databases on Linux, Windows, and AIX platforms.
- Perform Oracle database installation, configuration, migration, upgrades, cloning, and patching.
- Manage RMAN backup and recovery, database restoration, and Disaster Recovery using Oracle Data Guard.
- Execute database refresh, schema refresh, and table refresh activities using Data Pump (expdp/impdp).
- Monitor database health, performance, and availability using Oracle Enterprise Manager (OEM) and other monitoring tools.
- Analyze AWR, ASH, and ADDM reports to identify and resolve performance bottlenecks.
- Manage ASM storage, tablespaces, users, roles, schemas, and database security.
- Create and schedule database jobs and automate routine administrative tasks.
- Handle production incidents, change requests, problem tickets, and service requests within SLA.
- Troubleshoot database connectivity, listener, TNS, and database-related issues.
- Prepare technical documentation, SOPs,



and MIS reports.
- Provide 24×7 production support whenever required.

Required Technical Skills
- Oracle Database Administration (19c, 12c, 11g, 10g)
- RMAN Backup & Recovery
- Oracle Data Guard
- Oracle ASM
- Performance Tuning (AWR, ASH, ADDM)
- SQL & PL/SQL
- Oracle Data Pump (EXPDP/IMPDP)
- Oracle Enterprise Manager (OEM)
- Linux, Windows & AIX Administration
- Database Migration & Cloning
- Listener & TNS Configuration
- Ticketing Tools: ServiceNow, Remedy, CMS
- Monitoring Tools: OEM, SolarWinds

Preferred Skills
- Oracle Cloud Infrastructure (OCI) knowledge or certifications.
- Experience in Banking, Aviation, Education, or Enterprise Production environments.
- Strong analytical and troubleshooting skills.
- Excellent communication and documentation abilities.

Qualification
- MCA / BCA / B.Tech / BE in Computer Science, Information Technology, or a related discipline.

Pre

📌 Oracle Database Administrator (Dehradun)
🏢 TNS NETWORKING SOLUTIONS
📍 Dehradun