OBJECTIVE

• A position as Microsoft SQL DBA where my significant SQL functional and technical knowledge and team work skills will be of great value to SQL Implementation and support projects.

SUMMARY

• Over 8+ Years of SQL Server DBA/Developer experience in Database Administration, System Analysis, Design, Development, Security and Support of MS SQL Server 2012, 2008, 2008R2, 2005, 2000 in Production (24x7), Testing, Development, Replication & Cluster Server Environments.
• Strong RDBMS concepts and experience in creating and maintaining Stored Procedures, Views, Functions, Triggers, Indexes, and Constraints.
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility
• Experience in SSIS\SSRS\SSAS. Wide experience in building static, dynamic and interactive reports using BIDS and Report Builder.
• Expert in migrating data from one SQL Server version to another.
• Supports day to day operational duties for the database platform such as service requests and tickets, backups, monitoring, performance tuning, system troubleshooting.
• Experience in Database Backup, Recovery and Disaster Recovery Procedures.
• Extensive experience in implementing high availability and disaster recovery technologies such log shipping, mirroring, Replication, Always ON and failover clustering.
• Excellent T - SQL Programming skills, Execution Plan, query optimization & performance tuning Query Optimization, Re-Indexing, Updating Statistics, tuning Stored Procedures and performing Maintenance Tasks, using DBCC commands
• Created maintenance plans to perform index defragmentation, re-indexing and update the index statistics.
• Experience working with DTS Packages, migrating DTS packages.
• Proficient with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, SQL Profiler, restoring full, differential, and log backups.
• Experience in Using Performance Monitor/Profiler to resolve Dead Locks/Long Running Queries and to resolve System Hardware bottlenecks.
• Expert in Database migration from MS SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008, and SQL Server 2008/2008R2 to SQL Server 2012.
• Worked extensively in OLTP & OLAP environments that included Production (24x7), QA and database development in SQL Server.
• Good operating knowledge in third party tools such as NetBackup, Lite Speed Pervasive ETL, SQL Assistant ERWIN, Red-Gate and Spotlight
• Worked closely with development and Technical Support team to resolve quality issues.
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project
• 24x7 Production Database on Call Support.

TECHNICAL SKILLS

RDBMS: SQL Server 2012/2008/2008 R 2/2005/2000/7.0 , Oracle 9i/10g, MS-Access 2000/2003/2007

Database Tools: SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS, SSRS, DTS, BCP, ODBC, SQL OLEDB, DBCC, Business Intelligence Studio, Crystal Reports

Languages\Tools: VB.NET, Visual Basic, C++, PowerShell, C#, XML, SQL, T-SQL

Operating Systems: Windows Server 2012, 2008R2, 2008, 2003, Win ME/NT/XP, UNIX.

Modeling Tools: MS Visio, Erwin

Monitoring Tools: SQL Profiler, Task manager, Performance monitoring and activity monitor

3rd party Tools: Lite Speed, SQL Safe, RedGate, SQL Secure and Quest spotlight

Architecture: Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP, OLTP.

ETL: SSIS, SSRS, DTS, Informatica, Data Stage.

Other Tools: Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005/2008/2010 , MS Visual SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate, sql compare, Dell lite speed

PROFESSIONAL EXPERIENCE

Confidential, Radnor, PA

MS SQL Server DBA

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2012/2008R2 on windows 2012/2008 Servers. Installation of SQL Server Service Packs & hot fixes.
• Successfully upgraded the databases from SQL Server 2008R2 to SQL Server 2012.
• Successfully implemented ALWAYSON for the new environment and created availability groups for databases.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Involved in Health Check process for database and monthly auditing of the servers.
• Implemented Policy Based Management, Central management servers, Table and Page level compression and Resource Governor.
• Virtualization of SQL Server in Production environment.
• Created Documentation for steps need to be taken while upgrading the SQL server 2008/2008R2 to SQL server 2012, which includes in-place, side-by-side and standalone migration.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping and Always ON
• Designed and implemented disaster recovery plan under strict RPO and RTO guidelines.
• Setting up daily and weekly backups directly to TSM (Tivoli Storage manager).
• Installed SQL Server 2012/2008R2 on Active/Passive and Active/Active clusters as part of Upgrade.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Participated in DR installation and troubleshooting (Mirroring, Logs shipping and High availability Cluster)
• Designed and build SSIS packages to ETL data from various sources like MS Access, MS Excel, Oracle, flat files onto SQL Server Database
• Created Tabular reports, matrix reports, List reports and sub reports in SSRS.
• Created Adhoc reports using Report Builder and used Drill down and Drill Through functionality.
• Optimized the Disk space for performance using RAID and SAN.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Documented the security standards and roles depending on Development and Production environments.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements

Environment: SQL Server 2012/2008R2 with Clustering, MS Access, Hyper-V, VMware ESX, Windows 2012/2008R2, Lite speed 5.0, TSM, DTS, RML Utility, T-SQL, SSIS, SSAS and SSRS.

Confidential, Campbell, CA

MS SQL Server DBA

Responsibilities:

• Involved in design and architecture of the entire project flow and integration with third party tools.
• Interfaced with Business in understanding the present functionality of Planner Reports and defining the phases in which the development would be done.
• Performed daily tasks including backup and restore by using SQL Server 2005/2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Assistance in cleansing data for data consistency whether the data source is a single system or multiple disparate sources.
• Made use of SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Assistance in Event Logging, Resource management, Log files, File and File Groups, Security, Backup and Recovery.
• Involved with migration from SQL server 2005 to SQL Server 2008 database.
• Performance tuning using Profiler and Database Tuning Advisor, rebuilding indexes and running Database Consistency Check Commands(DBCC).
• Involved in Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
• Implemented replication (transactional and snapshot) between Main production server and offsite (disaster recovery) server.
• Assisted in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts.
• Created sophisticated SQL Server database to responsively handle complex queries (triggers, stored procedures, views, functions) and .NET data access components.
• Worked on SSRS to generate hierarchical reports and drill down reports and tested using Management Studio in SQL server 2008.
• Worked on SSRS and MS Excel and converted Reports as per Business rules.
• Developed OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.

Environment: SQL Server 2005/2008, VB.NET, SSRS, SSIS, SSAS, Visual SourceSafe, DTS, OLAP, Query Analyzer, DTA, SQL Profiler, Active Directory and Windows XP platform, DOT NET Frame Work2.0

Confidential, New York

SQLServer DBA/Developer

Responsibilities:

• Participated in joint application development session (JAD) to gather information about clients need and to get familiar with vendorsproduct.
• Wrote T-SQLstatements to ensure data consistency by filtering corrupt data and implemented variousconstrainsandtriggersto preserve data integrity.
• Developed effectivestoredprocedures, functionsto implement business logic.
• UsedBCPto move in or out data from different sources.
• UsedBulk Inserttocopy large amount of data into database.
• Designing, testing and managing disk\tape Backups and Recovery strategies.
• Backing upmaster & system databases andrestoring.
• Design and automation of disaster recovery procedures.
• DevelopedMerchandise Business Analysis reportfor Top management and Category Buyers using reporting services(SSRS)and deployed to reportserver.
• Migrated data from text files and Excel spreadsheets toSQLServerdatabases using Integration Services (SSIS).
• Maintained and createdReplication:Merge,Transaction and Snapshotand also implemented data transformation to the published articles
• Increased query performance, necessary for statistical reporting after monitoring, tuning, and optimizing indexes by usingPerformance Monitor,Profiler, andIndex tuning wizard.
• Participated in testing and debugging to validate data after the export/import/delete.

Environment: SQLServer2005/2008, VB 6.0, XML, windows server 2008/2003

Confidential, NJ

SQL Server DBA

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specification.
• Create and maintain the databases using MS SQL Server.
• Installing and Configuring SQL Server on the server and client machines provide connections and manage databases.
• Plan the Backup policy for the databases and Scheduling Online/Offline Backups and performing database recovery using backup sets.
• Installation of replication server, configuration and monitoring the replication between two sites, implemented Transactional replication.
• Create packages, procedures, functions, and triggers; handle database performance and tuning.
• Apply Service Packs for SQL Server database.
• Creation of new database, starting from scratch i.e. deciding the location of data files and log files on the disks.
• Reorganization of existing databases to standardize the placement of various databases related files.
• Creation of additional databases, logins and roles.
• Creation of schema objects, granting of roles and privileges to the users, compilation of procedures etc.
• Configuring the names pipes for connectivity from client machines.
• Ensuring that the backups are running fine for various databases on different servers.
• Created different objects: Stored Procedures, Triggers, Script to populate data into different tables according to different parameters specified.
• Wrote store procedure to feed different application from SQL Server
• Debugs the Procedures, Triggers, and Views by using Debug tool, monitor the system and SQL server job schedule and record any error logs.
• Migration of Database from SQL Server 2000 to SQL Server 2005.
• Developed various stored procedures used in the application using T-SQL, Created and modified Stored Procedures, Triggers, Cursors
• Used SQL Server Reporting services (SSRS) for creating, editing and scheduling various reports and scheduled Reports to run on a daily, weekly basis in the Report Manager.

Environment: Microsoft SQL Server 2000/2005, Windows 2000/2003 Server, SSRS, Microsoft Visual Studio

Confidential

MS SQL Server /SSRS/SSIS Developer

Responsibilities:

• Involved in logical & physical design, development, and testing of the system.
• Developed complex T-SQL code for the application and implemented constraints on tables.
• Migration of databases from SQL Server 2000 to SQL Server 2005.
• Worked as a developer in creating Stored Procedures, SSIS packages, Triggers, Cursors, Tables, and Views.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Created SSIS packages to extract data from heterogeneous into SQL Server 2005.
• Worked on complex data loading (implemented the batch data cleansing and data loading).
• Generated reports using MS Reporting services.
• Wrote Parameterized Queries for generating reports using Global variables, Expressions, Data, Defining Data sources and Subtotals for the reports using SSRS.
• Involved in performance tuning using Database Tuning Advisor.

Environment: MS SQL Server 2005/2000, SSIS, SSAS, SSRS, MS Access, Query Analyzer, BCP, SQL Profiler