Shreeyansh Technologies is a group of passionate, highly skilled Database Administrators and Engineers who have rich expertise across PostgreSQL, EDB Postgres Advanced Server, Oracle, MS SQL Server and MySQL.
The team has deep understanding in database architecture, configuration, management and quality with extensive exposure in delivering these capabilities as per the business needs. We can compete with the established players in this space and can work together with the organization to offer tangible result driven, cost effective solutions in various database platforms.
The Consulting provides end to end analysis with the aim of building custom solutions for business needs by using powerful, scalable proprietary/open source tools and scripts which are platform independent and performance driven.
Our core values together with our business ethics and expertise help us drive to maintain guaranteed service quality across various database technologies. Customer delight is at the heart of whatever we do in this space.
Methodology / Process :
- Customer Call/Email
- Understand the customer requirements/pain points
- Recommend best possible cost effective services short/long term options
- Sign off Statement Of Work (SOW)
- Acquire remote connectivity
- Plan the work and take necessary business approvals wherever applicable
- Perform the agreed SOW tasks
- Deliver the Consulting report wherever applicable
- Discussion call/email on the report if applicable
- Propose future needed service offerings to safe guard the production Env’s.
- Closure of the service engagement
List of Consulting Services
1) Design of Robust Backup Strategy:
Backups are essential key components of any production databases and design of robust backup & recovery strategies to be implemented with utmost care to safe guard the complete environment to recover when disaster happens.
Backups play very important role hence storing backups to multiple location to be planned very carefully and recovery test procedures to be followed once in quarter to make sure the intact of backups and successful restoration of data if any emergency need arises.
2) Database Upgrades:
Every RDBMS have fast development cycles which result towards release of higher database versions by incorporating advanced features, bug fixes etc.
The faster release of new versions make the older versions to unsupportable from their support life cycles. At some point it becomes mandatory for the customers who are in use of very older versions in upgrading with new versions to take the benefits of newly added features and performance improvements. Database Upgrade is to be planned at regular intervals, to be par with latest versions for a mission critical applications that need to be performed by the Database Administrator which involve downtime to be based on the process followed along with database size.
It’s recommended in use of latest database versions with planning minor/major upgrades versions at regular time interval with complete testing before production implementations.
3) Data Replication:
Due to increase in data size, it’s becoming a challenge for getting higher downtime from the business team if the application is depending upon the single database server that lead towards higher recovery time while restoring from the available backups resulting towards data loss that solely based on the type of backups implemented. Nowadays, Data replication has become the key element for any database deployments which helps in reducing great downtime and data loss.
Most of the RDBMS open source/ Proprietary offers wide range of replication options which can be implemented as per the design needs and requirements.
PostgreSQL offers below replication options where each have their own advantages and disadvantages.
- Streaming Replication
- Cascading Replication
- Synchronous/Asynchronous replication
- Multi Master replication
4) Disaster Site (DR) Build
Business data is vital and DR setup enables keeping a copy of running database syncing with primary in different Data Center (DC) which fulfills as a high availability option and can be used for load balancing as well if need to be. Most of the RDBMS supports Logical or physical stand By databases and implementation varies from one RDBMS to another.
PostgreSQL offers below standby options.
- Warm Standby setup
- Hot Standby Setup
5) Architecture Health Check
Database Architecture Health Check is a service engagement with detailed review of database deployments that runs on various operating systems. During this service, we inspect all aspects from hardware, operating system, database perspective with out making any changes to your production environment. During this service, we go through all database details and perform analysis on the collected data. A detailed Database Health Check report will be delivered after completion of analysis that helps to implement on the customer databases as per the customer time-lines.
6) High Availability with OS Clustering Solutions
Any RDBMS need to be always available for business continuity and HA can be obtained by various options either with minimal manual intervention or fully automated.
PostgreSQL supports both options. PostgreSQL HA with automatic failover/switchover can be achieved by using operating system clustering solutions which may incur extra license costs wherever applicable.
- Steeleye – Lifekeeper
- Redhat Cluster suite (RHCS)
7) Performance Tuning
Performance Tuning is one of the most critical part which needs more analysis from various components that falls under Operating System, Application, Network and Database. The application deployed code plays a very vital role that based on the application design, code implementation methods and write of SQL queries in business logic. Many of the mission critical application see the performance impact because of unoptimized queries used in the code when data size grows resulting towards major performance degradation, increase in server load with usage of more server resources.
Tuning need to performed in parallel on all components like application, database and Operating system level in order to maintain the intact the performance as per the growing business demands.
Shreeyansh offers database tuning as well as SQL tuning based on the customer needs.
As the table size grows it becomes challenge to maintain the performance of the application because of data sets. Many RDBMS have come up with partitioning feature that enables to cut down big tables into smaller chunk with out making any changes at application side resulting towards execution of the application queries on smaller inherited tables rather than the big table. This mechanism helps greatly in performance improvements derives table to grow horizontally rather than vertically.
PostgreSQL support Partitioning feature along with various options.
9) Connection Pooling & Load Balancing
Database establish the client connectivity in dedicated or shared server model to fulfill the incoming user requests. By default, dedicated server connection is established by the database server which will be assigned to the respective user/client and never be shared among others till the user request gets fulfilled/completed. In other model, the shared connection is established which will be shared among other user connection resulting towards handling increase in user connection requests with the help of connection pooling features.
PostgreSQL supports database level connection pooling the enables to utilize the existing idle available database connections rather than creating dedicated server connection making room for more connections by using existing hardware resources.
PostgreSQL also has the ability to balance the load between two or more servers to take off the load from the primary server and replicas.
10) Migration Assessment
Migration Assessment is service offered by Shreeyansh Technologies as a first step in stone for migrating customer databases that resides on Oracle, EDB Postgres Advanced Server, MS SQL Server, MySQL to Open Source database – PostgreSQL. Every database has come up with own set of rich features list and there is no apple apple automatic conversion is possible to move off from these databases directly to PostgreSQL.
A detailed analysis performed through migration assessment on the source databases and reach to conclusion whether the said database is good candidate for migrating off from proprietary database to PostgreSQL.
Based on the post migration assessment, actual Migration project estimates provided as next course of actions.