Sr. Database Development Engineer
The Senior Database Development Engineer develops and supports databases to ensure optimal functionality of the server environment and contributes to accurate, timely delivery of client project data.
The ideal candidate will enjoy working in a dynamic fast-paced environment, is a creative problem-solver, an excellent communicator, and autonomous worker. Successful candidates are able to effectively communicate technical subjects to non-technical audiences and can proactively manage priorities, providing on-call support when needed.
Essential Duties include:
- Provides expert-level work using SQL Server and T-SQL
- Normalizes and cleanses messy data in order to facilitate statistical analysis and data mining
- Uses flat file inputs to populate SQL tables
- Builds and/or leverages SQL Server Integration Services (SSIS), SQL Server Management Studio (SSMS), and SQL Analysis Services
- Provides expert-level work writing stored and reusable procedures flexible enough to take in a variety of data in various configurations and turns it into data for product and person analyses
- Designs metric reports, strategies, and procedures
- Instructs and/or implements data automation from scratch
- Investigates database development errors and escalates to appropriate technical resources
- Identifies weak/churning code and works with team to improve vulnerable sections
- Demonstrates in-depth understanding of design/code of a feature/project
- Identifies/develops database development frameworks and procedures
- Maintains server integrity and optimizes server performance
- Automates and optimizes data transfer, online reports, and presentations for internal and external clients using SSIS and stored procedures for both staging and production systems
- Monitors database systems for performance, capacity, and integrity
- Creates and debugs custom queries and stored procedures which connect disparate data sources
- Investigates and stays up-to-date with application and data persistence layer technology as well as hardware components (computing devices, networking devices)
Requirements include:
- Bachelor's Degree in Computer Science, Software Engineering, Computer Engineering, and/or related field
- 4+ years of experience as a database developer in a live production environment in information technology, finance, analytics, and/or statistics
- 3+ years Microsoft SQL Server 2005 & 2008 R2+ (views, indices, complex compound queries, and stored procedures)
- 2+ years SSIS Package Development and performance tuning and optimization
Required Skills:
- Data concurrency/race conditions
- Security
- Localization
- Database stored procedures, Data warehousing
- Database modeling, design, and development
- .NET Framework 3.5 (C#, ASP.NET)
- Powershell
- RedGate
Preferred Skills:
- 2+ years of experience performing statistical and or data mining analyses
- Analysis Studio
- SQL Server Business Intelligence Studio (SSBID)
- LAMP stack
- Omniture, WebTrends, Google Analytics
- Content Management Systems (ExactTarget, Kentico, Wordpress, DotNetNuke, Drupal)
- Analytics
- UML or similar
- MySQL, MSMQ/SQL Broker Queues
- Unit testing principles
