SUMMARY:

• Information Technology professional experienced in entire SDLC cycles. Over 10+ years of experience with multiple database systems - MS SQL Server (13 years), Sybase (14 years), Oracle (5 years), Informatica PowerCenter (6 years). Worked with multiple platforms: Unix, Windows, and Linux. Possesses working experience with database design and database management. Heavily interacted with developers/users to diagnose and solve technical issues.
• Experienced in and knowledgeable of performance issues and problem management. Possesses the ability to quickly adapt and master new technology. Excellent communication and organizational skills.

TECHNICAL SKILLS:

DATABASE: MS SQL Server 6.5/7.0/ 2000/20, Oracle 8i/9i/10gv2/11GSybase 10/11/12/12.5/15/15.5

LANGUAGES: Perl, Shell Scripting, C, Java, Visual Basic, SQL

SYSTEMS: HP/UX 10/11.11/11.23, Sun Solaris 2.6, Windows XP/2000/NT/ 98/95/2005/2008

UTILITIES: DB Artisan, ERwin, Power Designer, Lotus Notes, Microsoft Outlook, PC Anywhere, ExceedExcel, Word, Lotus 123, Evault

ETL TOOL: Informatica Power Center 6.2.2/8.1.1/8.6/9.0.1, Microsoft Sql Server Integration Services 2005

JOB SCHEDULERS: Cybermation Espresso 4.5/CA Workload Automation v11.1

MIDDLEWARE: Platinum Infopump

MONITORING: IWatch 4.5/6.0/6.1, Precise 9.0.1, Nimsoft

WORK EXPERIENCE:

Confidential

Consultant - Level 3 MS SQL DBA/Sybase

Responsibilities:

• Administration of existing production SQL Server 2012, 2008, 2005 instances and databases.
• Installed and configured SQL Server Instances on standalone and clustered environments as needed.
• Installed and configured of SQL Server Reporting services.
• Configured and scheduled SSIS tasks.
• Implemented of SQL Server and databases security such as creating logins, users and modifying permissions.
• Performed SQL Server performance monitoring and tuning as necessary.
• Configured and managed high availability and/or disaster recovery processes (Log Shipping, Clustering, Replication).
• Performed SQL environment capacity planning to ensure long and short term sufficiency of resources such storage, RAM and CPU.
• Applied service packs/patches on SQL Servers as necessary.
• Performed server and database maintenance tasks. Monitored jobs and troubleshot issues as needed.
• Created and maintained SQL environment documentation.
• Troubleshot/resolved hardware, software, and network issues working with hosting service provider as required.
• Provided database related support to onshore and offshore development teams and performed code review.
• Hands on with T-SQL coding and familiar with database standards and best practices.
• Worked with third party tools:Quest LiteSpeed for backup compression, Foglight/Nimsoft for performance monitoring, TSM for tape backups

Confidential

Consultant - MS SQL DBA

Responsibilities:

• Created project plan for service pack upgrade for all MSSQL 2008R2 clustered servers. Implemented and performed upgrade. Scheduled changes with effected groups.
• Built SQL Server 2005 and 2008R2 servers in order to move from Sunguard to Ashburn data center.
• Used Precise tool to capture slow running queries. Tuned queries.
• Created new MSSQL 2012 test servers including SSIS, SSAS, SSRS services.
• Troubleshot replication issues. Created new publications and subscriptions between NY and London servers.
• Setup mirroring and log shipping between SQL servers.

Confidential

Project Leader/Senior Database Administrator (MSSQL/Sybase/Oracle)

Responsibilities:

• Managed all database environments (development/QA/production) for Premium Financing/Direct Billing/Life Insurance Funding applications. Involved in technical issues and projects involving administration of MSSQL 2000/2005/2008, Sybase 10/11/12/12.5/15/15.5, Oracle 9i/10G/11G, and Informatica PowerCenter 6.4/8.11/8.6/9.0.1. Includes installation, configuration, optimization, upgrading, performance and tuning, setup of maintenance procedures/jobs, troubleshooting problems, patching, reorganizing tables, monitoring, security setup, backup and recovery, disaster recovery planning, capacity planning and forecasting, conversions from 32-bit to 64 bit platforms. Dealt with Microsoft clustering, replication and log-shipping.
• Improved existing disaster recovery procedures for all production and development servers (MS SQL, Sybase, Oracle) by implementing new procedures based upon acceptable business availability.
• Created and setup security and auditing for all systems as required by Sarbanes-Oxley compliance.
• Organized, planned and discussed with other groups the preparation needs to move database servers from Jersey City to Kansas City
• In-charge of moving production Sybase and MS SQL production servers from Jersey City to Kansas City data center. Verified and tested database servers were operational prior to and after relocation.
• Provided research analysis of third party tools used to monitor Sybase and Oracle production environments. Obtained tool which best fits the company’s needs by providing monitoring without hindering performance.
• Created project plans for all MS SQL/Sybase/Oracle/Informatica server upgrades.
• Met with managers to discuss implementation of new hardware and server upgrades.
• Troubleshot all hardware/software issues (ex. faulty RAID controllers, SAN disk failover failures, faulty RAM disks, upgrade issues, etc)
• In-charge of complex migrations to production and test environments.
• In-charge of platform conversions of Sybase from HP-UX to Linux and Informatica from HP-UX to Windows platform. Converted Data Warehouse databases from Oracle to MS SQL server. Used MS SQL Server Migration Assistant to transfer all objects. Corrected all inconsistencies and problematic areas. Verified all data conversions. Compared target data. Eventually eliminated high priced oracle servers (target) by transferring objects to MS SQL server. Created and managed project plans from projection to implementation.
• Created shell scripts to automate conversions of Sybase QA boxes to DR boxes during emergencies.
• Troubleshot issues with batch jobs related to Sybase databases.
• Setup partitioning strategy to separate less frequently accessed data to disk instead of RAM disk using Sybase Partitioning option.
• Setup data masking of information in development, and testing environments using PowerCenter ETL tool.
• Created and setup daily, weekly, and monthly task lists to ensure 100% uptime of all servers and jobs.
• Created MS SQL server agent jobs to dump/load databases, transfer/zip files, kill processes, optimize databases.
• Wrote, installed and maintained shell/Perl scripts to monitor Oracle tablespaces and Sybase databases for free space. Sent email alerts to DBA and Unix admin groups.
• Created, maintained and updated shell scripts used for server status monitoring, dbcc checks, reorg, and update statistics.
• Worked with developers to create and maintain store procedures and shell/Perl scripts for applications.
• Created shell scripts to automate daily database refreshes of hot databases for QA/development/DR environments.
• Maintained and supported all database administration and monitoring utility scripts and jobs.
• Created shell scripts to synchronize Sybase logins between production and QA/DR servers.
• Provided technical assistance and support to developers.
• Reviewed database design specifications and application coding routines to ensure adherence to the best practices for database usage.
• Analyzed store procedures and application sqls to improve performance.
• Analyzed database growth, space usage, and free space availability on a monthly basis. Forecasted future growth and allocation usage.

Confidential

Lead Sybase Database Administrator

Responsibilities:

• Supported financial market data, news, commentary and e-commerce applications. Managed and administered multiple server environments to support the various functions of the life cycles. Installed and configured Sybase 12.0 servers (on Unix and NT), High Availability Sun clustered servers, and Sybase replication servers, etc. Reviewed and optimized existing store procedures. Created store procedures for various implementations. Wrote shell scripts to automate new releases, migrations, and system administration (DBCC, update statistics, nightly backups, error log checking, etc). Troubleshot database and replication problems. Provided support to the developers in database related issues. Worked closely with System Administrators to setup administrative functions (backups to tape, etc).

Confidential

Lead DB Administrator

Responsibilities:

• Installed and setup MS SQL servers. Optimized configuration parameters. Created database objects: databases, tables, views, indexes, and store procedures. Enhanced referential integrity by creating triggers and constraints. Automated daily backups, maintenance tasks, and weekly load processes. Support production and development environments.
• Maintained and provided weekly refreshes of Data Warehouse environments (on Win NT platform) using java scripts and IBM Visual Warehouse internal scheduling mechanism.
• Created models of all databases and tables using reverse and forward engineering with Platnium Logic Works Erwin.
• s (in Technology):
• Created and implemented a reorganization of entire database environments into: applications (development, test, and production), adhoc reporting (production), and load processing. Implemented Infopump (middleware) for data migration from mainframe to Win NT. Developed and implemented an automated daily data migration from a manual weekly load process.

Confidential

Systems Analyst/DB Administrator

Responsibilities:

• Designed physical and logical databases. Initialized and allocated Sybase devices. Created databases, tables, views and indexes in Sybase. Performed daily backups and maintenance of databases. Migrated data from Sybase to DB2 using Sybase DirectConnect and MDI Gateways. Ensured data integrity between Sybase and DB2.
• Heavy user interface with developers to provide necessary changes to plansetup tables in order to generate new or modify existing fund plans in the Millennium system.
• Developed and implemented a new migration system using Access/SQL/VBA code in a Windows NT environment to automate transfer of data from different environments (development and production). Eliminated the need to use Excel spreadsheets and the manual process of inserting information through Access.
• Developed a Reconcile system using store procedures in Sybase to check the data integrity between DB2 and Sybase environments.
• Created data models of all plansetup, financial, and indicative tables using Logic Works ERwin.

Confidential

Associate Technical Management Analyst/ATMA

Responsibilities:

• Performed cost analysis for projection purposes and analytical research. Generated reports on construction usage in the railroad system. Provided information and prepared reports for studies on degradation and quality of construction. Produced inventory, variance, employee availability reports to upper management.
• Heavy user interface with contractors, manufacturers, and in-house personnel to review quality control and maintain high level of standards and integrity of construction projects.
• Developed and implemented programs using Visual Basic and SQL/Access in a Windows environment to provide an inventory of data in computerized inspection areas.
• Developed Visual Basic applications for users to capture material expenditures and labor costs related to each on going construction project.
• Used Excel and Harvard Graphics in a Windows environment to provide feasibility studies and quality control reports to upper management and other departments. Reports were also used to determine future construction sites.
• Developed several databases in Dbase to store information concerning inventory of material and location.