Senior Database Administrator-Redshift_oracle

Company Description

TechMantra Global is a technology, consulting, and outsourcing company.

We partner with global technology companies like Microsoft, Salesforce, Oracle, and Sitecore to deliver end-to-end IT solutions. Our specialized services include Salesforce CRM, cloud solutions like Azure, Azure data factory, Azure DevOps, Power Apps, and BI tools like Power BI and other analytics solutions. We are dedicated to helping organizations design and deploy complex IT solutions with ease and perfection.

Role Description

This is a full-time hybrid role for a Senior Database Administrator-Redshift_oracle. The Senior Database Administrator will be responsible for the day-to-day management of databases, including administration, design, troubleshooting, and replication. This role will be based in Pune with flexibility for some remote work.

Qualifications

• Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
• 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 onAMAZON Redshift databases.

Planned and Implemented DR & High Availability oracle solutions using Data Guard.

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

Database:

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

Technologies and Tools:

AWS(VPC,Redshift,IAM,KMS,EC2,RDS,S3, Clouud 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.