SYBASE ASE ADMIN PROFESSIONAL 12.5
Sybase DBA * Sybase Replication Admin * PL/SQL Programming
PROFILE
• Certified Sybase DBA with Wipro Technologies Ltd, Chennai, India Since Mar-2010
• 4+ years of experience as Sybase Database administrator, Sybase Replication server and PL/SQL programming
• 2+ years of experience in System Requirement Analysis, System Design and Development, Testing and Documentation
• Expertise in Unix, C++, PL/SQL, Qt Designer
• Involved in design and development of the projects using the OOAD with UML and designing tool Rational Rose
PROFESSIONAL EXPERIENCE
Wipro Technologies Ltd, Chennai, India, Sybase DBA (Technical Lead) Since Mar-2011
TATA Consultancy Services Ltd, Chennai, India, Sybase DBA (IT Analyst) From Jan-2005 to Mar-2011
CMC Limited, Hyderabad, India, Project Assignee From Mar-2004 to Oct-2004
Code Systems, Pondicherry, India, Software Programmer From Aug-2002 to Dec-2003
EDUCATION
Master of Engineering in IS from CEG, Anna University, Chennai, India
Bachelor of Engineering in CSE from Madras University, Chennai, India
AREAS OF EXPERTISE
• Proficiency in administrative functions in Sybase ASE 12x/15.5 on Sun Solaris, IBM AIX & Linux
• Replication technologies 12x/15x on Sun Solaris
• Installation and configuration of Sybase in critical equities systems
• Database migration from old version to latest version and apply any patches
• Performance & tuning (dataserver & code), key configuration parameters
• DBMS internals such as Query Processing, Access methods internals, Index/Search, Transaction management and SQL programming
• Experience in shell scripting and sound knowledge of regular DBA activities
• Installation of Replication server for setting up warm standby and MSA replication
• Troubleshoot DSI Thread down, Replication Agent down issues for Replication server
• Troubleshoot database server performance problems
• Troubleshoot Replication server slowness issues
• Implement UNIX Shell scripts to monitor the latency and queue depth for the replication server
• Sybase (both client library and basic SQL) including design and building new tables, triggers and stored procedures, etc
• Give suggestion to application team to fine-tune the inefficient queries
• Liaise with clients for any new requirements and problems
• Release management for database scripts into production environment
• Database Design, Database Administration, Database Performance Tuning and Optimization
• SQL (TSQL & PL/SQL) programming and complex stored procedure development
PROFESSIONAL EXPERIENCE
Technical Lead, Wipro Technologies Ltd, Chennai, India, consulting for the following clients and projects:
SYBASE DBA Production Support, Citi Ltd, Tokyo, Japan, Mar 2011 to till date
• Supporting 200+ production Sybase servers for Citi Ltd across multiple regions
• Installation and Configuration of Sybase 12.5 & 15.5 servers for Nikko Citi Ltd Equities systems
• Installation and configuration of Replication server 12.6 & 15.x in new and existing equities servers
• MSA replication setup between multiple source databases and multiple replicate databases
• ASE 12.x upgradation to ASE 15.5
• Replication server upgrade from 12.x to 15.2
• Implementation of backup and recovery for production databases
• Monitoring of Sybase ASE using DBA Maint and BMC patrol monitoring jobs
• Regular health checks, monitoring, updates of ASE and Rep servers
• Monitoring the growth of various objects over a period of time using threshold procedures and advice the application group on the growth of database
• Adhoc user requests like refreshing the Development/Test Servers
• Identifying the poorly written programs or SQL queries and optimizing the same
• COB and recovery tests for production environment
IT ANALYST, Tata Consultancy Services Limited, Chennai, India, consulting for the following clients and projects:
SYBASE DBA Production Support, STANDARD CHARTERED BANK, Chennai, India, Jan 2009 to Mar 2011
• Installation and Configuration of Sybase 12.5 servers for NCS Project migration on IBM AIX 4.6 CISC hardware
• Installation and configuration of Replication server 12.6 in new machines for NCS Project
• MSA replication setup between multiple source databases and multiple replicate databases
• User Login Management and Security Implementation
• Responsible for creating User Panel and granting the permissions of the same
• Creation of Devices & User databases
• Implementation of backup and recovery for production databases
• Monitoring of Sybase ASE server errorlog and the backup server errorlog
• Running the update statistics on APL tables, reorg rebuild for DOL tables and recompiling the tables on weekly basis
• Checking the database health by running DBCC commands periodically
• Index creation, Partitioning tables for inserting huge data
• Monitoring the growth of various objects over a period of time using threshold procedures and advice the application group on the growth of database
• Adhoc user requests like refreshing the Development/Test Servers
• Written the Unix scripting for Update Statistics, Reorg rebuild, Checking Sybase Server, DBCC Checks, Dumping the tran logs every 15 minutes and scheduled the these jobs through crontab and Control-M
• Migration of stored procedures as per the user request on Production/Development servers
• Developing the new UNIX and Perl scripts as per the user requirement
• Identifying the poorly written programs or SQL queries and optimizing the same
• Disaster recovery for production ASE server and replication server environment
SYBASE DBA (for Forex Cash Reporting Project), STANDARD CHARTERED BANK, Chennai, India, June 2008 to Dec 2008
• Involved in financial domain project Forex Cash Reporting for Thailand design and development
• Complete database design for the FCR project team with functional knowledge
• Provided automated system to generate cash projection for each non-residential cash accounts
• Played key role as liaison with client in problem solving, project status updates, gathering performance
• Installed Replication server and have done MSA setup for the NCS application in SCB for the first time
• Introduced distributed database management system for better performance and throughput
• Segregated processing production database from Reporting database using Replication 12.6 MSA setup
• Led CMM-based process-improvement team effort to implement more efficient, documented estimating process that was previously unstructured and subject to customer complaints, resulting in
• Developed complex and effective stored procedures involving business knowledge and batch updates
• Delivered Microsoft .NET 2002 development objects for each DB objects
• Involved in web development for Reporting services
• Provided functional Stored procedures for Crystal Reporting team for Reporting services
SYBASE DBA & SYBASE DEVELOPER (for Network Custodian Systems), STANDARD CHARTERED BANK, Chennai, India, Sep 2006 to May 2008
• Installation and configuration of multiple databases on single ASE server for application development team
• Installation and configuration of multiple production equivalent ASE servers for SIT and UAT environment
• Provided DBA support to Development Sybase ASE 12.5 server involving many regions (user database) in a single ASE server
• Tuned stored procedure and Queries for better performance
• Provided database support to development team and central testing facility team for integrated database and front-end environment
• SYBASE ASE database administration for more user databases in same ASE server with highly tuned environment
• Sybase ASE Performance Tuning for server and
• Server Performance Monitoring and Maintenance
• DB Objects designing for development team
• Converting time consuming complex batch programs into efficient database Stored procedures
• Monitoring and maintaining development environment for volume growth
• Backup and Recovery planning for development ASE server user databases and system databases as part of regular maintenance activities
• Provided IBM CICS 5.0 and IBM DB2 8 support for AIX development and production team
• Developed programs and provided production fixes using ProC and IBM C++ 6.0
• CMR analysis and development using Sybase CT-Library for batch and developed IBM AIX binaries
• Tuning application queries and Data manager queries developed by application developers
• Providing assistance and training to developers about better PL/SQL query programming for better performance
SYBASE DBA & SYBASE DEVELOPER (for Proprietary Defence Project), Defence Electronics and Research Laboratory, Hyderabad, India, Mar 2004 to Aug 2006
• Analysis and Application design using Rational Rose
• Developed const effective Microsoft Visual Basic 6.0 tools for automating many development activities
• Installation and configuration of Sybase ASE 12.0 development in Sun Solaris 5.9 SPARC hardware
• Reviewing design and technical Documents
• Auto generating source codes of UI and Control classes
• Analysis Mechanism on Sybase ASE 12.0 Text Search in Database
• Implemented Cyclomatic complexity tool for SUN C++ 5.5 and lex parser
• Provided database access mechanism and code DB access snippet for development team using Sybase CT-Library
• Installed and configured Sybase Replication Server 12.0 for distributed database environment using Warm Standby mode
• Implementing multiprocess handling and event handling
SOFTWARE PROGRAMMER, Code System Limited, Pondicherry, India, consulting for the following clients and projects:
JAVA Web Developer (for Warehouse Management System), STADS Limited, Chennai, India, Sep 2002 to Apr 2003
• Development of warehouse management web application system
• Development of Java 1.8 and JSP web development application under Microsoft Windows environment
• Maintaining Jakarta tomcat webserver 4.0.3 as application server
• Designing completed database objects in Oracle 8i database for application and writing stored procedures
• Various analysis on employee payment pay slip mode
Application Developer (for Time Attendance & Payroll Management System), Packaging India Limited, Pondicherry, Chennai, India, May 2003 to Dec 2003
• Developing Time Attendance/Payroll Management system using Microsoft Visual Basic 6.0
• Developing DB component with Microsoft Access 2000 database and Oracle 8i database
• Analysis on various types of pay slip modes for application development
• Client interaction for reviews & updates for the application development
• Reporting development using Crystal Report system
PROFESSIONAL AFFILIATIONS
• Institute of Electrical and Electronics Engineers since 2007
• CBDI Service Oriented Architecture Practice Portal since 2006
• International Sybase User Group member since 2007
• Rational User Group since 2005
TECHNICAL EXPERTISE
OS : Sun Solaris 5.10, IBM AIX 5.2
Hardware : Sun SPARC, AIX IBM Compatibles, RS 6000 LAPRs
Languages : C, C++, PL/SQL, UNIX Shell Scripting, ProC CT Library Programming
RDBMS : Sybase ASE 12.x & 15.x, Oracle 8i
Tools : Sybase Central, Rational Rose 2003, Qt Designer 3.3.0, Sybase Replication Server 12.x & 15.x
Last updated on: 03 July 2011