SUMMARY:

• Over eight years of extensive experience in MS SQL Server database administration and database development.
• Production experience in administering MS SQL Server 2008, 2005, 2000 and 7.0
• Experience in MS SQL Server installation, database configuration, indexing, implementation of backup and recovery, tuning databases, database migrations, standby database setup, replication and troubleshooting of various products/versions on Windows NT (4.0)/2000 Advanced Server/2003 Enterprise servers.
• Excellent understanding of RDBMS and design of database architecture.
• Overall database design, such as creating normalized databases, query tuning, assigning proper indexes, partitioned views, creation of triggers, and stored procedures.
• Experienced in implementing and configuring database mirroring, log shipping, replication, and clustering and database snapshots to ensure high availability, data protection, and disaster recovery.
• Efficient usage of Dynamic Management Views (DMV’s) for troubleshooting and table partitions, multiple file groups for enhanced query performance.
• Experience in supporting huge databases, troubleshooting problems, and documenting root cause analysis.
• Expertise in designing and implementing ETL and BI solutions using SQL Server 2008/2005 integration (SSIS) and reporting (SSRS).
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Utilized Access, Excel and SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports
• Extensive experience in database migration and upgrade from SQL Server and 2008.
• Experienced in monitoring performance, activity, and auditing using tools/utilities: SQL Server Profiler Trace, SSMS, DDL triggers and event notification.
• Proficient in end - to-end troubleshooting to mitigate performance issues caused by blocks and deadlocks.
• Experience with SQL Litespeed as a backup solution for MS SQL Servers.
• Proficient in monitoring SQL Server performance using SQL Profiler and Windows Performance Monitor.
• Experience in data modeling using MS Visio and ERWIN
• Worked in OLTP and OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Extensive work experience in production 24/7 support and problem solving skills during disaster situations.
• Have documented disaster recovery plans and participated in disaster recovery drills.

TECHNICAL SKILLS:

RDBMSMS: SQL Server 2008, 2005, 2000, 7.0, Oracle9i/10g, MS Access 2007

Business Intelligence: SSIS, SSRS, SSAS

Operating Systems: Windows Server 2008/2003/2000, Windows Vista, Windows XP, Windows 7.0

Other Tools: SQL Litespeed, Database Tuning Advisor (DTA), MS Visio, Business Intelligence Development Studio (BIDS), SQL Server Profiler, Report Builder 2.0, MS Outlook 2007

Languages: C, T-SQL, SQL, PL/SQL, VB.NET, HTML, XML

ERP: SAP ABAP, SAP SD, SAP CRM

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

SQL Server DBA/Developer

Responsibilities:

• Installation of the Microsoft SQL Server 2005 and 2008 on New Production and Test servers with latest Security updates involving Service Packs and Security patches.
• Performed data migration from SQL Server 2005 to SQL Server 2008.
• Provided support for existing Disaster Recovery procedures and Experience in Data Modelling.
• Created user logins with appropriate roles and granting the privileges to appropriate users and groups.
• Good in recovering databases from damaged or suspect conditions
• Monitored and modified performance using execution plans and Index tuning.
• Configured Transactional replication between Primary Server and Dedicated servers, with separate Distributor server and experience in troubleshooting replication issues.
• Prepared and documented Backup & Restore Plans.
• Implemented backup process using SQL Lite Speed a Backup solution for MS SQL Server.
• Implemented and successfully tested Log Shipping in SQL Server 2005 and SQL Server 2008.
• Involved in Performance tuning with the help of SQL Server Profiler, Database Engine Tuning advisor & windows performance monitor.
• Performing administration tasks on the live databases like re-indexing, shrinking databases, rebuilding full text catalogs.
• Backing up master & system databases and restoring them when necessary and automated backup processes using SQL Server jobs.
• Create and maintain database Maintenance plans on various production and development SQL servers.
• Resolved locking (Dead Locks) and blocking issues.
• Partitioning tables to achieve better performance for access and writes.
• Created and deployed SSIS Packages to import and export data from various flat files and Database Replication experience.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Designed various reports using different reporting features such as group by, drilldowns, drill through
• Created parameters for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts, images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Created report models for Ad-hoc reporting
• Created weekly and monthly reports as per requirement using SSRS.
• Scheduled Reports to be delivered to User on demand Basis in SSRS report Manager.

Environment: SQL server 2008/2005 Enterprise edition, SSIS, SSRS, Windows 2003 Standard Edition, Windows 2000 Advanced Server, SQL Lite Speed, Erwin 7.2

Confidential, Charlotte, NC

SQL Server Developer/ DBA

Responsibilities:

• SQL SERVER 2005/2000 production Environment.
• Updating Microsoft patches/Service packs on SQL server and Windows Server 2003/2005
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at the SQL SERVER LEVEL.
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Database Modeling using Normalization Principles for Minimizing Date Redundancy, Data Restructuring, I/O using small transactions and to maintain Referential Integrity
• Wrote Triggers, Functions, Views, Cursors and stored procedures according to the business client applications.
• Wrote Scripts in the Maintenance Plans for Performance Tuning and for measures due to Fragmentation.
• Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and updating statistics manually
• Designed and implemented comprehensive Backup plan and disaster recovery.
• Good experience in data modeling and metadata services.
• Used APPLY clause and also implemented with CROSS and OUTER APPLY to join tables and table variable functions. Worked with SQL Server 2008 new MERGE statement
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Handling Memory configurations for SQL Server 2000/2005 and SQL Server 2005/2008 on Windows 2003/2008
• Migrated DTS packages to SSIS packages and maintained the archival data, Monitored and modified Performance using execution plans and Index tuning.
• Expertise in SQL server Reporting Services (SSRS) and Created ADHOC reports using SSRS in BIDS.
• Recovered the System and User databases from suspect mode, Expert in sizing Temp database.
• Used log shipping for synchronization of databases and performed Database mirroring and Clustering (2-node,Active-Passive)
• Prepared Documentation for the Disaster Recovery plan, Worked in Active passive cluster environment
• Extensively used litespeed backup with MS SQL SERVER 2005/2008.
• Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Actively involved in the analysis of Cubes and added the Key Performance Indicators (KPI) to the created cubes

Environment: SQL Server 2000/2005/2008 with clustering, Replication, T-SQL, Windows bit, BugZilla, DTS, SSIS, Profiler, SQL Sentry, Oracle 10g,TFS,LiteSpeed, Crystal Reports, PERL, XML, Web Services

Confidential, Secaucus, NJ

SQL DBA

Responsibilities:

• SQL Server 2008 Database Administration.
• Managed the migration of SQL Server 2005 databases to SQL Server 2008.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in the design and creation of the logical and physical databases using Erwin 4.0.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1.5 Terabytes.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC and DMV at regular intervals.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Did trouble shooting of Client connections, viewing error log and applications.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Using Log shipping for synchronization of database.
• Worked with other database administrators, report writers, and project teams to refine reporting requirements based on customer's business needs
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager.

Environment: MS SQL Server 2008, VS2008, SQL Server Reporting Services (SSRS 2008), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, Oracle 9i, Toad, MS Excel

Confidential, Indianapolis, IN

Production Support Database Administrator

Responsibilities:

• Administrated 900+ databases on 26SQLServersin production, dev, QA, staging, and test environments.
• Monitored performance on Kaplan’s Mission Critical production databases and implemented best practice strategies for enhanced performance of customer sites.
• Recovered production database from hardware failure with minimal data loss.
• Implemented day-to-day operations such as database creation, monitoring disk space, monitoring performance using Profiler, implementation, testing, maintenance, and troubleshooting of software applications.
• Implemented stringent quality checks for data push with every production release and responsible for all code deployments to production.
• Implemented transactional replication to meet reporting services requirements.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports
• Responsible for optimization of existing stored procedures and created new ones to support faster data retrieval by existing applications.
• Monitored database system resources and performance.
• On-call during off hours and weekends on a rotation basis.
• Responsible for patching servers with required hot fixes and security updates.
• Coordinated database system upgrades with IT team, end users, and vendors.

Environment: SQL Server 2005, SQL Profiler, Windows 2003/2000 Server, DTS, SSRS, SSIS

Confidential, Englewood, NJ

SQL DBA

Responsibilities:

• Complete administration of MS SQL 2000/2005 servers.
• Installation and configuration of MS SQL Server on Windows 2000/2003 Servers.
• Migration of databases from MS SQL 2000 to MS SQL 2005.
• Logical and Physical design of database for projects on basis of user requirement.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.
• Implemented and maintained database security.
• Experience with high availability ends like Replication and Clustering as well log shipping
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Used DTS package for backup and restore.
• Performed Database backups (operating system, flat file backups & export/import).
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Used Query Analyzer to optimize SQL Queries.
• Created hierarchies and dimensions for creating cubes in SSAS
• Developed standards and guidelines to maintain and develop and administer the SQL Server database.
• Handled corrupt databases diagnosed and repaired them and was involved to transfer the OLTP data to Data Warehouse

Environment: SQL Server 2000/2005, T-SQL, MS Reporting Services, Management Studio, SSIS, SSAS, Query Analyzer, Windows 2000/2003 Server, Oracle 9i.

Confidential, New York NY

SQL Database Administrator

Responsibilities:

• Management of SQL Servers, databases, storage management for databases.
• Management of database objects such as tables, views, indexes etc.
• Management of users including creation/alteration, grant of system/db roles and permissions on various database objects.
• Involved in writing Transact-SQL command line script for various needs.
• Evaluated data storage considerations to store databases and transaction logs.
• Involved in Migration of SQL server and also on new hardware with the platform of windows2000 and 2003.
• Used DTS to perform the ETL tasks
• Tuned the database to perform efficiently by managing databases.
• For transferring, used data import and Export utility and BCP command line utility.
• Monitoring the server for High availability of the servers solving the raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Tuned Stored Procedures, DTS packages for accuracy of Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.

Environment: SQL Server 2000 & 2005, Windows 2000 & 2003 server, Enterprise Manager, SSIS, SSRS, Query Analyzer

Confidential, Jacksonville FL

SQL DBA

Responsibilities:

• Identified the necessary steps to enhance user response time by checking fragmentation and reindex tables for efficient application access methods.
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore
• Rebuild Indexes on Various tables.
• Scheduling activities for Maintaining Databases and installed MS SQL Servers 2000.
• Designed DTS package to export SQL Server data to Access Database.
• Set up, configure and administer Snapshot and Transactional Replication on MS SQL Server 2005.
• Administered Backup and recovery and administered Disk and Database Space.
• Administered the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, granting the privileges to users and groups.
• Assign users to particular roles and scheduled the job for Database Backup, Transaction Log Backup.
• Ran various DBCC commands like checkdb/checktable, showcontig, showstatistics etc. for checking database/table consistency and system performance.
• To ensure all scheduled administrative jobs are running/completed for Microsoft SQL Servers.
• Involved in implementing Log Shipping
• Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.

Environment: MS SQL Server 2000, Windows 2000 Server

Enterprise Manager

Confidential

Responsibilities:

• Planned database capacity, infrastructure, configuration and backup/recover strategies
• Performed Relational and OLAP databases installation, configuration, migration, upgrade and performance optimization and tuning
• Perform Database upgrades.
• Maintained standby servers using log shipping and replication concepts.
• Assigned permission to User(s), Role(s) and objects.
• Designed and created data marts, databases, indexes, views, aggregations, store procedures, partitions and data integrity
• Transformed data from various data sources using OLE DB connection by creating DTS packages.
• Designed and implemented data extraction, transformation and loading from legacy systems, other RDBMS systems and flat files via SSIS services
• Created data transformation/validation components using VBA, VB, stored procedures and functions
• Scheduled and monitored all maintenance activities, database consistency check, index defragment
• Configured securities and accesses to production databases and database servers
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code
• Interacting with Business Analysts and Developers in identifying the business requirements, designing and implementing the database schema.
• Provided technical support to internal developers and external clients

Environment: Access, SQL Server 2005, Visual Studio 2005, XML, MS Visio