Resume 12

ORACLE and SYBASE DATABASE ADMINSTRATION

• 12 years of experience in the IT industry, 8 years of US experience working for Major corporations.

• 2 years of ORACLE experience in installation, configuration, and stored procedure and trigger development using PL/SQL as part of migration project from Sybase to Oracle in Lucent Technologies.

• 10 years of experience in Sybase Database Administration and Sybase backend development, out of which 6 years of experience as a Production support DBA for Sybase Replication between servers that located in different countries and ASE data servers that range in size from 10 GB to 300 GB with maximum of 300 concurrent users in Lucent Technologies and Read-Rite. Done many Sybase server installations, configurations, upgrades, and physical and logical designs on UNIX environment. Spend great extend of time in troubleshooting and performance tuning for better response time and throughput.

• 6 months of experience at Sybase Inc working as Technical Support Engineer for Sybase ASE servers.

• 12 years of experience in all aspect of application development Design, development, implementation and maintenance , Skilled in database administration, data modeling, SQL coding, stored procedure and trigger development, Relational Design, Referential Integrity, Index strategies, SQL Troubleshooting Using Sybase.

• Experience in SCOPUS Bug Tracking System , Clarify, PeopelSoft HR, Manufacturing Bill of materials and Purchase order , Property insurance coverage and Banking applications.

• Also, experience in MS SQL Server administration, Unix Shell scripting, C, COBOL, Perl, Java servlet and HTML.

MS in Computer Application, 1991
St. Josephs s College, TN, India

• Languages:
  SQL, C, COBOL, Unix Shell Scripts, Power Builder, Perl, HTML, Java Servlet, and JDBC

• Database:
  SYBASE ASE 12.5, ASE 12.0, ASE 11.9.2, ASE 11.5.1, ASE 11.3.3 ,Replication 11.5, 11.3 , Oracle 8i, MS SQL server 7.0, 6.5 and IDMS

• Applications Used:
  Scopus, Clarify and PeopleSoft

• Database Tasks:
  Data modeling, Installation, Configuration, upgrade, troubleshooting, Establishing Replication between servers, Capacity planning, Backup and Restore, Corruption and Recovery, Managing login and permission and Performance tuning

• Tools:
  Oracle Migration Workbench, SQL-Backtrack, Platinum - Performance Monitor, Veritas Volume Manager, PowerDesigner, Sybase Central, ERWin and DBArtisan

• Operating System:
  Unix Solaris, HP-UX, AIX , Windows NT 4.0, and TME

• As the only DBA for seven Sybase production servers that range between 10 to 50 GB in size and one MS SQL server, I was responsible for reviewing every object before creating into production server, trouble shooting, performance, user support and backups. Many Scripts developed to monitor Sybase server s various activity using shell scripts, Java Servlet and JDBC.
• Five production servers migrated to new powerful hardware that includes designing physical raw partition, installing and configuring Sybase server and copying the database from old servers to new servers. Replication between these five servers established using Scopus WorldTeam tool. Developed new interfaces utility between CARES and SCOPUS using Unix shell script and Sybase TSQL.
• Deadlocks were the major issue during peak hours, All-Page-locked tables altered to data-only-locked tables to avoid the deadlocks. Parallelism enabled on large tables so that the ad-hoc queries run faster, large I/O pool configured on default data cache for better throughput. On regular basis, the Update statistics ran and clustered indexes dropped and recreated on the All-Page-Locked tables and ran reorg rebuild to reclaim space on Data-only-locked tables. In addition, sp_sysmon ran regular basis to monitor system activity. To reduce the regular dbcc timing and improve the concurrency, dbcc has been running using checkstorage.
• Migrated two Sybase database to Oracle database using Oracle Migration Workbench, that includes installing Oracle 8i dataserver in Unix platform, configuring, creating tables, indexes, stored procedures, triggers and loading data from Sybase database to Oracle database.
• All the production and development servers upgraded to 12.5 from 11.9.2.
• Environment:
  Unix Solaris 2.6/2.8 , Sybase ASE 12.5, ASE 11.9.2 and Replication server 11.5, Oracle 8i, SQL Server 7, NT 4.0, Veritas Volume Manager, Scopus CRM, Perl, HTML, Java Servlet, JDBC , Oracle Migration Workbench, PowerDesigner and Sybase Central

• As a Technical Support Engineer, I was responsible to provide solutions in limited time for the problem reported by clients in the area of server installation, corruption, recovery and performance in multi-platform. Installed and configured all versions of Sybase servers on every Unix OS and Windows NT platform for testing the critical solution that given to the customers later on. Many critical cases involving large production servers from major corporations and government agencies solved. Server bugs reported by clients reproduced and directed to engineering for bug fix.
• More than 250 cases logged by the clients including about 100 of higher priority Cases solved in 6 months time.
• Environment:
  Unix Solaris, HP-UX, AIX and Digital Unix , NT 4.0, SYBASE ASE 12.0, 11.9.2, 11.5.1 and 11.3.3 , Clarify CRM

• As a member of DBA team for five production Sybase servers that ranges from 50 GB to 300 GB in size and replication servers, I was responsible for reviewing every object before creating into production server, trouble shooting, performance, user support and backups.
• Two-way replications established between servers in California and Thailand. Sybase servers upgraded to 11.5.1 and then to 11.9.2 on a new hardware, that includes physical design on SUN storage using Veritas Volume Manager. Replication servers upgraded to 11.5. SQL-Backtrack installed and configured for Day-to-day database backup.
• Many scripts developed to monitor Sybase servers various activities using shell scripts, also replication server manager configured to monitor the health of the replication servers and data servers. A new application developed to archive large tables and track them.
• Installed and configured MS SQL server for new project development. In addition, the schema and data moved from main Sybase server to MS SQL server.
• The database devices created in such a way that the I/O spread across multiple devices. To minimize the I/O bottleneck, the data pages and index pages placed in appropriate segments. To improve the performance of PeopleSoft application, heavily used tables binded to named cache with large I/O pool and tempdb binded to named cache, large I/O pool configured on default data cache to improve the dbcc performance and better throughput. Most of the queries re-written to use the proper index so that the response time is better. Many OLTP application tables altered to Data-only-locked table from All-Page-Locked table for more concurrency. Large tables archived on a regular basis.
• Environment:
  Unix Solaris 2.6 , SYBASE 11.9.2, 11.5.1, 11.3.3 , Replication 11.5, 11.3 , MS SQL server 6.5, NT 4.0, Veritas Volume Manager, SQL-Backtrack, Platinum - Performance Monitor, PowerDesigner, Sybase Central and DBArtisan, PeopleSoft

• As a member of development team, I was responsible for developing many C CT-Library programs involving Unix system calls and Sybase stored procedures for Interface that captures all legacy system financial posting, directs those transactions to either DBS or SAP and ensures that all inter-company transactions are directed to the correct locations. In addition, I was the lead person in integrating all the programs in the interface and performing the beta testing.
• Environment:
  Unix Solaris 2.6 , Sybase 10, C CT-Library , C Shell

• As a member of development team for FMP Forced Mortgage Program Application, I was responsible for EDI/Tapes module. This module reads various format EDI/Tapes files from lenders, validate them and copies them into intermediate tables. In addition, issues coverage, endorsement and cancellation based on the received information and sends back the bills and letter logs to the lenders through EDI/Tapes in various format.
• Responsible for all aspects of the project, including analysis, coding, maintenance, and end user support for this module. Data modeling done by using ERWin. Many C programs, stored procedures, triggers and SQR reports developed for this module.
• In addition, I developed scripts to run dbcc s, update statistics, and monitor the table growth. Every query in this application tested with showplan to see whether the right index used or not.
• Environment:
  UNIX Solaris 2.6 , Sybase 10, APT, C DB-LIB , Power Builder, SQR, Shell Scripts, ERWin

• I was a member of a large team that migrate all IDMS Network DBMS application to Sybase RDBMS. I was involved in designing new logical and physical Sybase database platform from the existing IDMS database, installing and configuring new Sybase server and converting IDBMS COBOL programs to Sybase SQL-COBOL programs by replacing DML verbs to SQL statements.
• In addition, I was responsible to load data into Sybase tables from IDMS schemas. Many COBOL programs written to down load data to flat files from IDMS schemas and many shell scripts written to bcp in flat files into Sybase tables.
• After migration as a member of development team, I was responsible for purchase order and bill of materials modules to study the COBOL programs and develop equivalent stored procedures and 4GL using APT. Many trigger written to enforce the referential integrity. Many on-line inquiries and entries screens developed using APT and reports designed using report workbench. Many C programs written using DB-Library for reports.
• Environment:
  UNIX HP-UX , TMC, Sybase 4.5, APT, Report Workbench, IDMS, C, COBOL, Unix Shell

• As a member of small MIS team, I was responsible to maintain and enhance Inquiry Management System that tracks customer information s, requirements, production schedule and inventory. Many COBOL programs developed for data entry, data down load to export to PC s.
• Environment:
  WIPRO MARK II, UNIX, COBOL

• As a member of development team, I was responsible for General Ledger Module for back office operations of a bank to verify cash balance at end of the day. Developed many ESQL-COBOL programs for cash and bank voucher entry, store them into a table and to print ledgers, trial balance and balance sheet.
• Environment:
  UNIX, ORACLE 5.0, COBOL