SUMMARY

• 7+ years of IT experience in Database Administration, Design Development and Support of MS SQL Server 2012/2008R2/2008/2005 in Production, Test, Development and Cluster Server Environments.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.
• Migration experience from MS SQL Server 2000 to MS SQL Server 2005/2008, MS SQL Server 2005 to MS SQL Server 2008.
• Implemented the new SQL Server 2008 concepts like Data partitioning, Snap shot isolation, database mirroring, Default trace, change data capture, File stream, database snapshot, DDL triggers, try - catch blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Master in performing administrative tasks, Database files management, Backup/Restore, Security management, Database Mirroring, Data integration and Synchronization and Isolation levels.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Normalization, Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Experience in implementing High availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and Implementing SQL Server clustering (Active-Active, Active-Passive), Multi Node Cluster .
• Expertise in reading and understanding execution plan and fixing query to execute with low cost using various operators depending on the scenario.
• Highly skilled and experienced in Agile Development process for diverse requirements.
• Experienced in the use of agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005.
• Experience in Powershell scripts and Powershell active directory with SQL server Powershell extensions.
• Experienced in executing VTF commands and files.
• Expert in Extraction Transformation Loading (ETL), Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them) and Implemented the security Policies as per PCI and SOX compliances.
• Expertise in DBCC Trace Flags and Blocking situations. Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008.
• Experience in identifying root cause analysis and fixing the Windows / IIS Web Server Related issues. Extensive experience with IIS (Internet Information Services) 5.0/6.0 using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management, Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS, ADHOC and Crystal Reports).
• Design of the SCOM2007 environment.
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions).
• Suggested Application level tuning changes for code, queries, SQL objects which may not be performing up to the optimum database performance standards.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

TECHNICAL SKILLS

Operating Systems: MS-SQL Server 2012/2008/2005/2000/7.0/6.5. , Oracle 9i, Oracle, MYSQL

Clustering Software: Microsoft Clustering, HP Polyserve Clustering.

Backup Tools / Software: Quest Tools (Lite Speed 2005, Performance Analysis and Spotlight)SQL Sentry, Red-Gate - SQL Compare, BMC - Pro active Net.

GUI Tools: Visual Studio (VB), Visual Studio2005/2003, VSS, Visio 2003, Office Visio 2007, SAN

Database Tools: SSIS, SSRS, SSAS, Crystal Reports, MKS Source Integrity Tool. SQL Server Profiler, DTS, Management Studio/Enterprise Manager, Query Analyzer, Active X, IIS, MTS, Lite speed, Spotlight, Erwin 4.0, SCOMTivoli TSM, Powershell, EMC, Agile, Scrum:

Web Server: Internet Information Server

Databases: SQL Server 2008/2005, MS Excel, MS Access, Oracle 9i.10g, 11g

Reporting Tools: Business Objects, Crystal Reports

OLAP Tools: SQL Server Reporting Server 2008/2005, SSIS (as ETL)

Third Party Tools: Lite speed, Erwin, DB Moto.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL Server Developer / ETL Developer

Responsibilities:

• Designed, Implemented and maintained Entity relationship diagrams, Data modeling, Tables, Stored procedures, Database Schema, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, Monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Administering SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.
• Up gradation of SSIS package from .
• Executed SSIS package as a job step and command line utility.
• Usage of various synchronous and asynchronous transformations and various tasks in SSIS.
• Troubleshoot of various SSIS packages and its performance tuning, Implemented failure alerts using email in SSIS.
• Wrote complex queries for the drill down reports
• Working with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008.
• Involved in Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Working with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Working with a combination of multiple Dataflow Transformations to build packages in SSIS.
• Implementing major Event Handlers like OnError, OnProgress and OnTaskFailed for SSIS Packages.
• Scheduling and Monitoring SQL Server Agent Jobs to run various SSIS packages in SQL Management Studio.
• Analyze, design and develop unit test, document, and implement reporting applications using SQL Server Reporting Services SSRS and other related technologies.
• Used DBCC commands to troubleshoot issues related to database consistency.

Environment: SQL Server 2008, MS Access, Excel, Windows Server 2008, VSS, Microsoft Visual Studio, MS Visio, MS Integration, Analysis and Reporting Services, Management Studio, SQL Profiler

Confidential, Scottsdale, AZ

SQL Server DBA

Responsibilities:

• SQL Server 2008 R2/2008/2005 Database Administration.
• Migrated databases from SQL Server 2000 to SQL Server 2005 and 2008 R2 and 2012.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Installing, Configuring and Maintaining SQL Server 2008R2/20 bit) on Active/Active Cluster with latest Service Packs, Hot Fixes.
• Worked as Primary DBA for 50 Instances and 70 as Alternate DBA.
• Experience working with CRM Application issues.
• Installed and configured Microsoft SQL 2 node Clustering (Active/Passive).
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Experience in Database security and integrity planning.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Deployed multi-campus backup environment based on EMC Datadomain storage.
• Installed and configured Storage Area Networks (SAN) in a heterogeneous environment.
• Tuning queries which are running slow using Profiler and Statistics by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Successfully implemented the Capacity planning for different servers.
• Experienced in configuring Powershell environment for SQL support.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through Try- Catch statement, Common Table Expression (CTE).
• Worked in Active passive and Active Active cluster environment and Installed and Configured more than 50 Clustered SQL Instances
• Installed Service packs and Builds and Worked with SQL Server 2008 in place and side by side upgrade from SQL server 2005
• Worked on Project for setting up DB mirroring and troubleshooting.
• Worked on setting up Transactional Replication (push and pull) and Merge Replication and troubleshooting along with Slip stream installations and TDE.
• Working on daily tasks include Backup failures, Login creations, Data refresh and Disk space issues.
• Implementation of SQL failover cluster and setting up backup jobs and Checking Control M Jobs.
• Creating and Maintaining Database Maintenance Plans and Worked in migrating database to different collations
• Implementing and Maintaining Server Level Auditing for auditing of Logins, Creating and Dropping Objects.
• Checking the performance issues on servers as per request by using profiler, perfmon, DBCC and DMVs.
• Monitoring servers by checking Error Logs, Windows Logs, Creating Logins and Roles with appropriate permissions.
• Worked in Configurations of IIS (Internet Information Service) in ISP environment with access to SQL DBs
• Installed and Configured SSRS and Deploying SSIS packages.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Fixing Missing Indexes and Excess indexes using Data Tuning Advisor.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: SQL Server 2008R2/2008/05, Windows 2008, Windows 2005 Server, Powershell, IIS, Lite Speed, MS Visio, EMC Datadomain, SAN, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008, FogLite.

Confidential, Sacramento, CA

SQL Server DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows 2003 Server. Worked on SQL Server 2003 failover clustering which is built on top of a Windows 2003 server cluster.
• Upgraded SQL Server 2000 to SQL 2005 server for high volume processing databases on a clustered environment.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning and optimizing SQL Server 2005.
• Administrator tasks like managing users, roles and permissions. 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
• Involved in complete database design including conceptual, logical and physical models.
• Performance testing on stored procedures, indexes and triggers.
• Experienced in working with SQL server Powershell provider and central management server from Powershell.
• Participated in the designing and development of software using agile development practices
• Providing support for storage operations for EMC Datadomain, Netbackup and other storage products. Based on the EMC requirement, updated the drivers (HBA etc)/patches (Operating System) on all systems involved in the data migration.
• Implemented Tivoli Alerting for the SAN Infrastructure devices to alert the command Center and worked closely with Tivoli team to create log adapters and carefully planned out the severity levels.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program and DTS from Oracle Databases and Flat files.
• Modeling and architecture of the SQL Server 2000 database.
• Managing local and remote databases from within IIS (Internet Information Services) Manager.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.
• Used third party tool, Light Speed to speed up backup operations.
• Created Complex reports using SS Reporting services.
• Created and maintained logical/physical data structures.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Used functions to create predefined conditions and prompts to filter the data and dynamic user selection
• Involved in creating Cubes using SQL Server Analysis Services.
• Created reports using Business Objects suite functionality like Slice and Dice, Drill Down function and formulas
• Created the reports using Business Objects functionality’s like Queries, Sub queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc

Environment: Windows 2003,MS SQL Server 2000, MS SQL Server 2005, Windows SCOM, Powershell, EMC Datadomain, SAN, Oracle 9i, T-SQL, Visual Studio, Crystal Reports 8.5,Business Objects 6.1b,SQL Loader, IIS, Lite Speed, MS Access, DTS, BCP, SSIS, SSAS,SSRS, SQL Profiler.

Confidential, Bloomington, IL

SQL Server DBA

Responsibilities:

• Responsible for the Installation, Daily monitoring, Maintenance of SQL Server 2000/2005 installations in both the Production and Development Environments and also upgrades to SQL server 2005.
• Involved in the configuration of new SQL Server Instances on Windows servers with appropriate parameters.
• Used SQL Server analysis services to simplify complex queries and enhance speed of execution.
• Participated in the Migration of the databases and managed the location of database files, log files and their sizes.
• Migrated and validated users and logins in the new environment.
• Granted roles and permissions to SQL server users.
• Developed, implemented, and maintained policies and procedures for ensuring the security and integrity of SQL Server 2000/2005 and the corresponding databases
• Created Maintenance plans, Scheduled Jobs and SSIS packages.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Created tables, views, indexes, functions and advanced queries for databases by using SSMS.
• Configured and maintained Transactional, Snapshot and Merge Replications.
• Performed Log shipping to a standby server to safeguard valuable data.
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.
• Performed Root cause analysis to track down problems and used SQL profiler for troubleshooting.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breaches.
• Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Performance testing on stored procedures, indexes, and triggers.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Experience in applying Service Packs at database and OS Level.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.
• Experience in using ERWIN tool for Entity Relationship diagrams.
• Checking Database Health by using DBCC Commands and DMVS
• Did Performance Tuning of the Stored Procedures.
• Hands on experience in trouble shooting database issues.
• Update statistics, database integrity check and Backup operations

Environment: SQL Server 2000/05, Windows 2003, Windows SCOM, Windows 2000 Server, MS SQL Server 2000/2005, MS Visio, Microsoft SQL server Visual Studio 2005/2000, MS Business Intelligence Development Studio 2000.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Analyzed various SQL server environments and suggested best practices for better performance.
• Administered the space usage of the various databases for various applications.
• Automated consistency check of the database (DBCC) for SQL Server.
• Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.
• Installed and configured SQL Server Reporting Services.
• Suggested various architectures that can be implemented after upgrading from older versions of SQL server to SQL server 2005.
• Proposed various high availability options to maintain the high availability of SQL server on various environments.
• Used DBCC commands to check physical and logical consistency of the databases and rebuild indexes.
• Created various automated processes to update the Reporting services databases on a regular basis.
• Suggested and implemented various SQL Server Reporting services environments.
• Upgraded SQL server 2000 boxes to SQL server 2005 and acted as the point of contact for all developers.
• Upgraded SQL server 2000 to SQL server 2005 on a Clustered environment.
• Developed streamlined procedures that decreased labor time and eliminated redundancies.
• Created automated daily stats report that reduced errors and is now used by records associates organization-wide
• Designed and developed data warehouse data stores, and analyzed business requirements, developed target-source data mappings and delivering ETL processes for end-user OLAP and reporting initiatives (Used report services as and OLAP client schedule reporting tool ).
• Primarily responsible for developing database solutions that provide the business with the information needed to make daily operating and strategic decisions. Perform data modeling activities, application performance tuning and code reviews.
• Implemented various high availability options for SQL server 2000/2005 including replication.
• Tested point in time recovery of the production 2005 databases using the traditional backup/restore technique.
• Setup replication for high availability.
• Make modifications/and add new MDX queries to cubes.
• Installed SQL server and implemented resource utilization on the server.
• Involved in performance tuning and query optimization.
• Fixed and rebuilt many SSIS packages during the migration.
• Analyzed many databases in various environments for performance issues.
• Monitored network for bottlenecks.
• Involved in tuning various reports generated using SSRS.
• Documented the various observations made and suggestions on various environments.

Environment: Windows 2000/2003,Windows SCOM, MS SQL Server 2000/2005, SSRS, SSIS, SSAS, VB 6, Erwin, SQL Server Profiler, SQL Loader, Database engine tuning Advisor, BPA, Upgrade Advisor.