Senior Database Administrator

2 months ago

Rockford, United States Hinshaw & Culbertson LLP Full time

SENIOR DATABASE ADMINISTRATOR

Location: Flexible and in any state where the firm has an office.

Hinshaw & Culbertson LLP, a national law firm, currently has an excellent full-time employment opportunity for a Senior Database Administrator. We offer competitive compensation and an excellent benefits package.

POSITION SUMMARY:

Looking for a Senior Database Administrator to join our team to apply system analysis techniques and procedures, including consulting with users, to determine software and system specifications for, and coordinates the design, implementation, production support and troubleshooting for SQL servers and all databases in an integrated system in multiple locations. Both domestic and international, the Senior Database Administrator will implement systems technologies covering all users to ensure high-availability of the SQL server environments.

ESSENTIAL FUNCTIONS INCLUDE:• Develops database standards and specifications, applies database systems analysis techniques and procedures to design, develop, implement, maintain and support databases throughout the Firm.• Works closely with IT staff to evaluate and install new applications and integrate them into the SQL server. Creates reviews and edits SQL code. Coordinates team members to ensure collaborative efforts result in maximum efficiency. May be required to develop, design, maintain and support database based software applications. • Maintains SQL Server client and server software to current stable service pack levels. Creates test environment and tests service packs prior to their installation in the production environment.• Tests, corrects errors, and modifies changes to programs or to databases. Reviews project requests describing database user needs, estimating time and cost required to complete project. Selects and enters codes to monitor database performance and to create production database. Coordinates with programmers and analysts to make changes to database management system. Reviews workflow charts developed by programmer analyst to understand tasks computer will perform. Reviews procedures in database management system manuals for making changes to databases. Confers with coworkers to determine scope and limitations of projects. Revises definition of data as defined in data dictionary. Specifies user and user access levels for each segment of databases. • Documents operating procedures and database design specifications for applications to be developed.• Serves as a liaison with vendors on the implementation of new packaged systems or upgrades to existing systems.• Create data feeds between applications and for import/export to external entities or to the cloud. Tools can include: SQL Server Integration Services (SSIS), SQL Stored Procedures, Batch files, Winscp, Powershell, and various APIs. • Creates data warehouses and designs data integration processes. Writes logical and physical database descriptions, including location, space, access method, and security. Establishes and calculates optimum values for database parameters. Develops data model describing data elements and how they are used. Codes database descriptions and specific identifiers of database to management system, or directs others in coding descriptions.• Oversees server roles and database security procedures to control data access and server privileges.• Sets up and manages backups, log shipping and recovery. Monitor database backups using Ola Hallengren's scripts or Idera SQL Safe• Programs scripts for database monitoring and automating routine tasks.• Periodically reviews server disk capacity and usage to ensure proper database growth and determine the necessity for server expansion to ensure adequate database capacity Firm-wide.• Proactively maintains and expands knowledge of trends, developments and new technologies that impact database design and operations. Researches, evaluates and provides input on database products and researches, evaluates and recommends enhancements to current systems and methods of operating.• Responsible for designing, implementing and maintaining the highest level of security of all Firm records and files.• Supports off hours (evening, weekends and holiday) installations and upgrades as needed.• Participates in departmental project teams and task forces designed to streamline workflow and/or resolve issues; assists with various firm and/or departmental projects and initiatives as assigned.• Working with a requestor, creates reports using SQL Server Reporting Services (SSRS)• Assumes additional responsibilities as requested.

QUALIFICATIONS AND PRIOR EXPERIENCE:• Bachelor's Degree in computer science or equivalent technical knowledge. Microsoft Certified Database Administrator Certification preferred.• 7-10 years of database experience.• Comprehensive knowledge of database administration and system analysis including design, installation and troubleshooting of MS SQL server on Windows server platforms. Experience using SQL server monitoring tools.• Thorough command of the industry language and the ability to effectively communicate technical information to a variety of technical and non-technical users.• Strong analytical and problem solving skills, ability to organize and prioritize multiple assignments, use initiative and judgment to accomplish results, participate as a team leader or member of a team, work under pressure and complete job assignments in an accurate, timely and professional manner.• Excellent presentation, communication, interpersonal and customer service skills and ability to interact effectively and professionally with all learning styles, personality types and levels of management, staff and a variety of external entities including clients and prospective clients of the Firm.• Ability to travel to the Firm's other offices.

This job description is intended to describe the general nature and level of the work being performed by employees in this job. It is not intended to be a complete list of all responsibilities, duties, and skills required for this job classification.

As an EEO/AA employer, Hinshaw & Culbertson LLP will not discriminate in its employment practices due to an applicant's age, race, color, religion, sex, sexual orientation, gender, gender identity, gender expression, national origin, protected veteran or disability status or any other factor prohibited by law.

  • Systems Administrator

    2 weeks ago

    Rockford, United States Vogrinc & Short, Inc. Full time

    Excellent opportunity for a Systems Administrator looking to broaden IT exposure and develop expertise in a collaborative and service-oriented culture. This person will support the company’s network, computer systems, and telecommunications in all areas, from regular maintenance and support to participating in strategic infrastructure planning with...

  • Systems Administrator

    4 weeks ago

    Rockford, United States Vogrinc & Short, Inc. Full time

    Excellent opportunity for a Systems Administrator looking to broaden IT exposure and develop expertise in a collaborative and service-oriented culture. This person will support the company’s network, computer systems, and telecommunications in all areas, from regular maintenance and support to participating in strategic infrastructure planning with...

  • Senior Contract Administrator

    4 weeks ago

    Rockford, United States Zobility Full time

    Job Title: Contract Administrator IILocation: Rockford, IL 61108 (Remote)Duration: 12 Months+Job Description:This position is for an experienced contracts professional, working independently.Creates proposals, negotiates and completes contracts.Provides guidance on warranty and contract administration and monitors and analyses.Government FAR 12 and FAR 15...

  • Systems Administrator

    4 weeks ago

    Rockford, United States Vogrinc & Short Full time

    Job DescriptionJob DescriptionExcellent opportunity for a Systems Administrator looking to broaden IT exposure and develop expertise in a collaborative and service-oriented culture. This person will support the company’s network, computer systems, and telecommunications in all areas, from regular maintenance and support to participating in strategic...

  • Administrative Coordinator for Rental Services

    5 days ago

    Rockford, Illinois, United States Homes Now Full time

    Job OverviewHomes Now is seeking a dedicated Office Support Specialist to assist with various administrative tasks within our rental office. The ideal candidate will manage incoming communications, welcome clients, and maintain organized records while performing essential clerical duties.Key Responsibilities:Manage incoming calls and other forms of...

  • Administrative Coordinator

    9 hours ago

    Rockford, Illinois, United States FurstStaffing Full time

    Job OverviewPosition: Executive Assistant/Office ManagerKey Responsibilities:Executive SupportOversee and manage the workflow of the CEO, ensuring priorities are met and progress is tracked.Prepare and advise on minutes, agendas, and essential documents for board meetings and stakeholders.Handle confidential information with discretion and independent...

  • System Administrator

    1 month ago

    Rockford, United States FurstStaffing Full time

    Job DescriptionJob DescriptionPOSITION SUMMARY:The Systems Administrator analyzes, installs, and supports the clinics’ central computer systems and network including servers, operating systems, and software. This position will ensure the performance, integrity, and reliability of all systems components, with an emphasis on telecommunications. This position...

  • Administrative Support Specialist

    6 days ago

    Rockford, Illinois, United States Homes Now Full time

    Job OverviewHomes Now is seeking a dedicated Office Coordinator to manage various clerical responsibilities within our organization. The ideal candidate will be adept at handling incoming communications, welcoming clients, and overseeing documentation and office operations.Key Responsibilities:Manage incoming calls and correspondence efficiently.Organize and...

  • Administrative Support Specialist

    5 days ago

    Rockford, Illinois, United States Homes Now Full time

    Job OverviewHomes Now is seeking a dedicated Office Coordinator to manage various clerical responsibilities within our organization. This role involves handling incoming communications, welcoming clients, and overseeing document management. The ideal candidate will possess strong organizational skills and a friendly demeanor.Key Responsibilities:Manage...

  • Operations Senior Manager

    6 days ago

    Rockford, Illinois, United States Health Conservation Incorporated Full time

    Company Overview:Health Conservation Incorporated is a nationwide provider of occupational health services dedicated to supporting corporate health and safety initiatives across the United States. Our mission is to safeguard employee well-being while ensuring compliance with OSHA regulations. We specialize in delivering core services such as audiometric and...

  • Senior Logistics Manager

    1 month ago

    Rockford, United States Health Conservation Incorporated Full time

    Job DescriptionJob DescriptionHCI is a national provider of occupational health services to corporations across the United States. HCI provides an ongoing service to support the health and safety plan of our clients to protect their employees while complying with OSHA regulations. Our core services include audiometric and respiratory screening services via...

  • Senior Manager of Operations

    4 weeks ago

    Rockford, United States Health Conservation Incorporated Full time

    Job DescriptionJob DescriptionHCI is a national provider of occupational health services to corporations across the United States. HCI provides an ongoing service to support the health and safety plan of our clients to protect their employees while complying with OSHA regulations. Our core services include audiometric and respiratory screening services via...

  • Senior Commercial Banker

    3 months ago

    Rockford, United States Wintrust Financial Full time

    Wintrust is a financial holding company with approximately $50 billion assets under management and traded on the NASDAQ:WTFC. Built on the "HAVE IT ALL" model, Wintrust offers sophisticated technology and resources of a large bank while focusing on providing service-based community banking to each and every customer. Wintrust operates fifteen community bank...

  • Senior Manager of Operations

    1 month ago

    Rockford, United States Health Conservation Incorporated Full time

    Job DescriptionJob DescriptionHCI is a national provider of occupational health services to corporations across the United States. HCI provides an ongoing service to support the health and safety plan of our clients to protect their employees while complying with OSHA regulations. Our core services include audiometric and respiratory screening services via...

  • Director of Clinical Integration, Supplies and Services

    1 month ago

    Rockford, Illinois, United States tapwage Full time

    OverviewUnder the direct supervision of the Vice President, Supply Chain this role is accountable for the development and management of efficient and cost-effective integrated systems of Sourcing/Contracting, Clinical Integration (CI) and Recall Management to align with the strategic vision of Supply Chain leadership. This includes management, recruitment,...

  • SENIOR SOFTWARE ENGINEER, FULL STACK

    4 weeks ago

    Rockford, United States Capital One Full time

    77 West Wacker Dr (35012), United States of America, Chicago, IllinoisSenior Software Engineer, Full StackDo you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery environment? At Capital One, you'll be part of a big group of makers, breakers,...

  • Medical Records Coordinator

    2 days ago

    Rockford, Illinois, United States Rosecrance Inc. Full time

    Job SummaryRosecrance Inc. is seeking a highly organized and detail-oriented Medical Records Clerk to join our team. As a Medical Records Clerk, you will play a critical role in maintaining the accuracy and integrity of patient records.Key ResponsibilitiesRecord Management: Accurately scan and maintain electronic health records, ensuring timely and accurate...

  • Donor Systems Coordinator

    2 weeks ago

    Rockford, United States Rockford Rescue Mission Full time

    Are you passionate about data? Do you enjoy working with non-profit donors? Have you longed to give meaning to your career? Look no further!! The Rockford Rescue Mission is looking for someone to join our family as a Donor Systems Coordinator. The Rockford Rescue Mission shares hope and help in Jesus' name to move people from homelessness and despair toward...

  • SENIOR BACK END SOFTWARE ENGINEER, CARD TECH

    4 weeks ago

    Rockford, United States Capital One Full time

    77 West Wacker Dr (35012), United States of America, Chicago, IllinoisSenior Back End Software Engineer, Card TechDo you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative delivery environment? At Capital One, you'll be part of a big group of makers,...

  • PT Benefits Access Coordinator

    1 month ago

    Rockford, United States Northern Illinois Food Full time

    Job DescriptionJob DescriptionJob Title Description: Benefits Access CoordinatorClassification: Non-exemptReports To: Senior Manager of Public Policy and BenefitsPOSITION SUMMARY The Benefits Access Coordinator’s primary responsibility is to provide SNAP (Supplemental Nutrition Assistance Program) Medicaid, Medicare Savings Program, TANF and resource...