7+ Oracle DBA Jobs in Bangalore (Bengaluru) | Oracle DBA Job openings in Bangalore (Bengaluru)

·      Problem-Solving Skills, should be able to convert Idea on Paper to Code

·      Bachelor’s degree in computer science or related field, or equivalent professional experience.

·      0 - 4 years of database experience (Oracle SQL, PL/SQL)

·      Proficiency in Oracle, with Hands-on experience in database design

·      Creation & implementation of data models.

·      Strong experience with Oracle functions, procedures, triggers, packages.

·      Willing to learn, grasp & quickly adapt needed cutting-edge tools & technologies in shorter timeframe.

·      Should be able to write basic Procedures & Functions.

• Should adhere to SDLC processes and Oracle standard documentation /Operating Procedures
• Develop Reports, Charts and Forms using built-in UI components
• Add HTML5 and CSS3 scripting to improve the User Interface thereby providing a better user experience
• Include custom scripting (JavaScript/JQuery/AJAX) as per the business requirement
• Prepare Test cases/reports. Perform Unit , Peer and System Testing on the same
• Inspect / Debug the code logic using the browser developer tools
• Deploy Authentication and Authorization for the modules as per requirement
• Build features and applications with a mobile responsive design (Not mandatory)
• Migrate application and DB objects from DEV to TEST/PROD environments.
• Mandatory to work from Bosch Bangalore office from the start

Mandatory and Optional Skills

Sr. No.

Technical Skills

Mandatory /Good to have

Min Years of hands on Exp in this skill

1

Oracle Apex

Mandatory

3 Yrs

2

Oracle SQL, PL/SQL, Oracle DB Models/Objects

Mandatory

3-5 Yrs

3

Extensive project experience in developing Interactive Reports/Grids, Charts/Graphs, Forms (version > 20.x)

Mandatory

3

4

JavaScript, JQuery, AJAX, CSS and HTML5

Knowledge

1-2 Yrs

5

Data and UI integration with external (Oracle & Non-Oracle) systems 

Knowledge

3 Yrs

• Should adhere to SDLC processes and Oracle standard documentation /Operating Procedures
• Develop Reports, Charts and Forms using built-in UI components
• Add HTML5 and CSS3 scripting to improve the User Interface thereby providing a better user experience
• Include custom scripting (JavaScript/JQuery/AJAX) as per the business requirement
• Prepare Test cases/reports. Perform Unit , Peer and System Testing on the same
• Inspect / Debug the code logic using the browser developer tools
• Deploy Authentication and Authorization for the modules as per requirement
• Build features and applications with a mobile responsive design (Not mandatory)
• Migrate application and DB objects from DEV to TEST/PROD environments.
• Mandatory to work from Bosch Bangalore office from the start

Mandatory and Optional Skills

Sr. No.

Technical Skills

Mandatory /Good to have

Min Years of hands on Exp in this skill

1

Oracle Apex

Mandatory

3 Yrs

2

Oracle SQL, PL/SQL, Oracle DB Models/Objects

Mandatory

3-5 Yrs

3

Extensive project experience in developing Interactive Reports/Grids, Charts/Graphs, Forms (version > 20.x)

Mandatory

3

4

JavaScript, JQuery, AJAX, CSS and HTML5

Knowledge

1-2 Yrs

5

Data and UI integration with external (Oracle & Non-Oracle) systems 

Knowledge

3 Yrs

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