Allied Solutions Development DBA in Carmel, Indiana

Development DBA, Carmel, IN

Apply

Back to All Open Positions

Company Description

Allied Solutions is one of the largest providers of insurance, lending, and marketing products to financial institutions in the country. It is our goal to work with our clients every step of the way, utilizing technology-based solutions that are customized to fit their needs. With more than 4,000 clients nationwide and offices in more than 14 states, we have grown progressively and we've recently exceeded 1,000 employees. If you're a person who thrives in a fast-paced, team-based, diverse environment and you enjoy helping others through personalized service, Allied Solutions could be the perfect fit!

Job Description

The successful candidate will be an experienced Developer with extensive enterprise background using MS SQL Server. The Development DBA will be required to identify business requirements, develop data models, perform data analysis, write advanced SQL queries, design and code complex stored procedures, and performance tune existing database processes.. As a motivated self-starter, you can identify opportunities for improvement and new ways of leveraging data for the benefit of the business. You will also define and enforce the standards for database development.JOB DUTIES AND RESPONSIBILITIES

  • Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages

  • Performance tuning the stored procedures and T-SQL.

  • Assist developers with complex query tuning and schema refinement.

  • Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

  • Address negative performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes

  • Tuning T-SQL queries to improve performance

  • Prepare documentations and specifications

  • Collaborate with other team members and stakeholders

QUALIFICATIONS (EDUCATION, EXPERIENCE AND CERTIFICATIONS)

  • Bachelor’s Degree in Computer Science or related field (or equivalent work experience) is required.

  • 3-5 years developing business applications and database solutions

  • Experience communicating with fast-paced, highly cross-functional teams with multiple stakeholders

  • Familiar delivering experience in agile and DevOps environment

Knowledge & Experience

  • Proficient with Microsoft SQLServer, T-SQL, Stored Procedures, Functions, Triggers, SQL Server Management Studio, and Power Shell

  • Experience with developing SSIS packages

  • Proven analytical problem solving and debugging skills

  • Experience with Microsoft Azure cloud databases and services is a plus

  • Work in a fast-paced continual learning environment. Requires independent education with the ability to quickly adapt and learn new technologies to solve business issues

  • Ability to translate business objectives into programming initiatives and requirements.

    Personal Attributes

  • Strong creative and organizational skills

  • Strong project-management skills

  • Strong leadership and interpersonal skills

  • Curious and inventive personality

  • Proven analytical and problem-solving abilities.

  • Ability to effectively prioritize and execute tasks in a high-pressure environment.

  • Strong communication skills and ability to adapt communication to a specific audience

  • Highly self-motivated and directed.

  • Team-oriented and skilled in working within a collaborative environment.

Benefits of Joining our Team

We offer our employees a robust compensation package! Our comprehensive benefits include: medical, dental and vision insurance coverage; 100% company-paid life and disability coverage, 401k options with company match, three weeks PTO by the end of the first year and much more. Allied proudly promotes from within as part of a strong commitment to providing career growth opportunities for employees of all levels. Our diverse business portfolio allows employees broad career options with the advantage of staying with the same organization.