Junior Database Developer

Asurint•Cleveland, OH

1d•Remote

About The Position

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, and 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.
Proficiency in MS Office (Outlook, Excel, Word) or similar software is required.
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.

Nice To Haves

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.
Relevant business management systems such as general ledger, HRIS, CRM, etc. is preferred.
Bachelor’s degree in computer science, information technology, or a related field is preferred.

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.