SUMMARY

• Certified Lead Sr. MS SQL DBA with 9+ 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, PowerShell TFS, SCOM 2012.
• Oracle & My SQL Around 2 years of experience inOracleDBA& Data Analyst on Linux, UNIX and Windows operating system environments.
• 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.
• Implemented the newSQLServer 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• CreatedDatabase Maintenance Plansand scheduled jobs that use SQL Server Integration Service Packages forchecking the health of migrated databases on new environment; Identified locking, blocking, dead locking issues and resource bottlenecks and resolved them.
• Ensures databases are replicated and backed up to meet the operational and disaster recovery requirements (current environment and Azure environment).
• Experienced with deploying to the cloud and have 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.
• 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 the System Center Operations Manager (SCOM) platform architecture to ensure operational needs of both the monitoring platform and the 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.
• 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.
• Experience in Deployment and Configurations of SQL Server Reporting and Analysis Services; Worked on adhoc reporting, Parameterized Reports, Custom Reporting.
• Experience with Oracle databases (9i, 10g, 11g, 12c) as well as exposure to MySQL (5.5); Responsible for both managing and supporting all Production, Development and Staging instances ofOracleVersion's 9i, 10g & 11g.
• Experience with configuring and administering Oracle RAC; Experience with configuring and administering Automatic Storage Management (ASM) and GRID Control.
• Experience in performance tuning using EXPLAIN PLAN, AWR and ADDM.
• Co-coordinating/Handling team offshore and On-site DB and application support teams.
• Good understanding of ITIL Processes-Incident, Change and Problem Managements.

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee

Lead Sr. Database Administrator

Responsibilities:

• Collaborated with Management to develop strategies to support miscellaneous organization requirements.
• Consulted with users on access to various databases; resolved data conflicts and inappropriate data usage.
• Migrated databases from SQL 2000 to SQL 2014 and Implemented Always-On availability using file share method in SQL 2014
• Maintained a highly secure, clustered and available systems (24/7 basis and worldwide)
• ETL experience and data warehousing experience working knowledge with SQL Azure, and migrating servers from On-premise to cloud and Migration of database services to Cloud (Azure).
• 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.
• Performed disaster recovery tests on a scheduled basis.
• Liaising with the SharePoint Administration team to assure that all SharePoint solutions are properly configured for disaster recovery.
• Liaising with the .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 the disaster recovery plan.
• Developed PowerShell script to automate several SQL Server-specific administrative/reporting tasks.
• Established best practices and guidelines for SQL Server PowerShell development.

Environment: SQL Server 2005/2008/2008 R2/2012/2014 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Windows Server 2008 R2/2012 and SCOM.

Confidential

Lead Senior Sr. SQL Server DBA

Responsibilities:

• Involved in Migration, Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshot issues with the same. Applied hot fixes and Service Packs in clustering environments.
• Created and maintained various databases for Production, Development and Testing environments usingSQLServer 2014, 2012, 2008r2, 2005.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshot issues with witness servers.
• Experienced in performance tuning using windows performance monitor andSQLprofiler ofSQLserver. UsedSQLServer error logs and event viewer to troubleshoot issues.
• Experience in Configuring, Managing and troubleshooting onSQLServer connection protocols like Kerberos and NTLM.
• Expertise in registering a SPN for Kerberos Connection and Performing NTML Failback.
• Implemented Kerberos Delegation with SSRS.
• Expertise in Fixed several Common issues in Kerberos and NTLM protocol like "Login Failed for user", "Could not open a connection toSQLServer", "Cannot generate SSPI Context", etc.
• Involved in Data migration ofSQLServer 2012 TOSQLServer 2014; Involved in moving login & users during server migration.
• Migrated an existing on premises SQLServer database toSQLAzure.
• All schema migrations via SSMS and migrated data through SSIS package toSQLAzure.
• Involved in the data migration across different databases and different servers using SSIS, BCP and Import/export tools; Experience in Data modelling and Data profiling.
• Performed daily backups and developed recovery procedures; Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Troubleshot issues with log file full and database size increasing beyond threshold.
• Creation of new database, planning the location of data, index, and transaction log files on the disks;
• Involved in Capacity Planning, data modeling and Logical/Physical database Design; Provided support to the application developers on the application databases; Handled the database components of application releases.
• Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources likeSQLServer, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
• Developed and deployed stored procedures, created triggers and audits.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff/log backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs etc.
• Proactively monitored, determined and solved issues atsql/database/server levels.
• Handled 24/7 production issues.
• Very good experience with Oracle 10g RAC administration and HA environment.
• Experience in using DB links & materialized views and Wrote PL/SQL stored procedures, functions and packages for moving data.
• Good Experience with Oracle PL/SQL scriptting
• Supported installation and setup of ORACLE Cluster's and RAC database.

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 Database Administrator

Responsibilities:

• Planned and Successfully InstalledSQLServer 2012 on the Production and Development Servers.
• Successfully Installed the Service Pack 2 and Hot-fix forSQLServer 2012 in all the Dev and Prod Environments.
• Involved in migration of the existing 2008R2 databases toSQLServer 2012.
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Developing the successful Backup strategies based on Recovery models.
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production.
• Involved in creating Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Raising the change management request and following up with the customer approval, for making any changes in the production server.
• Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Transactional.
• Implementing Database maintenance plan for Database consistence & Integrity.
• On call 24/7 support to databases on weekly rotation.
• Experience with SSIS, SSAS, SSRS; Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Used SSRS to build health check reports & deploying the SSRS.
• Experience in using Data driven Subscription to prevent unforeseen circumstances.
• MonitoringSQLserver performance using profiler to find the performance and dead locks.
• Monitoring and TroubleshootingSQLCluster, Mirroring, Log Shipping.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Recovered many Databases at the time of Database crashes or data loss.
• PerformingSQLServer database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.

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:

• Created and maintained various databases for Production, Development and Testing environments usingSQLServer.
• Actively involved in setting up Active-Active/Active-Passive clustering in Production and Testing Environments and also troubleshoot issues with the same; applied hot fixes and Service Packs in clustering environments.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshoot issues with witness servers.
• Migration ofSQLServer 2005 TOSQLServer 2008 & 2008R2 versions
• Performed daily/weekly/monthly based backups and restore.
• Migration of the data across different databases and different servers using SSIS, BCP and Import/ export tools.
• Performance tuning using windows performance monitor andSQLprofiler ofSQLserver; usedSQLServer error logs and event viewer to troubleshoot issues.
• Troubleshoot issues with log file full and database size increasing beyond thresholdCapacity Planning, data modeling and Logical/Physical database Design.
• Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Provided support to the application developers on the application databases.
• Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracing to identify performance issues with deadlocks & other locking issues.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• UsingSQLServer Reporting Services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting/Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources such asSQLServer … Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• ITIL process such as Change management, Incident Management & Problem ManagementMaintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Experience on Configuring and Maintaining Backup strategies using Lightspeed and SQL Maintenance Jobs and implemented log shipping using LightSpeed.
• Configuring and monitoring multiple servers using Spotlight.
• Experiences on Diagnostic servers, Notification Alams, Reporting with using Spotlight.

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

SQL Server DBA

Responsibilities:

• Installation of MS SQL 2005 Enterprise servers on test and development boxes.
• Recommended system design approaches, which are consistent with the application's business requirements.
• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
• Handling database objects with Enterprise Manager and Query Analyzer.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the 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 with development resources, System Administrators and System Architects.
• Automated processes using SQL Server jobs.
• Proper use of Views to prevent unauthorized access.
• Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the 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 the concept of OLEDB.
• Installation of replication server, configuration and monitoring the 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, and 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 the 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 the reports.(SSRS)(2005/2008 R2).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with 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 with error handling.
• Experience in moving the 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 the reports in SSRS.
• Responsible for scheduling the subscription reports with 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 the web front end.
• Created the 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 with End user and changing the 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 with 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 the SQL Server by creating users & login ids with 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 the performance of the Server.
• Tuned the SQL queries using SQL profiler. Involved in tuning the 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.