Summary

• 13 Years IT experienced detail-oriented Senior Level Production and certified DBA currently pursuing as SAP SYBASE ASE DBA for 8 years, MS SQL Server DBA for 3 years and executed as ORACLE DBA for 4 years with strong problem solving and project management skills on UNIX flavours and NT Platforms in domains Like Re-Insurance, Financial Institutions, Healthcare Services and Mobile Communication.
• Strong Experience in Production and Development Environments on latest version from ASE 15.7 in clustered environment to v15.0.x/12.5.x/12.0.x on UNIX IBM AIX, Sun Solaris, HP and MSSQL 2012, 2008R2 and v2005 on Windows Server 2008 and 2003.
• Having 4.0 Years of SAP Sybase Replication Server experience CERTIFIED Replication Server v12.5 . And have working experience on with types WARMSTANDBY and Transaction Replication.
• Strong Installation, configuration and troubleshooting skills in PRODUCTION, DEVELOPMENT and UAT environments ranging from 36GB, 1TB to 8TB.
• Experience in Physical and Logical Database design, development implementation.
• Experience in migrating to 8K page SAP Sybase Servers and upgrading, managing Disk Space, memory, performance tuning and etc.
• Develop and implement backup and recovery plans, Export/ import Data using BCP utility.
• Dataserver / Database Performance tuning.
• Writing Unix Shell Scripts and programming to automate various database activities.
• Strong verbal and written communication skills, analytical with Multi-tasking capabilities.
• Maintaining meticulous records of all activities.

Technology

• Primary Skills : DBA for SAP SYBASE ASE, RepServer, MS SQL Server and ORACLE
• RDBMS : SAP Sybase ASE 15.0.x/12.5.x /12.0.0.8, RepServer 12.x,
• SAP Sybase IQ 12.x, MS SQL Server 2012, 2008R2 2005, Oracle 7.x 9i.
• Operating System : IBM P7 / P6 9117-MMA AIX 6.1, 5.x, SunOS Solaris 8 Model SunFire
• 6800 / 12K, 4800 and v1280, Digital TRU64, Linux7.2, SCO, Win2K, XP
• Languages : Perl 5.2, CGI, Shell Programming, PL/SQL, SQL, Transact-SQL, Pro C
• Storage : SAN, T3 , Sun Storedge 6320 T4
• Special Softwares : TOAD 6.5 Oracle , PL/SQL Developer 3.0.1 Oracle ,
• DBArtisan SAP Sybase , SAP SybaseCentral, Embarcadero RapidSQL
• GUI : D2K Forms 6.0, OracleReports6i, Visual Basic 6.0 and Crystal Reports3.0.
• Operational Knowledge on : IBM Tivoli Enterprise Portal 6.2.3, Microsoft SSAS/SSIS, SAP SAP Sybase IQ, and BMC Patrol for SAP Sybase, AUTOSYS, SCCS, HP Open View Service Desk 4.5, ONYX.

Work Experience

Confidential

Position: Sr. Database Administrator

Project Responsibilities:

• Provide SAP Sybase and MSSQL Database support and business customer service through reactive daily database administration and support, implementation of new and cloned databases, operational maintenance, and proactive change initiatives both initiated by infrastructure and clients.
• Responsible for supporting almost 3000 SAP Sybase and MSSQL Production databases.
• Storage request, resource allocation on Clustered LPARs AIX / Windows Clusters and planning for Datacenter migration from Armonk USA to Zurich, Switzerland.
• Installing, upgrading and migrating ASE dataservers and MSSQL instances.
• Proactively drive the ongoing maintenance and optimization of preventative maintenance activities.
• Shell scripting to consolidate / automate jobs in TWS, Perl/CGI scripting to provide web interface.
• Direct data changes/application code deployment requested via ChangeManagement tool for users.
• month/quarter-end support for specific application portal, valuations/DSS, BoF, Tiger etc
• Base consultancy and performance analysis on servers, jobs and user request.
• Tuning the dataservers and instances for optimal performance.
• Projects IBM Tivoli Monitoring for SAP Sybase / MSSQL Servers Security implementation with Identity Access management.
• Participate in an overnight/weekend on-call support rota.

Environment: SAP Sybase 15.7/15.5/12.5.x IBM P7/P6 AIX 6.x LPARs. MS SQL Server 2012 / 2008R2 / 2005 Windows 2003 , 2008 Cluster.

Confidential

Position: SAP Sybase Consultant

Project Responsibilities:

• On-call availability during off-business hours on rotational basis to address database issues.
• Migrating SAP Sybase servers from 12.5.3 to SAP Sybase 15.0.3 with 8K pages for various environment PROD, MO, UAT SystemTest and DEV.
• Provided production support as SAP Sybase Primary, ON-CALL Rotation, coordinating with Application team - Batch/Tidal primary, UNIX primary, N/W team for Monthly and Weekly maintenance and resolving requests or problems raised by application groups in various business clusters.
• Database refresh and synchronizing replicated databases on warm standby.
• Tuned ASEs for performance from different levels i.e system level, server level using various approaches memory, indexing, locking, updating statistics, table de normalization and other server configurations.
• DR setup project - DR Server creations.
• Recommended, created shell scripts and placed on TIDAL for various DBA activities like update statistics round robin execution with data change , reorg rebuild, dbcc and replication monitor.
• Entry Level MS SQL Server 2005 DBA support: Installing and configuring SQL Server 2005 for testing Facets 4.71 conversion, restoring databases and monitoring Cluster SQL Servers used for sharepoint services.
• SAP Sybase IQ DBA: Creating SAP Sybase IQ databases, Starting and Stopping SAP Sybase IQ database servers. Installing SAP Sybase IQ. Adding Users, assign them privileges and manage logins and Backing up and restoring databases.

Environment: SAP Sybase 15.0.x/12.5.x / Rep 12.6 Warmstandby SAP Sybase IQ 12.6, IBM AIX 5.x. MS SQL Server 2005.

Confidential

Position: SAP Sybase DBA Project Lead

Responsibilities:

• Participate in DBA activities as listed below
• Monitor and resolve production alerts and issues.
• Creating device matrix for capacity planning, Creating databases.
• Installing SAP Sybase ASE 15.0.x , REP 12.6 in AIX, Loading FACETS, HIPAA Gateway, Health Web, e-facets application databases and AUDITING installation and configuration.
• Database Refreshes with Localization, fixes which installs change pack procedures/tables/indexes for facets databases. Migrating Production Servers.
• Table Migration, Objects Creation and Stored Procedure Creation/Execution.
• Creating RepServers for Regular and Warm Standby, and troubleshooting alerts like thread down, Refreshing databases and so on.
• Participate in activities such as defect and enhancement analysis, and development of problem fixes and minor enhancements.
• Participate in creation of deliverables and quality review as needed for Offshore DBAs.
• Perform all responsibilities and resource commitments consistent with the detail task plan created by TriZetto manager.
• Provide copies of project deliverables and supporting documentation e.g., meeting notes, data collection templates, etc., as requested.
• Raising issues/risks

Environment: SAP Sybase 15.0.x/12.5.x / Rep 12.6 MSA, Warmstandy and heterogeneous with Direct Connect IBM AIX 5.x

Confidential

Position: SAP Sybase DBA - Team Lead - OFFSITE

Responsibilities:

• I was leading team members for hundreds of highly secured SAP Sybase database instances by providing necessary Operating instructions on Remedy ticketing system, obtaining SecureIDs, training in accessing secure sessions, training AUTOSYS commands NDI scripts, providing ON-CALL support, scheduling tasks and
• State Street Corporation financial services, head quartered in Boston, Massachusetts, is the world's leading provider of financial services to institutional investors with 12.3 trillion in assets custody and 1.8 trillion under management.
• Upgrading ASE 12.0 to 12.5.3 or 11.9.2 to 12.5.3
• Requesting raw devices to create database devices and extending databases
• Troubleshooting Dataserver/Database Errors.
• Monitoring Growth Rate of Segments and Sizing Databases
• Setting Database Options and Configuring Data server
• Troubleshooting AUTOSYS job failures like dump, dbcc, update statistics, instance down and etc. and Activating, Terminating and Monitoring.
• Monitoring Remedy Ticketing System and BMC Patrol Tickets.
• NDI scripts supported for SCCS
• Implementing procedures for DR tests.

Environment: SAP Sybase 12.5.3 / SAP Sybase 11.9.2 / SunOS 5.8 Solaris 8 / EXCEED / SQL Backtrack.

Confidential

Responsibilities:

• Successfully initiated this project for clients Medical data systems, ABN Amro, Warner Bros., Kroger and Cinergy and got consent/confidence with other clients like Natexis, Subscribersmail and Lightspeed to monitor proactively through EMS Event Management System using BMC patrol for following.
• Creating databases, database devices and extending databases
• Monitoring Growth Rate of Segments and Sizing Databases
• Managing Adaptive Server Logins, Database Users and Groups
• Setting Database Options and Configuring Data server
• Backup/Dumping the Database/Transaction
• Recovering/Loading the database
• Immediate response to USERS' request
• Troubleshooting Database Errors.

Confidential

• Availability of Replication Server, Starting and shutting down the Replication Server.
• Starting and Shutting down REP AGENTS.
• Monitoring the Error Log of REPLICATION Server.
• Backing up RSSD databases.
• Monitoring Queue Growth.
• Skipping transactions for Duplicate Primary Key Errors.
• Resync replicate databases in WARMSTANDBY.
• Adding replicate databases in WARMSTANDBY.

Environment: SAP Sybase ASE 12.5.3 / Replication Server 12.5 / SAP Sybase Central / Sun OS Solaris / Linux / HP-UX.

Confidential

Position: Wireless SAP Sybase DBA

Responsibilities

• Installing and Configuring SAP Sybase ASE 12.5.0.3 in UNIX HA.
• Upgradation / EBF 12.0.0.8 Installation on SAP Sybase ASE 12.0.0.8
• Client Patch Installation for BCP version on SAP Sybase ASE 12.0.0.8
• Managing Databases like Creating, Assigning Space and Devices to User Databases
• Recovering/Loading the database
• Backup/Dumping the Database/Transaction
• Managing Free spaces and Sizing Databases
• Setting Database Options and Configuring Data server Engines
• Object management and Security
• Installing Audit Functionalities and Auditing Logins and database object
• Managing Adaptive Server Logins, Database Users and Groups
• Managing Segments like Creating and Assigning Segments to Database Objects
• Placing the Transaction Log on a Separate Device
• Writing Scripts for Bulk Copying.
• Synchronizing the Test Servers with Production
• Tuning physical memory, cache partioning and IO contention using sp sysmon
• Tuning IO utilization
• Tuning Engine Utilization
• Tuning the Log usage to avoid LOGSUSPEND
• Troubleshooting Database Errors like 644, 2628, 605 and 614.

Confidential

• Installation of SAP Sybase 12.5 in T4 Storage Array having 8 TB size
• Upgradation of SAP Sybase / EBF 11442 Open Client for BCP version Installation
• Migration of SAP Sybase 12.0.0.8 to 12.5.0.3
• Implementation of Audit Functionality for Database Auditing.
• Maintaining Database Sizes not to reach the Critical OS Space Crunch.
• Introducing DBdumper : Every hour 120000 records were being parsed and collected data from network elements. Due to heavy insertion Application were not able handle the Queues. Dbdumper concept is introduced to reduce the Queues with BCP functionality.
• Troubleshooting Database Errors.

Environment: SAP Sybase 12.0.0.8, SAP Sybase 12.5.0.3 / SAP Sybase Central / Sun OS Solaris 8 gnu tar application installed / Sun Cluster V3.1

Confidential

Responsibilities

• System Study and Analysis.
• Logical and Physical Database Design for the system
• Creating Users, Groups and Logins.
• Configuring Interfaces.
• Backup Recovery maintenance.
• Responsible for Managing different database, Installing SAP Sybase v12.0, Backing up and Restoring Databases, Managing server logins and users, Managing Disk space and memory allocations, creating database objects Tables, Indexes, Constraints , Fine Tune the SAP Sybase Server for best performance.
• Supporting End Users.

Confidential

Oracle Database Administrator

• Installation of Oracle8i Oracle9i in WinNT and WinXP
• Creating Users, Granting roles and privileges, Space Management
• Adding and altering Tablespaces and Datafiles
• Taking Physical Backups and Logical Backups using Export / Import utilities
• Recovery of Database from Disk or Instant failure
• Installing and configuring Network Manager and Net8 component
• Writing Scripts for SQL Loader
• Writing PL/SQL Procedures using PL/SQL developer
• Hierarchical lock of users, Provides Support to end-users and developers
• Analyzing Tables and Indexes to improve the performance
• Creating Database Links, Accessing Distributed Database
• Migrating from Oracle7.x to Oracle8i
• Written shell scripts for Automated Backups Readability Checking and
• Various day-to-day DBA activities

System Administrator

• Digital TRU64 Unix, SCO-Unix, Maintenance
• Creating Users, Forming Groups and Maintaining user profiles.
• Troubleshoot system and network problems.
• Establish effective backup and recovery procedures.
• Taking dump application backups
• Applying patches to operating systems for Oracle Application Users.

Environment: SAP Sybase 12.0 / Oracle 7.3 9i / Sun Solaris SUNfire 6800 / Digital Tru64 / SCO-UNIX / Win2K / Toad.

Confidential

Position: Jr. Oracle DBA

Responsibility

• The responsibilities include construction of program unit as per the program specification, creating the table and other database objects as required, creating database triggers, database procedures, unit testing of the coded programs and bug fixing of the unit tested programs.
• Taking backups of Developer's Application and required tables for modification
• Export and import of tables from Oracle databases.

Environment: Oracle 8.0.4, D2K Forms 6.0, Reports 3.0 , HP-UX 11.0