Must Have Technical/Functional Skills
Database Administration
- Install, configure, and maintain Oracle databases (11g / 12c / 19c) on Linux/Unix platforms
- Perform database creation, configuration, cloning, and decommissioning
- Manage tablespaces, datafiles, redo logs, control files, and storage growth
- Perform routine maintenance activities such as space management and housekeeping
Backup & Recovery
- Design and implement backup and recovery strategies using RMAN
- Perform database restores and recoveries (complete and point in time recovery)
- Test backup and recovery procedures regularly to ensure DR readiness
- Handle archive log management and retention policies
Performance Monitoring & Tuning
- Monitor database performance using AWR, ADDM, ASH, OEM
- Identify and resolve performance issues related to CPU, memory, I/O, SQL
- Tune SQL queries, indexing strategies, and optimizer statistics
- Manage Oracle initialization parameters for optimal performance
High Availability & Disaster Recovery
- Implement and support Oracle Data Guard (Physical / Logical Standby)
- Manage Oracle RAC environments for high availability
- Perform planned and unplanned failover and switchover operations
- Support DR drills and business continuity testing
Security & Compliance
- Manage database users, roles, profiles, and privileges
- Ensure database security standards and compliance requirements are met
- Implement auditing, password policies, and access controls
- Apply security patches and CPU updates
Upgrades, Patch & Migration
- Perform Oracle patching, PSU/CPU upgrades, and version upgrades
- Support database migrations across platforms or versions
- Coordinate with application and infrastructure teams during releases
- Follow change management and release processes
Production Support
- Provide 24x7 on call support for production databases
- Troubleshoot database incidents and perform root cause analysis
- Work with vendors and internal teams to resolve complex issues
- Maintain SOPs, runbooks, and operational documentat ion
Salary Range: $100,000 - $130,000 a year
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & amp; Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
#LI-SP1