Upside Cloud Technologies

info@upsidecloudtechnologies.com +91 - 9900569467

ABOUT US - (Sybase) SAP ASE Experts

Having a clean database and tuned ASE engine is critical for all applications. A well maintained and continuously monitored setup gives extra confidence to the business team and helps compete in the tough market these days.

Our experts use innovative technology, latest tools and techniques to maintain server health that includes hardware, operating systems, database systems (Sybase/SAP ASE) and related applications. Working over a period of last 20+ years, our experts now have a library of practical queries, scripts, program and applications that help them perform as masters in the field of Sybase/SAP ASE management. Tools provided by SAP Sybase or their own, have simple usability and rich functionality to simplify data preparation and transformation that is very critical for data migration.

Our team is experienced in drawing up strategy for risk-mitigation and streamline data migration to the new environment, on time and on budget. Our team expertise in redefining data migration/installation/upgrade and take it to successful conclusion by following and adhering to the proven methodologies and quality tests.

Experienced in performance tuning and fine-tuning that enhances certain long running queries/reports/processes taking several hours and days to run. The outcome of their effort really makes it possible to run the same in few seconds or minutes.

Our monitoring and maintenance team use tools and mechanism to identify threats related to space, performance bottlenecks, data availability, locks, usability thresholds and other alerts and inform respective teams to take necessary actions while avoiding disasters for business users.

Currently we operate from four major cities across countries to facilitate user convenience. In India we have presence in Bangalore and Pune. In North America, we have New York City (NYC, USA) and in Canada we operate from Toronto city.

Our migration team ensures data is extracted from the source system, transformed, cleansed and loaded in to the target system using the migration rules and perform stress-test using large volume of data, before handing over to business users.

SERVICE LINE

Installation and Upgrades
Migration
Production Support
Multiple-countries replication management
Performance Tuning
Application Development and Re-engineering
Dev Team Support and Application DBA

OUR CAPABILITIES -AS SYBASE-SAP ASE DBA

Installaiton, Upgrade, Migration, Administration

Around 20+ years of Individual experience for most of our experts
Hands on experience in Current and Obsolete version in Sybase 4.0 till SAP(Sybase)ASE 16.x
Extensive hands-on experience in Sybase Server installation, On-going Maintenance, Seamless upgrade to newer versions
Experience in migration from Sybase to other Databases including Oracle, MS-SQL, UDB/DB2, MySQL, MongoDB and other databases.
Experience in ASE tools and utilities - Sysmon, DBCC, Update Statistics, Showplan.
Perform day-to-day managing tasks using proven tools - DBartisan, Sybase Control Center, Sybase Central, Rapid SQL
Manange smooth and seamless migration using tools - SSMA, Other Migraiton Tools
Production DBA, Managing L1/L2 Support teams, Supporting Application DBAs.
Performance Tuning Experts for local servers, clusters, cloud servers.
Experience in setting up and managing replication servers across regions, countries and time-zones. Includes setting up warm standby, multi-site availability (MSA)A
Setup Disaster recovery plan, mock drills and data set monitoring
Backup and Recovery on local and distributed environment using different backup/restore strategy and tools

OUR CAPABILITIES - AS SYBASE-SAP ASE DEVELOPER

Development, Testing, Design, Coding

Mix of Seniors, Mid and fresh developers as per project needs
Quality development skills using unit-testing and standard coding practices as per industry best practice
Skilled in agile methodology and SDLC
Adhere to project timelines, testing guidelines and business rules
Experts in offshore and on-site development roles and collaborating with other teams
Thorogh knowledge and experience in creating and managing various database objects - Tables, Stored Procedures, Triggers, Indexes, Rules, Defaults
Participate in application development using API, Json, XML, Device connectivity, SFTP/FTP
Hands-on experience in writing and managing Data Definition Language (DDL) and Data Modification Language (DML).

HARDWARE/OS EXPERIENCE

Development, Testing, Design, Coding

Sun Servers
AIX Servers
Linux
Windows 2008 server
Windows NT
HP-Prolient

SOFTWARE/TOOLS EXPERIENCE

Sybase Adaptive Server Enterprise (ASE) 16.x/15.x/12.x/11.x/4.x
Replication 16.x/15.x /12.x/11.x/4.x
SQL Server 2008/2005
Oracle 12c/11g/10g
Perl
Shell script
vi-editor
DBartisan
MSSQL Management tool
Sybase Central
iSQL

DOMAIN EXPERIENCE

Healthcare
Banking
Finance
Insurance
Logistics
Manufacturing
Trainig & Education

OUR EXPERT SKILLS

UNIX Shell scripting, Java, Sybase TSQL, Power Builder
Stored Procedure, Triggers, Indexes, Defaults, Cursors, API
Code version, Clear case, Bitbucket, Git, PVCS
Design, Technical and Functional Documentation
Report creation and maintenance using TSQL, Crystal Report, HTML
Testing, Debugging, UAT, Unit Testing, SDLC for application development
Performance Tuning, Data storage optimization, application performance optimization, indexing, parallel processing, worker processes management, locking methods
Vertical and horizontal normalization of tables
Programming based on FTP, SFTP for data transfer between systems and applications, encrypted data transfer, data validity, data backup/restore, BCP in/out
Auto emailing and event-based email through applications
Cron jobs, Ctrl-M and auto scheduler job scheduling

SYBASE VERSIONS AND KEY BENEFITS

The following is a list of the versions of ASE released over the years:

Sybase SQL Server / ASE

Adaptive Server Enterprise 11.5
Adaptive Server Enterprise 11.9.2
Adaptive Server Enterprise 12.0
Adaptive Server Enterprise 12.5
Adaptive Server Enterprise 12.5.2
Adaptive Server Enterprise 12.5.4
Adaptive Server Enterprise 15.0
Adaptive Server Enterprise 15.7
Adaptive Server Enterprise 16.0

Sybase Replication versions

Sybase Replication Server 11.0
Sybase Replication Server 11.5
Sybase Replication Server 12.0
Sybase Replication Server 12.5
Sybase Replication Server 15.0

CERTIFIED EXPERTS

Our expert teams have rich experience and are certified in one or more of Sybase certifications

Sybase ASE 12.0 Administrator Certified

CASE STUDY: HEALTHCARE DOMAIN

One of the major MNC had a large Sybase setup which was running on ASE version 12.5 with 1500+ concurrent business users. Due to the Security requirement, management decision was made to go for platform change as well as supported hardware change. Since the newer hardware and Operating system were not compatible with the obsolete Sybase ASE version 12.5, it was decided to upgrade Sybase as well to the supported 15.7 version.

Our team was entrusted with the task to upgrade all Sybase servers to version 15.7, which our team completed successfully in all environments from Dev to Production.

There were initial performance issues and service degradation, which was overcome by implementing the suggested changes in ASE configuration settings in the newer version. Performance was ensured by spending a considerable amount of time testing the existing SQLs with the new optimizer, taking advantage of newer capabilities properly (e.g. partitions) and performing some SQL rewrites to tune the SQL queries and Stored procedures.

CASE STUDY: MANUFACTURING DOMAIN

For a large cement manufacturing factory located in remote village area in India, the challenge was to manage their inventory, production planning, procurement of raw material and delivery of finished goods. With over 1000+ inventory items and warehouse spread over 2 acres it was all haywire to large extent. Company senior management team being miles away in Mumbai HQ was expecting production to go smooth and get real-time reports. The material suppliers on other hand were expecting detailed purchase order and a better payout performance for their invoices.

Existing system in place were having challenges to manage with multiple software applications, multiple entries of same data in different system, non-integrated or non-compatible system caused integration between systems. Different table structures and data elements restricted creating detailed report.

Our experts deployed a team of 2 members to study the existing system and the expected process at the factory. They also captured management expectations and supplier requirements to include in their design.

Sybase SQL server was chosen and using DWB and RWB (Data Work Bench and Report Work Bench) the entire system was built from scratch on Unix platform using Client-Server architecture. The application was installed on the mini-computer installed on the computer/IT department of the factory. System was used in a multi-user environment across factory with distributed network for gate entry, store-entry, production requisition, accounts-payable and management reporting.

Existing data were migrated out from legacy systems, restructured, cleansed and then imported to the new system to provide reporting based on past and current data.

Project was successfully completed to client satisfaction. Overall period for system design and development was about 10 months with a team size of 4-5 people including system architect, DBAs and developers.

CASE STUDY: BANKING & FINANCE DOMAIN

One of the major American Multi-national investment bank and financial services company based in NYC invited us as consultants and engaged us to help resolve a major performance bottle-neck in one of their Sybase application.

The application was locally developed for NYC team which later got implemented across 7 countries and within short period the usage picked up round the clock with several users logging at once. Certain core screens and forms used to take about 15-30 min to open and at times system got freeze.

The issue diagnosed by our team was in two critical areas of table-locking and process-threads that was resolved within two weeks of time that brought huge relief to all the users across the globe. Once the major issue was resolved, a detail project plan was conceived by our consulting team and handed over to the client’s IT team with long-term recommendations and suggestions.

CASE STUDY: INSURANCE DOMAIN

Our client, an US Based MNC in International Global Insurance Company was using a set of 2 applications with 3000+ users world-wide. Their management decided to move these applications on urgent basis from their current Data Center in US to another Data Center within US itself.

Our expert team took the challenge and formed a combined team from onsite and offshore centers. The execution involved setting up Dev, Test and Prod environment on the new Data center and migrating both applications and its data.

Entre project was successfully completed in less than 60 calendar days, with both applications up and running on new environment and handed over to client and their users for business as usual.

ASE TIPS

Installation Tips (Do’s and Don’t’s)
Upgrade Tips and checklist
Migration checklist, tips and tricks
Performance monitoring, tuning and configuration tips based on different system usage (OLTP, DW/Reporting, client-server, SaaS or cloud setup)
Backup/restore tips, methods and checklist
Disaster recovery checklist and tips

ASE FAQs

1. Which is the latest version of ASE?
2. What is the future of Sybase ASE after the takeover by SAP?
3. What is the current name of Sybase ASE? SAP ASE.
4. Is ASE available on cloud?
5. Which cloud platform supports or is considered best for cloud setup? AWS, Google Cloud, Azure, IBM Cloud
6. Can you help setup Sybase on private cloud?
7. How much time / effort is required to move Sybase ASE local to cloud
8. How much time does it take to migrate?

OUR SERVICE METHDOLOGY

Our expert team has a proven methodology that works for successful end results for customer satisfaction.

Understand & Team Formation

We deploy our experienced consultant to study the business scenario, pain areas, document and share with client team. This also helps build a rapport among all stakeholders from client team and our team.

Prepare and schedule

Our execution team will then start taking up tasks that are pre-requisite for the project and complete them. This helps tie any loose ends and fill the cracks before the major task begins. Example verify and setup backup / recovery tasks, prepare/update fresh list of database objects so we don’t miss them in plan, prepare parallel system as needed to keep business running as we perform the upgrade or migration till completion.

Execution

Typically, our plans would be arranged in multiple phases so that it can be easily monitored, completed and then proceeded to the next phase. Our execution team will arrive at the site or off-shore labs fully equipped with their tools, checklists, utilities and start the work as per Phase 1 plan. Once completed, the team coordinator verifies and gets client consent and moves to next phase.

UAT and Mock Run

Once execution is completed, the system moves to User Acceptance Test (UAT) mode, where business users will login and ensure the new upgraded/migrated system is as per business needs or as per agreed document and expected results.

Go - LIVE

Move or perform tasks for Live environment, ensure the tasks are completed within the defined downtime window, monitor each step/phase and keep the stakeholders informed.

Warranty

We provide 1/3/6 months warranty and support as part of our agreement with client, depending upon the nature and criticality of project.

INDIA

Bangalore:

Upside Cloud Technologies
No 530/B, Ground Floor,
19th Main, Sector 3,
HSR Layout, Bangalore.
560102.
Landmark: Near Allen Career Institute

Sybase/SAP ASE ENQUIRY

For any inquiries, questions or comments, Reach us: +91-9900569467 or fill out the following form

POLICIES

EDU & TRAINING

Training & Placement
Corporate Training

CONSULTING SERVICES

CUSTOMER SUPPORT