Upcoming speaking engagements (as of 12/1/2020) #SQLSaturday

I received an email this morning about an upcoming speaking engagement, so I figured it was time to update my list.

I received word this morning that I will be speaking at Minnesota virtual SQL Saturday on December 12. I will be doing my job hunt presentation (which reminds me: I still need to update my slides).

Anyone can register for SQL Saturday, and it’s free to do so. (And you don’t even have to be a techno-geek to attend!) Go to the site to register for this event.

Hope to see you online on December 12!

The worst online job application #JobHunt

In my job hunt experience, I might have come across what may be the worst online job application I’ve ever experienced — so bad that I felt a need to write about it. I will not identify the institution, other than it is a well-known institution in the Albany Capital District. Maybe if a representative from this institution is reading this article and recognizes that it is theirs, they’ll realize what a horrible experience this is, and takes steps to fix this problem — and yes, it is a BIG problem. I consider this a case study in how NOT to set up an online job application.

In my job search, I started looking into specific companies to which I could apply, so I went to this institution’s web site. I went to their careers section, found a few positions that I thought were interesting, and started applying for them. This is where the horror show begins.

Most online applications that I’ve experienced generally have an option for you to create a profile that includes your identifying information, resume, background, and so on. Indeed, I had applied to this particular employer years ago, and they had such a system in place back then. I poked around to see if I could find my previous profile, but I couldn’t find any such link. I figured, no matter; they probably had my old email address back then, so I’d probably have to create a new one.

As it turned out, this was a red flag.

Throughout my past several months of filling job applications, I’ve gotten used to ATS systems that read your resume or LinkedIn profile and autofilled job applications based on your resume and profile. I’ve had mixed success with these systems with varying levels of frustration, but for the most part, they’ve saved me a great deal of time and effort with applying for positions.

Unfortunately, for this employer, there was no such system. I clicked the button marked “Click Here To Apply.” It took me to a page that had this interface.

(At this point, I want to point out the part that says “You may add additional positions to this application.” I’ll come back to this later, but let me say that [1] during this first run-through, I wasn’t thinking about other positions yet, although there were others that interested me, and [2] I did not see this on the first go-round. Those of you who follow my post regularly know how much I emphasize that “reading is work!!!” Again, hold this thought; I’ll come back to this.)

Okay. I clicked Continue. The next screen was the standard HR-ese about EEO and code of conduct. I clicked the requisite box and clicked Continue again.

The next screen asked me to fill out my name, address, email, and various other boxes (“have you ever worked for [name of employer] before,” etc.).

Wait a minute. It’s asking for my name. Shouldn’t it ask to upload my resume or connect to my LinkedIn account? I looked around, and there was no such button or link. Okay. I filled the requisite fields and clicked Save & Continue.

The next screen asked questions such as date available to work, salary requirements, relatives that work for (name of employer), and so on. Again, I answered what they asked, and once again, clicked Save & Continue.

The next screen displayed the following.

I took issue with this question, particularly with the “highest graduate education year completed.” I have a Masters degree, I went to school part-time, and it took me 4½ years to get it, taking a class per semester (and a summer session) as my schedule allowed. So does that mean I click 4 (as in it took me 4+ years), or do I click 1 or 2 (as it typically takes to get a Masters degree full-time)? It did not specify, and there were no instructions. I don’t remember what I answered (I think it was 2), so I went with my best guess as to what they wanted.

Directly under that question was this.

Wait a minute. You haven’t asked me to attach a resume. I suppose it’ll ask me later (I still don’t understand why it didn’t ask me to attach one at the very beginning). I clicked Save & Continue.

The next screen asked about job history.

I already have my employment history on my resume (which you still haven’t yet asked me to attach, upload, or link). You really want me to take the time to fill this in? This screen frustrated me; I’ve been working professionally for thirty years. You really want me to fill all of that in? And why aren’t you autofilling it from my resume (that you still haven’t asked for yet), like everyone else using ATS is doing? The application only asks for at least four years of employment history, but I’ve only worked for a few companies over four years, and it doesn’t tell the entire story of who I am or my professional history.

Nevertheless, the application system had me over a barrel, so I had no choice but to fill it all out. Let me emphasize that the form is not easy to fill out; all dates are drop-down selections (which, I should add, don’t work very well), they don’t auto-format fields such as phone numbers (e.g. they don’t limit area codes to three digits), and you have to fill out the fields for employer, title, job description, and so on.

I don’t know how long it took me to fill it all out. I’ll estimate that it took between fifteen and thirty minutes. It felt like several hours.

It next asked for personal references, if I had fewer than two employers. Since I definitely had more than two employers, and I didn’t feel like filling out more than I had to, I skipped this step. (And I should note: what if I worked ten years for only one employer? Yet another problem with how this application was put together. Whomever it was that put this together was obviously not thinking.) Again, I clicked Save & Continue.

At this point (step 8 of 12, according to the application), it asked to upload documents (resume, cover letter, etc.). It only allowed up to two documents (most other applications I’ve filed allowed for more than two). Okay. I added my resume and cover letter, and clicked Save & Continue.

Finally, it got to the point to review everything I’d filled out (very painfully, I should add). I clicked Save & Continue. Subsequent screens displayed the requisite EEO questions — race, veteran status, and so on. I clicked through the screens. My application was submitted.

At this point, I went back to apply for other positions that interested me. It was here where the employer’s application went from being frustrating to downright infuriating.

Almost all automated job applications send an email acknowledgement, so I looked for one after I finished the arduous procedure. I didn’t see one. After waiting for several minutes and poking around my email, I finally found this sitting in my spam folder.

It sent it as an attachment? No wonder why it was flagged by my spam filter. Since I trusted the sender (or, more accurately, I knew from where it had been sent), I went in and followed the instructions. Okay, fine. I downloaded it and followed the sign-in instructions. It had me sign into their system, where I found this message.

Granted, there was no identifying information (other than my email and the employer, which I blacked out in this screen capture). Now, I am all for data security and ensuring data is protected, but did this message warrant sending a secure attachment and requiring a login? I don’t think it was. I’ve gotten other emails from job applications that included more information that was sent less securely. One other thing I found infuriating was that there was absolutely no reference to the position that I had applied. I’ve been using my email to keep track of applications. How am I supposed to know to what position this refers? In my opinion, this message was not worth sending in a super-secure email. I felt that the mechanism they used to send this message was overkill.

I had seen other positions on the list that interested me, so I went back to apply for them. I figured that the system would take my information from the previous application and use it for the new application.

I figured wrong.

There was absolutely NO mechanism to refill all the information from the previous application. There was no applicant account function, no resume or LinkedIn ATS autofill function, nothing. If I wanted to apply for another position, I had to refill the ENTIRE application manually. Did I mention how painful and tedious it was to fill the application? It might as well have taken several hours to do so.

Now, remember earlier how I mentioned that there was a link to “add other positions to your application”? I did not see that the first time around. The next time, I tried it. The link brought me back to the ORIGINAL job search page. There was NO function to add any other jobs to an existing application. Nothing like that was anywhere to be seen. And if it did exist (and I’m not sure that it does), it is not obvious.

This application system design is so horrendous that it’s saying “f**k you” to applicants. It is doing more to drive applicants away than it is to make them want to apply for positions.

This is not the first time I’ve written about bad form design. However, this problem isn’t just about the form; it’s also about the entire application process. The design planning was poorly thought out, if it was done at all. There is no mechanism for autofilling fields. There is nothing to save applicant data. The forms are not intuitive. And I’m willing to bet large sums of money that either there was no end user or QA testing done, it was done shoddily, or test criteria were poorly defined.

I could keep going, but to make a long denunciation short: whomever it was that put this together has absolutely no business working on UX/UI projects.

The object of well-designed UX/UI and online forms is to make it easier, not harder, for end users. As an applicant, I found this process to be infuriating, not just frustrating. A process this bad will likely deter qualified applicants from applying to jobs. And if this system is that badly designed, these applicants are likely to question whether they want to work for this employer in the first place.

You didn’t ask questions at your interview? You just blew the interview #JobHunt

This afternoon, I saw a tweet from James Phillips, who posted this:

It reminded me of what I think is an important point when you’re interviewing for a position. I responded with this:

This is a point that I emphasize in my job hunt presentation; in fact, I made mention of this in an earlier article, and I think it’s important enough that it’s worth emphasizing again. When you’re preparing for a job interview, make sure you have at least two or three questions prepared for the interviewer (I’d even prepare more that that; note that you don’t have to ask all of them). I’ve also mentioned this during Thomas Grohser’s interview presentation. I’ve sat in on his presentation a number of times (sometimes at his request), and I make sure that I bring this up as a talking point.

If you’re interviewing for a job, one of the worst things you can do is NOT ask any questions at an interview. I’ve heard several stories of people who blew their interview because they did not ask any questions — and for good reason.

When you’re interviewing for a position, keep in mind that you’re interviewing the company just as much as they’re interviewing you. You want to ensure that the position is the right fit for you — that it’s something that interests you, something you think you can fulfill, and the company culture is the right fit.

Asking questions is also a signal to the interviewer. It demonstrates that you are interested in the job and the organization. Not asking questions not only shows that you’re not interested, it also shows that you aren’t taking the interview seriously. This could prove fatal to your job interview.

That being said, it’s also important to ask the right questions (I actually wrote about this a while back). The best questions are those that demonstrate that you’re willing to be a team player for your prospective employer. For example, one question that I always bring with me to every interview is, “what is your biggest issue, and what can I do to help?” It demonstrates that I’m interested in the company, and that I’m willing to help resolve any issues that arise. Try to avoid questions that are self-centered (e.g. “what’s in it for me,” “what’s the salary range,” etc.). (That said, you’re going to want to know about the company, so try to phrase your questions in such a way that it doesn’t sound like, “what’s in it for me?”)

Whenever I prepare for an interview, I’ll research the company, and I always prepare appropriate questions in advance, such as “how can I help you solve your problems” (shows that I’m a team player), “what challenges does your organization face” (shows I’m interested in the company), or “what does your team do for fun” (shows I’m interested in team dynamics).

A resource I’d suggest is a book or website about good interview questions. There are a number of them out there (here’s a link to a few books on Amazon). Go to your local library, buy your own copy, or search Google. All of these provide good suggestions for appropriate questions to bring to a job interview.

Asking good questions won’t necessarily guarantee that you’ll land the job, but not asking questions nearly guarantees that you won’t get the job. Prepare questions in advance, and be prepared to ask questions as things come up during your interview. Don’t blow your interview by not asking any questions.

Your job application was rejected by a human, not a computer.

Last Saturday, at Virtual SQL Saturday #1003 (Memphis), I sat in on Christine Assaf‘s presentation about Organizational Trauma: Mental Health in a Crisis (or something like that — I don’t remember the exact title). I found her presentation interesting and relevant to my own; so much so, in fact, that I invited her to sit in on my presentation and offer any of her insights.

After this weekend, Christine wrote this ‘blog article. I haven’t yet had a chance to fully process it (as I’m writing this, I haven’t had my coffee yet, and my brain is still in a fog), but what little I did process, I found interesting.

I intend to scrutinize this more when I’m a little more awake. And I suspect I’ll be making some adjustments to my presentation.

HRTact

INTRO:
Recently I attended a presentation where a commonly held belief was repeated and I feel the need de-bunk this. The speaker stated “75% of applications are rejected by an ATS (applicant tracking system) and a human never sees them…”

First, I want to point out that recruiters will tell you this is false. As the main users of ATSs, recruiters have extensive experience and years in talent acquisition, and will tell you they hear this all the time and they cringe upon it’s utterance. But if you want to know my opinion on why this “myth” has infiltrated the job seeking world, scroll past all the research and jump to the end.

MY RESEARCH:
Secondly, let’s track down the origin of this false statistic. The speaker I heard it from cited topresume.com. So I did some digging:

From topresume.com

That topresume.com article (which includes the same false stat…

View original post 1,019 more words

Bad web forms — how to drive people away from your site

I’ve come across my share of bad design, and I’m sure you have as well. I’ve especially come across some egregious examples as a job applicant.

I came across one that particularly set me off. While poking around Indeed, I found a technical writer position for GitLab that interested me. Of course, most people who work in IT are familiar with GitLab, so they have a reputation. I read through the description, and it sounded interesting, so I clicked the button to “apply on company site.”

The subsequent link took me to this page.

The page talks about the technical writer roles and responsibilities. It talks about the hiring process, it includes a salary calculator, and it even talks about benefits, including stock options.

Nowhere on the page was there any link to actually apply for the position!!!

If you don’t believe me, check out the link and see for yourself. No wonder why they need technical writers. I understand and appreciate GitHub’s reputation in the IT community, but this page is seriously making me question whether or not I really want to work for them.

GitHub is far from being the only offender. I came across another page that, even after they asked me to upload my resume, it still asked me to manually input my work experience. (Even worse, these were required fields; there was no way around this. What if you’re a student with no work experience?) After I hit Submit, it came back and told me there were errors. It had cleared out all the dates I’d entered (I had entered months and years), and it insisted that I entered days. Seriously, raise your hand if you actually remember what day you started or ended a job from years ago. I have enough trouble just remembering the month or year. It made me question how well their automated formatting really worked (if it worked at all). Once I filled those in (with the best guesses for days), it told me there was another error. I clicked the message, expecting it to show me where the error was. Nope. It just told me there was an error. I had to search the entire page to figure out what it was complaining about.

I’ve come across too many forms like this during my job hunt. I also remember coming across some very badly designed forms years ago from previous job hunts — some that were so badly designed that they discouraged me from applying for the jobs.

I’ve talked about making documentation easier for the end user, and this is far from the only article I’ve written about how bad design is a detriment to anyone who needs to follow instructions. UX/UI needs to be as painless as possible for the end user. If you’re a vendor, bad design can drive away customers. If you’re an employer, you run the risk of discouraging qualified applicants.

Like good documentation, good form design needs to be well-thought-out and well-designed. Don’t be the organization that lost customers because your forms were too arduous to use.

I’m speaking this upcoming Saturday, October 3 #SQLSaturday #SQLSat1003 #SQLSatMemphis

Memphis Tile Supplier | Custom Tile for Flooring & More

This upcoming Saturday, October 3, I will be speaking at SQL Saturday #1003, Memphis. Of course, because of pandemic restrictions, I will not actually be traveling to Memphis; SQL Saturday #1003 is virtual, and I will be presenting from my home office in Troy, NY.

(In a way, it’s too bad I won’t be in Memphis. I’ve heard good things about Memphis barbecue!)

A lot of people (myself included) have lost their jobs during the pandemic, so it’s especially apropos that I will be presenting my session titled, “I lost my job! Now what?!?

If you want to check out my (and other great) sessions this Saturday, use the SQL Saturday #1003 link to register.

Hope to see you virtually this Saturday!

Social media: should I stay or should I go?

I don’t think I have to mention just how prevalent social media is these days. If you’re reading this ‘blog, most likely you’re engaged in some form of social media. Terms such as Facebook, LinkedIn, and Twitter are a regular part of daily life these days. It’s gotten to the point that these terms have become verbs (e.g. “Facebook it”). Even I’ll tell people that “the best way to get a hold of me is on Facebook,” and I’m the first to admit that I generally can’t go a day without checking my Facebook app on my phone.

In these times of divisiveness, security concerns, and ‘bots, I’ve also seen a number of friends say, “I’m closing my Facebook account” or “I’m shutting down my LinkedIn.” I’m often saddened by these, because one of my main reasons for maintaining Facebook (which I’ll expand upon in a moment) is to easily keep in touch with friends and family. Any time a friend says that (s)he is shutting down his or her account is a contact that I lose. It doesn’t mean that (s)he is no longer a friend; it just means that it’s a little more difficult to keep in touch with that person.

However, a lot of people are (understandably) turned off by the negativity and political discourse that are pervasive on social media. People have written articles about how much better their lives have become after shutting down social media. I completely understand how people are disillusioned by what they see on social media.

So I get it when people ask this question about social media: should I stay or should I go?

I’ll give the standard DBA answer*: “it depends.”

(*For those who don’t understand the reference, the widespread joke among data professionals and IT people is “it depends” is the standard response when they are asked just about any question.)

Not satisfied with that answer? Let me expand on it.

I don’t think I need to get into why people want to leave social media; there are too many obvious examples of that out in the wild (and maybe a few not-so-obvious examples, such as data security and privacy, and the “need” — a very stupid reason, in my opinion — to maintain social status). People are getting stressed out over these issues. I certainly understand why people want to leave social media, and I won’t decry them for it. So instead, I’ll talk about some reasons why you might want to stay.

Like just about anything else, social media is a tool, a piece of software developed for a purpose. Mostly, that purpose is communication. People have been talking about the shrinking world for years. Social media contributes to the world shrinking even further.

I mentioned earlier that I maintain my Facebook account so that I can easily stay in touch with friends and family. It is the primary reason why I first joined Facebook, and it is why, even despite all the issues that come with it, I maintain my account today. Humans are social animals, and more often than not, humans need to maintain social contact with one another, especially so these days with the COVID-19 pandemic. I enjoy talking to people and keeping in touch with friends, so for me, personally, these reasons outweigh all the problems and tribulations that come with Facebook, and maintaining my account is worthwhile.

Some people seem to think they have to maintain some level of status on social media, like trying to compete in some type of popularity contest. Personally, I think this is one of the biggest bullshit reasons to be on social media. I could not care less about how popular I am. I’ll post about personal news that’s happening in my life, something on my mind that I want to get off my chest, ask a question about an issue I can’t seem to solve on my own, or occasionally express an opinion (although I do try to avoid anything having to do with politics; personally, I despise politics passionately). If you’re on social media to maintain social standing, I think you’re on it for the wrong reason. (Trying to sell yourself is a different matter; I’ll get into that shortly.) If I don’t care about my social standing (and I don’t), then I don’t have to concern myself with maintaining it on social media.

That is why I want to be on social media. However, I also think there are reasons why you should be on social media.

Love it or hate it, social media is prevalent in our society today, and I don’t think it’s going away anytime soon. Because so many people use social media, it’s probably the single largest and most effective communication device in the world.

I think you have to be on social media if you’re at all serious about any of the following: marketing, networking, sales, job hunting, problem solving, news and information (not the fake kind, but I digress), running a business, customer service, recruiting, and maybe a lot of other things I haven’t thought about — essentially, anything that involves communication on a large scale. Most business sites that sell products or services include links to “like us on (insert your favorite social medium here).” Many job applications include a form field for your LinkedIn profile, a sign that they take it seriously. Organizations such as PASS make extensive use of media such as Twitter to communicate with their members. I’ve also written before about online networking; I won’t rehash that here.

One of the big complaints I often hear is that people are sick of being bombarded with ads and politics. Facebook (and other media, I’m sure) does include tools to suppress things you don’t want to see; for example, there are tools to “hide” or “block all from (name of account).” There are a number of such tools available. I won’t get into them right now, but I will say that using them has made my online experience much more palatable.

So should you maintain a social media presence or not? These are the reasons why, despite their issues, I continue to do so. Social media are communication tools. How — and whether you decide — to use them is completely up to you.

The appeal of working for a virtual company

This morning, I had an online interview for a virtual company. For personal and privacy reasons, I won’t talk about the company or the interview (other than it went well), but one takeaway from it was that it seems very much like an organization where I’d like to work.

If I do land this job, it would not be my first experience working for a virtual company. I previously worked for a place that had no brick-and-mortar office location. I left that job after a few months for reasons that were unrelated to the virtual office structure.

I will say that during my time at that company, I saw — and still see — the appeal of working for a virtual company, something that is much more relevant now, especially during the COVID-19 pandemic.

For starters, there’s the commute. When I was working my previous job (and before the pandemic), I’d get in my car and drive fifteen minutes to get to my office. In a work-at-home situation, my commute is the distance from my bedroom downstairs to my home office — which generally takes all of thirty seconds. Additionally, that’s less wear and tear on my car, and less gas that I need to use. I can probably count on one hand the number of times I’ve had to put gas in my car during the pandemic.

The job for which I interviewed is a full-time position that requires me to put in forty hours a week — but they are a flexible forty hours. This position would give me the ability to adapt my schedule around my activities.

While I like the camaraderie that comes with working with people in a brick-and-mortar office, one of the great appeals for this position is that I would be working with a globally distributed and geopolitically-diverse team located in several different countries. As someone who enjoys watching shows on The Travel Channel and Food Network, the idea of working with such a diverse group of people is especially appealing. I enjoy experiencing different cultures, and the prospect of working with different people from around the world appeals to me. While I will likely not meet these people in-person, and while they are not a substitute for physical presence, current technologies such as Zoom and Microsoft Teams do make up for some of the lack of contact.

And although I never had the opportunity to physically shake hands with my coworkers from my previous virtual position, I did make a number of friends with a number of them. Several of them are still connected with me on LinkedIn and Facebook to this day.

Additionally, while I would be working for a new company, I would already go into it being familiar and comfortable with my surroundings. There is no concern about getting comfortable with a new desk, learning the layout of your office, knowing where the bathroom is located, or trying to figure out where to go for lunch.

To be sure, remote work is not perfect, and there are several things I do miss about working in an office — for example, the ability to go out to lunch with my coworkers or go out for a drink with them after work. However, despite the fact that this company has no brick-and-mortar location, I’m finding that there are many aspects of this potential employer that appeal to me. I’m genuinely excited about the prospect of working for this company.

During this period of the COVID-19 pandemic, the ability to work from home is essential. Some people argue that virtual companies are the wave of the future. Regardless of how you feel about the work-at-home environment, there is something to be said about working for a virtual company.

Upcoming speaking engagements (as of 9/10/2020) #SQLSaturday #PASSSummit

This morning, I got the official word that I will be speaking at SQL Saturday #1003, Memphis on October 3. Since it’s being held virtually, I don’t have to make travel plans to Tennessee. (That’s too bad, since I understand that Memphis is a cool city to visit, with its music history and barbecue!)

I am now confirmed to speak at two (virtual) events, so I figured that this was a good a time as any to update my speaking schedule.

I continue to apply to speaking events that I am able to attend (since many are held virtually right now, it makes it easier). As my speaking schedule is updated, I’ll keep you posted.

My #SQLSaturday presentation on networking is viewable online #SQLSatAlbany #SQLSat961

I recorded my SQL Saturday session from this past weekend. If anyone is interested in checking out my presentation titled: “Networking 101: Building Professional Relationships,” it is now viewable online!

If you have an hour to kill, click here to see my presentation!