| | Job Description | Job Description: - Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
- Experience 7 Plus years in relevant domain.
- Postgres RDS .
- AWS Oracle RDS instances, ensuring the latest features and bug fixes were implemented
- 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.
Skill:
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). | 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. | |
