Oracle Database Administrator

1 month ago

Jamshedpur, India Wizertech Informatics Pvt Ltd Full time

Day to day Database administration and Production Support.
- Use problem and change management tools.
- Support mission critical databases for customer, where any unscheduled downtime will result in major business loss.
- Manage incidents at Customer account.
- Database Security Administration
- Maintain Configuration details
- Proactive system monitoring and support
- Level 2/Leve 3 ticket resolution
- Basic monitoring and tuning
- Backing up and recovering databases
- Basic understanding of database security issues
- Database design
- Good knowledge of DBMS series of packages
- Command over SQL and PL/SQL
- Query & DB Performance tuning experience
- GUI and command line usage
- Should have sound knowledge Oracle RAC / Non-RAC Architecture (SGA/ PGA / Background processes / Physical Logical Structure of database) with parameters settings.
- Should have knowledge / hands-on experience with CDB / PDB such as create, clone & drop.
- Should have hands-on experience of database activities such as Start-up / Shutdown cluster & Standalone DB.
- Should have hands-on experience of RAC / Non-RAC databases such as parameters change, spfile backups.
- Hands-on experience to create datafiles, add datafiles, remove datafiles, resizing datafiles in RAC / Non-RAC databases.
- Hands-on experience to create schema, change schema profiles, password management, tables/schema management.
- Hands-on experience to run scripts in database or schema, experience of gather stats such as DB stats, schema or table / indexes stats.
- Should have hands-on experience with RMAN Backup and knowledge of recovery scenarios.
- Experience in Cloning databases using various methodologies like cold, hot refresh, expdp / impdp and RMAN on different platforms.
- Should have experience/Knowledge to generate AWR, ADDM, ASH, Query running history reports etc.
- Knowledge of Oracle Database Upgrade, Database Clone using RMAN, Data Guard Setup / Switchover and aware of maintenance activities, configure / maintain database processes/services to ensuring high availability with security.
- Experience of Oracle GRID and Client Software Installations.
- Should have experience of Incident Management and Problem Management, RFC Handling Process and Ticket Handling Process with ServiceNow tool.
- Knowledge of Alert setup and Monitoring multiple databases with tools such as OEM, TOAD etc.
- Should have troubleshooting skills such as connectivity issues, Scan /Local listener, password issues, Oracle code compilation issue, fix query plans
- Should have hands-on experience with Unix OS commands
- Should have good communication skills

**Salary**: ₹329,952.78 - ₹1,421,228.96 per year

**Benefits**:

- Health insurance
- Paid sick time
- Provident Fund

Schedule:

- Day shift
- Health insurance

  • Office Administrator

    5 days ago

    Jamshedpur, India Skilled Human Resource Consultants Pvt. Ltd. Full time

    **Responsibilities** - Coordinate office activities and operations to secure efficiency and compliance to company policies - Supervise administrative staff and divide responsibilities to ensure performance - Manage agendas/travel arrangements/appointments etc. for the upper management - Support budgeting and bookkeeping procedures - Create and update records...

  • Back Office Coordinator

    1 month ago

    Jamshedpur, India Dirums Collective Private Limited Full time

    e are seeking a Back Office Coordinator to join our dynamic ecommerce marketplace team. As a Back Office Coordinator, you will be responsible for supporting the day-to-day operations of the business by performing administrative and operational tasks. **Responsibilities**: - Handle data entry and database management tasks to ensure accurate and up-to-date...

  • Office Executive

    4 weeks ago

    Jamshedpur, India Active Construction Company Full time

    Company: Active Construction Company Location: Jamshedpur, Jharkhand **Responsibilities**: 1. Data Entry: Accurately input and maintain data into the company's systems and databases. Ensure data integrity and confidentiality at all times. 2. Reporting: Generate and compile reports as required by management. This may include financial reports, project...

  • Quality Associate

    4 weeks ago

    Jamshedpur, India Asoka Sky Metals Private Limited Full time

    Research potential vendors - Compare and evaluate offers from suppliers - Negotiate contract terms of agreement and pricing - Track orders and ensure timely delivery - Review quality of purchased products - Enter order details (e.g. vendors, quantities, prices) into internal databases - Maintain updated records of purchased products, delivery information and...

  • IT Engineering Manager

    1 month ago

    Goa/Kolkata/Jharkhand/Ranchi/Jamshedpur/Coimbatore/Chennai/Hyderabad, IN Aricent Full time

    Profile : IT Manager (Engineering)Job Description :- A Successful candidate will have a background in building and operating large scale Digital Commerce and search capabilities and hands-on approach to leading software development, great project management and communication skills and an eagerness to grow with a team as they take on increasing...

  • IT Engineering Manager

    2 months ago

    Goa,Kolkata,Jharkhand,Ranchi,Jamshedpur,Coimbatore,Chennai,Hyderabad, India Aricent Full time

    Profile : IT Manager (Engineering)Job Description :- A Successful candidate will have a background in building and operating large scale Digital Commerce and search capabilities and hands-on approach to leading software development, great project management and communication skills and an eagerness to grow with a team as they take on increasing...

  • IT Network Infrastructure Manager

    1 month ago

    Goa/Kolkata/Jharkhand/Ranchi/Jamshedpur/Guwahati/Srinagar/Jammu & Kashmir/Jammu/Patna/Hyderabad/Wara, IN Aricent Full time

    Role : IT Network Infrastructure ManagerJob Description :Job Summary :- This is an exciting position for a candidate at a middle management level with a competence to manage technology infrastructure and assets across all locations and coordinate with the team to maintain and support the company's technology hardware and software. - You would also be...

  • IT Network Infrastructure Manager

    4 weeks ago

    Goa/Kolkata/Jharkhand/Ranchi/Jamshedpur/Guwahati/Srinagar/Jammu & Kashmir/Jammu/Patna/Hyderabad/Wara, India Aricent Full time

    Role : IT Network Infrastructure ManagerJob Description :Job Summary :- This is an exciting position for a candidate at a middle management level with a competence to manage technology infrastructure and assets across all locations and coordinate with the team to maintain and support the company's technology hardware and software. - You would also be...