OVERVIEW

• Over 10 years of experience in Database Solutions.
• Experienced Information Technology Professional with demonstrated expertise in installation, programming, configuration, and administration of MS SQL Server databases.
• Capable of objective analysis and skilled at making quick decisions based on experience and judgment.
• Possesses the ability to clearly communicate intricate technical solutions to business users, resulting in successful implementation.
• Skilled at handling complex projects, customer expectations, and rapidly evolving requirements.
• Highly proficient in many technical areas including database development and web site design.
• Good interpersonal capabilities, with ability to deliver quality results with minimum supervision.

Bachelor of Science in Electronics & Communications Engineering

TECHNICAL ENVIRONMENT

LANGUAGES:

T-SQL, Stored Procedure, Trigger, Oracle PL/SQL, Oracle Forms & Reports, Shell Scripting, VB, EDI, UML, HTML, COBOL, CICS, JCL, ASP, JavaScript, VBScript, XML, JSP, Servlets, C, Java

OPERATING SYSTEMS:

Windows NT 4.0/2000/XP/98, UNIX, SOLARIS

DATABASES:

MS SQL SERVER 7.0/2000/2005, ORACLE 8i/9i/10g, SYBASE, DB2

UTILITIES:

T-SQL, DDL, DTS, Unix Shell Scripting (Bourne & Korn), ODBC, SQL Plus, SQL Navigator, TOAD, Embarcadero, Veritas Backup, Veritas Cluster, Visio Professional, MS Cluster, Rational Rose, Gentran 6.52, XPEDITOR, VSAM, Websphere, Embarcadero Tools

HARDWARE:

Pentium

MAJOR ASSIGNMENTS

1. Project: Confidential,Atlanta, GA
Jan 2007 – Present

Administer/Maintain the SQL Server databases for the projects being executed by DOT.

As a SQL SERVER DBA, I was responsible for the following:

• Create the database in the development region for the new projects.
• Participate in the database design meetings and suggest.
• Production data refresh in development regions.
• Create stored procedures to automate the various tasks including prod data refresh, autofix logins, database backups, purge old data, etc.,.
• Create and schedule various stored procedures to improve the sql server peformance.
• Involve in optimize and fine tune SQL queries.
• Setup the SQL profilers for various servers to monitor application load.
• Apply patches to SQL Server 2000.
• Prepare the upgrade process from SQL Server 2000 to SQL Server 2005
• Migrate the oracle data to SQL Server 2005 using integration services.
• Create data-dictionary for DOT. Create database and setup the access to datadictionary application in Oracle 10g.
• Write VB-Script programs to get the server information from all available servers on network.
• Copy the data from text/excel/access to SQL Server using DTS.
• Create/refresh OLAP cubes in Analysis server.

Environment: Windows 2000/XP, SQL Server 2000/2005, Oracle 9i, T-SQL, PL/SQL, DDL, DTS, Analysis Services, MS Cluster, ODBC, SQL Plus, Windows script, TOAD, Embarcadero DBArtisan, data integrator and Erwin.

2. Project: Confidential,Atlanta, GA
Jan 2002 – Dec 2006

Design, develop and implement the projects for PR Consultants Inc clients includes Viget labs, Jockey club info systems, etc.,

As a SQL SERVER DBA, I was responsible for the following:

• Create SQL Server Backup and scheduled the daily and weekly backup job.
• Create the T-SQL query to retrieve the data from SQL server database using the Crystal Report and drawn the Diagram.
• Create the SQL Server script to purge old data for SQL Server database.
• Administer SQL server by tuning security, monitoring databases and providing user administration.
• Install and configure SQL Server.
• Apply patches to SQL Server 2000.
• Prepare the upgrade process from SQL Server 2000 to SQL Server 2005
• Migrate the instance to another server including scripts and scheduled job.
• SQL Server Database Maintenance, design a backup strategy to fit available budget, Cluster State Management.
• Prepare ER diagrams for warehouse database. Design Fact & dimension tables.
• SQL Server 2000 Index and Lock management, Primary & Foreign Key monitoring & verification, Data Security and patch verification.
• Evaluate query execution plan, use DBCC OPENTRAN to locate long-running transactions, use SQL Profiler to monitor table and index scans.
• Design, develop and went live after migrating several MS Access & SQL Server databases for corporate developers, resolving typical database issues.
• Setup Replication between sites.
• Used Query Tuning & Diagramming to encourage Developers how to design their applications to ensure the Query Optimizer uses the best plan, and improve congruence.
• Performance tuning and multiple SQL servers in a failover infrastructure.
• Create/refresh cubes in Analysis Services.
• Involve in dimensional modeling/database design.
• Create Oracle database in the development region and refresh the test data with prod backup copy.
• Create users and provide access in Oracle instance.
• Fine tune/optimize Oracle database and change configuration settings.
• Migrate data from Oracle to SQL server 2000.

Environment: Windows 2000/XP, UNIX, SQL Server 2000/2005, Oracle 8i/9i, AIX, T-SQL, PL/SQL, DDL, DTS (Data Transformation Services),Unix Shell Scripting, MS Cluster, ODBC, SQL Plus, Windows script, XML, SQL Navigator, TOAD, Visio Professional, Erwin.

3. Project: Confidential,Richmond, VA
Apr 2000 – Dec 2001

As a DBA, I was responsible for the following:

• Installed, configured, and created databases for production, test and development.
• Created Unicast Customer Report Templates and utilized technologies such as Perl and Internet platform OLTP tool to design and develop Ad Management Server
• System (Oracle 8i Server) Network setting configurations.
• Created shell scripts for daily database loading process and executing stored procedure for generating summary data.
• Assisted in design of database to optimize system performance using Toad & Erwin.
• Migrated Oracle Database from one operating system to another.
• Used RMAN to recovery the database.
• Created/optimized store procedures and triggers for Production Database.
• Performed massive data load from other data sources using SQL*load.
• Installed and configured Oracle 8i RAC on Unix Environment.
• Setup testing environment for SQL Server 7/2000 database on Windows 2000 server.
• Installed the applications on SQL Server database for testing.
• Created the T-SQL to analyze online reports.
• Wrote detailed test procedures to function test server-side data exchange operation functions.
• Upgraded the SQL Server 7 to SQL Server 2000 version.

Environment: SQL Server 7.0/2000, Oracle 8i, T-SQL, PL/SQL, DDL, JSP, Servlet, JDBC, RMAN, Veritas Backup exec, Veritas Cluster, SQL*Load, Unix Shell Scripting, ODBC, SQL Plus, SQL Navigator, TOAD.

4. Project: Confidential,Troy, MI
Sep 1997 – March 2000

Syntel intranet application is fully developed with Coldfusion to maintain the employee timesheet, HR related, other company details.

As Coldfusion Programmer, I was responsible for the following:

• Develop the Coldfusion driven pages for the company intranet.
• Develop Coldfusion custom tags
• Maintain the existing application on IIS server
• Database design and development
• Create database triggers, views and stored procedures using Transact-SQL to track all system changes to web database and created a web-based application to view the changes.
• Perform SQL Server DBA activities for the intranet application.

Environment: Coldfusion 3.0/4/0, IIS 4.0, Windows NT, Windows 98, MS-ACCESS, SQL Server 6.5/7.0, HTML, Javascript