Junior Database Developer

Job description

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, 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 p...