Oracle DBA Administrator

Tata Consultancy Services; Wichita (KS); On-site; USD 100,000 - 120,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Vacation and Sick Leave

401K Plan

Certification and Training Reimbursement

Job summary

A leading IT services provider in Wichita, Kansas is looking for a Database Administrator to manage Oracle databases, troubleshoot performance issues, and ensure database security. Key responsibilities include creating backup strategies, handling data migrations, and working in UNIX environments. A salary range of $100,000 to $120,000 per annum is offered along with comprehensive medical coverage, parental leaves, and professional growth opportunities.

Qualifications

• Strong knowledge in Oracle Database administration.
• Experience in troubleshooting database issues in RAC/Non-RAC setups.
• Good knowledge of UNIX environments (AIX/RHEL).
• Ability to handle all types of database backups and recovery procedures.

Responsibilities

• Manage database performance, tuning, and capacity monitoring.
• Maintain and configure Data Guard databases.
• Create and implement backup and recovery strategies.
• Perform database upgrades/migrations and monitor system automation.

Skills

Oracle Databases

Performance tuning

UNIX environments

Database security

Data guard databases

Backup and Recovery strategies

Cluster management

Job description

Responsibilities

1. Candidate should have strong knowledge on Oracle Databases having worked as Database Administrator
2. Experience in trouble shooting GI, Database and performance tuning issues in RAC/Non-RAC set up
3. Good knowledge of UNIX environments (AIX/RHEL)
4. Strong Performance tuning experience with a good understanding of database statistics, Locks & Blocking sessions, Explain plan analysis, AWR report analysis, Server resource monitoring etc.
5. Experience on applying/maintaining GI and Database & DB security patches
6. Should be able to create, maintain Data guard databases, troubleshoot and fix DG issues
7. Strong in handling all types of backups, refreshes and recovery procedures
8. Good understanding of database partitioning, database security architecture and maintenance
9. Responsible for making detailed technical RCA of problems, and taking appropriate remedial actions
10. ACFS & Adding and resizing of ASM disk groups
11. Work on issues that couldn’t be resolved by L2 team
12. Formulating Backup and Recovery strategies
13. Database upgrades/migrations
14. Install and configure Oracle enterprise manager Grid control
15. Formulating Backup and Recovery strategies
16. Handle RAC databases from a design, implementation, management and technical support perspective
17. Take ownership of performance and capacity monitoring aspects of the DB
18. Execution of data migration jobs and scripts as required
19. Assist the infrastructure team in sizing hardware used for the DB
20. Contribute to the creation and maintenance of disaster recovery plans
21. Create a reliable backup strategy. Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality
22. Determine and document DB policies, procedures and standards
23. Advance Finetuning concepts in Database
24. Managing the Database Team in various location and guiding them to Handle the daily operations smoothly
25. Security Patching of Database to be handled on time in coordination with the Application Team
26. Troubleshooting of cluster failures, ASM disk group’s failures and DR related problem etc
27. Database monitoring job automation. Any other DBA activities to fix any operational issues to make sure 24x7 uptime of databases

Generic Managerial Skills, If any

• Excellent interpersonal, verbal and written communication skills
• Strong logical, analytical, problem-solving skills
• Able to prioritize and execute tasks in a fast-paced environment
• Flexible working in 24/7 environment
• Should have Experience in IT Service organization
• Working exp using Incident management tools like ServiceNow

Base Salary Range

$100,000 to $120,000 Per Annum

TCS Employee Benefits Summary

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet In surance Plans.
• Family Support: Maternal & Parental Leaves.
• Insurance Options: Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
• Time Off: Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.