SUMMARY:

• Over 9.5 years of experience in Database Administration, System Analysis, Design, Development, Architecture and Support of MS SQL Server 2014, 2012,2008 R2, 2005 and 2000 in Production, QA, Development and Replication & Cluster Server Environments.
• Having solid experience as a Production Support DBA.
• Solid experience in installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2000, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.
• Extensively worked on more than Seven Terabytes of Database (VLDB).
• Upgrading from SQL server R2, 2012 and 2014.
• Good working noledge in Always - on and setting up the always on availability group.
• Good noledge on in-memory tables, managed backups and contained databases and column store indexes.
• Installed and maintained cluster servers like active-active and active-passive.
• Experience in Database Backup, Recovery and Disaster Recovery (DR) procedures. Server built from Scratch. Good exposer to System state recovery.
• Worked on different backup tools like Commvault, NetBackup, HPDP, DPM, Avamar.
• Data migration using SSIS and DTS services across different databases like Oracle, MS access & flat files.
• Participated in SAN Migration, Datacenter Migrations and OS Patching as per Change Management Schedules.
• Strong troubleshooting and organizational skill.
• Worked on TDE (Transparent data encryption) to encrypt data at rest and PCI Compliance.
• Implemented different types of Replication topologies like Snapshot, Merge and Transactional.
• Configured and maintained Replication from Oracle to SQL Server.
• Established Log shipping from production to DR servers.
• Configuring and Automating SQL MAIL notification.
• Transferring users and their related passwords to new server.
• Identifying & resolving blocking and deadlocks.
• Experience in Change Data Capture(CDC) and Change Tracking in SQL Server 2008
• Centralize all the databases and setup corresponding user security levels to make it possible for sharing the common data among different divisions.
• Migrating on-premises databases into SQL AZURE.
• Taking Bacpac and restoring the SQL AZURE databases.
• Setup data sync services on SQL Azure. Mange Security and provide access to the users in SQL Azure.
• Designing and documentation of SQL Server Strategies and plans.
• Automating the Database Maintenance tasks by creating Jobs and Alerts.
• Proficient in using Profilers for both performance and auditing purposes.
• Worked on Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Optimizing SQL Server Performance and Health in multi-terabytes environment.
• 24x7 support and trouble shoot production issues on high availability system.
• Configured RMAN backups on oracle 11g. Good working noledge on RAC (Full RAC and Half RAC)
• Migrating databases from Oracle to SQL from 11g to SQL 2008R2.
• Installing and maintaining Oracle database software and patches; testing and upgrading software releases; building databases; providing support; monitoring database instances and servers daily on, Linux and Windows based platforms; and providing database backup and recovery administration.
• Good noledge on memory allocation, architecture and managing the access to the oracle database.
• Supporting Oracle 11g Database servers Unix / Solaris/Windows systems
• Excellent Team Building, Project Management, Analytical, Interpersonal & Communication Skills.
• Good hands on experience with SSIS, SSAS and SSRS.
• Extensive experience in creating ETL packages using SQL Server 2008 Integration Services (SSIS) and scheduling packages, Fuzzy Look-up for cleaning bad data, validating data using SSIS
• Experience in creating Ad-hoc reports, data driven subscription by using Report Builder in SSRS.
• Experience in Report Design, Report Model, report configuration and deployment using SSRS.
• Hands on experience with SQL Server and T-SQL in constructing Tables, Triggers, Stored Procedures, User Defined Functions, Views, Indexes, Relational Database Models, Data Dictionaries and Data Integrity.
• Ability to learn and adapt to new technology and concepts quickly and create a systematic approach in working towards developing business solutions dat increase company’s efficiency, Productivity and profitability. Possess strong analytical, interpretation and problem solving skills.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, C#, C++, HTML, XML, VB script

RDBMS: MS SQL Server 200,2005,2008,2012 and 2014, MS-Access, Oracle 11g.

Front EndMS Visual Basic, ASP, ASP.Net

Version Control Tools: Rational Clear Case, Visual Source Safe

Operating Systems: Windows2012, Windows2008/200R2, Windows2000/2003, Advanced Server, Windows NT, UNIX, VMware, Hyper-V.

Other Tools: OLAP, IIS, SQL Server Enterprise Manager SSIS, SQL Sentry, Idera, Ignite, litespeed, Gloden gate, First choice.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

SQL Server DBA

Responsibilities:

• Installing new standalone and cluster SQL 2000, SQL 2005, SQL 2008R2, and SQL 2012 servers.
• Prepare and implement the DR Strategies.
• Worked on system state recovery like physical to Physical, Physical to Virtual.
• Worked on different backup tools like commvault, Symantec NetBackup, EMC Avamar.
• Worked on managed recovery programs.
• Build servers from scratch and recovered to point-in-time.
• Good hands on experience in Overall process flow of DR Strategies.
• Troubleshoot and fix the issues when performing the managed recovery program.
• Worked on RMAN backups and recovery.
• Installing and maintaining Oracle database software and patches; testing and upgrading software releases; building databases; providing support and providing database backup and recovery administration.

Environment: SQL Server 2012, 2008R2,2005,2000 Windows 2012, Windows 2008R2 Server, Windows 2008,2003,2000 Server, litespeed, Commvault, NetBackup, Avamar and SQL Safe.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installing new standalone and cluster SQL 2005, SQL 2008R2, SQL 2012 and SQL 2014 servers.
• Managing SQL servers, databases and storage management.
• Good working noledge in Always-on and setting the always availability group. Cluster configured on windows for always-on. Configured listener port for client application connectivity.
• Managed to migrate the databases from one datacenter to another datacenter.
• Created linked server to transfer data.
• Created master service key and implemented TDE.
• Worked PCI compliance environment.
• Good noledge on SQL 2014 features like in-memory tables, managed backups and contained databases and column store indexes.
• Extensively worked on Performance Tuning and T SQL Scripts.
• Extensively worked on Replication.
• Configured and worked on different DR strategies with Logshipping, Mirrioring, Alwayson and Clustering.
• Upgrading the existing servers with Service Packs, and applying Patches and Hotfixes.
• Working on the Production Servers using Firstchoice for Ticketing and Incident Management system and Change Management (CM).
• Hands on experience with SQL Server and T-SQL in constructing Tables, Triggers, Stored Procedures, User Defined Functions, Views, Indexes, Relational Database Models, Data Dictionaries and Data Integrity.
• Migrating on-premises databases into SQL AZURE with data tier application.
• Scheduling bacpac and restoring the SQL AZURE databases in same/other servers.
• Configured and maintained Geo replication.
• Setup data sync services in SQL AZURE to move On-premise data into Azure and Azure to On-premise. Mange security of SQL Azure.
• Worked with development team to setup database with Azure compliance.
• Implemented the Data Changes, Scripts and new Releases onto the Production servers.
• Participating in SAN Migrations, Datacenter Migrations and OS Patching as per Change Management Schedules.
• Experience in creating Ad-hoc reports, data driven subscription by using Report Builder in SSRS.
• Experience in Report Design, Report Model, report configuration and deployment using SSRS.
• Production to Test and Development DB Refreshes based on user requirements.
• Interacting with the users and troubleshooting the issues.
• Maintained more than 7 TB (VLDB) size databases.
• Executing and Scheduling the DTS and SSIS Packages based on user requests
• Worked on RMAN backups and recovery strategies.
• Good working noledge on RAC.
• Worked on Data guard. Proving access to the users on Oracle database.
• Installing and maintaining Oracle database software and patches; testing and upgrading software releases; building databases; providing support; monitoring database instances and servers daily on, Linux and Windows based platforms; and providing database backup and recovery administration.
• Providing 24/7 On-call Support.

Environment: SQL Server 2005, SQL Server 2008R2, SQL Server 2012, PL/SQL, Windows 2003, 2008R2 and 2012 servers, VB Script, Oracle, Excel, Visio, Access, ASP.Net, and VB 90, Enterprise Manager, Query Analyzer, DTS, SSIS, SSRS, Database Maintenance Plan Wizard, Foglight, Quest, HPDP, Syteline7, Citrix, VSS, Logshipping, Replication, Litespeed, CommVault, ControlM.

Confidential

Lead SQL Server DBA

Responsibilities:

• Installing and configuring new SQL 2005, 2008 R2 standalone and cluster servers.
• Managing SQL servers, databases and storage management.
• Installed and configured Microsoft Data Protection Manager.
• Migrated all the servers from SQL 2005 to SQL 2008 R2 servers.
• Working on the Tickets assigned to SQL database Queue related to application databases.
• Maintained more than 2TB size databases.
• In depth noledge in Performance Tuning and T SQL Scripts.
• DB Refreshes from Production to Test and Development based on user requirements.
• Implemented the Data changes, Scripts and New Releases on the production servers.
• Migrating SQL Servers from old servers to new servers.
• Hands on experience with SQL Server and T-SQL in constructing Tables, Triggers, Stored Procedures, User Defined Functions, Views, Indexes, Relational Database Models, Data Dictionaries and Data Integrity.
• Extensive experience in creating ETL packages using SQL Server 2008 Integration Services (SSIS) and scheduling packages, Fuzzy Look-up for cleaning bad data, validating data using SSIS
• Implemented and maintained database security.
• Configured and worked on different DR strategies with Logshipping, Mirrioring, Replication and Clustering.
• Configured log shipping between production and DR servers.
• Job Scheduling & Re-Scheduling on Production Databases.
• Created new logins, users and groups.
• Managed security issues in production, testing and development environments.
• Providing 24/7 On-call Support.

Environment: SQL Server 2008R2, SQL Server 2005, Windows 2003 Advanced Server, Windows 2008R2 Server, Microsoft DPM, Foglight, litespeed, Ariba, Heat, Spark, VB Script, Oracle, DTS, SSIS, Excel, Visio, Access, Voyager 3.0, ASP.Net, and VB 6.0, ERWIN.

Confidential

SQL Server DBA

Responsibilities:

• Managing SQL servers, databases and storage management.
• Installing and configuring new SQL 2000 and SQL 2005 standalone and cluster servers.
• Migrating SQL Servers from old servers to new servers.
• Migrating all the servers from SQL 2000 to SQL 2005 servers.
• Worked on Datacenter migrations.
• Implemented the Data changes, Scripts and New Releases on the production servers.
• Working on Remedy for Ticketing, Incident Management system and Change Management.
• Monitoring SQL production servers using idera for errors, disk spaces, jobs …. etc.
• DB Refreshes from Production to Test and Development based on user requirements.
• Job Scheduling & Re-Scheduling on Production Databases.
• Performance Monitoring on Production Databases.
• Good exposure on Performance Tuning and T SQL Scripts.
• Participated in migration and implementation planning.
• Involved in preparing documentation for migration and implementation.
• Resolved the trouble tickets as soon as possible.
• Interacting with the users and troubleshooting the problems.
• Maintained more than one TB size databases.
• Configured log shipping between production and DR servers.
• Configured and worked on different DR strategies with Logshipping, Replication and Clustering.
• Created new logins, users and groups.
• Implemented and maintained database security.
• Managed security issues in production, testing and development environments.
• Worked on FTP FileZilla for transferring large size databases and trans logs.
• Helped the development team in deploying and testing the application, which uses SQL Server as backend.
• Working on the Tickets assigned to SQL database Queue related to application databases.
• Worked and resolved the high priority tickets.
• Executing and Scheduling the DTS and SSIS Packages based on user requests
• Providing 24/7 On-call Support.

Environment: SQL Server 2008, SQL Server 2005 & 2000, PL/SQL, Windows 2000/2003 Advanced Server, VMware, Recovery Point, P2V, VB Script, Oracle, Excel, Visio, Access, ASP.Net, VB 6.0, ERWIN, FTP FileZilla, Idera, Enterprise Manager, Query Analyzer, DTS, SSIS, SSRS, Database Maintenance Plan Wizard, Foglight, Quest, Remedy, Citrix, VSS, Mirroring, Logshipping, Replication.

Confidential

SQL Server DBA

Responsibilities:

• Installing new SQL 2000, SQL 2005 servers.
• Upgrading SQL 2000 to SQL 2005 Servers.
• Migrating the SQL Servers from old server to new servers.
• Managed to migrate the databases from one datacenter to another datacenter.
• Upgrading the existing servers with Service Packs, and applying Patches and Hotfixes.
• Working on the Production Servers using Remedy for Ticketing and Incident Management system and Change Management (CM).
• Worked on the Change Requests as per Change Management Schedules.
• Worked on the Tickets assigned to SQL database Queue related to Application Databases.
• Performance Monitoring on Production Databases.
• Implemented the Data Changes, Scripts and new Releases onto the Production servers.
• Participating in SAN Migrations, Datacenter Migrations and OS Patching as per Change Management Schedules.
• Production to Test and Development DB Refreshes based on user requirements.
• Interacting with the users and troubleshooting the problems.
• Maintained more than one TB size databases.
• Helped Development Team in deploying and testing the application, which uses SQL Server as backend.
• Configured and worked on different DR strategies with Logshipping, Replication and Clustering.
• Created linked server to transfer data.
• Configured data mirroring on databases from one server to another server.
• Implemented log shipping between production and DR servers.
• Configured and worked on litespeed backups.
• Created new users, groups and logins.
• Managing Security issues in production, testing and development environments.
• Providing 24/7 On-call Support.

Environment: SQL Server 2005, SQL Server 2000, PL/SQL, Windows 2003 Advanced Server, Windows 2000 server, Litespeed, VB Script, Oracle, DTS, SSIS, Excel, and VB 6.0, ERWIN