Database Administrator (Oracle) PearlTech Consultancy Private Limited

About PearlTech Consultancy Private Limited

PearlTech Consultancy, an ISO 9001, ISO 20000, and ISO 27001-certified managed service provider, utilises extensive technological and industry expertise to help businesses optimise their operations, thereby fostering sustainable growth and increased profitability. Our track records speak for themselves: since 2015, we have been revitalising the businesses of their multinational clients.

Job Description

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

Salary Range : 6 – 8 LPA

Education, Experience & other requirements

• B.S. degree from an accredited university.

• Must have solid Oracle RAC , Golden Gate & Data Guard experience.

• 3 - 4 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.