SUMMARY

US Citizen; more than 15 years of IT experience - 12 years as Database Administrator (Sybase 12 years; Oracle 8 years; DB2-luw 2 years). Expertise in all phases of database design, development, deployment and production support; extensive experience in UNIX/Sybase, UNIX/Oracle and UNIX/DB2-luw environments; some exposure to Sybase IQ and MS SQL Server; outstanding problem-solving and analytical abilities; excellent communication and interpersonal skills

SKILLS

Platform: AIX 5.3, 6.1; HP-UX; SUN SOLARIS, Red Hat LINUX 5.2, Window NT Workstation & 2000, XP
Language: UNIX Shell Scripting, AWK, PL/SQL, Transact SQL
Database: Sybase Adaptive Server 11.0, 11.51, 11.92, 12.0, 12.5.X, 15.X; SYBASE IQ 12.5 Oracle 8i, 9i, 10g, 11g; Oracle Data Guard 9i and 11g; Oracle Grid 10g, RMAN, ASM  DB2-luw (UDB) 9.7 (Fix Pack 2); HADR MS SQL Server 7.0/2000
Tools: BMC SQL Backtrack, BMC Patrol, Sybase Central, DB Artisan, ERwin, Oracle GRID,  DB2 Data Studio, Change Management Tools (Remedy, USD, CARS)

PROFESSIONAL EXPERIENCE

Confidential, Franklin Lakes, NJ 2004 – 2011 
Senior Database Administrator
Responsible for developing documentation and strategies, installing, monitoring, tuning, backup and recovery, licensing information, capacity planning, DDL changes and 24/7 production support of Oracle, Sybase ASE and DB2-luw databases; database sizes varied from a few gigabytes to more than a terabyte.

• Developed and implemented plans and strategies for migrating and consolidating Oracle databases from HP-UX to AIX platform; installing Oracle Release 9i, 10g and 11g software; installing and configuring Oracle GRID 10g software; upgrading Oracle databases to 10g and 11g.
• Worked as a lead DBA for planning, installing and implementing first DB2-luw environment at Medco. The installation uses HADR configuration for High Availability.
• Co-ordinated efforts for Hardware Requirements and resolving issues with other groups (UNIX, storage, network).
• Extensively used Oracle Grid, Sybase diagnostic tools and DB2 Data Studio for database performance evaluation, tuning and trouble-shooting.
• Developed and maintained UNIX Shell scripts to perform miscellaneous database administration tasks.
• Assisted in documentation, scripting and maintenance of Oracle Data Guard 9i and 11g installations.
• Monitored usage for license compliance for Oracle, Sybase and BMC SQL Backtrack; assisted management with software licensing issues by collecting, analyzing and presenting required information.
• Developed backup and recovery strategies and documentation for Oracle, Sybase and DB2-luw databases. Also developed and maintained UNIX shell scripts to automate database backups for Oracle, Sybase and DB2-luw databases.
• Developed and implemented plans and documentation for installing, upgrading and configuring the SQL Backtrack software for Oracle and Sybase.
• Prepared documents for installing various critical software Patches for Oracle, Sybase and DB2-luw.
• Interacted with users for setting up user accounts, database options, tables, indexes, views, stored procedures, triggers, and referential integrity for Oracle, Sybase and DB2-luw databases.

For seven years worked at Dun &Bradstreet Corporation. From 1997 to 2002 worked as a Full-Time employee. In August 2002 became CSC employee after Dun & Bradstreet out-sourced the DBA group to CSC.

Confidential, Berkeley Heights, NJ 2002 – 2004 
Database Administrator
Responsible for installing, monitoring, sizing, tuning, maintenance and 24/7 production support of Sybase ASE servers at D&B, Reynolds & Reynolds and Nortel Networks; Server sizes varied from a few gigabytes to more than 250 gigabytes. 
Developed project plans for migrating and consolidating Sybase ASE servers. Also developed plans for upgrading SYBASE ASE 11.X servers to ASE 12.X releases. This was done while supporting Sybase at various releases and different EBF levels). Installed critical Sybase servers with failover feature using HP MC/Service Guard Cluster environment

• Developed disaster recovery plans and procedures for Sybase databases. Also participated in the disaster recovery exercises at the SunGard facilities in Philadelphia and New Jersey for testing disaster recovery procedures by restoring Sybase servers on restored UNIX server machines.
• Extensively used BMC SQL Backtrack for Backup/Recovery and migration of Sybase databases. Developed scripts for logical as well as physical Backup/Recovery using BMC SQL BackTrack software. Also developed migration scripts for moving and/or upgrading ASE servers.
• Interacted with users for setting up user accounts, database options, tables, indexes, views, stored procedures, triggers, and referential integrity.
• Extensively used Sybase diagnostic tools (Optdiag, DBCC, Sysmon) for performance and tuning of ASE servers, memory management and optimizing Transact SQL code.
• Developed and maintained UNIX Shell scripts to perform miscellaneous database administration tasks.
• Also worked as a backup DBA for a Data warehouse project using Sybase IQ 12.5 product in a multiplex environment.

Confidential, Parsippany, NJ 1997 – 2002
Database Administrator II
Responsibilities included Sybase database administration, maintenance and tuning, 24/7 production support. Also participated in design, implementation and maintenance of business database applications

• Created Sybase databases for development, QA and production environments. Created database objects (tables, indexes, views, stored procedures and triggers) from data models and managed user accounts.
• Developed UNIX Shell scripts to perform miscellaneous database administration tasks.
• Developed Back up/Restore procedures for production, QA and development databases using BMC SQL Backtrack software. Installed the Sybase software on UNIX server machines.
• Conducted performance tuning of the Sybase databases using Sybase diagnostic tools (DBCC, Sysmon, Optdiag). Prepared and analyzed show plans for stored procedures; optimized queries and created indexes for improving performance.
• Also worked as a member of the middleware application development and maintenance team. Responsibilities included relational database maintenance, coding and benchmark analysis. Interacted with Sybase 11.X, 12.X, Oracle 8.X and MS SQL 7.0/2000 servers.

Confidential, Parsippany, NJ 1996 – 1997 
Programmer/Analyst; Client: Dun & Bradstreet Corporation, Parsippany, NJ

Confidential., Mahwah, NJ 1989 – 1995 
Engineer

EDUCATION

Master of Applied Science, Engineering
Master of Science, Engineering
Bachelor of Science, Engineering