Organizations as diverse as 7-Eleven, American Solar Direct, Bloomin' Brands, Cisco Systems, Google, McGladrey LLP, NASCAR and OmniTI are among those recognized by The American Business Awards, the U.S.A.’s premier business awards program.
This year’s Gold, Silver and Bronze Stevie® Award winners in Information Technology will be announced on September 12 in San Francisco. A record number of nominations were submitted this year with more than 3,300 from organizations of all sizes and from virtually every industry. The ABAs include a wide variety of categories including information technology awards. Finalists were chosen by more than 130 business professionals nationwide during preliminary judging in April and May. Members of nine, specialized final judging committees will determine Gold, Silver and Bronze Stevie Award placements from among Finalists in judging that will begin next week. More than 280 executives will participate in the judging process this year.
The OmniTI Database Operations Team, led by Denish Patel, is managing database operations for some of the most highly trafficked e-commerce websites (many in the Alexa top 100), serving 100MM+ worldwide users and having $1B+ in online gross sales. The team has a wide depth and breadth of expertise, and experience with a wide range of database technologies. With detailed understanding of complex database infrastructures, the database team has implemented numerous database solutions addressing challenging business requirements for our clients.
This Team evaluates database technologies, performs installations, upgrades, performance audits, backups and recovery, and ensures 24/7 availability of the databases. The team has completed some very critical projects for our clients, such as:
- One retail client's half-Terabyte production Postgres database was upgraded from Postgres 9.0 to Postgres 9.2 (with in-place upgrade) with less than 20 minutes outage.
- The production databases for well-known financial firm were upgraded from Postgres 8.1 to Postgres 9.2 and the database server was moved from SAN storage to local storage on SSDs. This upgrade improved performance by more than 2000%.
- The Team upgraded Postgres database server software and hardware for a very large install of MessageSystems product using Postgres at one of the largest newsletter publishing firms in the world. This upgrade helped them to improve mailings generation throughput by 33%.
- The database of a very large Real Estate Investment Trust) Postgres database servers were migrated from a Virginia to an Illinois datacenter with less than 15 minutes outage.
- Another client's production Oracle database was migrated to PostgreSQL 9.2, freeing them of more than $700,000 in licensing fees annually.
- The Team helped a library consortium to improve their top resource intensive queries to perform up to 5000 times faster.
OmniTI wrote a tool called OmniPITR to manage replication and backups for Postgres database servers. Subsequently, capability was extended to take backup of databases on Hadoop or Amazon S3 for taking backups off site, and users can create encrypted backups. This is an open source tool that doesn't cost our clients anything, and was released back into the community so that everyone can benefit from it. A number of companies outside of OmniTI now use this tool for managing replication and backups.
The Team continues to look for additional ways to contribute to the postgresql community. Currently, they are reviewing commit patches and going through the source code to make more useful contributions.
Denish and team speak at many conferences around the world each year. Look for them at the NY Tech Summit , PGCon and OSCON
Congratulations everyone!