Job Description
About TCS :
Tata Consultancy Services is an Indian multinational information technology services and consulting company with its headquarters in Mumbai. It is a part of the Tata Group and operates in 150 locations across 46 countries. In July 2022, it was reported that TCS had over 600,000 employees worldwide.
About Job:
Job Title: Oracle DBA
Location : Las Vegas, NV
Job Type: Full Time
Technical skills:
Essential Job Functions
- Evaluate patch releases from Oracle and patching requests from development, and communicating constraints, issues, and timelines for deployment.
- Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production.
- Provide 24x7 rotational on-call support, including driving Root Cause Analysis (RCA), Preventative action follow-though, and participation in weekly operations reviews.
- Provide proactive database monitoring and issue resolution
- Perform database and PL/SQL optimization including performance tuning, query optimization and supportability.
- Participate and contribute to projects involving enterprise systems enhancements.
- Perform Implementation and ongoing support of high availability architecture (standby logical/physical Data Guard, RAC, hot standby databases, etc)
- Work with development project teams to design and implement database solutions to meet business requirements.
- Participate in project design and Oracle database design decisions. Refine and troubleshoot the design.
- Create and maintain appropriate documentation about the database and the data architecture.
- Support of the nightly ETL processing
- Ensure regular proactive capacity planning and tending reviews of all oracle databases. Producing weekly, monthly management reports.
- Attend project kick-offs and design reviews as necessary to appropriately size new environments, recommend infrastructure solutions and deliver associated cost and resource effort estimates
- Develop and implement Database security polices and procedures, in line with corporate objectives
- Perform other duties as assigned
Position Requirements
- Must have over 6 years of Oracle DBA working experience on Oracle Database 10g, 11g and/or 12c.
- Must be knowledgeable and experienced working with multiple operating systems including Microsoft Windows and Linux.
- Experienced in Database backup using RMAN with RMAN Catalog.
- Must be experienced using Oracle 10g, 11g and/or 12c Data Guard.
- Must be experienced using OEM Grid Control, Emrep and OMS. Experienced with tools such as Toad, Spotlight, or other Monitoring tools.
- Strong skills in PL/SQL and UNIX/Linux Shell Scripting
- Strong SQL and PL/SQL Design, Development, Tuning and debugging skills
- Experience with Oracle Security Administration
- Ability to maintain a positive attitude while working with high demands and short deadlines
- Ability to prioritize heavy workload with minimum supervision.
- Highly adaptable with ability to work in a fast paced demanding environment
- Must have excellent communications and interpersonal skills.
- Ability to work well with development and infrastructure teams in doing database design, changes and enhancement to new and existing applications.
- Support interfaces and back-end integration with applications.
- Strong Troubleshooting Skills.
- Strong organizational and analytical skills.
- Understanding of High Availability and Disaster Recovery requirements and solutions.
Preferred
- Oracle Education and Certifications (OCP) are a plus.
- Experience with Oracle Streams and/or database replication is a plus.
- Security and compliance experience including Encryption, Audit, Authentication, PCI, GLBA, SOX, etc.
- Experience in supporting Oracle RAC environments and ASM is preferred.
- Experience in data modeling and DM tools such as Oracle Data Modeler, Erwin, Toad, Visio, etc.
- Understanding of or experience supporting .NET application Tata Consultancy Services
Job Tags
Full time, Work experience placement, Worldwide, Night shift,