Sql Server Management
Resume:
KEERTHANAA PALANIAPPAN
*+ 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.
PROFESSIONAL SUMMARY
Tata Consultancy Services – (Aug 2010 till Aug 2012)
Sybase DBA support to Humana Inc. from Chennai.
Env: Sybase ASE 15; ASE 12.5 Replication Server 12.6
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.
●
Royal Bank of Scotland (Jan 2010 to July 2010)
Anaylst DBA Chennai.
Env : Sybase ASE 15; ASE 12.5 Replication Server 12.5/12.6;
Addition to the dba duties and responsibilities was part of the Centre of Excellence team giving
consultations to the other Sybase dba teams when required.
Completed ITIL training for best practices.
UST GLOBAL (Apil 2009 to Jan 2010)
System Analyst Chennai.
Env : Sybase ASE 15; ASE 12.5 Replication Server 12.5/12.6; SQL server 2000,SQL server 2005
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.
●
Credit Suisse (Nov 2008 to March 2009 date)
Database Administrator Raleigh,NC,USA
Env : Sybase ASE 15; ASE 12.5 Replication Server 12.5/12.6; SQL server 2000,SQL server 2005
Role: Production Support on Sybase ASE and replication servers, SQL server databases across different
business unit being part of Centre of excellence dba team.
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.
●
FIDELITY INVESTMENTS (Dec 2005 to Nov 2007)
Sybase Database Administrator Boston, MA
Env : Sybase ASE 12.5; Replication Server 12.5/12.6; Oracle 9i,10g
Role: Production Support on Sybase ASE & Sybase Replication Servers, Oracle 9i and
10g application support. Taken ownership in maintaining the critical databases, trouble
shooting, performed migration of old versions, DR tests and recovery.
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
WIPRO TECHNOLOGIES (Jan 2003 to Dec 2005)
Sybase Database Administrator Lehman Brothers, Jersey City NJ
Env : Sybase 12.0.x/11.0.x; Replication Server 12.x
Production Support on Sybase ASE & Sybase Replication Servers for
Role:
Lehman Brothers, USA.
Description: Production Support for Sybase ASE Servers and Sybase Replication Servers.
Lehman Brothers, an innovator in global finance, serves the financial needs of
corporations, governments and municipalities, institutional clients and high net worth
individuals worldwide. Majority of Lehman applications implemented on Sybase Servers.
The numbers include around 400 Sybase servers and 50 replication servers. A team of
20 DBA’s work round the clock to meet the client requirements.
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.
●
TECHNICAL SUMMARY
Operating Systems : Sun Solaris 2.6 & 2.8, AIX UNIX 4.3.2,
Windows 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 PC,
Dell System
Education
● Bachelor of Engineer in Computer Science
Contact
Email: **********.******@*****.***
Contact this candidate