Senior
SQL Server Database Developer/Admin
Work with developers and product owners to define
requirements, perform analysis and design, and implement robust, maintainable
solutions that meet the business requirements. Create and maintain conceptual,
logical, and physical database models. Provide routine database administration
support including backups, recovery, security, and replication for the
development and quality assurance environments.
Create technical specifications and support documentation. Create SSIS packages to load and process
data. Develop and enhance stored
procedures. Design and create reports using Reporting Services and Analysis
Services. Design and develop maintenance
for cubes using Analysis Services.
Assist in establishing, maintaining, and communicating standards,
guidelines and data architecture best practices. Mentor and work closely with
development and implementation teams; and for each phase of a project, work
with the project management to identify and mitigate data architecture risks.
Lead and participate in reviews and quality assurance processes to ensure that
the data architectures and standards are being adhered to.
Developer will be required to work some
evenings and weekends when software is released.
Qualifications
Required: Bachelors
degree in computer science, or other related field
6+ years database development and
administration using Microsoft SQL Server is required.
In depth T-SQL knowledge is required,
including advanced tuning skills.
Experience with data modeling and use of data
modeling tools, such as ERWin or PowerDesigner, is required.
Experience with transactional replication is
required. Knowledge of XML technologies
is required.
Experience with Microsoft Integration Services
including writing robust data ingests, is required.
Some Experience or a desire to learn Microsoft
SQL Server Reporting Services and Microsoft SQL Server Analysis Services is
required.
Desired:
Experience with Microsoft SQL Server Analysis
Services including designing and maintaining cubes is a plus
Experience with Microsoft SQL Server Reporting
Services is a plus
Knowledge of Visual C# is a plus.
Knowledge of KDB+ is a plus.
Knowledge of FAST search solutions is a plus