SUMMARY

• Over 9 years of experience in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server also specialize in MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Production, Test, and Development Environments.
• Proficient in Installing, Configuring and Troubleshooting SQL Server 2000/2005/2008/2008 R2/2012/2014 on Standalone boxes as well as Cluster Environments.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including Integration Services (SSIS) and Reporting Services (SSRS) and Analysis Services (SSAS).
• Worked extensively in Active / Passive and Active / Active Clustered Environments to increase scalability and stability of business critical systems.
• Hands on experience in using Always on availability groups as a HADR solution.
• Hands on experience in using sql server contained databases.
• Hands on experience in Setting up and Monitoring Log Shipping, Mirroring, and Replication.
• Hands on experience in both Side by Side and In - Place SQL Server Upgrade and Migration.
• Installed SQL Server Integration and Reporting Services and configured on both standalone and Clustered Environments.
• Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS wif MS SQL 2005/2008/2012.
• Expert in working wif different data sources like OLE-DB, flat files and Excel to source data in SSIS.
• Hands on experience in Creating and Deploying SSIS packages.
• Hands on experience in creating and deploying basic SSRS reports.
• Hands on experience in deploying SSAS cubes.
• Hands on experience wif SQL Server and T-SQL in constructing triggers, tables, and user defined functions, views, indexes, relational database models, data dictionaries, and data integrity.
• Extensive experience in writing Complex Stored procedures as well as analyzing and debugging existing complex stored procedures.
• Extensive experience in Monitoring SQL server Performance and Identifying teh Bottlenecks using Performance Monitor, SQL Profiler, Database Tuning Advisor and Dynamic Management Views.
• Extensive noledge in Query Tuning using proper Index, Fragmentation and Statistics Management.
• Experience in troubleshooting teh performance problems using a various methods Tracing, Query Optimization Review, Database Tuning Advisor and Error Logs.
• Having noledge regarding memory architecture of SQL Server and their recommendations for better configuration.
• Experience in creating Automatic Maintenance jobs and notification services and SQL Alerts.
• Working Knowledge in Data Modeling using Erwin Design Tool.
• Experience in establishing Backup, Recovery, Disaster Recovery, and Disaster Recovery Drill.
• Experience in applying Patches and Service packs on standalone and cluster to keep teh database at current patch level.
• Provided 24/7 on call support on a rotational basis.
• Expertise in preparing teh documentation and working wif in teh team.
• Excellent organizational and analytical abilities teamed wif effective communication skills.

TECHNICAL SKILLS

Domain noledge: Transportation, Banking, Insurance, Telecommunications and Finance.

Operating Systems: Windows XP, Windows NT, Windows 2000 Server, Windows 2003(32 bit & 64 bit), Linux.

Databases: SQL Server 2000/2005/2008/2008 R2/2012, Oracle 9i/10g/11g.

Database Tools: SQL Server management Studio, SQL Profiler, Configuration Manager, Surface Area Configuration, Upgrade Advisor, BIDS, SSIS, SSRS,SSAS, Query Analyzer, SQL Server Agent, Performance monitor, SQL Diagnostic Manager, Database Tuning Advisor, Lite Speed, Microsoft visual studio 2005 / 2008/ 2012..

Middleware servers: Web Sphere 5.x/6.x/7.x, IBM HTTP Server 1.3/2.0/6.0/6.1 , Apache Server, IPlanet6.x, Microsoft IIS, Tomcat.

Languages: Transact SQL, VB Script, C, C++, and JAVA.

Management Tools: Visual Source Safe, SVN, Lite Speed, VMware, Active Directory, Netback up.

Design Tools: Erwin, Microsoft Visio.

Networking: Sun One Directory Server, Site minder.

PROFESSIONAL EXPERIENCE

Confidential

Sql server production DBA

Responsibilities:

• Installed and configured SQL Server 2014/2012 on both standalone and cluster environments.
• Implemented Sql Server 2014 always on groups as HADR solution for Sql Server QA and Production Environments.
• Expertise in using contained databases as part of HADR solution for QA and Production sql servers.
• Migrated databases from Sql server 2008 R2 to Sql server 2014 and added databases to always on groups on Sql server 2014 servers.
• Configured databases to use database mirroring on Sql server 2008 r2 production systems as a DR strategy.
• Migrated databases from Sql server 2000/2005 to Sql server 2008 R2.
• Installed SQL Server 2008 r2 SSIS, SSRS and SSAS services.
• Configured scale-out deployment for Sql server 2008 r2 SSRS production servers as a DR solution.
• Migrated SSRS reports from sql server 2005 to sql server 2008 r2 as part of migration process.
• Deployed SSRS reports using BIDS on QA and Production systems.
• Deployed SSIS packages using BIDS on QA and Production systems.
• Troubleshooting SSRS report data source issues.
• Creating subscriptions, granting access to end-users to SSRS reports.
• Applying service packs, cumulative updates to Sql server Database engine services, SSIS, SSRS and SSAS sql servers.
• Deploying Sql server objects like tables, indexes, views and stored procedures using scripts provided by teh developers in source control on QA and Production systems.
• Extensively used HPSM to work on tickets based on priority levels related to Sql server Database engine services, SSIS, SSRS and SSAS sql services.
• Deployed xmla scripts to create cubes on SSAS QA and Production servers.
• Troubleshooting SSAS storage issues and Cube corruption issues on QA and Production Sql servers.
• Extensively used Idera SQL Diagnostic manager to monitor sql servers.
• Auditing sql server using sql default trace to identify security changes on sql server production servers.
• Assisting OS teams during windows patching on sql server installed windows boxes.
• Used Sql server activity monitor and DMV’S to monitor sql server performance.
• Participated in a Quarterly SQL server DR test for critical applications.
• Used DBCC commands to perform maintenance activities.
• Scheduled sql server backups to run using COMMVAULT.
• Used Database engine tuning advisor to tune slow running queries.
• Provided 24/7 on-call support on a rotational basis.

Environment: SQL Server 2000/2005/2008 R2/2012/2014, windows 2000/2003/2008 /2012 , SQL Server Integration Services, SQL Server Reporting Services, Sql Server Analysis Services, SAN Replication, Visual Studio, Idera Sql DM, Commvault.

Confidential, Cranston, RI

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2008R2\2012 on both standalone and cluster environments.
• Hands on experience in Active\Passive and Active\Active multi-node cluster environments.
• Involved in consolidating multiple standalone server applications in to shared cluster environment.
• Migrated databases from sql server 2000\2005\2008 servers to sql server 2008 r2 and sql server 2012 servers.
• Configured log shipping, database mirroring for critical production databases.
• Configured and monitored sql server transactional replication for reporting purposes.
• Installed and configured sql server 2008 r2 reporting services for OLTP servers.
• Involved in side by side upgrade from sql server 2000\2005 to sql server 2008r2\2012.
• Installed, configured and administered quest fog light for production and QA environments.
• As part of production readiness, actively worked wif SAN team to setup SAN replication as a DR solution for sql server production servers.
• Experience in using DMV’S to generate fragmentation reports and checking blocking sessions to monitor performance.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Created linked servers between different RDMS sources.
• Created maintenance plans like rebuilding teh indexes, re-organize indexes, update statistics, Integrity check and Backups for system databases and user databases.
• Expertise in Server Management issues like administration, Backup/Restore, Space Management (auto growth/shrink, file groups), Attach/Detach.
• Installed and configured Symantec enterprise security manager DB agent on sql servers to monitor sql server security auditing.
• As part of security hardening on sql servers, created triggers to record security events.
• Implemented windows AD group type access to end users.
• Created application accounts using sql server authentication and granted access to database objects through roles.
• Deployed SSIS packages using BIDS on both production and QA environments.
• Provided 24/7 on call support.

Environment: SQL Server 2000/2005/2008 R2/2012, windows 2000/2003/2008 , SQL Server Integration Services, SQL Server Reporting Services, Erwin, SAN Replication, Symantec Enterprise security manager, Visual Studio, Quest Fog light, SQL Lite speed backup, Oracle 10g/11g r2.

Confidential, Minneapolis, MN

SQL Server Production DBA

Responsibilities:

• Installed, Configured SQL Server 2008 R2 on both standalone and Cluster Environments.
• Updated SQL Server 2005 to SQL Server 2008 R2 in Production and Test Environments.
• Migrated Databases from SQL Server 2005 to SQL Server 2008 R2 in Production and test Environments.
• Configured SQL Encryption on Production Servers.
• Worked extensively in Active / Passive and Active / Active Clustered Environments to increase scalability and stability of business critical systems.
• Worked on high availability SQL Server solutions, including Log shipping, Transactional Replication and Mirroring.
• Involved in Data modeling, designing, and building relational databases.
• Monitored Performance Monitor and SQL Profiler to optimize queries and enhance teh performance of database servers.
• Diagnosed and tuned teh server Optimal Performance using SQL Server 2005’s Dynamic Management Views (DMV).
• Backup and Recovery of production databases and tuning them for better performance.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Creating databases and logins and users wif permissions in SQL server 2005/2008.
• Configured Linked Servers between SQL server 2005/2008 and Oracle servers in teh environment.
• Used DBCC commands to check physical and logical consistency of teh databases and rebuild indexes.
• Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
• Expertise in Server Management issues like administration, Backup/Restore, Space Management (auto growth/shrink, file groups), Attach/Detach.
• Created SSIS packages from scratch and deployed them.
• Deployed SSIS and SSRS packages on QA and Production environments.
• Worked wif different data sources like OLE-DB, flat files and Excel to source data in SSIS.
• Provided 24/7 on call support on a rotational basis.

Environment: SQL Server 2005/2008 R2, windows 2003/2008, SQL Profiler, Erwin, TSQL, BIDS, SQL Server Integration Services, SQL Server Reporting Services, SQL Agent, Visual Studio,. Net framework, Oracle 10g\11g.

Confidential, Memphis, TN

SQL Server Production DBA

Responsibilities:

• Installed SQL Server 2008 / 2005 on Windows 2003 / 2000 Servers on Active / Passive as well as Active / Active Clustered environment and applied Patches, Hot Fixes and Service Packs.
• Upgraded SQL Server 2000 / 2005 to SQL server 2008 and Migrated Databases and Logins.
• Hands on experience in Monitoring and Performance Tuning at Server, Database, Query and Object levels.
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups.
• Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes.
• Responsible for configuring and monitoring Log shipping of important databases.
• Configuring and maintaining Transactional Replication between Source and Target SQL Server Databases.
• Configured Linked Servers.
• Managed Security by creating login/groups and assigning appropriate permissions.
• Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.
• Developed SSIS packages using different type's task and wif Error Handling.
• Developed several Complex Reports (daily, weekly, monthly, quarterly and yearly) using SSRS (SQL Server Reporting Services).
• Enhanced teh old Excel Reports to new SQL Server Reports that fit new business requirement, and implemented into SQL Server 2008.
• Created Views and Indexed Views to reduce database complexities for teh reports.
• Scheduled teh Reports to run on daily and weekly basis in Report Manager and Troubleshooting for any error occurs in execution.
• Performed unit testing and regression testing in testing various reports and to check teh validity of teh data retrieved from teh database.
• Written and Maintained teh Reports (or) Documentation on Performance Issues for Future Follow ups.
• Provided 24x7 on call support.

Environment: Microsoft SQL Server 2000/2005/2008 Enterprise Edition, Windows 2000/2003 Server, Management studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), Ms Excel 2003, Microsoft Visual Studio.NET 3.5, BIDS, Visual cut, Visual Source Safe.

Confidential, Boston, Massachusetts

SQL Server DBA/Developer

Responsibilities:

• Installation, Configuration and Administration of SQL Server 2005/2008 on Windows 2003 Servers.
• Implemented and maintained database security, logins, roles and schemas.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Performed Database backups (operating system, flat file backups & export/import).
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.
• Performed application program enhancements, troubleshooting and bug fixes as required.
• Implement Replication for Reference Data across different Instances of teh application.
• Worked on Active/Active and Active/Passive Clustering.
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Performed query tuning & optimization using Query Plans & SQL Profiler.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Developed standards and guidelines to maintain and develop and administer teh SQL Server database.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Handled Database recovery (disaster recovery), diagnosed, repaired and was involved to transfer teh OLTP data to Data Warehouse.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Environment: SQL Server 2005/2008, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Windows 2003 Server.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Involved in developing logical design, ER diagrams and mapping data into database objects.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained Referential Integrity.
• Created Stored Procedures to transform teh Data and worked extensively in T-SQL for various needs of teh transformations while loading teh data.
• Checked teh coding standards followed by peers of teh team.
• Developed Stored Procedures, Triggers, Cursors and Functions.
• Involved in Data Migration and Data Integration.
• Conducted teh Performance tuning, indexes tuning, and Checked Deadlock Issues.
• Automated teh routine Maintenance Tasks and Jobs.
• Managed Login and User: adding logins, roles, groups to teh Window NT and MS SQL Server and maintaining proper security procedures.
• Involved in capacity planning in estimating and sizing of tables.
• Extraction, Transformation and Loading of teh data using DTS packages.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Performed Backup and Restore and verified teh Health of teh Databases.
• Implemented Log Shipping for specified databases as High Availability solution.
• Monitored SQL Server Logs, OS Logs for Troubleshooting teh Issues.
• Worked on Linked servers to run Distributed queries between SQL Servers.
• Responsible for designing schema and finalization of naming and coding standards throughout project life cycle.

Environment: SQL Server 2000 / 7.0, Windows 2000 Server, SQL Profiler, HTML, T-SQL, SQL Loader, DTS, visual studio 6.0, Visual Source Safe and Replication.