Database Developer
OVERVIEW
The Database Developer develops databases to ensure optimal functionality of the server environment and contributes to accurate, timely delivery of client project data.
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Identifies/develops database development frameworks and procedures
- Shapes definition of scenarios leading to specific project/feature improvements
- Develops demos/proof of concept at the application and/or data persistence layers
- Provides advanced troubleshooting in order to provide strategic direction and implementation of solutions
- Identifies weak/churning code deficiencies and works with team to improve vulnerable sections
- Creates and debugs custom queries and stored procedures which connect disparate data sources
- 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
- Processes AdHoc data import and data export requests
- Contributes to work-estimates, designs, policies, and documentation
- Budgets, plans, prioritizes and schedules milestones making appropriate compromises to ensure high quality yet timely delivery
- Maintains server integrity and offers ideas to optimize server performance
- Monitors database systems for performance, capacity, and integrity
- Designs metric reports, strategy, procedures for interpreting results/performance/security at an intermediate level that spans data persistence layers
- Designs and implements technical documentation and design that spans data persistence layer of solutions for all internal and client-facing projects
- Develops methods of aggregating customer data to make it more actionable
- Provide guidance on customer requirements interpretation and translate into technical documentation that spans data persistence layers of solutions particularly for stress, performance, globalization/localization and easy maintenance/extendibility
- Provides cross-skill pollination to other team members
- Investigates and stays up-to-date with application and data persistence layer technology as well as hardware components (computing devices, networking devices)
- Identifies and adopts new development methodologies, best practices, tools
- Monitors database systems for performance, capacity, and integrity
QUALIFICATIONS AND EXPERIENCE
- Bachelor’s Degree in Computer Science, Software Engineering, Computer Engineering, and/or related field and 2+ years of experience as a combination of database administration and development in a live production environment in information technology, finance, analytics, and/or statistics; or equivalent combination of education and experience.
- Ability to read, analyze and interpret business periodicals, professional journals, and technical procedures.
- Ability to write reports, business correspondence, and procedure manuals.
- Ability to effectively present technical subjects to non-technical audiences and respond to questions from managers, colleagues and customers.
- Ability to define problems, collect data, establish facts, and draw valid conclusions that demonstrate good judgment.
- Ability to proactively manage workload and priorities with minimal supervision.
-
A high level of proficiency is required in the following areas:
- Microsoft SQL Server 2005 & 2008 R2+ (views, indices, complex queries, and stored procedures)
- Database modeling and design
- Performance tuning & optimization
- Unit testing principles
- Data concurrency / race conditions
- Security
- Localization
- Database stored procedures
- Data warehousing
- .NET Framework 4.0 (C#, ASP.NET)
-
The following skills are preferred but not required:
- Azure SQL
- AWS
- LAMP stack
- Omniture, WebTrends, Google Analytics
- E-commerce packages
- Database design and development
- Powershell
- Analytics
- WCF
- UML or similar
- PHP, MySQL
PHYSICAL DEMANDS
The physical demands described 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 the essential functions.
While performing the duties of this job, the employee is regularly required to use hands and fingers and reach with hands and arms. The employee frequently is required to sit, talk, and hear. The employee is occasionally required to walk and climb stairs. The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 20 pounds. Specific vision abilities required by this job include close vision, peripheral vision, depth perception, and the ability to adjust focus.
WORK ENVIRONMENT
Work is typically performed in client office environments. The noise level in the work environment is usually moderate, however may vary.
The preceding position description is not intended to describe in detail the multitude of tasks that may be assigned, but rather to provide a general overview of the expectations and responsibilities of this position. As the nature of business demands change, so may the functions of this position. Additional duties and responsibilities may be assigned.

