SUMMARY

• Over 7+ years of IT Experience in SQL Server Administration, Development and Database Design in Production, Developing and Testing environments with Microsoft SQL Server 2014/2012/2008 R / 2000 in various business domains.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server /2005/2000 on Clustered and Standby Environments.
• Migration from SQL server and 2000/ by using In - Place upgrade process and as well as side-by-side upgrade process, and also from SQL Server 2008/2008R2 to 2012(Side by side Migration) and documented the Upgrade Process and also expert in migrating DTS packages to SSIS Packages.
• Experience with the Additional features in SQL SERVER 2012 i.e., Always on Availability Groups for Database Mirroring and Cross-Cluster Migration of Always On Availability Groups.
• Researched and having conceptual knowledge on SQL Server 2012(Denali) implemented Always on customized self-built PC using windows server 2008R2 and SQL Server 2012 developer previews.
• Solid experience and outstanding knowledge on High availability (HA) &Disaster recovery solutions (DR) - log shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active).
• Experience in Database migration from Oracle, DB2to SQL Server 2005 and 2008R2.
• Well Experience in File and File Group’s management and Supported for Very Large Databases (VLDB) over 3TB, highly transact and Complex Databases.
• Well experience in Analyzing Performance, Query Optimization and Tuning, Creating Indexes and writing stored procedures.
• Experience in identifying the I/O and memory bottle necks, blocking and deadlocks caused by complex queries using SQL Server Activity monitor/profiler, Dynamic Management Views (DMV) and handling them by implementing better Query Execution plans.
• Experience in Index Maintenance Index tuning, Rebuild & Reorganizing according to Index fragmentation, running DBCC checks and, Update Statistics to check Data Integrity.
• Experience in analyzing Locks, Dead Locks and handling the Isolation Level and Concurrency Effects.
• Experience in Data partitioning for large tables to increase performance by paralyzing the I/O.
• Experienced in Backing up, restoring the database manually and also by scheduling the jobs and Maintenance Plans.
• Proficient with Database Recovery models.
• Experience in moving system databases and user databases when needed.
• Configured the Address Windowing Extension (AWE) in SQL Server 2005 for 32-bit architecture.
• Experience in configuring DB Mail.
• Experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Experience in using third party tools for Data modeling SQL Diagrams, Erwin, for Backup Solutions SQL LiteSpeed, Commvault for performance Foglightfor alerting Idera.
• Experience in Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility.
• Experience in Data Extraction, Transforming and Loading (ETL) using For Each Loop in SQL Server Integration Services.
• Experience in Administrating Windows Server 2003\2008\2008R2\2012.
• Implemented enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) /Network Attached Storage (NAS), RAID levels and adding new disk drives in cluster service and SQL Service dependencies.
• Responsible for SSIS package deployment and execution, SSAS cubes deployment, SSRS reports publishing, report generation and availability.
• Provided support for 24x7 availability of database Services and ensure to meet the SLA.
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.

TECHNICAL SKILLS

Operating Systems: Windows 2012,Windows Server 2008R2,Windows 2008 server, Windows 2003 Server, Windows 2000 server and Windows 95/98/2000 XP.

RDBMS: SQL Server 2014/2012/2008 R 2/2008/2005/2000 , MS Access.

SQL Server Tools: SSMS, Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan,BIDS.

Languages: C, T-SQL, DDL, DML.

ETL Tools: SSIS,SSAS,SSRS, Data Transformation Services (DTS).

Third Party Tools: Erwin, Visio, Quest Litespeed, Redgate.

Web technologies: HTML, XML, XSL.

PROFESSIONAL EXPERIENCE

Confidential, Sanfranscisco

SQL Server DBA/Power BI developer

Environment: SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Windows 2012, Windows 2008R2, Windows 2008, Windows 2005 Server, Linux, Putty, SAN, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008.

Responsibilities:

• Installed and Upgraded from SQL server 2005, 2008 and 2008 R2, 2012,2014 and some servers upgrade Standard to Enterprise edition.
• Migrated Databases fromDB2 to SQL Server 2012.
• Worked on the installation of the latest SQL Server 2012, 2014 and well experienced in its additional features.
• Worked in database Monitoring for DB2 Master prod server.
• Worked in 3 node Active-Active clustering.
• Experienced with using ClearCase to manage source control for the C code and Unix shell scripts. Developed ANSI SQLqueries, embedded within C programs, as well as ad hoc SQLqueries using the TOAD tool.
• Reviewed/Edited creative drafts of Infographic Advertisements prior to publication.
• Developed and enforce CMS database standards, guidelines and operational policies and Level II procedures.
• Analyzed, defined, and developed build process improvements using TFS.
• Experienced on to deploy workloads on Azure Resource Manager (ARM) Virtual Machines.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Granting authority to Local DBAs as necessary (see Oracle Standards for further clarification on levels of database authority).
• Administration of user accounts and managing their permissions, hands on experience on troubleshooting the connection issues of users with TFS. visualized data and designed infographicswith Illustrator, Tableau and Highcharts to illustrate the story for the online and print audience.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production database and supported it.
• Promote client Infographicsthrough impactful web and social channels.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Expert in Performance Tuning of the Databases.
• Creating SQL agent maintenance jobs for purging data, maintaining indexes, archival operations.
• Checking Database Health by using DBCC Commands and DMV’s.
• Monitored and modified Performance using execution plans and Index tuning.
• Created alerts, notifications, and emails for system errors, insufficient resources, database errors, hardware errors, and security breaches.
• Experience in Database security and integrity planning.
• Prepared Documentation for the Database Migration Plan.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.

Confidential - Scottdale,AZ

SQL/Power BI Developer

Environment: SQL Server 2012, SSDT, Erwin, TSQL, SSIS, SSAS, SSRS, Azure SQL,POWER BI, TFS, SharePoint.

Responsibilities:

• Defined and developed logical and physical data models to support business needs.
• Created business specific Stored Procedures for different reports, generating various kinds of daily and monthly reports for different Business Requirements.
• Installation of azure resource group, virtual network, Network security group, Virtual Machines, Azure DNS, and gateway for Synchronization with on premise.
• Wrote Complex stored procedure, Table valued Functions, Views for the reports.
• Refined the performance of various SQL scripts and stored procedures by using UDFs, CTEs and System stored procedures.
• Implemented continuous integration and continuous delivery for Azure Web Apps.
• Implemented error handling techniques like try catch blocks, error functions in T-SQL scripts and stored procedures to support the applications.
• Created and optimized stored procedures to perform database maintenance tasks like index rebuilding & reorganizing to deal with fragmentation problems of OLTP database.
• Used Microsoft POWER BI POWERQuery to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Used power BI PowerPivot to develop data analysis prototype, and used PowerView and Power Map to visualize reports.
• Representing data using the Cross Tabs, Scatter Plots, Geographic Maps, Pie Charts and Bar Charts, Heat Maps, Gauge, Tree Maps in Power BI.
• Published reports on Power BIservices, shared dashboards utilizing within the Office 365.
• Implemented Subscription, schedule refresh, data alert utilizing Power BIGateway.

Confidential, Austin, TX

SQL Server Production DBA

Environment: SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Windows 2012, Windows 2008R2, Windows 2008, Windows 2005 Server, PowerShell, MS Visio, SAN, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008.

Responsibilities:

• Installed and Upgraded from SQL server 2005, 2008 and 2008 R2, 2012,2014and some servers upgrade Standard to Enterprise edition.
• Migrated Databases from SQL server 2005, 2008 to SQL Server 2012.
• Worked on the installation of the latest SQL Server 2012, 2014and also well experienced in its additional features.
• Enhanced the capability of Database Mirroring using the latest feature in 2012 i.e., the Always on Availability Group.
• Worked in Active-Passive, Active-Active Cluster and DB Mirroring environment as a High availability solution .
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Set up of Transaction Replication from Application Server to Reporting Server.
• Experienced in configuring Power-Shell environment for SQL support.
• Performing Backup/Restore to/from Disk.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications
• Expert in Performance Tuning of the Databases.
• Creating SQL agent maintenance jobs for purging data, maintaining indexes, archival operations.
• Checking Database Health by using DBCC Commands and DMV’s.
• Monitored and modified Performance using execution plans and Index tuning.
• Created alerts, notifications, and emails for system errors, insufficient resources, database errors, hardware errors, and security breaches.
• Experience in Database security and integrity planning.
• Prepared Documentation for the Database Migration Plan.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Good experience in data modeling and metadata services.

Confidential, St Louis,MO

SQL Server Production DBA/Developer

Environment: SQL Server 2008R 2/2008/2005/2000 , Windows 2008, Windows 2005 Server, Powershell, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008, MS Business Intelligence Development Studio 2008.

Responsibilities:

• SQL Server 2008 R2/2008/2005 Database Administration.
• Implemented Side By Side Migration of MS SQL SERVER 2000 on Windows 2008 server.
• 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.
• Used the 2008 DMV’s for monitoring the fragmentation of indexes, blocks, page splits, Log space of all the databases.
• Working on daily tasks include Backup failures, Login creations, Data refresh and Disk space issues.
• Installed and configured Microsoft SQL2 node Clustering (Active/Passive).
• Created documentation to install SQL Server, apply service pack, hot fix and clustering installation.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• 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 CDC(Change data Capture)Process.
• 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 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.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Worked on setting up Transactional Replication (push and pull) and Merge Replication and troubleshooting.
• Creating and Maintaining Database Maintenance Plans.
• 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.
• 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.

Confidential, SanJose, CA

SQL Server Developer

Environment: SQL Server 20 (2003, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, T-SQL, MS-Access, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, SSAS, ERWIN.

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Worked with SQL queries using MS Access for data manipulations.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
• Worked on advanced dimension Design and Cube design.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.

Confidential

SQL Server Developer

Environment: SQL Server7.0/ 2000, Enterprise Manager, Windows 2000, SQL Profiler, DTS, Business Objects, T -SQL, SSIS, Crystal Reports.

Responsibilities:

• Installation and configuration of SQL Server 2000/7.0 on Window 2000/NT OS.
• Managing of database objects like Tables, views, stored procedures, indexes etc.
• Written complex stored procedures and functions according to business requirements.
• Implementing Backups and restoring when necessary.
• Creation and management of Database maintenance plan for various database consistency checks.
• Developed original system for tracking database objects (tables, views, procedures, etc.) over multiple Sybase servers using Unix Shell Scripting.
• Implemented and configured Transactional and Snapshot replication.
• Extensively working on performance issues like update statistics, Auto Stats.
• Involved in Change Data Capture process (CDC).
• Experience in SQL Server Analysis Services (SSAS) for designing OLAP Cubes.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Extensively Developed SQL scripts for maintaining administration tasks.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility that can be passed on to production support team.