Database Administrator - Oracle & AWS Cloud

ECMS REQ ID

545077

Number of Openings

1

Country

India

Detailed JD (Roles and Responsibilities)

Job Description:

Database Administrator OnPrem and AWS Cloud having hands on experience in database creation, administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, trouble shooting .

Environment:AWS(Redshift,S3,EC2,Lambda,RDS,IAM),Postgresql,Oracle(10g,11g, 12c,19c), Aurora Global DB, Oracle Data guard, Solaris 10, SQL, PL,SQL, AIX 5.1, Shell scripting, OEM (12c,13c), SecureCRT, WinSCP ,Putty, SQL developer, TOAD, SQL Workbench, ER Studio (2016,2018).

• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• Experience 6 Plus years in relevant domain.
• Worked extensively on Oracle Version Upgrade, Migrations and Patching.
• Configured and implemented different types of Advanced Replication Models of distributed databases.
• Knowledge on Golden Gate.
• Dealing with database security and auditing.
• Worked as a team member to provide 24x7 on call support production database support.
• AWS Cloud experience.
• Worked on AMAZON Redshift databases.
• Planned and Implemented DR & High Availability oracle solutions using Data Guard.
• Extensive experience in Database Administrator managing Oracle RDS, AWS Aurora Postgres and Redshift databases.
• Orchestrated seamless Data Migration from Oracle RDS to Redshift using DMS ensuring minimal downtime and data integrity.
• Oversaw Upgrades for Aurora Postgres and AWS Oracle RDS instances, ensuring the latest features and bug fixes were implemented

Database: AWS (Redshift,RDS) ,Oracle 9i/10g/11g/12c/18c/19c, POSTGRESQL.

Technologies and Tools: AWS(VPC,Redshift,IAM,KMS,EC2,RDS,S3, Cloud Watch, Auto Scaling,),Oracle,OEM, Export, Import, Data Pump, RMAN,SQL Loader, Log Miner, PL/SQL, DB Solo 3.0, Spotlight, Win SCP, Putty, ER Studio.

Total Experience

6 Years

Relevant Experience

6 Years

Work Location

Any India DC

WFO / WFH / Hybrid

Hybrid

Vendor Rate in currency of Work Location

10,000 INR/Day - depending on the candidate's experience.

Contract duration (in months)

6 Months

Shift Details (Time)

General

Notice Period (Availability)

Immediate - 30 days