SUMMARY

• 10+ years of experience as Sybase Database administrator, Sybase Replication server, production support 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 2.0
• Involved in design and development of the projects using .Net technologies, the OOAD with UML and designing tool Rational Rose
• Proficiency in administrative functions in Sybase ASE 12.x/15.x on Sun Solaris & IBM AIX
• Replication technologies 12.6/15.x on Sun Solaris and IBM AIX
• Installation and configuration of Sybase ASE 15.7 in critical business servers
• Sybase database backup and recovery policies and practices.
• Database upgrade from old version to latest version and applying patches
• Expertise in disaster recovery plans and procedures for Sybase databases and software systems.
• Performance & tuning, 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 database server and replication server various parameters
• Troubleshooting application performance, 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

TECHNICAL SKILLS

OS: Sun Solaris, IBM AIX

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

Tools: Sybase Central, Rational Rose 2003, Qt Designer 3.3.0 Sybase Replication Server 12.x/15.x

PROFESSIONAL EXPERIENCE

Confidential, TX

SYBASE DBA Prod. Support

Responsibilities:

• Installation and Configuration of Sybase 15.0.3, 15.7 servers for North America Confidential Global markets and Confidential Group Global Markets Japan on RedHat Linux, IBM AIX
• Migration of production servers from older Sun Solaris hardware to newer one
• Upgrade of production servers from ASE 12.5.4 to ASE 15.0.3/15.7
• Migration of production servers from Sun Solaris to IBM AIX and Redhat Linux along with upgrade from ASE 15.0.3 to ASE 15.7
• MSA replication setup between multiple source databases and multiple replicate databases
• Replication server upgradation from 12.6 to 15.2
• Maintenance of database environment using autosys and crontab for regular DBA maintenance jobs such as DBCC, Reorg, Update Statistics, Dump and Backup.
• Implementation of backup and recovery strategy for production databases
• DBA Monitoring of Sybase ASE server errorlog, backup server errorlog and scheduled jobs log using BMC Patrol monitoring for production environments and Shell scripts for non production environments
• DB health by running DBCC commands periodically using autosys maintenance jobs
• BMC Patrol Monitoring for the growth of various objects over a period of time
• Using threshold procedures for alerting db usage limits and notifying application team
• Development/Test Servers maintenance using adhoc user requests like db refreshing
• Migration of stored procedures as per the user request on Production/Development servers
• Using long running transaction alerts and blocking alerts, identifying the poorly written programs or SQL queries and optimizing the same for application team
• Periodical COB test - Disaster recovery for production ASE server and replication server environment
• MDA Monitoring and Diagnosing server performance using monitorconfig, MDA and sysmon details
• 24/7 production support on all Global Markets Production database servers
• Good understanding of shell scripts

Confidential

SYBASE DBA Production Support

Responsibilities:

• Installation and Configuration of Sybase 15.0.3 servers for NCS Project migration on IBM AIX 5 CISC hardware
• Installation and configuration of Replication server 15 in new machines for NCS Project
• MSA replication setup between multiple source databases and multiple replicate databases
• ASE upgradation from 12.5 to ASE 15.0.3
• Replication server upgradation from 12.6 to 15.0
• Rewriting all database maintenance scripts for newer version of ASE and replication server
• Implementation of backup and recovery strategy 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

Confidential

SYBASE DBA

Responsibilities:

• 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

Confidential

SYBASE DBA & SYBASE DEVELOPER

Responsibilities:

• 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

Confidential

SYBASE DBA & SYBASE DEVELOPER

Responsibilities:

• 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

Confidential

JAVA Web Developer

Responsibilities:

• 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

Confidential

Application Developer

Responsibilities:

• 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