Key skills
AWSCloudGoogle Cloud PlatformJavaOracleShell ScriptingSplunkSQLUnixShellUnit TestingGCPGoogle CloudGitCI/CDCommunicationCollaboration
About this role
Role Overview
- Responsible for OLTP Database Maintenance and Support.
- Responsible for Impact Analysis, Performance tuning of database Objects.
- Responsible for Modifying Stored procedures, database Packages etc.
- Provide Level 1,2 and 3 support for the database.
- Handle critical Incidents and Problems raised due to the database related issues.
- Handle database updates(DML and DDL) operations.
- Analyze Splunk logs and find Root causes and assist Incident Managers.
Requirements
- 7+ years of experience as a Oracle Developer.
- Excellent skills in Oracle SQL/PLSQL programming.
- Expert in using log monitoring tools like splunk.
- Expert in Oracle Performance Tuning
- Expert in understanding Physical design aspects like partitioning, clustering, indexing etc.
- Expert in reading Explain plan, TKProf outputs etc and recommend performance tuning options.
- Good Knowledge of Unix and Shell Scripting.
- Basic understanding of Java.
- Good Knowledge of Cloud Platforms like AWS/GCP.
- Good knowledge of Git and CI/CD pipelines.
- Good knowledge of Unit testing using UTPLSQL or any other frameworks.
- Good communication and collaboration skills.
Tech Stack
- AWS
- Cloud
- Google Cloud Platform
- Java
- Oracle
- Shell Scripting
- Splunk
- SQL
- Unix