Summary

• Over 8 years of IT experience in Database Administration and System Administration in various domains like Finance, Insurance and Healthcare
• Expert in installation, configuration and maintenance of MS SQL Server2008 R2/2008/2005/2000 in stand alone and clustered servers.
• Highly experienced in investigating and applying necessary SQL Server database servicepacks,Hot fixes and Security Patches.
• Experience of Upgrading and migration from earlier version of SQL Server to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 in different environments
• Experience in installing SQL 2012.
• Good knowledge in creating SQL objects like Databases,tables, views, stored procedures, Indexes, Triggers, User defined data types, cursors and Functions.
• Experience in T-SQL programming skills.
• Extensive experience in Migration from Oracle to SQL.
• Experience in virtualization, latest virtual center has ESX 4.1 version
• Experience with Veritas Net backup
• Coordinated in Virutal center Upgrade.
• Experience with IIS Configuration for 2005 SSRS
• Experience on working with Windows 2000/2003/2008R2 environments.
• Handled up to 20+TB of data
• Expertise in database Backup, Recovery and Disaster recovery procedures (Logshipping, Mirroring, clustering, Replication and SRDF).
• Hands on experience in troubleshooting Database/data Issues
• Experience in Performance Tuning for slow/long running stored procedures and server level tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Worked extensively in clustered environment (active / passive) to further increase scalability and stability of business critical systems.
• In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL), PL/SQL.
• Experience in writing and debugging Stored Procedures and Triggers.
• Experience in implementing different types of Replication Models like Snapshot, Merge and transactional.
• Expert in designing disaster recovery model for corporate databases. For Ex: Redgate and Erwin
• Expert in utilizing different Monitoring tools including third party tools.
• Maintained Database Authentication Modes, Creation of Users, Configuring Permissions and assigning roles to users.
• Experience in extracting and transforming transactional information using DTS Import/Export wizard, BCP (Bulk Copy Program) DTS (Data Transformation Services) and SSIS Packages from SQL Server.
• Using Performance Monitor/Profiler to solve Blocking, Dead Locks/Long running queries.
• Experience in setting Database E-mail for notifications
• Experience in SQL Server Reporting Services (SSRS).
• Experience in creating data models and deploying to Report manager for developing Ad-hoc reports.
• Experience in working with remote teams
• Monitored the size of the transaction log. Managed databases on multiple disks using disk mirroring and RAID technology.
• Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
• Experience in Installation of SSRS 2005/2008 .Hands on generating different types of Reports using SQL Server Reporting Services (SSRS).
• Trouble shooting SSRS issues.
• Creating and configuring Service Broker, End Points, Queues, Message types and Remote Binding
• Experience in creating SSL Certificates.
• Good experience with the entire phases of Software Development Life Cycle (SDLC) that include analysis, design, development, testing and deployment.
• Experience working with TWS job scheduling.
• Experience in creating STAR SCHEMA design and different data models
• Experience in installation of Oracle 10G and Unix scripting
• Experience in using HP tool for queue monitoring
• Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and SSIS.
• Experienced in developing and deploying the cubes using SSAS.
• Worked closely with management, applications development staff, and users on database solutions to business problems.
• Defined and administered database standards, controls, procedures and documented the same
• Provided after hours and 24/7 Database Maintenance and Production Support.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

RDBMS

MS SQL SERVER 2000/2005/2008, Oracle, Ms Access 2000/2005.

Databases Tools

SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, DTS xChange, Quest Spotlight, RML Utility, MS Visio, SSRS, SSIS, SSAS,

Programming Languages:

SQL, TSQL, HTML, XML, PL/SQL.

Web Tools:

MS-Front Page, Internet Information Server(IIS),FTP

Operating Systems:

Windows 95/98/2000/2003/2008/XP/NT 4.0, Linux, MS-DOS.

Utility Tools:

MS Office, MS Project, HP Service Manager

Client: Confidential
Redmond, WA November 2011 - Current
SQL Server DBA

Confidential, is an American Public Multinational Corporation headquartered in Redmond, Washington, USA. Working as Tier 2 operational engineer supporting various property groups. Providing services to Enterprise service delivery team to improve the efficiency and automation of services.

Responsibilities:

• Installed and Configured SQL Server 2008 and 2008 R2 Servers.
• Managed 2005 SQL Servers
• Upgraded SQL Server 2000/2005 to 2008 using In-place and Side by Side Upgrade in Prod, PPE and lab environments.
• Performed troubleshooting of database related issues during upgrading and migration process.
• Solved Issues related to Orphaned Users and Managed Logins, Users, Roles and User permissions.
• Performance tune and Optimize frequently used SQL Queries, Indexes and Stored Procedures.
• Designed and Implemented Disaster Recovery Procedures Log Shipping, Mirroring as well as Backup and Restore Strategies.
• Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.
• Resolved issues in Mirroring setup.
• Solved backup, copy, restore job failure, space, network, latency Issues related to Log Shipping.
• Handled various issues related to setup and configuration of Database Mirroring, log shipping and replication.
• Implemented Transactional replication to Admin and Report databases and resolved the issues.
• Solved latency ,agent job failure, Synchronization issues related to Replication,
• Involved in scheduling Jobs, Alerts using SQL Server Agent as required.
• Created automation procedure for patching production servers.
• Involved in deploying changes to production and PPE environments.
• Involved in creating and renewal of SSL certificates.
• Developed and implemented backup and recovery strategies involving complete database backup/Restore, transaction log backup/restore.
• Create, test, and conduct performance tuning on SQL Server databases using Windows Performance Monitor and SQL Server Profiler and also used Microsoft tools perf insight and perf analyzer.
• Did perform Administrative functions which are Update Statistics, Re-indexing.
• Involved in solving production issues on web servers and biz talk servers administration.
• Have Knowledge on power shell scripts to automate few tasks on production servers.
• Used SQL Profiler and Database engine tuning advisor for solving Deadlock, Performance Issues.
• Experience in migrating data from Reporting app server to SQL Server.
• Experience in writing Stored Procedures and VIews
• Worked with developers to tune the SQL queries and improve the Performance.
• Solved Issues related to Synchronization of Data in Development, Test ,Smoke, Production

Environments

• Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server.
• Provided 24 x 7 on call support for all the SQL application on production server.

Confidential
Tampa, FL Nov \'10 - Nov\' 11
Sr. SQL Server DBA

PwC (Officially PricewaterhouseCoopers) is a global professional services firm headquartered in London, UK. It is the world\\\'s second largest Professional services firm. It is one of the \"Big Four\" accountancy firms. Pursuant to the terms of our contract with PWC, TCS provides a wide range of technology services to PWC . TATA Consultancy Services (TCS) provides their services to PWC at Onsite and Offshore. TCS has a well-established management structure in place to provide full and complete managerial oversight to all PWC projects and the information technology professionals providing services.

Responsibilities:

• We provide 24/7 System support to PwC, Pwc Data Centers meet Service Level Agreement (SLA) Obligations
• Transiting various Applications and Tasks to Offshore Locations
• Participated in various deployments in Production
• Responsible for Installation, Configuration and Administration of MS SQL Server 2005/2008/2008 R2 on windows 2003/2008 Servers.
• Responsible for Installation and configuration of SSRS 2005/2008
• Experience in understanding IIS configuration
• Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Transparent Data Encryption, Table and Page level compression and Resource Governor
• Responsible for Installation of SSL certificates
• Designed and executed SQL Server 2005 to SQL Server 2008 upgrade plan
• Successfully upgraded the databases from SQL Server 2005 to SQL Server 2008/2008 R2.
• Implemented SQL Server high availability solutions including clustering, replication, log shipping and SRDF
• Worked in Active/Passive and Active/Active cluster environment.
• Monitored and Trouble shooted jobs in Production, QA and Development environment.
• Responsible for installations, upgrades, patches and fixes.
• Participated in Data Center migration from Old Data Center to New Data Center. Migrated servers by using different methods like Virtual Migration, BMR migration and Physical Migration.
• Trouble shooted the issues which occurred during migration
• Worked on tickets assigned as part of 24/7 on call support.
• Implemented Transactional Replication for New Production Environments
• Configured log shipping from Production to DR servers and maintaining it.
• Experience in troubleshooting Logshipping issues
• Creating and Troubleshooting SSIS Packages in SQL Server 2005/2008/2008 R2.
• Worked on upgrading DTS to SSIS
• Export and Import of data from text files and Excel to SQL Server database using Bulk Copy Insert and BCP utility
• Setup profiler traces for slow running queries and used query execution plans to optimize the performance and improve I/O utilization.
• Participated in project team activities prior to release and contributed to documentation requirements consistent with methodology.
• Monitored the size of the transaction log. Managed databases on multiple disks using disk mirroring and RAID technology.
• Created VB Scripts as part of Automation of Auditing Production Servers after Maintenance.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements
• Tuning Queries and Database performance using tools Database Tuning Advisor, PSSDiag and SQL Profiler
• Monitored performance and current space utilization reports to management along with recommendations for any corrective action.
• Experience in working with VERITAS NetBackup
• Knowledge on SQL Azure
• Experience with TWS job scheduling
• Experience in creating and troubleshooting Service Broker issues
• Experience in raising Change Controls and using HP tool for user request maintenance

Environment: SQL Server 2000/2005/2008 with Clustering, Power Shell 1.0, Windows 2000/2003/2008 Servers, HP Service Manager, T-SQL,DTS, SSIS and SSRS.

Confidential
San Francisco, CA June\\\'09 - Oct\\\'10
Sr.SQL Server DBA

E-Trade Financial Corporation is a Financial Services company based on New York City, United States. It provides financial services and products to its customers. It is a holding company, the major business of which is anonline discount stock brokerage service for self-directed investors. Investors can buy and sell securities such asstocks, bonds,options, mutual funds, andexchange-traded fundsvia electronic trading platforms or by phone via E-Trade Mobile Pro. The company also offers banking and lending products such as checking and savings accounts, money marketaccounts,certificates of deposit, and credit cards. E-Trade is regulated and licensed byFINRA.

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2005/2008/ on windows 2003/2008 Servers.
• Automated Installation of SQL Server 2008 SP2, and SQL Server 2008 client tools (work stations) through BMC Blade logic tool.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008.
• Experience with side by side and in place Upgrade.
• Successfully patched the servers with appropriate hot fixes
• Experience in using high availability features i.e. Active/Active or Active/Passive cluster, logshipping, mirroring and replication.
• Experience in performance tuning of long running queries and stored procedures by using SQL Profiler, Performance monitor and DTA
• Monitoring and trouble shooting Cluster resources in all the environments.
• Monitoring and Troubleshooting jobs in Production, QA and Development environment.
• Automated Health Check process for database and auditing the servers using Power Shell 1.0.
• Implemented MBSA 2.1 in all the environments to monitor the windows/SQL Server patches.
• Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Transparent Data Encryption, Table and Page level compression and Resource Governor.
• Creating and Troubleshooting SSIS Packages in SQL Server 2005/2008.
• Upgrading DTS to SSIS
• Involved in working with SSAS
• Installed and configured litespeed on Dev, QA and Prod servers.
• Installed and configured Report Server on windows 2008 server.
• Tuning Queries and Database performance using tools Database Tuning Advisor, PSSDiag and RML Utilities.
• Monitoring and trouble shooting SQL Agent Jobs including backup and batch jobs.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping
• Worked in Active/Passive and Active/Active cluster environment.
• Installed SQL Server 2005/2008 on Active/Passive and Active/Active multi node clusters.
• Experience in Star Schema design and trouble shooting
• Experience in working with T-SQL and PL-SQL
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005/2008 with Clustering, Power Shell 1.0, MBSA 2.1, Windows 2000/2003/2008 Servers, SQL Diag, BMC Blade Logic, TSM, DTS, T-SQL, SSIS, SSAS and SSRS.

Confidential
San Francisco, CA Jan\\\' 08 - May\\\'09
SQL Server DBA

Confidential, is an American Clothing and accessories retailer based on SF, CA and founded in 1969.

Responsibilities:

• Responsible for Installation, Configuration and Complete Administration of MS SQL Server 2000/2005/2008 on windows 2000/2003/2008 Servers. Installation of SQL Server Service Packs & hot fixes.
• Successfully upgraded the databases from SQL Server 2000 to SQL Server 2005/2008.
• Monitoring and Troubleshooting jobs in Production, Preview and Development environment.
• Scheduling SSISjobs (SQL Agent), Converting DTS packages to SSIS packages using DTS xChange tool.
• Involved in Health Check process for database and monthly auditing of the servers.
• Implemented the new SQL Server 2008 concepts like Policy Based Management, Central management servers, Table and Page level compression and Resource Governor.
• Virtualization of SQL Server in Production environment.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005/2008, which includes in-place, side-by-side and stand alone migration.
• Implemented SQL Server high availability solutions including clustering, replication and log shipping
• Worked in Active/Passive and Active/Active cluster environment.
• Setting up daily and weekly backups directly to TSM (Tivoli Storage manager).
• Installed SQL Server 2005/2008 on Active/Passive and Active/Active clusters as part of Upgrade.
• Worked on different DB replication techniques.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Designed database standards as per HIPAA and PHI specifics.
• Participated in Disaster Recovery.
• Participated in DR installation and trouble shooting(Mirroring, Logs hipping and High availability Cluster
• Experience in T-SQL and PL-SQL
• Optimized the Disk space for performance using RAID and SAN.
• Worked on Performance Comparison between SQL Server 2000 and SQL Server 2005 using RML Utility tool as part of Pre-Upgrade.
• Handling the RFC`s and work orders assigned to me as part of daily responsibilities.
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required.
• Documented the security standards and roles depending on Development, UAT and Production environments.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• Managing security roles in SQL Suite.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005/2008 with Clustering, DTSxChange, MSAccess, VMware ESX, Windows 2000/2003/2008 Servers, Litespeed 5.0 , TSM, DTS, RML Utility, T-SQL, SSIS, SSAS and SSRS.

Confidential
Torrance, CA Oct\\\'07 to Dec\\\'08 SQL Server DBA

Customer Support Reporting System is a part Honda Dealership Network system that provides various dealership performance reports related customer satisfaction. Responsibilities include data model design, extracting, transformation and loading data into operational data source for creating web-based reports using Business Objects and DBA for SQL server and Analysis servers.

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, and store procedures to clean and validate the data to meet the company specifications.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve the problems.
• Created database objects like tables, stored procedures, views, Triggers, Rules, Defaults, User defined data types and functions in SQL Server 2005.
• Designing and Optimizing all the SSIS packages
• Installed and configured MS SQL Server 2005. Edited the server registration properties, Created Logins. Managed the object level permissions and security issues of the server.
• Created Backups Strategies for databases and automated the process.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database. Removed fragmentation from indexes.
• Provided support for Clustering environment, DTS packages and Transactional/Merge replication.
• Created Transactional replication, pull subscription and defined edition to transfer data from branch to head office and vice versa.
• Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship.
• Written stored procedures for automatic scripting to backup transaction logs, log file, maintain archive of objects and so on.
• Replicated SQL servers handling thousands of logins per day with 24/7 uptime to service clients.
• Involved in Management of clustered database servers.
• Ensured constraints and writing triggers to apply business rules. Performance Tuning, backing up and restoring user databases.
• Involved in Designing and Implementation of data warehousing solution which includes Building an OLAP database, creating data source.
• Extracted data from SQL Server for report, backup, testing purpose by using SSIS
• Created different user level groups and assigned appropriate permission level to the database. This made sure that only right person with enough authority would be able to see the information.
• Created distributed partitioned views, debugging / troubleshooting stored procedures, upgrading existing ones.

Environment: SQL Server 2005/2000, Oracle 9i/10g, MS Access, T-SQL, SSIS, SSRS, SSAS, Windows Server 2000/2003

Confidential
Hyderabad, India Aug\\\'-04 to Oct\\\'07
Jr. SQL Server DBA
Confidential, provides healthcare business process outsourcing and technology services worldwide. The company is headquartered in Hyderabad, India. iSpace Software Technologies, Ltd. operates as a subsidiary of DST Systems, Inc. ispace now it called as DST Global Solutions.

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Created SSIS packages to export data from Oracle to SQL Server Database.
• Wrote DTS ActiveX scripts that extract data from database tables and write the data to text files
• Configured product meta-data tables to support client data reporting needs.
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Supported clustering and replication for servers.
• Responsible for Tuning the Tuxedo/Application server to boost performance
• Generated database SQL scripts and deployed databases including installation and configuration
• Created Reports Using MS Reporting Services.
• Responsible for tier 2 support for more than 10 SQL Servers in a 24x7 mission-critical/production environment.
• Maintained cluster servers to provide high availability.
• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems
• Used ER/Studio to reverse engineer legacy database from Sybase to SQL Server.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA
• Migrated few objects from SQL Server 2000 to SQL Server 2005
• Provide 24 X 7 supports to all production, development, staging and clustered servers.
• Configured two Active/Passive Clustering setups for failover on production servers. This included installing windows cluster service and SQL 2000 on windows 2003 enterprise edition.

Environment: SQL Server 2005, SQL Server 2000, T-SQL, Oracle, MS Access, Windows 2000/NT/XP, MS Reporting Services, DB2, Microsoft Visual Source safe.