OBJECTIVE: SQL SERVER DATABASE ADMINISTRATOR

SUMMARY OF QUALIFICATIONS: 
Nine years as SQL Server Database Administrator responsibilities in support SQL Server Database Systems in enterprise level, large databases with high transaction volume, multi-tier applications production environments.

CERTIFICATIONS: 
Microsoft Certified Database Administrator SQL Server, MCDBA. 
Microsoft Certified System Administrator window, MCSA

TECHNICAL SKILLS: 
Databases: MS SQL Server, Oracle, MS Access, Excel. 
Programming languages: TSQL, PL/SQL, PowerShell, ASP. Net, VB.Net, HTML, Visual Basic, MS Access, HTML, VB-script, java-script.
Applications software: Kronos, VSS, Visual Studio, Excel, Access, Power Point, STARS, SFDM, INFORMATICA.  Win2003/Win2000/WinNT/Win9x, UNIX, DOS, NOVELL, IIS, TCP/IP, LAN/WAN, SAN. CLUSTER, SSIS / DTS , SQL Report Service, SQL Server Cluster, Familiarity with Analysis Service. Knowledge of Data Warehouse/Table Partitioning.

PROFESSIONAL EXPERIENCES: 

DATABASE ADMINISTRATOR CONSULTANT 01/2007 – 05/2010
Confidential. San Jose, CA
Responsibility for production MS-SQL Server Databases (2008/2005/2000) in Win 2003/2000 /SAN environments. Manage multiple datasets across multiple database servers. In charge of trouble-shooting all database related issues Define and manage databases in Development, QA, Staging, and Production.

• Consolidate, migrate, and upgrade versions for SQL Server Systems.
• Provide system integration, data synchronization to production, staging, test and development.
• Identify and resolve database performance issues, database capacity issues, and other distributed data issues – MSDTC, link Servers, database space growth issues.
• Respond to and resolve SQL server connection and database access issues.
• Install SQL Server engine, apply SQL service packs and Application Service Packs.
• Analyze hardware, software performance; resolve locking conflicts and resource utilization.
• Monitor and resolve production database system details in databases, including automation and
• dependency jobs, stored procedures, execution time.
• In charge of backup and restore, disaster and recovery strategy and setup.
• Create scripts and stored procedures for database maintenance routines.
• Generate alerts for backup jobs, scheduled jobs, and system performance.
• Setup and maintain Database Replication, database Mirroring, database log shipping.
• Design, setup, monitor, and troubleshoot DTS, SSIS packages.
• Assist and troubleshoot SQL Server 2005 / 2008 Report Services.
• Administer database and all systems for KRONOS Web Enterprise Payroll Application.

DATABASE ADMINISTRATOR 09/2004 - 11/2006 
Confidential, Irvine, CA 
Responsible for extensive SQL Server/ Application monitoring, troubleshooting, tuning, high-availability strategies in a Win2003/ Win 2000/Cluster/San/ SQL Server 2000 critical production environment.

• Created required reports and troubleshot data issues in response to business user needs.
• Troubleshot production problems encountered and participated in a rotate on-call support team.
• Identified and resolved database performance and other distributed data issues.
• Ensured integrity and recovered ability of database structures. Apply service packs and fixed packs as necessary.
• Resolved locking conflicts and resource utilization. Set up standard backup, re-indexing, consistency checking jobs. Setup Linked Servers, SQL jobs.
• Monitored, optimized and allocated logical and physical data storage for database systems.
• Monitored and resolved production database system details in databases.
• Applied database deployment builds into Production.

DATABASE ADMINISTRATOR 2000-2002 
Confidential, Mountain View, CA 
Administered MS SQL Server 6.5 /7.0/2000 database systems.

• Implemented logical and physical SQL Server databases.
• Implemented and performed backup, restoration, and disaster recovery.
• Performed systems/databases tuning and index optimization. Monitored SQL Server performance by System monitor and SQL Server Profiler.
• Designed, setup, monitored, troubleshot DTS packages used in data transformation.
• Implemented and troubleshot data replica. Upgraded numerous databases from SQL Server 6.5 to 7.0/2000. Setup Sql Mails.
• Supported application developers in database design, security, and application migrations..

SYSTEM AND DATABASE ADMINISTRATOR 1998-2000 
Confidential, Milpitas, CA 
Supported production database systems, used by over 1200 users, which included 7 NT servers, 20 ORACLE 8i / MS SQL Server 6.5, and 4 in-house applications software.

• Administered SFDM application running on ORACLE Databases and Unix OS, monitoring storage spaces; supported end users by using DML SQL to troubleshoot data problems.
• Administered SQLServer 6.0/ 6.5 databases and related applications on both servers and clients
• Built 6 Dell Servers, Setup volumes, RAID; Installed NT4.0, database system, and software applications.

EDUCATION: 
BS in Management Information System, 
DBA training at Computer Training Consultants 
MCSE training courses at Electrocomp Institute