Senior SQL-C# .NET Developer
January 18, 2012
FMIC Job Description for Senior SQL/C# .NET Developer
Frederick Mutual Insurance Company (FMIC) is
a regional property and casualty mutual insurance company licensed to serve the
states of Maryland and Pennsylvania. The company has over $48 million in assets,
writes approximately $23 Million in direct written premium, has 222 independent
agencies and is rated A- (Excellent) by A.M. Best. FMIC has product offerings in
Personal Lines and Commercial Lines including Homeowners, Dwelling Fire,
Personal Umbrella, Artisan Contractors, Businessowners, Commercial Automobile,
Commercial Umbrella and Inland Marine.
This position reports directly to the Software Engineering Manager. The duties and
responsibilities for this position include, but are not limited to the following:
DUTIES and RESPONSIBILITIES:
The individual should have a minimum of six years’ experience in software design,
development, maintenance and/or application systems integration in a Wintel (MS
Windows and Intel architecture) hardware/software environment. Incumbent must be
well versed in current generation client-server technology (under the Windows OS), and
equally familiar with current web-focused technologies for integration with back-office
business systems running under MS SQL Server architecture. Strong SQL/relational
database skills are a must. The individual must possess superior analytical and problem
solving skills. Experience in the P&C Insurance industry a strong plus. The
responsibilities and tasks for this position include, but are not limited to the following:
- Develop program/system specifications.
- Function with business staff to define systems needs/functionality using
demonstrated collaboration and negotiating skills.
- Analyze, resolve, and/or define root cause of problems without supervision.
- Perform a structured analysis (data and process) without supervision.
- Develop data modifications scripts to fix data based on troubleshooting analysis.
- Develop database design specifications, prototypes, standards and procedures
(analysis and design).
- Heavy experience developing stored procedures, data filtering, data importing,
reporting extracts, data in from multiple sources and push to other internal
systems, complex stored procedures, functions, indexing, etc. using normalized
databases.
- Utilize analytical and problem solving skills in project management operations.
- Provides high-level expertise and guidance in technical matters relating to
software development, reporting, data manipulation and SQL Server operations.
- Assists with the development and implementation of performance management
metrics, reporting or data extraction to feed 3rd party data needs.
- Assures that business processes are performed in the most efficient manner and
that human and other company resources are allocated and utilized effectively.
- Have the ability to work with legacy code.
- Provides leadership to various projects as assigned by the Software Engineering
Manager.
- Provide direct technical leadership and development of the web applications
maintained by FMIC.
- Interfaces with technology counter parts at vendors, business partners and client
operations as needed.
- Assist in the management of SQL Servers and the associated databases to ensure
optimum operations and security is always maintained.
- Assist in the development and maintenance of data reporting as needed.
- Assist in the development and maintenance of data extraction as needed.
- Assist in month, quarter and year end processing as needed.
- Be on-call for systems support if needed.
QUALIFICATIONS
The Senior SQL/C# .NET Developer is a creative, self-initiator who can work both
independently and as the member of a team, while maintaining a positive, client focus
and strong interpersonal skills. The individual must be able to perform each essential
duty satisfactorily and manage multiple initiatives simultaneously. Most importantly, the
individual must conduct himself / herself with the highest degree of integrity and ethical
business standards.
EDUCATION and/or EXPERIENCE
Bachelor’s degree in Computer Science, Information Science/Technology or Business
Administration/Management with an explicit IT Concentration. Six years developing in
Microsoft technology. Three plus years’ experience developing solutions using SQL Server
(SQL 2005 or greater versions). Experience in the insurance industry is a strong plus.
TECHNOLOGY SKILLS
Strong working knowledge of the Microsoft Windows server operating systems and
platforms, and their relationship to database management components and end-user operating
systems. Understanding of the Layered software products available to this OS that provide
networking, messaging and database functionality. Familiarity with OS auditing functions is
helpful. User-level knowledge of mainstream business applications a plus. Experience
supporting web applications that run on iOS an Android device a plus. Experience with TFS
and MVC Framework. Fluent in T-SQL. Experience with web services and client-side
JavaScript.
LANGUAGE SKILLS
Strong command of the English language. Ability to effectively communicate complex
information to persons outside the profession, and respond collegially to questions from
external and internal customers both in person, in writing and on the telephone.
REASONING ABILITY and PROBLEM SOLVING
Ability to decompose complex problems into discrete, manageable solution sets. Ability to
solve problems that deal with a number of variables in situations where only limited
precedence exists. Ability to interpret instructions furnished in written, oral, diagram, or
schedule form. Ability to work independently in developing and executing project plans, yet
recognize when the plan impacts another organizational element and requires coordination.
MATHEMATICAL SKILLS
Ability to work with and apply basic mathematical and statistical concepts.
JOB LOCATION
The company location is in Frederick, MD, but this job may be performed remotely from
any location within the continental United States.
PHYSICAL DEMANDS
The physical demands here are representative of those that must be met by an employee
to successfully perform the essential functions of this job. Reasonable accommodations
may be made to enable individuals with disabilities to perform essential functions. While
performing the duties of this job, the employee is frequently required to sit; walk from
one end of the building to the other; stand; use hands to handle or feel; reach with hands
and arms; climb stairs, talk and hear.
Please email your resume to postmaster@fredmut.com.