Summary:

I am a Sr. SQL Server DBA with over ten years of experience. This includes:

• Installed, maintained and tuned MS-SQL 2000, 2005 and 2008.
• Implemented and maintained security rules for SQL databases.
• Tuned SQL servers for maximum performance.
• Implemented and maintained clustering, data replication, Log Shipping, DTS/SSIS migration.
• Created and Worked with T – SQL, Stored procedures, Indexes and triggers.
• Supported Production environment 7 X 24 to resolve issues and implemented changes.
• Proactively monitored the database systems to ensure secure servers with minimum downtime.
• Created backup jobs and disaster recovery processes.
• Created and worked with change management and problem tracking tools.

Education:

• Bachelor of Computer Science

Certifications/Training:

• MS SQL 7.0, 2000, 2005
• System Administration for - Performance Tuning & Optimization for MS SQL Server 7.0
• Installing, configuring of Database for MS SQL 7.0 , 2000 and 2005
• DTS, SSIS, SSRS to Populate Data Warehouse.
• ORACLE 7 Database Administration
• Solaris 2.X System Administration
• Tools I - Data Management Tools, Red Gate
• CNE
• Compaq, IBM, and Apple Certified.

Technical Skills:

Operating Systems: Windows 2008, 2003, 2000, Vista. XP, 2003, NT, and OS/2 Ver.2.01
Ancillary Skills: MS SQL Server 2008,2005, 2000, 7.0, 6.5, Oracle 8i, 7.3, People Soft 6.0, 7.0, 7.5, XP, SMS, SQL Server Clustering, Replication, , Log Shipping, Linked Servers
DTS, SSIS, Redgate SQL Compare, Sitescope, NetIQ, Sitescope, TCP/IP, RDBMS Level Two Training, SQA Tool, Crystal Reports, Cognos, TSQL, , pcanywhere, Remotely Possible, UnixWare, Novell 3.11, 4.01, NetWare Asynchronous Comm., Utility Programs - Netutil, Norton, PC Tool, VERITAS, LiteSpeed back up, - Arcserv version 4.02, Connected Backup
Hardware: DELL and HP servers, NT Cluster, NetFRAME Super servers, Novell Installation Configuration & Support, IBM AS400, System 36, VAX 11/785,Data General MV/10000, Laser, matrix and line printers, Compaq/Apple/IBM Certified on full line of products

Work Experience:

2009 - Present Confidential,CA
Title: Lead SQL Server DBA

• Installed, configured, supported SQL server 2000, 2005 and 2008.
• Maintained health care application systems.
• Managed various database projects and other IT projects.
• Created processes and provided directions to clarify business processes.
• Supported developers and users to resolve their issues.
• Worked with SSIS, SSRS and DTS packages.
• Performed database tuning and troubleshooting complex database issue.
• Used reporting tools, such as SSRS, Crystal Reports and MS Excel.
• Use TSQL to write scripts to format and filter data.
• Created tables, keys, indexes, views and stored procedures.
• Understood end to end data cycle and acquired data from systems and created data warehouses.
• Presented reports specifications and research analysis and database concepts.

2007 – 2008 Confidential,Oakland, CA
Title: SENIOR SOFTWARE ANALYST

• Installed, configured and tuned SQL 2000 and 2005.
• Managed SQL Servers in Production Environment
• Participated in on-call duty for out of hours problem resolution
• Planned, Scheduled and executed SQL server 2000 to 2005 Migration.
• Monitor SQL Server Performance and performed Tuning of SQL Servers for maximum Performance.
• Implemented and maintained data replication, Log Shipping., DTS/SSIS migration, data warehouse.
• Created and Worked with T – SQL, Stored procedures, Indexes and triggers.
• Documented processes to support Products
• Created SQL jobs for backups and maintenance.
• Created technical requirements and business reporting experience.
• Created processes, checklist for applying code changes or patches in production.
• Provided stability by using automation.
• Worked with SSIS and SSRS.
• Installed, configured and supported IIS.
• Supported and trained end users.
• Installed, configured Log Shipping, and Linked Servers, Replication.

Environment: Setup, Installation, Configuration, Upgrade, Performance and tuning of SQL 2000 and 2005 databases.

2000 – 2006 Confidential,CA
Title: SENIOR SQL SERVER DBA

• Created and Worked with T – SQL, Stored procedures, Indexes and triggers.
• Supported Production environment 7 X 24 to resolve issues and implement changes.
• Provided DBA support for remote SQL servers.
• Developed stored and other script to modify databases in production and client’s sites.
• Setup, maintained and provide access to production and test databases.
• Created Test environment in IT lab to test all patches in lab before production.
• Performed SQL Server Performance and Tuning.
• Designed, configured, maintained and monitor SQL 7.0, 2000 and 2005 Servers in Production.
• Responsible for capacity planning and space management database performance and monitoring.
• Installed, Configured, Managed performance on 30 SQL Servers in production environment.
• Installed and configured SQL replication, log shipping and clustering.
• Installed, Configured and maintained Crystal Reports.
• Supported and maintained various remote SQL servers for clients.
• Performed remote client upgrades and database maintenance.
• Worked with TSQL.
• Used DTS and SSIS in SQL 2000 and SQL 2005.
• Performed database administration and backups.
• Installed and configured Connected Backup software on SQL Server.
• Maintained documentation and checklist for all DBA’s tasks and other processes.

Environment: Support installation, configuration, and upgrade and maintain SQL server 7.0 and 2000 in production and remote clients.

1995 – 1999 Confidential,Pleasanton, CA
Title: SENIOR SQL SERVER DBA

• Administered SQL Servers in Production and QA environments.
• Installed, maintained and patched the MS-SQL software; create, move, upgrade, and delete databases
• Implemented and tested PeopleSoft Tools, PeopleSoft Financial and Human Resources on SQL 7.0 platform.
• Administered PeopleSoft Financial and Human Resources for Release Management.
• Supported Help Desk engineers on resolving user issues related to HR or Financials.
• Created and Worked with T – SQL, Stored procedures, Indexes and triggers.
• Resolved SQL issues related to PeopleSoft modules.
• Managed MS SQL Server 7.0 platform for system and platform testing.
• Configured servers for different database engine installations.
• Installed, tested, performed troubleshooting SQL server for various projects.
• Created, loaded and performance tuned databases for system and platform testing.
• Designed, implemented drop procedure from development to release management.
• Trained other DBA\'s for Release management and Demand planning.
• Installed, configured and tested People Soft HR, Financial and Student Administration.

Environment: Support installation, configuration, upgrade and maintain SQL server 7.0, 2000, Oracle and SBA online learning software in production and remote clients on Windows and UNIX.

1987 – 1994 Confidential,Concord, CA
Title: NETWORK ENGINEER

• Designed, Installed maintained and supported MS Network and Novell LAN\'s.
• Provided system Support for local and various remote Networks.
• Tested, evaluated and supported new software packages.
• Converted system 36/AS 400 Network to MS NT 3.51 Network.

Environment: Troubleshooting setup, upgrade Novell and NT on Compaq servers