We provide IT Staff Augmentation Services!

Sql Resume

CA

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

Hire Now