Database Administrator

Database administrator (DBA) with 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 DB2, Access, Sybase, MS SQL Server, MS Visual C#.net, MS ASP.net, JDBC, Visio, Apache Web Server, Java, C++,VB Script, HTML, DHTML, XML, Windows and Linux (complete list on request). DBA skills include:

• Microsoft SQL Database Administration
• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Standby/Failover Administration
• MS SQL Admin/Installation
• MS SQL Forms and Reports Development
• Database-Backed Web Solutions
• SQL Tuning in an Microsoft Environment

Experience

Confidential Los Angeles, CA
Database Administrator 10/2007 - Present

Manage MS SQL database administration assignments for diverse industry clients. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.
Key projects:

• Served as DBA or project lead in the completion of medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support.
• Managed data-integration project for financial services firm that consolidated information from accounting applications, third-party market data and internal equities/fixed income applications.
• Innovated time-saving, robust employee data-intake system that automated database update functions, enabling new salary and process-exception information to be automatically populated.
• 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 Report 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 gain in understanding of business data requirements and, in turn, integrate business data needs into the physical enterprise data model and logical model.
• Support rollout of production changes for multiple products including but not limited to Microsoft CRM Dynamics, WAM, Dailygraphs.com and Investors.com
• Plan, design and implement the databases and ETL for mid/small size products.
• Performing backup and recovery duties.
• Work with developers in index tuning and stored procedure development on all products.
• Performing database upgrades.
• Update internal website features used for product stability and supportability.
• Setup and maintain data replication.
• Reacting to database user complains.
• Add steps to existing Jobs that will alert support staff in job fails.
• Performing database security review.
• Work with CTE to insure data quality for all our products.
• Providing 24/7 support.
• Data Warehousing.
• Automate routine processes with PowerShell, SQL and C# and other languages.

Confidential
Los Angeles, CA
HEALTH AND SERVICES
Information Systems Analyst II 09/2000 - 10/2007

Developed functions, scripts and reports that were instrumental to the success of high-priority development projects.Promoted from Data Systems Analyst Aid to Information Systems Analyst I, II.

Information Recourse Management - Enterprise Applications
Key projects:

• 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 that provides 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.

Public Health Laboratory - Bio terrorism Unit (LIS)
Key projects:

• 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.

Acute Communicable Disease Control - Bio Terrorism Unit
Key projects:

• 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.

Information System Branch - Service Desk
Key projects:

• 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 02/1998- 09/2000

Confidential - Onsite support
Key projects:

• 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.

Education

• Major in Computer Science