5+ Oracle DBA Jobs in Delhi, NCR and Gurgaon | Oracle DBA Job openings in Delhi, NCR and Gurgaon

·      Problem-Solving Skills, should be able to convert Idea on Paper to Code

·      Bachelor’s degree in computer science or related field, or equivalent professional experience.

·      0 - 4 years of database experience (Oracle SQL, PL/SQL)

·      Proficiency in Oracle, with Hands-on experience in database design

·      Creation & implementation of data models.

·      Strong experience with Oracle functions, procedures, triggers, packages.

·      Willing to learn, grasp & quickly adapt needed cutting-edge tools & technologies in shorter timeframe.

·      Should be able to write basic Procedures & Functions.

Role: My SQL DBA

Work Location: Noida/Hyderabad

Exp : 3+ Yrs

About the Role:

The ideal candidate would be working on the servers which impact various SaaS AI/ML products and

1000+ models in AI/ML. As a DBA administrator the server support would be provided for various

industry verticals like Finance, Telecom, Travel & Transportation, Healthcare, Government etc. This role

would give an opportunity working on multiple and complex databases for fortune 500 customers which

have impact on their data related to AI/ML products/models of the company.

About the Company:

We are America’s oldest machine learning solutions company. With offices across US, China and India,

we hire people with a broad set of technical and domain skills who can contribute to the creation of

machine learning solutions across verticals such as financial services, telecommunications, healthcare,

consumer products etc.

Preferred Qualification:

(Must have)

· Three years or above working experience, more than two years in MySQL, familiar with MySQL

database architecture.

· Have good experience in database troubleshooting and solutions for the whole system chain,

including OS, Database, storage, network, application, cloud and so on.

· Familiar with SQL tuning, know about how to split large tables in MySQL.

· Familiar with the daily backup and restore operations of MySQL, and know about the HA

principles of MySQL replication and MySQL Cluster. Experience in PostgreSQL is preferred.

· Familiar with Linux operating system, be able to write daily scripts with Shell/Python.

· Experience about NoSQL databases is preferred, such as MongoDB, Redis.

· Experience about distribution databases is preferred, such as Greenplum, Clickhouse.

· Oracle DBA or SQL Server DBA working experience is preferred.

· Careful work, strong sense of responsibility, good learning ability and team spirit.

Responsibilities:

· Responsible for the daily maintenance and troubleshooting for all Databases, such as MySQL

and postgreSQL, make sure all database system running safely and stably.

· Establish MySQL daily backup and recovery policies, and data security policies.

· Responsible for the design and implementation of Database tables, and large table split policy.

· Provided daily support to the development team and application team, such as database design

specification and performance tuning suggestions.

JD:

• Experience in maintaining Oracle Exadata, RAC, and Administration of Oracle Multitenant Architecture.
• Implemented below Exadata new features like Smart scan, Flash cache, flash log, IORM, Storage indexes
• Using CellCli or dcli to manage Exadata storage server objects.
• Monitoring cell disk, grid disk, cell flash cache, flash disk
• Configured dcli between cell nodes and database nodes.
• Monitoring Exadata storage servers with cell metrics alerts and active requests.
• Migrating legacy database to Exadata.
• Experience in Exadata patching
• Experience in RAC along with new features like Flex ASM and Flex cluster.
• Resolve the issues like replace damaged physical disk or Flash disk.
• Installing & configuring Oracle Cluster ware & Database Software for Oracle 12c and 19c.
• Extensive Knowledge on Oracle Multitenant Architecture 12c and 19c.
• Experienced in Oracle installations, upgrades, migration, cloning, designing logical/physical architecture
• Database Refresh using Data pump.
• Expertise in Database upgrades, patching for standalone & RAC databases.
• Experienced in Database Point in Time Recovery.
• Enforcing security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts.
• Knowledge on oracle enterprise management
• Implementation of db compression using Exadata HCC
• Running ExaCheck reports monthly 
• Implementing smart flash cache, enabling flash cache write back
• Hardware changes , flash disk, griddisk and DIMM replacements
• Working knowledge on managing NFS mount points.
• ZFS share creation
• Huge pages setting

Job Summary

At PwC, our purpose is to build trust in society and solve important problems. We’re a network of firms in 157 countries with more than 208,000 people who are committed to delivering quality in Assurance, Advisory and Tax services.

Within Advisory, PwC has a large team that enables government organisations to transform and provide better service to citizens and optimize operations. The open position is for a candidate who desires to work with government clients and bring about a change in society. A successful candidate will be expected to work pro-actively and effectively on multiple client engagements over the period of time and take ownership of the entire project delivery he/she entrusted with.

Proposed role requires a candidate with relevant experience in Enterprise/Solution Architecture. He/She would have lead the process improvement and solution conceptualization and handled large integrations involving the latest technologies in the field of solution architecture. The architect should have a successful track record in managing and implementing e-government projects with particular focus on business components, and has contributed to the IT Strategy, maintenance of the information strategy and use architecture to support business and process change.

The candidate should strong interpersonal skills, who not only enjoys the challenge of working with other team members but externally with a diverse, senior-Government officials across varied Ministries and PSUs. Recent experience and understanding of the Indian business ecosystem and government initiatives is a must.

The candidate will be required to showcase excellent communication skills and will have demonstrated consistently the skill and capability in delivering impactful and insightful projects in the past. He/she will also be required to participate in client meetings and, during the course of a project, will be responsive to client enquiries, eventually leading the delivery engagement.

They will also be expected to contribute to Practice or Firm development. This may be adjudged in various ways such as serving as a mentor to other team members, by leading training/development initiatives, contributing to thought leadership papers, assisting other network firms etc.

Positions are with PwC’s Government and Public Service (G&PS) practice, which works

with Central & State Governments, PSUs, donor agencies etc. The position can be based in Delhi or Kolkata. However the ideal candidate should not have any constraints to travel for work related opportunities, whether domestic or internationally.