SUMMARY:

• 7 Years of total IT experience in Sybase and Replication as Database administrator.
• Sybase Certified Adaptive Server Administrator Associate 12.5
• Disaster recovery planning and implementation for 10 plus applications.
• Responsible for DISK Mirroring/PARTITIONING/BCP Capacity Planning.
• Performed regular database maintenance and replication administration.
• Provided troubleshooting and maintenance.
• Completed performance tuning within SMP environment with large quantities of parallel processing features enabled.
• Assisted developers in testing and implementing new applications as well as changes to existing applications
• Good knowledge in Replication Server installation, maintenance
• Sybase ASE Upgrades from 12.5.3 to 15.0.3..
• Replication upgrades from 12.5.6 to 15.x
• Installing Replication Server 12.5 and setting up replication for the ASE servers.
• Configuring the Replication Databases and Tables using Replication Definitions and subscriptions.,
• Monitoring the Replication server error log and trying to fix the issues..
• Identifying the Duplicate rows which made the DSI thread down and communicating with the client in order to bring it up.
• Good experience in Database backup and restore and Database refreshes.
• Good knowledge in BMC Patrol tools.
• Good Knowledge in autosys and BMC Patrol Tools.
• Good Experience to handling the Production changes.

KEY STRENGTHS:

• Sybase Certified Adaptive Server Administrator Associate 12.5
• Expert in installing, Maintaining Records, Backups, Recovery of Databases, Monitoring Resources, Users/Login Control, Proficient in Performance Tuning.
• Good knowledge in Replication Server installation, maintenance.
• Currently Working on Sybase (Versions: 11.9.2, 12.5.3, 12.5.2, 15.0), Replication 12.6 database servers.
• Involved in Production support Activities with 24/7 support.
• Sybase ASE Upgrades from 12.5.3 to 15.0.3.
• Sybase ASE server builds
• Replication upgrades from 12.5.6 to 15.x
• Installing Replication Server 12.5 and setting up replication for the ASE servers.
• Configuring the Replication Databases and Tables using Replication Definitions and subscriptions.
• Monitoring the Replication server error log and trying to fix the issues.
• Identifying the Duplicate rows which made the DSI thread down and communicating with the client in order to bring it up.
• Resuming the Rep Agents and DSI threads.
• Starting and shutting down the replication Server.
• Creating of Warm Standby setup.
• Creating of Warm MSA setup.
• Creation to user Accounts in replicated environment.
• Checking for latency of replicated databases.

TECHNICAL SKILLS:

Databases: Sybase ASE, Replication, Sybase IQ, SQL server,MS SQL

Operating Systems: Sun SOLARIS, UNIX, LINU, Windows

Languages: C, C++, JAVA

PROFESSIONAL EXPERIENCE:

Confidential

Sr. DBA

Responsibilities:

• Installing Adaptive Server and Backup Server.
• Migration of ASE servers from one unix box to other.
• Upgrading of ASE 12.5.2 to ASE 12.5.3 by applying the right EBF’s.
• Server & Database Monitoring.
• Backup and Restoration.
• Creating Devices and Databases.
• Managing Data Servers.
• Database Performance Tuning.
• Monitoring all servers regularly to check long run Trans, blocks, log & errors
• Managing and creating Adaptive Server user Accounts.
• Granting user permission and roles to database user on the sybase objects.
• Analyzing the Growth rate of the database and getting in touch the Application Users and accordingly increasing the database size or if require purging the data.
• Installing and Maintaining of Audit database.
• Installation of Dbccdb database
• Dealing with the tempdb and user log issues.
• Involved in Production releases.
• Running weekly maintenance task like Dbcc checkStorage, re - org rebuild and update statistics.
• Identifying the daily backup jobs failure, trouble shoot and fixing.
• Supporting databases 16X7Created
• Experience in designing and implementation of efficient Backup, Restore, Maintenance, Disaster Recovery & High Availability Strategies of MS SQL Server 2005 and 2008 in Production and Development environment.
• Hands on experience with planning and monitoring Log shipping of MS SQL Server 2005 and 2008.
• Knowledge in Performance Monitoring and Tuning, Query Optimization, using DBCC Utilities of MS SQL Server 2005 and 2008
• Experience in security management including creating logins, configuring permissions and assigning roles of MS SQL Server 2005 and 2008.
• Provided 24 X 7 dedicated supports for SQL Server production server.

Environment: Sun SOLARIS, Linux, Sybase ASE 12.5.x, 15.x, Replication Server 15.x,, Sybase IQ, SQL Server 2005 and 2008,BMC patrol.

Confidential

Sr Analyst

Responsibilities:

• Installing Adaptive Server and Backup Server.
• Migration of ASE servers from one unix box to other.
• Upgrading of ASE 12.5.2 to ASE 12.5.3 by applying the right EBF’s.
• Server & Database Monitoring.
• Backup and Restoration.
• Creating Devices and Databases.
• Managing Data Servers.
• Database Performance Tuning.
• Monitoring all servers regularly to check long run Trans, blocks, log & errors
• Managing and creating Adaptive Server user Accounts.
• Granting user permission and roles to database user on the sybase objects.
• Analysing the Growth rate of the database and getting in touch the Application Users and accordingly increasing the database size or if require purging the data.
• Installing and Maintaining of Audit database.
• Installation of Dbccdb database
• Dealing with the tempdb and user log issues.
• Involved in Production releases.
• Running weekly maintenance task like Dbcc checkStorage, re-org rebuild and update statistics.
• Identifying the daily backup jobs failure, trouble shoot and fixing.
• Supporting databases 16X7.

Environment: Sun SOLARIS, Linux, Sybase ASE 12.5.x, 15.x, Replication Server 15.x, Sybase IQ, Foglight.

Confidential

System Specialist

Responsibilities:

• Resolving tickets via BMC remedy.
• Checking of Database space and taking measures to increase the space etc.
• Monitoring Error logs and taking preventive measure thereon.
• Creation of Database devices.
• Data base refreshing
• To perform various administrative activities pertaining to Databases and Performance.
• To take and verify the backup of the databases on daily/weekly basis.
• To co-ordinate with Datacenter Operators to perform weekly/monthly maintenance Db activities like DBCC, Update statistics etc.
• Creation of User id’s for the Users in different applications.
• To interact with users to solve performance related problems and ensure smooth running of system.
• Creating and maintaining various DB maintenance jobs for smooth working of Database Servers.
• Monitoring and Maintaining the Replication Servers.
• Installation of Sybase 12.5.3 Server.

Environment: Sybase ASE 12.x, RS 12.6, Solaris, Linux, AIX, Tivoli Storage.