SUMMARY

• 7+ years of experience in DATABASE ADMINISTRATION with extensive exposure in administration of Sybase Adaptive Server Enterprise 11.x, 12.x, 12.5.x, 15.0.2, Sybase Replication Server 12.5 and 12.6 on Sun Solaris and Windows 2000 Server Environment. 2+ years of experience in SQL server 2008 and 2012.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 2.6 & 2.8, AIX UNIX 4.3.2Windows 2003 Server,Windows XP,Windows Vista

Rdms: Sybase 11.x, 12.x, 12.5.x,15

Distribution Technology: Sybase Replication Server 12.x

Database Admin Tool: DB Artisan 7.0,Iwatch, sqlbacktrack

Front - End: Power Builder 5.0

Scripts: Unix Shell Script

Scheduler: Autosys, Dattool (Third Party tool)

Hardware: Sun Ultra Spark Server, Sun blade PCDell System

PROFESSIONAL EXPERIENCE

Confidential

Sybase DBA Support

Responsibilities:

• Monitoring cron jobs and fixing errors if any.
• Backing up and loading Sybase user databases.
• Performing end to end database refreshes.
• Investigating server access problems - user connections, locks etc.
• Investigating performance of servers and queries - syslogshold, sp showplan etc.
• Investigating replication problems - thread down, stable queue filling up, hung rep agent, synching up warm standby etc.
• Monitoring and fixing replication and latency issues.
• Assisting users - object and space management, new logins, code evaluation, query structuring/optimization, data migration, database design/normalization etc.
• Documenting ASE and replication scenarios to quicken response time during production problems.
• Monitoring server shutdown and startup during maintenance.

Confidential

System Analyst

Responsibilities:

• Installation/upgrade of adaptive servers.
• Creating Devices, Databases, Tables, Indexes etc.
• Setting up backup and recovery procedures - capacity planning, compressed dumps etc.
• Investigating failed jobs - dbcc corruption and dump errors.
• Investigating server access problems - user connections, locks etc.
• Investigating performance of servers and queries - syslogshold, sp showplan etc.
• De-fragmentation of huge tables for space recovery in databases.
• Designing and setting up replication systems - Warm Standbys, Bi-directional etc.
• Investigating replication problems - thread down, stable queue filling up, hung rep agent, synching up warm standby etc.
• Creating/altering replication definitions and subscriptions.
• Assisting users - object and space management, new logins, code evaluation, query structuring/optimization, data migration, database design/normalization etc.
• Documenting complex replication scenarios to quicken response time during production problems.

Confidential, Raleigh,NC

Database Administrator

Responsibilities:

• Installation/upgrade of adaptive servers, replication servers.
• Creating Devices, Databases, Tables, Indexes etc.
• Setting up backup and recovery procedures - capacity planning, compressed dumps etc.
• Investigating failed jobs - dbcc corruption and dump errors.
• Investigating server access problems - user connections, locks etc.
• Investigating performance of servers and queries – syslogshold, sp showplan etc.
• De-fragmentation of huge tables for space recovery in databases.
• Designing and setting up replication systems – Warm Standbys, table level etc.
• Investigating replication problems – thread down, stable queue filling up, hung rep agent, synching up warm standby etc.
• Creating/altering replication definitions and subscriptions.
• Assisting users – object and space management, new logins, code evaluation, query structuring/optimization, data migration, database design/normalization etc.
• Documenting complex replication scenarios to quicken response time during production problems.

Confidential, Boston, MA

Sybase Database Administrator

Responsibilities:

• Installation/upgrade of adaptive servers and Replication Servers.
• Setting up backup and recovery procedures – capacity planning, compressed dumps etc.
• Investigating failed jobs – dbcc corruption and dump errors.
• Investigating server access problems – user connections, locks etc.
• Investigating performance of servers and queries – syslogshold, sp showplan etc.
• Designing and setting up replication systems – Warm Standbys, Bi-directional etc.
• Investigating replication problems – thread down, stable queue filling up, hung rep agent, synching up warm standby etc.
• Creating/altering replication definitions and subscriptions.
• Assisting users – object and space management, new logins, code evaluation, query structuring/optimization, data migration, database design/normalization etc.
• Writing scripts to automate jobs and tools to increase productivity in the team.
• Oracle work involved working with two development databases - setting up of instance, creating tablespaces, creating of users (schema), creating objects, granting permissions for objects, synonyms

Confidential, Jersey City NJ

Sybase Database Administrator

Responsibilities:

• Installation/upgrade of adaptive servers.
• Creating Devices, Databases, Tables, Indexes etc.
• Setting up backup and recovery procedures – capacity planning, compressed dumps etc.
• Investigating failed jobs – dbcc corruption and dump errors.
• Investigating server access problems – user connections, locks etc.
• Investigating performance of servers and queries – syslogshold, sp showplan etc.
• De-fragmentation of huge tables for space recovery in databases.
• Designing and setting up replication systems – Warm Standbys, Bi-directional etc.
• Investigating replication problems – thread down, stable queue filling up, hung rep agent, synching up warm standby etc.
• Creating/altering replication definitions and subscriptions.
• Assisting users – object and space management, new logins, code evaluation, query structuring/optimization, data migration, database design/normalization etc.
• Documenting complex replication scenarios to quicken response time during production problems.