SUMMARY:

• The Consultant has around 16 years of IT Industry experience as System Analyst, Design, Development, Implementation and Administration of application systems developed in UNIX and windows environment.
• Worked with company like Wells Fargo, Confidential, JPMorgan Chase, Confidential and Presently working in Capital one as Sr. Sybase, Replication and MSSQL server DBA. Have extensive experience in
• Database performance & tuning, database administration, backup/recovery and troubleshooting of Sybase SQL server. Have good knowledge and hands on experience on Sybase Replication Design, Installation
• Administration and Trouble Shooting. Have excellent communication and inter - personal skills and is a responsible team player.
• Having good knowledge and experience in Installing, configuring and upgrading Sybase ASE 11.X/12.X/15.5/15.7 on Unix.
• Expertise in Installation, configuration & of Sybase Replication 15.X on UNIX environment.
• Have good experience in Unix Shell Scripts for daily backups and regular maintenance, monitoring scripts which are scheduled in autosys jobs to execute on daily and weekly basis.
• Having thorough knowledge in troubleshooting of Sybase server, Replication server and database related problems.
• Implemented and reviewed backup / recovery strategy for production environment.
• Managing and monitoring the use of disk space, memory and connections.
• Maintaining database related and server related security.
• Setting database option to change database behavior.
• Implemented resource limited on production environment.
• Creating devices & database, altering database size according to requirement.
• Cache creation and object binding, pool creation to increase performance.
• Tuning of complex queries using monitoring tables, show plan, statistics IO, set IO and best plan option.
• Writing complex and optimized stored procedures, triggers and analyzing of query plans for better performance.
• Implemented partitioning, worker process management parallelism to improve performance of queries.
• Maintaining of Index and there statistics with update index statistics.
• Maintaining table using reorg, using optdiag utility and changing lock scheme.
• Implemented DBCCDB database for checking consistency of database.
• Setting up server to use remote procedure calls.
• Implemented CIS connection for remote server access.
• Optimization of server, database and query using sysmon.

TECHNICAL SKILLS:

Hardware: SUN Solaris, IBM and AIX.

Operating System: Solaris, Linux, Aix UNIX 4.3, Windows NT/2000, Digital UNIX 4.0.

Servers / Database: SYBASE Server - 10/11.X/ 12.0/12.5.0.3/12.5.3/15.03/15.5/15.7 Sybase Replication 12.6/15.x, Oracle 9i, SQL Server 2008 R2

Tools: ERWIN Data Modelling Tool, DB Artisan 8.1, Sybase Central.

RDBMS: Sybase ASE 15.0.3, 15.7.x, Replication 15.5, MSSQL 2008

Operating System: Solaris 10, Linux, Windows

Tools: DBArtisian 8.1.5, Sybase Central and HPSM Change

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sybase/Replication DBA

Responsibilities:

• Involve in analysis of system, performance, tuning and troubleshooting of Sybase server and Replication and MSSQL server.
• Troubleshooting and maintaining database related and server related problems in both Sybase and MSSQL server
• Controlling and monitoring user access/permissions, setting up logins, roles and users for server and database.
• Managing and monitoring the use of disk space, memory and server connections.
• Use HPSM change control management to add or modify procedure, tables in production environment..
• Checking consistency of database, daily backups and error logs.
• Installation and configuration of MSA replication on Unix. Configured rep-agent, created database replication definition and database subscription
• Maintain and modify Unix shell scripts for daily backups and regular maintenance, monitoring scripts, this is scheduled in Cron jobs to execute on daily and weekly basis.

Confidential, Chicago, IL

Sybase/Replication DBA

Tools: - DBArtisian 8.1.5, Code, Clear Quest.

Responsibilities:

• Involve in analysis of system, performance, tuning and troubleshooting of Sybase server and Replication server.
• Involved in upgrading Sybase servers and Moving Replication Server from one Hardware to another.
• Coordinating Solaris 10 Upgrade with Unix Admin for all Production Unix host.
• Troubleshooting and maintaining database related and server related problems.
• Checking consistency of database, daily backups and error logs.
• Installation and configuration of warm standby replication and single side replication on Unix. Configured rep-agent, created route between two-replication servers, created replication definition for tables, created subscription to subscribe data from primary, create function replication definition etc.
• Writing Unix shell scripts for daily backups and regular maintenance, monitoring.
• Managing and monitoring the use of disk space, database size and memory usages.
• Optimization of server, database and query using sysmon, maintained index and column level statistics with update statistics, setting up logins, roles and users for server and database. Controlling and monitoring user access/permissions
• Implemented and reviewed backup/recovery strategy for production environment.
• Implemented partitioning, parallelism and parallel sorting to improve performance of queries. Setting database options to change database behavior.
• Optimization of server, database and query using sysmon, maintained index and column level statistics with update statistics.
• Optimized stored procedure and query Using show plan, statistics Io, DBCC 302,310 output.
• Implemented DBCCDB database for checking consistency of database.

Confidential

Sybase DBA

Tools: -DBArtisian 8.1.5.

Responsibilities:

• Involve in analysis of system, performance & tuning and troubleshooting of Sybase server and Replication server.
• Involved in installation, configuration and upgrading Sybase servers from 12.5.3 to 15.0.2.
• Troubleshooting and maintaining database related and server related problems.
• Checking consistency of database, monitoring servers, regular maintenance and backups.
• Managing and monitoring the use of disk space, database size and memory usages.
• Setting database options to change database behavior.
• Implemented and reviewed backup/recovery strategy for production environment.
• Optimization of server, database and query using sysmon, maintained index and column level statistics with update index statistics.
• Implemented DBCCDB database for checking consistency of database.

Confidential, Boston, MA

Sybase / Oracle DBA

Tools: -DBArtisian 6.03, Sybase Central, Lotus notes.

Responsibilities:

• Involve in analysis of system, performance, tuning and troubleshooting of Sybase server and Replication server.
• Involved in implementation of Sybase to Oracle replication and Oracle to Sybase replication in production and development environment using Sybase replication server, repagent for Oracle and direct connect for Oracle.
• Troubleshooting and maintaining database related and server related problems.
• Controlling and monitoring user access/permissions, setting up logins, roles and users for server and database.
• Managing and monitoring the use of disk space, memory and server connections.
• Installed sybsecurity database for Sybase server auditing.
• Checking consistency of database, daily backups and error logs.
• Installation and configuration of warm standby replication and single side replication on Unix. Configured rep-agent, created route between two-replication servers, created replication definition for tables, created subscription to subscribe data from primary, create function replication definition etc.
• Writing Unix shell scripts for daily backups and regular maintenance, monitoring scripts, this is scheduled in Cron jobs to execute on daily and weekly basis.
• Use change control management to add or modify procedure, tables in production environment.
• Installation of Oracle instance, Start and shutdown of oracle database.
• Backup and Restore using Import and Export utility.
• Creating and altering tablespace, allocating space for temporary segments.
• Creating, altering and dropping users, granting and revoking permissions.
• Creating and modifying roles.

Confidential, Houston, TX

SYBASE DBA

Tools: -DBArtisan 6.0.3, Sybase Central, Lotus notes.

Responsibilities:

• Installation and configuration of Sybase ASE 2.5 on Unix.
• Planning and coordinating fail over testing to D/R location including with other applications.
• Implemented and reviewed backup/recovery strategy for production environment.
• Managing and monitoring the use of disk space, memory and connections.
• Troubleshooting and maintaining database related and server related security.
• Setting database options to change database behavior.
• Optimization of server, database and query using sysmon, maintained index and column level statistics with update statistics.
• Setting up logins, roles and users for server and database.
• Creating and managing objects such as tables, views, indexes, rules etc.
• Controlling and monitoring user access/permissions

Confidential

Sybase DBA / Analyst

Tools: -DBArtisan 6.0.3, ERWIN Modeling tool, Sybase Central.

Responsibilities:

• Utilizing my skills and knowledge to develop, implement and build database centric business intelligence solutions for Confidential .
• Worked on Sybase 12.0 to Oracle 9i conversion project. Job responsibility includes analysis the system and making business decisions, implementing business solutions in data centric model. Involved in planning strategy to convert data from Sybase to Oracle model and back from Oracle to Sybase model.
• Lead a team to implement disaster / recovery site for troubleshooting extensive scenarios on ASE and Replication server and also involved in monitoring performance and troubleshooting Sybase server, warm standby replication server and single side replication server in production environment.
• Installation and configuration of Sybase ASE 12.0 and 12.5 on Unix.
• Installation, configuration of warm standby replication and single side replication on Unix. Configured rep-agent, created route between two-replication servers, created replication definition for tables, created subscription to subscribe data from primary, create function replication definition etc.
• Writing Unix shell scripts for daily backups and regular maintenance, which is scheduled in Cron jobs to execute on daily and weekly basis.
• Implemented and reviewed backup/recovery strategy for production environment.
• Implemented partitioning, parallelism and parallel sorting to improve performance of queries.
• Optimization of server, database and query using sysmon, maintained index and column level statistics with update statistics.
• Optimized stored procedure and query Using show plan, statistics Io, DBCC 302,310 output.
• Implemented DBCCDB database for checking consistency of database.

Confidential

SYBASE DBA

Responsibilities:

• Managing and monitoring consistency of database.
• Setting up logins, roles and users for server and database.
• Troubleshooting server and database related problem.
• Monitoring performance and tuning of database and SQL scripts.
• Creating and managing objects such as tables, views, indexes, rules etc.
• Controlling and monitoring user access/permissions
• Bug fixing, product enhancements & development, rollovers.
• Writing complex and optimized stored procedure, triggers for better performance.
• Implimented partition & parallelism strategy for better performance.
• Analysis & tuning of complex queries using showplan, statistics io, DBCC 302,310 output.
• Implemented partitioning, parallelism and parallel sorting to improve performance of Queries.
• Maintaining of index and column level statistics with update statistics.
• Maintaining table using reorg, using optdiag utility and changing lock scheme.
• Bulk-Copy in/out of data, defncopy, writing cronjobs for maintenance.
• Implemented DBCCDB database for checking consistency of database.
• Implemented and reviewed backup / recovery strategy for production environment.

Confidential, NJ

PROGRAMMER / ANALYST

Responsibilities:

• Writing complex stored procedures, triggers.
• Defining rules, defaults, and constraints on tables for database integrity.
• Optimization of stored procedure and trigger for better performance.
• Analyses of query plans, forcing index-scan and table-scan.
• Index creation, fine-tuning of indexes.
• Fine-tuning of queries using showplan/ DBCC 302,310 output
• Implimented partition & parallelism strategy for better performance.
• Monitoring performance and tuning of database and SQL scripts.

Confidential

SYBASE DBA

Responsibilities:

• Written unix shell scripts for daily backups and regular maintenance which is scheduled in cron jobs to execute on daily and weekly basis.
• Troubleshooting of sybase server, replication server and database related problems.
• Formulation, implementation and review of backup and recovery strategy.
• Setting database options to change database behavior.
• Managing and monitoring the use of disk space, memory, and connections.
• Maintaining database related and server related security.
• Checking consistency of database.
• Mirroring device for nonstop recovery in the event of media failure.
• Creation of logins for the users, granting roles/ rights.
• Tuning of complex queries using showplan, statistics io, DBCC 302,310 output.
• Writing complex and optimized stored procedure triggers for better performance.
• Analysis of query plans, forcing index-scan and table-scan.