Database Administrator For The Personnel Department At A Law Firm
Job Title: HRIS Administrator
Type of Company: I work for a large law firm.
Education: BA, Psychology, Stonehill College (Easton, MA) certificate, Human Resources Management, Bentley College
Previous Experience: I worked at a ski resort in Colorado as a Human Resources assistant, and later worked at a VNA in Boston as a recruiter.
Job Tasks: I work in the human resources department of a large law firm as a database administrator. I am responsible for the accuracy of the data and creating file feeds to various vendors and internal systems. I create customizations in the database based on various reporting/tracking needs, which involves knowledge of Microsoft SQL and .asp web pages. I am the project manager for any upgrades performed to the database. I work closely with the national director of benefits and HR systems and need to have a strong and detailed knowledge of the benefit plans that are offered by the firm. I also assist with the administration of the retirement plans for the partners and owners of the firm. This includes preparing calculations in the database, communicating with the partners regarding their retirement plan obligations and how and when the deductions for their payments will occur. I need to provide files to payroll detailing the deductions that should occur and to audit to make sure that the deductions were taken correctly. I also serve on the client advisory board for the software company that makes the database software the firm uses. They provide me with a beta version of new applications they're building and I provide feedback, telling them what I like, don't like, and would like to see added.
Best and Worst Parts of the Job: My favorite parts of the job are the daily auditing that I do to ensure that the data in the database is accurate. Any errors or omissions are sent to the user responsible for correction. I also love how I am improving my technical skills.
The most frustrating part of the job is having so many large projects that need to be completed, but the day-to-day fire drills that come up always seem to get in the way.
Job Tips: You need to be extremely detailed-oriented in order to do this job. It helps to start off as an HR assistant, where you can get a sense for how an HR department works. Any type of technical training is a plus: a degree or certification in technology is a plus. Most people who work in HR have a psychology or sociology degree.