PROFILE

• Present: Database Administrator DBA , SQL Server 2008 and SQL Server 2005/2000
• Past: Data Modeler, Data Engineer, Application DBA DB2 V.7, V.8

OBJECTIVE

In the market, seeking for a position in SQL Server Database Administration DBA

EXPERIENCE SUMMARY

• Primary experience as a SQL Server 2008/2005/2000 Production DBA
• Experience supporting SQL Servers in Win 2008, Win 2003 and Win 2000
• Experience in High Availability solutions such as Log shipping, Mirroring, Replication
• Experience in Windows Scripting Language, Poweshell
• Understanding of SQL Server table and index structures, database Engine
• Experience in using Windows Performance Monitor, SQL Server Profiler, DMVs and Extended Events for monitoring and troubleshooting needs and detecting system health and performance issues
• Performed various database administration operations such as Database and Transaction Log Backup and Recovery, Index Maintenance, Storage management, Page Compression, Data Refresh, Database File movement, Create and Maintain SQL Agent Jobs, Linking Servers etc
• Experience in implementing and maintaining Data Partitions
• Query Tuning, Performance Enhancements
• Experience in writing Stored Procedures, Triggers, Functions, T-SQL
• Used Third Party Tools Like Performance Analysis, Litespeed, Redgate SQL and Data Compare
• Past experience in IBM's DB2 up to V.8 as an Application DB2 DBA
• Data Modeling using Erwin
• Experience working with multiple Customers in different geographic locations across United States.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA Production

• Write and/or review deployment and rollback scripts create/alter/drop database objects and elevate into all environments including production
• Migrated several databases from SQL 2000 and SQL 2005 into SQL 2008 using backup and restore methodology
• Refreshing data on user databases across environments using backup/restore as well as detach/attach processes as per customer requests
• Have tuned data warehouse queries that were posing performance bottleneck, leveraging existing indexes to bring down response time from 3 hours to 15 minutes
• Implemented Database Log-shipping, SQL Replication Snapshot, Transactional , Database Mirroring
• Maintained data partitioning partition switching for sliding windows and contributed towards building an automated process for select partition schemes
• Used DMVs adequately to obtain information on SQL execution, I/O activities, Index usage and recommendation, transaction locking, operating system for various monitoring and performance reasons
• Rebuilding Clustering Index on fairly large table using bcp-in and out process
• Coached application developers on best practices and high performance database design while creating database objects such as tables, indexes, RI, procedures etc
• Performed administrative activities such as taking Database Backups full and differential , Transaction Log Backups, Reorganizing and Rebuilding Indexes, Shrinking Databases non-critical and for storage needs only , Page Compression, Database File Movement, Create SQL Agent Jobs, Linking Servers etc
• Monitoring and Troubleshooting server issues. Disk I/O, CPU. Database issues. Transaction locking and blocking, resource-waiting, poor response time, space issues with tempdb, user data and transaction log files, insufficient access rights etc
• Presented usage of Powershell on SMO, WMI and SQL Connection to our SQL DBA team

Accomplishments:

• Enhanced an existing SQL Login Audit Script to auto-generate Grant statements to aid database migration and data refresh efforts
• Tuning Physical Memory on several production clustered machines and SQL Instances
• Audit security setup on newly migrated sql instances using Windows Powershell
• Create inventory for sql instances and machines using Windows Powershell, SMO and WMI Service

Confidential

• Data Engineer SQL Server Developer and Test-Env DBA , Claims Platform
• Create and Maintain Data Models using data modeling tool ERWin while designing tables and indexes
• Produce deployment as well as rollback atomic scripts for SQL Server database development
• Produce scripts to synchronize SQL Server databases across environments using vendor tool Redgate SQL Compare
• Guide application developers in designing data access flow and troubleshooting database issues
• Writing Stored Procedures, Functions, defining Views
• Stored Procedure query performance tuning in SQL Server 2000
• Part of the Database Code Review team in Claims Platform for both SQL Server

Accomplishments:

Analyzed, simulated and provided two effective resolutions to a massive conversion deadlock occurring in production environment in a SQL Server 2000 database

Confidential

• Data Access Services DB2 Developer and Test-Env DBA , Claims Platform
• Writing DB2 Version 8 Stored Procedures using Development Center PL/SQL and z/OS Cobol
• Designing Tables, Indexes etc and writing Functions and Triggers in DB2
• Create and Maintain Data Models using data modeling tool ERWin
• DB2 SQL performance tuning using Visual Explain and Raw Explain using Spufi
• Assisting developers and users in producing reports on business data by writing ad hoc queries in DB2
• Assisting team members in influencing database object locking while creating Procedures with complex data integrity requirements
• Re-write existing DB2 PL/SQL Procedures to resolve hanging thread issues in DB2
• Fixing Production, QA defects pertaining to DB2 errors
• Delivered presentations to developers on a Locking and Concurrency and b Data Partitioning in DB2

Confidential

Enrollment Systems

Environment:

IBM z/OS, IBM DB2, SQL, Platinum, Spufi, File Aid, REXX, Panel, Skeleton, ISPF Dialog Manager, COBOL, JCL, VSAM, CICS, Eztrieve, Quick Job, Inter test, Smart test, Xpediter, TMON, Strobe.

Responsibilities:

• Root Cause Analysis for Production Exception Conditions involving Database errors
• Assisting development team in fixing Production transaction checkpoint issues
• Assisting development team in Production turns/deployments
• DB2 Performance monitoring using TMON
• DB2 SQL Tuning, Explain Access path Raw Explain table results
• Package maintenance, Bind, Rebind, Free Packages in non-production environments
• Preparing DDL for Test Environment
• Running IBM Utilities - Load, Unload, Reorg, Runstats, Repair etc
• Creating Stored Procedures in Cobol
• Was part of V7 to V8 CM migration Stored Proc and Application
• Coordination between development team and production DBAs

Accomplishments:

Production Deployment Audit Report:

Created a Production Deployment Audit utility. In absence of a version control tool such as Changeman, this tool would generate a batch report on missing DB2 DBRMs and/or binds to DB2 Collections. It helped in taking necessary action before-hand on missing production deployment.

Confidential

Automated Enrollment

Environment:

IBM z/OS, IBM DB2, SQL, Platinum, Spufi, File Aid, REXX, Panel, Skeleton, ISPF Dialog Manager, COBOL, JCL, VSAM, CICS, Eztrieve, Quick Job, Inter test, Smart test, Xpediter, TMON, Strobe, Cool:gen, Advantage:gen

Responsibilities:

• Production Break Fixes, Production Support Metrics, Production Enrollment Transaction Metrics. Application Programming involving DB2. Developing Stored Procedures, Production Support. Application and Database Design using Visio. Limited database operations such as reorg, runstats, load, unload etc on non-production environments.
• Been innovative on coming up with resolution to Environmental issues. Outlined required Technical specifications. Designed, developed and successfully installed couple of new tools to implement the concepts.

Accomplishments:

• 1 System Programming to support DB2 package set up:
• Fixed nightly batch job failures after DB2 security setup was made SOX compliant. Created a system programming tool using Rexx, to use DB2 Secondary Authorization IDs to build DB2 packages after sox compliant security policies were made effective.
• 2 Resolving Environmental Issues:
• With no change control tool in place such as Changeman and limited number of test regions for all of UAT, System Testing, QA and Unit testing, there were outstanding issues with non-production environments mostly due to overlapping and/or inconsistent APIs.
• Provided technical approach with detailed design and implemented a user-friendly Rexx-tool to address add Versions on DB2 Packages. The benefits were - easy code base maintenance, automated non-production release implementation, cutting CPU cost, making test environment as production-like as desired etc.
• 3 Enrollment Online Data-Retrieval Tool:
• Produced a tool that would pull customer enrollment info online in TSO environment. It was a TSO-to-DB2 system programmed tool invoking more than 100 DB2 SQL queries behind the scene to ease the work for QA users.

Confidential

Policy Admin

Responsibilities:

• Project Lead. Project Management. Mentoring a team of 16 members for Production Support,
• Enhancement, Development and Maintenance. Coordinating on overall SDLC process.
• Generating Project Health Metrics. Facing Software Compliance Audits both internal and
• external. Batch System Automation.
• Tutor/Trainer on DB2 hands-on.

Accomplishments:

• Management appreciated the team, and in particular me, for following SDLC process with passion - which earned a 100 compliance from external auditor group.
• Received client appreciation for automation of test batch system using Rexx, Skeleton and Panels.