Objective
SQL SERVER DBA


Summary


Summary : Microsoft Certified for SQL Server 2000 Database Design and Administration.

Over 8 years of experience in Design, Development, Implementation and Administration of Client Server Applications, Legacy and Database systems using MSSQL 7.0/2000T-SQL, PL-SQL, VB 6.0 VBScript, IBM DB2 and Oracle.

Over 5 years of extensive exposure in MSSQL Database Administration with Expert level skills in SQLServer Configuration, Performance Monitoring, Tuning, SecurityAdministration and Replication

Experience in Datamodelling and Database Design using DM tools Erwin and SQL Diagrams.
Exposure to multiple Database systems like MS SQL, IBM DB2 Oracle 7.0 etc.

Experience in Database Programming using T-SQL in writing StoredProcedures, Triggers and DTS Jobs
Developing Comprehensive Database Backup strategies and Successfully Implementing Various Backup, Restore Methodologies and exposure to MS-OLAP and Analysis services.
Administer and Support mission critical databases and provide 24*7 Production support.
Implementation of Microsoft Clustering Services for High Availability of Servers.
Extensive knowledge in Healthcare, Insurance and Oil and Gas Energy Sectors and a certified LOMA Professional.
Strong knowledge in Windows 2000 Advanced server and Windows 2003 Server and Compaq EVA, EMA SAN.

Excellent analytical, organizational, problem solving, interpersonal and communication skills ; good team spirit, quickly adaptive, hard working and determined.

Computer Skills : Programming Languages : C, Cobol, VB 6.0T-SQL, PL-SQL, VBScript, JavaScript, HTML, JSP
Databases : MS SQL 7.0/2000 Oracle9i, IBM DB2
Tools and Utilities : DBArtisan 5.0 DBDiff, VSS 6.0 SQLLitespeed, ERWIN 5.1SPOTLIGHT
Terminal Services, RDC, PCAnywhere, ERWIN 5.1Dameware, Arcserv 6.0
Operating Systems : Windows 98, NT/XP Windows 2000 Advanced Server, W2K3 server, UNIX MS-DOS
Hardware : Compaq Proliant 400060007000 Series, HP-9000IBM PC Servers 325
Compaq EVA, EMA SAN
Miscellaneous : : Informatica, Expeditor, CA-Interest, TSO, ISPF, SDSF


Employment

1998 -  2000
Analyst

Agency system is 1 of the major systems under the purview of Individual line of business at Phoenix Home Life Insurance. The Agency Production Support project encompasses OnCall activities, maintenance to the various sub systems belonging to the AGENCY business line. Oncall Production Support involves Resolution of bends encountered during the production batch cycle by the OnCall analysts. Production Support involves frequent changes needed for the system, enhancements based on the requirement of the business domain. The requests for the changes are entered as Service Requests by the requester in the Production Inventory Tracking System.

Responsibilities :
Involved in Knowledge acquisition process Which involves the study of the existing system and pass on the knowledge to the offshore team at India
Assigning of requests to the team
Involved in analysis of the Service Requests raised by the users, Field support people
Supporting the production environment on 24*7 basis

Review of the work done by the team and assure the quality of the product

Documenting of the production issues for future reference

1997 -  1998
Software Engineer

Education

Miscellaneous

Certifications : Microsoft Certification in SQLSERVER 2000 Administration
FLMI Level 1 Certification from LOMA

Database Architect, Administrator, El Paso Corp Inc, Houston, TX Feb04 Present

Involved in design, analysis, implementation and Administration of MSSQL databases in multiple environments handling requests and requirements for multiple users for the Client which is 1 of the largest provider of Oil and Natural Gas in North American Continent.

Responsibilities :
Set up and Configure database servers for multiple environments
Design tables, Implement relationships and forward engineer across all the environments using ERWIN 5.1
Created Database objects like Tables, Views, Indexes, Stored procedures and triggers using T-SQL
Created Logins, users and roles and involved in Day to Day User Maintenance

Monitor database growth activities and Troubleshoot Transaction Log and Space Issues
Resolved Deadlock and Blocking Lock Issues by setting Trace Flags like T1204, - T1205
Integrated Database Maintenance jobs with SQLLitespeed to perform Full, differential and transaction log Backups and scheduled them with the Sqlserver agent job scheduler
Involved in setting up Transactional Replication and Monitor and Support Replication issues

Scheduled weekly DBCC DBReindex and other Database Maintenance Jobs to check database consistencies
Set up and Schedule Data Migrations and Loads using DTS packages from various heterogeneous data sources
Extensive usage of BCP and BULK INSERT utilities for data Migrations involving multimillion records tables

Created Linked Servers between SQL Servers and other Heterogeneous environments like Oracle and ADSI

Set up SQL Profiler and Spotlight to trace various Database activities, application Responses and Performance tune them.
Performance tune Stored Procedures and long running queries by looking at query plans, IO Statistics, Joining Techniques, Outdated Statistics and Indexes
Involved in SAN Hardware Raid level Implementations and Placement of tempdb, Logs, Indexes, datafiles across different Raid levels for optimal Performance
Administer Procedures and Controls for SOX Audit Compliance

Environment : MSSQL 7.0/2000 T-SQL, VB Script, DBArtisan 7.1 DBDiff, Spotlight, Log Explorer, Dameware
Windows 2000/2003 Advanced Server, IBM/ Compaq Proliant 7000 servers/ EVA, EMA SAN

Database Administrator, National Life Group, Vermont, VT May02 - Jan04
Supporting multiple applications on multiple environments like Production, Test and development servers for National Life Insurance Group, Vermont

Responsibilities : Set up and configure Test and Development servers.
Estimating storage capacity for database objects and allocating resources.
Creation and migration of various objects like tables, Primary Key, Foreign Key constraints, Indexes, Views
Created stored procedures for various Database and Application functionalities
Involved in Analysis and Implementation of Indexing for Large History Tables
Created DTS Packages and Jobs to load data from various User Input files
Implemented Replication for availability of Standby server

Involved in Upgradation of SQL 7.0 to SQL 2000 and co-ordinate all Upgrade activities
Schedule Backup Jobs for Various Tape and Disk Backups
Setting up a Comprehensive Database Restore Strategy
Setup database maintenance jobs through Database Maintenance Wizard
Involved in Production Support on a 24*7 basis
Written Custom Scripts and procedures to Extract, Transform and Load data through DTS packages

Environment : Windows NT/2000 MS SQL 7.0/2000 HP-9000 Servers, T- SQL, VB Script, PCAnywhere

Systems Analyst, Database Architect, IMS Health, Totowa, NJ Mar00 - Apr02
The Health care system which deals range of Pharmacy Products that are supplied to various clients, was converted from Legacy System to SQLServer for this Client.

Responsibilities :
Involved in Design and Data model Mapping from Mainframe Application for conversion into SQLServer
Created DTS Packages for Data Loads from DB2 and Text files sources to SQL Server
Design DTSPackages to Import and validate the data from various User Input files like FlatFiles, Excel files

Involved in Supporting and Troubleshoot Data Conversion activities throughout the phases of Development, Conversion, UserTesting, PerformanceTesting and Production cycles
Involved in writing Business Stored Procedures and Triggers using T-SQL

Created Tables, Views, Triggers and other database Objects in SQLServer

Involved in preparing test case data for Conversion activities from DB2 to SQLServer
Involved in preparing JCLs and Jobs to prepare data files for Conversion
Involved in writing Data Conversion templates and programs to load data from DB2 into the Flat Files

The Federated Buying and Order Processing system developed on IBM Mainframe S/390 supports the entry and maintenance of purchase orders for Departmental stores like Macyss East, Macyss West and Grooming Dale. Uses size group models for selecting sizes and entering quantities. Select a generic size group and store group that is used by a department or create 1 for particular purchase order.

Responsibilities :
Coding Online and Batch Programs to convert data from Oracle to Db2.
Test programs
Coding Event Coordinators
Coding Data Access Programs
Involved in Designing Templates.

Environment : MVS OS/390 COBOL II, ORACLE 7.1 DB2 CICS, Windows 95/98