SUMMARY : Over 10 years in Sybase Database Administration, Support of which 4 4 years in Database Development and 6 6 years are in Database Administration of huge databases on Sybase ASE on SUN, MS-SQL Server on Windows NT in multiple locations. Supported multiple server and database on 24 X 7 environments. Responding to usres and developer issues

Database Administration : Monitor the databases to optimize database performance, resource use and physical implementations of databases. Checking for database consistency, fixing DBCC errors, monitoring of error logs regularly, monitoring of database space allocations, transaction log space allocations .I was responsible for Creating and testing of Database Backup Procedures, Disaster Recovery procedures

Sybase server Installation : Installed Sybase servers version 10 11.0 11.5 11.9 ASE 12.0 ASE 12.5 and 12.5 .x on SUN, SCO UNIX System and applied required patches by monitoring new patch releases.

Replication Server : Worked on Replication Server in 24 X 7 environments.

Database creation : Created logical data models and translate into physical database structures that integrate with existing or proposed database structures. Verify if they meet the required parameters. Created tables, index, views, triggers, procedures, user groups, users and assign permissions based on requirement for.

Performance tuning : Reduced the data retrieval time considerably by binding frequently used object to memory pool, Created Stored Procedures optimized for performance at query level and modified existing queries for optimum performance. Optimized bcp for large data loads with sp_configure.

Monitoring memory, CPU utilization, disk utilization, locks, deadlocks and runtime of queries.

Database Security : creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups.

Documentation : Created or updated documents for the application.

SQL Programming : Created database objects as required by the application, modified objects for better performance and change in requirements. Working with developers on issues creating efficient queries, application design, Data Modeling and writing stored procedures, triggers. Extensively worked on developing and coding backend stored procedures on Sybase, Unix

Shell Scripting : Created scripts for Monitoring and Maintenance task, automated Database and transaction dumps, monitoring data received at 15 min interval was received and populate reporting tables.

Perl Scripting : Used Perl for transfering data, gathering performance data like op, ostat, vmstat, sp_sysmon.

Database Backups : Writing Backup scripts for automated dumps of full and transaction dumps of databases, bcp out the rows into files from tables to happen at a scheduled time, Perform manual backup when regular scripts fail.

Worked on new System 12.5 features like cache partitioning, quiesce database, disable triggers, user defined login security, query tuning by using merge joins, taking server engines offline, using ansi joins, using reorg rebuild on indexes and high performance backup and restore. Dump, Loading across multiple platforms.

Dbartisan, Sybase Central, SQL Programer, Veritas netbackup, ER win, Toad and Visio, Oracle Enterprise Manager, ARS Remedy, Sybase Direct Connect, Exceed, TSQL, ISQL, BCP, Replication Server Manager, SQL Plus, SQL Loader, Exceed, putty.


Employment

2005 - 2006
Role : Sybase DBA
Client : TELCOVE USA Role : Sybase DBA

Hardware and Software : Sybase ASE 12.5 on SUN, Sybase 11.9.2 on SUN

Responsibilities :
Managed 1 Production Server 4 devlopment servers.

Provided DBA support to upgrade ARS Remedy from 4.0.3 to 4.5

Upgraded Sybase server 11.9.2 to 12.5 in development and documented the steps, configured memory, procedure and data cache.


2005 - 2005
Role : Sybase DBA
Client : Hilton Hotels USA Role : Sybase DBA Client : TELCOVE USA Role : Sybase DBA

Hardware and Software : Sybase ASE 12.5.1 on AIX, Korn Shell scripting, Sybase 11.9.2 on SUN

DBA Responsibilities :
Managed 1800 Production Databases across 4 Servers.

Provide 24 X 7 Pager support for Production Servers.

Monitor dumps, DBCC, update stats task run to completion.

Provide DBA Support to Business Analysts and Development Teams. Solved swap space issue, deadlock issue.

Performing Benchmarks and fine tuning Sybase 12.5 ASE Servers.

Performance monitoring - Monitoring memory, CPU utilization, disk utilization, locks, deadlocks, runtime of queries.

Configuring 12.5 ASE Server level configurations. Producing over 4 - 5% increase in Server and batch process performance reducing run time by half.

Using sp_sysmon to evaluate server level performance. Tuning configuration and server parameters.

Monitoring performance of servers and databases. Tuning the database by setting various initialization parameters.

Housekeeping Sybase, dump directories.

Data migration using BCP utility.

Maintaining database backup and recovering from system database failure

Maintaining user, group, assigning privileges

Handling DBCC output and troubleshooting

Monitoring and optimizing database performance.

Script writing and editing for Sybase related batch jobs.


2004 - 2005
Role : Sybase DBA
Client : AT and T USA Role : Sybase DBA

Hardware and Software : Sybase 12.5 .x on SUN, Korn Shell scripting.

DBA Responsibilities :
Deliver new Sybase environments for Development, Testing and Training.

Provide 24 X 7 Pager support on rotation basis.

Monitor Scheduled task run to completion.

Test Pre Production installation of new changes to configuration, Monitoring scripts.

Provide DBA Support to Development Teams and testing Teams 28 data Servers.

Provide DBA Support to Reporting teams 4 data servers.

Script writing and editing for Sybase related batch jobs.

Data migration using BCP utility.

Involved in planning for disaster recovery procedures and writing shell scripts to move data across servers.


2002 - 2004
Role : Sybase DBA
Client : Star Securities INDIA Role : Sybase DBA

Hardware and Software : Sybase ASE 12.5 on SUN Solaris, Rep Server 12.1 on SUN Solaris, MS-SQL, Shell scripting, Perl 5.6.

I was part of a 5 member Sybase dba team.

Responsibilities :
Managed 5 Production Servers and 20 Development Servers.

Move the data from SQL Server to Sybase using bcp.

Used Perl to import tables into Sybase.

Write triggers for application Auditing requirement.

Write shell and Perl scripts to transfer data from Sybase to text files for reporting.

Test and implement the application in coordination with the Business teams.

Check and tune the performance of the Procedures with appropriate Index Strategy and statistics.

Monitor Sybase dataservers and replication server for performance.

Worked on new System 12.5 features like cache partitioning, quiesce database, disable triggers, user defined login security, query tuning by using merge joins, taking server engines offline, using ansi joins, using reorg rebuild on indexes and high performance backup and restore.

Designing the distributed environment by using architectures supported by Sybase Replication Server. Identifying tables, columns that need to be replicated from primary to replicated database. Creating replication definitions and subscriptions for the distributed environment.


2000 - 2002
Role : Sybase DBA
Client : GREAT RIVER ENERGY USA Role : Sybase DBA

Hardware and Software : Sybase 11 .x, 12 .x, SUN Solaris, MS-SQL Server, Oracle, Veritas Netback up, Shell scripting.

Worked as DBA consultant for GREAT RIVER ENERGY for 24 months and was responsible for shell scripting, coding stored procedures and database maintenance. Involved in the following projects as part of a development team : -

Responsibilities :
Managed 2 Productions and 1 Development.

Created auditing tables with trigger for Security.

Monitor Database Backup and Transaction Dump took Place.

Monitor live data feeds

Created scripts to monitor the data load across servers and report for failure, so the data is populated manually.

Created the procedures to populate the summary tables hourly, daily and monthly basis run thru cron task.

Migrated 2 databases from Sybase to oracle.

Migrated 1 database from MS-SQL server to oracle.

Created shell scripts for database backups, transaction dumps thru cron job.

Reduced the data retrieval time considerably by binding frequently used object to memory pool.

Modified existing queries for faster data retrieval time.

Configured the DBCC database and set up to run DBCC checkstorage. Used the new dbcc checkverify.

Created test database for development with required table and index as required.

Created production database as required for moving the test systems for production.

Develop and manipulate large, complex data sets and maintain large databases.

Monitor 3 OLTP servers for optimum performance.

Created views for users to view the data with detailed description.

Monitor success or failure of Database backups and log dumps.

Worked with mission critical databases which required less than 15 minutes of recovery from system failure.

Document the tables, views and procedures used.


1993 - 2000
Sterling Holiday Resorts INDIA




Miscellaneous

Role : DBA, Developer

Hardware and Software :
Sybase System 10 .x, Sybase ASE on Sun Solaris, SCO UNIX, MS SQL Server 7.0 6.5 TSQL, Power Builder 5.0/4.0/3.0perl, C-shell, AWK, Sybase Central, Erwin, Power designer, Perl.

Worked as part of 4 member database team in the design, development, testing and implementation of Customer oriented processing system, Resort Management System, Financial management system, Human Resource Management System using Sybase 10 and upgraded to 11.9.2 on a UNIX server. Worked on 24 X 7 environments with support for Unix Administrator tasks. These systems handle all the transaction related requirements of the company.

Responsibilities :
Created Database Schema, development, administration and testing using Sybase System 10 .x or 11 .x Servers, MS-SQL 6.5 7.0 Server.

Involved in maintaining 24 x 7 data access or report for various clients of the company using Sybase, Oracle, MS_SQL server and access.

Provide 24 X 7 environments for mission critical OLTP.

Monitor Sybase dataservers and replication server for best performance.

coded stored procedures, triggers, table creation and indexes in Sybase and MS-SQL servers.

Responsible for development, testing, implementation and administration of Human resource System where the Employee details, Payroll accounting are handled.

Responsible for development of reporting procedures for clients which involved transfer of data from Sybase to oracle, MS_SQL server of the clients.

Testing of applications for performance, data integrity and validation issues.

Data Transfers between various servers using BCP, import export in MS_SQL server.

Maintain availability and integrity of databases through multiple access schemes ; facilitate sharing of common data by overseeing proper key and index management. Monitor the databases to optimize database performance, resource use and physical implementations of databases. Involved in creating, testing and implementing Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.

Created logical data models and translated into physical database structures that integrate with existing or proposed database structures. Verify if they meet the required parameters. Created tables, index, views, triggers, procedures, user groups, users and assign permissions based on requirement for. Working with various business groups while developing applications, phasing from development to testing and to Production environment in Sybase.

Reduced the data retrieval time considerably by binding frequently used object to memory pool, modified queries for optimum performance.

Keeping logs and database objects on separate devices to achieve improved performance and recovery.

Placing a table on 1 hard disk and non clustered indexes on another to ensure faster and parallel reads, writes.

Query plan analysis using show plan to avoid table scans.

Reviewing database design to avoid usage of variable length data type, null data values etc. to prevent deferred updates when possible.

Usage of proper fill factor values in the create table statement to improve performance.

Reorganization of table by rebuilding its clustered indexes after high volume inserts, updates, deletes.

Creating temporary tables for reducing the number of table joins.

Installed Sybase servers version 10 11.0 11.5 and 11.9 on SUN, SCO UNIX System and applied required patches by monitoring new patch releases. Traveled extensively to install and troubleshoot Sybase and UNIX servers.

Create or update documents for the application.

Created user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups, assigning the users to particular groups.

Mirroring devices, checking for database consistency, fixing DBCC errors, monitoring of error logs regularly, monitoring of database space allocations, transaction log space allocations, fine tuning SQL performance, backing up of transaction logs, backing databases regularly, database segmentation for fine performance.

Migrated 5 applications from Oracle to Sybase as part of a team of 4 DBAs and to provide support and upgrades to existing oracle application during migrating period.

Used Perl for coding scripts to manupulate data for transferring for Sybase to SQL server for reporting.