Oracle Apps DBA

Role: My SQL DBA

Work Location: Noida/Hyderabad

Exp : 3+ Yrs

About the Role:

The ideal candidate would be working on the servers which impact various SaaS AI/ML products and

1000+ models in AI/ML. As a DBA administrator the server support would be provided for various

industry verticals like Finance, Telecom, Travel & Transportation, Healthcare, Government etc. This role

would give an opportunity working on multiple and complex databases for fortune 500 customers which

have impact on their data related to AI/ML products/models of the company.

About the Company:

We are America’s oldest machine learning solutions company. With offices across US, China and India,

we hire people with a broad set of technical and domain skills who can contribute to the creation of

machine learning solutions across verticals such as financial services, telecommunications, healthcare,

consumer products etc.

Preferred Qualification:

(Must have)

· Three years or above working experience, more than two years in MySQL, familiar with MySQL

database architecture.

· Have good experience in database troubleshooting and solutions for the whole system chain,

including OS, Database, storage, network, application, cloud and so on.

· Familiar with SQL tuning, know about how to split large tables in MySQL.

· Familiar with the daily backup and restore operations of MySQL, and know about the HA

principles of MySQL replication and MySQL Cluster. Experience in PostgreSQL is preferred.

· Familiar with Linux operating system, be able to write daily scripts with Shell/Python.

· Experience about NoSQL databases is preferred, such as MongoDB, Redis.

· Experience about distribution databases is preferred, such as Greenplum, Clickhouse.

· Oracle DBA or SQL Server DBA working experience is preferred.

· Careful work, strong sense of responsibility, good learning ability and team spirit.

Responsibilities:

· Responsible for the daily maintenance and troubleshooting for all Databases, such as MySQL

and postgreSQL, make sure all database system running safely and stably.

· Establish MySQL daily backup and recovery policies, and data security policies.

· Responsible for the design and implementation of Database tables, and large table split policy.

· Provided daily support to the development team and application team, such as database design

specification and performance tuning suggestions.

#HiringAlert

We are looking " Oracle DBA " for Reputed Client @ Permanent Role.

Work Experience: 8 - 10 years

Must Have Skills:

•Oracle Database Administration: In-depth knowledge of Oracle database administration (11g, 12c, 19c) and maintenance, including database architecture, backup and recovery, performance tuning, and security.

•Disaster Recovery: Knowledge of disaster recovery planning and execution, including developing and implementing backup and recovery strategies, and testing disaster recovery plans.

•Oracle Apex installation, upgrade and troubleshooting skills

•Oracle Real Application Cluster (RAC) skills and troubleshooting knowledge in depth.

•Hands on experience in RMAN cloning. Data pump export & import

•Standby and Dataguard skills

•Db upgrade experience. (12C to 19C)

•OEM knowledge.

•DB patching skills.

•Cloning experience through RMAN, Datapump, Cold, Hot backup etc.

•Should work individually and to provide suggestions to the client in all aspects related to database support

Good To Have Skills:

Communication:

•Good communication skills to work collaboratively with other teams and to communicate effectively with customers.

•Soft skills: Strong interpersonal skills, including teamwork, to work effectively with stakeholders and team members.

•Oracle Real Application Cluster (RAC) skills and troubleshooting knowledge in depth.

•Oracle Apex installation and troubleshooting skills

Key Responsibilities:

•Maintains responsibility, accountability, and credibility in all work and research assignments and sustained ability to be highly self-motivated and directed

•Documentation and Reporting: Documenting project activities and maintaining accurate records, as well as generating reports to inform management and stakeholders about project status and issues.

•Monitoring and Troubleshooting: Monitoring system health and proactively identifying and troubleshooting issues to ensure high system availability and uptime.

•Cloning and Refreshing: Cloning and refreshing Oracle environments for testing, development, and production purposes.

•Supporting for database RAC environment and Apex installation, upgrade, troubleshooting.

Location : Mumbai

07-13 years as an Oracle DBA with production support experience, including Oracle 10g and 11g.

07-13 years of experience as an Oracle Apps DBA with Oracle EBS 11.5.10 and R12

Strong understanding of Oracle RDBMS architecture

Hands-on experience with implementation, upgrade, and tuning of:

Large Oracle EBS environments, Oracle EBS in a production environment; throughout all stages of the lifecycle

Enterprise Manager Grid Control

Backup and recovery concepts, including RMAN

Oracle R12, Oracle RAC

Patch assessment and application in an EBS environment with activation of different modules

Performance Tuning (ie. Sql Queries)

Proven experience with multiple operating systems: Linux/Unix/Solaris/Windows

Strong verbal, written, organizational and documentation skills.

Ability to provide accurate and realistic effort estimates, commit and deliver accordingly

Ability to work in a fast paced environment with occasional non-business hours (evenings and weekends) flexibility and able to prioritize and juggle multiple projects.

Ability to work productively in a team environment and participate as a positive and cooperative team member.

MS in CS or BS/ BA in Computer Science with five years of relevant work experience.

Candidates should be flexible for Night shifts/Weekend Shifts

Preferred Skills:

Experience with Engineered Systems (ie. ODA's)

Oracle Data Guard

Oracle RAC/Multitenant architecture . WebLogic . OEM 13c/12c

R12.2 Upgrade Experience on multiple projects

Experienced with Oracle Identity Management product suite

Immediate Joiners preferred

Senior Oracle Database Administrator

Experience and CTC: 7 to 10 Years (20 LPA- 25 LPA)

Educational Qualification: B.Tech/ MCA

Location: Noida

Notice Period: Immediate to 20 Days

Required Skillsets:

DBA, RAC , RMAN, Perfromance tuning, Backup & recovery, Data guard

Primary Responsibilities

• Oracle database administration and basic understanding of performance Tuning
• Instance tuning, schema management, space management, disaster recovery, data replication, database refresh, and SQL programming and tuning
• Basic Understanding of Oracle RAC
• Basic Understanding of Oracle Data guard
• Understanding of UNIX shell scripting
• Knowledge of upgradation and Migration to higher version
• Should be ready for travel in India and abroad and open for working in any shift
• Good troubleshooting skills required and ability to handle production support
• Sound knowledge of Oracle Database Performance tuning
• Sound knowledge of RMAN backup and recovery procedure
• Ability to work across multiple global sites and working teams is imperative
• Experience with Grid Control, Performance Tuning and Diagnostic packs
• Should have worked on big Oracle development/UAT and production databases
• support across multiple hardware and software platforms including Solaris and AIX, HP-UX, LINUX is desired
• Ability to perform DBA activities that span multiple phases of database application life cycle
• Good understanding of Database performance tuning Oracle 11g & 10g
• Maintain standards and strategies for security, database objects and backup/recovery
• Validate that all physical database designs satisfy business requirements and meet standards to database objects, data integrity, security, performance and recoverability
• Understanding of Operating system like HP-UX, AIX, Solaris, Linux and storage
• Inventory of Best Practices , Automation scripts, SLA and KPI benchmark
• Must be self- motivated and well- organised

Job Location: Chennai

Client: A leading Indian IT major hiring for a leading insurance client

Experience: 5-9 Years

Primary skills: Filenet

Secondary Skill: IBM FileNet Capture/Oracle DBA/

Domain Skill: Technical Lead File Net

Detailed Job Description: 

• Overall 3-6 years of experience in IT. 
• Strong understanding of Application admin / Software Development Life Cycle 
• ability to work with a technical team to meet sure deliverables everyday. 
•  Must have 1-2 years of an experience in working in IBM FileNet, IBM Data Capture, Oracle DB 
•  Prefer to have 1-2 years of experience WAS, HA Configuration, Cantera storage & EMC ECS storage. 
• Must stay current on IBM, Windows, WAS… versions. 
• must have experience in managing workflow having API CALLs & Documaker to FileNET 
• having support experience dealing with interfaces from internal and external sources. 
• should be able to do deployment to production 
•  Applying patches to production with the GIT technical team. 
•  Excellent communication skills 
• Willing to work in 24x7 Shifts

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

Roles and Responsibilities:

• Installation, configuration and upgrading of Oracle server software and related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Take care of the Database design and implementation, including Patch Management and Version Control. Implement and maintain database security (create and maintain users and roles, assign privileges).
• Perform database/application tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (capacity planning).
• Work as part of a team and provide 24x7 support when required.
• Perform general technical troubleshooting and give consultation to development teams.
• Interface with Oracle Corporation for technical support.
• Analyse potential impact of problem resolution and take corrective measures when needed.
• Root Cause Analysis.

Education, Skills and Experience required:

• Engineering or Technical Degrees (BE/ B.Tech/ ME/ M.Tech/ M.Sc / MCA)
• Minimum 4 years of relevant industry experience.
• Must have experience on multiple Hardware and Software Environments and be comfortable with complex heterogeneous systems environments.
• Must be an Oracle Certified Professional DBA (11g or above) with hands-on experience of RAC, RMAN.
• Good understanding of the Oracle database, related utilities and tools and underlying operating system.
• Excellent knowledge of the physical database design and all Oracle backup and recovery scenarios.
• Developing, managing and testing back-up and recovery plans. Data archival and space management.
• Ability to perform both Oracle and operating system performance tuning and monitoring.
• Good knowledge of Oracle security management and Oracle data integrity.
• Experience in code/data migration, database change management and data management through the various stages of the development life cycle.
• Sound knowledge of both database and system performance tuning and implemented application systems.
• Should have the ability to handle multiple projects and deadlines.
• Male candidates preferred as the role requires working in shifts.