SUMMARY

• 14 years of Information technology Industry experience, possess extensive experience in MS SQL Server 2012/2008 R 2/2008//2005/2000 versions.
• Extensively worked with MS SQL Server 2012/2008R 2/ 2008/2005/2000 on Windows platform. Experience in SQL Server Clustering Environment. Installation of SQL Server Active/Active & Active/Passive Cluster environments.
• Extensively worked with MS SQL Server 2012/2008R 2/ 2008/2005/2000 on windows platform having SAN environment and Virtual Machines.
• Expertise in moving servers from one Data Center to another Data Center.
• Extensively worked with MS SQL Server 2008R 2/ 2008/2005/2000 OLTP and Data Warehouse environments
• Extensive experience with MS SQL Server 2008R2/2008/2005 Extraction, Transformation and Loading process.
• Set up Database Mirroring and Log shipping for High Availability.
• Set up Database Replication (Snap shot, Transaction, and Merge).
• Expertise and Interest include Administration, Development, Database Design, Performance Analysis, and Production Support for Large (TB’s) and Complex Databases., Replication, Log Shipping, Full - text indexing, and Database 24 X 7 Production Database on Call Support.
• Extensive experience with MS SQL Server 2008/2005 new features such as Table/Index partitioning, Policies, Facets, Online Restore, Online Indexing Operations, SQL Server Management studio, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting services(SSRS), Snapshot Isolation and Database Mirroring.
• Expertise in SQL Server Performance fine-tuning, query optimization, index maintenance query planning, and SQL Trace utilities.
• Hands on experience in Data Integration, Database Migration, Database upgrade, Data warehousing, Performance Tuning, Implementation and troubleshooting production issues.
• Extensive experience supporting databases in Terra Bytes size.
• Workflow structure and configuration, Workflow Connections
• Mapping Validations, Object Export and Import.
• Workflow structure and configuration, Workflow Connections.
• Exposure to Complete Software Development and Maintenance Life Cycle.
• Involved in supporting large production databases and fine-tuning of large production databases of various libraries and other financial clients in US.
• Extensively worked with Confidential Operations Manager.
• Exceptional skills in Tuning and analyzing application code such as SQL, Stored Procedures, functions, Triggers, views and fine-tuning of system resources such as CPU, I/O and Memory. Setting up Backup and recovery strategies, Scheduling jobs, Shell Scripting. Upgrading databases, and applying patches. Extensive experience with DTS packages, T- SQL.
• Worked as module lead closely with Product Analyst’s, DBAs and manager’s & Business users to the enforce database standards in the development and database upgrade.
• Planning and work allocation Risk Management and Issue resolution.
• Application Monitoring and reporting
• IIS 6.0 Configuration and Trouble Shooting
• Sound knowledge in SQL Server Index Tuning and query optimization for OLTP and Data Warehouse environments.
• Extensive experience in (24 x 7) Production and Beta-customer Support
• Ability to work in team environment with excellent presentation, leadership, analytical, qualitative and interpersonal skills.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team.

TECHNICAL SKILLS

Web Systems: IIS 6.0 Web Server, DNS, TCP/IP, Proxy Server, MTS

Development Tools: VB.NET, ASP.NET,C#.NET

Reporting Tools: SSRS

Languages: T-SQL, PL/SQL, HTML

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

RDBMS & Tools: SQL Server 6.5/ 7.0/2000/2005/2008/2008 R2/2012 My SQL 4.0, Export/Import

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Backup software’s: Symantec/Light speed/Backup Utility/Veritas / Visio

Other Software’s: PC Anywhere, ActiveX, DAO, ODBC, ADO, MS Outlook, Front, Lotus Notes, Page, SQL, Telnet, FTP

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Installation & Configuration of SQL Server 2012/2008 R2/2008 64 bit Enterprise Edition on new Servers.
• Database Support Team in developing and implementing next generation database systems architecture.
• Daily Administration and performance monitoring of Database related systems and migration of database related changes.
• Design, Create, Expand, Shrink, Drop and Settings of Database options
• Back up databases, Transaction logs and implementing Backup & Restore strategy.
• Backups strategies implemented Natively and thru third party tool (Symantec NET backup tool)
• Created Synonyms for Tables, Views, Stored Procedures, and UDFs and configuring Assemblies, Managed stored Procedures.
• Operational support for SQL Report services (SSRS) and Analysis Services (SSAS).
• Worked with MS SQL Server 2008 R2/2008/2005 Extraction, Transformation and Loading process.
• Set up Database Mirroring and Log shipping for Share point High Availability.
• Migration of database servers retiring the old server.
• Migrated over 30 terra bytes of data during the split of Confidential and Confidential .
• Worked on Servers Builds for both Confidential and Confidential (includes Production, QA and Development environments)
• Worked on Database & Application Deployment on, QA and Development environments.
• Extensively given database support (Production, QA and Development environments).
• Performed numerous Disaster recoveries.
• Responsible for capacity planning, resource management such as memory management, disk management etc. also responsible for back up, recovery and disaster recovery.
• Resolving Application & User Issues.
• Resolving client issues. Adding patches and updating applications
• Tune stored procedures, functions, and packages to support needs of Developers.
• Provided programming guidance and architectural support for applications and developers to support ongoing Development Projects.
• Assist in the design, development, and support of relational and non-relational database designs and their physical generation in a team-oriented environment using data modeling tools.
• Implementing of all IT best practices.
• Ability to quickly troubleshoot and conduct root cause analysis.
• Ownership and accountability for production level issues.
• 24X7 PRODUCTION, USER SUPPORT & ON LINE SUPPORT

Environment: SQL Server 2012, 2008 R 2/ 2008/2005/2000 , Poly Serve, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) & SQL Server Analysis Services (SSAS), IIS Administration, Windows 2008/2003.

Confidential

SQL Server DBA

Responsibilities:

• Installation & Configuration of SQL Server 2008/2005 64 bit Enterprise Edition on new Servers. Installed and configured Confidential IIS.
• Daily Administration and performance monitoring of Database related systems and migration of database related changes.
• Moving Servers from Data Center to Data Center (includes Production & Pre-Production).
• Designing database structure including schemas (Star & Snow flake), tables, columns, relationships, Normalization, primary keys, data types, data validation.
• Design, Create, Expand, Shrink, Drop and Settings of Database options
• Back up databases, Transaction logs and implement a Backup & Restore strategy.
• Scrubbing and cleansing of legacy data and migration from various disparate formats to SQL Server prior to Extraction, Transformation and Loading into Data Warehouse.
• Operational support for SQL Report services (SSRS) and Analysis Services (SSAS).
• Worked with MS SQL Server 2008/2005 Extraction, Transformation and Loading process.
• Set up Database Mirroring and Log shipping for High Availability.
• Workflow structure and configuration, Workflow Connections
• Migration of database servers.
• Extensively worked on Database & Application Deployment on Production and Pre-production environments.
• Extensively given Production support and applications support (both Production and Pre-Production environments) in Confidential .com.
• Responsible for capacity planning, resource management such as memory management, disk management etc. also responsible for back up, recovery and disaster recovery.
• Install and configured Everycontactor.com applications in Production &Testing
• Resolving Application & User Issues, client issues. Adding patches and updating applications
• Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals using SSRS 2005/2008.
• Generated reports using SSRS, Excel (Pivot).
• Tune stored procedures, functions, and packages to support needs of Developers.
• Defined calculations, which are Multidimensional Expressions (MDX) expressions or scripts. Calculated members, named sets, and execute other script commands to extend the capabilities of a Confidential SQL Server Analysis Services (SSAS) cube.
• Experience in Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Provided programming guidance and architectural support for applications and developers to support ongoing Development Projects.
• Assist in the design, development, and support of relational and non-relational database designs and their physical generation in a team-oriented environment using data modeling tools.
• Implementing of all IT best practices.
• Ability to quickly troubleshoot and conduct root cause analysis.
• Lead projects like live website, ECHubs, Report Manager, Intranet, Blue AJAX, Green AJAX, Auto jobs, Finance, e-Fax, Dymo
• Ownership and accountability for production level issues.
• 24X7 PRODUCTION, USER SUPPORT & ON LINE SUPPORT

Environment: SQL Server 2008/2005/2000 , Active/Active Clustering, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) & SQL Server Analysis Services (SSAS), IIS Administration, Windows 2003.

Confidential

SQL Server DBA

Responsibilities:

• Installation & Configuration of SQL Server 2005/2000 Enterprise Edition on new DELL Servers. Installed and configured Confidential IIS & MTS servers
• Installed and configured SQL Server Active/Active Clustering on the servers on SAN environment and Virtual Machines
• Merged 50 plus stand-alone databases to one centralized Master database and size of the database more than TB.
• Integrate and manage financial and clinical data to help improve overall operations and enhance the care process with McKesson's Clinical applications interface and Practice Schedule Manager Applications.
• Designing database structure including schemas (Star & Snow flake), tables, columns, relationships, Normalization, primary keys, data types, data validation.
• Design, Create, Expand, Shrink, Drop and Settings of Database options
• Back up databases, Transaction logs and implement a Backup & Restore strategy.
• Scrubbing and cleansing of legacy data and migration from various disparate formats to SQL Server prior to Extraction, Transformation and Loading into Data Warehouse.
• Operational support for SQL Report services (SSRS) and Analysis Services (SSAS).
• Involved in the SSAS storage, Aggregations, and calculation of queries with MDX, developing reports using MDX and SQL.
• Involved in enhancing the functionality of OLAP Cube by creating KPI.
• MS SQL Server 2005 Extraction, Transformation and Loading process.
• Mapping Validations, Object Export and Import.
• Set up Database Mirroring and Log shipping for High Availability.
• Workflow structure and configuration, Workflow Connections
• Migration of database servers.
• Installed and Configured Confidential Windows 2003/2000 Servers and MS SQL2005/2000
• Involved in Servers Builds (both Production and Pre-Production environments)
• Involved in Database & Application Deployment on Production and Pre-production environments.
• Extensively given Production support and applications support (both Production and Pre-Production environments) in Confidential .
• Responsible for capacity planning, resource management such as memory management, disk management etc. also responsible for back up, recovery and disaster recovery.
• 24X7 PRODUCTION & USER SUPPORT & ON LINE SUPPORT

Environment: SQL Server 2005/2000, Active/Active Clustering, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), IIS Administration, Windows 2003/Vista

Confidential, Seattle-WA

SQL Server DBA

Responsibilities:

• Installation & Configuration of SQL Server 2005/2000 Enterprise Edition on new DELL Servers.
• Installed and configured SQL Server Active/Active Clustering on the servers on SAN environment and Virtual Machines.
• Tracking project metrics
• Planning & scheduling maintenance of servers for patches/updates installation having minimum impact on End Users.
• Designing database structure including schemas (Star), tables, columns, relationships, Normalization, primary keys, data types, data validation.
• Used SQL Server Analysis Services (SSAS) to create cubes using dimensional and fact tables to implement Data Warehouse for analysis.
• Worked on OLAP databases for reporting and used together with SQL Server Reporting Services (SSRS).
• Extensively given Production support for databases more than Terra byte.
• Design, create, expand, shrink, drop and setting of Database options
• Back up databases and implement a Backup strategy, Restore
• Installed and Configured Confidential Windows Vista/2000/2003 Servers and MS SQL2005/2000
• Involved in Database & Application Deployment on Production and Pre-production environments.
• Build and Supported applications and Production servers (both Production and Pre-Production environments) in Confidential shadow support group.
• Responsible for capacity planning, resource management such memory management, disk management etc. also responsible for back up, recovery and disaster recovery.
• Resolving Application & User Issues.
• 24X7 PRODUCTION,USER SUPPORT & ON LINE SUPPORT

Environment: SQL Server 2005/2000, OLAP, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Windows 2003/Vista, IIS Administration