SQL Developer Resume Profile

Objective

I am an associate with 8 years of IT experience. My main area of experience has been project delivery of various sizes in the Telecom and Insurance domain. I am proficient in Oracle SQL, PL/SQL, and Advanced PLSQL, Hadoop IBM Info Sphere Big insights Big Data, IBM Netezza Database,

Technical Skills

Software	IBM Biginsights Hadoop, sqoop, Hive, IBM Netezza database import tool, Core Java, Advanced Java, Struts, Web services, SQL, PL/SQL, Advanced PLSQL,UNIX, Oracle Data Base Administration 9i,10g,11g Release ,Oracle ASM, Data Guard, Informatica 8.6,9.1
Hardware	UNIX and Linux Servers
Tools	TOAD for Oracle, Toad for sql server, Toad Data Point IBM Netezza data base , Sql developer, PLSQL developer, Aginity work bench for IBM netezza database server , Oracle Application Server, Mercury Test Director, Mercury Quality Center ,Eclipse, JDeveloper
Methods
Domain Experience	Telecom-Domain 4.7 years Insurance 4.6 years
Management Experience
Business Development	Contributed to the sale of an in house product to Tata Sky

Project Experience Summary

Confidential

Role: PLSQL/Advanced PLSQL/IBM Big data Hadoop Technology Lead

Responsibilities

Working with development teams regarding the PLSQL and Advanced PLSQL development Procedures, Packages, Views, Materialized views, curors, refcurors, sys refcursors, parameterized cursors, Varrays, Nested Tables, Associative Arrays, and Bulk Collections etc .
Used SQL loader, Oracle import/export and oracle Data pump import and export for loading the data.
Developed Stored Procedures for the Java and .NET Front End Development Team

Identifying software versions ,Monitoring system states, System Errors, logs
Management of Netezza Database users, Groups, Group limits.
Management of Databases, user tables, Stored Procedures, Clustered base tables.
Management of Distribution keys, Data skew, Generating Database statistics, Groom tables, Session management, Netezza optimizer and query plans, Query status and history.
Data Loading using Netezza nzload .
Netezza database backup and recovery-Incremental backups
Backup History report, Database statistics after restore, Restore tables, Incremental restoration.
Installation of Netezza database drivers JDBC,ODBC,OLE DB database

Confidential

Using IBM Info sphere Big Insights tool for Maintenance of the following services and nodes

Maintenance of the following nodes and services:
Name Node, secondary Name Node and 8 Data Nodes
Map/Reduce Functions
Hadoop File System HDFS
JAQL server
HBASE
HIVE
BIGSQL Internal to IBM big insights and an alternative to HIVE .
Using Hive and Hive Query languages.
Using IBM Big SQL in OLAP environment.
Using Sqoop tool to import and export data from Hadoop File system HDFS .
Importing data from Oracle database and IBM Netezza databases to HDFS using sqoop
Using Database import IBM big insights tool to import and export data from Hadoop File system.
Developing java map and reduce functions and deploying the application using IBM Big Insights Tool.
Design various data models including class diagrams, dataflow diagrams, workflow diagrams, sequence diagrams and interaction diagrams.

Environment: Oracle SQL, PL SQL, Advanced PLSQL, UNIX, IBM WebSphere Application Server 7.1, Eclipse, JUnit, TOAD, Oracle SQL Developer, PLSQL Developer, TOAD for Data Point

Confidential

Role: PLSQL/Advanced PLSQL/IBM Big data Hadoop Technology Lead

Responsibilities

Working with development teams regarding the PLSQL and Advanced PLSQL development Procedures, Packages, Views, Materialized views, curors, refcurors, sys refcursors, parameterized cursors, Varrays, Nested Tables, Associative Arrays, and Bulk Collections etc .
Used SQL loader, Oracle import/export and oracle Data pump import and export for loading the data.
Developed Stored Procedures for the Java and .NET Front End Development Team

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship