About
Responsibilities
Works with the DBA team to help coordinate and assist development teams in creating database procedures, functions, and triggers.
Executes database-related activities for changes to all database objects, primarily in OLTP designs.
Conducts performance tuning using SQL query, stored procedures, and database engine under the guidance of senior-level staff.
Assists with managing the Criminal Records database, including support and creation of SQL Agent jobs, complex query construction, and other support as deemed appropriate.
Assists with identifying production performance issues, blocking and deadlocks, and long-running queries.
Assists with the administration, high availability, redundancy, security, and performance monitoring of all relational databases in production and non-production environments.
Performs daily system health checks including reviewing job failures and basic troubleshooting. Coordinates with other teams to address issues and escalates them to senior-level staff when appropriate.
Assists with creating database, process, and technical documentation.
Participates in release process meetings.
Collaborates with team members and business partners in defining, designing, developing, and implementing technology solutions to improve business functions.
Provides support before, during, and after normal business hours as well as nights, weekends, and holidays as needed.
Other duties as required.
Requirements
Minimum 1 year of experience designing solutions with Microsoft and SQL Server 2012 or higher is required.
Experience using a variety of methods to identify and resolve database performance issues or errors is preferred.
Experience with Source Control repositories is preferred.
Experience with extract/transform/load (ETL) tools such as SSIS and reporting with tools such as SSRS preferred.
Experience utilizing XML structures within data stores preferred.
Experience with Microsoft technologies (ASP.Net, C#, etc.) and object-oriented development concepts preferred.
Experience with the legal/court system is preferred.
Experience with background screening is preferred.
Proficiency in MS Office (Outlook, Excel, Word) or similar software is required. Relevant business management systems such as general ledger, HRIS, CRM, etc. is preferred.
Education: Bachelor’s degree in computer science, information technology, or a related field is preferred.
Certifications or licensure: If you do any work‑related driving while at Asurint, a driver’s license and ability to maintain a driving record that is satisfactory to the company’s liability insurance carrier is required.
Years of relevant experience: 1 to 2 years is preferred.
Years of experience supervising: None.
Working Conditions
The work environment involves everyday risks or discomforts that require normal safety precautions typical of offices, including the need for general safe workplace practices with office equipment and computers, avoidance of trips and falls, and observance of fire regulations.
This position is performed remotely within the United States or in an office setting in the Cleveland, Ohio headquarters, although off‑site meetings in various settings may occur.
Inside Asurint’s office environment, the noise level is usually quiet to moderate.
In a remote setting, the employee is responsible for maintaining a safe and secure work environment, for arranging the off‑site workspace in an ergonomically sound manner, and for maintaining standard Internet speeds in order to work effectively.
In a remote setting, the employee is required to ensure that all equipment and records that are the property of Asurint but have been relocated to the off‑site workplace, are maintained in a safe and secure manner and are used only for business purposes.
The schedule is generally normal Eastern Time Zone business hours (unless otherwise communicated based on position or working location), although the employee may be required to perform work, attend meetings and events before or after normal working hours, and occasionally on weekends and evenings.
Some travel by personal automobile and a valid driver’s license may be required. Occasional overnight travel may be required.
Ability to lift light objects (less than 20 pounds) and carry them short distances (20 feet or less) is required.
The work environment involves everyday risks or discomforts that require normal safety precautions typical of offices, including the need for general safe workplace practices with office equipment and computers, avoidance of trips and falls, and observance of fire regulations.
Benefits In exchange for your unique abilities, perspectives and teamwork, Asurint offers a competitive salary and an excellent benefit package — with options you can select according to your needs — which includes:
Medical, dental and vision effective first day of employment
401(k) with employer match
Paid time off
10 company-paid holidays
Employee Assistance Program
Wellness Program
Paid Bereavement
Pet Bereavement
Pet Insurance
Volunteer time off
Telecommuting Stipend
Professional development programs
Short‑term disability
Company‑paid long‑term disability
Company‑paid life insurance
Flexible spending/health savings accounts
Employee referral bonus
Asurint is an equal opportunity employer. All applicants will be considered for employment without regard to race, color, religion, age, sex, national origin, disability status, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Please note, the pay range represents a good faith estimate for the role at the time of posting. Final compensation will be within this range and determined based on factors such as experience, skills, qualifications and any unique requirements, or specialized skill sets relevant to the role. We are committed to maintaining equitable pay across employees in similar roles to ensure fair and consistent compensation practices.
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.