Oracle DBA Jobs in Bangalore (Bengaluru)

JD for APPS DBA. – Years of Exp 6-8 

Job Description:

• Should support R12.2, Cloning, Patching, ADOP, Shared appl top, SSL/TLS.
• WebLogic, OAM, OIM, registration
• Experienced with Oracle RAC, supporting multi tenant architecture, CDB, PDB
• Installation and Upgrade of Application and Database
• Performance tuning at Apps, DB level,
• Troubleshooting skills, identifying root cause analysis
• Supporting other oracle and 3rd party technologies, from start, stop and basic maintenance, OBIEE, OBI, SOA services
• Oracle Certification
• Database RMAN backups, restores and recoveries
• OEM monitoring, identifying performance issues.
• Unix, Linux basic support, shell scripting.
• Preferable to have knowledge in OCI.

JD:

• Experience in maintaining Oracle Exadata, RAC, and Administration of Oracle Multitenant Architecture.
• Implemented below Exadata new features like Smart scan, Flash cache, flash log, IORM, Storage indexes
• Using CellCli or dcli to manage Exadata storage server objects.
• Monitoring cell disk, grid disk, cell flash cache, flash disk
• Configured dcli between cell nodes and database nodes.
• Monitoring Exadata storage servers with cell metrics alerts and active requests.
• Migrating legacy database to Exadata.
• Experience in Exadata patching
• Experience in RAC along with new features like Flex ASM and Flex cluster.
• Resolve the issues like replace damaged physical disk or Flash disk.
• Installing & configuring Oracle Cluster ware & Database Software for Oracle 12c and 19c.
• Extensive Knowledge on Oracle Multitenant Architecture 12c and 19c.
• Experienced in Oracle installations, upgrades, migration, cloning, designing logical/physical architecture
• Database Refresh using Data pump.
• Expertise in Database upgrades, patching for standalone & RAC databases.
• Experienced in Database Point in Time Recovery.
• Enforcing security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts.
• Knowledge on oracle enterprise management
• Implementation of db compression using Exadata HCC
• Running ExaCheck reports monthly 
• Implementing smart flash cache, enabling flash cache write back
• Hardware changes , flash disk, griddisk and DIMM replacements
• Working knowledge on managing NFS mount points.
• ZFS share creation
• Huge pages setting

ORACLE DATABASE ADMINISTRATION

• Assisting developers to write efficient code.
• Tuning and debugging customer installations.
• Maintaining internal development and test databases.
• Working closely with leading experts in Supply Chain management to support various E2open teams.
• Provides on-call support in a 24x7 environment.

The position requires night shift work to support the US time zone.

Required Experience/Skills:

• Bachelor's/Master's/PhD degree in Engineering, Computer Science, Mathematics, or other Science with a consistent academic record (Preferably more than 70%)
• Oracle-certified DBA with 3+ years of DBA experience
• Oracle 12c and 19c experience is a must.
• Experience in Performance Tuning and Query Optimization is a must.
• Expertise and development experience in PL/SQL and SQL
• Experience in Oracle installation, upgrade backup, and recovery methods.
• Experience in Unix/Linux shell scripting.
• Track record of delivering quality work on time and ability to expand own expertise.
• Self-motivated, detail and team-oriented
• Solid verbal and written communication skills
• Enjoys dynamic, result-oriented work culture.
• Excellent problem-solving and troubleshooting skills.
• Experience considered a plus: 
• MySQL and PostgreSQL
• Knowledge of server, storage, and networking technology.
• Supply Chain background

smartShift Technologies is looking for a seasoned Database Administrator - Oracle to join our Bangalore team.

 Responsibilities

• Perform regular Database administration tasks.
• Perform HA and DR setup maintenance tasks
• Analyze the performance metrics and provide tuning recommendations
• Analyze the repetitive support requests and provide the automation feasibility
• Handle incidents and problems
• Perform trend analysis of the incidents/events and help in finding the resolution

 Skills & Experience

• Strong experience in Database Administration  in Oracle database 
• Have strong knowledge on Oracle SQL and PL/SQL 
• Expertise in writing and analysing Stored procedure , packages and triggers. 
• Exposure to AWS Cloud RDS is required
• Experience in Database Patching/Upgrade/Migrations
• Experience in managing the HA and DR setups ( Standby, DataGuard)
• Experience in performance tuning ,query optimisation
• Experience with client interaction is preferred
• Exposure to other MySQL database is preferred
• Excellent written and verbal communication skills. 
• Real time experience in DB administration (Installation/Tablespace Management/Object Management
• Expertise in RMAN and other backup(Expdp/Impdp) methodology implementations
• Experience in Database Patching/Upgrade/Migrations
• Knowledge on GoldenGate is desirable
• Knowledge on Oracle 12C/19C new features
• Experience with client interaction is preferred
• Knowledge on RAC & ASM is desirable
• Exposure to AWS Cloud is desirable
• Excellent written and verbal communication skills