6+ Oracle GoldenGate Jobs in India

Position Responsibilities :

1. Prime focuses on installation, testing, and configuration for Oracle, ASM, backup/recovery, security, monitoring, maintenance, logging, HA, and DR setup.
2. Managing hundreds of Oracle databases using more innovative routines/tools to identify the opportunities for better security and availability 
3. Setup and manage Oracle OEM
4. Analyze, solve, and correct issues in real time
5. Bring standards across environments and products by developing SOPs.
6. Optimize day-to-day operations and bring efficiencies
7. Plan and implement industry best practices for the best utilization of available resources
8. Perform duties in compliance with Deltek, industry, and regulatory security and compliance standards as defined
9. Work with cross-functional teams to assist in application and hosting optimization
10. Respond effectively to high-priority issues and incidents when needed
11. Provide Technically expertise and training to internal and external teams for Oracle Administration
12. Work independently and with a global team on highly specialized projects
13. Provide on-call support as required
14. Perform duties in compliance with Deltek, industry, and regulatory security and compliance standards as defined.

Qualifications :

1. 10+ years of Oracle DBA experience, at least 4 of which are in 12c or newer with multitenancy in a virtualized environment, AWS is preferred
2. In-depth knowledge and extensive hands-on experience with Oracle, Grid, ASM, OEM, Fleet Management, RMAN, Data Guard, TDE, CMU, Patching, and other critical components of Oracle
3. In-depth knowledge of Pluggable Databases, Virtualize Platform, Linux OS environments, and operating system Internals
4. Thorough understanding of configuration options, configurable components, concepts, and technologies
5. Strong expertise and hands-on with installation, configuration, backup, and restoration of all data
6. Extensive experience in troubleshooting and maintaining 100+ database instances using a variety of tools
7. Experience with large-scale database management designs, best practices, and issues
8. Good experience with database scripting Shell/python scripting to manage effort-consuming tasks in a more innovative way
9. Excellent verbal and written communication skills
10. Excellent time management and prioritization skills with an ability to escalate concerns or questions
11. Data-driven solid analytical skills, ability to create reports and present decision-supporting data/patterns
12. A plus is knowledge and experience in OCI (Oracle Cloud Infrastructure), Snowflake, and Rubrik.
13. Individuals will be working European hours to support Denmark. 
14. Perform duties in compliance with Deltek, industry, and regulatory security and compliance standards as defined.
15. Improves and contributes towards the team's delivery process and raises change requests appropriately. Can estimate the effort required and ensure priority & urgency are understood. Ensures appropriate monitoring is in place.
16. Displays good skills in executing and creating solutions for toil reduction and efficiency. Exercises abilities in troubleshooting, critical thinking, and problem-solving.
17. I can handle all incidents and lead incident response with appropriate communication. I take a systematic approach to problems and see them through to the conclusion. 
18. Deliver business value by improving functional/product knowledge by executing best practices and contributing ideas toward innovation.
19. Ability to exercise analytical and technical thinking across multiple areas of responsibility.
20. When delivering tasks, collaborating, and managing feedback, the sphere of influence influences the supervisor, peers, clients, and other teams. Decisions' impact affects a wide range of teams or areas of responsibility and facilitates the crafting and implementation of strategies.

Job Description & Responsibilities:

Selected engineer's day-to-day responsibilities include:

• Performs Database Administration tasks in Oracle & MS/MY SQL. Also performs basic DBA tasks in

SQL Server and DB2 environments as necessary.

• Designs and builds simple to complex database structures from data models.

• Installs, configures and patches Oracle.

• Implements HA and DR systems using Data guard and RAC.

• Builds and manages Data Guard Physical/Logical Standby Databases using Data Guard Broker

• Provides rotating 24x7 on-call support for company's Oracle, SQL Server, and DB2 environments as

necessary.

• Participates in design reviews as required to ensure database design meets application

requirements.

• Designs, maintains, documents and executes database utilities to provide information regarding

database activity.

• Proactively performs database monitoring and performance tuning tasks.

• Identify and provide solutions to performance issues in multiple database environments.

• Provides automation to standard DBA tasks. Able to develop scripts on UNIX and Windows

platforms as necessary.

• Reviews and enforces adherence to the company's Architecture, as well as database design and

usage standards.

• Understands database high availability technologies and guides the company in implementing

appropriate solutions.

• Performs other duties as assigned.

Location : Chennai, Tamil Nadu

Joining : Immediate – 15 days

Education, Experience & other requirements

• B.S. degree from an accredited university.

• Must have solid Oracle RAC , Golden Gate & Data Guard experience.

• 3+ years of extensive experience with Oracle database installation / configuration best practices

and Database upgrade/migration approaches.

• Experience installing, building, upgrading and supporting Oracle RAC environment, ASM,

Grid/Cluster.

• In-depth knowledge and hands-on experience in the installation, configuration and

troubleshooting of Oracle products and patches, including Oracle 12c, RAC, ASM, Clusterware,

GoldenGate, Dataguard, Oracle Database Appliance (ODA), Oracle Enterprise Manager 12c.

• Experience in Oracle 12c RAC based environment - architecture, installation, building, upgrading

and maintenance of Oracle RAC based environment in production.

• Extensive experience in Oracle DataGuard replication and physical standby for Disaster recovery

• Working experience of Oracle Database Appliance.

• Strong knowledge of OEM 12C grid monitoring configuration.

• Strong working experience with RMAN configuration, Job maintenance and backup & recovery

• Experience in database problem identification, problem diagnosis and resolution.

• Experience in building data architecture models and enforcing enterprise architecture standards

and guidelines.

• Excellent communication – ability to explain a technical problem to management.

• Ability to work on high performing teams and deliver under pressure situations.

Job Description.

DB developer 

This position is for Oracle Golden Gate developer and DBA position. The Candidate will implement and support Oracle Golden Gate replication components across many databases. Working closely with many application teams and implementing near real time replications with golden gate. Candidate should provide operational support as well.

Roles and responsibilities :

Configure and build Golden Gate Extracts/replicate for multiple databases.

Configure error handling for restart, logging, production support and status reporting in Golden Gate.

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

Provide Golden Gate solutions :

- Working with Oracle on SRs for critical issues.

- Strong oral and written communication skills along with problem solving skills.

Individual with min experience of over 5+ years on SQL Server

• Good Experience in SQL Server Installation and Configuration
• Backup and Recovery
• Security management
• Troubleshooting & Monitoring
• SSIS/SSRS/SSAS

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.