SQL Server Database Developer/Administrator

You:

As DBA, you will be a key member of the production support team as well and participate in design and development of new systems.

 You will possess strong attention to detail, excellent relationship management skills, and the ability to effectively participate and lead design and implementation of software systems with developers. You must be business minded and posses the ability to weigh business decisions against technical ones.

 Ideally, you will have at least five years of enterprise level software development experience, including two years of experience in administering and developing on a very large multi-tenant database application. You will have comprehensive experience of using Microsoft SQL Server technologies (SSIS, CDC, partitioning, Entity Framework) for a .NET web application and a passion for new emerging technologies.

 Responsibilities

  • Own and proactively monitor database performance tuning analysis and optimization
  • Develop, implement, and monitor standards and procedures to ensure optimum performance, scalability, and reliability
  • Plan, design, and implement the database capacity and security practices for every phase of major .NET application development
  • Review all investigations, analysis, and resolution of database problems; compile and maintain documentation
  • Troubleshoot and Tune T-SQL Scripts
  • Work closely with Application Developers to ensure proper design and implementation of database systems
  • Develop ETL scripts to transport data in a real time fashion from OLTP schema to reporting schema, using SSIS
  • Assist in developing Data Migration Plans

Essential Skills

 5+ years demonstrated experience successfully managing complex SQL Server database systems in a hosted environment

  • Experience with large scale database design and development on the Microsoft SQL Server 2000/2005/2008 platforms including normalization techniques, performance tuning etc
  • Deep understanding of Microsoft development tools such as Visual Studio GDR Edition and database build and deploy processes
  • Demonstrated experience with SSIS
  • Understanding of the .NET dev stack and how it consumes the database
  • Experience with setting up SQL Server Replication and clustering
  • Must be able to work in an agile time-critical environment and be decisive when faced with complex problems
  • Excellent verbal and written communication skills required
  • Must possess strong organizational and time management skills with ability to manage multiple projects at the same time.

Desired Qualifications

 BS in Computer Science or Engineering, MIS or equivalent preferred; Masters Degree a plus

  • Experience with different partitioning schemes is very desirable.
  • Experience with SSRS, SSAS, Entity Framework, LINQ is a plus
  • Experience with campaign management or fundraising applications extremely helpful
  • Understanding and use of project management and development toolsets, including the MS Office suite, Team Foundation Server, Sharepoint, Visio, MS Project, Visual Studio Team System and other development tools as necessary.
Home