SUMMARY

• Eight years of experience in Implementation, Administration and Support of MS SQL Server 7.0/2000/2005/ 2008 R2 in Development, Test, UAT and Production Environments.
• Installation and configuration of SQL server 2012/2008/2005/2000 with Health Care, Manufacturing and IT sectors.
• Specific hands on experience include administering large and complex Databases, Database Design.
• Entity relationship diagram (ERD) development / normalization and physical database schema design.
• Performed Log Shipping and implemented Transactional and Snapshot Replication as high availability techniques.
• Experienced with Kronos Work Force Central and WIM Application, Configured, Supported and Upgraded.
• Implemented ServiceNow and customized. Migrated data from ITSM to ServiceNow.
• Created custom - tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task. Upgraded/migrated databases from lower version of database to higher version. Experienced in Migrating data between servers (Oracle, MYSQL, Staging, Data warehouse).
• Experience in Database of OLAP/OLTP and Mirroring as disaster recovery solution
• Implemented both Active / Active Clustering and Active Passive Clustering as a disaster recovery solution
• Experience in supporting Very Large databases 4TB and troubleshooting the problems.
• Experience with 2008 new concepts like Data Auditing, and Policy based management system.
• Experience with 2005/2008 concepts like data partitioning, online indexing, DDL triggers, DMV, DMF
• Experience with T-SQL in writing triggers, tables, user defined functions, views, indexes, and relational database models and data integrity, and experience in migrating SQL Server 2000 to SQL Server 2005/2008/R2.
• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Implemented AlwaysOn Availability Group.
• Expertise in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experienced using Looped cells, variables and created macros using Excel VBA.
• Excelled in generating formatted SQL server Reports by writing parameterized queries using SSRS 2008.
• Experience in configure server and client network protocols like SQL Server and SQL Extensions in SQL 2005 using configuration manager.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Intensive experience in monitoring database performance using SQL Profiler, and the DB’s percent log space for all database servers using SCOM and Windows Performance counters.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in writing Stored Procedures, User Defined Functions, Cursors, Triggers and Schema.
• Experience in Data Modeling (logical modeling and physical modeling) using Erwin.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
• Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities

TECHNICAL SKILLS

Databases: MS SQL Server 2000/2005/2008 R2, Oracle 8i/9i/10g, MS Access

Tools: /Utilities: SSIS, DTS, SSRS, SQL Server Enterprise Manager, Profiler, SQL Navigator BCP, Query Analyzer, SQL Server Manager, SSMS, Apex log, IDERA, ITSM, ASSURENET, Concur, KRONOS, LOFTWARE, Red gate SQL Compare tool, Database Tuning Advisor, Desk Board, Erwin 7.x, Visual Basic 6.0 & 9.0, ODBC, Excel VBA, ADO, ADO.NET, PL/SQL, TOAD, Visual Studio 2003/2005/2008.

Programming: T-SQL, PL/SQL, C#.net, ASP.net, VB.net, VB Script, HTML, Java Script, Unix Shell.

Ticketing system: ARS, Remedy, Auto Task.

Operating Systems: Windows NT/2000/2003, Windows 9x, HP-UX 10.x, 11.x, AIX 5.3, Solaris 9/10.

Other Tools: MS Office suite 2000/03/10, MS Visio, .Net frame work 1.1/2.0/3.0/3.5/4.0.

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Sr SQL Server DBA

Responsibilities:

• Plan, design, and implement application database code objects, such as CONCUR, KRONOS, and LOFTWARE.
• Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
• Involved and supported users with ITSM incidents and Change management issues.
• Implemented Service Now and Migrated data from ITSM databases to Service Now.
• Resolved issues on Concur Travel and expenses configuration issues configured Audit rules and Cognos reports.
• Migrated data from Oracle to SQL using SSMA (SQL Server Migration Assistant).
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Configured user delegation roles in Concur. Created documentation on HCP recipients for each country globally (complete Spend and Aggregate Spend Projects).
• Created reports and deployed on SharePoint Servers. Created users and User roles on SharePoint servers.
• Migrated from ITSM to Service now with along with vendor. Customized the application reports and worked as Service now admin.
• Upgraded SQL Databases and changed compatibility levels, configured and implemented AlwaysOn availability.
• Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Determined user/business/functional requirements. Created vision, scope, and use case documents; business process models, use case diagrams, activity diagrams, and state chart diagrams.
• Experienced in extracting data from Development / UAT / Production servers by using SSIS.
• Provide database coding to support business applications using T-SQL.
• Experienced with Clustering setup and Active Directory in Windows 2010.
• Implemented AlwayOn Availability between Primary and secondary Production servers with configuring Shared Witness server and Windows Failover cluster.
• Develop new processes to facilitate import and normalization, including data file for counter parties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Created many Cascaded parameters in the reports using MDX and T-SQL.
• Involved in Database Modeling, Database Mapping, And Normalization Using ERWIN.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import/export data feeds to/from data warehouse and claim system.
• Design and develop reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Migrated databases among the servers using copy, attach/detach, copy/restored utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, Adhoc request and ETL related operations.
• The packages created included a variety of transformations, for exampleSlowly Changing Dimensions,Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
• Supported 24X7 in production issues and User’s issues on applications.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2012 / 2008 R2 / 2005, IIS, SharePoint, Clustering, VB.Net scripting, SSIS, SSRS, T-SQL, GEM Fusion, Visual Studio 2008, Toad, Indexes, Cluster, .Net Framework 3.5, 4.0, snapshot, backup/restore, MS Office suite 2003

Confidential, SFO, CA

Sr. SQL Server DBA

Responsibilities:

• Involved in updating existing databases of SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
• Managing databases spread across multiple servers in Production, Development, Staging and Testing environments using SQL 2008 and SQL 2005 on Windows Active- Active Clustered Environment
• Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
• Design and develop SSIS packages, store procedures, configuration files, and tables, views, and functions implement best practices to maintain optimal performance.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on SQL2008 Data compression and Table Partitioning.
• Replicate data from acceptance to QA and production phase.
• Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the data warehouse.
• Generated reports by using SSRS and provided them on web server Report manager.
• Checked database upgrade advisor for compatibility check for databases before updates.
• Created, altered, maintained system roles, Logins and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
• Audited database user’s using SQL profiler tool and costumed stored procedures and packages. Hide tables columns from the developers and non - technical staff member using views.
• Created maintenance plans for database Full, Differential and Transactional backup. Also schedule for rebuild indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
• Generated reports by using SSRS and provided them on Share point 2010 Report manager.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved inStaging PartitionsandUsage Based Optimization (UBO)mechanisms for SSAS OLAP databases. Involved inTabular Datawarehouseoperations for SSAS 2012 and 2008 OLAP databases.
• Involved in performing Audits and recovery operations of SSAS objects. Created reports to generate them through Email for the administrative using MDX Queries.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2008 R2, IIS, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Studio 2010,Sybase, MYSQL, Toad, Indexes, LogShiping, .Net Framework 3.5, snapshot, Replication, MS Office suite 2010.

Confidential, Raritan, NJ

SQL DBA

Responsibilities:

• Involved in beginning of the project, updated existing database from Oracle Servers to SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
• Experienced in using Data Manipulation Language (DML) for the query and update commands and the Data Definition Language (DDL).
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Worked with end users to resolve their issues on all applications on priority basis using ITSM tool.
• Involved and supported users with ITSM incidents and Change issues.
• Processed Daily expenses through SSIS jobs by collecting data from Concur FTP servers.
• Involved in the Service Now implementation project.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services using packages to import / export data feeds to / from OLAP data warehouse and claim system.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Replicate data from acceptance to QA and production phase.
• Automated Maintenance Routines to complete monthly data updates and special maintenance activities for the OLAP data warehouse.
• Installed, configured, operated and troubleshot Web SharePoint Portal Services. Created and maintained websites using Windows SharePoint Team Services.
• Generated reports by using SSRS and provided them on web server Report manager.
• Worked with importing flat files and XML files, Share Point, fetched data from other data source like PL SQL, MySQL, and ETL (Extract, Transform and Load) to the database.
• Configured database log shipping and mirroring to maintain, prevent from the disaster recovery and managed ASCO’s standards. Configured and managed primary- standby nodes for High availability of database for users and manage organization standards.
• Identified long running queries using Desk Board report. Generated XML plan for T-SQL performance. Resolved blocked and locked objects issues. Created new Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Migrated databases among the servers using BCP, attach/detach utilities. Worked on SQL Server Integration Services (SSIS) for data integration from heterogeneous data sources, ETL related operations.
• Enabled email notification, linked servers, certificates, symmetric keys for advance database use.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
• Worked with importing flat files and XML files, fetched data from other data source like MS Access, DB2, Mysql, Oracle and ETL (Extract, Transform and Load) to the database using SSIS. Created UNIX shell script to move file across the servers and automation of daily tasks.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server 2008 R2, IIS, Sybase, SharePoint, Clustering, SSIS, SSRS, T- SQL, Visual Basics, Visual Studio 2008, Indexes, Cluster, .Net Framework 3.5, snapshot, Replication, MS Office suite 2011, Cognos 10.

Confidential

SQL Server DBA / Developer

Responsibilities:

• Involved in new databases design and creation using Rational Rose.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Identify database entities and attributes, relation among the entities tables and enforced the referential integrity constraints.
• Worked on creation and improving the stored procedures and triggers performance.
• Implementation of Microsoft Office SharePoint Server 2007 Beta for corporate intranet, document management, collaboration.
• Experienced in Design of OLAP Data warehouse using Star Schema and Snow Flakes Schema.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults user defined data types and functions.
• Created Database Diagrams using third party tool ER-Win in beginning of the project. Defined relationship between tables and enforced the referential integrity constraints.
• Responsible for Query Performance tuning and Optimization.
• Created views, SQL joins DTS packages and statements for applications.
• Designed and implemented stored procedures and triggers for automating tasks.
• Generated T-SQL code for creating cursor and handling the data validations.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• ETL packages are created to extract, transform and load data to data ware house using SSIS.
• Using SSIS the data is transferred to and from flat files, MS Excel, MS Access and SQL Server 2005. .
• Implemented the calculations to aggregate physical measures using management studio.
• Involved in creation of Multi - Dimensional Cubes and Relational Cubes.
• Used BCP techniques, Stored Procedures, Triggers, Cursors and Transaction management, T-SQL to convert data from various sources to MS SQL 6.5/7.0 databases.
• Developed and maintained MS Access database.
• Supported development of a speciation control documents for an MS Access Project Management Database.

Environment: MS Office suite 2000, MS-SQL Server Management Studio 2000/2005, T-SQL, DTS, Replication, Rational Rose, Windows 9x/Windows NT, MS SQL Reporting Services 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005, MS Access, Erwin, SQL Query Analyzer.