Resume 7

To obtain a senior Sybase DBA position in a progressive company.

Languages: Ksh, Csh, Perl, Sed, Awk, C, C++, Java, VB5.0, Fortran.

Database Management Systems: Sybase ASE 11.x, 12.x , Replication Server, T-SQL, Open Client / ODBC/JDBC, Power Designer 8; Informix Online Server 7.x; Oracle 8, 8i: PL/SQL.

Operating Systems: Unix Solaris, HP-UX, Linux , Windows 95/98/2000/NT 4.0 Server/Workstation , DOS.

Networking: TCP/IP

Web Development: IIS 4.0, ASP, HTML, CGI, Java Script

• Installed eight new Sybase ASEs version 12 and upgraded three ASEs to version 12 from 11.x. Set up user PCs and Unix application servers connections to ASEs.
• Wrote shell and SQL scripts and setup cron jobs for checking Adaptive servers availability, backup of databases and crucial system tables, nightly batch jobs for data transfer from Informix to Sybase servers, synchronizing syslogins tables among different servers, refreshing the same database in test server with production data.
• Monitored server performance, database and transaction log growth and error logs.
• Tuned ASEs on case-by-case basis such as adding indexes, data and procedure caches, allocating segments, partitioning big tables, optimizing SQL statements, etc.
• Performed disaster recovery for a production database which went offline after the server was moved to a new Sun box. Recovered a testing server after accidentally deleting all its syslogins entries including sa login.
• As the only DBA, supported nine developers for various projects such as database logical design for new applications ER diagram, primary, foreign keys, etc , building data warehouse, creation and population of daily work tables out of huge tables for faster data retrieval. Responded to user requests and resolved server issues.
• Administered three Informix On-Line Server 7.x. using dbaccess, onstat, onmonitor, load, unload, dbimport, dbexport, dbschema. Moved Informix production server to a new unix sun box. Migrated an Informix database from a development server to a testing server. Setup daily cron jobs to unload Informix data and load into Sybase server. Added more chunks to temp dbspace, resolving a slow server response issue.

• Provided production support as Sybase Primary, resolving requests or problems raised by application groups in various business clusters, and coordinating with Command Centers, Legato primary, Unix Primary, Replication Primary, etc.
• Administered replication servers LTM, DSI, heartbeat, Partitions, Stable Queues, Secondary Truncation point, Connections, Synchronization, etc .
• Monitored Sybase ASEs on SUN unix hosts via the monitoring tools: Tivoli, PCM problem change manager and Mail Tools, as well as on NT with Sybase Central.
• Diagnosed and resolved server problems using the monitoring tools, relevant error logs, scripts, stored procedures, internal web documents and Sybase support.
• Involved in Sybase server migration from version 11.0.3.3 to 11.9.2.1.

• Installed, upgraded, and configured Sybase ASE11.x and replication servers on Sun Solaris and Windows NT.
• Created databases, managed storage device, fragment, segment, threshold , and administered security role, login, user/alias/group, object/command permissions .
• Monitored and troubleshooted Sybase ASEs using server messages, ASE error logs, backup server logs, system procedures, DBCCs, threshold manager, etc.
• Performed backup and recovery recovery of master/user databases and master device, server rebuild, Up-to-the-Minute Recovery, Point-in-Time Recovery, etc.
• Tuned ASEs for performance from different levels i.e. system level, application level, server level using various approaches memory, indexing, locking, object placement, table de normalization, SQL design, and other server configurations .

• Created databases in the development, test, and production servers.
• Authorized Sybase SQL server users and granted permissions to them.
• Managed and monitored the use of disk space, database space, CPU, memory, cache, and user connections and processes.
• Implemented procedures for backup and recovery of production servers.
• Developed various procedures and shell scripts on HP-UX platform.
• Transferred large quantities of data in and out of Sybase SQL server databases.

Used C , FORTRAN, dBase III to manage and analyze various data of measurement and technical specifications.

RUTGERS UNIVERSITY
MS Dept. of Computer Science

NANJING UNIVERSITY
BS Dept. of Earth Science