integration and implementation of technology-focused business solutions

November 2012

How to Eliminate Expensive DBA Turnover

November 30th, 2012

Are you sick and tired of training your DBA's, then watching them leave? You're not alone. Nobody wants to constantly be training new DBA's, have them around for just a short period of time, then watch them leave.

Fortunately, that brain drain is one of the primary problems LSG Solutions help companies in Oklahoma and surrounding states address.

Many times, database administrators move around from company to company. They really want to be challenged by the work they're doing. If there aren't many new projects, they get bored. They want to experiment and learn with new technology.

Essentially, they are constantly concerned that they may be getting rusty. Playing with those new technologies lets them keep their skills sharp. The issue is that if you don't have that kind of dynamic environment, and you keep hiring good DBA's, you'll keep losing them. If they're good, they know the only way to stay fresh is to be somewhere they can learn those new skills.

LSG Solutions can help retain those employees by taking care of the mundane, routine database monitoring that bores your DBA. We continually monitor and review your production database environment with the goal of proactively identifying and eliminating factors that tend to end up causing issues.

We have over 10 years of DBA success, and can provide you with senior-level production support coverage on a fixed fee basis.

When you have us do that monitoring instead of your DBA, it frees him up to be constantly challenged with more interesting projects. And since he's working on more interesting projects, he's much less likely to leave you for greener pastures.

If you've been frustrated by high DBA turnover, contact us at 405-285-2500 or at to see if we're a good fit for your DBA needs.

Comments: None

LSG Revamps the Oklahoma Sex Offender Registry

November 13th, 2012

Earlier this year, LSG Solutions was contracted by the State of Oklahoma to update the Oklahoma Sex Offender Registry web application site. Originally built back in the early 2000's, the original system was very informative, but had become out of date. While several similarities are in place, we also added several new features for the Oklahoma tax-payer and Oklahoma local law enforcement.

In addition, the specific technologies we used allowed us to hit a very tight federal grant deadline.

The Public Interface

Two of the primary benefits will be strongly appreciated by the Oklahoma citizen. First is the ability to see the location of sex offenders via a Google maps interface. Second is the ability to sign up for notifications when a sex offender moves into your specified area.

While the previous system simply listed out the names and address, the new Google maps interface gives the public the ability to easily visualize the location of a sex offender's residence. The mapping technology wasn't there when the system was originally launched in the early 2000's. Instead, you had to search by zip code and rely on a text-based list of addresses.

The new mapping capabilities bring the system up to date with what people currently expect in web-based location databases. It lets you search by address and specify how many miles around that address you want to search, then shows the results on a Google maps interface.

With the email notifications, you can enter one email address and up to five physical addresses to have monitored. Whenever there is any sex offender movement within your specified radius of each of those addresses, you'll receive an email notification.

The Oklahoma Law Enforcement Improvements

Regarding other improvements, the old system relied on an older web browser, Internet Explorer 6. Because that web browser was from 2001, most of the law enforcement officers were unable to update the database themselves. All those updates were passed to the Sex Offenders and Violent Offenders Unit, who were frequently backlogged as a result.

Now, with the new system more officers have access to update the data, which means more reliable, up to date information in the system.

Why LSG Solutions Was a Good Fit

In 2006 the Adam Walsh Act, aka SORNA, passed. The Act defined standards across all states. The work LSG Solutions recently completed was Phase One of the project, which brought the Oklahoma Sex Offender Registry into compliance with the Act. As part of those upgrades, it added new features for the public interface and more modern compatibility for Oklahoma Law Enforcement.

The Oklahoma Department of Corrections became aware of a grant that was available if they complied with the Adam Walsh Act before the end of August 2012. The work had to be done under a very specific deadline. The Oklahoma DOC didn't know if any company would be able to complete the project on time.

Fortunately, LSG was able to recommend and utilize specific rapid software development technologies that allowed for a much quicker turnaround than other companies. Phase one of the project began in May 2012, and ended in August 2012. The new system went live the final weekend in August, and hit the hard deadline required by the granting authority. Citizens are increasingly signing-up for notifications. Their online feedback has been very motivating. Now Law Enforcement can perform their activities while taking back the unusual burden placed on the Sex Offender Administration Unit. Both parties now can appreciate the features Google Maps brings for visual safety monitoring and locating the registered sex offender in the public.

Comments: 5


501 E. 15th St., Suite 200B
Edmond, OK 73013