Position Overview:
This individual will play a critical role in migrating our on-premises Oracle and SQL Server databases to AWS RDS and converting some of these databases to PostgreSQL. The ideal candidate will have extensive experience with AWS RDS, strong knowledge of database migration strategies, and the ability to work closely with our in-house database support team to ensure a smooth transition.
Key Responsibilities:
- Lead the migration of on-premises Oracle and SQL Server databases to AWS RDS.
- Convert select databases from Oracle/SQL Server to PostgreSQL.
- Develop and execute a comprehensive migration strategy, including planning, design, and implementation.
- Collaborate with the in-house database support team to transfer knowledge and ensure they are equipped to manage and maintain the new RDS environment.
- Perform database performance tuning and optimization in the new RDS environment.
- Ensure data integrity, security, and compliance throughout the migration process.
- Create detailed documentation of the migration processes, configurations, and best practices.
- Provide post-migration support and troubleshooting to ensure all databases are running efficiently on AWS RDS.
- Stay up-to-date with the latest AWS RDS features, best practices, and industry trends.
- Perform technical planning, architecture development and modification of specifications for cloud computing environments
- Develop specifications for new IT cloud computing products and service offerings
- Assess the compatibility and integration of products/services proposed as standards in order to ensure an integrated architecture across interdependent technologies.
- Advise executives to develop functional strategies on matters of significance.
- Acts as the SME in building cloud products and has a passion to learn.
Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Proven experience in migrating on-premises databases to AWS RDS.
- Strong knowledge of AWS RDS, including setup, configuration, and maintenance.
- Hands-on experience with Oracle, SQL Server, and PostgreSQL databases.
- Experience with database migration tools and techniques (e.g., AWS Database Migration Service, Schema Conversion Tool).
- Familiarity with AWS services and infrastructure, including IAM, EC2, S3, VPC, and CloudWatch.
- Excellent problem-solving skills and attention to detail.
- Strong communication and interpersonal skills, with the ability to work effectively with cross-functional teams.
- Certification in AWS (e.g., AWS Certified Database – Specialty, AWS Certified Solutions Architect) is a plus.