SUMMARY:

• 21+ years of experience as Sybase(15,12.5,12,11.9.2,10,4.9.2)/ Sybase Replicatiion(12.6,15.x) including RepAgents for Oracle/ ASIQ(15.2) Oracle DBA (9i,8i and 7.x)/MS SQL Server 6.5/7/2000 DBA/ Database Architect / System Analyst on SUN Solaris and Windows NT/2000.
• Participated in several ASE 15 upgrade effort on Solaris and Linux platform as team member. Familiar with ASE new features including new query processing, encryption, enhanced update statistics, user defined functions, mixed workload.
• Experience of Performance Tuning i.e. Tuning applications, shared pool, buffer cache, I/O distribution, rollback segments, redo mechanisms, stored procedures, triggers & functions.
• Implementation, Customization and Developments of Database.
• Experienced in Disaster Recovery.
• Proficient in Sybase DBA - Installation of Sybase Server, Designing & Testing of database, setting up replication, CIS, proxy tables, mda. Administration, Backup & Recovery Strategy using SqlBacktrack and netbackup. Implementation according to the volatility of the data, Create and manage Database Users, Performance Monitoring/Tuning & DB Security.
• Proficient in Sybase ASIQ(12.6/12.7) - Installation of Sybase ASIQ, Designing & Testing of database. Administration, Backup & Recovery, Create and manage Database Users, Performance Monitoring/Tuning & DB Security.
• Proficient in ORACLE DBA - Installation of Oracle Server, Designing & Testing of database, Administration, Backup & Recovery Strategy Implementation according to the volatility of the data, Create and manage Database Users, Performance Monitoring/Tuning & DB Security.
• Proficient in MS SQL Server 2K DBA - Installation, Administration, Backup & Recovery Strategy, Script to retrieve object information, Run the DBCC, DTS packages, Import and export, Maintenance plan, Link the server, Stored procedure, Database Trigger, Performance Monitoring/Tuning and Database Security.
• Experience in planning & implementation of Backup & Recovery strategy, used physical & logical backup using Exp./Imp.
• Warm standby Sybase Replication Server setup including table level replications between NY, London, Sydney, Hongkong and Singapore..
• Backup using SqlBacktrack and Netbackup tools.
• Production databases used Oracle's Standby Database feature for failsafe recovery.
• Database Application Design and Development.
• Experienced in tuning SQL statements.
• Created audit purge scripts for Sybase Audits.
• Writing Shell Scripts for managing day-to-day transactions.
• Implementing the Oracle Parallel server Database.
• Currently planning Oracle 9i upgrade for 20 test, development & production databases.

PROFESSIONAL EXPERIENCE:

Sr. Sybase Consultant

Confidential

Responsibilities:

• Responsibilities include support/upgrade/maintain Confidential & Confidential Services ASE and IQ and Sybase Replication production servers.
• I am part of global production support team where we provide 1st and second level support under follow the sun model.
• Setting up data replication between Oracle to Oracle using Sybase replication as Confidential was considered too expensive for the company.
• Working on replication from ASE 15 to Sybase IQ 15.2 using Sybase replication 15.5.

Sr. Sybase Consultant

Confidential

Responsibilities:

• Responsibilities include support/upgrade/maintain 60+ Confidential & Confidential Services ASE and IQ and Sybase Replication production servers.
• Upgrading 15TB IQ data warehouse to IQ 15.2 from IQ 12.6.
• Performance tuning of Confidential trading system using tempdb segregation and sql code enhancement.
• Involved in various ASE 15 upgrade project where there are 4 way data replication using routes.
• Adding an additional replicated site is being used as back out plan. Install and configure patrol agent on all the production servers for monitoring.
• Represent DBA team in Cross technology Group, where any production impacting issues are discussed and provide input from DBA prospective.
• Work with application developers in query optimization and tuning.
• Support various data load jobs to IQ servers.

Sr. Sybase Consultant

Confidential, NY

Responsibilities:

• Responsibilities includes support/upgrade/maintain a complex Sybase database/replication hub environment with 1000+ down streaming clients.
• Sybase Replication Server(12.6) is setup to distribute the live feeds via DSIs to 1024 global down streaming clients simultaneously.
• The downstream clients consists of Sybase ASE, Oracle 9i, 10g, 10g RAC, SQL servers and DB2 mainframe.
• Down streaming connectivity to Non-ASE clients is achieved via Confidential (12.6) and proxy database.
• Connections to SQL servers and DB2 clients is achieved via odbc and Confidential .
• Migarted heritage Bear Stern’s 10 ASIQ servers in to JP Morgan infrastructure. Implemented Control-M jobs for daily backups. Automated dataload and optimization. Revisited the database objects and indexes for optimal performance.
• Provide DBA support to Exotic & Hybrid Application.
• Maintain and support 8 ASE 12.5.4 dataserver on a 4 node Sun cluster Sun-Fire-15000.
• Monitor and review the nightly and weekend database maintenance job logs such as backups, reindex, update statistics etc.
• Monitor and report the hardware and disk space usage for database servers. Recommend the future space growth based upon database growth.
• Installed Sybase audit and provide audit reports to internal auditors on a regular basis.
• Work with application developer in optimizing their sql codes.
• Re-visit ASE configuration by running sp monitorconfig and recommend optimized configuration.
• Perform database reorg on quarterly basis based upon findings from optdiag output.
• Implement and monitor database monitoring for syslogs, locks, blocks etc.
• Maintain and provide support for UAT and development environment. Manage a database backup repository from where users can refresh the UAT or development databases via a self-help website.
• Working on migration/upgrade of Exotic & Hybrid server to a M5000 Solaris server and ASE 15. Participated in POC and performance testing in UAT environment.

Sr. Sybase Consultant

Confidential, NY

Responsibilities:

• Responsibilities included support/upgrade/maintenance of 50+ Sybase/Oracle/SQL200 dataservers on SUN/Solaris clusters and Windows 2000, including 17 production servers.
• Provided Primary DBA support to Fixed Income and Forex Trading system application of Confidential .
• Worked with development teams in New York and Singapore in migrating Global Foreign Exchange system from MSSQL to Oracle 9i.
• Setup three way Sybase replication between New York, London and Singapore security processing systems using routes, replication definitions and subscriptions.
• Managed and coordinated global ASE 12.5.3 upgrade and Replication Server 12.5 upgrade project for Securities processing group. Worked with DBAs across the globe to develop migration strategy for development, UAT and production servers.
• Revisited ASE setup and configuration parameters of dataservers earlier upgraded by provisioning team. Suggested the optimized configuration to utilize the hardware and OS resources which improved the server response time drastically.
• Managed and coordinated NT elimination and Windows 2000 migration project at Confidential on time.
• Worked as a team member during several DR simulation test and data center power down projects.

Sr. Sybase Consultant

Confidential, Rutherford, NJ

Responsibilities:

• Responsibilities include maintenance of 60+ Sybase/oracle/SQL200 dataservers on SUN/solaris platform and Windows 2000, including 23 production dataservers.
• Setup/support the Replication server environment to maintain the warm backup of Accounts and Products database using WAN. Warm backup machine is being used by the TnP clients as dss and also for batch extraction during night. Wrote scripts for replication definitions and subscriptions.
• Fine tuned the replication server for memory, trace flags and others. Setup the online disksuit for unix level mirroring of stable queue disks.
• Participated in the system 11/Y2K migration work. Performed the conversion of dataservers from 4.9.2 to system-11. Ported the stored procedures to system-11. Fine tuned the the sybase system-11 using the new features of system-11 such as cache memory and partitioned tables, network packet size and others.
• Worked on upgrading 60 Sybase servers from 11.9.2 version to 12.5.03 and migrated all the applications to EMC - SRDF using SAN.
• Enabled Sybase audit on all the production and UAT servers, developed scripts to purge, archive audit data. Worked with application team to develop the front end to review the audit data.
• Installed MDA on Sybase 12.5 server, collected and analyzed the data and recommended performance enhancements to Unix Engineering.
• Currently working on server consolidation project to migrate applications to fifth-generation fault-isolated dynamic system domains on SUN 15K server with full hardware redundancy, more than 1/2 TB memory in a single domain.
• This environment will have hot-swappable uniboard CPU/Memory boards, I/O, MaxCPU boards, power and fans. This pilot project will first migrate the in house and back office applications.
• Support a global reporting systems which tracks the fixed income trading activity. Installed and maintain table level sybase replication between NY, London, Sydney, Hongkong and Tokyo servers. Constantly working with application development team to optimize the sql queries and optimizing the server configuration so that all 5 sybase servers perform at optimum level.
• Participated in the development of a financial application known as Transaction & Position. The application maintains the books and records of Salomon Smith Barney for its back office. The systems retrieve the trades from TES and mainframe systems. The system is used as a common interface for the functional database transaction and position posting and to distribute real-time data from the functional database. The trades are stored in different queues on sybase dataserver depending upon its origin. Then the messages are converted and stored in Transaction and Position databases. It also maintains the accounts and products of Salomon Bros.
• As a team member designed and developed Clearance and Settlements Distribution System to support the transportation of data to and from the Clearance and Settlement functional database. The system is used both as a common interface for the functional database transaction and position posting and to distribute real-time data from the functional database. The system is developed in C++ using Sybase as a queuing and transport mechanism.

Sr. System Engineer

Confidential, West Greenwich, RI

Responsibilities:

• Design and developed various applications for Confidential 's worldwide offices and its service departments.
• The applications were used to report sales data for lotteries, keep track of hotline calls for service calls, repairs, inventory, out of box testing. Sybase 4.8 and Jayacc Confidential were used for developing the applications.
• I also wrote db - library routines used by unix daemons for doing nightly updates and indexing and data dumps. I am also involved in performance tuning, system integration (SUN Spark Stations 2/10), installing SunOS 4.1.3 Sybase 4.9.1, monitoring the system usage, drive usage, performing nightly load using SQL Backtrack, developing backup and recovery strategies for our inhouse development system as well as for our client sites, maintaining the staging, qa and production source code for our developers, customizing the Sybase configuration for memory, number of connections, number of users, etc.
• Writing unix scripts using c shell and isql to eliminate manual operations of tape dump, bcp and indexing. Wrote various reports using SQR.

Consultant

Confidential, New York, New York

Responsibilities:

• Design and developed application using Sybase as the back-end and Confidential as the front-end application.
• Project involved Freight forwarding and Accounting (A/R, A/P, G/L) and involved heavy Stored procedures and DB-LIBRARY interface.
• Also was involved in System Administration duties.
• Design and developed Shipment Management System ( S.M.S ) for a trucking company in SUN OS and Xwindow environment.

Systems Engineer

Confidential, New York, New York

Responsibilities:

• Design and developed Medical Billing Systems for many reputed hospitals in the tri-state area using Informix and File-Pro database system.
• Also involved in writing special application to work with Laser Printers to invoke customized forms at will and overlaying data on top of the desired form.
• Front-end application involved Informix/4GL and Confidential .