Denish possesses a wide depth and breadth of expertise and experience in database technologies. With detailed understanding of complex database infrastructures, he has implemented numerous database solutions addressing challenging business requirements. Denish has hands-on industry experience with Oracle, PostgreSQL, MySQL,  SQL Server and NoSQL databases. His expertise extends to heterogeneous database management, backup and recovery solutions, and performance optimizations. Denish leads OmniTI's database operations team. 

Prior to joining OmniTI, Denish was a database technology consultant on projects for enterprise clients in education, insurance, energy and pharmaceuticals, for companies such as Vectren Energy, Mylan Pharmaceuticals and M-Care Medicare Insurance. He holds an MBA from the Johns Hopkins University and a BS in Computer Science from Nirma Institute of Technology, India, and has spoken at the Postgres East and Postgres West Conferences.

 We are delighted to have both Robert Treat and Leon Fayer on the leadership team to help our customers meet today’s online platform demands.

~ Theo Schlossnagle, CEO

With many new clients coming to OmniTI each day for help with scalability and performance issues, as well as those who need strategic IT planning, custom CMS or guidance for starting up, some restructuring was necessary. As a result, Robert Treat assumed the role of COO and Leon Fayer took on Business Development. These positions will help to ensure that all of OmniTI's clients continue to receive, not only technology agnostic solutions to real-time problems from some of the best minds working on the web, but also sustain their close working relationships with staff.

In his new role, Robert will provide operationally focused leadership within the company, overseeing all aspects of the business, including marketing, sales, contract execution and team growth and development. Robert Treat is a veteran open source developer and advocate. A major contributor to the PostgreSQL project, he is an internationally recognized speaker on open source, databases and managing operations at scale. Prior to joining OmniTI, Robert worked at several companies including GTE, Sprint and WebMD, where he served in a variety of front-end and back-end web development roles, including user experience analysis, and more traditional systems and database management. He co-authored the book, "Beginning PHP and PostgreSQL 8: From Novice to Professional," and has written numerous articles.

As Vice President, Business Development, Leon is responsible for the overall growth, profitability and staffing of complex and highly visible engagements, overseeing multiple, mid-size projects and large integration efforts.  Prior to joining OmniTI, Leon worked on projects for enterprise level clients, and the Federal government―including the White House--leading a development team through a series of very successful content management systems implementations. Leon was one of the architects behind what is now IBM’s premier enterprise content management platform, and led teams through the architecture, design and development of content management (CMS), customer retention management (CRM) and workflow systems for very large entertainment, media and sports event clients. These efforts simplified outdated and overly complex existing systems, and reduced editor’s time to upload new content by more than 80% and ensuring that the applications could sustain traffic spikes of 800%.

"Wikipedia is one of the most visited sites in the world, serving tens of millions of articles to thousands of users per day worldwide, and we are excited to work with them to enhance the interaction between users and editors, and to improve the quality of the content as well as user experience."

According to their website, OSCON Data organizers, "distilled hundreds of proposals to answer these issues and share the innovative solutions (and admirable hacks) by the people who build and manage data infrastructure in a world that is increasingly dependent on information as it’s currency."

Theo Schlossnagle, Founder and CEO of OmniTI speaks on Monday about Real-Time and Streaming in a session titled, Esperwhispering: get your real-time data game on. Esper is an open-source complex event processing (CEP) system. In this session he’ll give attendees an understanding of how real-time data management is different from traditional data management, how Esper works, the possibilities introduced by incorporating CEP into your software stack and how to go about integrating Esper.

Robert Treat, Database Architect and head of OmniTI's Database Group, will speak Tuesday about Database Scalability. The session, titled, Database Scalability Patterns: Sharding for Massive Growth focuses upon sharding data across multiple nodes to handle both read and write traffic, even in cases where that traffic might not be uniform. He’ll cover how to keep things running; schema changes, index builds and failover scenarios, discussing the trade-offs and constraints that various databases will impose.

The other half of the equation will be covered also: the effects on the applications that must interface with the database. Sharded architectures add complexity to any environment, and navigating those waters can be tricky. He’ll cover some of the most common hurdles that OmniTI has run across, and show attendees how to stretch the patterns based upon their needs.

Treat will give a workshop on Wednesday, as well. Titled, Pro PostgreSQL 9, this session will help attendees go beyond the basics and get the information they need to go from "just another user" to "serious PostgreSQL professional."

OSCON Data will take place July 25-27, 2011, in Portland, Oregon together with OSCON.

PGEast was a great experience, as always, and OmniTI's Robert Treat and Theo Schlossnagle presented to attendees. Schlossnagle talked about using Esper to identify problems in real-time data. Treat presented "The Essential PostgreSQL.conf 9" and "Advanced WAL File Management with OmniPTIR"; hosted the Postgres in the Cloud panel; and gave the tutorial, Pro Postgres 9.

The large amount of Postgres usage in New York has been a widely held secret for many years, so it was nice to finally get to see this community come out of it's shell. As a frequent visitor to the city, I was happy to help out as much as I could with the conference, and met some amazing people while there. Kudos to the New York tech scene and the PG East crew for bringing it all together.

~ Robert Treat

In April, CEO Schlossnagle traveled to Moscow to talk about running high performance web caches and asynchronous queuing systems with the Russian Internet Technology Community.

In addition, he keynoted the Professional IT Community Conference in New Jersey this year.

May found Theo back in Europe where he spoke about decoupled systems at the What's Next, Paris event. The biggest Java event ever organized in France. It was an interesting event. . .

I would never have known this was the inaugural event. The topics, the staff, the venue, the audience and the speakers were all presented with seasoned excellence. Zeneka really understands a solid path for Java developer maturity and showed it through a spectacularly curated conference. I’m very pleased I could contribute something valuable.

~ Theo Schlossnagle

Meanwhile, Treat presented at PGCon in Ottawa, talking to attendees about OmniPITR and presenting, "Database Scalability Patterns, Sharding for Unlimited Growth."

At Velocity in June, Schlossnagle gave a plenary speech on Career Development and presented on actionable web performance for Ops, while Treat presented, "Managing Databases in a DevOps Environment."

I tried to shake things up a bit. With an opening plenary, you’re not sure if everyone is completely awake yet. Sure development and operations learn from each other, but cohesive organizations are much more than that. People at Velocity get that.

~ Theo Schlossnagle

Leon Fayer, OmniTI's VP of Business Development (and long-time web architect) participated in a panel on the current state and future of Content Management Systems, and presented a case study, at the Inbound Marketing Summit in San Francisco and gave a radio interview on the RSSRay show on designing websites that sell.

A busy Spring travel schedule didn't keep OmniTI from working with new and existing clients on projects such as:

--consulting on monitoring and trending solutions that will scale with rapid growth for Tumblr

--doing systems/architecture design consulting work, assisting with the design of a new application and the design of a new, multi-datacenter infrastructure for Chryon

--enhancements to current applications and user interface for National Geographic Expeditions.

Amidst the client work, open source collaboration and educational outreach, we're looking forward to producing Surge 2011, the scalability and performance conference, now in its second year. Registration is now open, so reserve your seat today.

One such advanced talk was the tongue-in-cheek, "P90X Your Database," given by Senior DBA, Denish Patel. This session focused upon a problem common in Postgres systems handling high update volumes; dealing with wasted space from old data, often referred to as "bloat".

"One of those things that comes up regularly on the database performance tuning discussion list are clients whose performance issues relate to "bloated" tables or indexes. Most clients are struggling to identify bloated tables and indexes, and others to trim bloated tables and indexes, without locking or database outages," said Patel. "Performance gains from shrinking a bloated database is the driving factor to make databases skinnier and faster, achieving better response time."

Attendees were thrilled to find out about tools for verifying system bloat, how to pinpoint specific tables and indexes within the system that are problem points, and some advanced tools for removing bloat as an online operation. Attendees could easily relate to those problems in this lively session, asking numerous questions to understand these challenges and how to resolve them, and get advice about how to work differently to avoid the problem in the first place.

Across town, Theo Schlossnagle, Founder and CEO of OmniTI, also participated on the Master Data Wranglers panel of industry leaders at the GigaOm Big Data Conference: Structure. They discussed topics such as managing large data sets, getting real time and/or rapid response analytics from that data, and dealing with security and disaster scenarios. The mix of academic and real world perspectives proved useful for attendees; as one member of the audience put it, "This was the best panel I saw all day".

Back at PGEast, our very own Robert Treat moved from the panelist's chair and picked up the microphone, serving as moderator for the "Database in the Clouds" panel. With practitioners from VMWare, Heroku, MongoDB and others, Treat hit on a range of topics, including trending and monitoring in the clouds, performance optimization vs. architectural design for cloud based solutions, and dealing with private vs. public cloud options. "Cloud solutions are often amorphous, so it's important to try to nail down specifics when you can. You can't be afraid to ask real world questions of your providers," said Treat.

Dealing with data is one of the leading challenges for many business these days, and OmniTI is helping people push those boundaries. We're proud to be recognized for this work by both conference organizations, and look forward to helping others as these challenges continue to grow.

For more on GigaOm's Master Data Wrangler's panel, please visit GigaOM: Is Big Data Making Us Dumber?

"With all of the changes in the open source database landscape, one constant has been the continued uptake and expansion of Postgres and it's userbase. PGEast as a result also continues to grow and gets better each year; and at this point I would say it's the premire event in the country for users, developers or those just starting to look into Postgres.” --Robert Treat

There is something for everyone at PGEast, from beginners to advanced users. OmniTI is excited to be participating again, with offerings for the beginner and intermediate user. Database Analyst Denish Patel; Database Architect and head of the Database Group, Robert Treat; and CEO Theo Schlossnagle will present four technical sessions and a half-day tutorial:

* P90X Your Database! Denish Patel. Obvious performance gain from shrinking bloated database is the driving factor to make database skinnier and faster in response time. This talk will explore ways to make your database skinnier for faster performance.

* Streaming databases: stepping outside of Postgres. Theo Schlossnagle. If you want the power of a complex database solution but have hundreds of thousands of new datum per second and need to run hundreds of thousands of queries per second it can become evident that a different approach is required. Introducing. . .Esper. Esper is a real-time streaming database (or CEP system) that allows running soft-real-time queries on streaming datasets. Esper is an excellent complimentary tool to Postgres and can completely alter the way you think about real-time data problems.

* Advanced WAL file management with OmniPITR. Robert Treat. Ever since the advent of PITR in Postgres 8.1, people have been creating one-off scripts designed to manage PITR and the xlog files that come with it. Finally, we decided we could do better, and OmniPITR was born. Designed to work with Postgres 8.2 and above, we've now replaced a whole mish-mash of scripts with something far more standard and re-usable. Cross platform and Postgres licensed, we have started to see more and more adoption outside of our client base, so we feel comfortable that it's a stable option for many of todays most demanding environments.

* The Essential PostgreSQL.conf, Robert Treat. While Postgres is generally considered easy to administer, these days it's config file contains hundreds of variables, which many find rather daunting. In this talk, attendees will review a break down the major areas that most people need to know about, and then discuss the config variables they'll most likely need to know. 

* Pro PostgreSQL 9. A half-day training session with Robert Treat. From start-ups to large enterprise shops, more and more people are using Postgres. Whether as a self-running data store, or to handle more complex OLTP, OLAP, and mixed database workloads, Postgres offers a lot of functionality and flexibility. What it doesn’t offer is a road map of how to go beyond the basics and get the information necessary to go from just another user to serious PostgreSQL professional.

For more agenda information and to register, please visit: https://www.postgresqlconference.org/

• Project renamed from SQL Server for WordPress to WordPress Database Abstraction
• Restructed from a patch to a WordPress must use plugin
• The plugin no longer touches or overwrites any core WordPress files.
• Now available through the WordPress.org plugin database.
• Easier updates to the plugin through your WordPress dashboard
• Several bug and SQL translation fixes
• Additional database support (SQLite and PostgreSQL) coming soon

To find out more about the update, read the full post here (http://wordpress.visitmix.com/development/wordpress-3-1-update)

Really cool news. Thanks to sponsoring from AWeber.com, and code by OmniTI's own, Brian Dunavant, OmniPITR now supports additional tablespaces in backup creation.

This works on both master and slave, and happens automatically without any kind of user interaction or changing options – OmniPITR simply detects if you have additional tablespaces and backs them up to data tarball.

More details are can be found under TABLESPACES in the omnipitr-backup-* docs.