Oracle PL/SQL Developer

• Over 2 years of experience as plsql developer. Skilled at Analysis , design, support ,development and performance tuning of application using Oracle plsql.

• Required Skills in Writing PLsql Packages, Stored Procedures and functions using Oracle 11g/10g.

• Expertise in PLsql skills like Cursors, Triggers, Arrays, Collections.Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views.

• Good knowledge of Query Optimizer, Execution Plans, and Indexes.Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

• Have used SQL queries optimally using Aggregate functions,Table Joins, group by commands.

Cloud Computing: AWS Exposure

• Strong Knowledge of AWS working on Regions and Availability Zones, Ec2, S3, EFS.

• Setup/Managing Windows and Linux Servers , Databases on Amazon RDS. Monitoring servers thorough Amazon CloudWatch, SNS.

• Creating/Managing AMI/Snapshots/Volumes, Upgrade/downgrade AWS resources (CPU, Memory, EBS)

• Strong Knowledge in planning, designing, and transforming environments from on-premises to cloud-based

• Monitored material use to identify concerns and keep costs low.

• Boosted production throughout and quality by revamping procedures and monitoring strategies