SUMMARY:

• Patent pending for an encryption method involving databases. Experienced in Installation, Configuration, Capacity management, Troubleshooting, Recovery and Maintenance of SQL Server - 2005/2008R2/2012.
• Upgrading SQL Servers and Migrating databases from SQL 2008 R2 to SQL 2012 in Development and UAT environments.
• 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 implementing high availability always on features and expertise in backup and recovery.
• Experienced in installation and maintenance of SQL Server 2012 standalone servers and has experience, knowledge on Always on High availability feature of SQL Server 2012.
• 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 and Database level security 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 and fine tuning the stored procedure associated with it.
• Experienced in Performance monitoring, working with Resource governor.
• Worked on indexing, views, indexed views sql query analyzer for identifying poorly performing queries.
• Query tuning depending on the issue.
• Reading query execution plans and making necessary changes accordingly.
• Experience in Designing, Constructing, and securing, troubleshooting, issues related to SQL Server Integration Services(SSIS) packages.
• Extensive knowledge in and skills of T-SQL, PHP-MYSQL or Shell scripting languages.
• Experience in configuring variables, environment variables, SQL server tables, parent package configuration. Setting SSIS package configuration and deployment utility.
• Data Extraction, Transforming and Loading (ETL) with the help of SSIS).
• Experience in migration 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.
• Experience in migrating from oracle to Sql. worked on structure migration and data migration.
• Experience in Installing configuring, developing and deploying SSRS services.
• Expertise in Installation, Configuration, Troubleshooting and Maintenance of SQL Server 2005/2008R2/2012 Active/Active Fail over Clusters, also worked on implementation of updates and security patches over nodes on 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, CSS, AJAX

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

Micro-Controllers: 8051, 8052, knowledge of hardware components

Micro-Processors: 8086,8085, Coding the Microprocessors

Packages: MS Office 2000/2003, Open Office

Data Base’s: My Sql, SQL Server 2008, SQL Server 2005, knowledge in sql server 2012 T-SQL, SQLCMD, OSQL, VBScript, VB.Net, PowerShell, WMISMO, 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, FTP,SFTP

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

PROFESSIONAL EXPERIENCE:

Confidential, Oakland, CA

SQL SERVER DBA

Environment: VMware infrastructure, AZURE cloud solutions, SQL Server 2000/2005/2008 R2,2012, Windows Server 2003/2008, 32 bit and 64 bit Servers,2 Node Active / Active, Active / Passive Clusters. SSIS, SSAS, SSRS, Service now and HPQC ticketing system, OEM monitoring system, MySQL, Oracle 10G, Exchange / Outlook, Linux distributions, Tools, PVCS, CVS, Apache Tomcat TFS, IIS.SVN repository

Responsibilities & Roles:

• Responsible for the initiation, planning, execution, control and completion of projects related to the SQL Server database management.
• Managing and coordinating the team's work, prioritize work requests, defining time - lines.
• Production Database Administration/ System administration support.
• Assisting developers and business analysts in development activity for high end e-business critical applications.
• Installing SQL Server 2012/2008 R2 active-active clusters on windows 2003/windows 2008.
• 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.
• Trouble shooting daily requests of lagging of queries and performance issues in production.
• Working with teams across different applications and analyzing issues related to queries and providing recommendations and solutions related to performance.
• Designing, Constructing, and securing, troubleshooting, deploying SQL server Integration Services (SSIS) 2008 packages.
• Refreshing databases from production to Dev and testing environments.
• Worked in database design for an internal messaging system involving maximum encryption.
• Data Extraction, Transforming and Loading (ETL) between Homogeneous 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 the Data Warehouse using DTS and SQL commands..
• Assisted developers in queries Developing drill down reports, chart reports, sub reports, conditional expressions and creating tabular and matrix reports.
• Writing Stored Procedures, Functions
• Understanding SSAS OLAP business requirements, Identifying Dimensions and attributes, designing measure groups and measures.
• Represent the weekly business meetings with customer and identifying processes and redefining, re-engineering existing process and support methodologies.
• Identifying new business areas, categorizing them and co-coordinating with the offshore team for all project deliverables.
• Analysis of the requirement and foreseeing environmental architecture changes and preparing the technical and functional process documents. Supporting core clients' E-Commerce applications as a DBA.
• System administration and Power-shell scripting.
• Implementing, managing, and troubleshooting on Virtual environments.
• Represent the weekly business meetings with customer and identifying processes and redefiningreengineering existing process and support methodologies.
• Identifying new business areas, categorizing them and co-coordinating with the offshore team for all project deliverables.
• Analysis of the requirement and foreseeing environmental architecture changes and preparing the technical and functional process documents. Supporting core clients' e-commerce applications as a DBA.
• Deploying, checking in and checking out the SQL scripts using version control TFS.
• System administration and shell scripting.
• Implementing, managing, and troubleshooting Virtual environments.
• Creating maintenance backup jobs on the sql-server.

Confidential, Harrisburg PA

SQL SERVER DBA

Environment: SQL Server 2001,2005/2008 R2/2012, Windows Server 2003/2008, 32 bit and 64 bit Servers,4 Node Active / Active, Active / Passive Clusters. SSIS, SSAS, SSRS, HPQC system, SCOM monitoring system, EMC networker Backup Tool, EMC Recover Point, EMC Recover Point Cluster Enabler, TFS, UNIX

Responsibilities:

• Responsible for the Maintenance, Control, Planning, of projects related to SQL server database administration. Assisting technical developers and maintain projects related to sql server development. Of sql server running on versions of 2005, 2008 and 2012 worked in the designing development implementation testing of a disaster recovery solution site for a newly established high priority project.
• Implemented log - shipping on various disaster recovery solutions.
• Involved in troubleshooting performance issues and latency issues while designing and implementation of DR.
• Worked extensively with Reporting teams on and finetuning existing stored procs and writing stored procedures and functions.
• Applied latest SQL hot fix and Services pack on active/active and active/passive clusters and multi instance standalone servers.
• Worked with application teams in re-engineering the whole database while moving from an old application to a new application.
• Migrated structures and data from oracle to sql server-2008, and 2001 to 2008
• Designed reports from excel to sql server
• 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 the Data Warehouse using DTS and SQL commands.
• Performed database capacity, performance management and tuning.
• Performed database installations and updates ensuring the integrity and security of confidential data. Applied latest SQL hot fix and Services pack.
• Implemented performance monitoring and benchmarking by deploying sql server scripts and running them through jobs and by creating monthly, and weekly reports continuously.
• Assisted teams in implementing encryption technologies and methods. worked with teams in implementing cross platform technologies like PHP-SQL server systems
• Applied latest SQL hot fix and Services pack on active/active and active/passive clusters and multi instance standalone servers.
• Extensively worked on indexing depending on the benefits by running performance scripts and reading sql-server query plans.
• Worked on issues with performance involving memory, network and operating system (win server 2005). designed and implemented Backup and Recovery plan schedule 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.
• Represent the weekly business meetings with customer and identifying processes and redefiningreengineering existing process and support methodologies.
• Identifying new business areas, categorizing them and co-coordinating with the offshore team for all project deliverables.
• Analysis of the requirement and foreseeing environmental architecture changes and preparing the technical and functional process documents. Supporting core clients' e-commerce applications as a DBA.
• Deploying, checking in and checking out the SQL scripts using SVN.
• System administration and shell scripting.
• Implementing, managing, and troubleshooting Virtual environments.
• Performed physical disk fragmentation on data drives.
• Creating maintenance backup jobs on the sql-server

SQL Server DBA,

Environment: 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, TFS, UNIX

Responsibilities:

• Responsible for the Initiation, planning, execution, control and completion of projects related to the SQL Server database management of 100+ servers and projects. 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.
• Installing, configuring, troubleshooting and maintenance of SQL Server 2008.
• Installation and maintenance of SQL Server 2008, 2012 standalone servers and has experience, knowledge on Always on High availability feature of SQL Server 2012.
• Performed database capacity, performance management and tuning.
• Performed database installations and upgrades and ensuring the integrity and security of confidential data. Applied latest SQL hot fix and Services pack.
• Migrating databases from SQL 2008 R2 to SQL 2012 in development and UAT environments.
• Configuring Disaster recovery and High availability solutions like Database Mirroring with witness server, High safety and High performance.
• Configuring SQL Server 2012 Security features like SQL Auditing, 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.
• 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 I/O activity, table scans, CPU utilization on multiple instances, obtaining query plan statistics, using covering indexes, xml indexes, indexed views.
• Troubleshooting concurrency issues using the SQL Server locks and latches, waits, deadlocks, setting isolation levels, evaluating transaction/sec performance counter, transaction query analysis and tuning.
• 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).
• 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 the Data Warehouse using DTS and SQL commands.
• 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 the weekly business meetings with customer and identifying processes and redefining, reengineering existing process and support methodologies.
• Analysis of the requirement and foreseeing environmental architecture changes and preparing the technical and functional process documents. Supporting core clients' e-commerce applications as a DBA.
• Deploying, checking in and checking out the SQL scripts.
• Implementing, managing, and troubleshooting Virtual environments
• Represent the weekly business meetings with customer and identifying processes and redefiningreengineering existing process and support methodologies.
• Identifying new business areas, categorizing them and co-coordinating with the offshore team for all project deliverables.
• Analysis of the requirement and foreseeing environmental architecture changes and preparing the technical and functional process documents. Supporting core clients' e-commerce applications as a DBA.
• Deploying, checking in and checking out the SQL scripts using version control TFS.
• System administration and shell scripting.
• Implementing, managing, and troubleshooting Virtual environments.
• Performed physical disk fragmentation on data drives.
• Creating maintenance backup jobs on the sql-server

Confidential, Chicago IL

SQL SERVER DBA (Backup and Recovery Team)

Environment: SQL Server 2000/2005/ Windows Server 2003/2005, Sql server 2000/2005 log Shipping 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.
• Have extensively worked in Database Refreshes from production to QA, development, testing and lab
• 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 the 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 Represent the weekly business meetings with customer and identifying processes and redefiningreengineering existing process and support methodologies.
• Identifying new business areas, categorizing them and co - coordinating with the offshore team for all project deliverables.
• Analysis of the requirement and foreseeing environmental architecture changes and preparing the technical and functional process documents. Supporting core clients' e-commerce applications as a DBA.
• Deploying, checking in and checking out the SQL scripts using version control TFS.
• System administration and shell scripting.
• Implementing, managing, and troubleshooting Virtual environments.
• Performed physical disk fragmentation on data drives.
• Creating maintenance backup jobs on the sql-server

Environment: s, Automated User permissions restore process for SQL 2000/2005.

Confidential, New-York NY

SQL SERVER DBA

Environment: 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, SHARE ticketing system, OEM monitoring system, ORACLE 11G /RHEL /OEL linux. ASM, Hibernate, MySQL, IBM TIVOLI, Exchange / Outlook, Linux distributions, DB2 Database Tools, Apache Tomcat.

Responsibilities:

• Working as part of a Team and responsible for the initiation, planning, execution, control and completion of projects related to the SQL Server database management of 3500 + servers and projects. Responsible for operational reliability, integrity and performance of all production databases
• Responsible for the initiation, planning, execution, control and completion of projects related to the SQL Server database management.
• Managing and coordinating the 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.
• Implementing, managing, and troubleshooting sql server 2008 on Virtual environments.
• Identifying new business areas, categorizing them and co-coordinating with the Management team for all project deliverables.
• Represent the weekly business meetings with customer and identifying processes and redefiningreengineering existing process and support methodologies.
• Represent the weekly business meetings with customer and identifying processes and redefiningreengineering existing process and support methodologies.
• Analysis of the requirement and foreseeing environmental architecture changes and preparing the technical and functional process documents. Supporting core clients' e-commerce applications as a DBA.
• Deploying, checking in and checking out the SQL scripts using version control TFS.
• System administration and shell scripting.
• Implementing, managing, and troubleshooting Virtual environments.
• Performed physical disk fragmentation on data drives.
• Creating maintenance backup jobs on the sql-server