OBJECTIVE:

To be a Senior SQL Server DBA / Software Engineer to utilize my strong technical expertise, project management and business knowledge. I am aspiring for a Technical Role that leads to a Managerial Role.

PROFESSIONAL SUMMARY:

• Over 15 years of experience in MS SQL Server 2000/2005/2008 R2/2012 and Windows Server technologies
• With working knowledge with Hadoop Big Data
• With working knowledge with Confidential
• 5 Years - Expert in High availability / Contingency solutions - Always On, Clustering, Replication, Database Mirroring and Log Shipping
• 5 Years - Expert in Handling Large Data Warehouse Databases with Replication Management
• 8 Years - Expert in Security Management and Auditing the Databases
• 8 Years - Expert in Performance Tuning, Query Optimization, Performance Monitor, SQL Profiler.
• 8 Years - Expert in Handling Large Database Backup and Restore
• 5 Years - Expert in Handling Database Disaster Recovery
• 8 Years - Expert in Troubleshooting Database Issues on Deadlocks and Blockings
• 5 Years - Expert in Handling SQL Server Downtime in Order to Have in Online within Minutes
• 5 Years - Expert in Detecting and Troubleshooting SQL Server related CPU, Memory, I/O, Disk Space and other Resource Contention.
• 5 Years - Expert in Knowledge of How Indexes, Index management, Integrity checks, Configuration, Patching.
• 5 Years - Expert in Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, System Sprocs)
• 5 Years - Expert in Knowledge of Windows Server, Security delegation, SPNs, Storage Components.
• 8 Years - Expert on MS SQL Server Administration and Design
• 8 Years - Experienced in Systems / Database Analysis and Design and Modeling
• 8 Years - Strong coding skills in T-SQL, triggers, views, functions, and stored procedures
• 5 Years - Experienced in Data Warehouse Design
• 5 Years - Experienced in Development of DTS and SSIS / ETL Packages
• 3 Years - Experienced in Development, Design and Maintenance of SAS Cube
• 7 Years - Expert in business analysis and creating reports
• 2 Years - Expert in SQL Azure Administration on Cloud Computing
• 5 Years - Experienced in Oracle DBA for Database Administration
• 5 Years - Experienced in Oracle DBA using SQL Plus Tool
• 5 Years - Experienced in Oracle PLS-SQL, Stored Procedure Programing for Oracle 9i and Oracle RAC 10g
• 5 Years - Expert in Oracle Reports Development with Business Objects for Oracle 9i and Oracle RAC 10g
• 7 Years - Expert at Application Development and Software Engineering
• 5 Years - Expert on C#.Net Programming for Win Forms and ASP.Net
• 5 Years - Expert on Ajax, Silverlight, CSS, WCF, MVC, XML and JavaScript Programming
• Excellent communication skills with management, developers, and users
• Strong project management skills and deadline oriented
• Expert in Events, Incident, Problem and Change Management
• Expert in Infrastructure Tools - Cosima, Remedy, Tivoli and SQL MOM
• Experienced with SharePoint Application
• Experienced with Biztalk Application

TECHNICAL KNOWLEDGE:

• Software development life cycle (SDLC) methodology
• SQL Server 2000/2005/2008 R2/2012 Enterprise
• Profiler, Dashboard, DTA, DMV
• DTS and SSIS
• SSRS and SSAS
• Snap Manager, Lite Speed
• Windows 2000/2003/2008
• SQL Server Power Shell Programming
• Toad, PL-SQL Developer Tool
• Active Directory and VB Script
• SharePoint 2003/2007/2010
• IIS 6, IIS 7 with .NET Framework
• SCOM, VMWare, and SAN
• MS Project and MS Office
• C#.Net Win Forms and Asp.Net, VB 6.0
• Visual FoxPro 4.0
• Business Objects and Crystal Reports 10.0
• Oracle 10g and 11g, Sybase
• Unix and Linux Programming
• MVC, WPF, HTML5, CSS3

EXPERIENCE:

Confidential

SQL Azure Developer, Architect

Responsibilities:

• Confidential Microsoft Partner Teamed up with Adaptasoft to work on CyberPay Online v3 a completely new application with single database payroll & HR with integrated time keeping that is hosted on Microsoft Azure Cloud. CyberpayOnline caters cloud based Payroll Services for 300 companies to date.
• Upgraded Production Server from Azure V11 to the latest version Azure V12.
• Assessed, Tested and Migrated 300 Databases from Web and Business Edition to the new Basic, Standard and Premium Tiers.
• Managed 300 Azure Production Databases for CyberPayOnline clients 24/7
• Database, Stored Procedure and Index Optimization
• Managed Cloud User Access to SQL Databases
• Assisted on VPN and Firewall configuration for access management.
• Troubleshooting databases performance issues, provided fixes and RCA as well
• Installed SQL Azure Data Sync to Migrate Azure Production Databases from Azure V11 to Azure V12 with no downtime.
• Managed Local SQL 2014 On Premise SQL Databases
• Enhanced .Net CyberPayOnline V3 .Net Application

Confidential, Florida

SQL BI/ETL Developer / Sr. SQL Applications DBA

Responsibilities:

• Confidential has been delivering memorable experiences through vacation ownership for more than 30 years. Through a strong platform of resort network growth and product flexibility, today more than 160,000 owners call our resorts home.
• IT Team is working on application and data migration from SQL 2005 to SQL 2012 and from a 3rd party application to .Net using continues integration approach. My role is a SQL BI Developer to develop SSIS packages to migrate data from SQL 2005 to SQL 2012 as per the original business logic to a whole new enterprise system. I also worked as Applications DBA for maintaining the database, script deployment and planned for using Red Gate Tools for Production deployment.
• MS VISUAL STUDIO /TFS / SQL SERVER / SSIS /SAS / SSRS
• Planned and Designed scalability of SQL server environment to fit organization structure and business requirement.
• Performed Installation, Migration and Continuous Integration from SQL Server 2005 to SQL Server 2012 and SQL Server 2014
• Performed installation for SSIS, SSRS, SAS.
• Developed and enhanced SSIS packages and SSRS reports.
• Review and implement SQL patch to production for in - house application.
• Maintained Visual Studio 2012 Database Project and TFS.

Confidential, Oak Brook, Chicago

Sr. SQL Server Applications DBA / SQL Azure Specialist

Responsibilities:

• Migrated SQL 2014 Databases on Cloud using SQL Server Azure
• Managed Cloud User Access to SQL Databases
• Assisted on VPN and Firewall configuration for access management.
• Stored procedure tuning on SQL Azure.
• Troubleshooting databases performance issues, provided fixes and RCA as well
• Performed SQL Data Sync to Replicate Data from Source to Hub and to Reference Databases
• Installed SQL Azure Data Sync client On Premise Database in order to communicate with Azure Database on cloud.
• Managed Local SQL 2014 Server Databases.
• Enhanced .Net Mobile and Tablet Applications.

Confidential, Houston, TX

Senior SQL Server DBA

Responsibilities:

• Senior DBA's delegate and distribute tasks to Operations DBA.
• Implemented Sql Server 2005, Sql Server 2008, Sql Server 2008 R2, Sql Server 2012. SQL SERVER / SSIS /SAS / SSRS
• Planned and Designed scalability of SQL server environment to fit organization structure and business requirement.
• Performed Database Analysis and Design and Modeling
• Performed upgrade and installation for SQL Server 2008, 2008 R2, 2012.
• Performed installation for SSIS, SSRS, SAS.
• Created and modified SSRS reports and SSIS package for IT administration.
• Installed and Configured Monitoring and Management SQL Server Clustering and Implemented service patches.
• Review and implement SQL patch to production for in - house application.
• Assisted activities in server group, such as virtualization.
• SQL Server Login and Access Administration.
• Backup and Restore Database Operations for Medium 100GB to 100TB Databases.
• Database Mail and Operators Development.
• Repaired, Recovered, Database Synchronization for Disaster Recovery.
• Created High Availability Solution with Database Mirroring, Log Shipping, Replication and Clustering.
• Provided Consulting for Database Performance Tuning and also used tools such as Data Tuning Advisor and SQL Best Practice Analyzer.
• Managed Databases using Maintenance Plan, DBCC, Backup (Full, Differential, Log), Automated Backup to Tape.
• Monitored SQL server performance and traced for potential performance issues.
• Performed SQL server trouble shooting for immediately issue, such as deadlocks.
• Migrated SQL Databases on Cloud using SQL Server Azure
• Managed Cloud User Access to SQL Databases
• Assisted on VPN and Firewall configuration for access management.
• Stored procedure tuning on SQL Azure.
• Troubleshooting databases performance issues, provided fixes and RCA as well
• Performed SQL Data Sync to Replicate Data from Source to Hub and to Reference Databases
• Programmed and enhanced SQL objects, including Stored Procedures, Functions, Indexes, Triggers.
• Implemented disaster recovery strategy and configure relative job on DR.
• Created and monitored SQL agent jobs.
• Powershell Programming.
• Communicates very well with Application Developers since I have relevant experience on Software Engineering and Development of Web Site and Local Applications.
• Supported and implemented DR and solution with database clustering, mirror, log shipping and replication.
• Supported and implemented, and maintain SQL server security setting, including Database engineer, SSRS, SSAS security.
• Assistant other day to day admin task in server group, and have ability to admin SAN and SnapManager.
• Install, configure, and admin SharePoint server and Team Foundation server.
• Provided consultation on management between server group and development group to ensure any database related requirements were met and the project plan reflected changes to scope and cost
• Participated enterprise - level software installation and configuration for SharePoint.
• Provide technical support for vendor applications, including version upgrade, server migration.
• Provided training and assistance for database developers and users on daily basis
• Document SQL server and relative information for future references.
• Assisted activities in development group, such as application consolation, testing
• Delegates tasks to Junior Operations DBA s.
• Coordinates with Wintel, Storage and Network Team.
• Incident, Events (SQL Monitoring using SQL MOM and Tivoli), Problem and Change Management.

Confidential

Applications SQL Server DBA/ETL Developer / Architect

Responsibilities:

• I also give consultation with regards SQL server stored procedure programming and performance tuning. This also includes consultation on how to create optimized Asp.Net and windows forms applications with SQL Server 2005 SSIS and Reporting Services.
• I specialized Replication for this project on a very large data warehouse environment.
• Implementation of Sql Server 2005, Installation, Configuration, DTA, SSIS, Reporting Services, Replication, Mirroring, Jobs, Performance TuningMaintenance Plans, T - SQL, XML, Stored Procedures SQL SERVER / SSIS /SAS / SSRS
• Planned and Designed scalability of SQL server environment to fit organization structure and business requirement.
• Performed Database Analysis and Design and Modeling
• Performed upgrade and installation for SQL Server 2008, 2008 R2, 2012.
• Performed installation for SSIS, SSRS, SAS.
• Created and modified SSRS reports and SSIS package for IT administration.
• Installed and Configured Monitoring and Management SQL Server Clustering and Implemented service patches.
• Review and implement SQL patch to production for in-house application.
• Assisted activities in server group, such as virtualization.
• SQL Server Login and Access Administration.
• Backup and Restore Database Operations for Medium 100GB to 100TB Databases.
• Database Mail and Operators Development.
• Repaired, Recovered Database Synchronization for Disaster Recovery.
• Created High Availability Solution with Database Mirroring, Log Shipping, Replication and Clustering
• Provided Consulting for Database Performance Tuning and also used tools such as Data Tuning Advisor and SQL Best Practice Analyzer.
• Managed Databases using Maintenance Plan, DBCC, Backup (Full, Differential, Log), Automated Backup to Tape.
• Monitored SQL server performance and traced for potential performance issues.
• Performed SQL server trouble shooting for immediately issue, such as deadlocks.
• Programmed and enhanced SQL objects, including Stored Procedures, Functions, Indexes, Triggers.
• Implemented disaster recovery strategy and configure relative job on DR.
• Created and monitored SQL agent jobs.
• Powershell Programming.
• Developed PL/SQL Stored Procedures for Oracle 9i, 10g
• Developed PL/SQL Reports Oracle 9i, 10g using Crystal Reports.
• Communicates very well with Application Developers since I have relevant experience on Software Engineering and Development of Web Site and Local Applications.
• Supported and implemented DR and solution with database clustering, mirror, log shipping and replication.
• Supported and implemented, and maintain SQL server security setting, including Database engineer, SSRS, SSAS security.
• Assistant other day to day admin task in server group, and have ability to admin SAN and SnapManager.
• Provided consultation on management between server group and development group to ensure any database related requirements were met and the project plan reflected changes to scope and cost
• Provide technical support for vendor applications, including version upgrade, server migration.
• Provided training and assistance for database developers and users on daily basis
• Document SQL server and relative information for future references.
• Assisted activities in development group, such as application consolation, testing
• Delegates tasks to Junior DBA s.
• Incident, Events (SQL Monitoring using SQL MOM and Tivoli), Problem and Change Management.

Confidential

Software Engineer and SQL Server DBA

Responsibilities:

• Developed Web and Winforms Application for Call Center Agents using C#.Net, ASP.NET, Java, Siebel 6 & 7.
• Performed Database Analysis and Design and Modeling
• Developed PL/SQL Stored Procedures for Oracle 9i, 10g
• Developed PL/SQL Reports Oracle 9i, 10g using Crystal Reports.
• Developed and Managed SQL Server 2005 and 2008 Databases using Maintenance Plan, DBCC, Backup (Full, Differential, Log), Automated Backup to Tape.
• Managed Oracle 9i Databases.
• Repaired, Recovered Database Synchronization for Disaster Recovery.
• Monitored SQL server performance and traced for potential performance issues.
• Created and maintained Replication and Database mirroring.
• Performed SQL server trouble shooting for immediately issue, such as deadlocks.
• Sybase Database PL/SQL Development and Administration.
• Sybase stored procedure programming for Report Writing using Crystal Reports