Objective
SQL Server DBA


Summary


Summary : Over 13 years of IT experience, roles as a Database Administrator, Systems Analyst and Programmer

Over 9 years of experience in MS SQL SERVER 2000/ 7.0/6.5/6.0 in supporting mission critical OLTP environment that includes Production DBA and Development DBA

Having 4 years of experience in replicating data using MS SQL Server Replication Server

Having 2+ years of experience in SQL Server Clustering to provide high availability of the database

SQL Server Skills :
Having excellent experience in Installing SQL Server 2000/7.0 and migrating databases from MS SQL Server 6.5/7.0 and Sybase 11.5 Adaptive server to MS SQL Server 2000

Having excellent experience in Planning, database implementation, performance monitoring, troubleshooting, performance tuning and backup and recovery and Administrative tasks in SQL Server 2000/7.0

3 + years of strong Installation, configuration, support and administration experience of SQL Server 2000/7.0 Replication

Having solid experience in Logical Database design, Physical Database Design, Physical Planning, Allocation and Maintenance

Having good experience in Maintaining High Availability of the server in 24/7 shops using SQL Server log shipping process

Having good experience in Query Optimization, Database Optimization, building better indexes for the tables and fine tuning existing indexes

Having good hands on experience in scheduling back ups for databases and transaction logs

Having good hands on experience in scheduling jobs for optimization, consistency and integrity checks of the databases

Having strong experience in Planning and Implementing Database Security

Having good experience in SQL Server Clustering to provide high availability of the database

Having good experience in designing Data Transformation Services packages for import and export data to, from SQL Server Databases

Strong experience in data transfer from Oracle 8i/8.0 Sybase 11.5/11.0 and MS Access to MS SQL Server 2000 using ETL tools like MS DTS and Informatica

Good experience in converting Oracle PL/SQL code to SQL Server T-SQL code and Sybase T-SQL code to SQL Server T-SQL code.

Having hands on experience in designing and building Data Warehousing environment using MS OLAP Services

Having good experience in MS SQL Server tools like Enterprise Manager, SQL query analyzer, SQL Server Profiler, Windows Performance Monitor and T-SQL

Having good experience in writing VB Script

Having good working experience in Windows 2003/2000/Windows NT 4.0

Having hands on experience in handling multiple servers and managed remote servers using Windows Terminal Services Client

Having good experience in monitoring Windows and SQL Server error logs
Having good exposure to MS SQL Server 2005 and. NET 2003

Data Modeling Skills : Logical and Physical Database Design or Modeling using Tools like ERwin, ER, Studio and MS VISIO
Data Warehouse Design or Modeling using Dimensional Modeling Methodology like Kimball and Tools like ERwin and ER, Studio
Logical and Physical Database Design or Modeling for Multi database environments like Sybase ASE, MS SQL Server and Oracle Database, Version, Revision and Build Management using Tools like MS Visual SourceSafe
Logical and Physical Database Design or Modeling for Very Large Applications involving 500+ Tables and related Objects
Forward Engineering NEW Database Models into deliverable Physical Database DDL Scripts and Reverse Engineering existing Databases into Logical and Physical Database Models for Change Management, Documentation, Re-engineering, etc. purposes
ETL for Data Mart or Data Warehouse Staging and Loading using Tools like Informatica PowerMart Designer/MS DTS along with Oracle SQL Loader and PL/SQL, Sybase BCP and T-SQL, etc.

Miscellaneous Skills :
Having good exposure to Oracle 10G/9i Database Administration
Developed applications in Power Builder 5.0 SYBASE 11.0.1 ORACLE 7.1 Developer 2000

Experience in SYBASE APT Work bench 5.3.0 DB-Library/C, T-SQL, BCP and ER-Win Data Modeling tool

Experience in writing UNIX shell scripts, Designed and developed reports using Crystal Reports
Exposure in C++, JAVA, HTML

Strong computational, analytical problem solving and design skills
Solid understanding of business needs and requirements for any company.

Technical Skills :
SQLServer 2005/2000/7.0/6.5 SYBASE 12.5/12.0/11.5/10.0.1 ORACLE 10G/9i/8i
OS : WINDOWS 2003/2000/NT 4.0 WINDOWS XP/98/95 HP-UNIX 10.0.1
WINDOWS 3.11 Linux, DOS 6.2
Hardware : Dell PowerEdge 1800/2800 Servers, Compaq Proliant 8000/8500 HP-9000 Series E-35 HP NETSERVER LC II, HP, Dell Pentium PCs
Front end : POWER BUILDER 5.0 Oracle Developer 2000 SYBASE - APT - Workbench 5.3.0
Languages : C, C++, JAVA, HTML, COBOL


Employment

2005 -  Present

are supporting the mission critical SQL Server Databases as a Production DBA. The databases are varying in sizes upto 500GB These databases were updated with gaming data nearly 27/7 by 1000s of player terminals. These databases are utilized for OLTP and OLAP data models and is made available for a 24/7 environment.

ROLE : Database Administrator

are supported the databases as a Production DBA
Migrated Databases from SQL Server 7 to SQL Server 2000
Have done BPR to identify the performance bottlenecks in the Database design of the application
Has build DTS Packages for data transfer from heterogeneous data sources using VBScript and T-SQL Stored Procedures
Created and monitored SQL Server automated jobs to transfer data from various data sources
Distributed the data to various locations using SQL Server Replication
Has done query optimization using SQL Server query analyzer to fine tune the views to get best performance
Has fine tuned database objects like Stored Procedures, Triggers, Rules, Defaults, Indexes, Primary Keys, Foreign Keys for better performance at peak loads of the database
Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards
Designed and developed data warehouse database schema using star schema design
Has configured MS Report Services to fetch and produce BI reports from Analysis Services
Designed and implemented ETL for data migration and data staging from heterogeneous environment like MS Access and MS Excel using MS DTS
Created and optimized the MOLAP, ROLAP Cubes, Fact and Dimension Tables
Has done DBCC checks to ensure the physical consistency of the database and objects are monitored the database to identify the performance issues using SQL Server Profiler and resolved the issues
Has created effective Backup and Recovery plan by Transactional Log, Differential and Full Database Backups and utilized to recover data in point in time in case of disaster of database or server
Has tested the Recovery of the database frequently to ensure that Backup files not corrupted and optimal
Implemented RAID disk subsystems for better scalability, storage and retrieval of high volume of the data are implemented and maintained high availability of the database using SQL Server Clustering

Environment : WINDOWS 2003, MS SQL Server 2000/7.0, Dell PowerEdge 1800/2800 Servers, MS VISIO, MS Visual SourceSafe, MS DTS, T-SQL, VB Script, MS Analysis Services and SQL Server 2000 Reporting Services

2004 -  2005

Supported the mission critical SQL Server Databases as a Production DBA at CapitalOne, 1 of the leading financial company at Richmond, VA. The databases are varying in sizes between 30 GB to 400 GB. The databases were containing financial information of the customers and payroll information of the employees. These databases are utilized for OLTP and OLAP data models and is made available for a 24/7 environment.

ROLE : Production DBA

Has build DTS Packages for data transfer from heterogeneous data sources like Oracle, MS Access and text files to SQL Server using VBScript, Stored Procedures and T-SQL Scripts
Created and monitored SQL Server automated jobs to transfer data from various data sources
Distributed the data to various locations using SQL Server Replication
Has done query optimization using SQL Server query analyzer to fine tune the views and Stored Procedures to get the best performance
Has created database objects like Stored Procedures, Triggers, Rules, Defaults, Indexes, Primary Keys, Foreign Keys
Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards
Has improved the performance by query optimization and tuned Stored Procedures and Triggers for better performance
Has done DBCC checks to ensure the physical consistency of the database and objects
Has optimized Backup and Recovery plan and utilized to recover data in point in time in case of disaster of database or server
Has designed and implemented Transactional Log, Differential and Full Database Backups to minimize the data loss and point of-time recovery of data incase of database corruption are monitored the performance of SQL Server and Windows using SQL Server Profiler, Windows 2003 Performance monitor and SQL Server Query Analyzer are implemented and maintained high availability of the database using SQL Server Clustering
Have provided after hours support using VPN connection and provided best availability of the databases are supported multiple servers and databases in development, test and production environment

Environment : WINDOWS 2003, MS SQL Server 2000/7.0, Compaq Proliant 8000/8500 MS VISIO, MS Visual SourceSafe, MS Analysis Services, MS DTS, T-SQL, VB Script and Micro Strategy

2002 -  2004

The client is a Supply Chain Distributors in USA The business transactions are maintained in SQL Server 2000 databases on Windows 2003 environment. are maintained data in multiple servers and the original application is migrated from SQL Server 7.0 to 2000. The data are replicated to remote servers using SQL Server Replication. This database is been made available for a 24/7 environment and are accessed by the users from worldwide through companys website. are re-designed the whole database schema for better performance and supported the production environment as a Production DBA.

ROLE : Database Administrator are worked as a Data Modeler and Database Administrator
Migrated Databases from SQL Server 7 to SQL Server 2000
Generated Logical and Physical Database design using MS VISIO
Have done BPR to identify the performance bottlenecks in the
Database design of the application
Has build DTS Packages for data transfer from heterogeneous data sources like FoxPro, MS Access and text files to SQL Server using VBScript and T-SQL Stored Procedures
Created and monitored SQL Server automated jobs to transfer data from various data sources
Distributed the data to various locations using SQL Server Replication
Has done query optimization using SQL Server query analyzer to fine tune the views to get best performance
Has created database objects like Stored Procedures, Triggers, Rules, Defaults, Indexes, Primary Keys, Foreign Keys
Optimized Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards
Has provided secured and scalable environment in Windows2000
Has improved the performance by query optimization and tuned Stored Procedures and Triggers for better performance
Has imported and exported data from SQL Server by XML format
Has done DBCC checks to ensure the physical consistency of the database and objects
Has created effective Backup and Recovery plan and utilized to recover data in point in time in case of disaster of database or server
Has designed and implemented Transactional Log, Differential and Full Database Backups to minimize the data loss and point of-time recovery of data incase of database corruption
Has tested the Recovery of the database frequently to ensure that Backup files not corrupted and optimal are monitored the performance of SQL Server and Windows using SQL Server Profiler, Windows 2003 Performance monitor and SQL Server Query Analyzer are implemented and maintained high availability of the database using SQL Server Clustering are provided on call support on after hours are supported multiple servers and databases in development, test and production environment

Environment : Compaq Proliant 8000/8500 WINDOWS 2003, MS SQL Server 2000/7.0, MS VISIO, MS Visual SourceSafe, MS DTS, T-SQL, VB Script and C#. NET

2000 -  2002

This application is mission critical OLTP environment to maintain F and A and Billing information for financial department of Cingular Wireless in Atlanta, GA. Data is maintained in SQL Server 2000 and Windows2000 environment and Compaq Proliant-8000/8500 hardware were utilized. Due to criticality and avail high availability of data, the SQL Server Log shipping service was utilized. are maintained data in multiple servers and the original application was migrated from SQL Server 7.0 to 2000. The data are replicated to remote servers using SQL Server Replication. This is a 24/7 environment and having accessing more than 200 users from local and remote locations. are supported the production environment as an on call Senior Production DBA.

ROLE : Senior SQL Server Production DBA

are worked as a Data Modeler, Database Administrator and System Administrator
Installed SQL Server 2000 and has done Performance Tuning of SQL Server and Database
Migrated Databases from Oracle 8i to SQL Server 2000
Converted Oracle PL/SQL Stored procedures and Triggers to SQL Server T-SQL Stored Procedures and Triggers
Generated Logical and Physical Database design using ER-Win and ER-Studio
Have done BPR to identify the performance bottlenecks in the
Database design of the application
Distributed the data to various locations using SQL Server Replication
Maintained high availability of the server using log shipping services of SQL Server
Has done query optimization using SQL Server query analyzer
Has provided secured and scalable environment in Windows2000
Has improved performance of the stored procedures by query optimization and fine tuned queries for better performance
Has created effective Backup and Recovery plan and utilized recover data in point in time in case of disaster of database or server
Has done DBCC checks to ensure the physical consistency of the database and objects
DTS Packages were created to transform data from this system to another business intelligence application using SQL Server DTS packages and BCP are monitored the performance of SQL Server and Windows using SQL Server Profiler, Windows 2000 Performance monitor and SQL Server Query Analyzer are done server side coding using VB Script and Java Script

Environment : WINDOWS 2000, MS SQL Server 2000/7.0, Compaq Proliant 8000/8500 ER-Win 4.0 ER-Studio 5.0 MS Visual SourceSafe, Oracle 8i, MS DTS, VB 6.0 COM, DCOM, VB Script, Java Script

Project 2. Budgeting and Forecasting Application
Budgeting and Forecasting Application is the Financial Forecasting System and it is a data warehousing application. is involved in their development team as database administrators for Designing and optimizing the Database Design, maintained data using MS Analysis Services and are provided support to the production environment. This application is developed on Windows 2000 platform.

ROLE : Senior SQL Server Production DBA
Have done logical and physical database design using ER-Win and ER-Studio
Designed and developed database schema for star schema design
Designed and implemented ETL for data migration and data staging from heterogeneous environment like MS Access, Sybase, Oracle and MS Excel using Informatica Power Mart and MS DTS
Created and optimized the MS OLAP Cubes for Fact and Dimension Tables
Performed Indexing Analysis and build better indexes and resolve performance
Problems using index tuning wizard in MS SQL Server Query Analyzer
Created the DTS packages for data import and export from/to text files, Oracle and Sybase databases
Distributed data to various remote sites using MS SQL Server Replication
Maintained OLAP Database and optimized the cube for better performance
Involved in debugging and testing of the application are done maintenance of the database and backup and recovery are done Planning, database implementation, performance monitoring, troubleshooting, performance tuning and backup and recovery and Administrative tasks in SQL Server 2000

Environment : WINDOWS 2000, MS SQL Server 2000, MS Analysis Services, Compaq Proliant 8000/8500
ER-Win 4.0 ER-Studio 5.0 VB 6.0 COM, DCOM, VB Script, Java Script, Informatica Power Mart, MS Visual SourceSafe

1994 -  1999

Handled various databases as SQL Server, Sybase DBA in Production and Development environments :
Project : Sales Order System
This system is designed and developed to maintain the Sales order details of the finished Cloth.

ROLE : SQL
Server Production DBA
Has done Performance Tuning of the SQL Server
Has created Database and devices
Managing Users and groups. Deciding on Access permissions.
Migrated the application and data from Sybase to SQL Server
Database performance monitoring, Tuning and performance enhancement.
Managed Database Backups and Recovery
Involved in Creation of Databases, Logs, Logins
Has done Data export and Import by using BCP

House keeping and Maintenance Work. DBCC checks
Created Views, Indexes, Stored Procedures and Triggers in MS SQL Server 6.5
Designed and created reports using Crystal Report Writer 4.1
Involved in system testing, implementation, user training, system documentation and preparing user manual.

Environment
WINDOWS NT 4.0 WINDOWS 95 MS SQL Server 6.5/7.0 Power Builder 5.0 Crystal Report Writer 4.1 ER-Win, SYBASE 11.5/11.0

Project : Stock Maintenance System
The Cotton Stock Maintenance is designed and developed to maintain the inventory of cotton.

ROLE : Development and Production DBA
Carried out requirement analysis, system design and Database design.
Migrated Databases from SQL Server 6.0 to 6.5
Managing Users and groups. Deciding on Access permissions.
Database performance monitoring, Tuning and performance enhancement.
Has done Data export and Import by using BCP
Created tables consisting of master and transaction tables with primary key, foreign key, defaults, rules and check constraints.
Created Views, indexes, Stored Procedures and Triggers in MS SQL Server 6.5
Involved in Creation of front end screens and Data windows using Power Builder 5.0

Environment
WINDOWS NT 4.0 WINDOWS 95 MS SQL Server 6.5/6.0, Power Builder 5.0, ER-Win

Project : Financial Accounting System
This system is designed and developed to maintain the Financial Accounting details of the company. This application maintains the transactions from Journal Entry to preparing the Final Profit and Loss and Balance Sheet of the company. It is highly mission Critical and OLTP Environment with more than 100 users are accessed from the local and remote locations.

ROLE : Development and Production DBA
Managing Users and groups. Deciding on Access permissions.
Has done Database performance monitoring, Tuning and performance enhancement.
Managed Database Backups and Recovery
Involved in Creation of Devices, Databases and Logins

Has done house keeping and Maintenance Work. DBCC checks
Has created tables and database objects
Designed and developed screens for transactions using SYBASE APT 5.3.0
Created procedures and Triggers in Sybase 10.0.01 T-SQL
Has written Shell scripts in C-Shell and Bourn Shell to provide menu driven interface for the application
Created Reports using DB-Library/C and Involved in system testing, implementation and documentation.
Environment

HP-9000 Series, HP-Infiniti-Pentium, HP-UNIX 10.0.1 WINDOWS NT 4.0 WINDOWS 95 TCP IP Network Protocol, SYBASE 10.0.01, SYBASE APT Work Bench 5.3.0 DB-Library/C, T-SQL, ISQL, DWB, Unix Shell Scripts

Project : Purchase Order Maintenance System
This application was developed to maintain the Purchase Order details of the company.

ROLE : Systems Analyst
Designed on-line system and generated coding Managing Users and groups. Involved in Creation of Devices, Databases, Logs, Logins
Created rules, primary key, foreign key and stored procedures for master and transaction tables in ORACLE 7.1. Has Created Procedures and Triggers.
Created the reports using Reports 2.0. Involved in testing and implementation of the system.

1992 -  1994

Education

Miscellaneous

As a programmer I have developed various business applications using Oracle, Power Builder 4.0 Visual FoxPro and FoxPro 2.0.