Job Title: Cloud Oracle DBA /Apps DBA (L2).
Location: Hyderabad
Experience: 5-7 years in the IT industry.
Education: B. Tech computer science or equivalent degree.
Job Description:
We are seeking a highly skilled full-lifecycle administration of Oracle (12c/19c), MySQL, PostgreSQL on Linux/Unix servers and Amazon on EC2 Specialist with 4-6 years of experience in the IT industry The ideal candidate will have a strong background on Oracle database administration & PLSQL concepts and Hybrid Database Administration Tasks.
Key Responsibilities:
- Database Administration: Installation, configuration, upgrades, PSU/RU patching, user and security management, tablespace and storage management.
- Monitoring & Performance: Database health checks, performance monitoring using New Relic, statistics gathering and tuning.
- CI/CD Support: Jenkins, Liquibase, Bitbucket (Deployment and Release Support).
- Troubleshoot and resolve any issues related to performance and application issues.
- Hands-on experience in database migration processes to AWS cloud environments.
- Migrated on-prem Oracle databases to AWS EC2 and Amazon RDS as part of cloud adoption projects.
- Performed Oracle to Aurora PostgreSQL schema conversion and data migration using AWS SCT and AWS DMS.
- Configured replication between on-premises and AWS databases for data synchronization during migration.
- Supported hybrid database environments during transition from on-prem to AWS.
- Worked closely with application teams to validate data consistency and application connectivity post- migration.
- Collaborated with application and infrastructure teams to resolve migration defects, ensuring minimal downtime and seamless user experience.
- Assisted in cutover planning, migration testing, and post-migration validation.
- Monitored migration performance and data integrity during migration activities.
- Lead On-Prem to AWS migration using AWS database migration service (DMS) for full load and change data capture (CDC) to ensure minimal downtime.
- Utilize AWS schema conversion (SCT) to access and convert legacy Oracle Schemas to PostgreSQL or MySQL Compatible formats.
- Execute legacy migration methods, when necessary, such as oracle Data pump, RMAN duplication or pg_dump/restore.
- Design and maintain high-availability solutions for Oracle Data Guard/RAC on-prem and multi-AZ deployment in AWS.
- Provide 24/7 level 2 support for production issues across all platforms, including deep troubleshooting of On-prem network latency and AWS RDS.
- Perform proactive tuning using oracle AWS/ASH reports for on-prem and Amazon Performance Insights for cloud instances.
- Implement unified security policies, managing AWS IAM database authentication alongside traditional On-prem user/role management.
- Required Skills: SQL Developer, PuTTY, WinSCP, MySQL Workbench, PG Admin, Bitbucket, Jenkins, Liquibase, New Relic, AWS SCT Tool, ServiceNow, Shell script.
- Experience in cloud technologies like AWS.
- Experience in CI/CD pipelines for DB scripts deployment using (Liquibase, Bitbucket).
- Experience in handling production releases.
- Experience in cloud migration activities.
- Understand the dependencies while migrate the apps from on-prem to cloud.
- Support Oracle 12c/19c databases in Standalone, RAC, environments across production, UAT, DEV, ST and non-production systems.
- Performed routine DBA activities (monitoring/maintenance activities).
- Perform installation, configuration, database creation, and upgrades, including 12c to 19c upgrades.
- Handle user management and security administration, including users, roles, privileges, profiles, and password compliance activities.
- Experience in vulnerability remediations.
- Collaborated with application teams during cutover planning, migration testing, and post-migration validation, ensuring smooth go-live and application stability.
- Experience in monitoring tools like, new relic and Splunk etc...
- Excellent communication skills, both written and verbal.
- Ability to work effectively with multiple client teams.
- Strong problem-solving and analytical skills.
- Ability to manage multiple projects and prioritize tasks effectively.
- Knowledge of industry standards and best practices in IT infrastructure and integration.
Qualifications:
B.Tech computer science or equivalent degree.
5-7 years of experience in the IT industry, with a focus on Database Administration tasks.
