SME - Oracle Administration,PostgreSQL,MYSQL, MS SQL
India
Job Description
SME - Oracle Administration,PostgreSQL,MYSQL, MS SQL
Chennai, Tamil Nadu

Job Summary

Total Experience - A minimum of 10 to 12 years of proven experience in database engineering and migrations, including designing, modernizing, and operating Oracle database platforms on AWS (RDS/EC2-hosted databases) with strong focus on performance, security, HA/DR, and automation. We are seeking a skilled Cloud/Database Engineer with strong hands-on experience migrating Oracle workloads to AWS. The ideal candidate will lead end-to-end assessment, schema and code remediation (as needed), data replication/CDC, cutover planning, and post-migration optimization for Oracle environments moving to Amazon RDS for Oracle or Oracle on Amazon EC2, ensuring secure and low-downtime transitions.


Key Responsibilities

· Plan and execute migrations of Oracle databases from on-premises, hosted environments, and engineered systems (as applicable) to AWS (Amazon RDS for Oracle and/or Oracle on Amazon EC2).

· Use AWS migration services and Oracle utilities (e.g., AWS Database Migration Service (DMS), AWS Schema Conversion Tool (SCT) when required for conversions, Oracle Data Pump, RMAN, and CDC/replication approaches where applicable) plus scripting/automation to support large-scale, repeatable migrations.

· Design migration runbooks (discovery/assessment, PoC, replication/CDC, cutover, rollback) including data validation and integrity checks, Oracle feature compatibility review (e.g., options/packs), encryption considerations (e.g., TDE), and minimal downtime execution.

· Perform Oracle performance tuning and operational readiness on AWS (parameter tuning, indexing, AWR/ASH analysis, backup/restore strategy, maintenance automation, and monitoring using CloudWatch and Oracle tooling).

Skill Requirements

1. Strong Expertise In Oracle Administration And Postgresql.
2. Proficiency In Mysql And Ms Sql Administration.
3. Solid Understanding Of Service Level Agreements (Slas) And Quality Compliance Metrics.
4. Ability To Conduct Root Cause Analysis And Trend Analysis.
5. Excellent Communication Skills For Stakeholder Engagement And Mentoring.

Other Requirements

Qualifications:

· 5+ years of hands-on AWS database migration experience, with primary focus on migrating Oracle databases to AWS.

· Strong Oracle DBA experience (installation/configuration, security, backup/restore with RMAN, Data Guard concepts, patching/upgrades, troubleshooting and performance tuning).

· Working knowledge of AWS database and migration services (Amazon RDS for Oracle, Oracle on EC2, DMS, SCT where applicable) and fundamentals of VPC, security groups, KMS encryption, and IAM.

· AWS Certification preferred (e.g., AWS Certified Database 01 Specialty or AWS Certified Solutions Architect) and/or Oracle certification (e.g., Oracle Certified Professional).

Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.

23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.