SUMMARY

• 7+ 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 Server 2012/2008 R 2/ 2008/2005/2000 in standalone and clustered servers.
• Experience of Upgrading and migration from earlier version of SQL Server to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 in different environments
• Good knowledge in creating SQL objects like Databases, tables, views, stored procedures, Indexes, Triggers, and User defined data types, cursors and Functions.
• Experience on working with Windows 2000/2003/2008/2008 R2 environment.
• Expertise in database Backup, Recovery and Disaster recovery procedures (Logshipping, Mirroring, AlwaysOn, clustering, Replication and SRDF).
• 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.
• Experience in implementing different types of Replication Models like Snapshot, Merge and transactional.
• Expert in designing disaster recovery model for corporate databases.
• Experience in Backing up, restoring the data base manually and also by scheduling the jobs andMaintenance Plans.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer and also Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS).
• Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
• Expertise in planning and implementing MS SQL Server Security and database Permissions.
• Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and also analyzing the execution plan and index management for better Query Optimization.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis.
• Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
• Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008.
• Experience in Data Migration from MS SQL server and from .
• Knowledge in Installing and configuring Cluster MYSQL Servers in Active/Passive environment.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• 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 creating data models and deploying to Report manager for developing Ad - hoc reports.
• Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
• Experience in Installation of SSRS 2005/2008/2012. Hands on generating different types of Reports using SQL Server Reporting Services (SSRS).
• Creating and configuring Service Broker, End Points, Queues, Message types and Remote Binding.
• Good experience with the entire phases of Software Development Life Cycle (SDLC) that include analysis, design, development, testing and deployment.
• Experience in creating STAR SCHEMA design and different data models.
• Hands on Experience in ETL (Extracting, Transforming and Loading) development using DTS and SSIS.
• Experienced in developing and deploying the cubes using SSAS.
• Defined and administered database standards, controls, procedures and documented the same.
• Provided after hours and 24/7 Database Maintenance and Production Support.
• In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL), PL/SQL.
• Experience in writing and debugging Stored Procedures and Triggers.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 2000/2005/2008/208 R2/2012, MYSQL, 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, Azure, 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

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Sr SQL Server DBA

Responsibilities:

• Installed and Configured SQL Server 2008, 2008 R2 and 2012 Servers.
• Managed 2005/2008/2008 R2/2012 SQL Servers.
• Upgraded SQL Server 2000/ using In-place and Side by Side Upgrade in Prod, PPE and lab
• Performed troubleshooting of database related issues during upgrading and migration process.
• Created DBA instances which run the oracle data base engine, experience with enabling and disablingRestricted sessions.
• Solved Issues related to Orphaned Users and Managed Logins, Users, Roles and User permissions.
• Worked with logs, switching online lock files adding, dropping and resizing online redo logs.
• Experience in creating and resizing tablespaces and data files, setting default tablespace, setting distributed recovery, setting database time zone, AWR, adjusting database links for use with DB instances in a VPC in AWS(Amazon Web Services).
• Worked with AWS S3 storage bucket.
• 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 using Clustering.
• Resolved issues in Mirroring setup.
• Azure File Service allows storing and access of data on the cloud using the SMB protocol.
• 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.
• By using Azure cloud we use to perform analytics and publishing of APIs on the cloud
• 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.
• 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.
• Performed Administrative functions which are Update Statistics, Re-indexing.
• Involved in solving production issues on web servers and biz talk servers administration.
• 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/7 on call support for all the SQL application on production server.

Environment: SQL Server 2000/ 2005/2008/2008 R2/2012, Power Shell, Windows 2000/2003/2008/2008 R2 Servers, Biz talk, Azure, T-SQL,MY SQL, DTS, SSIS and SSRS.

Confidential, Houston

Sr. SQL Server DBA

Responsibilities:

• Provided 24/7 System support to meet Service Level Agreement (SLA) Obligations.
• Transitioning 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, Row and Page level compression and Resource Governor.
• Responsible for Installation of SSL s.
• 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 Troubleshoot 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.
• Troubleshoot 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.
• 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 in raising Change Controls and using HP tool for user request maintenance.

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

Confidential, VA

Sr. SQL Server DBA/Developer

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.
• Implemented MBSA in all the environments to monitor the windows/SQL Server patches.
• 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, MBSA, Windows 2000/2003/2008 Servers, SQL Diag, BMC Blade Logic, TSM, DTS, T-SQL, SSIS, SSAS and SSRS.

Confidential, Charlotte, NC

SQL Server DBA

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 SSIS jobs (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.
• Installed SQL Server 2005/2008 on Active/Passive and Active/Active clusters as part of Upgrade.
• Worked on different DB replication techniques.
• Participated in Disaster Recovery.
• Participated in DR installation and trouble shooting (Mirroring, Logs hipping and High availability Cluster.
• Optimized the Disk space for performance using RAID and SAN.
• 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.
• 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

SQL Server DBA / Developer

Responsibilities:

• 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.
• 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 24/7 mission-critical/production environment.
• Maintained cluster servers to provide high availability.
• 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/ 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 2008/2005/2000 , T-SQL, Oracle, MS Access, Windows 2000/NT/XP, MS Reporting Services.