Oracle DBA + AWS

Oracle DBA & AWS RDS/EC2 JD

Primary Skills: AWS RDS Administration /L3 Production Support/Unix

Must Have: Migration of On-premises 11g/12c databases to AWS RDS/EC2 19c databases.

Secondary Skills: SQL-Performance Tuning/terraform/Jenkin. 

Role purpose:

• Knowledge of Database Administration and Architecture

• Administered Production Databases & have knowledge of different Oracle versions from 12c, 19c & AWS RDS

• Knowledge of S3 and EC2

• Should have knowledge of database migration from OnPrem to EC2 and administration.

• Should have knowledge of database migration from legacy to Cloud (AWS)

• Should have knowledge of upgrade from older to latest oracle versions 

• Knowledge of Enterprise Manager, RAC, Performance Tuning, Database Development

• Should have knowledge of Active-Passive Cluster 

• Support Database Operations with working close to application team.

• Should have worked with tools like Remedy, Oracle Enterprise manager, Oracle Support

• Should accomplish on call support for Database during peak times & ready to work in 24/7 environment

• Should have Support knowledge for Database upgrade, Migration and perform production checks

Key accountabilities (Role Description):

• Ensure availability and performance of All Production Databases.

• Manage Database Operations support along with performance tuning & PL-SQL & Unix scripting.

• Advance knowledge at UNIX Level is mandate to handle jobs, batch process and tune existing processes or create a new one accordingly.

• Work on incidents, service-requests and change requests from the user departments.

• Should have minimal introductory knowledge of database connection to middleware & other application tiers.

• Experience for working with an international team.

• To come up with ideas to enhance the monitoring and maintenance of systems.

Desired Profile:

• To analyse performance bottlenecks. Identifying issues causing application-functionality slowness (scripts/pl-sql-code/user-generated queries).

• Knowledge on Enterprise Manager, RAC and Database Architecture

• Monitor & Participate in Auditing & SOX Compliance activities.

• Profound knowledge of UNIX, Oracle SQL, Shell-Scripting and at least one scripting-language (e. g. Perl)

• To have proficient application database support operations skillset with minimal 4 to 6yrs of experience.

• To Deliver/Develop environment support/maintenance scripts for atomization, BAU operational activities to smoothen/stabilize system.

• Telecom Knowledge would be added advantage.           

Behavioural/ Personality Specifications Required:

• Should have excellent communications skill.

• A good team member and one keen to learn new technologies.

• Professional Certifications like 12C OCP, AWS Cloud Practitioner, Oracle 19c RAC administration would be preferred.

• B.E candidates would be preferred first.