5+ Oracle Data Guard Jobs in India

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 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.

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