SUMMARY

• 7 years of IT Professional experience in Development, Client Analysis, Database Design, Testing and Support and presentation using SQL Server 2000/2005/2008 R2.
• Extensive working experience in various industries including banking, financial, marketing services, and healthcare industry.
• Experience in an operational environment providing support, involving coordination with release Management and Change management.
• Extensive experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008 R2 on both Cluster and Stand - alone Environment.
• Database Design in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases with Point in Time Recovery.
• Extensive experience in designing, implementation and administration SQL Server Relational Database / Data Modeling, Data Warehouse in small, medium and large organizations.
• Replication, Snapshot Replication and Merge Replication.
• Experience in Log Shipping (Configuration of source, Target and Monitor) Servers in SQL Server 2005.SQL Server Integration Services.
• Knowledge of SQL CLR, Service Broker and other new features in SQL Server 2005, SQL Server Reporting Services and SQL Server Analysis Services.
• Worked on various SSIS/dts packages for data import/export/transformations from different OLEDB/Flat source to SQL 2005/SQL 2008.
• Good understanding of High availability techniques Database Mirroring and Clustering.
• Extensive experience in Creating alerts for SQL Server Performance.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Optimization and Maintenance tasks including Re-indexing, Updating Statistics, Shrinking Databases and Recompiling Stored Procedures.
• Experience in working with Linked Servers, Distributed Transactions, and Federated Databases.
• Hands-on working experience with analyzing query plans, query optimization, performance tuning, managing indexes and locks, troubleshooting deadlocks.
• Running of Traces using SQL Profiler tool, Performance Monitoring & Tuning using Performance Monitoring Tool, Query Optimization, Client / Server Connectivity.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2005/ 2008.
• Involved in implementing transactional replication in a high OLTP environment.
• Experienced in configuring SQL Mail.
• Creating and Maintaining Databases, Adding Users, Roles and Groups and assigning privileges according to the project needs.
• Expertise in T-SQL, Stored Procedures, Functions, Cursors and Triggers etc.
• Used Indexes for improving query performance, lower storage and maintenance cost.
• Strong Expertise in providing appropriate resources for business applications with enough resources for their short-term and long-term growth by performing capacity planning, workload modeling and prediction.

TECHNICAL SKILLS

Languages: Java, C#, ASP.NET, VB.NET,JSP, JDBC, JDOM, XML, VB C++, Java Script-SQL, PL/SQL.

Databases: MS SQL Server 2000/2005/2008 R2, MYSQL 5.0, Oracle, MS Access.

ETL tools: DTS, SSIS, Informatica.

Operating System: Windows 2000, 2003, XP, Vista.

Software Tools: Visual Studio 2005, Visual Source safe, Microsoft Visio, MS Excel, Win Runner 7.5, Load Runner 7.0, Rational Suite, QTP 8.0, Test Director, Web Tools(Dream weaver), Macromedia Flash 2004, Siebel MS expression web and MS sharepoint designer.

Other Tools: SQL*Plus, SQL*Loader, TOAD, SQL Navigator, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Branchville, NJ

SQL Server DBA

Responsibilities:

• Administrated and Managed SQL Server 2008R 2/2008/2005/2000 databases in Production, Staging, QA and development environments.
• Responsibilities include the Production and Application Support for the Database and Application Servers.
• Upgraded/Migrated SQL Server 2000 databases to SQL Server 2008R2/2008/2005 databases and mentored other technical staff.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Resolving performance issues using DMVs (Dynamic Management Views).
• Used native tools like Database Tuning Advisor, SQL Server Profiler, Performance Monitor and Activity Monitor for performance tuning.
• Installing, Configuring and Maintaining SQL Server 2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans. Checked servers for optimizations and implemented them.
• Troubleshooting blocking issues, deadlocks using blocker scripts, trace flags and activity monitor.
• Designed the Database Recovery plan and implemented the Database Mirroring in SQL Server 2008/2005 and participated in Disaster Recovery Drill processes.
• Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Policy based Management, Table Compression, Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• Performed data partitioning for efficient management of database tables and indexes.
• Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Change Data Capture process.
• Maintained Production and Test Database Environment in SQL server 2008R 2/2008/2005.
• Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
• Designed and developed SSIS packages using different control flow tasks, data flow task and data transformations.
• Debugged and Deployed SSIS packages in to file system server and MS SQL Server with the help of manifest file.
• Designed, Developed, Configured and Deployed custom build business reports using MS Reporting Services - SSRS.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers

Environment: Microsoft Windows 2008 Server, Microsoft SQL Server 2008 R2, Microsoft SQL Server 2005, TSQL

Confidential, OH

MS SQL Server DBA

Responsibilities:

• Install and configure SQL Server 2005 and 2008 instances in both production and development environments on standalone and clustered environments (Active/Active and Active/Passive).
• Apply regular security fixes and service packs in a timely manner.
• Upgraded/migrated most of the sqlserver 2000/ 2005 instances to sqlserver 2008
• Deployed database changes accordance with change management policies and procedures.
• Created Stored procedures and SSIS packages import the data from access, oracle databases to SQL Server
• Used linked server’s on SQL Servers to import tables from other SQL Servers & oracle databases
• Created automated scripts, SQL Jobs, Operators, Alerts and Mail Profile to monitor/generate report on the database health
• Administering the database by managing free space, user management and access rights permissions, and doing performance and tuning of the database and job scheduling on daily basis
• Created the database maintenance plans for monitoring, optimization and integrity check.
• Involved installation of SQL Server Analysis Services(SSAS) 2005/2008 by Using Setup.
• Monitor daily backup of databases on production servers.
• Monitor and schedule existing/ new jobs on production server.
• Implemented the Partitioned Tables and Indexes in SQL Server 2005/2008
• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.
• Changed Sysadmin passwords automatically and periodically using password vault.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005 on Windows 2003
• Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O, SQL queries
• Involved in monitoring performance and managing parameters to provide fast query responses
• Create Views to access the tables and assign specific permission to the users
• Monitored and managed database growth and capacity and tuned database performance using Performance Monitor, SQL profiler and quest spotlight.
• Assisted application analysts with report writing functions using SSRS as requested
• Assisted application analyst in converting all applicable Microsoft Access databases to SQLSERVER
• Coordinated with software vendors and performs all database upgrades
• Implemented HIPAA security measures to monitor data security and activity.
• Assisted application analysts to Facilitate inter-database access and report writing using SSIS and linked servers
• Involved in database capacity planning and provide system administrators about the hardware requirement
• Create detailed documentation of all database administration policies and procedures and detailed troubleshooting documentation
• Works closely with operations staff to ensure stable performance for the database environments to monitor, analyze, identify and resolve bottlenecks and problems

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SQL Server 2008,DB2, T-SQL, DTS, Windows 2003 Server, SSIS, SQL profiler, SSRS, TABLEAU, Questlite Speed,VBScript, Veritas Netbackup, DBartisian, Quest spotlite, Password Safe, Terminal Services, IP Monitor, SQL Trace, BCP, DTS Import/Export, Visual Source Safe 2008,Profiler, Query Analyzer

Confidential, Cincinnati OH

SQL Server DBA/Developer

Responsibilities:

• Create and maintain various databases for Development and Testing Environment using SQL Server 2005/2008 and involve in actual Relational Database Design for high OLTP environment
• Worked with Client/Server tools like SQL Server Enterprise Manager and Query analyzer to administer SQL Server
• Created a database model by using Erwin 4.0 and also designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity
• Created scripts for tables, stored procedures, and DTS and SSIS, (SQL 2K5) tasks
• Physical Implementation and application of Schema changes to SQL Server database using Power Designer View
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Actively monitored performances of queries on SQL server using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Good experience on working with Extract, Transform and Load (ETL) tool
• Exposed to data conversion from different data sources to SQL server 2008 using SSIS
• Using Import/Export wizard to move data from flat files and Excel sheets to SQL Server using SSIS
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports
• Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions

Environment: SQL Server 2008, SSIS, SSRS, Windows Server 2003, Visual Source Safe 6.0, C#, Visual Basic.

Confidential, Malvern, PA

SQL Server DBA

Responsibilities:

• Install, configure SQL Server 2008 and SQL Server 2005 versions.
• Configure relevant SQL Server components including database backup, consistency, integrity and network utilities to ensure health and access of each database.
• Resolving the day to day maintenance tasks.
• Applied service packs on SQL Server 2000 and SQL Server 2005.
• Worked extensively with SSIS SQL Server 2005 to automate DBA tasks.
• Migrated DTS packages and jobs from SQL Server 2000 to SQL Server 2005.
• Worked extensively with backup and restore requests.
• Worked with application development staff to enforce SQL Server database architectures coding standards and quality assurance requirements in accordance with Cephalon change control and testing procedures and policies.
• Respond and resolve database access and performance issues to meet business SLA's.
• Monitor database system details with in the database including the stored procedures and execution times and implement efficiency improvements.
• Also must be able to perform database transaction and security audit.
• Support redundant systems for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Created a mirrored database on the report server using database mirroring.
• Proactively monitor, optimize and allocate physical data storage for SQL Server database systems to ensure minimum down time.
• Create or support creation of required reports in response to the business user needs.
• Evaluate database monitoring tools including tasks to be monitored.
• Used space manager tool find space occupied on the disk

Environment: SQL Server 2008/ 2005/2000 , T-SQL, SQL Server Integration Services, Window server 2008, Windows Server 2003

Confidential, NY

SQL Server DBA

Responsibilities:

• Interacted with users to gather business requirements
• Modified existing database by adding tables and relationships
• Configured database backup schedules to help in disaster recovery
• Created views as per the requirement of front-end developer for easier implementation on ASP.NET pages
• Worked with BCP and DTS to load text files to SQL Server.
• Maintaining the data, database backups and restoration, backup strategies, scheduling backups
• Created stored procedures and functions to support complex wealth management logic
• Ensured the performance of queries by removing unnecessary columns, normalizing tables, established joins and created indexes wherever necessary
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server
• Created Database Maintenance Planner for the performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
• Involved in testing, bug fixing and documentation for the project
• Created stored procedures and functions to support complex wealth management logic

Environment: SQL Server 2000, Windows server 2003, Windows 2000/XP, MS Visual Studio

Confidential

SQL Server DBA

Responsibilities:

• Actively participated in gathering User Requirements and System Specifications.
• Filtered unnecessary data using complex T-SQL statements, implemented various Constraints and Triggers for data consistency.
• Created Views to facilitate easy user interface implementation, and Triggers on them to facilitate consistency Data entry into the database.
• Created Reports from database onto excel spread sheet using DTS.
• Wrote complex stored procedures to process employee’s requirements and generating records between front end and back end.
• Created various reports using Crystal Reports after performing Data Analysis on the various Views of Business Intelligence.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure optimal performance of the server.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
• Involved in fine Tuning Performance and Query optimization of the Database as required by the application.
• Created Users and Roles, managed security and permissions of the databases.
• Maintained SQL Scripts for creation of Database Objects.

Environment: SQL Server 2000, Windows NT 4 Platform, EXCEL, Erwin 3.x, Crystal Reports 9.