Archive for October, 2009

SQL Administrator – Database Job Description, Requirements

October 25th, 2009



Database technologies have grown to a large proportion of most organizations’ information technology budget. As the dominant format, SQL databases have become a core part of the data infrastructure for most companies. The resulting shifts have increased demand for SQL administrator professionals with expertise in web data, MsSQL as well as a variety of software technology ranging from SQL 2000 to 2005.

An SQL Server Administrator works to develop secure SQL databases for a variety of organization as well as ensuring the free flow of data to authorized users. A core part of the job is developing a proper firewall to ensure that security rights are well established so prevent unauthorized data access both within and external to the organization. The ability to solve database problems is a particular important skill, as DBA administrators come across new issues nearly every day. While most days an administrator will work to develop and upgrade existing technologies, they also need to be able to constantly test and correct any issues with the database to avoid any potential problems down the road. Since large companies require fast data access, administrators are constantly upgrading systems and creating plans to upgrade software and hardware to improve performance.

While there are no firm degree requirements, most DBA professionals have an associates, bachelors or masters degree with a focus on information systems, computer science or software engineering. Most importantly, the skills needed to properly analyze the growth of web data is a broad set of quantitative skills that allow you to constantly learn new and emerging technologies. To that end, SQL DBAs should seek to become Microsoft Certified Information Technology Professionals which provides both certifications on existing technology, as well as opportunities for training on upgrades and forthcoming software options. MS SQL is a major component of SQL software, along with the open source mySQL solution. Most major companies rely upon a complete set of Microsoft solutions ranging from software to hardware, so a Microsoft SQL training course will cover the professional needs of most DBAs.

As a growing field, the career outlook for SQL administrators is strong with above average earnings and field growth projected over the next decade. In order to maintain competitive in the field, it’s important to be involved with ongoing professional training to stay ahead of the curve. Like most fields, ongoing professional development is a core part of gaining promotions in SQL database administration. Louis Zhang, Certdatabaseadministrator dot com

By: Louis Zhang

Eye On I-9

October 21st, 2009



A few weeks ago, I helped facilitate a peer-to-peer conference on HR Strategies on behalf of The New England Mail Order Association (NEMOA). NEMOA was formed in 1947 and is one of the nation’s oldest and largest professional organizations dedicated exclusively to the catalog industry.

In attendance were human resource and senior management professionals, representing catalog and e-Commerce businesses, both large and small.

One of the subjects discussed at our meeting was I-9 Employment Verification.

The new I-9 Employment Verification legislation is on the verge of passing in Congress, so I thought it would be a good time to give the subject a closer look. It’s a process that’s long overdue for establishing viable work eligibility in the U.S. And with some forward thinking on the part of management, and those responsible for human resources, it should be good news for a smooth, compliant transition.

Mandatory employment verification on the horizon.

Direct marketing organizations, like all businesses, have been collecting I-9 information since the original Immigration and Reform Control Act (IRCA) of 1986, which made it illegal for employers to knowingly hire unauthorized workers.

Although your attention may be focused on your hourly workers—typically high turnover individuals working in warehouse, distribution and contact centers—all employees must meet the same scrutiny.

Part of the IRCA created the I-9 document and the verification process employers must follow today in order to avoid sanctions. This verification process consists mainly of a physical review of identification documents (e.g., a social security card and a driver license) to establish both the person’s identity and the individual’s authorization to work in the U.S. In the 20 years since passing of the IRCA, the process has changed very little; however this basic and manual process has inherent issues that can result in applicant fraud and error.

Recently, the topic of immigration, and specifically illegal aliens, has reached a fever pitch. With the coordinated immigration protests across the country on May 1st as one of its high points, the U.S. government has been looking at the employment eligibility issue for some time. It has recently taken steps towards addressing the current challenges.

Step #1

In December 2005, the House took action to minimize illegal immigration by taking the first steps to tighten border controls and stop illegal aliens from obtaining employment in the U.S. The bill includes statutes that require, within two years of the legislation passing, all employers to perform an employment eligibility check directly with the Department of Homeland Security (DHS) for all new employees, or face civil or criminal penalties for hiring illegal workers.

Step #2

In April 2006, the Senate responded to the House bill by sending a bill (S.2612) to the floor called the “Comprehensive Immigration Reform Act of 2006.” If passed, the DHS and the Social Security Administration (SSA) will be required to implement a countrywide I-9 Employment Verification database and process. The bill also establishes steep civil and criminal penalties for noncompliant employers.

What does this mean for you?

You would still be required to obtain a signed I-9 form, backed by supporting documentation, from each new employee. What’s new is that you would be required to also submit the new hire’s information to the DHS verification system within three days of hire. Also, the law provides for reassessment of all employees through the system, regardless of hire date, to ensure eligibility to work in the United States.

How does the DHS I-9 Employment Verification work?

The new hire’s information is sent to the DHS database and the system verifies eligibility to work in the United States, verifies that the name and Social Security Number match, verifies the Social Security Number for wage reporting purposes, discourages the use of false documentation and levies penalties for the violation of hiring and/or employment eligibility laws.

What if the result is negative?

If the DHS search returns as a non-verification, the new-hire must be notified that their eligibility status was deemed non-verified and be given the opportunity to contest. If the applicant does not contest in the time allowed, the non-verification will be final. If they do contest, the verification will remain tentative until that time the eligibility is deemed either verified or non-verified under further review.

Who must conform?

Until the new law is passed in Congress, I-9 Employment Verification is currently available in all 50 states on a volunteer basis. If a company decides to participate in the volunteer program, it must screen all new-hires in a search conducted post-hire, within three days of the employee’s start date.

While the program is still voluntary until the act is passed, you can count on the fact that the government is serious about illegal immigrants and establishing a program to ensure that work eligibility verification will happen soon. There’s every reason to believe that some version of the “Comprehensive Immigration Reform Act of 2006” will exist and companies should start planning to implement an I-9 verification program in the near future.

For more information on the summarized bill “Comprehensive Immigration Reform Act of 2006,” visit the Library of Congress at
http://thomas.loc.gov/ and search for S.2612.

You may also want to check out the services of independent, third party employment verification and screening providers.

Much of the information contained in this article was provided through the website of The US Department of Labor, Employment Standards Administration: Compliance Assistance—Immigration Reform and Control Act.

By: Les Gore

The Equal Employment Opportunity Commission Gets a $23 Million Boost

October 18th, 2009



On December 13th the Senate passed the 2010 omnibus appropriations bill. Under the new funding bill an additional $23 million dollars will be directed to the Equal Employment Opportunity Commission to help tackle a growing backlog of discrimination complaints. The perennially cash-strapped employment enforcer will use the much needed budget to boost staffing levels and beef up on litigation attorneys. With more EEOC representatives attacking the standing cases, companies can expect a more agile organization with shorter response times for equal opportunity complaints.

Over the years the Equal Employment Opportunity Commission has suffered consistent staffing and funding cutbacks with an increasing rate of complaints being filed year to year. From 2007 to 2008 the complaint backlog jumped over 30 percent. The chronic underfunding has held up from the Clinton administration through to the recent Bush Administration. With some active cases standing at over 3 years old, both government litigators and corporate lawyers agree that the situation has reached an untenable state.

A key piece of the economic revival strategy, equal employment opportunities are being targeted as a means of leveling the job market playing field. From the President down to the house of representative EEO enforcement sends a clear message to constituents that Law Makers are vying to protect the entire spectrum of voters during the slow revival.

While many corporate lawyers see the funding boost as a positive sign, companies are gearing up for an increasing number of EEOC Audits. Ultimately, reducing the 3 year backlog only helps bring the case to judgment. It is preferential to both side to minimize the length of time between complaints and resolutions. In addition to reducing the standing backlog, new EEOC resources will be utilized for new regulations concerning bailout recipients. Under the terms of the American Recovery and Reinvestment Act of 2009 all government contractors who received bailout funds will be flagged in the Federal Contractor Selection System for potential future audits.

With a boost in EEOC resources companies need to be more stringent in their enforcement of equal opportunity practices and their record keeping for equal opportunity compliance data. On the positive side, average Equal Employment Opportunity case length should shrink. Given the funding implications, applicant tracking software companies have developed built-in EEO tracking features to automate the data capture process and provide push button EEOC compliance reports. Companies that maintain best practices when hiring, stay up to date on EEOC guidelines and take advantage of technology should stand to benefit from a reinvigorate Equal Employment Opportunity Commission.

By: Byron Mackelroy