Oracle Database Administrator

3 weeks 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

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

  • Data Entry Operator

    2 weeks ago

    Jamshedpur, India Quest Business Solution Full time

    Assembling, arranging, and getting ready papers, materials, and data for data input. - Doing research to gather data for missing papers and materials. - Converting paper or voice recordings into digital documents. - Checking the accuracy of all documents and information, and notifying the supervisor of any mistakes or discrepancies. - Establishing frequent...

  • Office Executive

    1 week 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

    6 days 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

    2 months 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

    4 weeks 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 Engineering Manager

    4 weeks 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 Network Infrastructure Manager

    2 months 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, 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...