OBJECTIVE:

Seeking challenging career in the field of Database Developer where I can use my professional exposure and work with top-notch professionals.

PROFESSIONAL SUMMARY:

Database Developer with Oracle Certified Professional (Oracle 9i/10g)

Having 8+ years of hands on experience in MSSQL Server 2005/2008/2010/2012, Oracle 8i/9i/10g and11g RAC instance databases with extensive experience in Client Server Application Design (Logical, Physical), Development and Administration as a Developer.

Experience in Analysis, Design, Architecture and Development of Software Applications, Business Intelligence projects in the Microsoft Server Suite of Products.

Experience in installing, configuring and monitoring MS SQL Server 2005/2008/2010 installations.

Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard.

Strong experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and Sub queries with T-SQL.

Experience in creating Backup & Recovery Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.

Designed layout of report in Crystal Report 8.0/2008 and SQL Server Report 2010/2013, SSIS, SSRS.

Prepare data flow diagrams, data dictionary, database normalization, entity relation

modeling and design techniques.

Knowledge of Web Logic server for standalone application server (Academic Level).

Installation of Hadoop on Single node with Cloudera and CentOS operating system.

Comfortable and effective in working both as a team member and team leader.

Effective time management and organizational skills.

TECHNICAL SKILLS:

Database

Oracle 7.x/8i/9i/10g & 11g, MSSQL Server 2000/2005/2008 /2010 & 2012,Firebird 1.0,MySQL 5.0, MS Access 2007/2010 & 2013,Foxpro 2.0/2.6 & 6.0.

Reporting Tools

Crystal Report, Oracle Report 4.5, SQL Server Report 2012/2013.

ETL Tools

Informatica 8.1.6, SQL*Loader, SSIS/SSRS & Data Martist.

OS

Win XP, Win 7, 8, Windows Server 2003/2005 & 2008, UNIX.

Languages

T-SQL / PLSQL, Unix shell script, Java, C, C++,XML

Windows Programming

ASP.Net C# 2.0,3.0,Develoepr 2000, Oracle Forms & Report, VB6

Web Development

HTML, CSS, JavaScript, WordPress

Data Analyst Tools

Excel Power Pivot, Pivot Table, SAP Lumira 1.0

PROFESSIONAL EXPERIENCE:

Database Developer Jan- 2012 /Apr- 2014

QuadTechInc, Ahmedabad, India

Key Responsibilities:

MSSQL/Oracle database Server, Client, Application configuration and installation database

development on Windows/Unix server as well as web logic server.

Designed MSQL Server databases for large departments, from planning and testing through

production.

Planned the application schema, designed database objects like tables, indexes, views, sequences

and integrity constraints, procedure, function, triggers using technical document. Setting the storage

parameters values.

Created stored procedures, user-defined Functions, sub-queries, views and cursors for both Online and Batch requests handling business logic and functionality of various modules.

Involved in query optimization and tuning stored procedures for better performance.

Developed the PL/SQL programs and involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.

Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.

Installed and configured SQL Server 2008 in Test environment with latest service packs and migrated few databases.

Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuilt indexes if necessary.

Worked with table partitioning and index partitioning to reduce the execution time of query.

Used dynamic queries for creating multiple T-SQL commands.

Migrating database from Access to SQL Server, SQL Server 2005 to 2008 and Oracle to MSSQL Server.

Worked under team environment, tight deadlines, and fast-paced environment.

Excellent analytical and management skills.

Environment: Oracle 9i/10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows Server

2003/2005 & Windows XP/Win7.

DBA Jun-2003/Nov-2011

Navgujarat College, Ahmedabad, India

Key Responsibilities:

Implemented Oracle server 9i on Windows Server 2003. Developed database for Online Admission System and set all parameters in database.

Developed application “Online Admission System” in VB6 (Frontend) and Oracle 9i (Backend).

Converted an existing database in Ms – Access to Oracle for a preexisting application in Visual Basic.

Introduced complex reports using SQL query in Crystal Report - multi-functioned, leveled and grouped, cross-tabs, charts, imported parameters and record sets from stored procedures with instructional tooltips.

Wrote complex PLSQL script for extract data from database like procedures, functions and triggers.

Coordinated in loading data from different databases using SQL*Loader. Used export / import.

Taking backups and restoring tablespaces and database.

Good command over Unix Scripting and wrote script for oracle backup statement.

Administration of Oracle networking like Names Server, TNSNAMES and Listener configuration and client configuration.

Ample knowledge in C/C++ and JAVA with Applet programming.

Provide technical and application support to students filling out online forms.

Environment: VB 6, Oracle 9i, PL/SQL, SQL*LOADER, Oracle Form 4.5, SQL PLUS, HTML, SQL Server

SSIS, TOAD, XML, UNIX shell scripting.

EDUCATIONAL & PROFESSIONAL ACHIVEMENTS

PROFESSIONAL ACHIVEMENTS:

OSLT (Occupational Specific Language Training- Humber College) 2015

Brain Bench Certificate in Oracle 11g Forms / Report (Score 3.5 out of 4.0). 2014

Oracle Certifications – 10g (Database Administrator) 2010

Oracle Certifications – 9ig (Database Administrator) 2009

EDUCATION:

Post Graduate in Computer Science Applications. (2002-2003)

Higher Diploma in Software Eng. (Aptech Computer Education) 1997-1998

Bachelor in Commerce 1991-1994

References - Available upon Request

Contact this candidate