Oracle DBA

This role is fulltime roles with LTIMindtree.

Job Title: Oracle DBA

Location: Irving, TX (Onsite)Salary: 120K

Mandatory Skills: good with Oracle19c RAC, Data Guard and Golden gate.

Job Description:

Responsible for supporting Oracle databases daily BAU operations which includes availability, Capacity management, Monitoring and Alerting, performance tuning and troubleshooting.Responsible to Database hygiene, Process improvement, Standardizations, Major Incident management, automation and SRE responsibilitiesPerform escalations including callouts to senior support teams, vendors, application owners.Contribute to knowledge base / standard process library with feedback and updates as needed.Immediately alert supervisor of any perceived risk, or improperly executed task whether performed by individual or witnessed/discovered.Attend required regulatory training sessions.Attend training and become proficient in new acquired technologies and solutions.Manage activities ensuring adherence to Information Security Policy, CITMP policy and corporate standardsIdentifies and proactively resolves issues that could impact system performance, reliability, and usability.Collaborate with infrastructure and technology partners, and external service providersPerforms the capacity planning required to create and maintain the databases. The DBA works closely with system administration staffPlans and implements backup and recovery of the database including DR and Volume Testing activities.Control migrations of programs, database changes, reference data changes and menu changes through the development life cycle.Implements and enforces security for all of Databases supportedPerforms database re-organization as required to assist performance and ensure maximum uptime of the database.Perform periodic reviews on the Database Configuration, Capacity, Performance, Software Currency,Provides support for application during testing, release, upgrade, and migration activitiesExecute unplanned COB FailoverPerforms Decommission of databases as per application requestImplement and rollout new database tools for monitoring, release management and configuration managementOS VTM Patching - DB Checkout ValidationPlan and Execute Database Upgrade, VTM Patching & Other Database Related Implementations for restricted or complex environmentsPerform Root Cause & Impact Analysis for Major Incidents and attend corresponding Incident callsManage vendor cases raised by Level 2 supportPrepare support documentationOracle Qualifications: -

Sector L3 DBA SupportExperience with an organization with a key reliance on 24x7 reliability on its databasePossess excellent written and verbal communication skills in EnglishPossess excellent time management skills: (keeping deadlines, meeting goals, multitasking, coordinating tasks)Possess excellent organizational skills: (following direction, analysis, assessment, evaluation, documentation, reporting, attention to detailSolid understanding of ITIL and LEAN operating model.Must be a self-starter with a strong attention to detail.Solid understanding of Operating Systems like Windows, RedHat Linux and Cloud TechnologiesStrong hands-on experience in Database TechnologiesOracle - ORACLE in a production RAC (ASM) environment, Data Guard, Data Replication Configuration using Golden GateInfrastructure development experience on Ansible Chef/Puppet or related technologies with Unix, Windows PowerShell, SQL scripting knowledgeBackground or experience on Database Caching Technologies such as REDDIS, Couchbase or Database Cloud Technologies (AWS, Google, Azure) would be an advantage