SUMMARY:

Delivering high quality technical and management services to the banking industry for over 20 years. Proficient in all aspects of technical staff managementdatabase and system design, architecture, analysis and implementation of client server based applications. Strong database administration skills in SybaseOracle and MS - SQL server with special proficiency in SYBASE ASE and Repserver fine-tuning, migration and upgrades, physical / logical database designsecurity, development, implementation and installation. Heavily involved in homogeneous and heterogeneous database replication. Successfully managed critical and highly visible projects as a senior technical team lead. UNIX system skills with experience in system and hardware integration on a variety of UNIX platforms. Lead various DR/BC projects by conducting and leading disaster recovery drills utilizing various technologies

TECHNICAL SKILLS:

Databases: Sybase ASE11.x -15.7, MS SQL 6.5, 7.0, 2000, Oracle 10/11g,UDB

Big Data: Hadoop (), SAP sybase IQ

Data Movement: Sybase Replication Server (11.x - 15.x), OpenSwitch, DirectConnect / Enterprise Connect Data Access, CIS, ETL - Informatica, SRDF, Oracle Migration WorkBench

Hardware: Various SUN / HP platforms ranging from large servers to EMC SAN,Enterprise Servers, StorageTek RAID (Redundant Array of Independent Disks)

OS: UNIX SUN Solaris, RedHat/SuSe Linux, AIX, HP-UX 9.x, MS-Windows

Software: C, SQL, UNIX shell (sh,csh,ksh), Perl

DBA Tools: DBArtisan, Quest Central, Cyrano, Autosys, SQL Backtrack, BMC Patrol,CAST Workbench, iWatch, BMC Patrol

Tools: Open Client 11.1.1 - 15, DB-Library / C, ESQL / C, awk, sed,perl, Pig, Hive, sqoop (Hadoop)

Workshops: Oracle Database 10g: Administration Workshop 1 & 2

PROFESSIONAL EXPERIENCE:

Confidential - New York

SYBASE DBA / architect

Responsibilities:

• Worked on SAP ASE database upgrade (RHEL Linux) and redesign of various credit risk applications ( running on SAP Sybase and Oracle)
• Defined road map and strategy of upgrading the obsolete platform to the latest version (SAP ASE 15.7) utilizing various types of regression tools
• Redesigned overnight back office processing to achieve optimal performance
• Involved in researching new technologies to be utilized as alternative platform for existing applications e.g Hadoop / SAP Hana
• Involved in database resiliency project
• Gave technical presentations to business management as well as developers

Confidential - New Jersey

SYBASE DBA / Database Lead

Responsibilities:

• Incident management calls - presented application teams with recommended solution based on root-cause analysis and troubleshooting of the incident
• Took part in co-ordinating bi-yearly business continuity exercises and achieved success in meeting the simulated disaster recovery goals
• Working closely with senior management of various departments like FICC, Equities, Legal, Compliance, IT infra-structure to define application support SLA’s
• Act as the technical lead in recommending solutions to improve enterprise level monitoring
• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access
• Worked on “SAP ASE exit” project involving dismantling of dataservers and infrastructure e.g hardware, monitoring system and maintenance jobs
• Provided Oracle DBA support which mainly involved Oracle database management and monitoring of 10/11g and 12c Grid Control
• SAN storage architecture knowledge including enterprise SAN storage capacity planning of different tiers of SAN

Confidential - New Jersey

Datacenter Migration lead (SYBASE)

Responsibilities:

• Technical lead role with 150 clients and data center migration project with IBM which involved migrating existing100+ sybase dataservers to new hardware (AIX). Also involved in day-to-day performance and tuning issues, incident management and replication server support. Additional duties included enhancing existing DBA monitoring and alerting utilities (in-house / third party).
• Successfully migrated sybase dataservers from AIX to Linux platform
• Improved throughput of badly performed queries by fine-tuning the Sybase server(s) with the help of collected monitoring metrics
• Evaluated DBA tools like Quest Central, Sybase Control Center and DBArtisan
• Communicated with IBM resources on regular basis and brought up and resolved any infrastructure related issues

Confidential - New Jersey

Senior SYBASE Technical Lead / DBA

Responsibilities:

• Achieved success as a senior technical lead in the Asset and Wealth Management group. Services included production support of very highly visible and crucial applications.
• Data center migration projects involving dataserver / repserver migration (Solaris/Linux) and patch upgrades.
• Worked as SME n various levels of performance and fine-tuning of databases, disaster recovery and business continuity of database servers.
• Worked on high availability POC utilizing a combination of OpenSwitch, replication servers and log mirror
• Supported a complex (24x7) global heterogeneous database environment running on SAP ASE, UDB and Oracle databases on UNIX/Solaris platform and EMC SAN storage in a Veritas Clustered environment
• Supervised offshore support team, provided documentation on start-up, shut down and first level troubleshooting of processes
• Successfully managed ASE migration project running on UNIX using the quiesce / mount db utility (to minimize downtime)
• Bridged (technical) gap between infrastructure and development team by holding technical presentations and discussions
• Designed complex heterogeneous data replication utilizing SAP replication server (previously known as DirectConnect Sybase Sybase, Sybase UDB, Sybase MSSQL and Sybase ORACLE)
• Workeded closely with Change management, Risk Management groups to establish a SOX compliant environment. Also developed “custom utility” generating a variety of daily / weekly / monthly “foot print” reports
• Implemented Automated Security procedures across DBMS to ensure compliance with security standards (especially on password policies)
• Worked with infrastructure team (NetBackup) to implement db backup retention policies and procedures to comply with the SOX / SEC standards
• Liaised with the Unix (Veritas VCS) and SAN storage (SRDF/device allocations) teams to sort out any issues affecting the database performance
• Lead Disaster Recovery (DR) simulation exercise which mainly involved EMC’s SRDF technology along with “DNS push” and making dataservers / repservers fail over to the "DR-node" with the help of Veritas Clustering Service (VCS)
• Lead the data center migration project (mainly via SRDF) to a new consolidated UNIX/Solaris hardware ncident and problem management - successfully tracked and put closure on all the issues/ bug fixes (post migration) with various vendors

Confidential - New Jersey

SYBASE Senior DBA Lead / Offshore Manager

Responsibilities:

• Performed hands-on technical lead & senior DBA duties in a global group of 22 DBAs (2 Dublin office; 5 offshore) with 300 + servers / 5000 dbs. Primary lead contact for the Equities & Asset Management group (PORTIA,LongView). Involved in initiating the offshore project (full life-cycle). Managing offshore DBA team in India. POC work on OpenSwitch. Performance and tunning of ASE and Replication Servers, problem solving & project management
• Worked very closely on failover management utilizing UNIX Clustering. OpenSwitch, Replication MSA technologies
• Performed wide range of DBA tasks in supporting Murex on sybase dataservers
• Performed fine-tuning activities on Murex dataservers including configuration and binding of user named caches, larger I/O pool configuration of the transaction logs, moving tempdb devices to swap-based devices, changing tables from APL to DOL locking scheme ( to reduce locking contention )
• Supported and maintained weekend maintenance schedule on the Murex dataservers mainly to do with running reorg rebuilds and update stats on mission critical tables, utilizing parallelism
• Involved in migrating ASE servers from Sun solaris to (RedHat) Linux enviroment (using XPDL)
• Conducted / ironed out Linux failover issues utilizing Linux Clustering
• Maintained and fine tuned replication server environments (Warm Standby & MSA- ver. 12.6)
• Took a lead part in the SAN migration project which involved moving 100 ASE servers to the new EMC ( DMX) storage solution.
• Involved in offshore project initiative (complete life cycle). This involved defining project scope, SLA/SLO, maintaining corporate security, process documentation, standardization and (on-site) offshore dbas
• Successfully migrated Sybase to Oracle utilizing Oracle migration WorkBench

Confidential - New York

Sybase DBA

Responsibilities:

• Performed Senior Sybase DBA duties in a team of 8 DBAs (3 offshore) with 200 sybase servers in Credit Derivatives / Fixed Income group. Providing 24x7 support to back office and front office applications, upgrade to current Sybase version 12.5.1(2), performance and fine - tuningtroubleshooting, backup and recovery
• Maintained Warm-Standby configuration using Sybase Replication Server (12.0) for DR site
• Maintaining backup and recovery using bmc SQLBackTrack
• Currently evaulating Sybase monitoring tools Quest Central ( Spotlight, SQL Tunning ) and bmc s DbXRay
• Installed and tested sybase s advanced security feature (licensed product: SSL) in ASE 12.5.2
• Successfully conducted business continuity test by failing over to DR site(s)

Confidential - New York

Sybase DBA / Unix Administrator

Responsibilities:

• Responsible for supporting Sybase / MS SQL and UNIX systems used by the Investment Banking. Duties include physical and logical design, configuring and implementation of very large Sybase database systems. This includes supporting 60 production and development servers with the average database size ranging from 5 - 25 GB. Managing data replication to Sybase / Oracle Servers through Sybase Replication Server / DirectConnect. Providing day to day UNIX support to end-users, troubleshooting and OS upgrades on SUN hardware.
• Migrated Sybase 11.9.2.3 to 12.5.0.3 leveraging warm standby feature of the replication server. Replication flow 12.5.0.3 to 11.9.2.3 for failover purposes
• Worked as Project Manger / DBA for datacenter migration. This involves migration of 15 SUN Solaris / Sybase Servers to a different datacenter
• Successfully managed and lead disaster recovery project during Sept. 11th by efficiently rebuilding contingency Sybase / Replication Serverstroubleshooting corrupted databases / master dbs, provided technical support to the users and met all deadlines and deliverables
• Involved with architecture, design and implementation of state of the art database systems in production environmet e.g configuration of 8 Sybase
• Server engines on a SUN E10K (running clustering s/w) with 64 cpus and 58 GB of RAM
• Installation, configuration and administration of MS SQL server 6.5, 7.0 and 2000
• Migrated development and production database servers from 11.9.2 to 12.0.0.4
• Using Sybase DirectConnect (12.0), managed and configured data replication to Oracle(8i) / MS-SQL server
• Assisted data engineering group with testing the new features of the latest Sybase versions
• Assisted developers with writing efficient SQL scripts and troubleshooting the SQL scripts