Here’s the profile of Certified Sybase DBA for your review. Key Skills: Strong Experience in Production and Development Environments on ASE 15.0.x/12.5.x/12.0.x, Sybase 11.9.2, Oracle 9i/7.x on UNIX and Windows environment. Having 4.0 Years of Replication Server v12.5 and v12.6 Sybase Certified with types WARMSTANDBY, MSA and Heterogeneous.
He is currently at CO, available with one week notice & willing to relocate. Please feel free to call/email me for further information. Thanks: Mehul Shah cyberThink, Inc. 201-984-4940 x 562 Email: [email protected] Resume of SRAVAN SUMMARY OF QUALIFICATIONS: " 10 Years IT experienced detail-oriented Production DBA currently pursuing as SYBASE DBA for 6+ 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 Financial Institutions, Healthcare Services and Mobile Communication. " Strong Experience in Production and Development Environments on ASE 15.0.x/12.5.x/12.0.x, Sybase 11.9.2, Oracle 9i/7.x on UNIX and Windows environment. " Having 4.0 Years of Replication Server v12.5 and v12.6 Sybase Certified with types WARMSTANDBY, MSA and Heterogeneous. " 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 Installing and upgrading Sybase Servers, managing ASE logins/users, Disk Space, memory and etc. " Develop and implement backup and recovery plans, Export/ import Data using BCP utility. " Data server / Database Performance tuning. " Writing UNIX Shell Scripts and programming to automate various activities. " Strong verbal and written communication skills, analytical with Multi-tasking capabilities. " Maintaining meticulous records of all activities. " Sybase Certified - Replication Server 12.5 Administrator " OCP Certified - Oracle 9i - . TECHNICAL SKILLS: Specialization : DATABASE ADMINSTRATOR for SYBASE and Oracle. RDBMS : Sybase ASE 15.0.x/12.5.x /12.0.0.8, RepServer 12.x, Oracle 7.x - 9i. Operating System : SunOS Solaris 8 Model SunFire 6800 / 12K, 4800 and v1280, IBM AIX 5.x, Digital TRU64, Linux7.2, SCO, Win2K, XP. Languages : PL/SQL, SQL, Transact-SQL, Shell Programming, Pro*C. Storage Arrays : T3+, Sun Storedge 6320 (T4). Special Softwares : TOAD 6.5(Oracle), PL/SQL Developer 3.0.1(Oracle), DBArtisan (Sybase), SybaseCentral, Embarcadero RapidSQL 7.3.4. GUI : D2K Forms 6.0, OracleReports6i, Visual Basic 6.0 and Crystal Reports3.0. Operational Knowledge on: BMC Patrol for Sybase, AUTOSYS, SCCS, HP Open View Service Desk 4.5, ONYX. PROFESSIONAL EXPERIENCE: Customer: Healthcare Services (CO) Position: Sybase DBA - Project Lead Period: June 2007 - Till date Project Description: HealthCare services (Facets, e-facets, Health Web) is the largest company dedicated to providing information technology for the health insurance payer industry. Client provides, leading proprietary and third-party software, including e-business applications; Outsourced Services; and strategic and implementation consulting. working as 'Sybase Lead DBA' for Hosting Services department which comprises the clients Blue Cross Network, TKC, Regence, United Health Care-Dental, Universal American Financial Corp, Today's Options (UAT), APS and so on. Responsibilities: " Participate in DBA activities as listed below. " Monitor and resolve production alerts and issues. " Creating device matrix for capacity planning, Creating databases. " Installing Sybase ASE (15.0.x), REP 12.6 in AIX, Loading FACETS, HIPAA Gateway, and 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: Sybase 15.0.x/12.5.x / Rep 12.6 MSA, Warms Tandy and heterogeneous with Direct Connect; IBM AIX 5.x. Customer: dbaDIRECT (USA, Cincinnatti-OH) Period: Sep 2004 - June 2007 Position: Sybase DBA - Team Lead Project Description: In Ascendum Systems started as Database Specialist for Sybase Database Administration and designated from Senior Database Specialist to Team Lead, leading team members by providing necessary training, transferring knowledge and scheduling jobs. We are proactively monitoring, analyzing, and managing hundreds of instances remotely to help our clients achieve success. Dedicated 100% to database administration, following are the deliverables in 24 X 365 remote database support. Client: State Street Corporation (US-Boston) Responsibilities: 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. Leading team members for hundreds of highly secured 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 " 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 Data server/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: Sybase 12.5.3 / Sybase 11.9.2 / Sybase Central / DBArtisan / SunOS 5.8 Solaris 8 / AIX / HP-UX / EXCEED / SQL Backtrack. Client: Medical Data Systems, ABN AMRO, Quest, Kroger, Cinergy, Natexis, Subscribers mail and Lightspeed. 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, Subscribers mail 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. And we support the Entry Level REPLICATION Server Administrative Responsibilities for Medical Data Systems (TWO Way) and WARMSTANDBY instances on Lightspeed, Natexis and Subscribers mail. " 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: Sybase ASE 12.5.3 / Replication Server 12.5 / Sybase Central / DBArtisan / Sun OS Solaris / Linux / HP-UX. Reliance Infocomm Ltd. Project Title: NNOC-Netrac Period: Sep 2003 - Sep 2004 Position: Wireless - Sybase DBA Reliance Infocomm Ltd. - Telecom sector - is a member of the Reliance Group, India's largest business enterprise and among the 500 largest companies in the world. Reliance Infocomm is the only private service provider with licenses to operate in 18 telecom circles that together cover almost 95% of India's population. NNOC (National Network Operations Center) that manages 80MSCs of Network Elements all over the country to provide extensive Wireless Connection to the customer. Following are the responsibilities as Wireless - Sybase DBA. Responsibilities " Installing and Configuring Sybase ASE 12.5.0.3 in UNIX HA. " Up gradation / EBF (12.0.0.8) Installation on Sybase ASE 12.0.0.8. " Client Patch Installation for BCP version on Sybase ASE 12.0.0.8. " Managing Databases like Creating, Assigning Space and Devices to User Databases. " Placing the Transaction Log on a Separate Device. " Managing Segments like Creating and Assigning Segments to Database Objects. " Managing Adaptive Server Logins, Database Users and Groups. " Installing Audit Functionalities and Auditing Logins and database object. " Object management and Security. " Setting Database Options and Configuring Data server Engines. " Managing free spaces and Sizing Databases. " Backup/Dumping the Database/Transaction. " Recovering/Loading the database. " Writing Scripts for Bulk Copying. " Synchronizing the Test Servers with Production. " Tuning physical memory, cache portioning 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. OS Monitoring & Scripting " Monitoring and sizing the OS File system. " Writing shell scripts using awk to monitor database growth, sizing, user creation / dropping, group creation and login creation and etc. Reliance 3G CDMA: Netrac Application- the gateway to the CDMA Wireless Network Element. Netrac is the application to fly the data from Network Elements (NEs) to ASE database to monitor Performance of the Network Elements, Alarm the Critical Messages and Connecting to SAP. For this application we are using Sybase Adaptive Server Enterprise (24 * 7) to bring the data from Network Elements like HLR, VMS, and SMS after parsing with device definition and frame handler. " Installation of Sybase 12.5 in T4 Storage Array having 8 TB size. " Up gradation of Sybase / EBF 11442 & Open Client for BCP version Installation. " Migration of 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 was not able handle the Queues. Dbdumper concept is introduced to reduce the Queues with BCP functionality. " Troubleshooting Database Errors. a. Error 2628: Table Structure Changed from APL to DOL b. Error 605 c. AUDIT PROCESS EXCEPTION d. Error 644 e. LOGSUSPEND Environment: Sybase 12.0.0.8, Sybase 12.5.0.3 / Sybase Central / Sun OS Solaris 8(gnu tar application installed) / Sun Cluster V3.1. Unit Trust of India (UTI) Project Title: US - 64 and Data migration Period: Apr 2000 - Sep 2003 Position: DBA (Sybase/Oracle) Unit Trust of India (UTI) - Financial Sector - is India's largest mutual fund organization. UTI has 54 branches across India and manages 80 types of funds. Responsibilities: SYBASE Database Administrator ULIP - Unit Linked Insurance Plan is one of the best schemes in terms of TAX benefit and market related. " System Study and Analysis. " Logical and Physical Database Design for the system " Responsible for Managing different database, Installing 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 Sybase Server for best performance. " Backup & Recovery maintenance. " Configuring Interfaces. " Creating Users, Groups and Logins. " Supporting End Users. Oracle Database Administrator Description - Projects Handled 1. MMMF Project: Money Market Mutual Fund is one of the Leading Scheme in the type of government securities, Bond Papers and Commercial Papers. Role of this project is to migrate data from Oracle 7.x (SCO-UNIX) to Oracle 8i (Windows NT). 2. TUP: The Technology Up gradation Project is mainly used for flagship Scheme US-64. Distributed Database Oriented Project. It is designed to handle millions of records. " 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: Sybase 12.0 / Oracle 7.3 & 9i / Sun Solaris SUNfire 6800 / Digital Tru64 / SCO-UNIX / Win2K / TOAD. HCL Infosystems Ltd Project Title: NIIL - Needles Integrated Management Information Systems Customer: Needles (Coimbatore, India) Period: Jul 1999 - Apr 2000 Position: Jr. Oracle DBA Project Description The project is to develop a complete integrated management information system for the client. The software includes various modules namely, Production Planning and Control System, Sales Accounting System, Financial Accounting System, Personnel Payroll System and Materials Management System. Each module is fully integrated with each other to provide the top management with online MIS information. Responsibilities: " 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. EDUCATION: MCA (Master of Computer Applications) Equivalent to MS in USA - Madurai Kamaraj University, Madurai, India. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "IT provider" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.co.in/group/IT-provider?hl=en -~----------~----~----~----~------~----~------~--~---
