2015 to 11/2016 AWS Solutions Architect Applied Information Sciences, Inc. | Fort Bragg, NC, Responsible for launching Amazon EC2 Cloud Instances using Amazon Web Services (Linux) and Configuring launched instances with respect to specific applications and regions. Installed applications on AWS EC2 instances and configured the storage on S3 buckets. Responsible for S3 buckets creation, policies and the IAM role based policies. Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection. Responsible for creating monitors, alarms, and notifications for EC2 hosts using  Cloud Watch. Involved in the migration and implementation of multiple applications from on premise to cloud using AWS services like SMS, DBMS, CloudFormation, S3, Route53 Glacier, EC2, RDS, SQS, SNS, Lambda, Kinesis, and VPC. Build servers using AWS and launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection. Build and configure a virtual data center in the Amazon Web Services cloud to support Enterprise Data Warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups, Route Tables, Elastic Load Balancer. The configuration of Continuous Integration (CI) and Continuous Delivery (CD) using CodePipeline and CodeDeploy for automation. Involved in a 24X7-support rotation for all the Production, Test, and Development environments. Responsible for the Installation, Configuration, and Maintenance of Oracle 12c/11g/10g Single Instances and RAC databases for High Availability and Disaster Recovery. Performed patching, upgrade and migration of multiple developments, test and production databases from 10g/11g to 12c and migration to different platforms. Performed backup and recovery strategy using Recovery Manager (RMAN) - physical backup - and Data Pump (Import/Export) - logical backup, respectively. Created User Accounts, Roles and granting required access Permissions and Privileges to the users. Implemented SQL, PL/SQL and T-SQL queries, packages, functions, stored procedures, triggers, tables, views, materialized views, indexes. Involved in the 24X7-support rotation for all the Production, Test, and Development databases. Performed Performance Tuning using SQLTRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM. Developed various Bash, Shell Scripts for automation. Environment AWS - EC2, S3, Glacier, SMS, DBMS, RDS, SQS, SNS, SES, CloudFormation, VPC, Redshift, DynamoDB, Oracle 12c, 11g, 10g, Linux, OEM, RMAN, Python, MySQL, MS SQL Server 2012, MS (SSIS, SSAS, SSRS)