SUMMARY:

• Certified Lead Sr. MS SQL DBA wif 10+ years of experience in Database Administration, Log Shipping, Database Mirroring, Replication, Always - On, Clustering, Upgrade, Patching, Cloning, design, development, Integration Services (SSIS) and Reporting (SSRS) using SQL SERVER 2014/2012/ 2008/2005/2000 , Azure, PowerShall TFS, SCOM 2012.
• Strong Experience in defining physical database structure, relationships, operational capacity, security policies, and backup and recovery processes.
• Strong Experience in defining physical database structure, relationships, operational capacity, security policies, and backup and recovery processes.
• Maintaining database performance by optimizing queries, updating schemas to accommodate expanding scale and size of data, and predicting future utilization based on current usage.
• Experience in Installation, Upgrade, Patching and Cloning of SQL Server 2014/2012/ 2008/2005/2000 ; Troubleshooting, Optimizing and Monitoring Connections, Locks and Performance of SQL Server,T-SQL code and Stored Procedures using native tools like Performance Monitor, DBCC Commands and Dynamic Management Views (DMVs).
• Installed and configured database mirroring, log shipping, Transaction Replication and Active/Active Failover cluster in production environment of SQL Server 2008; experience in implementing different types of Replication models like Snapshot and Transactional.
• Experience in Installation and configuration of SQL Server Cluster, SQL 2012 Always-On Availability Groups, log shipping and Mirroring.
• CreatedDatabase Maintenance Plansand scheduled jobs that use SQL Server Integration Service Packages forchecking teh health of migrated databases on new environment; Identified locking, blocking, dead locking issues and resource bottlenecks and resolved them.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities and Dynamic Management Views/Functions.
• Ensures databases are replicated and backed up to meet teh operational and disaster recovery requirements (current environment and Azure environment).
• Experienced wif deploying to teh cloud and has a high level understanding of maintenance, administration, upgrades and deployments in a cloud hosted SQL Server environment and SQL Server based Data hosted in Azure environment using IS packages.
• Lead, build out and supporting a team of Build Engineer and TFS Staff to support all business efforts; managed teh day to day operations of teh TFS system, troubleshoot and triage TFS system related issues.
• Deep understanding of TFS Server Administrator, TFS Build Server(Continuous integration), MSbuild, TFS Client, TFS Templates, Build Controllers and Agents; Knowledge on Advanced Microsoft Team Foundation Server (TFS) architecture.
• Experience using PowerShell SQL Server 2008/2008 R2/2012 environments - DBA/Developer experience.
• Experience in PowerShell script to automated several SQL Server-specific administrative/reporting tasks and establishing best practices and guidelines for SQL Server PowerShell development.
• Maintained and improved teh System Center Operations Manager (SCOM) platform architecture to ensure operational needs of both teh monitoring platform and teh services under management are met.
• Created, managed and maintained dashboards and management packs; Monitor and prune SQL database on a daily basis for SCOM monitoring.
• Identified potential areas where existing monitoring capabilities and processes require change and where new ones need to be developed - especially to meet future business demands (SCOM).
• Experience in Database Architecture, Design, Coding, Error Handling, Precedence Constraints, Break Points, Check Points, Logging using SSIS and Production Support.
• Excellent in high level design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as data conversion, conditional split, bulk insert, etc.
• Extensive experience in generating Drill through and Drill down reports wif Drop down menu option, sorting teh data, defining subtotals in SSRS 2005/2008.
• Experience in Deployment and Configurations of SQL Server Reporting and Analysis Services; Worked on adhoc reporting, Parameterized Reports, Custom Reporting.
• Good understanding of ITIL Processes-Incident, Change and Problem Managements.

TECHNICAL SKILLS:

Databases: MS SQL server 2000/2005/2008/2012/2014 , Oracle, PeopleSoft

SQL Server Tools: SQL Server Management Studio, BIDS (SSIS, SSAS, SSRS), SQL Server Query Analyzer, SQL Server mail service, DBCC, SQL Server profiler, Enterprise Manager, Profiler, Query, Export & Import (SSIS), SSMS, Perfmon.

Operating Systems: Windows 2000/2003/2008/2012 , Windows NT, UNIX

ETL Tools: Data Transformation Services (DTS), MS SQL Server 2005/2008 Integration Services (SSIS)

OLAP/Reporting Tools: SQL Server 2005/2008 Analysis Service (SSAS), SQL Server 2005/2008 Reporting Service (SSRS), MDX.

Scripting Languages: Java Script, Shell, Perl, VB Script

Other tools: Erwin, ER/Studio, MS Visio, Azure, TFS

Third party Tools: System Center 2012 (SCOM).

Application: BizTalk, SharePoint

Ticketing Tool: Service Now

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee

Lead Sr. SQL Server DBA

Responsibilities:

• Migrated databases from SQL 2000 to SQL 2014.
• Implemented Always-On availability using file share method in SQL 2014
• Maintained a highly secure, clustered and available systems (24/7 basis and worldwide)
• Application database design, creation, and maintenance
• Ensured Database quality control (QC) and auditing to ensure accurate and appropriate use of data
• Migration of database services to Cloud (Azure).
• ETL experience and data warehousing experience working noledge wif SQL Azure, and migrating servers from On-premise to cloud.
• Collaborate wif Management to develop strategies to support miscellaneous organization requirements.
• Consulted wif users on access to various databases; Resolved data conflicts and inappropriate data usage.
• Provided expertise in requirements determination and validation, Analysis of Alternative (AOA), systems design, data modeling, capacity planning, performance tuning, debugging and other related areas
• Developed and supported SharePoint and/or .NET web application projects
• Applied SQL Server 2008 (N+1, N-1) security and standard database patches and Staging.
• Architecting, sustaining, troubleshooting, and implementing an SQL 2008 (N+1, N-1) Database backup and disaster recovery plan.
• Troubleshooting encountered problems, performing a full re-load of software and analyzing procedures and processes.
• Performing disaster recovery tests on a scheduled basis.
• Liaising wif teh SharePoint Administration team to assure that all SharePoint solutions are properly configured for disaster recovery.
• Liaising wif teh .NET Development team to ensure that all .NET web application databases are properly configured for disaster recovery.
• Updating procedures and documentation and making recommendations to improve teh disaster recovery plan.
• Lead, build out and support a team of Build Engineer and TFS Staff to support all business efforts; Managed teh day to day operations of teh TFS system, troubleshoot and triage TFS system related issues.
• Developed PowerShell script to automate several SQL Server-specific administrative/reporting tasks.
• Established best practices and guidelines for SQL Server PowerShell development.

Confidential

Lead Senior Sr. SQL Server DBA

Responsibilities:

• Leading from teh front and completing teh projects on time for teh company
• Managed PRODUCTION, DEVELOPMENT, QA and UAT environments
• Upgraded from SQL Server 2008R2 to SQL Server 2012.
• Installed and configured of SQL Server Cluster, SQL 2012 Always-On Availability Groups, LogShipping and Mirroring in SQL 2012
• Installed and configured Active/Passive Failover cluster as a high availability solution wif SQL Server 2008R2.
• Experience working in an Azure, Cloud based environment.
• Experience ensures databases are replicated and backed up to meet teh operational and disaster recovery requirements (current environment and Azure environment).
• Implemented Transactional Replication in SQL Server 2008R2.
• Troubleshooting, Optimizing and Monitoring Connections, Locks and Performance of SQL Server,T-SQL code and Stored Procedures using native tools like Performance Monitor, DBCC Commands and Dynamic Management Views (DMVs).
• Set up Backupstrategy for nightly and weekly basis which involved Full Backups, Differential Backups and Transactional Log Backups.
• CreatedDatabase Maintenance Plansand scheduled jobs that use SQL Server Integration Service Packages forchecking teh health of migrated databases on new environment.
• Extensively involved in designing teh SSIS packages to export data of flat file source to SQL Server database.
• Expert in Building Packages to Load Data Base to Data Warehouse
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Used data flow transformations - look up, fuzzy look-up to clean teh bad data in teh tables
• Applied various data transformations like SCD (Slowly Changing Dimension)- to maintain teh history of teh data, aggregate, sort, multicasting, conditional split and derived column.
• Generated reports using global variables, expressions and functions for teh reports.
• Identified and worked wif parameters for parameterized reports in SSRS 2005.
• Created many complex stored procedures/functions and used them in SSRS directly to generate ad-hoc reports.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard
• Involved in conceptual logical modeling and physical modeling of teh database
• Extensive testing on teh performance of teh stored procedures.
• Using third party tool like SCOM for monitoring and performance.
• Creating logins and users as and when required wif specific roles on production and development servers

Environment: SQL Server 2008/2008R2/2012/2014 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2008 R2/2012,Oracle 11g, 10g Query analyzer, SCOM.

Confidential

Lead MS SQL Server DBA

Responsibilities:

• Installed, configured, administered and secured SQL Server 2000/2005/2008 R2
• Implemented Operational Data Source(ODS) in SQL Server 2008 from SQL Server 2000/ 2005/ 2008 and DB2 using replication and Log shipping
• Offered 24x7 support forboth production and development databases wif on-call pager
• Designed Disaster Recovery Strategies & Procedures.
• Migrated SQL server 2000 to 2005/2008 installed and configured stand alone SQL server.
• Migrated DTS packages from SQL Server 2000 to SSIS SQL server 2008.
• Installed and configured database mirroring.
• Implemented Transactional Replication.
• Involved in installing and configuring Active/Passive Failover cluster in production environment of SQL Server 2008.
• Involved in fine Tuning and Performance and Query optimization of teh Database as required by teh application.
• Installed SQL Server Enterprise 2008 64bit version on Windows Server 2008 Enterprise systems
• Installed and administered two node cluster Active/passive on Microsoft Windows Server 2008 Enterprise Edition on SAN environment
• Implemented Change Data Capture(CDC) feature in Production 2008 SQL Server
• Used DDL triggers, Online Indexing in SQL Server 2008.
• Analyzed long running /slow queries and tune teh same to optimize application and system performance.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load teh Data from various Databases and Files.
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• 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.
• Actively involved in Normalization & De-normalization of database.
• Database and Transaction log backups & restoration, backup strategies, scheduling teh backups. Backing up system & user databases and restoring them whenever necessary.
• Extensively worked on Dynamic Management Views (DMV’s) to get teh information about executed T- SQL statements.
• Maintained teh database consistency wif DBCC at regular intervals.
• Configured and altered alert configuration settings for teh jobs and issues.
• Involved in setting up SQL Server Agent Jobs for periodic backups wif backup devices, database maintenance plans and recovery.
• Created custom reports using SSRS.
• Helping Development Team in deploying and testing teh application which uses SQL Server.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Experience in working wif reporting tools such as Crystal Reports and SQL Server reporting services (SSRS).
• Used SQL Server Integrated Services (SSIS) of SQL Server to populate data from various data sources by creating package for different data loading operation for application.
• Provided 24X7 production supports.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003/2008.

Confidential

MS SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005 on Windows server 2008R2 and applied service packs when required.
• Migrated data from SQL Server 2005 to SQL Server 2008.
• Successfully implemented SQL Server Log Shipping for SQL Server 2005.
• Installed PeopleSoft Application (8.9 & 9.0) and People Tools (8.49 & 8.50).
• Installed and configured teh N-Tire architecture using web server (web logic and Tuxedo) as part of PeopleSoft installation.
• Expertise in running Load Test using WAPT Tool, and Capturing Long Running Query’s in teh profiler and Fine Tuning teh Stored Procs.
• Monitored and modified Performance using execution plans wif query hints and Index tuning.
• Assign permission to users, roles, and object. Administrate security for server’s logins wif Windows and SQL Accounts.
• Troubleshooting, Debugging and Performance Optimization for SQL Server Database and Application Related issues.
• Performed horizontal data partitioning for efficient management of database tables and indexes, Full text indexes, Using Contains, Tuning LOB, BLOB data types.
• Generating Script files of teh databases when ever changes are made to stored procedures or views or any other database objects.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
• Used Windows Performance monitor to monitor CPU & Memory usage and SQL Server Profiler to monitor and record database activities of particular users, applications.
• Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.

Environment: Microsoft Windows Server 2008/2003, Microsoft SQL Server 2005/2008, Microsoft Visual Studio 2005 and PeopleSoft 8.9/9.0 and People Tools 8.49/8.50.

Confidential

SQL Server DBA

Responsibilities:

• Installation of MS SQL 2005 Enterprise servers on test and development boxes.
• Recommended system design approaches, which are consistent wif teh application's business requirements.
• Interacting wif Business Analysts and Developers in identifying teh requirements and designing and implementing teh Database Schema.
• Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures teh optimal operation of all database environments.
• Handling database objects wif Enterprise Manager and Query Analyzer.
• Administering teh MS SQL Server by creating user logins wif appropriate roles, dropping and locking teh logins, monitoring teh user accounts, creation of groups, granting teh privileges to users and groups.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Perform Capacity Monitoring and short and long-term capacity planning in collaboration wif development resources, System Administrators and System Architects.
• Automated processes using SQL Server jobs.
• Proper use of Views to prevent unauthorized access.
• Using teh Database Maintenance Wizard to make some necessary changes and keeping teh performance of teh server at acceptable levels.
• Database design, creation of user databases and installation of MS SQL Server & Clients.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources using teh concept of OLEDB.
• Installation of replication server, configuration and monitoring teh replication between two sites, implemented Transactional Replication.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Worked on linked servers to run distributed queries between SQL servers

Environment: MS SQL Server 2008/2005/2000 , Windows 2000/2003, DTS

Confidential

MS SQL Developer

Responsibilities:

• Created Tablix Reports, Matrix Reports, Parameterized Reports and Sub reports using SQL Server Reporting Services 2008.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports
• Worked on row and Column Grouping.
• Involved in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in writing MDX queries and performance optimization of teh SSAS cubes.
• Experience in writing complex MDX queries for calculated members and measure groups.
• Experience in building Reports on Analysis Services cubes.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for teh reports.(SSRS)(2005/2008 R2).
• Extensively involved in teh SSAS storage and partitions, and Aggregations, calculation of queries wif MDX, Data Mining Models, developing reports using MDX and SQL
• Identified and defined Fact relationships in SSAS
• Responsible for identifying KPIs in SSAS 2005.
• Development, improvement, customization and deployment of SSRS reports in Business Development Studio
• Involved in creating Indexes, Constraints on database objects.
• Created various Weekly and Monthly reports showing detailed information in SSRS.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 R2 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements wif error handling.
• Experience in moving teh data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services (SSRS), Report Builder.
• Generated Reports using Global Variables, Expressions and Functions for teh reports in SSRS.
• Responsible for scheduling teh subscription reports wif Data Driven Subscription Windows File share and Email Delivery using SSRS.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into teh web front end.
• Created teh Data source connections, Data Source Views, Relationships, Named Query for customized analysis in SSAS.
• Defined MDX scripts for data validation process against OLAP cubes for business validation.
• Worked on backups scheduling.
• Experience in Reviewing Cube wif End user and changing teh cube and documentation according to their requirements.

Environment: SQL Server 2005/2008 R2, SSAS, SSIS, T-SQL, SSRS, Oracle 9i, Performance Point Server 2007.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Assisted clients wif physical database modeling, data archiving strategies, data purges and disaster recovery planning.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications
• Created complex stored procedures and functions to support efficient data storage, Archiving, Purging and manipulation.
• Involved in Administration of teh SQL Server by creating users & login ids wif appropriate roles & grant privileges to users.
• Involved in writing T-SQL statements for retrieval of data.
• Worked on performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating indexes.
• Performed daily database backup & restoration, monitored teh performance of teh Server.
• Tuned teh SQL queries using SQL profiler. Involved in tuning teh database. Created necessary indexes to make data retrieval process faster.
• Designed and developed tables, view, stored procedures and triggers in MS SQL Server database on Windows NT platform.
• Designed and developed reports using Crystal Reports

Environment: MS SQL Server 2000, Windows server 2003, Enterprise Manager, MS Access, MS Excel, MS Word, Windows 98/NT/2000, T-SQL, DTS, Query Analyzer, SQL Profiler, Crystal Reports.