PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, Pennsylvania

Database Administrator

Responsibilities:

• Supporting and Monitoring eComm DB2LUW databases in a PureScale Cluster with an HADR Configuration;
• Working with Developers in running sql scripts and granting/revoking access to database objects;
• Checking the db2diag.log, administration notification logs and the STMM logs and troubleshooting issues;
• Checking and troubleshooting errors in the scheduled processes and jobs on the servers.
• Performance Tuning on the SQL queries using Explain;
• Performance and Memory Monitoring on the instance (dbm), db and application levels configuration parameters like STMM parameters, PACKAGECACHESZ, APPLHEAPSZ, etc.
• Using db2top in troubleshooting and monitoring instances and database locks and hung processes;
• Backing up, quiesceing, and restoring tables and databases;
• Checking and monitoring using db2pd the HADR and Primary and Standby db2 servers;
• Troubleshooting Re - org and runstats scheduled processes and running ad-hoc run-stats;
• Cataloging remote db2 connections;
• Monitoring and troubleshooting the storage and file systems and archiving old files;
• Checking and maintaining the db2 licensing, versions and installations;

Confidential, Austin, Texas

State Employee: Lead DB2 Database Administrator

Responsibilities:

• Leading a Team of 5 DB2 DBAs in Administrating, Improving Processes, maintaining and Troubleshooting db2 databases set up with SQL Replication;
• Implemented and Administering IBM Data Server Manager (V2.1 EE with DB2 LUW V10.5 ESE Repository Database on AIX);
• Implementing and troubleshooting the database changes on various db2 instances and databases for DB2 LUW and DB2 z/OS databases;
• Monitoring and Troubleshooting the scheduled processes on db2 servers;
• Improving change process for the db2 z/OS systems and working with various db2 z/OS DBA tasks;

Confidential, Austin, Texas

Database Administrator

Responsibilities:

• Database Administration, Installation and Configuration of IBM DB2 LUW databases running on AIX. Installing, troubleshooting monitoring and validating complex DB2 LUW databases, including PureScale and installing and configuring db2 SSL certificates.
• Implemented IBM Data Server Manager (V1.1 and 1.2 ) along with the DB2 Repository Database - DB2 V10.5 ESE on AIX; The solution monitors (database Administration and Performance Monitoring ) hundreds of db2 LUW databases.

Confidential, Austin, Texas

Systems Analyst

Responsibilities:

• Secure FTP Administrator: working with GlobalSCAPE Secure EFT System.
• Systems Design and Administration and working on Escalation Level Tickets;
• Working with Oracle v 10g in dba tasks and troubleshooting on Oracle databases;

Confidential, Austin, Texas

Systems Analyst

Responsibilities:

• Supported, migrated and administered applications and a SharePoint farm using Central Administration and PowerShell. (MOSS 2007 to SharePoint 2010)
• Database Administration and Systems Administration

Confidential, Austin, Texas

Database Administrator

Responsibilities:

• Supported various Health Care and Epidemiology Applications and Databases.
• Supported the total n-tier application including the front-end web site / client and the back-end databases;
• SQL Server Databases (SSIS, SSRS and SSMS, ETL processes, triggers, stored procedures, indexes)
• Windows Server 2003 and 2008 (IIS version 6 and 7).
• Troubleshooting and supporting mission critical, web based, 24x7 applications.
• User Reporting and Training
• Installed, Administered and Troubleshot the PKI for the application websites.

Confidential, Austin, Texas

Team Lead, Field Services Engineer/ Infrastructure Services

Responsibilities:

• IT Infrastructure and Operations Technical Services (Windows Servers 2003, Exchange 2003, Terminal Services, SharePoint migration)
• Installing, Configuring, Administrating and Troubleshooting a SharePoint Farm running MOSS 2007 and a SQL Server 2005 database backend.

Confidential - Austin, Texas

Sole Proprietor

Responsibilities:

• Remote Technical Support for Microsoft Premier Customers on Windows Server, SQL Server, Exchange Server and SharePoint Server.
• Troubleshooting Active Directory and Clustered Implementations, Engineering Upgrades, Migrations, and New Systems.
• Windows Server 2003. Troubleshooting and Systems Administration.
• Conducted Business Applications and Technical Training
• Taught Microsoft courses like SQL, Advanced Excel and VBA (Visual Basic for Applications) at New Horizons Computer Learning Center.

Confidential, Pleasanton, California

Application Consultant

Environment: Microsoft Windows Server, Microsoft Exchange Server

Responsibilities:

• Provided key and major account Technical Support for Confidential .
• Systems analysis, design, installation, and migrations from Legacy systems and Platforms.
• Upgrading, troubleshooting and System Administration of the Total customer software solution
• Customer training in the new or upgraded Platforms and Solutions

Confidential, Pleasanton, California

Application Engineer

Environment: Microsoft Windows Server, Microsoft Sequel Server

Responsibilities:

• Provided Technical Support to users throughout the sales cycle.
• Configuration modifications in the software to ensure customer requirements are fully satisfied and other Systems Analysis Tasks.
• Worked closely with the Area Technology teams and the customer to fully implement projects on time with the appropriate level of quality given the resources and business needs of the project.