Gaurav kumar

SUMMARY 3 years comprehensive hands-on Experience in creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating data in Oracle. 2+ year solid experience in supporting, automating, and optimizing mission critical deployments in AWS Technologies

• Operating System: Linux

• Scripting: Shell /Python

• Database: Oracle 11g, PostgreSQL

• Versioning Tool: Github

• Tools:Sql Developer,HPSM,MicroFocus

• Language: Python • APM: AppDynamics

Wipro October 2018- Present Telenor Myanmar - PL/SQL Developer

• Writing SQL queries to retrieve data from Database as per specific requirements and in specific format.

• Involved in SDLC, Planning, Designing and Testing.

• Created and modified SQL Loader, PL/SQL scripts to load data in Database.

• Wrote SQL, PL/SQL programs to Retrieve/Modify data from database and Handling Exceptions.

• Developed and modified Functions, Procedure, Packages and stored & Standalone programs for data conversions and PL/SQL procedures and Functions to create database objects dynamically based on user requirement.

• Created database objects like Tables, materialized views, synonyms, views, Anonymous/Stored Procedures, Functions, Packages using Oracle tools like PL/SQL developer.

• Created Unix Script to Automate Hourly and weekly Reports for Clients.

• Extensively used PL/SQL concepts like Bulk bind and bulk collect to larger volume of data.

• Analyzed and Modified PL/SQL program to fine tuning query performance by creating Indexes and Partitioning the table.

• Operating System: Linux

• Scripting: Shell /Python

• Database: Oracle 11g, PostgreSQL

• Versioning Tool: Github

• Tools:Sql Developer,HPSM,MicroFocus

• Language: Python

• APM: AppDynamics Cloud: Amazon Web Services (AWS)

• Compute: EC2, ASG, Load Balancer, Elastic Beanstalk.

• Network: Route 53, VPC, Subnets, NAT

• Storage: S3, Glacier, EBS Volumes, EFS

• Others : IAM, RDS, CloudWatch, Athena P