As a part of Infosys, you will play a key role in helping clients achieve their digital transformation goals by leading the migration of databases from on-premises environments to AWS Cloud.
Experience. 3 – 10 years
Responsibilities
- Design & Implement Database Migrations. Lead heterogenous and homogenous database migrations from on-premises Oracle/SQL Server to AWS RDS (Oracle/SQL Server/Aurora PostgreSQL).
- Leverage AWS Services. Build and implement database migration factories using AWS services, including RDS, Aurora, EC2, SCT, DMS, S3, EBS, and Data Pipeline.
- Native Backup & Restore. Handle database backups and restores using tools like Export/Import, RMAN, Transportable Tablespaces, Oracle Data Guard, and SQL Server SSMS.
- Database Programming. Develop in PostgreSQL (PSQL), Oracle PL/SQL, SQL Server T-SQL, and PowerShell, with a focus on high performance and scalability.
- Troubleshoot Performance Issues. Resolve database performance problems during migrations.
- SSIS & SSRS. Implement and manage SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
- Infrastructure as Code. Automate cloud infrastructure setup using Terraform or CloudFormation, ensuring efficiency and repeatability.
- High Availability & Disaster Recovery. Design and implement database high availability (HA) and disaster recovery (DR) solutions on AWS using Multi-AZ and multi-region replication.
- Cloud Architecture & DevOps. Manage cloud architecture and cloud resources for optimized performance, scalability, and cost efficiency. Implement CI/CD pipelines using AWS services.
- Security & Compliance. Ensure adherence to security best practices and compliance for all cloud solutions.
- Monitoring & Maintenance. Utilize AWS CloudWatch and other native tools to monitor cloud infrastructure and RDS databases. Provide operational support for incidents, changes, and problem management.
Technical Requirements
- Proficiency in Oracle, SQL Server, and PostgreSQL database administration
- Experience with native database backup and recovery methods, including Oracle Data Guard and RMAN
- Programming experience in PSQL, PL/SQL, T-SQL, and PowerShell
- Expertise in AWS cloud services, including RDS, EC2, and CI/CD pipelines
- Hands-on experience with Terraform or CloudFormation for infrastructure automation
- Knowledge of database performance troubleshooting and database HA/DR solutions on AWS
- Familiarity with SQL Server SSIS and SSRS
- Knowledge of AWS monitoring tools like CloudWatch
Join Infosys to be part of a dynamic team that plays a critical role in helping businesses navigate their digital transformation journey with cutting-edge cloud solutions. If you’re passionate about database management and cloud technologies, we invite you to apply and contribute to exciting projects at the forefront of innovation.