Oracle Database Administrator

Greetings from TCS!

TCS has been a great pioneer in feeding the fire of young Techies like you. We are a global leader in the technology arena and there’s nothing that can stop us from growing together.

Your role is of key importance, as it lays down the foundation for the entire project.

Make sure you have a valid EP number before interview. To create an EP Number, please visit

Kindly complete the registration if you have not done it yet.

Position: Oracle DB Admin

Experience: 5-7 years

Location: Pan India

Job Description:
• Strong working knowledge of Oracle 12C, 18C and 1+C. Knowledge of 21C will be added advantage.
• Perform day-to-day administration of Oracle databases, including backup/recovery, Capacity planning and performance tuning.
• Very good knowledge about Oracle Architecture, RAC, High Availability and DR solution and OEM
• Configuring High Availability and DR solution with DGMGRL
• Upgrading oracle databases to latest versions
• Applying latest Fix-Packs as per requirements
• Monitor database performance and recommend improvements for operational efficiency
• Database performance tuning by configuring database parameters.
• Monitor the Oracle Alert logs files, transaction logs, archive logs and backup log
• Day to day activities like TS, backup, cronjob, OEM alert
• Experience with Data-Guard, Cloning, RMAN backups, Golden Gate and point in time recovery, ASM
• Monitor system's health and performance
• Perform Database maintenance like, Reindexing, Update Statistics and review and optimize query tuning.
• Perform scheduled maintenance and support release deployment activities after hours
• Review Hardware and configuration and suggest the improvement areas.
• Hands on setting up DR environment and experience in DR testing.
• Manage database security and make sure it’s complied policies, regular audit of security processes
• Familiarity with monitoring tools like Confio, Solarwind and splunk etc.
• Good knowledge in Linux operating system and hands on experience in writing shell scripts/Perl/python, with this scripting knowledge, should explore automating the repetitive tasks
• Refine and automate regular processes, track issues and document changes
• Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution
• Capacity planning, space management and data maintenance activities for database system. Perform database enhancement and modification as per the requirements.
• Global On-call Support including weekend
• Regular Connect with Client
• Operational Shift support as per Roster
• Willing to learn and work on other Opensource/ DB technologies like DB2, PostgreSQL, MySQL
• Knowledge of ITSM process and ticketing tool like ServiceNow /REMEDY etc.

Desired Competencies (Technical/Behavioral Competency):

Must-Have: Oracle installation and Configuration on Linux/Windows OS platform, configuring HA, DR databases, Database upgrades and applying PSU packs, Hands on experience in writing/troubleshooting shell scripts/Perl/python

Good-to-Have: Knowledge of Cloud computing technologies, Real Application Cluster

TCS Eligibility Criteria:
• BE/B.tech/MCA/M.Sc./MS with minimum 5 years of relevant IT-experience post Qualification.
• Only Full-Time courses would be considered.
• Candidates who have attended TCS interview in the last 1 month need not apply.

Referrals are always welcome!

Kindly don't apply if already attended interview in last 1 month.

Regards,

Sangeethraj Hopper