SUMMARY:

• Database architect, database administrator and database developer with over 10 years extensive experience designing, coding, testing and supporting next - generation database solutions in SQL T-SQL Server environments.
• Proficient in an assortment of technologies, including MS SQL Server, MySQL, MS C#.net, MS ASP.net, VB/Java Script, HTML, DHTML, XML and (complete list available upon request).

TECHNICAL SKILLS

• Microsoft SQL Database Administration
• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Standby/Failover Administration
• SSIS, SSRS, SSAS
• MS SQL Admin/Installation
• MS SQL Forms and Reports Development
• Database-Backed Web Solutions
• SQL Tuning in an Microsoft Environment
• SQL Envier. 2000, 2005, 2008, 2008 R2, 2012, 2014

PROFESSIONAL EXPERIENCE:

Confidential, Santa Monica, CA

Sr. MS SQL Database Engineer

Responsibilities:

• Worked closely with the engineering group to design and implement databases, recommend solutions and mentor others as necessary.
• Reviewed and approved all schema changes in the application.
• Developed and maintain stored procedures, user defined functions, triggers and index.
• Provide 24/7 support with On-call rotation.
• Responsible for performance tuning of slow Queries and optimized for faster response.
• Designed and implemented data warehouse solutions, such as differential data using Change Tracking.
• Analyzed Load Test results before deploying major database versions to Production.
• Worked closely with network operations, QA and application development Team.
• Developed and implemented web base Real-Time monitoring solution using T-SQL and C# 4.0
• Reviewed and assessed the impact of database design changes prior to implementation.
• Developed and implemented process to dynamically sync all SQL Server environments to Central Management Servers.

Confidential, Malibu, CA

Sr. MS SQL Database Administrator / Developer

Responsibilities:

• Analyzed existing T-SQL code to improve database performance.
• Logical and physical data modeling, database design, and implementation including maintaining and updating database architecture.
• Developed and implemented ASP.Net (C# .Net 4.0) custom Web Portal for SQL Server Monitoring.
• Developed and implemented (C# 4.0) FTP/SFTP client for SSIS.
• Developed and implemented email parsing process (MS Outlook) to automate attachment download for SSIS ETL process.
• Supporting Java and PHP developers T-SQL development.
• Supporting data warehouse and ETL environment.
• Provide 24/7 support.

Confidential, Culver City, CA

Principal MS SQL Database Engineer

Responsibilities:

• Supporting high volume data bandwidth of databases with up to 1 TB monthly growth.
• Maintaining, developing and supporting global based data centers for cloud environments.
• Performing monthly and daily performance optimizations.
• Supporting and maintaining MS SQL databases up to 24 TB.
• Supporting database deployments for new releases.
• Provide 24/7 support.

Confidential, Los Angeles, CA

Sr. MS SQL Database Administrator / Developer

Responsibilities:

• Implemented SQL Server 2012 Enterprise AlwaysOn Failover Cluster (three nodes) with Availability Group Listeners.
• Implemented High Jump solution for Warehouse Management System (WMS) on SQL Server 2012 environment.
• Developed interface conversions from MySQL 5.x to SQL Server 2012 using SQL Server Integration Services (SSIS) 2012.
• Setup and configured SQL Server Reporting Services (SSRS) 2012.
• Developed and implemented real-time storage monitoring website in ASP.NET 4.0 (C#.net, jQuery).
• Wrote stored procedures, triggers and views using T-SQL.
• Participated in designing, testing and implementing an enterprise Disaster Recovery Plan.
• Conducted root cause and analysis for database incidents and problems.
• Monitored data activities (i.e. database status, logs, space utilization, locks and long transactions).
• Managed security by defining roles and rights.
• Participate in the planning, analysis, design and implementation of databases.
• Acted as a primary point of contact for new application implementation.
• Monitored the database server performance and performed tuning queries and stored procedures when required.

Confidential, Los Angeles, CA

Sr. MS SQL Database Administrator / Developer

Responsibilities:

• Enhanced end users understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials.
• Installation, Upgrade and Configuration of SQL Server, Performance Monitoring, Tuning, Profiler Trace.
• Developed and implemented web based SQL Server Database Management.
• Customized Microsoft Team Systems for automated builds and versioning.
• Created customized business reports using Microsoft Reporter Builder.
• Performance tuning, query tuning, SQL profiler and performance counters
• Database tuning and monitoring activity, CPU, I/O and memory, DTS packages, user activities
• Failover clustering, replication and log shipping.
• Work with project managers to understand business data requirements and integrate business data needs into the physical enterprise data model and logical model.
• \Plan, design and implement the databases and ETL for mid/small size products.
• Help developers to perform index tuning and stored procedure development on all products.
• Performing backup and recovery duties.
• Performing database upgrades.
• Update internal website features used for product stability and supportability.
• Setup and maintain data replication.
• Add steps to existing jobs that will notify staff in case of SQL job failure.
• Performing database security audit.
• Work with CTE to insure data quality for all our products.
• Provide 24/7 support.
• Automate routine processes with PowerShell, SQL and C# and other languages.
• Writing stored procedures, triggers and views using T-SQL.

Confidential Los Angeles, CA

Information Systems Analyst II

Responsibilities:

• Implemented and supported Symantec Antivirus Corporate Edition as a centralized virus protection system for all Los Angeles County Department of Health Services facilities (HSA, OMC, HR etc.).
• Implemented and supported Symantec Antivirus Reporting server department-wide.
• Implemented BMC Atrium CMDB (Configuration Management Database) and BMC Remedy Change Management using ITIL industry standards and the best-practice process structure.
• Developed and implemented inventory application using ASP.Net 2.0 and MS SQL 2005 called PreCMDB to track server hardware, software and appliance.

Confidential

Responsibilities:

• Developed and implemented Public Health Laboratory Web Portal using ASP, Java script, VB script, and MS SQL 2000.
• Developed and implemented advanced Web Security using ASP.Net and MS SQL 2000.
• Developed and implemented West Nile Virus Data Reporting application system using VB.Net and MS SQL 2000.
• Developed and implemented Specimen Tracking System for a large user environment using ASP, Java script, VB script and MS SQL 2000.
• Developed and implemented Web based File Sharing, Calendar, Project Management, and News using ASP, Java script, VB script and MS SQL 2000.

Confidential

Responsibilities:

• Developed Administrative web pages for phone call tracking system using ASP and MS SQL 2000.
• Added, modified, listed records from MS SQL 2000 database and created reports for those records using MS Visual Basic 6.0.
• Configured of Windows 2000 Advanced Server, MS SQL 2000, and web server running IIS 5.0.
• Provided technical support for MS Windows 9.x / NT / 2000 / XP, MS Office 2000 / XP, Internet Explorer 5.5 / 6.0, Outlook, Netscape Navigator, WordPerfect 8.x / 9.x / 2000, Novell GroupWise 5.5, Novell Client 32, Lotus 123 / Notes.

Confidential

Responsibilities:

• Developed web pages for county health organizations using HTML, ColdFusion 4.5 and Java script.
• Designed graphical interfaces for Enterprise systems such as Help Desk using Photoshop 5.5 / 6.0, Corel Draw 10, Macromedia Dreamweaver 4.0 / Ultra Dev, and Macromedia Flash 5.0.
• Installed and troubleshot Windows 95 / 98 / NT 4.0 / 2000 Pro, Novell Client 32 and GroupWise 5.2 / 5.5.
• Tested new software such as Altiris Software for Client troubleshooting, computer inventory etc.
• Supported users remotely using Net Support PC Duo Version 5.31 (Remote Control Software).
• Repaired network and local printers: HP, Lexmark, Canon and others. Laser jets as well as Inkjets.

Confidential, Los Angeles, CA

Data Systems Analyst

Responsibilities:

• Administered Windows NT Servers for large volume of users.
• Supported small and large LANs with NT and Novell Netware 3.x - 5.x, as well as Windows 95 / 98 clients PCs running Microsoft Outlook or Novel GroupWise.
• Configured and set up LAN / WAN with Token Ring and Ethernet network with installation and configuring Windows NT Servers with Microsoft Exchange and IIS.
• Installed and upgraded Windows 95 / 98 / ME / NT (Workstation, Small Business Server) / 2000 (Professional, Server and Advanced Server), GroupWise 5.x / 6.x, CompuCare software package, Simulation software such as (AS / 400 and Extra), Office 97 / 2000, Corel Suite 7.x / 8x.