PROFESSIONAL SUMMARY

• Confidential is a Database Administrator with 16 years of experience in industry and 12years of experience database administration in MSSQL Server and Sybase ASE. He has previously worked for over 4 years as a software developer in client server modeled software using Visual Basic and MS SQL Server / Sybase ASE.
• He is proficient in database administration, SQL scripting/development, documentation, performance monitoring, trouble shooting application and databases in client server and web based software models. He has been involved in critical systems upgrade project performing role of database administrator in which he has lead and managed project databases and developed requirements for database conversion and database transfers from legacy systems into MS SQL Server / Sybase ASE.
• He has managed company wide databases in production environments and is familiar with SDLC, Change Control, Disaster Recovery processes, Audit reporting and reviewing.

Technical Skills

RDBMS MS SQL Server 2005, 2008 R2, 2012 Sybase ASE 12.5.4 fluent in sql

OS Windows 2008, 2012, Win7

Web Servers IIS

Languages T-SQL, PowerShell, SQL, Dos batch scripting, VB, VBA, HTML

Tools MS SQL Mgmt Studio, SSIS, SSRS, SSAS

DB Artisan, Serena Team Track, Sales Force Resolve IT, Service Now.

Office products, MS Visio, Guardium, Fortinet, Litespeed

Applications In-house operations software, batch processes, Reporting

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator

Responsibilities included:

Key project database support role.

• Production support for databases for MS SQL Server 95 and Sybase database systems.
• Installations, configuration, troubleshooting, performance tuning and documenting on clusters and standalones for MS SQL Server 2005, 2008R2, 2012
• Plan database migrations or upgrades using MS PROJECT
• Collect metrics IO, CPU, Memory for MS SQL environment in planning for virtualization using PowerShell
• TPC benchmarking for tests on Physical and Virtual environments on MS SQL 2008 R2 / 2012.
• Lead yearly ACL Audit security reporting and support using PowerShell
• Lead Sybase database system administration, migration to 64 bit in ASE 12.5.4 setup auditing and support compliancy.
• Lead and participate in Disaster recovery planning and execution for onsite and offsite
• Snapshot Replication setup for MS SQL Server database systems
• Assist developers in setting partitioning schemes and table compression implementation for database models.
• Optimization using query analyzer sql profiler performance monitor to analyze server performance.
• Migration to MS SQL 2008R2, MS SQL 2012, upgrade database and batch processes to SSIS.
• Setup and support MS SQL Server auditing for production servers
• Move Refresh databases between MS SQL Servers,
• Administer user security setup modifications within databases
• Setup administer and support application teams in SSIS and SSRS
• Setup Document batch processes in sql agent
• Read and understand data models to query extract data using sql or POWERSHELL SSIS SSRS

Confidential

Consultant Database Administrator

Responsibilities included:

• Key project database support role.
• Plan database activities for system conversion within team and document tasks using excel.
• Script security changes and ETL requirement using DTS SSIS. Build file loads using SSIS.
• Move Refresh databases between servers
• Administer user security setup modifications within databases
• Setup Document batch processes in sql agent
• Install configure document sql server 2000 2005 on stand alones
• Migrate SSRS across servers.
• Read and understand data models to query extract data using sql or DTS SSIS.
• Optimization using query analyzer sql profiler performance monitor to record server performance.

Confidential

Database Administrator

Responsibilities included:

• Key member of project team playing role of database administrator in SQL Server 2000.
• SQL Server 2000 management in development, test and production environments.
• Application Support for Intellectual Property Software INPROTECH Release 3.3
• Organize data updates, database connectivity, database backups, space monitoring and recovery using transaction logging.
• Create test/UAT environments for use and refresh periodically for analysts.
• User login creations and testing connectivity.
• Software deployment over development, test and production systems.
• Data reporting using MS Excel, reports and pivot tables
• Use SQL profiler to find bottling SQL.
• Use performance monitor to analyze server performance.

• Build database conversion package using SQL server scripts and implemented using SQL Server 2000 data transformation services.
• Arrange download of data from Universe to SQL Server 2000 to form source database
• Write SQL scripts using a field-mapping document to convert from a source database to destination database.
• Assist in testing of conversion database.
• Analysis source database with business analysts to build reports for data scrubbing exercises

• Interfaces
• Arrange extraction of changes to client data and new clients from live database on periodic basis for load to a IBM Universe database system. Data extracted in fixed text file format.

Confidential

Database Administrator

Responsibilities included:

• Manage productions systems for all database applications within organization.
• Production support for all databases.
• SQL Server 2000 SYBASE ASE 2.5/11.9.2 installations administration support.
• iPlanet 6.0 Web Server LDAP installation, application deployment and administration
• Setup, administration of PVCS Version Manager
• Applications deployment over dev, test and production systems
• Change control Management using PVCS
• Organize Batch tasks, Data updates, database usage, database Backups, Space allocation and recovery
• Development and Test environment refreshes
• User login creations and testing connectivity.
• Provide support to developers and to business analyst with SQL queries, stored procedures and database concepts.

Analyst Programmer

Confidential

• Play lead developer role for data conversion project from Mainframe to Sybase/MS Sql Server
• Data conversion from Mainframe to Sybase Sql server. Write application in VB 5 to read data, apply business logic and apply to target SYBASE 11.9.2 database.
• Analyze, document and develop 2 tier business application systems using Microsoft Access 8.0, Visual Basic 6.0 as client and SQL Server 2000 and Sybase 11.9.2 as backend database.
• Document process and operations user guides and installation guides for applications.