SUMMARY

• 8+ years of IT experience in Database Administration, Design Development and Support of MSSQLServer2012/2008R 2/2008/2005/2000 in Production, Test, Development and ClusterServer Environments.
• Experience with software development life cycle (SDLC) and project methodologies.
• Managed a major Hardware Upgrade / Database Migration.
• Performed Capacity Planning, data modeling and Logical/Physical database Design.
• Experience in installing and configuring SQL Server 2008 R 2/2008/2005/2000 clusters in Active/Active and Active/Passive.
• Experience with SQL Server 2012, 2008 R2, 2008, 2005 installation, configuration, SSIS, SSRS and administration
• Migration experience from MSSQLServer2000 to MSSQLServer2005/2008, MSSQLServer2005 to MSSQLServer2008 & SQL Server .
• Experience in Database Backup, Recovery and Disaster Recovery procedures (Clustering, Log Shipping, Replication and Mirroring).
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Experience in usingSQLServerTools like DTS, Import/Export Wizard, SQLServerEnterprise Manager, SQL Server Management Studio, SQLProfiler andSQLQuery Analyzer.
• Experience in Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managingserverand clients.
• Good knowledge on Advanced features like MSDTC, and Full Text Indexing etc.
• Experience inSQLServer 2005/2008/2012 Online Database Indexing and Recovery.
• Expertize in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MSSQLServer2000/2005.
• Experience in creating SSIS packages and migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in using SSIS (SQLServerIntegration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Used IderaSQLsafe backup which provides a high - performance backup and recovery solution.
• High level plan for securing all the databases and better control on all SQL Servers.
• Involved in creation of linked servers using remote user account.
• Industry working experience in SQL Server and Oracle database management, maintenance, and troubleshooting.
• Worked on VMware machines.

TECHNICAL SKILLS

Databases: MS-SQL Server 2005/2008/ 2008 R2, 2012, MS Access 2003

Languages: C, C+, VB Script, Java Script, HTML, XML

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyzer, Export &Import, Precise i3 for SQL Server

Operating systems: Windows 2008\2003

Software Packages: MS Office 97/2000/XP,2003,2007, MS Outlook 2003,2007,Visio

PROFESSIONAL EXPERIENCE

Confidential, Torrance, CA

SQL Server DBA

Responsibilities:

• Installed and Configured SQL Server 2005, 2008 R2 and 2012 Servers.
• Upgraded SQL Server 2000/ /2008 R2 using In-place and Side by Side Upgrade in Prod, PPE and lab environments.
• Experience in upgrading databases from side by side.
• Extensive experience in applying service packs on SQL 2005, 2008, 2008 R2 and 2012 to the latest version.
• Experience in setting up high availability concept on clustering Active/Active and Active/Passive.
• Involved in setting up database level HA Mirroring, Replication and Log shipping.
• 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.
• Experience in handling multiple internal projects at a time and implemented them successfully.
• Worked on Critical Business requirements to execute SQL scripts on Production servers using emergency change request.
• Experience in performance tuning and Optimize frequently used SQL Queries, Indexes and Stored Procedures.
• Designed and Implemented Disaster Recovery Procedures Log Shipping, Mirroring and Replication as well as Backup and Restore Strategies.
• Solved backup, copy, restore job failure, space, network, latency Issues related to Log Shipping.
• Worked on space reports for all servers and request the space if it is required, to maintain below 70% of space occupied.
• Handled various issues related to setup and configuration of Database Mirroring and replication.
• Experience in decommissioning the old servers and databases which are not required using service-now tickets, also filling up the decommissioning request form.
• Worked on requesting Firewall ports to be open to connect SQL Server machines.
• 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 performancemonitor and performance analyzer.
• Worked on weekly maintenance jobs on Update Statistics, Re-indexing, Integrity checks and history cleanups.
• Involved in solving production issues on web servers and biz talk servers administration.
• Used SQL Profiler and Database engine tuning advisor for solving Deadlock, Performance related Issues.
• 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.

Environment: SQL Server 2008 R2 Enterprise Edition with Clustering, SQL 2012, 2005 and 2000, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB

Confidential, Los Angeles, CA

SQL Server DBA

Responsibilities:

• Installation of MS SQL Server 2005 and 2000 on production, Test and Development boxes.
• Worked in Active/ Active and Active/Passive Cluster environment as a High availability solution.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Involved in upgrades of both Side-by-Side and In-Place from SQL Server 2000 to SQL Server 2005.
• Successfully migrated near to 50 Databases from SQL 7.0 including many numbers of DTS packages to SSIS.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Setup and maintain of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Checking Database Health by using DBCC Commands.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for the Disaster Recovery plan
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.

Environment: MS SQL Server 2005/2000,T-SQL,SSIS,SSRS, Report Builder, Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server.