SUMMARY

• Expertise in Installation, Configuration, Capacity management, Troubleshooting Recovery and Maintenance of SQL Server - 2005/2008R2/2012.
• Experience in implementing high availability always on features and expertise in backup and recovery.
• Expertise in installation and maintenance of SQL Server 2012 standalone servers and has experience, noledge on Always on High availability feature of SQL Server 2012.
• Upgrading SQL Servers and Migrating databases from SQL 2008 R2 to SQL 2012 in Development and UAT environments.
• Expertise in configuration, maintenance and troubleshooting of data distribution Replication technologies.
• Experience in Configuring Disaster recovery and High availability solutions like Native SQL Log Shipping, Database Mirroring with witness server with High safety and High performance..
• Experience in database Planning, Scheduling daily, weekly, Monthly tasks in maintenance at backup and recovery point of time.
• Experience in configuring Security features
• Experience in configuring, monitoring SQL clustered and standalone instances using SQL mail, alerts, notifications and tools like SCOM and SQL Idera.
• Designing Instance level security
• Designing Backup strategy at enterprise level following SLA's, storage cost, Processes and less data loss.
• Database Refreshes from production to development, QA testing
• Upgrading SQL Server and Migrating databases
• Identifying poorly performing queries using query editor.
• Performance monitoring, working with Resource governor worked on indexing, views, indexed views sql query analyzer for identifying poorly performing queries.
• Experience in Designing, Constructing, and securing, troubleshooting, deploying SQL Server Integration Services(SSIS) packages, Strong development skills in T-SQL, Perl or Shell scripting languages
• Experience in configuring variables, environment variables, SQL server tables, parent package configuration. Setting SSIS package configuration and deployment utility, Moving .dtsx files.
• Data Extraction, Transforming and Loading (ETL) with teh halp of SSIS )
• Experience in Importing/Exporting Data from various data sources like Excel, MYSQL, DB2 and Flat file using DTS utility and SQL Server Integration Services. Involved in transformation of OLTP data.
• Designing, creating, and processing of cubes using SSAS.
• Experience in Installing Designing, configuring, developing and deploying SSRS services.
• Expertise in Installation, Configuration, Troubleshooting and Maintenance of SQL Server 2005/2008R2/2012 Active/Active Failover Clusters

TECHNICAL SKILLS

Operating Systems: Windows - 95/98/2000/ XP, NT, LINUX (gui)

Languages: C,Asp.Net, HTML,XML Sql,Tsql

Web Technologies: Php, Asp HTML, DHTML, XML, JavaScript

Web editors: Bluevoda coffecup html editor, Edit Plus, Dream Weaver

Packages: MS Office 2000/2003, Open Office

Data Base’s: My Sql, SQL Server 2008, SQL Server 2005, noledge in sql server 2012 T-SQL, SQLCMD, OSQL, VBScript, VB.Net, PowerShell, WMIPowerCLI SMO, PL/SQL, Linux Shell Script, c#.net

GUI Tools & Utilities: SQL Server Management Studio, BIDS, Visual Studio 2012, Enterprise ManagerQuery Analyzer, DTS designer, SQL Server Profiler, SQL Lite speed, SQL Compare, SQL Idera, VMware, VSphere, Hypervisor, Netapp, TSM, Symantec Net Backup, OEM,WINSCP,PUTTY,GPG.FTP,SFTP

Data Modelling Tools: ERWIN 4.0, MS Visio, SQL Server Diagrams

PROFESSIONAL EXPERIENCE

Confidential, New-York NY

SQL SERVER DBA

Environment: Microsoft hyper-v, Vspehre5 VMware infrastructure, SQL Server 2005/2008 R2/2012, Windows Server 2003/2008, 32 bit and 64 bit Servers,4 Node Active / Active, Active / Passive Clusters. SSIS, SSAS, SSRS, Remedy ticketing system, SCOM monitoring system, EMC networker Backup Tool, EMC Recover Point, EMC Recover Point Cluster Enabler

Responsibilities:

• Responsible for teh Initiation, planning, execution, control and completion of projects related to teh SQL Server database.
• Responsible for operational reliability, integrity and performance of all production databases
• Designed high availability and established disaster recovery execution plans with Native SQL Log Shipping replication and clustering, Database Mirroring with witness server.
• Installing, configuring, troubleshooting and maintenance of SQL Server 2008. Installed mission critical High availability Active/Active and Active/Passive clusters.
• Installation and maintenance of SQL Server 2012 standalone servers and has experience, noledge on Always on High availability feature of SQL Server 2012.
• Performed database, performance management and capacity tuning
• Applied latest SQL hot fix, patches and Services packs.
• Performed database multi instance, Side - by-Side installations and upgrades and ensuring teh integrity and security of confidential data. .
• Migrating databases from SQL 2008 R2 to SQL 2012 in development and UAT environments.
• Configuring, maintenance and troubleshooting of data distribution technologies like SQL Server 2005/2008 R2 Snapshot Replication, Transactional Replication with updatable subscriptions, Merge Replication and Peer - Peer replication.
• Configuring SQL Server 2012 Security features like SQL Auditing, Transparent data encryption, default schema for windows groups, user defined server roles.
• Analyzing and enforcing standards and compliance using Policy based management facets, conditions, database level and instance level audit in SQL 2008/2012. Capturing and tracking changes in user created tables using Change Data Capture (CDC).
• Designing Backup strategy at enterprise level following SLA's, storage cost, Processes and less data loss.
• Performed back-up and recovery of existing database. Working on Database Refreshes from production to development, QA testing and lab environments taking care of user/login permissions with scripts as it was before refreshes.
• Recovery of Database in case of crash/emergencies, data or log file corruptions, page corruptions using DBCC CHECKDB, page/transactional log restore, point-in-time restores, attach/ detach.
• Proactively monitored systems and made recommendations as well as reporting Performance and Uptime.
• Moving System and User databases, shrinking data and log files.
• Upgrading SQL Servers and Migrating databases from SQL 2005 to SQL 2008/SQL 2012.
• Performed trouble shooting of operational issues and implement solutions along with periodic maintenances, fixes and patches of databases .Experience in Troubleshooting database and instance issues using SQL error logs, windows event viewer application and system log, cluster log.
• Identifying poorly performing queries using query editor, SQL profiler, DTA, DMV's, detecting excessive me/O activity, table scans, CPU utilization on multiple instances, obtaining query plan statistics, using covering indexes, xml indexes, indexed views.
• Troubleshooting concurrency issues using teh SQL Server locks and latches, waits, deadlocks, setting isolation levels, evaluating transaction/sec performance counter, transaction query analysis and tuning.
• Designing, Constructing, and securing, troubleshooting, deploying SQL server Integration Services (SSIS) 2005/2008 packages, Setting checkpoints, breakpoints, incorporating transactions, package debugging and logging.
• Configuring SQL server tables, parent package configuration, Setting SSIS package configuration and deployment utility, Moving .dtsx files.
• Deploying and scheduling packages with proxy accounts and credentials.
• Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML).
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility and SSIS, Involved in transformation of OLTP data to teh Data Warehouse using DTS and SQL commands.
• Designing, creating, and processing of cubes using SSAS. Designing Aggregations and pre-calculating teh same in SSAS 2005/2008.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS) 2005/2008.
• Installing Designing, configuring, developing and deploying SSRS services.
• Developing drill down reports, chart reports, sub reports, conditional expressions and creating tabular and matrix reports.
• Experience in Understanding SSAS OLAP business requirements, Identifying Dimensions and attributes, designing measure groups and measures.
• Implementing, managing, and troubleshooting Virtual environments Microsoft hyper-v, Vspehre5.

Confidential, Atlanta, GA

SQL Server DBA

Environment: Microsoft hyper-v, Vspehre5 VMware infrastructure, SQL Server 2008 R2 Windows Server 2003/2008, 32 bit and 64 bit Servers,2 Node Active / Active, Active / Passive Clusters. SSIS, SSAS, SSRS, BMC Remedy ticketing Tool, OEM monitoring system, ORACLE 11G / IBM TIVOLI, Exchange / Outlook, Database Tools, Apache Tomcat.

Responsibilities:

• Working as part of a Team and responsible for teh initiation, planning, execution, control and completion of projects related to teh SQL Server database management of 3500 + servers and projects. Responsible for operational reliability, integrity and performance of all production databases
• Responsible for teh initiation, planning, execution, control and completion of projects related to teh SQL Server database management.
• Managing and coordinating teh team's work, prioritize work requests, defining timelines maintaining SLA and SLO’s.
• Creating indexes, monitoring and resolving Memory or disk space problems
• Production Database Administration/ System administration support and development activity for high end e-business critical applications.
• Setting up mirroring of databases on several stand by and active servers for high availability
• Setting up log shipping for reporting and DB Mirroring for High Availability of database
• Applied latest SQL hot fix and Services pack on active/active and active/passive clusters and multi instance standalone servers.
• Designing, Constructing, and securing, troubleshooting, deploying SQL server Integration Services (SSIS) 2005/2008 packages. Setting checkpoints and breakpoints, incorporating transactions, package debugging and logging.
• Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility and SSIS. Involved in transformation
• Installing Designing, configuring, developing and deploying SSRS services.
• Developing drill down reports, chart reports, sub reports, conditional expressions and creating tabular and matrix reports.
• Implementing, managing, and troubleshooting sql server 2008 on Virtual environments.
• Identifying new business areas, categorizing them and co-coordinating with teh Management team for all project deliverables.
• Represent teh weekly business meetings with customer and identifying processes and redefining, Re-engineering existing process and support methodologies.

Confidential, Oakland, CA

SQL SERVER DBA

Environment: Vspehre5 VMware infrastructure, SQL Server 2000/2005/2008 R2 Windows Server 2003/2008, 32 bit and 64 bit Servers,2 Node Active / Active, Active / Passive Clusters. SSIS, SSAS, SSRS, BMC Remedy ticketing tool, MySQL, Exchange / Outlook, Apache Tomcat.

Responsibilities:

• Responsible for teh initiation, planning, execution, control and completion of projects related to teh SQL Server database management.
• Implementing, managing, and troubleshooting SQL Server on Vspehre5 VMware infrastructure environments.
• Analysis of teh requirement and foreseeing environmental architecture changes and preparing teh technical and functional process documents. Supporting core clients' E-Commerce applications as a DBA.
• Managing and coordinating teh team's work, prioritize work requests, defining timelines.
• Production Database Administration/ System administration support and development activity for high end e-business critical applications.
• Installing SQL Server 2005/2008 R2 active-active clusters on windows 2003/windows 2008 R2.
• Applied latest SQL hot fix and Services pack on active/active and active/passive clusters and multi instance standalone servers.
• Setting up log shipping for reporting and DB Mirroring for HA of database.
• Designing, Constructing, and securing, troubleshooting, deploying SQL server Integration Services (SSIS) 2005/2008 packages.
• Configuring variables, environment variables, SQL server tables, parent package configuration. Setting SSIS package configuration and deployment utility, Moving .dtsx files.
• Deploying and scheduling packages with proxy accounts and credentials.
• Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, BCP, XML).
• Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility and SSIS. Involved in transformation of OLTP data to teh Data Warehouse using DTS and SQL commands.
• Represent teh weekly business meetings with customer and identifying processes and redefining, reengineering existing process and support methodologies.

Confidential, Oakland, CA

SQL SERVER DBA

Environment: SQL Server 2000/2005/2008 R2 Windows Server 2003/2008,32 bit and 64 bit Servers, 2 Node Active / Active, Active / Passive Clusters, Replication and mirroring SSIS, SSAS, SSRS, Service now ticketing system, Exchange MySQL Apache Tomcat.

Responsibilities:

• Responsible for teh initiation, planning, execution, troubleshooting control and completion of projects related to teh SQL Server database management.
• Managing and coordinating teh team's work, prioritize work requests, defining timelines.
• Production Database Administration/ System administration support and development activity for high end e - business critical applications.
• Installing SQL Server 2005/2008 R2 active active clusters on windows 2003/windows 2008 R2.
• Setting up log shipping for reporting and DB Mirroring for HA of database.
• Designing, Constructing, and securing, troubleshooting, deploying SQL server Integration Services (SSIS)
• 2005/2008 packages. Setting checkpoints and breakpoints, incorporating transactions, package debugging and logging.
• Configuring variables, environment variables, SQL server tables, parent package configuration. Setting SSIS-package configuration and deployment utility, Moving .dtsx files.
• Deploying and scheduling packages with proxy accounts and credentials.
• Data Extraction, Transforming and Loading (ETL) using SQL tools (SSIS, DTS, Bulk Insert, XML).
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility and SSIS. Involved in transformation of OLTP data to teh Data Warehouse using DTS and SQL commands.
• Designing, creating, and processing of cubes using SSAS.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS) 2005/2008.
• Installing Designing, configuring, developing and deploying SSRS services.
• Represent teh weekly business meetings with client and identifying processes and redefiningreengineering existing process and support methodologies. co-coordinating with teh offshore team for all project deliverables.
• Analysis of teh requirement and foreseeing environmental architecture changes and preparing teh technical and functional process documents

Confidential, Chicago IL

SQL SERVER DBA

Environment: SQL Server 2000/2005, server 2000/2005 log Shipping, Windows Server 2003/2005, Sql 32 bit and 64 bit Servers, 2 Node. SSIS, SSAS, SSRS, BMC Remedy ticketing system, MySQL, Exchange / Outlook, Scom, SQL idera, Sql Mail.

Responsibilities:

• Worked as a sql server DBA providing SQL Server support for mission critical applications.
• Installing SQL Server 2000/2005 active active clusters on windows 2003/windows 2008 R2.
• Applied latest SQL hot fix and Services pack on different sql servers and multi instance standalone servers.
• Setting up log shipping for reporting and DB Mirroring for HA of database.
• Performance tuning database queries and developing SSIS ETL processes.
• Configuring alerts using SQL idera and troubleshooting SQL server related issues.
• Configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server
• Planning, Scheduling daily, weekly, Monthly tasks in maintenance at backup and recovery point of time.
• Checking teh SQL Error logs for any errors, physical Disk space, Event Viewer, jobs for failed completion.
• Monitoring backups and log sizes, performance with PERFMON, Running Indexing, Run Integrity checks, Perform monthly security audits on all logins and users to SQL Server,
• Performed physical disk fragmentation on data drives.
• Creating maintenance backup jobs on teh sql-server
• Configuring sql-mail on sql server 2005 for Alerts