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/2008R2/2012 and Windows Server technologies
• 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/2008R2/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

Sr. SQL Server Applications DBA / SQL Azure Specialist

PROJECT BACKGROUND

• Confidential is starting their first venture into the Cloud. Windows Azure is the cloud solution chosen by Kellogg. The Retail Execution Hub is intended to prove an architecture that exposes data from on-premises systems to mobile device users through Windows Azure.
• The Retail Execution Hub uses Azure to surface line-of-business data through the cloud to mobile devices operated by Retail Store Representatives. Using Windows Azure and adhering to Platform-as-a-Service PaaS approach were the primary design decisions and constraints
• SQL Azure Microsoft Windows Azure SQL Database extends SQL Server capabilities to the cloud. SQL Database offers a relational database service called Microsoft SQL Database, and using Windows Azure SQL Database, provisions and deploys relational database solutions. Benefits include manageability, high availability, scalability, a familiar development model, and a relational data model.
• SQL AZURE
• 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
• SQL SERVER
• Installed SQL Azure Data Sync client On Premise Database in order to communicate with Azure Database on cloud.
• Managed Local SQL Server Databases.
• .NET APPLICATIONS
• Enhanced .Net Mobile and Tablet Applications.

Confidential

Senior SQL Server DBA

PROJECT BACKGROUND

• T-Systems is a company that handles all applications, database, storage and network requirements for a large world class company Shell.
• Our SQL DBA Team manages Shell Servers of huge number around 9000 SQL Servers boxes and around 24,000 databases.
• Senior DBA's delegate and distribute tasks to Operations DBA.
• Implemented Sql Server 2005, Sql Server 2008, Sql Server 2008 R2 and 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.
• DATABASE / HIGH AVAILABILITY / PERFORMANCE TUNING
• 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.
• SQL AZURE
• 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
• STORED PROCEDURES / JOBS PROGRAMMING
• 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.
• APPLICATION AND ACTIVITIES
• 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

POSITION: Applications SQL Server DBA / Architect

PROJECT BACKGROUND

• The project under my responsibility is MES Proctor and Gamble manufacturing data warehousing applications database management and engineering for SQL Server 2005. I am managing 12 SQL servers and around 120 databases. My responsibilities are database management, performance tuning, backup, Replication, setup and installation. The client location is in Cincinatti, U.S. I manage these thru VPN and windows remote connectivity. I also designed databases for data warehouse for reporting purposes.
• 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 Tuning,
• Maintenance 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.
• DATABASE / HIGH AVAILABILITY / PERFORMANCE TUNING
• 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.
• STORED PROCEDURES / JOBS PROGRAMMING
• 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.
• APPLICATION AND ACTIVITIES
• 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

POSITION: Software Engineer and SQL Server DBA

PROJECT BACKGROUND

• Confidential is a call center marketing company handling inbound and outbound calls. Its head office is based in U.S. other branch offices are located in Australia and Philippines. My responsibilities are analysis, development, enhancement and documentations call center scripts
• programs for medical marketing purposes. Handled Siebel 6 conversion to 7 for a project for Hallmark client. I have documented RMR along with my Application Development tasks these includes Disaster Recovery Plan and Business Continuity Plan.
• PROGRAMMING AND DEVELOPMENT
• 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.
• DATABASE
• 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