-
IT Database Administrator
1 week ago
Karmanos Cancer Institute Oregon, United StatesMcLaren Health Care is a fully integrated health network committed to quality, evidence-based patient care with locations in Michigan and Indiana. The McLaren system includes 13 hospitals in Michigan, ambulatory surgery centers, imaging centers, a primary and specialty care physi ...
-
Titan Industries Janesville, United StatesAre you interested in an exciting job in IT? Junior / Senior Database / SAP Basis Administrator (m/f/d) ESWE Versorgungs AG is the energy service provider for the state capital of Hesse (electricity, gas, heat, renewable energies) with a continuously growing market share througho ...
-
Foreclosure Mediation Program
1 week ago
Illinois 17th Judicial Circuit Court Rockford, United StatesHOURS: 20 hours per week · Hours must fall within 8:30 am to 5:00 pm Monday through Friday · COMPENSATION: $15.00 / hr · Paid leave - up to 40 hrs / year · LOCATION: Winnebago County Courthouse, 400 West State Street, Rockford, IL 61101 · SUMMARY OF RESPONSIBILITIES: · The Reside ...
-
Client Coordinator Trainer
1 week ago
Examworks Group, Inc. Rockford, United StatesOverview: · ExamWorks is seeking a **Client Coordinator - Trainer.** · The Client Coordinator Trainer is responsible for servicing inquiries from clients, physicians, nurses or any representative acting on behalf of a client. This position performs a wide range of data processing ...
-
Client Coordinator
6 days ago
Examworks Group, Inc. Rockford, United StatesOverview: · The Client Coordinator is responsible for servicing inquiries from clients, physicians, nurses or any representative acting on behalf of a client. This position performs a wide range of data processing tasks, including data preparation, data entry, data tracking, docu ...
-
Customer Service Representative
1 week ago
Four Rivers Sanitation Authority Rockford, United StatesThis position serves the public by providing the highest level of customer service by successfully completing detailed clerical and administrative duties. · **General Statement of Duties** · Under general supervision, performs work of routine difficulty while providing profession ...
-
Administrative Medical Biller
12 hours ago
Beloit Comprehensive Treatment Center Beloit, United StatesOverview: · **Seeking**:Administrative Assistant - Medical Billing · **Full Time Hours**:Monday - Friday 5:00 AM-1:30 PM · **Our Benefits**: · - Quarterly Bonus Program · - Medical, Dental, and Vision insurance · - Competitive 401(k) plan · - Paid vacation and sick time · - STAR ...
-
School Secretary
1 week ago
School District of Beloit Beloit, United StatesJobID: 1571 · **Position Type**: · Secretarial/Clerical/Secretary**Date Posted**: · 3/28/2024**Location**: · Converse Elementary**Date Available**: · As soon as possible**Closing Date**: · Until is filled · Required Qualifications · 1. High school diploma or GED certificate. · 2. ...
-
Client Coordinator
1 week ago
TEKsystems Rockford, United States: · The Client Coordinator is responsible for working through CMS portals, processing the cases and entering into the database. They will be reviewing for eligibility. This position is responsible for data preparation, data entry, data tracking, documentation, and filing. All dut ...
-
GIS Specialist
1 day ago
FurstStaffing Rockford, United StatesJob Description · Job DescriptionThe GIS Specialist is responsible for, through the use of GIS and other appropriate software, the maintenance of the geographic information as well as other systems. This will also include updating geometry, attribute data and production of hard c ...
-
Mercy Health System Rockford, United StatesOverview · Under 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 st ...
-
Associate Endodontist
1 week ago
Specialty1 Partners Rockford, United StatesOur practice is currently looking for a Full-Time Endodontist to join our rapidly growing office. Camelot Endo is a very well-established, quality-oriented group practice limited to Endodontics, located in upscale communities in Rockford, Illinois. Our objective is to provide End ...
-
Client Coordinator
1 week ago
ExamWorks Rockford, United StatesOverview · Are you looking for a role where you can work from the comfort of your home? Are you an experienced Client Coordinator or Customer Service Professional seeking your next opportunity? · If you have the desire to be challenged, work in a fast-paced, fun environment and t ...
-
Senior Server Administrator
1 week ago
Woodward Rockford, United StatesJob Description Senior Server Administrator **Description** · If youre a Senior Server Administrator, we have an exciting opportunity for you · The Senior Server Administrator is responsible for the monitoring, installation, maintenance, support, and overall operational stabili ...
-
UW Health SwedishAmerican Rockford, United StatesPosition Summary: · Under the direction of the Construction Services Manager or Facilities Planning Manager at University of Wisconsin Hospital & Clinics, the Facilities Planning, Design, and Construction – Project Manager - Senior, is responsible for a range of project manageme ...
-
Tax Admin Internship
1 week ago
Wipfli Rockford, United States InternshipSHIPReferral Details: · We greatly appreciate your referral, and we look forward to reviewing the qualifications of the candidate you've recommended. Here's a brief overview of the process: · After you've completed this referral form, your recommended candidate will be directed to a ...
-
Data Management Specialist
4 days ago
PCI Pharma Services Rockford, United StatesLife changing therapies. Global impact. Bridge to thousands of biopharma companies and their patients. · We are PCI. · Our investment is in People who make an impact, drive progress and create a better tomorrow. Our strategy includes building teams across our global network to pi ...
-
Network Systems Administrator
1 week ago
Kaney Rockford, United StatesThe Network Systems Administrator will be responsible for the efficient operation and maintenance of our organization's network and computer systems. They will oversee the implementation, configuration, and maintenance of all network hardware, software, and related infrastructure ...
-
Network Systems Administrator
2 weeks ago
Kaney, Inc Rockford, United StatesJob Description · Job Description Description: The Network Systems Administrator will be responsible for the efficient operation and maintenance of our organization's network and computer systems. They will oversee the implementation, configuration, and maintenance of all networ ...
-
Tier II Tier III Academic Interventionist
1 week ago
Rockford Public Schools Rockford, United StatesROCKFORD PUBLIC SCHOOL DISTRICT #205 · Job Description · Job Title: MTSS Tier II and Tier III Academic Interventionist · Job Code: 2272 · Department: Multi-Tiered Systems of Support (MTSS) · Supervisor: Director of MTSS · Date: · FLSA Status: · PURPOSE OF THE POSITION: The MTSS A ...
Senior Database Administrator - Rockford, United States - Hinshaw & Culbertson LLP
Description
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.
