SUMMARY

• 9+ years of experience as a Microsoft SQL Server DBA in Production/UAT/QA/Development environments.
• Involved in SQL Server 2014, 2012, 2008R2,2008,2005,2000Installation, Configuration, Administering, Securing, and Maintenance of Client’s Production/UAT/QA/Development Servers.
• Good knowledge in SQL server cloud infrastructure - SQL Azure.
• Perform day to day Database Support (VLDB environment) and Maintenance tasks - Database Monitoring, Database Native Backups, Tivoli Backups, Maintaining Scheduled Jobs, Alert Notifications, Space Management, Resource Utilization and Responsible for Performing object Migration between all Production database servers.
• Involved in SQL server upgradations, migrations and virtualization projects.
• Identifying and resolving Blocking / Deadlocking issues for concurrent users by using Activity Monitor and Profiler (server side tracing).
• Involved in database migrations from MS Access and Oracle to SQL server.
• Solving space issues like Tempdb and Log file issues.
• Well versed wif SOX auditing and HIPAA standards.
• Successfully resolving SQL Server problems in conformance wif SLA.
• Good understanding of ITIL framework.
• Performing Database Consistency Check, Data Cleanup, Synchronization, Upgrade wif new Service packs, hot fixes and Migrated Servers from MS SQL Server 2000 to MS SQL Server 2005 and higher versions.
• Experience in Deploying and Executing SSIS packages.
• Has Working Experience of SQL Server Clustering.
• Collaborate wif Developers, Network Administrators, and System Administrators to implement secure reliable Database environments.
• Using SQL Profiler, Query Execution plans, Trace Flags, and Perfmon to aid Troubleshooting and Resolving Performance issues.
• Leaded the Offshore DBA Support Team to ensure 24x7 support for Production Databases and application issues.
• Responsible for the Production to Development, Test Database, QA Database Refreshes based on requirements.
• Created and Troubleshoot Transactional Replication, Merge Replication issues of existing Publications and Subscriptions to keep data in Synch.
• Implemented Mirroring, Log shipping to meet customer needs for production.
• Developed Secured environment to enforce end user permissions and restriction of sensitive Information.
• Having the ability to work in a fast paced environment, good team player and can work independently and halped the database Developers on technical issues.

TECHNICAL SKILLS

Database: MS SQL Server 2000,2005,2008,2008 R2,2012, 2014,MS-Access, Oracle 11g

Languages: T-SQL, PL/SQL

Tools: SQL Server Management Studio, Profiler, Database Tuning AdvisorPerfmon,Tivoli, MOM, SCOM, Monitor,Query Analyzer, SSMS, Power Shell,Spotlight,SQL Idera,Gloden gate, Foglight,DPM, Litespeed, Enterprise content management and data cap versions of IBM, Enterprise Manager, VERITAS Netbackup, PSS Diag, Filenet,TFS, CMS.

Platforms: Windows Server 2008/2003/2000, Windows XP/NT

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL Server DBA

Responsibilities:

• Installing SQL Servers 2014/2012 on windows 2012 core machines using power shell also installed SQL server 2008 R2, 2008 on windows machines.
• Provide requirements for changes and upgrades to the databases.
• Upgraded databases from SQL Server 2012toSQL server 2014.
• Involved in migrating MS access and Oracle databases to SQL server.
• Maintain, operate and upgrade as necessary, automated monitoring tools to monitor database performance.
• Identify and recommend DBMS software enhancements.
• Document - install, maintain and support database upgrades.
• Based on the business need created Transactional Replication on Different applications.
• Day to Day administration of SQL Servers on Standalone and Cluster Environments.
• Performing Health checks and Monitoring performance of the Production Servers.
• Resolving the Database I/O Consistency errors and Allocation errors.
• Successfully Recovered the Databases from Suspect/Emergency/Offline/Bypass Recovery states.
• Recovered the SQL Server Instances by using Rebuilding the Master where the disk failed.
• Responsible for Creation of the Rebuild index/Reorganize, Update Statistics Jobs for new servers.
• Handling of the database backup failures, fixing the issues and make sure the availability of daily backups.
• Configured and administered SQL server 2012 databases wif always on high availability feature.
• Providing the access to users based on the Requirement to the Production/UAT/QA/Development Servers wif Appropriate Approvals.
• Experience in Deploying and Execution of SSIS packages.
• Handling of the low Logical disk space issues, Tempdb issues and Log file issues.
• Applying the Hot fixes and patches based on the requirements for different stores wifin the maintenance window.
• Applying the Service packs and Cumulative Updates based on the Requirement to fix the issues.
• Database refreshments from Production to DEV/UAT/QA environments.

Environment: MS SQL Server 2012/2014, Windows 2008/2012 servers, Outlook Express, .NET, MS Access, SQL Monitor-Red Gate, OEM-Oracle Enterprise manager, Ticketing tool-Jeera, SSIS, SQL Diagnostic manager-IDERA, SAN, SAS, BIDS, Data tools.

Confidential

SQL Server DBA

Responsibilities:

• Database design review and gap analysis for multiple projects based on HMO requirements.
• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting the day to day developments of the work done.
• Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management, Creation of SSIS packages for data loading and applying service packs
• Develop and maintain all documentation for databases and database services administered or maintained.
• Involved in SQL server upgradations, migrations and virtualization projects.
• Initiate database processing, database processing recovery, manage database resource availability and execute database subsystem started tasks restarts.
• Provide requirements for changes and upgrades to the databases.
• Maintain, operate and upgrade as necessary, automated monitoring tools to monitor database performance.
• Identify and recommend DBMS software enhancements.
• Document - install, maintain and support database upgrades.
• Based on the business need created Transactional Replication on Different applications.
• Develop and make available standard database access routines for use by CHI staff as requested by CHI.
• Writing and Reviewing stored procedures, Functions, views and triggers.
• Day to Day administration of SQL Servers on Standalone and Cluster Environments.
• Performing Health checks and Monitoring performance of the Production Servers.
• Resolving the Database I/O Consistency errors and Allocation errors.
• Successfully Recovered the Databases from Suspect/Emergency/Offline/Bypass Recovery states.
• Recovered the SQL Server Instances by using Rebuilding the Master where the disk failed.
• Responsible for Creation of the Rebuild index/Reorganize, Update Statistics Jobs for new servers.
• Handling of the Tivoli database backup failures, fixing the issues and make sure the availability of daily backups either in the disk or TSM server using CMS.
• Providing the access to users based on the Requirement to the Production/UAT/QA/Development Servers wif Appropriate Approvals.
• Experience in Deploying and Execution of SSIS packages.
• Handling of the low Logical disk space issues, Tempdb issues and Log file issues.
• Applying the Hot fixes and patches based on the requirements for different stores wifin the maintenance window.
• Applying the Service packs and Cumulative Updates based on the Requirement to fix the issues.
• Database refreshments from Production to DEV/UAT/QA environments.
• Migrated Servers from SQL Server 2000 to SQL Server 2005 and based on the application team requests.
• Preparing the stores for Acquisition’s and Divestiture’s for the planned schedules.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2/2012, Windows 2000/2003/2008/2012 servers, Outlook Express, .NET, MS Access,Spotlight, BMC Remedy, Gloden gate, SSIS, SQL Diagnostic manager-IDERA, Veritas Netbackup.

Confidential, IL

SQL Server DBA

Responsibilities:

• Installed and configuredSQL Server 2005/2008R2on both cluster and stand-alone environment.
• Installed SQL Server 2008R2 In Cluster environment usingSlipstreamwif Cumulative update 3.
• Installed SQL SERVERService Packsto keep the SQL Server up to date.
• Experienceon DB Securityin creating logins, users, roles and permissions for the business people.
• Responsible for activitiestaking backup restore using VERITAS Netbackup, refreshing databasesas per requirements.
• Scheduled and createdMaintenance planson databases and also created automated jobs.
• Performed Database consistency checks wifDBCC,Defrag,Indextuning and monitored error logs
• Configured and managedlog shippingbetween production server and Secondary servers forhigh availabilitysolution.
• Performed theDR Drill (Cutover)onLog shipping database routing the application from DR Servers and testing the Application connectivity
• ConfiguredDatabase Mirroringwif high performance and high availability mode.
• Experience in implementing Failover Clustering support for SQLServer Active Passive Cluster configuration.
• ConfiguredSQL Server 2005 four Node Cluster (Active-Active)in virtual environment using VM Ware Workstation for testing.
• Upgraded SQL Server 2005 to SQL Server 2008/2008R2in windows server bit.
• Migrateddatabases fromSQL Server 2005toSQL Server 2008/2008R2databases.
• Experience inmigration and maintenanceof data using various utilitieslike DTS, SSIS, Import and Export, ATTACH/DETACH Data Migration tools.
• CreatedLinked Serversbetween SQL server 2005 and 2008/2008R2, Oracle servers.
• Involved in Moving System databases.
• Involved in SQL server upgradations, migrations and virtualization projects.
• Maintaining both Development and Test servers in sync wif Production server bydoing Database Refreshes.
• Involved inSQL Server Hardening.
• Troubleshoot for SQL Server performance related Issues in the servers usingDBCC commands, DMVs and Performance Counters.
• CreatedOperatorsand ConfiguredDatabase Mail
• Monitored the event logs and server logs fortroubleshootingand problem solving
• Upgraded the SQL Server 2005 to SQL Server 2008.
• UsedETL packagesto move logins and jobs from one server to another server.
• PerformedQuery optimizationandachievedPerformanceby tuning SQL queries using Profiler and Execution Plans.
• Implemented different types ofreplicationsTransactional, Snapshot and merge replications.
• Provided On-Call supportto Mission critical Environments and expertise wifDisasterRecoverymechanisms
• UsedData Flow task, Execute package task, Execute SQL Task, for each loop container in SSISfor transformation of the data.
• Implemented enterprise databases on enterprise Storage Solutions usingStorage area Networks (SAN)/Network Attached Storage (NAS),RAID levels.
• Responsible for SSIS, SSAS, SSRS package executions and availability.
• Provided support for 24x7 availability of database Services and ensure to meet the SLA.

Environment: MSSQL Server 2005/2008/2008 R2 64 bit, Enterprise, Windows serve 20 bit,Business Intelligence Development Studio - SSIS, SSRS, SSAS, Performance Monitor, Clustering,SQL Agent, VERITAS Netbackup,Vcenterconverter, Fog light, SQL Profiler,Database Tuning Advisor, SCOM,Platespin protect, .Net, VB Script,T- SQL,IIS.

Confidential, IL

SQL Server DBA

Responsibilities:

• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting the day to day developments of the work done.
• Day to Day administration of SQL Servers on Standalone and Cluster Environments.
• Implemented and maintained Log shipping to meet customer needs for production.
• Performing Health checks and Monitoring performance of the Production Servers.
• Resolving the Database I/O Consistency errors and Allocation errors.
• Successfully Recovered the Databases from Suspect/Emergency/Offline/Bypass Recovery states.
• Recovered the SQL Server Instances by using Rebuilding the Master where the disk failed.
• Responsible for Creation of the Rebuild index/Reorganize, Update Statistics Jobs for new servers.
• Handling of the Tivoli database backup failures, fixing the issues and make sure the availability of daily backups either in the disk or TSM server using CMS.
• Providing the access to users based on the Requirement to the Production/UAT/QA/Development Servers wif Appropriate Approvals.
• Experience in SQL server upgradations, migrations and virtualization projects.
• Experience in Deploying and Execution of SSIS packages.
• Handling of the low Logical disk space issues, Tempdb issues and Log file issues.
• Applying the Hot fixes and patches based on the requirements for different stores wifin themaintenance window.
• Applying the Service packs and Cumulative Updates based on the Requirement to fix the issues.
• Database refreshments from Production to DEV/UAT/QA environments.
• Migrated Servers from SQL Server 2000 to SQL Server 2005 for the stores based on the Schedule.
• Preparing the stores for Acquisition’s and Divestiture’s for the planned schedules.
• Creation of the Maintenance plans During Tivoli backup failures for taking the backups to disks.
• Working on work Orders (Planned Activities), Service Calls (Ad-hoc Requests), Incidents wifoutbreaching SLA.
• Providing the ON Call Support during the weekends and off duty hours of SQL Server DBA.
• Coordinate wif the Offshore DBA Support Team to ensure 24x7 supports for Production Database and application issues.
• Monitor SQL Server Services status, Application Log, Jobs, SQL Server Logs, Dead Locks/Blocking.

Environment: SQL Server 2000/2005 Enterprise 64bit on Windows Server 2003 Enterprise 64bit, Query Analyzer, Database Tuning Advisor, Clustering, VirtualizationBusiness Intelligence Development Studio (BIDS),Vcenterconverter, SSIS, SSRS, Transact - SQL, Litespeed, XML, .Net, ASP, Visual Studio, MS-Office, IIS 5.0.

Confidential

SQL Server DBA

Responsibilities:

• Day to Day administration of SQL Servers.
• Participated in the daily stand up SCRUM agile meetings as part of AGILE process for reporting the day to day developments of the work done.
• Performing Health checks and Monitoring performance of the Production Server.
• Creation of Users, Roles, and Managing Security by implementing TEMPeffective database Security practices.
• Reorganizing/Rebuilding the Indexes at regular intervals for better performance.
• Involved in Installation, Configuration of SQL Server 2005, and applied patches and service packs to keep the database at current patch level.
• Based on the business need created Transactional Replication on Different applications.
• Implemented stand by servers and Log Shipping.
• Configured Mirroring between Primary Server and Mirrored Server and experience in Troubleshooting Mirroring Problems.
• Backup and Restore using native backup and created Backup Jobs, Maintenance plans.
• Monitor SQL Server Services status, Application Log, Jobs, SQL Server Logs, Dead Locks/Blocking, and Backup verification (Daily/Weekly/Monthly).
• Monitoring of Disk space where physical database are stored.

Environment: MS SQL Server2000, 2005, Windows 2003/2000 Server, T-SQL

Confidential

SQL Server DBA\Developer

Responsibilities:

• Database design review and gap analysis for multiple projects.
• Writing stored procedures, Functions, views and triggers.
• Routine DBA activities: Backup and Data recovery, Data security, Data Migration, Performance Tuning, Data Integrity analysis, User Management, Creation of SSIS packages for data loading and applying service packs
• Work closely wif application developers and business users to design databases
• Design databases: logical and physical level.
• Participate in the definition, documentation and application of our Coding and Naming Standards.
• Provide support to developers/testers to resolve technical problems wif data and/or databases.
• Schedule and Deploy schema changes, data conversion, data fixes and packages throughout many different environments including Development, System Test, UAT and Production.

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003/2008 servers, Outlook Express, .NET, MS Access, SSIS, .NET, VB Scripting, Macros.

Confidential

SQL Server DBA\Developer

Responsibilities:

• Installed and configured SQL Server 2005 and 2008 in the production environment.
• Involved in database migration from SQL server 2000 to SQL server 2005 and 2008.
• Extracted data from Flat files into SQL server using BULK INSERT/BCP.
• Created SSIS packages to migrate existing data into new data structures.
• Successfully Implemented and deployed SSIS packages.
• Providing the backup evidence of Tivoli for SOX databases based on the requirement for every month.
• Configured and administered high availability solutions, Mirroring and Log shipping.
• Created new Transactional replication and addressed the Replication Issues to maintain high availability of the data between the servers.
• Created indexed view to optimize query performance by facilitating easy user interface implementation.
• Created linked server for load balancing and increasing the performance of the Database.
• Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures, Triggers, Rules and Defaults.
• Ran DBCC consistency checks, and fixed data corruption in user databases.

Environment: MS SQL Server 2000/2005/2008, Windows 2000/2003/2008 servers, Outlook Express, .NET, MS Access, SSIS.

Confidential

SQL Server DBA\Developer

Responsibilities:

• Actively involved wif the front end .net developers as a part of a team for gathering and analyzing the needs of User Requirement.
• Modified existing database to fit new business requirement by adding tables and relationships to support Customer Information System.
• Created efficient Stored Procedure and functions which implement necessary business logic to support the front end application.
• Optimized the query performance by removing unnecessary columns, redundant and inconsistent data. Query performance was improved by normalizing tables, establishing necessary joins and creating useful indexes wherever necessary.
• Worked on Client/Server tools such as SQL Server 2000 Enterprise Manager and Query Analyzer to administer SQL Server.
• Created Database Maintenance planner for the performance of SQL Server, which includes Database Integrity Checks, Update Database Statistics and Re-index the fragmented indexes.
• Created DTS packages to migrate data from various sources to the SQL Server 2000.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Optimized database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Environment: MSSQL Server 2000(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), Microsoft Amalga, ASP.Net, VB.Net, VB Script.

Confidential

System Admin Intern

Responsibilities:

• Responsible for executing PC setup and desktop image deployment for all new users.
• Involved in database maintenance as a trainee.
• Responded to employee needs in person or via email, phone, Lync, or remote desktop software to provide break/fix support for PC/laptop hardware, operating systems, applications, printers and video conference system.
• Used halpdesk management system to respond to user support requests
• Installed printer hardware and drivers as needed.
• Installed phone handsets.
• Resolved desk side issues and via remote desktop.
• Trained users as needed