SUMMARY

• Ten (10) years of IT experience spreading across banking and Insurance Industries in 24X7 environment
• 9+ years of experience in Sybase DBA
• Substantial experience in Banking industry (Foreign Exchange, Transaction Services, Fixed Income and Money Market)
• Installation and configuration of Sybase 11.9.2/12.5/15.0/15.7 in UNIX (Sun, AIX,Linux) and Windows NT 2000.
• Installation and Administration of Sybase Replication Server 12.6 & 15.7
• Strong skills in Sybase ASE, Sybase Replication Server, database installation and administration. Sybase ASE - 15.7 upgrade.
• Supporting for COB TESTS.
• Managed & monitored the Database space issues, refresh, block, log segment space issues etc.
• Database Activities like DBCC, Update Statistics
• Replication server DSI/RS thread down issues.
• Data server / backup server / replication server down
• The Job involves maintenance of SYBASE Database Using UNIX, Database comparator, SQL Capture & DBArtisan (Version 4.02) tool as a third party S/W.
• Taking backup of SYBASE D/B periodically.
• Created major shell scripts at Confidential 's client.
• Received CIO recognition award for creating scripts for automating major tasks.
• Installation of MS-SQL2000
• Providing Level-1 Support for MS-SQL servers.
• Providing Support to The User errors and Issues.
• Creation of Data, Log and Backup devices and user databases
• Creation and management of different NT integrated login permissions for SQL Server.
• Running DBCC commands for checking database consistency and system performance.
• Resolving Log shipping issues.
• Synching data across RDBMS through DTS tool.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Project Manager- Sybase DBA

Environment: Sybase 12.0, 12.5, 15.0.3, 15.7, RS 12.5, 15.7, MS-SQL 2005, AIXLinux & Windows NT, Putty, CTRM, Database comparatorSQL Capture, DBArtisan, UNIX Shell Scripting

Responsibilities:

• Overall single point of contact for all Sybase related issues.
• Created Shell Scripts for monitoring and day-to-day operations.
• Building and installing New Sybase Servers /migrations.
• Sybase ASE -15.7 upgrade.
• Installing Replication server and configuring it.
• Setting up Warm Standby and MSA replication on demand.
• Setting up Table level Replication and maintaining existing replication.
• Troubleshooting inbound/outbound replication queue issues.
• Re-configure replication post data base refresh in non production environnent.
• Handling Replication server DSI/RS thread down issues.
• Support for ad hoc user requests.
• Performance monitoring & trouble shooting of database issues
• Log space full, tempdb space full related issues
• Recovery of a Database by dropping the database by dbcc and recreating the database
• Blocks and Locks related issues
• Extending data, log and user segments
• Dump and load of databases, troubleshooting for Database Objects
• Configuring and tuning the sp configure values
• Data server / backup server / replication server down issues.

Confidential, TX

Lead Sybase DBA

Environment: Sybase ASE 12.0, 12.5, 15.0.3, RS 12.5, MS SQL 2005, Sun SolarisAIX, Windows NT, Putty Release 0.54, BMC Patrol, I-watchVERITAS Cluster, etc

Responsibilities:

• Individual Owner of Sybase servers (Primary Support)
• Support for User requests
• Performance monitoring & trouble shooting of database issues
• Log space full, tempdb space full related issues
• Recovery of a Database by dropping the database by dbcc and recreating the database
• Blocks and Locks related issues
• Extending data, log and user segments
• Dump and load of databases, troubleshooting for Database Objects
• Determining cause of slow response time.
• Configuring and tuning the sp configure values
• Supports for Autosys Job Instances
• Replication server DSI/RS thread down issues.
• Data server / backup server / replication server down
• Building and installing New Sybase Servers /migrations
• Supporting for COB TESTS.
• Managed & monitored the Database space issues, refresh, block, log segment space issues etc on
• MSSQL Server (on both 2000 as well as 2005 version)

Confidential, Warren, NJ

Sybase Server DBA

Environment: - Production/Contingency/Development/Testing

Responsibilities:

• Support for User requests
• Killing of blocked or Hung Processes
• Extending data, log and user segments
• Investigating Connectivity errors
• Dump and load of databases, troubleshooting for Database Objects
• Determining cause of slow response time.
• Configuring and tuning the sp configure values
• Supports for Autosys Job Instances
• Investigating the cause for job failure
• Corrective action on the same
• Action on script generated problem
• Replication server DSI/RS thread down issues.
• Data server / backup server / replication server down
• System segment threshold exceeded.

Confidential

Sybase DBA

Environment: Sybase ASE 15, RS-15, AIX on Cluster, CRT 6.0, Sybase Central

Responsibilities:

• Support for User requests.
• Killing of blocked or Hung Processes
• Extending data, log and user segments
• Investigating Connectivity errors
• Creating devices and databases
• Determining cause of slow response time.
• Configuring and tuning the sp configure values
• Managing Server reboots during cluster reboots
• Database Activities like DBCC, Update Statistics
• Taking Care of Monthly Sybase Server reboots.
• Data server / backup server / replication server down

Confidential

Sybase DBA

Environment: Sybase ASE 12.0, 12.5, RS 12.5, MSSQL 2000, Sun SolarisWindows NT, Putty Release 0.54, DBArtisan 4.0, etc

Responsibilities:

• Monitoring Error logs and taking preventive measure thereon
• Co-ordination with Developers to include modifications in the Database in the form of DDL and DML Changes.
• To perform various administrative activities pertaining to Databases and Performance
• To take and verify the backup of the databases on daily/weekly basis
• To co-ordinate with Datacenter Operators to perform weekly/monthly maintenance
• Creation of User ids for the Users in different applications
• To interact with users to solve performance related problems and ensure smooth Running of system
• Installation of Sybase 12.5.3 Server, Replication Server & SQL Server 2000
• Maintaining SQL Servers, checking Status of DBCC and Update Statistics also
• Database related SQL Jobs.

Confidential

Sybase Support Engineer

Responsibilities:

• The Job involves maintenance of SYBASE Database Using UNIX, MS SQL Server & DBArtisan (Version 4.02) tool as a third party S/W.
• Taking backup of SYBASE D/B periodically.
• First level support to users.
• Administrating Sun Servers.
• Support DBA for Weekend DBCC Jobs.
• Taking Care of Monthly Server Reboots.
• Scheduling SQL Server Jobs.
• Report Generation for Application Team.