SUMMARY:

• Over seven years of experience MS SQL Servers 2005/ 2000 in Production, QA and Development Environments.
• Experience in designing the Logical data model and Physical data model
• Experience in supporting Large Databases up to a size of 2 Terabytes.
• Experience in Installing, configuring, Controlling, Monitoring data files, table spaces.
• Experience in migration of Data from Excel, DB2, Sybase, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Extensive experience in writing and debugging Complex Stored procedures, cursors, triggers, views and user-defined functions.
• Documented disaster recovery plans and participated in disaster recovery.
• Expert in writing TSQL stored procedures & DTS packages.
• Performance Tuning of SQL statements and database.
• Experience with supporting high-transaction/high-availability business applications.
• Attended webcasts and started working with SQL Server 2008, SSIS, SSRS and SSAS.
• Extensively worked with QA, release team and developers to give the required environment.
• 24x7 Support including scheduled and emergency night and weekend work
• Excellent communication skills, both oral and written and pleasing interpersonal skills

TECHNICAL SKILLS:

RDBMS : MS SQL Server 2000/2005/2008, Oracle 10g/9i/8i, Sybase
Other : Erwin, TOAD, Dimensional Data Modeling, Star/Snow-Flake Modeling, OEM, Enterprise Manager, Query Analyzer, and SQL Profiler.
Reporting Tools : MS Reporting Services, Crystal Reports XI, Business Objects XI r2/6.x
Languages : T-SQL, PL/SQL, C++, HTML and XML, SQL
Operating Systems : Windows2003/2000/NT, AIX, Linux

EDUCATION:
Bachelors of Science

EXPERIENCE:

Confidential, Tampa, FL Jan'08-Present
SQL Server DBA
Confidential is a leader in delivering broadband and other wireline and wireless communication innovations to mass market, business, government and wholesale customers. This application (Receivables Management) receives all the information related to receivables from other applications like Mainframes, eOrdering, CoFEE etc.
Responsibilities:

• Currently working on conversion from SQL server to Oracle enterprise with ODI, Essbase and OBIE.
• Worked closely with Mainframes applications with DB2 for receiving data and loading onto SQL server.
• Database design, including optimizing the database schema and coding database procedures/queries.
• Designing and building data load procedures, using MS SQL Server
• Capacity planning and Database growth in production box.
• Scalability and Availability of the Database in Production Environment.
• Worked on development for the enhancements to the existing applications.
• Wrote DTS scripts and scheduled jobs that extract data from database tables and write the data to text files.
• Configured product meta-data tables to support client data reporting needs.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Analyzed database performance with SQL query manager and Optimized indexes to significantly improve queries.
• Working with Different methods of taking Database Backup and Recovery procedures.
• Designed and developed backend packages in the database layer, stored procedures, functions and triggers. Wrote ad-hoc SQL for data analysis.
• Extensively used SQL SERVER BCP Utility and Import/ Export to load the database from text files received from different applications.
• Automated consistency check of the database (DBCC) for SQL Server.
• Analyzed & Fine-tuned performance at regular intervals.
• Generated database SQL scripts and deployed databases including installation and configuration
• Working with different types of Replication Models like Snapshot, Merge and Transactional.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

Environment: MS SQL Server 2008/2005/2000, Server Management Studio, Performance Monitor, BIDS, T-SQL, Index Tuning Wizard, SQLCMD, PL/SQL, TOAD, Oracle 10g, Enterprise Manager. Windows 2003/2000/XP

Confidential, Minneapolis Oct '06 to Dec ‘07
SQL Server DBA
Confidential is one of the largest healthcare providers in US. This application is useful for vendors for the internal acceptance of the policies. The application receives the input data from online booking policy customers. The data can even manually be entered by staff once when they are approved in the presence of customers and edit according to the needs of the policies requested by the customers.
Responsibilities:

• Involved in designing and implementing capacity planning, backup/recovery, tuning, and monitoring strategies.
• Constant monitoring and performance tuning of database, checking the most expensive queries.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Deployed the code on different environments (Development, Test, and Production).
• Detected and corrected bugs during system integration and user acceptance testing. Set up a fail-over environment to support a production environment,monitoring the stand by server.
• Documented the whole process flow, packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Worked closely with the application development teams to identify and implement continuous improvements and effective problem resolution strategies.
• Involved in system programming (Shell and SQL) to automate database pickup, monitoring and other DBA functions. Data & Schema transfers from SQL Server to SQL Server, SQL Server to text files and vice-versa.
• Backup tasks using OS backups, Oracle backups and as well as through Export/Import Wizard.
• Developed batch programs using Batch scripts to generate reports daily, weekly & monthly.
• Load data in different tables based on some conditions. Extensively used SQL SERVER BCP Utility and load the database from text files received from different applications.
• Automated consistency check of the database (DBCC) for SQL Server.
• Tuned the database to perform efficiently by managing databases using the option grow or shrink database files and monitor the size of transaction log.
• Created named backup devices to backup the server regularly.
• Wrote various T-SQL stored procedures and Triggers to carry out various tasks
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.

Environment: SQL Server 2000/2005, TOAD, Enterprise Manager, SQL Server Management Studio, Performance Monitor, BIDS, T-SQL, Index Tuning Wizard, SQLCMD, O-SQL, Database Mirroring, Database Snapshots, CLR Integration, Windows 2003/2000/XP

Confidential, CA
SQL Server DBA Jun'05-Sep' 06
Responsibilities:

• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Created sub programs both Server and Client side.
• Involved in table redesigning with implementation of partition table and partition indexes to make database faster and easier to maintain.
• Created ERD (Entity Relationship Diagram).
• Designed and developed backend packages in the database layer, stored procedures, functions and triggers. Wrote ad-hoc SQL for data analysis.
• Fine tuned application logic for better performance developed complex queries, functions, stored procedures and triggers using PL/SQL
• Tuned frequently used SQL statements using TOAD and increased performance by passing appropriate HINTS, by utilizing the best optimization techniques.
• Involved in designing the transfer of data to the Oracle database.
• Performed translations and validations on the data in the legacy tables to prepare for loading into Oracle 10g.
• Developed program specification according to service request received from the users.
• Involved in creation of DTS Scheduled Packages for the daily transfer of data from Oracle Databases to SQL Server Databases.
• Analyzed & Fine-tuned the SQL Server performance at regular intervals.
• Created the necessary indexes to improve the query performance.
• Writing packages, stored procedures, functions to pick up the appropriate data.
• Design and develop and scheduling the various DTS package for data migration, ftp the database, bulk load data using BCP, import/export.
• Setup the performance counter by using performance monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Identify and analyze the most expensive T-SQL stored procedure by using the SQL Profiler, SQL analyzer and Index tuning wizard.
• Ability to handle multiple tasks and capable of handling responsibilities independently as well as a proactive team member.

Environment: SQL Server 2000(8.0), SQL* Plus, PL/SQL, T-SQL, SQL*Loader, Query Analyzer, Enterprise Manager, ISQL, OSQL, DTS, TOAD, Windows 2000/XP/NT.

Confidential, CT April '03 to May '05
SQL Server DBA
The system keeps track of the customer record, escalation of the call, prioritization of the call, defect tracking, searching the solution based on some key words, company information, employee information, user information, asset management, inventory control; vendor information management. It also provides inclusion of new asset type and inventory.
Responsibilities:

• Installed and administered SQL Server 8.0/ORACLE 9.x and created databases.
• Created login accounts and database user accounts and managed database security using groups and roles.
• Created database objects and managed the permission access on the objects with necessary security.
• Created stored procedures, query optimization, triggers, schedule and monitoring the jobs.
• Estimated the space and capacity planning on tables.
• Created and scheduled the packages using SQL Server DTS packages.
• Automated SQL Server /ORACLE database/Transaction backup.
• Extensively used SQL SERVER BCP Utility and Oracle Import/ Export to load the database from text files received from different applications.
• Automated consistency check of the database (DBCC) for SQL Server.
• Analyzed & Fine-tuned the SQL Server performance at regular intervals.
• Created the necessary indexes to improve the query performance.
• Extensively used stored procedures to perform complex operation. Debugged and tested stored procedure from developers and improved the performance.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working.
• Defined the database deployment process for the extranet applications. ata modeling, backups andrecovery.

Environment: SQL Server 2000, SQL Server 7.0, Oracle 9i, SQL* Plus, PL/SQL, T-SQL, SQL*Loader, Query Analyzer, Enterprise Manager, ISQL, OSQL, DTS, TOAD, MS-Office. Windows 2000 Server, Windows ME

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Productionenvironment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables

Environment: SQL Server 7.0, Oracle 8i, Windows NT, C++, HTML, T-SQL, PL/SQL, SQL*Loader.