Database administrator Resume Profile CA - Hire IT People

Objective

I am only looking for job in Sacramento Metro or telecommute work.

Work Experience

Confidential

Senior SQL Server Database administrator

Confidential

Lead the effort to implement centralized USDA Geo-Spatial Databases with SQL Server 2008.
Installing, configuring, managing, monitoring and troubleshooting Arcsde Databases on SQL Server 2005, 2008 and 2012.
Set up database backup and recovery strategies.
Setup and monitored SQL Server transactional replication.
Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS.
Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services SSRS .
Daily routine DBA tasks like handling user's permissions and space issues on Production, Development and Certification Servers and handling maintenance Jobs.
Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.

Confidential

Performed work as database administrator for ArcSDE SQL Server 2000 databases.
Installed, maintained and upgraded ARCSDE on SQL Server 2000.
Created, Designed and Implemented citywide ArdSDE spatial databases to support Municipal, Park, Planning, Public Work, and Police Department.
Participated to administrate and implement Oracle Databases for Integraph Dispatch System for Police Department. Participated to build citywide ArcIMS website with Java API, VB.net.
Performed routine maintenance and performance tuning on databases.
Backup databases by Veritas Backup Exec 9.0.
Migrated vector data and raster data to ARCSDE spatial databases.
Used SDE monitor to monitor ARCIMS and ArcGIS software gsrvr connections to SDE.
Custom ArcGIS application By ArcObject and VBA.

Confidential

Performed work as Software Engineer for SQL Server.
Installed and maintained SQL Server 7.0.
Analyzed, designed and implemented databases.
Wrote, tested and implemented stored procedures and triggers.
Created custom reports using VB 6.0, MS Access and Crystal Reports.
Performed SQL Server performance tuning, backup recovery, security administration.
Wrote stored procedures, DTS packages for report generation.
Optimized existing SQL Server stored procedures for report generation using Crystal Reports 8.
Troubleshooting SQL Server using event log and error log messages.
Carried out requirement analysis, designed, developed and implemented Front-End applications tools.