Job Description :
Position Responsibilities & Essential Functions:
· Lead the technical design, development, testing and
implementation of SQL Server based applications utilizing CPU standard
development procedures and techniques that support the requirements
defined by users and analysts. Ensure that standards for database
performance, availability and security are being met. Perform
proactive performance consultation, design, tuning, and planning with
Database Architect and Production DBA. Responsible for suggesting,
reviewing and justifying new technical tools and techniques and
managing their implementation.
· Translate and document customer requirements, recommend system
solutions, and formulate detailed specifications from which enterprise
applications are developed. Work closely with business partners to
produce quality products that meet business needs. Implement solutions
following the complete Software Development Lifecycle (SDLC),
including requirements gathering, design, specifications, development,
change management, testing and deployment activities.
· Analyze database applications/queries and implement
improvements to optimize performance.
· Provide tiered production support including limited on-call.
· Track and report development progress and performance on a regular basis.
Skills:
· Strong understanding of how to maximize SQL Server application
scalability, performance, recoverability, and maintainability.
· Demonstrated ability to balance multiple concurrent projects of
varying priorities and shift focus from one project to another with
minimal loss of productivity or quality.
· Demonstrated experience supporting data warehouses.
· Demonstrated experience with adhering to usability, design and
development standards.
· Demonstrated experience with all aspects of unit testing,
performance testing and user acceptance testing. In-depth experience
with the development lifecycle and software development methodologies.
· Understanding of various schemas and their pros/cons: star
schema, snowflake schema, 3rd normal form, etc.
· A strong understanding of technical and infrastructure
environments (data communications, web technologies, network, SAN,
security, etc.
· Demonstrated experience with large scale database design and
development on the Microsoft SQL Server platforms including
normalization techniques, writing stored procedures, performance
tuning etc.
· Solid understanding of SQL Server locking, indexing and error
handling, and basic administration tasks.
· Ability to meet deadlines in a fast-paced environment that is
also evolving.
· Ability to work in a collaborative, dynamic team environment and
interact at all levels to ensure reliability, availability,
scalability, and performance of applications.
· Excellent organizational, time-management, and project
planning/strategizing skills.
· Experience with source control, preferably GIT or SVN.
· Strong verbal and written communication skills.
· Strong analytical and problem resolution skills.
· Experience with healthcare systems is preferred.
Experience and Education:
· Minimum of 3 years of experience developing SQL Server
applications and optimization including DDL, DML, stored procedures,
triggers, SSIS, SSRS, and performance tuning.
· Minimum of 3 years of experience with SQL Server version 2008R2
and earlier versions.
· Minimum of 3 years of relational database experience within a
multi-tiered environment; including use of database performance and
monitoring tools.
· Minimum of 3 years of professional, technical experience as a
SQL Server DBA and with database development and optimization.
· C# experience a plus.
· B.S. or B.A. in Computer Science or equivalent work experience.
Communication:
· Ability to read and comprehend simple instructions, short
correspondence, and memos
· Write simple correspondence
· Effectively present information in one-on-one/small group
situations to customers, clients, and other employees of the
organization.
Other:
Client would prefer candidates with more experience on the development
side with DBA skills. Developer skills first and an SQL tuner
optimizer second.