Senior Consultant - System Management Job at LTIMindtree
Oracle DBA With Golden Gate
Nearest Major Market: Irving
Nearest Secondary Market: Dallas
Job Segment: Database, Oracle, SQL, DBA, Management Consulting, Technology, Management
- Experience on Oracle Core DBA activities
- Excellent understanding of Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes using Oracle 11g
- Troubleshoot/resolve complex production data issues.
- Index Strategy (i.e. Fragmentation)
- HA Solutions
- DR/COB Solutions
- Application Entitlements, Security Review
- Archiving/Historical Data
- DB Performance & Tuning Specialist
- Ability to perform RCA and remediation of DB Perf. issues using AWR, ASH, Query execution plans, monitoring report etc.
- Able to review of SQL plan and other SQL metrics
- Understanding of DB configuration parameters and optimal settings
- Database logical design
- Knowledge and understanding of different oracle wait events include cluster waits
- Strong RAC implementation & support experience
- Identify and produce documentation of best practices.
- Trouble shooting and performance tuning Golden Gate replications.
- Implementing necessary monitoring scripts for Golden Gate in UNIX/PERL scripting
- Operational support experience
- Create database objects in operational data store and maintaining them.
- Working with project management team to plan release activities.
- Deep understanding Oracle Golden Gate internal mechanism, OGG new features such as Integrated capture, native DDL capture, coordinate apply mode, multi-threaded replicate
- Provide Golden Gate solutions
- Working with Oracle on SRs for critical issues.
- Should be able to help in finding current issues and provide solutions to improve performance
- Build deployment packages and promote them to higher environments (UAT, Production and Cob) following SDLC
- Working knowledge of Linux Redhat, File System, Cluster Management and Oracle ASMC and ACFS
- Manage and maintain databases across multiple environments.
- Perform Database analysis and provide recommendations.
- Work on the Database architecture, design, and performance optimization.
- Develop automation scripts to improve platform efficiency.
- Identify and recommend Database design and Data models.
- Provide oversight on low-level design and technically guide the Development team.
- Partner with Development organization/oversee DB landscape for portfolio.
- Plan and manage existing/new DB Development, manage and customize server configuration, as per application needs.
- Optimizing stats collection
USA RR Inputs:
- Our client requires all the employees working on this engagement to be COVID-19 vaccinated.
- If you need a reasonable accommodation for a sincerely held religious belief or medical condition, please contact covid-19@lntinfotech.com
Nearest Major Market: Irving
Nearest Secondary Market: Dallas
Job Segment: Database, Oracle, SQL, DBA, Management Consulting, Technology, Management
Please Note :
www.bankofmontserrat.ms is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.bankofmontserrat.ms provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.