Role : Associate Architect - Database Specialist (SQL/Oracle)
Experience : 7-13 Years
Location : Mumbai/Bangalore
Key Responsibilities
- Lead end-to-end Oracle/SQL server database migration from on-prem (including Exadata) to AWS platforms such as Amazon RDS, EC2, and Aurora PostgreSQL-compatible environments
- Ensure transaction continuity, CDC-based replication, and minimal downtime cutovers
- Perform Oracle database performance tuning, indexing strategies, and query optimization prior to migration
- Design and execute schema conversion and validation strategies (Oracle to PostgreSQL/MySQL where applicable)
- Leverage AWS DMS and SCT for full load and continuous replication migrations
- Work with ODI pipelines and existing ETL workflows, ensuring compatibility or modernization on AWS (Glue/EMR)
- Design and implement secure, highly available database architectures on AWS
- Build and optimize data pipelines using AWS Glue, PySpark, or EMR
- Manage S3-based data lakes and metadata using Glue Data Catalog
- Collaborate with application, infrastructure, and analytics teams for smooth migration and post-migration stabilization
- Implement data validation, reconciliation, and rollback mechanisms
- Ensure compliance with security, governance, and regulatory standards (GDPR, HIPAA, etc.)
Must Have:
- 7+ years of experience in database administration and migration (SQL Server, Oracle, MySQL).
- Strong hands-on experience with Oracle databases, including Exadata environments
- Experience with Oracle Data Integrator (ODI) and legacy ETL workflows
- Proven expertise in Oracle performance tuning, partitioning, indexing, and transaction management
- Experience with Oracle migration tools (Data Pump, RMAN, GoldenGate - preferred)
- Experience migrating Oracle, SQL Server, and MySQL databases to AWS (RDS, EC2, Aurora)
- Hands-on with AWS DMS and SCT for full load and CDC replication
- Strong experience in database administration (HA, DR, backup/restore, schema conversion)
- Experience building pipelines using AWS Glue, PySpark, or Spark on EMR
- Strong experience with S3-based data lakes and Glue Data Catalog
- Strong SQL, Python/Pyspark, and shell scripting
Nice to Have:
- Experience with Aurora Global Database and cross-region replication
- Familiarity with Oracle GoldenGate for real-time replication
- Knowledge of Data Mesh architecture and cross-account data sharing in AWS
- Experience with Redshift, Lake Formation, and modern data warehousing
- Exposure to CI/CD pipelines for database and ETL deployments (CodePipeline, Jenkins)
- AWS certifications (Solutions Architect Associate / Data Engineer Associate)
- Experience mentoring teams and driving knowledge transfer sessions
- Experience with Infrastructure as Code (Terraform / CloudFormation)
