Database Administrator

Mastech Digital

5 years

0 Lacs

India

Posted:1 week ago| Platform:

Apply

Skills Required

database oracle exadata programming development sql tuning indexing indexes architecture query coordination automation scheduling support data goldengate replication optimization monitoring configuration logical processing informatica etl jira workflow agile toad

Work Mode

On-site

Job Type

Contractual

Job Description

Required Skills and Experience:

Working knowledge of Oracle 19c/Exadata added capabilities and functionality.
Strong programming/development skills using PL/SQL (package, procedures, functions, triggers) a plus.
Proficient in performance tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, and Hints.
Strong knowledge of database triggers, indexes, and partitioning.
Expertise in Oracle architecture.
Proficient in reading Query Execution Plans with the ability to evaluate and improve performance characteristics of SQL.
Manage database objects like table space, users, indexes, roles, privileges, profiles, and synonyms.
Coordination with the automation team for the scheduling of various AWA jobs to be executed on multiple databases.
Support ongoing efforts and provide technical support for multiple database re-platforming efforts to Exadata.
Reviewing and implementing data loading scripts related to GoldenGate data replication.
Optimization and tuning of SQL queries and indexes in Oracle.
Monitoring of the database performance as it relates to memory usage, proper backups, active sessions, long-running queries, tablespace configuration, and space allocations.
Coordinate with data architects and analysts on the building of schemas, tables, functions, views, stored procedures, and roles.
Provide DBA supervision and Oracle best practices guidance for custom application development and routine database administration efforts.

Essential Skills and Competencies:

5+ years of logical and physical DBA experience, including experience in Oracle Exadata.
Extensive working knowledge of all aspects of Database Data Movement and Processing, including GoldenGate and Informatica ETL.
Familiarity with JIRA workflow processes and agile methodology.
Working experience with TOAD or Oracle SQL Developer.

More Jobs at Mastech Digital

Reltio Architect

India

5 - 5 yrs

Salary: Not disclosed

Staff Engineer- Java

Bengaluru

12.0 - 18.0 yrs

INR 15 - 30 Lacs

Innovation Lead/Artificial Intelligence

Chennai, Tamil Nadu, India

Experience: Not specified

Salary: Not disclosed

US Payroll Assistant Manager

Noida, Uttar Pradesh, India

6.0 - 6.0 yrs

Salary: Not disclosed

US Revenue Assistant Manager

Chennai, Tamil Nadu, India

6.0 - 6.0 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.