Allied Solutions Development DBA in Carmel, Indiana
Development DBA, Carmel, IN
Back to All Open Positions
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!
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.
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.