5+ Oracle GoldenGate Jobs in India

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.