SUMMARY:

• Over Seven (7+) Years of IT experience in installing and maintaining Sybase ASE and Sybase Replication server in Critical Production Environments wif Stringent SLA’s.
• Experience in Upgrading Sybase Servers, Creating database and devices, Database Maintenance activities, database monitoring
• Error log monitoring, Backup and recovery, Permissions and security, Auditing in L1, L2 and L3 Support in Production, Development and QA environment
• Administration of Sybase ASE across different flavors of Unix.
• Administration of DB2 UDB across different flavors of Unix.
• Experience in Installation, Maintenance and Support in SQL Server 2005 and 2008
• Administration of MSSQL Server databases.
• Proficient in handling Sybase, SQL, and DB2 databases
• Installation and Configuration of Sybase ASE Servers.
• Upgrade of the servers across different versions of Sybase.
• Upgrade of Sybase servers from 12.x to 15.x.
• Performance tuning and Query optimization on ASE 15.x
• Production Support Experience in Administration of Sybase/MSSQL Servers.
• Installation and configuration of Sybase Replication Server.
• Experienced in performance and tuning of Sybase ASE.
• Point - in time recovery of databases
• Well-versed in recreating the Sybase database wif all data intact using bcp utility
• Proficient in troubleshooting issues like database corruption in Sybase databases
• Experienced in creating and debugging stored procedures and triggers in Sybase and SQL databases
• Skilled in installing and configuring Unix and AIX for Sybase databases
• Expertise in creating Unix scripts to schedule Sybase database maintenance jobs
• Implemented log shipping method of replication in SQL server
• Experience in analyzing and working wif various 3rd party tools for various activities like SQL Backtrack and BMC Patrol for Sybase etc.
• Generation of various metrics of the team performance across various disciplines and also analyzing and preparation of various proposals for the SLA’s.
• Refreshing UAT/development data servers.
• Troubleshooting Replication Issues.
• Working on Replication Sync-up.
• Formulating and Implementing Database maintenance activities.
• Working on Production Releases.
• Creating Devices and Databases.
• Implementing Security and Permission policy.
• Setting up Database Auditing for enhanced security.
• Checking the database health and maintaining consistency by running DBCC commands, Update statistics, Reorg rebuild periodically
• Implementation and Formulating backup and recovery strategies for production databases
• Finding the root cause for the repetitive incidents and system failure cases and preparing RCA documents
• Formulating and Setting database options.
• Administration on SQL Server Systems including installation and Configuration.
• Provided SQL DBA support for databases in production, development and test environments for various types of application- OLTP /DSS
• Backup/Recovery for SQL server databases
• Setup and Maintenance for SQL server replication.
• Disaster Recovery using Mirroring, Log Shipping
• Preform basic health check for DB2 databases
• Perform refresh of development and QA environment
• Scheduling reorg and update statistics activities on regular basis on DB2 databases
• Troubleshooting DB2 issues.
• Good knowledge of Shell scripting
• Created script weekly schedule for DBCC commands, error log monitoring.
• Carrying out Disaster Recovery drills.

TECHNICAL SKILLS

Sybase ASE: 11.x, 11.5.x, 11.9.2. 12.0.x, 12.5.x, 15.0.x

Replication: 12.0, 12.5, 12.6, 15.0.x MS SQL Server 6.5/7.5.x, 2000

Database Utilities: Replication Server plug-in for Sybase Central(RSM Client), DBArtisan, BMC Patrol, SQL Backtrack, Desktop DBA, Platinum, Erwin, SQL Advantage, Direct Connect plug-in for Sybase Central, Autosys

Operating Systems: Sun Solaris 2.5.1, 2.6, 8, AIX, HP/UX and Linux2.45, Windows NT4.0, Windows 2000/2003, SOA

Middleware: Sybase Replication Server 11.03, 12.0 and 12.5, Replication Server Manager(RSM) Server 12.0 and 12.1

HA Solutions: SUN Cluster 3.0, Veritas Cluster 3.x, Sybase ASE, Sybase Replication Server.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Sybase Developer / DBA

Responsibilities:

• Administration of Sybase ASE across different flavours of Linux as well as Solaris
• Installation and Configuration of Sybase ASE Servers.
• Upgrade of the servers across different versions of Sybase and applying EBF.
• Administration on SQL Server Systems including installation and Configuration.
• Provided SQL DBA support for databases in production, development and test environments for various types of application- OLTP /DSS
• Creating Devices and Databases.
• Create and Maintain Database Maintenance Plans.
• SQL Server user management Access Control
• Disaster Recovery using Mirroring, Log Shipping
• Backup/Recovery.
• Perform DDL/DML changes.
• Windows system administration.
• Checking the database health and maintaining consistency by running DBCC commands, Update statistics, Reorg rebuild indexes periodically
• Troubleshooting Blocking / Deadlocks.
• Troubleshooting replication issues.
• Working on replication sync-up.
• Onsite offshore coordination.

Confidential, Raritan, NJ

Sr. Database Administrator

Responsibilities:

• Administration on SQL Server Systems including installation and Configuration.
• Provided SQL DBA support for databases in production, development and test environments for various types of application- OLTP /DSS
• Creating Devices and Databases.
• Create and Maintain Database Maintenance Plans.
• SQL Server user management Access Control
• Disaster Recovery using Mirroring, Log Shipping
• Backup/Recovery.
• Perform DDL/DML changes.
• Windows system administration.
• Checking the database health and maintaining consistency by running DBCC commands, Update statistics, Reorg rebuild indexes periodically
• Troubleshooting Blocking / Deadlocks.

Confidential

Sr. Database Administrator

Responsibilities:

• Installation/configuration of Sybase Server on various Unix Environments.
• Upgrading of Sybase Servers to ASE 15.5
• Monitor update statistics, reorg on weekly basis.
• Implementation and Formulating
• Responsible for fixing log full/tempdb issues.
• Deal wif Database corruption.
• Utilization reporting for databases where the data segment has exceeded the agreed 90% capacity and sending these reports to the management.
• Backup & Recovery.
• Creation of Devices/user databases setting database options.
• Troubleshooting and Analysis for Replication Environments
• Keeping track of all scheduled jobs & taking necessary actions when failed.
• Responsible for implementing security/password policies.
• Installation of Replication Server on Sybase servers.
• Troubleshooting Replication Issues.
• Working on Replication Sync-up.
• setup Table-level replication on production environment
• Formulating and Setting database options.
• Administration on SQL Server Systems including installation and Configuration.
• Provided SQL DBA support for databases in production, development and test environments for various types of application- OLTP /DSS
• Creating Devices and Databases.
• Create and Maintain Database Maintenance Plans.
• SQL Server user management Access Control
• Disaster Recovery using Mirroring, Log Shipping
• Backup/Recovery.
• Perform DDL/DML changes.
• Windows system administration.
• Checking the database health and maintaining consistency by running DBCC commands, Update statistics, Reorg rebuild indexes periodically
• Troubleshooting Blocking / Deadlocks..
• Perform basic health check for DB2 databases
• Perform refresh of development and QA environment
• Scheduling reorg and update statistics activities on regular basis on DB2 databases
• Troubleshooting DB2 issues.
• Carrying out Disasters Recovery drills.

Confidential

Sr. Database Administrator

Responsibilities:

• Installation/configuration of Sybase Server on various Unix Environments.
• Upgrading of Sybase Servers to ASE 15.5
• Data server error log monitoring - to trace and identify issues reported by the Sybase servers wifin production and development environments and offer potential solutions and advice to the DBA area, also checking server status.
• Checking the database health by running DBCC commands periodically
• Responsible for fixing log full/tempdb issues.
• Backup & Recovery.
• Creation of Devices/user databases setting database options.
• Troubleshooting and Analysis for Replication Environments
• Refreshing UAT/development data servers.
• Keeping track of all scheduled jobs & taking necessary actions when failed.
• Installation of Replication Server on Sybase servers.
• Working on Replication Sync-up.
• setup Table-level replication on production environment
• Administration on SQL Server Systems including installation and Configuration.
• Provided SQL DBA support for databases in production, development and test environments for various types of application- OLTP /DSS
• Creating Devices and Databases.
• Create and Maintain Database Maintenance Plans.
• SQL Server user management Access Control
• Disaster Recovery using Mirroring, Log Shipping
• Backup/Recovery.
• Perform DDL/DML changes.
• Windows system administration.
• Checking the database health and maintaining consistency by running DBCC commands, Update statistics, Reorg rebuild indexes periodically
• Troubleshooting Blocking / Deadlocks.

Confidential

Sr. Database Administrator

Responsibilities:

• Installation/configuration of Sybase Server on various Unix Env.
• Upgrading of Sybase Servers to ASE 15.5
• Responsible for fixing log full/tempdb issues.
• Deal wif Database corruption.
• Using BMC Patrol to monitor all servers
• Utilization reporting for databases where the data segment has exceeded the agreed 90% capacity and sending these reports to the management.
• Backup & Recovery.
• Handling Daily User request.
• Creation of Devices/user databases setting database options.
• Troubleshooting and Analysis for Replication Environments
• Refreshing UAT/development data servers.
• Installation of Replication Server on Sybase servers.
• Troubleshooting Replication Issues.
• Working on Replication Sync-up.
• Setup table-level replication on production environment
• Formulating and Setting database options.
• Provided SQL DBA support for databases in production, development and test environments for various types of application- OLTP /DSS
• Creating Devices and Databases.
• Create and Maintain Database Maintenance Plans.
• SQL Server user management Access Control
• Disaster Recovery using Mirroring, Log Shipping
• Backup/Recovery.
• Perform DDL/DML changes.
• Windows system administration.
• Checking the database health and maintaining consistency by running DBCC commands, Update statistics, Reorg rebuild indexes periodically
• Troubleshooting Blocking / Deadlocks..
• Installation/configuration of Sybase Server on Solaris/Linux Env.
• Running the update statistics, compilation of objects on weekly basis.
• Data server error log monitoring - to trace and identify issues reported by the Sybase servers wifin production and development environments and offer potential solutions and advice to the DBA area, also checking server status.
• Checking the database health by running DBCC commands periodically
• Backup & Recovery.
• Handling Daily User request.
• Installation of Replication Server on Sybase servers.
• Creation of Devices/user databases setting database options.
• Troubleshooting and Analysis for Replication Environments
• Refreshing UAT/development data servers.
• Keeping track of all scheduled jobs & taking necessary actions when failed.
• Responsible for user/group and login creations and implementing security/password policies.