SUMMARY

• 7 years of experience as Sybase DBA Involved in providing software solutions to various clients.
• Expertise in Sybase 15.7/15.0/12.5 .1, Replication Server 15.6/12.6
• Extensively worked on initializing database devices, creating databases, tables, indexes, views, triggers, using and writing stored procedures, partitioning tables.
• Experienced in Upgrading/Migrating Sybase Database Server from ASE 12.0 to Sybase ASE 15.0/15.5
• Strong server side administration skills with Linux, Sun Solaris.
• Administered very large databases of sizes ranging from 1 TB to 5 TB.
• Experience in creating server logins, database users, user groups, granting and revoking permissions for user accounts, assigning roles to users.
• Monitoring memory, CPU utilization, disk utilization, locks, deadlocks and runtime of queries.
• Created scripts for Monitoring and Maintenance tasks, automated Database and transaction dumps
• Experience in writing UNIX shell scripts to maintain the database environment
• Scheduled UNIX Cron jobs to monitor database health.
• Created, configured, tested and implemented DBCC database on all the Production Databases, and also written scripts to run and fix DBCC errors regularly.
• Monitoring of database space allocations, transaction log space allocations
• Creating segments and thresholds
• Extensively worked on installing and configuring (32bit/64bit) different versions SQL Server 2000, 2005, 2008 R2 and updating with latest hot fixes and service packs.
• Experience in regular monitoring of the server using sp sysmon system procedure to prevent situations where the system starts to perform badly because of misconfiguration, identifying bottlenecks or intensive server use
• Expertise in auditing events such as logins, logouts, server boot operations, accesses to database objects, and actions performed by a specific user with a particular role active
• Migrated data from and into the server and operating system files using BCP
• Migrating databases across Adaptive Server versions and page sizes using sybmigrate utility
• Created and tested Database Backup Procedures and Disaster Recovery procedures
• Created multiple tempdbs and bound user login as well as applications to specific temporary databases or a group of temporary databases via the system stored procedures interface
• Proficient in performance and tuning, diagnosing server problems
• Fine tuning the server by setting configuration parameters, limiting access to server resource
• Experience in Monitoring queues, routes, threads and connections of Replication Server in different sites with huge replication data.
• Experienced on working with Sql - Server2000/2005

TECHNICAL SKILLS

RDBMS: SYBASE ASE 15.7/15.0/12.5 x/12.x, Replication Server 15.6/12.6, MS-SQL Server 2000/2005/2008

Languages: UNIX-Shell Scripting, Perl Scripting, C, C++, Power builder 5.0/6.5/7, T-SQL

Operating Systems: Red Hat Linux 3.x, 4.x, 5.1, Sun Solaris, UNIX, AIX, MS DOS, Windows 2000/XP, and Windows server 2003/2008

TOOLS: Embarcadero DBArtisan 9.1, Autosys, Erwin, ER Studio, Sybase Central, Power Designer, SQL Backtrack, Tivoli, Clear Case 5.0, Veritas Volume Manager.

SupportSQL: Database, MVS Database, PC and Notebooks, Application Development and Upgrades, Platinum and Tivoli Case tools

PROFESSIONAL EXPERIENCE

Confidential, Mount Laurel, NJ

SYBASE/SQL Server DBA

Responsibilities:

• Installation, configuration, management and production/dev/uat support of ASE 12.5.x and 15.x
• Installation, management and production/dev/uat support of Replication 12.6 and 15.5
• Experience of building Warm standby, MSA, Table level
• Monitoring of Sybase error log for all Data Server
• Monitoring of Replication Server
• Monitoring databases threads on Replication Server
• Responsible for performance & tuning ASE Sybase/Replication servers
• Backup and recovery for all ASE Sybase MS SQL servers databases
• Responsibility to monitor and setup MS SQL server (2008r2/2012) replication (Transaction/Merge)
• Monitor and setup of log shipping and database mirroring for MS SQL, Sybase
• Creating and Maintaining user databases
• Creating and managing Adaptive Server login accounts
• Granting roles and permissions to Adaptive Server users
• Managing and monitoring the use of disk space, memory, and connections
• Backing up and restoring databases
• Diagnosing system problems & troubleshooting
• Configuring Adaptive Server to achieve the best performance
• Establishing Disaster Recovery procedures, DBA runbook, Discovery Document
• Assisting Application DBA (Store procedure/trigger/t-SQL/View etc.)
• Automate monitoring and alerting by scheduling errorlog / logspace/database capaciting/ Long running process monitoring and alerting scripts
• Automate and analyze proactively database maintenance activity (DBCC/Update stat/reorg etc.)
• Performance-tuning SQL Server, Database level, Query level to achieve the best performance.
• Creating sysmons reports on regular basis using shell script and cron jobs
• Create scripts to monitor processes in Sybase and to highlight blocking and long running processes
• Implementation of backup and recovery for production databases
• Monitoring of Sybase error log for all Data Server
• Monitoring databases threads on Replication Server
• Troubleshooting performance issues & fine tuning quires
• Rebuilding/reorg of table and Indexes
• Setting thresholds to Monitor data and log space, maintaining multiple databases
• Checking the database health by running DBCC/Checkstorage commands periodically
• Use of Sybase tools like Sybase central for server monitoring Determination of Monitoring the growth of various objects over a period of time using threshold procedures
• Creating jobs to automate repetitive tasks by writing cronjobs, shell scripts etc.

Confidential, Harrisburg, PA

Production Support DBA

Responsibilities:

• Support a production system setup comprising of Sybase 15.0.3 ASE servers, Replication Servers 15.7.
• Monitor crontab jobs daily and rectify issues if any.
• Schedule and monitor db maintenance activities such as reindexing, reorg, dbcc during maintenance slots 2AM to 6AM Saturday through Sunday
• Supported the Application that handles check images for the bank and replication to other servers using routes.
• Automated the dump and load of databases using corn shell scripting.
• Open Change Request tickets in the CA ticketing system, get approvals, present the change on Change
• Board Meetings and implement the changes in the production and DR servers during maintenance slots.
• Worked with SQL Server 2008 side by side upgrade from SQL server 2000.
• Database Backup and restores, and periodical database refreshes
• On call providing 24/7 Sybase and Replication Server DBA support for all incident calls. This involved working with Applications Support team and Operations Team to resolve the incident Request Tickets.
• Worked On SQL Server 2000/2005/2008 (R2) Clustered Environments.
• Worked on setting up MSA replication system using resource files.
• Monitor Replication queues using RCL commands and use rs ticket to check on latency.
• Used Perfmon, DMV’s, SQL Profiler to capture the activities of the databases and used the trace file as workload file to the Database Tuning Advisor for index recommendations.
• Suspend and Restore Replication server for all necessary ASE maintenance when required.

Confidential, Cleveland,OH

SYBASE/SQL Server DBA

Responsibilities:

• Installation, configuration, management and support of ASE of ASE 12.5.x, 15.x
• Installation, management and support of Replication 12.6 and 15.2
• Managing shift rotation to cover 24X7
• Monitoring of Sybase error log for all Data Server
• Monitoring of Replication Server
• Monitoring databases threads on Replication Server
• Responsible for Monitoring/Alerting/Backup/Recovery Sybase ASE/MS SQL/Oracle server environment
• Responsible for Migrating server to latest version (ASE 15.x),applying patches/EBF
• Setup, Installation, Performance &Tuning of Sybase and Replication servers (MSA/WARM Standby)
• Replication, Database mirroring and log shipping for MS SQL Server
• Table, View, T-SQL, Expert in writing Stored Procedures, Trigger and other database objects (Rule, Default, constraints etc.,)
• Managing Dev/UAT/Production environment
• Responsible for Problem Resolution for ASE/REP/MS SQLSERVER servers

Confidential, Mount Laurel, NJ

Sybase DBA

Responsibilities:

• Installation & configuration of Sybase ASE /Rep
• Migration from ASE 12.5 To ASE 15, Migration from 2K page to 8K page
• Replication server installation and configuration
• Database capacity planning
• Creating Devices, Database, mirroring and granting ownership of them.
• Maintaining login /User account. Granting roles and permission to SQL server users.
• Managing and monitoring the use of disk space, memory and user connections.
• Performance-tuning SQL Server, Database level, Query level to achieve the best performance.
• Creating sysmons reports on regular basis using shell script and cron jobs
• Create scripts to monitor processes in Sybase and to highlight blocking and long running processes
• Implementation of backup and recovery for production databases
• Monitoring of Sybase error log for all Data Server
• Monitoring of Replication Server
• Monitoring databases threads on Replication Server
• Troubleshooting performance issues & fine tuning quires
• Rebuilding/reorg of Indexes
• Setting thresholds to Monitor data and log space, maintaining multiple databases
• Checking the database health by running DBCC/Check storage commands periodically
• Use of Sybase tools like Sybase central for server monitoring Determination of Monitoring the growth of various objects over a period of time using threshold procedures
• Creating jobs to automate repetitive tasks by writing cronjobs, shell scripts etc.
• Refreshing the Development/Test Servers every alternate week
• UNIX Shell scripting
• Perform Root Cause Analysis. Handling user requests.
• SQL loader, EXP and Imp utility.

Confidential

Sybase DBA/SQL Developer

Responsibilities:

• Sybase Installation
• Database capacity planning
• Creating Devices, Database and granting ownership of them.
• Maintaining login /User account. Granting roles and permission to SQL server users.
• Managing and monitoring the use of disk space, memory and user connections.
• Backup and Restoration and Recovery of Databases.
• Performance-tuning SQL Server and Database level to achieve the best performance.
• Log space management.
• General maintenance (consistency check, update statistics, Fill factor, partitioning table, indexing etc.)
• Wrote UNIX Scripts for backup, restore of databases, Sybase error log monitoring, and automation of SQL code
• Shell scripting (C & Perl) for different applications and scheduling job through CRONTAB
• Table, View, T-SQL, Expert in writing Stored Procedures, Trigger and other database objects (Rule, Default constraints etc.)
• Providing data for Data warehouse from different system and application.

Environment: Sybase ASE 12.0/12.5, Red Hat Linux