[Hiring] Junior Database Developer @One Source Technology LLC

Role Description

The Junior Database Developer is responsible for assisting with the technical design, development, and ongoing improvement of Asurint’s databases and systems by:

• Reviewing/troubleshooting daily data load jobs
• Reviewing query performance
• Data loading and data extraction
• Deadlock resolution
• Stored procedure development
• Assisting with level 1 database administration and monitoring

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.
• This position is performed remotely within the United States or in an office setting in the Cleveland, Ohio headquarters.
• 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.
• The schedule is generally normal Eastern Time Zone business hours, although the employee may be required to perform work outside of these hours.
• Some travel by personal automobile and a valid driver’s license may be required.
• Ability to lift light objects (less than 20 pounds) and carry them short distances (20 feet or less) is required.

Benefits

• 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