SUMMARY

• 7 years of experience in SQL server Database Administration for very large and complex databases using SQL Server 2012, 2008 R2 and 2005
• Strong technical background includes performing business analysis, writing documentation and specifications, T - SQL, stored procedures, triggers, functions, SSIS, DTS, BCP/Bulk insert.
• Run queries between SQL servers and other data sources using ODBC/ OLE DB.
• Outstanding experience in Database Monitoring tools, Application Support, Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience in managing large database in 24/7 environment (Test, Dev & Production)
• Self-motivated, proactive, team player, able to manage own projects efficiently for on-time delivery.
• Excellent verbal, written and presentation skills, Independent problem solving and detail oriented skills.
• Proven ability to manage multiple tasks with different vendors.
• Excellent coordination, cooperation, organizational, interpersonal skills and cross group Collaboration.
• Migrated SQL Server from 2000 and 2005databases into SQL Server 2008 and SQL Server 2012.
• Extensively worked on installing and configuring (32bit/64bit) different versions SQL Server2008 R2,2012 and updating with latest hot fixes and service packs.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Expertise in auditing events such as logins, logouts, server boot operations, accesses to database objects, and actions performed by a specific user with a particular role active
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MSSQL server by using BCP utility, DTS and SSIS services.
• Created and tested Database Backup Procedures and Disaster Recovery procedures
• Proficient in performance and tuning, diagnosing server problems
• Fine tuning the server by setting configuration parameters, limiting access to server resource
• Experience in Monitoring queues, routes, threads and connections of Replication Server in different sites with huge replication data.
• Migrated SQL Server 2005 data to SQL Server 2008 using SQL Server integration services (SSIS)

TECHNICAL SKILLS

Database: MS SQL Server 2008,2005 MS Access 2003 & 2000

Operating System: Windows Server 2008, Windows XP/NT4.0, MS-DOS, VMware

Languages: SQL, T-SQL, Store Procedures, Trigger, Web Design, HTML, DHTML, XML JavaScript, ASP, ASP.net

ETL Tool: SSIS/DTS, BCP, OSQL, ISQL

Reporting Tool: SSRS (SQL Server Reporting Services)

Data Modeling: Toad Data Modeler, ERWin

Networking: Active Directory, TCP/IP, DHCP/DNS, LAN

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. SQL Server DBA

Responsibilities:

• Installed and Configured, and Managed SQL Server 2012 and 2008 R2 managed in development, test and production environment.
• Installed, configured and maintained Database Mirroring, Log Shipping and Replication
• Maintained Fail-Over Clustering using SQL Server 2012/20008 R2.
• Installed, configured and administered SQL Server Reporting Services (SSRS). Developed Reports using SSRS and deployed Reports
• Managed security of Reports and Report Server
• Developed Ad-hoc Reports
• Upgraded Databases from SQL Server 2005 to SQL Server 2008 R2/ 2012
• Migrated Databases from Oracle 10gR2 databases to SQL Server 2008 R2 and 2012, and MySQL 5.1.23 databases to SQL Server 2008 R2
• Applied SP (Service Pack) and HOT Fixes on SQL Server 2000, 2005, 2008 R2 and 2012
• Worked on many data modeling projects. Created and managed E-R Diagram Data Modeling tools. Used Toad Data Modeler. Used Backward & Forward Engineering with data modeling tools mentioned above.
• Managed security by creating Groups, Logins, and users with proper authentication and grant them appropriate permission on Server level, Database level as well as Object level.
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring
• Experienced on database monitoring, performance tuning and query optimization as well as monitoring SQL Server Error Log, space usage and solving related issues as needed.
• Scheduled and maintained new and existing jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification, database statistics, rebuild or reorganize indexes.
• Created notification if there is any failure, error, warning or disk issue.
• Wrote T-SQL, Trigger, Stored-Procedures and assisted Database Developers to Optimize SQL queries and Stored Procedures and Triggers.
• Exported & Imported data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
• Strong knowledge and working experience in Database Backup and Disaster Recovery and created Backup strategy for production development environment.
• Experienced with Point-in-Time Recovery
• Implemented multidimensional cubes with measures, hierarchies, calculations, KPIs, partitions to support analysis needs and fast data retrieval.

Environment: Windows Server 2012 R2, 2008 R2, IIS 7.5, Apache Tomcat 5.5, SQL Server 2012, 2008 R2, 2005, 2000, ASP, ASP.net, PHP, AD (Active Directory)

Confidential, Harrisburg, PA

Sr. SQL Server DBA

Responsibilities:

• Installed, configured, and managed SQL Server 2008 R2, 2005 & 2000 in development, test and production environment
• Configure and maintained Database Mirroring, Log Shipping and Replication.
• Installed, configured, and administered SQL Server Reporting Services (SSRS)
• Developed Reports using SSRS and deployed Reports
• Upgrade Databases from SQL Server R2 and 2012
• Migrated Databases (development, testing and production environment ) MS Access 2003/2000/97 databases into MS SQL Server 2008 R2 and 2012
• Migrated Databases from Oracle 10g databases to SQL Server 2008 R2, My-SQL 5.1.23 databases to SQL Server 2005 and 2008 R2
• Participated in data modeling projects and generated E-R Diagram Data Modeling tools using SQL Server Data Diagram.
• Applied SP and HOT Fixes on SQL Server 2000, 2005, 2008R2
• Performed on database Monitoring and Performance tuning using SQL profiler, Database Tuning Advisor and Windows performance monitor.
• Identified slow running queries and Stored procedures and tuned them.
• Experienced on creating and using stored procedures, functions, Triggers and T-SQL.
• Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes
• Created, scheduled and maintained automated job for backup, backup validation, disk space and monitoring database health.
• Exported & Imported data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
• Strong knowledge and working experience in Database Backup and Disaster Recovery and restoring Database from backup
• Created and implemented backup strategy for production and development environment.
• Experienced with Point-in-Time Recovery
• Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring
• Attended Weekly and monthly meetings.

Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, Apache, Tomcat 5.5, SQL Server 2008 R2, 2005, 2000 ASP, ASP.net, PHP, AD (Active Directory)

Confidential, Mt.Laurel, NJ

SQL Server DBA

Responsibilities:

• Database Administrator, Database Programming.
• Performed server installation and configuration for SQL Server 2005 and SQL Server 2000.
• Performed installation of SQL Server Service Packs.
• Upgraded databases in SQL Server 2000 to SQL Server 2005.
• Involved in capacity planning, sizing and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments when necessary.
• Created Transactional replication for the reporting apps.
• Implemented DR solution at the remote site for the production databases using Log Shipping.
• Setup Database Maintenance Plans to reorganize indexes, re - indexing and update the index statistics on the production databases.
• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Used SQL Server Profiler to monitor and record database activities of particular users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
• Extensive use of DDL and DML Triggers to implement business logic and for auditing changes to critical tables in the database
• Checked code for ANSI standards using Standard Code Checker Tool
• Developed SSIS packages, scheduled them as jobs and deployed packages in SQL Server Integration Services
• Developed customized reports using SSRS and administered the SQL Server Report server
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Worked on upgrading DTS packages to SSIS packages.
• Creation of various data objects like tables, views and indexes.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
• Reviewed DB Scripts from the development team before releasing them into the Production.

Environment: SQL Server 2005, SSIS, SSRS, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows NT/2003, UNIX.

Confidential

SQL Server DBA

Responsibilities:

• Installation of MS SQL 2008/2005 Enterprise servers on production, Test and Development boxes.
• Handling user requested issues through Service Tickets.
• Involved in creating Schemas, Logins, Tables, Clustered and Non - Clustered Indexes, Views, Functions and Stored Procedures.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• On call 24/7 support to databases on weekly rotation.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created SSIS Packages to migrate the data from database to Text files.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Created new replications and addressed the Replication Issues to maintain high availability of the data between the servers.
• Worked on DTS Package, DTS Import/Export for transferring data between Database (Oracle and Text format data) to SQL Server
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in development teams including project planning, estimating, programming and testing.

Environment: MS-SQL Server 2005/2000, SSIS, SSRS, Windows 2003/2000/NT4.0, Clustering, Replication, Erwin3.5.2/4.0, DTS, Visual Basic6.0/VB.net, VB Script and Visual Source Safe.