SQL Developer Resume Profile

Technical Skills

Software	IBM Biginsights Hadoop, sqoop, Hive, IBM 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 3.7 years Insurance 3.6 years
Management Experience
Business Development	Contributed to the sale of an in house product to Tata Sky

Contributions/Achievements

Received awards for outstanding performance in all the projects involved in.
Contributed to KNOWMAX TCS Internal with the lessons learnt in the field of Oracle dB links and Java Stored procedures in Oracle
Replaced all the Data base links with java stored procedures
Automated all the process related to Analyzing tables ,Rebuilding indexes, Reorganizing tables and recompiling the invalid objects
Developed a front end GUI using Struts 1.2 for support team for monitoring following activities

1. Object dependencies whenever altering the objects

2. Scripts for tables,indexes,views,forcedViews,materialized views,procedures,functions,packages,

Java stored procedures, Triggers, sequences etc.
Implemented Exchange partitions in the Oracle Data base which had accelerated the archival process and reduced the archival time from 18 hours to 1 hour
Participated in Many disaster recovery activities and successfully replicated the database objects and all other processes from production servers to disaster recovery servers
Eliminated all the row level triggers for archival process and introduced exchange partitions for archival of data
Developed oracle PLSQL code for consumption of web services in oracle 11g release2 data base.
Developed and contributed many new PLSQL/Advanced PLSQL components to MIGHTY internal to TCS .
Profiled over 20 applications and improved their throughput by 5 times.
Successfully developed and managed Electronic Voucher Distribution EVD as the throughput increased from 5000 to 2 Million.
Successfully delivered EVD as a product to Tata Sky from TCS.

Confidential

Identifying software versions ,Monitoring system states, System Errors, logs

Management of Netezza Database users, Groups, Group limits.

Management of Databases ,user tables, Stored Procecudes, 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

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

Data Loading using Netezza

Confidential

Creating db objects Tables, Views, Materialized views, Triggers, Procedures, Packages, indexes, db links, Partitioned Tables Range, List, Hash, Interval , sequences .
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 .
Working on different Kind of MV Refreshes Fast, Force and Complete Refresh
Attending code review meetings related to SQL, PLSQL, Advanced PLSQL, Java Web applications, Informatica workflows, Tasks, sessions, mappings
Maintaining single instance Databases of size 640 TB of 15 databases in Data Ware Housing Environment.
Installation of databases using Manual Methods.
Maintaining very huge tables of sizes more than 1 TB
Using Data Pump for data copies >GB and less than TB
Using oracle apps server for deployment of java web applications war files
Backup and recovery using EMC split BCV cold backups every week
Maintaining databases running in Archive and Non archive log mode.
Maintaining ASM and Data Guard
Dealing with the Informatica power center 8.6,9.1 , Informatica workflow manager 8.6,9.1 , Informatica Workflow Monitor 8.6,9.1
Maintaining the very huge Table spaces related to Tables and indexes
Maintaining the databases with Archive log as well as non-Archive log modes
Performance Tuning especially related to Query performance tuning
Maintaining oracle connection pooling.
Working closing with Client DBA team who is maintaining RAC databases.
Taking on call on weekly basis every month.
Assigning operational activities for the offshore team of 10 members

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
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
Proof of concepts completed .

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship