FREE ACCESS
5,000–10,000 jobs/day

See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Tech Stack
Tools & technologiesASP.NETETLSQLSSIS
About the role
Key responsibilities & impact- The Junior Database Developer is responsible for assisting with the technical design, development, and ongoing improvement of Asurint’s databases and systems.
- Reviewing/troubleshooting daily data load jobs.
- Reviewing query performance, data loading and data extraction, deadlock resolution, and stored procedure development.
- Assisting with level 1 database administration and monitoring.
- 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.
- 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.
Requirements
What you’ll need- 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.
Benefits
Comp & perks- 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
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
SQLdatabase designstored proceduresperformance tuningETLSSISSSRSXMLMicrosoft SQL Server 2012object-oriented development
Soft Skills
collaborationproblem-solvingcommunicationdocumentationtroubleshootingcoordinationsupportteamworkadaptabilityattention to detail
