Experience : 7+ Years
Desired Competencies (Technical/Behavioral Competency)
Must-Have
· Installing, upgrading and maintaining the Oracle database software
· Familiarity with Oracle database design, coding, and architecture.
· Regularly updating the database security protocols patches.
· Hands-on experience in Oracle Goldengate Active-Active environment.
· Excellent knowledge of data backup, recovery, security, integrity, and SQL
· Experience and knowledge of SQL query and SQL Trace/Explain plan, SQL performance tuning.
· Setting up Oracle’s different parameters and options.
· Previous experience with DBA case tools (frontend/backend) and third-party tools
· Hands-on experience in installation and configuration and troubleshooting of Oracle products and patches, including RAC, ASM, Cluster ware, Data Guard, Grid/Cloud Control environments.
· Knowledge of creating and maintaining Tables, Partitioning, indexes, Triggers, stored procedures, etc. in a large terabyte database environment
· Experience with Oracle 19c-12c, (Oracle 12c, Oracle 19c ) Golden Gate, RAC, RMAN, Grid Control under AIX, and Red Hat Linux.
· Plan growth and changes (capacity planning) Sound knowledge of the SDLC and experience in code migration, database change management, and data management.
· Oracle technical certifications with rich experience in performance tuning and Golden Gate (if any) · Good knowledge of Oracle RMAN and data pump utility.
· Solid experience in Linux, Linux Shell scripting Experience, and PL/SQL coding
Good-to-Have:
· Excellent communication and interpersonal skills
· Ability to work independently and collaboratively in a fast-paced, team-oriented environment.
· Prior experience involving client/customer interaction.
· Experience in development on Oracle, MongoDB, Azure SQL, Azure Cosmos DB, Redis, and Kafka
SN Responsibility of / Expectations from the Role
1 Performance Tuning
2 Goldengate replication tuning and monitoring
3 Database upgrade and migrate
4 Oracle RAC