12 Oct
|
Team Computers
|
Pune
12 Oct
Team Computers
Pune
Role & responsibilities
Key Responsibilities
1. Database Administration
- Install, configure, upgrade, patch, and maintain Oracle databases.
- Manage Oracle database instances, schemas, users, roles, privileges, and database objects.
- Perform routine database health checks and housekeeping activities.
- Monitor database availability, capacity, and overall health.
1. Performance Management
- Monitor database performance and identify bottlenecks.
- Analyze AWR, ADDM, ASH reports and SQL performance.
- Perform SQL tuning and database optimization.
- Monitor CPU, memory, storage, I/O, sessions, locks, and waits.
- Recommend capacity and performance improvements.
1. Backup &
- Recovery
- Manage database backup and recovery using RMAN.
- Perform backup validation and restoration testing.
- Support database recovery during incidents or failures.
- Ensure backup policies meet business continuity and DR requirements.
1. High Availability &
- Disaster Recovery
- Manage and support Oracle Data Guard environments.
- Monitor primary and standby databases.
- Perform Data Guard switchover/failover activities as required.
- Participate in DR drills and ensure database recovery objectives are met.
1. Incident &
- Problem Management
- Troubleshoot database incidents, performance issues, connectivity problems, and application-related database issues.
- Provide L2/L3 support for critical incidents.
- Perform RCA for recurring or major database incidents.
- Implement preventive and corrective actions.
1. Security &
- Compliance
- Manage database access, roles, privileges, and authentication.
- Follow security and compliance standards for database environments.
- Support vulnerability remediation and database patching.
- Maintain audit logs and required operational documentation.
1. Change &
- Release Management
- Execute database changes in accordance with the approved change-management process.
- Support application releases, database migrations, upgrades, and patching activities.
- Prepare implementation, rollback, and validation plans.
1. Monitoring &
- Automation
- Monitor database alerts and proactively identify potential failures.
- Work with monitoring tools to improve proactive incident detection.
- Automate repetitive DBA activities using scripts wherever possible.
- Maintain operational dashboards and database health reports.
1. Documentation &
- Governance
- Maintain SOPs, runbooks, database architecture documents, and recovery procedures.
- Prepare daily/weekly/monthly operational reports.
- Maintain database inventory and configuration information.
- Participate in service review meetings and governance calls.
Required Technical Skills
- Strong experience in Oracle Database Administration.
- Oracle 11g/12c/18c/19c/21c administration experience.
- Strong knowledge of SQL and PL/SQL.
- Oracle RMAN backup and recovery.
- Oracle Data Guard.
- Database performance tuning.
- AWR,
ADDM and ASH analysis.
- Oracle Enterprise Manager.
- Database patching and upgrade.
- Linux/Unix operating system knowledge.
- Shell scripting.
- Storage and filesystem concepts.
- TCP/IP and database connectivity fundamentals.
- Knowledge of ITIL-based incident, problem and change management.
Valuable to Have
- Oracle RAC.
- ASM.
- GoldenGate.
- Oracle Cloud / OCI.
- Exadata.
- Enterprise Manager Cloud Control.
- Database migration and modernization experience.
- Automation using Python/Shell scripting.
- Experience working with ServiceNow or other ITSM platforms.
Key Competencies
- Strong analytical and troubleshooting skills.
- Good communication and stakeholder-management skills.
- Ability to work independently and as part of an operations team.
- Ability to handle P1/P2 database incidents under pressure.
- Strong documentation and process discipline.
- Proactive approach toward monitoring and problem prevention.
- Willingness to participate in rotational/on-call support where required.
Key Performance Indicators
- Database availability and uptime.
- SLA compliance.
- Backup success and recovery-test compliance.
- Database performance and capacity management.
- Incident resolution and MTTR.
- Change success rate.
- Reduction in recurring incidents.
- Security and patch compliance.
- Quality of operational documentation.
Education &
- Certification
- Bachelor's degree in Computer Science, IT, Engineering, or equivalent.
- Oracle Database certification is preferred.
- ITIL certification is an added advantage.
📌 Database Administrator (Pune)
🏢 Team Computers
📍 Pune