SUMMARY

• Over 8 years of IT experience in SQL Server Administration and Database Design in Development, Test and Production environments with MS SQL Server 2014, 2012, 2008R2, 2008, 2005
• Experience in installing SQL Server 2012, 2008R2, 2005 applying service packs and patches on stand - alone and Cluster Environment and Configuring on 32 bit, 64 bit Architectures
• Experience in Upgrade process of SQL Server 2008/2008R2 to SQL Server 2012 and Migrated databases from SQL Server 2008/2008R2 to SQL server 2012 databases
• Solid experience and outstanding knowledge on High availability & Disaster recovery solutions - Log Shipping (With Monitor Server Instance), Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active - Active)
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID Levels
• Experience in implementing Business logic by using T-SQL (DDL, DML), stored procedures, triggers, and user defined functions (UDF)
• Experience in Analyzing Performance, Query Optimization and Tuning, and creating Indexes
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
• 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 performing database regular Backups (Full/Differential/Transaction Log Backups into Disk and striping for large Databases) and Restoring on requirement. And proficient with Database Recovery models
• Experience in automation of administrative tasks like creating Maintenance plans, creating Jobs, Alerts using SQL Server Agent
• Extensive experience in planning and controlling User Privileges, Monitoring Security and Audit issues as per Standards
• Experience in configuring DB Mail and Migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP and DTS utility
• Responsible for SSIS package deployment and execution, SSRS reports publishing, report generation and availability
• End to end experience in designing and deploying data visualizations using Tableau.
• Expertise in usingglobal variables,expressionsandfunctionsfor the reports with immense experience in handling sub reports inSSRS
• 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

RDBMS: MS SQL Server 2012, 2008, 2008R2, 2005, 6.5, 7.0, Oracle 8i/9i/10g, MySQL

Programming: Visual Basic 6, Visual Basic 5, Visual Studio, C, C++, C# .NET, VB.NET & T- SQL

Web Technologies: HTML, XML, XSL, JavaScript, IIS (5.1/6.0/7.0),MOSS 2007

Operating System: Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux, Unix

SQL Server Tools: SSMS, Enterprise Manager, Query Analyzer, System Monitor/Performance Monitor, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, SSIS, SSRS, SSAS

ETL Tools: SQL Server Integration Services (SSIS), Tableau Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Connecticut

SQL SERVER DBA

Responsibilities:

• Installed and configured SQL Server 2014, 2012, 2008 on both cluster and stand-alone environment
• Involved in Upgrade process of SQL Server 2008/2008R2 to SQL Server 2012 and Migrated databases from SQL Server 2008/2008R2 to SQL server 2012 databases
• Installed SQL Server Service Packs to keep the SQL Server up to date
• Maintained DB Security by creating logins, users, roles and permissions for the business people
• Verified and maintained System Health Checkups like Space, CPU, Table Statistics
• Responsible for activities daily routine backup, restore, refreshing databases as per requirements
• Scheduled and created Maintenance plans on databases and also created automated jobs
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Configured and managed log shipping for Disaster recovery solution
• Configured Database Mirroring with high performance and high availability mode
• Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, Attach/Detach Data Migration tools
• Maintained both Development and Test servers in sync with PRODUCTION server by doing Database Refresh
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters
• Created Operators and Configured Database Mail
• Used ETL packages to move logins and jobs from one server to another server
• Extracted the data from Oracle Database and loaded to SQL Database using SSIS
• Performed Query optimization and achieved Performance by tuning SQL queries using Profiler and Execution Plans
• Implemented different types of Replications Transactional, Snapshot and merge replications
• Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms

Environment: SQL Server 2012/2008/2005 , MS Excel, Windows2003/2008, Linux, Visio, SQL Diagrams, Activity Monitor, Spotlight, Index tuning wizard, SQL Profiler, Query Analyzer, Enterprise Manager

Confidential, Montpelier, VT

SQL SERVER DBA

Responsibilities:

• Installation and configuration of SQL Server 2012/2008R2, applying service packs in both Cluster and stand-alone environments
• Created Logins and managed database objects like Tables, views, stored procedures, indexes
• Created Jobs, Alerts using SQL Server agent, monitoring and troubleshooting the jobs
• Monitored database health and tuned accordingly
• Monitored replication health checks and backup checks
• Configured log shipping, Database mirroring for high availability of Databases
• Analyzed Performance and Optimizing and Tuning queries, Indexes and Stored Procedures
• Involved in Index Maintenance Index tuning, Rebuild & Reorganizing Indexes according to Index fragmentation
• Involved in creating internal DBA RFCs
• Optimization of T-SQL procedures, resolving the blocking, deadlocks, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities
• Implemented Data partitioning for large tables in SQL Server 2005 to increase performance
• Configured and managed database maintenance plans for update statistics, database integrity check and backup operations
• Created Operators and Configured Database Mail
• Extracting and transforming data using SSIS, Import/Export Data, Bulk Insert and BCP Utilities
• Created, deployed, configured complex ETL/SSIS packages to transfer the data between production and development environments
• Developed Business reports using Pentaho Report Designer and SSRS and Built metadata for use in Pentaho Interactive Reporting
• Created reports like Tables, Maps, Charts and Graphs using Tableau Reporting Tool
• Worked on formatting SSRSreports using the Global variables and expressions
• Createdparameterized reports, Drill downandDrill throughreports using SSRS
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications
• Involved in performing Audits and recovery operations of SSAS objects
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team

Environment: MS SQL Server 2005/2008/2012 , Windows 2003 server, T-SQL, SSIS, SSRS, SSAS, Pentaho Report Designer, Tableau Reporting Tool, Query Analyzer, Enterprise Manager, MS Excel, Spotlight

Confidential, Carmel, IN

SQL SERVER DBA

Responsibilities:

• Managed and administrated SQL Server 2008R2/2008/2005 on production and non-production servers
• Installed SQL Server 2008/05 and service packs on Windows Server Clustered environment
• Migrated SQL Server 2005 databases to SQL Server 2008 databases including DTS to SSIS packages
• Updated statistics, performed database integrity checks and Backup operations
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Set up and monitored transactional replication, database mirroring on Production
• Developed and created the new database objects including tables, views, index, stored procedures, functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Experienced with the service layers and communicated with the Entity Framework in the back end.
• Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
• Handled the RFC's and work orders assigned to me as a part of daily responsibilities and also involved in RFC deployment
• Responsible to monitor and troubleshooting Log Shipping
• Assisted on the Adhoc-Query requests based on the requirement by using joins, sub queries and co-related sub queries
• Created, scheduled database maintenance plan using SSIS Maintenance plan task
• Mastered the ability to design and deploy rich Graphic Visualizations with Drill Down and Drop Down menu and Parameterized using Tableau
• Worked on SSRS togenerate hierarchical reports and drill down reports and tested using Management Studio in SQL server 2005.
• Used Online Indexing and online Restoring in SQL 2005
• Prepared, maintained and modified SQL server installation and configuration documents

Environment: SQL Server 2005/2008, SSIS, DTS, VB.NET, Web Services, JavaScript

Confidential, Salt Lake City, UT

SQL SERVER DBA

Responsibilities:

• Installed SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services (MSCS) from Hardware inventory to test environment
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005
• Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments
• Designed and implemented comprehensive Backup plan using SQL LiteSpeed
• Resolved and tweaked memory pressures caused during product release
• Worked with customers on Application rollouts and server migrations
• Troubleshoot performance problems and fine-tuning of databases
• Expertise in designing databases and capacity planning
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs
• Monitored and modified Performance using execution plans and Index tuning

Environment: SQL Server 2005, Windows 2003 Server, SQL LiteSpeed 4.5, MSE, VSS and Password Updater

Confidential

SQL SERVER Developer

Responsibilities:

• Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• OptimizedSQLqueries for efficiency and the front-end developer with their queries and procedures.
• Migrated access objects toSQL Server 2005.
• Created Tables,IndexesandConstraints.
• CreatedIndexes, Views, Triggers, Stored Proceduresand Packages inT-SQL.
• Configured and monitored database application.
• DevelopedReportsto generate daily, weekly, monthly, quarterly, yearly Reports usingCrystal Reports
• Designed and implemented several complex reports and administration modules.
• Defined stored procedures for module integrity and application.
• Wrote database triggers inT-SQLto check the referential integrity of the database.
• DesignedVBforms using the forms andcrystal reportswere made for business reporting purpose.
• Involved in performance tuning of the database andT-SQLqueries using Execution Plan.

Environment: SQL server 2005/2000, Visual Basic 6.0, Windows2003, Crystal Reports 8.0 and MS Visio professional