SUMMARY

• 9 years of experience as a SAP Confidential and Replication server DBA working with financial clients.
• Experienced in Installations and upgrades of Confidential 15.x versions which includes in - place upgrades, new installations, replication setup, migrations and DR setup.
• Experience with SAP Replication Server set up, upgrades and migrations.
• Experienced in Datacenter Migrations, Disaster Recovery setup, Cross platform database migrations.
• Experience in building and maintaining MSSQL server versions 2008 R2,2012 and 2014
• Worked on complex Heterogeneous and Homogeneous Confidential Replication environments which comprises of multiple database products and third party tools.
• Worked on database optimization and performance improvement by analyzing optdiag, dbcc’s and other Confidential native utilities.
• Worked closely with Development, Engineering and Remediation teams to improve database performance and new enhancements.
• Experience on working with latest release of SAP ASE 15.7, SAP Replication server 15.7 and their new features like threaded mode.
• Exposure to Confidential data warehousing Confidential IQ.
• Experience with shell scripts for multiple database tasks like Monitoring error logs, space management, maintenance tasks, health checks, automated Database processes, table migrations, Health checks, Replication queues, Replication Threads, FTP, timely backups and Housekeeping the backup directories.
• Documented key procedures for Replication setup, disaster recovery, configuring database consistency checks, Replication switchover incase of disaster and key troubleshooting techniques of runtime errors specific to the environments.

TECHNICAL SKILLS

Platforms: Windows. UNIX, AIX-5.2, Solaris, HP UX, Linux

Tools: Tidal, Confidential Central,FogLight, BMC Remedy, Autosys

Version Control: PVCS

Databases: ASE 15.7,15.0.3, 12.5.x MSSQL server 2012,2008 r2

Data warehouse: Confidential IQ.

Replication: Confidential Replication Server 15.7,15.x,12.6, 12.5

Replication Connectors: Enterprise Data connect,DirectConnect,Repagent

Languages: c, c#.

Web technologies: ASP.NET.

Database Tools: DB Artesian, DB Change Manager.

Development tools: Visual Studio.NET 1.1.

Markup languages: HTML

PROFESSIONAL EXPERIENCE

Confidential, Reston, Virginia

Responsibilities:

• Provide senior level SAP Confidential ASE and MSSQL server 2012, 2008 r2 database administration.
• SAP Confidential installation, configuration, tuning, backup and recovery, Configure Confidential Servers.
• Managing and monitoring the use of server parameters like disk space, memory, and connections.
• Experience working with Remediation Teams (FACTORY) to upgrade production servers to latest versions.
• Participated in On Call rotation and provided support for Confidential, MSSQL servers 24/7.
• Performing database code releases and assisting developers to promote their code into production from test servers.
• Assisting UNIX team with their patch upgrades.
• Experience on setting up Disaster Recovery, Analyzing the existing setup and plan for DR setup in a new location.
• Planning, implementing timely maintenance scripts like DBCC’s, Reorg’s, Table fragmentation, Analyzing statistics and troubleshooting errors reported.
• Setup new Replication servers, upgraded existing replication servers to latest versions and host migrations.
• Interacted with various project teams within the company and provided solutions for their application support and database related queries.

Environment:

• Operating systems: Windows, UNIX, Solaris, Linux.
• Databases: SAP ASE 15.7, ASE 15.0.3, ASE 12.5.
• RepServer: Confidential Replication Server 15.7, 12.6.
• Ticketing Tool: BMC Remedy
• Tools: Fog Light, Autosys, DB Artesian, and DB change Manager.

Confidential, Irvine, California

Responsibilities:

• Provide senior level Confidential and MSSQL server 2008 r2 database administration.
• Confidential installation, configuration, tuning, backup and recovery, Add and Configure Confidential Servers.
• Involved in upgrade projects of production servers till Go Live.
• Worked on migration of Disaster Recovery site to a new Data Center.
• Managing and monitoring the use of disk space, memory, and connections.
• Performing monthly database code releases and assisting developers to promote their code into production from test servers.
• Assisting UNIX team with their patch upgrades.
• Responding timely to user requests and assisting them on their releases, Performing Table Migration and requested data restoration.
• Planning, implementing timely maintenance scripts like DBCC’s, Reorg’s, Table fragmentation, Analyzing statistics and troubleshooting errors reported.
• Built a new DR site complete end to end with Confidential and Replication.
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.

Environment:

• Operating systems: Windows, UNIX, Solaris
• Database: ASE 12.5, ASE 15.0.3,15.7
• RepServer: Confidential Replication Server 12.6, 15.x.
• Ticketing System: HP-Open view V7

Confidential

Responsibilities:

• Provide senior level Confidential and Oracle database administration which involves hundreds of servers.
• Confidential installation, configuration, tuning, backup and recovery, Add and Configure Confidential Servers.
• Create and Restore System database backups.
• Creating/Modifying/Locking Logins and Users in Confidential, Oracle Databases. Granting Roles and Permissions to users.
• Managing and monitoring the use of disk space, memory, and connection.
• Creating/Modifying/Locking Logins and Users in Confidential Database.
• Responding timely to user requests and assisting them on their releases, Performing Table Migration and requested data restoration.
• Planning, implementing timely maintenance scripts like DBCC’s, Reorg’s, Table fragmentation, Analyzing statistics and troubleshooting errors reported.
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Working on user requests,changes,releases on HP-OpenView
• Talk to various Business Units within organization for functional as well as technical discussions for new enhancements, understanding their requirements and suggesting suitable solutions.

Environment:

• Operating systems: Windows, UNIX, AIX-5.2, Solaris, HP UX.
• Database: ASE 12.5, ASE 15, Oracle 10g, 11g
• RepServer: Confidential Replication Server 12.6, 15.x.
• Ticketing System: HP-Open view V7

Confidential

Responsibilities:

• 24/7 support for all the customers of REMO and ensuring servers are up and running fine.
• Monitoring and Troubleshooting issues that are encountered on daily basis with Replication server and ASE.
• Worked on Issues filed with CTS.
• Installed, Configured and upgraded servers based on clients requests.
• Working with day-to-day Data server, Database issues in a production environment like log segment filling up, taking backups and refreshes.
• Performing Table Migration on user requests.
• Provided support on Confidential IQ data warehouse which includes simplex and multiplex architecture.
• Provided timely, reliable status reports of the servers to clients for their analysis.
• Worked on heterogeneous replication environments troubleshooting issues with RepAgents, Enterprise data connect software’s.
• Worked on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Visited onsite for domestic customers, studied the environments, worked on stabilizing the environment and training their staff.
• Worked on weekend support maintenance for customers, which include running diagnosis jobs, fixing errors reported, defragmenting tables, purging data and reclaiming space.
• Prepared documentation on key troubleshooting tips and tricks.

Environment:

• Operating systems: Windows, UNIX, AIX-5.2, Solaris, HP UX.
• Database: ASE 12.5,15.
• Data warehouse: Confidential IQ 12.6.
• Replication: Confidential Replication Server 12.5,12.6,15.5,Repagent
• Middleware: Enterprise Data connect,DirectConnect

Confidential

Responsibilities:

• Performed early morning Health checks for all the critical servers within timeframe provided and hence ensuring the business for a hassle free BOD process by the application teams.
• Monitoring and Troubleshooting issues that are encountered in production hours with Replication server, ASE, Repagent and Direct Connect.
• Worked with departments that are associated with data servers and responding to their adhoc requests.
• Worked with day-to-day Data server, Database issues in a production environment like log segment filling up, taking backups and recovery.
• Worked on BOD and EOD activities performing various tasks like capturing selected data and transferring to various departments within stock exchange.
• Performing daily backups at close of business hours which includes file system backups and backups on tapes.
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Worked on weekend maintenance activities and mock testing with the development team.
• Installed and configured servers as requested by development teams and encouraging them to use the new features.
• Trained in house staff associated with the project.

Environment:

• Operating system: HP UX UNIX.
• Database: ASE 12.5.
• RepServer: ASE Repserver 12.5, 12.6
• Data warehouse: Confidential IQ 12.6.
• RepAgent: Confidential Replication agent 12.5
• Middleware: Confidential Direct connect

Confidential

Responsibilities:

• 24/7 support for all the production servers and ensuring servers are up and running fine.
• Monitoring and logging long running user transactions, blockings in production hours.
• Monitoring and troubleshooting busy production hours which comprises of users connecting from all the branches throughout the country.
• Scheduling and running maintenance activities on production server like update statistics, REORG REBUILD.
• Improving performance of large database tables by partitioning them and reducing fragmentation.
• Upgrading the server with latest EBF’s and patches.
• Providing support to SA’s on their scheduled maintenance and patch application.
• Managing database growth and handling large database tables by partitioning them.
• Working on user requests.

Environment:

• Operating system: UNIX, AIX-5.2.
• Database: ASE 15.0.2 HA.

Confidential

Responsibilities:

• Monitoring and troubleshooting Jobs that are running on TIDAL Scheduling Software.
• Monitoring and Troubleshooting issues that are encountered on daily basis with Replication server and ASE.
• Working on ONYX tickets and STARS assigned by Onsite team
• Working with day-to-day Data server, Database issues in a production environment like log segment filling up, taking backups and recovery.
• Performing Table Migration on user requests
• Working on replication issues like thread down, disk space monitoring, dealing with Repagent.
• Documented key troubleshooting tips and tricks.

Environment:

• Operating system: UNIX, AIX-5.2, Solaris.
• Database: ASE 12.5
• RepServer: ASE Repserver 12.5
• Monitoring Tool: Tidal Scheduler
• Ticketing System: ONYX, Stars, HP Openview

Confidential, Denver

Responsibilities:

• Involved in adding new functionalities to the existing application.
• Worked with modifying stored procedures.
• Understanding the existing stored procedures and modifying them according to the application changes.

Environment:

• Operating system: Windows 2000.
• Browser: Internet Explorer 5.0.
• Database: Oracle 10g
• Application development: Oracle Forms and Reports Development Suite.