OBJECTIVE: Seeking a Challenging position as SQL SERVER DBA / DEVELOPER.

SUMMARY OF EXPERIENCE

ð      MS SQL SERVER DBA / Developer

Five Years of Experience in Information and Technology Computer Software and Internet Industries serving expertise in SQL Server 2000 / 7.0 Database Development and Administration (DBA). Experience in using tools for Monitoring and Tuning MS SQL Server Performance. Successfully done Performance and Query Tuning of SQL Server Databases using tools like SQL Profiler, and Win NT Performance Monitoring. Scheduled Backups and Restoration Plans and Point In Time Recovery. Experience in planning and implementing MS SQL Server Security and database permissions. Worked extensively on Data Transfer and Transformation using tools like DTS Import Export Data, BCP. Experience in Snapshot and Transactional Replication of MS SQL Server Databases. Configures SQL Mail For MS SQL Server, SQL Server Agent and SQL Mail in Support Services. Hands on Data warehousing and Data Modeling tools like Erwin 4.0, Visio 5.0. Experience in writing T-SQL statements for Different Queries, creating tables, indexes, and constraints. Web and Crystal Reports has been created using such queries used for production, customer and Decision Support System (DSS). Worked extensively MS SQL 7.0/2000 Database Development like writing Store Procedures, Cursors, Triggers, Views, Indexes, and Constraints. Worked extensively on installation, upgrade and configuration of MS SQL Server 6.5/ 7.0/ 2000 databases.

ð      ADDITIONAL PROJECT SUMMARY

• Experience of programming in C++, VB 6.0, VB Script, ASP, XML, HTML and CFML
• Experience in Web Development using IIS 4.0, and Cold Fusion 4.5 Professional Server.
• Knowledge of Web Tools like Cold Fusion Studio 4.5, MS Front Page 2000, and Macromedia Dream Viewer, and Adobe Golive.
• Experience in other RDBMS like Oracle 8i / 7x and MS Access 2000 / 97.
• Experience in Testing Tools like Rational Rose SQA Suites 6.0, Win Runner 5.0 TSL, QA Partner and Silk.

TECHNICAL SKILLS:

RDBMS                      : MS SQL Server 2000 / 7.0, Oracle 8i / 7x and MS Access 2000 / 97

SQL Server Tools      : Enterprise Manager, Query Analyzer, Profiler, SQL Mail, and SQL  

                                         Server Agent, DTS, DTC, BCP, Client Server Network Utility,   

                                         Security, Link Server

Data Modeling            : ER Win v 4.0, Visio 5.0

Languages                  : C++, Visual Basic 6.0 / 5.0, T-SQL, PL/SQL, CFML, VB Script, Java

  Script, ASP, XML, HTML 

Operating System       : Win 2000 Advance Server / NT 4.0 Servers & Workstation / 9x,

  Macintosh, Sun Solaris UNIX

Hardware                    : Compaq Proliant, Pentium Server and Workstation, PC based Network

PROFESSIONAL EXPERIENCE

e-Vue, Inc. (Sarnoff spin-off and partner), Iselin, NJ, USA         MARCH 2000 –PRESENT

SQL SERVER DBA

e-Vue e-Commerce and Customer PRODUCTION Database Server

• Provided SQL Server Database Administration and Development at e-Vue multi Gigabyte data storage Server.
• Duties included installation, administration, and maintenance of SQL Server 2000 and SQL Server 7.0 databases.
• Creating and debugging stored procedures; restoring databases from backup; adding and changing SQL Server logons, users, and groups.
• Converting Access Databases to SQL Server Databases.
• Analyzed application performance using SQL Profiler, collated results to identify worst-performing queries, and tuned indexes and rewrote queries to eliminate table scans, lock contention, and database hot spots, making application 40% faster overall.

• Installation of SQL Server using different security levels and Authentication.
• Different Backups has been scheduled as per requirement.
• Configures SQL Mail For MS SQL Server, SQL Server Agent and SQL Mail in Support Services.
• Different Performance Monitoring Tools has been used as and when for different performance issues like slow query performance.
• SQL Profiler is used for tracing SQL Server Activities leads to lower Performance.
• Experience on data migration from MS SQL Server 6.5 to 7.0 to MS SQL Server 2000.

Environment: SQL Server 2000, Visual Basic 6.0, Visual Source Safe, ER Win 4.0, Visual Studio, Windows 2000 Advance Server and Windows NT 4.0 Workstations and Server.

SQL SERVER DBA / DEVELOPER

MR Tracking System Buglive

• Understanding the Business Requirement and Designing the SQL Server 2000 Database.

·         Installation and Registration of SQL Local as well Remote Server. Involved in Database Designing, Logical, Relational Database Diagram, Integrity Constraints and Finally Physical Data Modeling and Normalization.

• Migration of Access Objects to SQL Server 7.0.Created Tables, Indexes and Constraints. Programming with Transact–SQL, Batches, Transactions, Stored Procedures, Triggers and Cursors.

·         Creating and Administrating of all SQL Server Database Objects, Logins, Users and Permissions in each Registered Server. Manage Database Files, Transaction log, Estimate space requirements. Managing Ongoing activities like Importing and Exporting, Backup and Recovery.

·         Optimization of Query Performance and Configuration and Performance Monitoring of Database Application.

·         Managing Database Users and Security. Used SQL Server Agent for Periodic Backups with Backup Devices, Database Maintenance Plan and Recovery.

·         Provide support in Tuning of Database Application, Stored procedures and Triggers. Replication to Synchronize data between servers.

• Visual Basic Programming using ADO-DB Record set and OLEDB provider for Microsoft SQL Server. User Interface, Logins and Bug Tracking Forms have been created. Reports are created in Visual basic using Data Environment and Data Reporting.
• Different store procedures and triggers have been fired at back-end and front-end level.
• N-tier CF Web Pages created using CF Studio/Server, IIS4.0, Sql Server for Select, Insert, Update and Varieties of Complex Reports.
• Created and executed test plans, test cases and test scenarios.
• Performed volume, stress and system testing.

 Environment: SQL Server 7.0, VB6.0, ASP, VBScript, Cold fusion, Crystal Report, Java, HTML, Access and WinNT 4.0

SQL SERVER DATA MODELER

E-Commerce and Bug Tracking Web Database Design and Data Modeling

• Understanding the Business Requirement and Designing the SQL Server 2000 Database. Designing logical and physical model of SQL Server 2000 Databases.

• Complete system designing, data model conceptual/physical defining tables, relationship between tables, general domains, and screen design/functionality behind the screen.
• Create Model à Refine Model à Generate New database from Model à If database Changed Update Model from Database.
• Using Visio 5.0 Imported existing .erx and .vsd models to visio enterprise database model.
• Worked on Entity Relationship Diagram in Models.
• Reverse and Forward Engineering on Database Models.
• Generated Database Schema using Visio DDL Scripts, Refining the database model. Synchronization between database and Model. Reuse of Database Model.

Environment: SQL Server 2000 / 7.0, ER Win, Visio and WinNT 4.0

RCC, Inc. Edison, NJ, USA                                                              JUNE 99 TO MARCH 2000

SQL Server DBA / Developer

Production Database SQL Server Administration.

• Configured SQL Server Agent service.
• Managing Database Users and Security. Used SQL Server Agent for Periodic Backups with Backup Devices, Database Maintenance Plan and Recovery.
• Database Tuning, Query optimization and debugging using SQL-Trace.
• Used DTS to Import or Export data from MS Access.
• Defined Stored Procedures for module integrity and application and system security was maintained by tuning the SQL statements.
• Successfully implemented High-Availability solution MS SQL Server 7.0 / 2000 Cluster for production Database.

Environment: SQL Server 7.0, Visual Basic 5.0 and Windows NT 4.0

TPI INC. INDIA                                                                                     JUNE 97 TO MAY 99

SQL SERVER DBA / DEVELOPER

Production and Marketing Module

• Migration of Access Objects to SQL Server 7.0.Created Tables, Indexes and Constraints. Programming with Transact–SQL, Stored Procedures and Triggers.
• Creating and Administrating of all SQL Server Database Objects, Logins, Users and Permissions in each Registered Server. Manage Database Files, Transaction log, Estimate space requirements. Managing Ongoing activities like Importing and Exporting, Backup and Recovery.
• Optimized Query Performance. Configured and Performance Monitoring of Database Application.
• Experience in conversion of dBase and FoxPro databases to SQL Server databases.
• Designed and implemented several complex reports and administration modules.
• Conducted ongoing usability tests and successfully put the system into production. The product was for furnishing general Production and Marketing activities. The system modules allow users to perform insert, update and delete functions for operational purpose.
• Designed VB Forms using the Forms and Crystal Reports were made for business reporting purpose.
• Defined Stored Procedures for module integrity and application and system security was maintained by tuning the SQL statements.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Performed low-level scripting, fixing of codes and software enhancement process.

Environment: SQL Server 7.0, Visual Basic 5.0, and Win NT

CERTIFICATION TRAINING AND COURSES

2000     SQL Server 7.0 DB Design and Administration

             Microsoft Certified Training At Microsoft Certified Alpha Train NJ USA

1999     Web and Client Server Application Programming at Info system Computers NJ USA

1998     Advance Oracle Application Programming Certification

             Oracle Corporation USA 

EDUCATION

BS       in Engineering – 1993

MBA   in Management Information System – 1997

MS      in Computer Science – Part time at Monmouth University, New Jersey.