Oracle PL/SQL AWS Tech Architect

Position Description:

The Technology Architect is responsible for analyzing, designing, migrating, Oracle DB to AWS postGres DB. The candidate will have in-depth knowledge of technologies involved and experience in Cloud Native Development.

• Analyzing the Schema's and Store procedure and migrate from Oracle to Postgres
• Maintain and contribute to product platform as necessary
• Maintain and support products that are released to stakeholders and customers
• Facilitate discussions among other developers to exchange new ideas and improvements
• Continually evaluate emerging technologies to identify opportunities, trends and best practices that can be used to strengthen technology platform and development practices.

Basic Skills & Qualifications:

• 7 years of experience in Oracle PL/SQL and 4+ Years of experience in AWS PostgresSQL
• Experience in migrating Oracle DB to AWS Postgres DB
• Backend application programs to be developed. Application programs such as stored Procedures, Functions, Packages, cursors, collections and triggers and materialized views using SQL and PL/SQL
• SQL and ETL processes, ETL and DB performance tuning, table partitioning

Preferred Skills & Qualifications:

• Good hands-on with Oracle PL/SQL Store Procedures
• Analyze on-premises Oracle database environments from migration perspective to AWS-PostgreSQL/MySQL
• Consult for optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance.

Required years of experience:

• 7 Years of software development experience
• 7 years of experience in PL/SQL development
• 4+ Years of experience in AWS Postgres DB
• Analyze on-premises Oracle database environments from migration perspective to AWS-PostgreSQL/MySQL
• Consult for optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance
• Migrate customer data workloads to AWS
• Work closely with AWS Platform Service Engineering and Solution Architecture teams to help ensure the success of project consulting engagements with customer
• Employ customer facing skills to represent AWS within the customer's environment and drive discussions with senior personnel regarding trade-offs, standard methodologies, project management and risk mitigation
• Experience in Performance tuning in SQL
• Be the go-to expert for Oracle and PL/SQL
• Participate in coding and enhancements
• Tune, script, and extract, transform, and load
• Support daily business operations related systems
• Run systems manually (test files, re-runs,) for exception cases
• Development and support Applications and services as specified by our business partners
• May serve as technical project lead
• Use research, proof of concept, spike testing, to drive technology roadmap and make technology recommendations are pushing the limit of what is currently possible towards completely new areas. And then executing these ideas to perfection.