SQL Database Developer

Strategic Staffing Solutions (S3) currently has multiple openings for permanent opportunities as well as contract to hire opportunities for SQL Database Developers.  These openings are located in Chicago. 

Position Description

As a Senior MS SQL Server Database Developer, you will be a critical member of a large team of 12-20 developers that provides high quality technology solutions that address Commercial Credit Card business needs. 
 
This is a highly demanding position that is visible throughout the organization which requires an individual to quickly evaluate information, engage within other team members and successfully drive development efforts thru to completion.
 
As a Senior Database Developer, you will be responsible for enhancing existing database designs at both a logical and physical level, developing or optimizing Stored Procedures, Views, Functions, Triggers, DTS and SSIS Packages as well as writing Technical Specifications.
 
The development team itself is matrixed and includes team members from Project Management, Business Analysts, and Quality Assurance.
 
The ideal candidate will need to have excellent communications skills, have experience working within a large development effort, will have significant experience utilizing and contributing to written technical specifications as well as programming/developing deliverables.
 
The ideal candidate will have experience with source control software, preferably ClearCase and will have worked in an environment that managed / merged at least two (2) concurrent versions of code.
 
While not a traditional DBA Operations role, the ideal candidate will have a high degree of involvement in recommending optimal database server configuration, performance monitoring, database replication monitoring, database clustering, and backup and disaster recovery.
 
The custom-built database applications are terabyte+, with over 300 tables and over 900 Stored Procedures, Views and Functions that aggressively mix batch type processing with the demands of on-line transaction processing. 
 
Therefore, the Senior Database Developer will have a significant expertise and discipline in the architecture, design and development of online transaction processing (OLTP) systems, high volume Extract Transform and Load (ETL) processes, Data warehouse (DW) disciplines, Database Replication, and high volume Reporting.
 
The individual may also be required to manage Level 3 production support issues and ensure the following:  triage database and application data incidents; peer review and/or remediate application defects, develop and/or peer review data cleanup/fix scripts, while complying with established IT architectural, Risk, and operational standard procedures.
 
The overall technology environment is 24 x 7, primarily a Microsoft based, multi-tiered web-based environment using .Net v2.0, C#, IIS, and SQL Server, with Windows Based operating systems.
 
The database environment includes multiple, Replicated Microsoft SQL Servers instances running in a clustered environment, supporting a wide variety of complex business functions.
 
The company has redesigned its commercial card platform, PaymentNet, around Web services utilizing Microsoft's .Net development environment.  The new releases of PaymentNet are geared to enabling business customers to manage commercial card programs more efficiently. 
 
The Commercial Card IT department is committed to developing cutting edge technology with high quality and innovation.
 
Qualifications
 
Bachelor’s degree (or equivalent work experience or specialized training) in Information Technology (IT), Computer Science (CS), or related discipline
Minimum 5 + years of work experience as a Microsoft SQL Server Database Administrator
Solid skills in database performance factors, monitoring tools and tuning procedures
Experience with maintenance of large database of Terabytes of size
Solid skills in productivity factors and ability to understand impact of problem on overall database performance
Knowledge of fault detection and resolution processes
Strong skills in maintenance tools and procedure
Project management experience in a team lead capacity
Experience developing database solutions using Microsoft SQL Server 2000 and SQL Server 2005
SQL programming experience including T-SQL DTS, and SSIS
Experience designing and programming complex stored procedures, views, data aggregation/manipulation through table joins/queries
Experience designing and implementing large-scale database solutions that are reliable, scalable, and perform at a high level.
Database and index tuning experience
Experience with SQL clustering, SQL replication, hardware replication, and/or disaster recovery implementations a plus
Experience using version control system, e.g. ClearCase
Experience using a structured software development methodology
Experience in driving process change
Excellent written and oral communication skills
Excellent analytical and problem-solving skills
Strong interpersonal skills
Excellent coordination skills to manage resources vs. deliverables
Ability to work independently as a self-starter and within a team environment, with dedication to follow thru until objectives are met
Banking and/or financial experience a plus


Qualified candidates must be authorized to work in the United States.