Job Title: Sr. SQL Server Database Developer
Job Location: IL - Chicago
The lead database primary job function is to analyze, design, develop, test, tune, and maintain new
database software applications in support of the achievement of business requirements. The lead database
engineer is expected to take a lead role in designing and developing large database subsystems and
coordinate, assign and review the work of other software engineers. As he/she will be called upon to write
detailed technical specifications, the senior engineer must possess excellent written communication skills.
The lead database engineer will be able to weigh business decisions against technical best practices, and
will determine the solution that provides the best combination of functionality, performance, and ease of
maintenance. The lead database engineer will be able to directly engage in design discussions, and
demonstrate the ability to see the application from the user's point of view, at the subsystem level or
higher. Thus, the post holder must possess excellent verbal communication skills and ability to interact with
The lead database engineer's ability to self-direct, set goals, manage other engineers and meet aggressive
deadlines is a key factor in the overall success of the product development organization
Collaborate with developers, project managers and business analysts in conceptualizing, designing and
developing new database applications, modules and enhancements.
Assist in the definition, development, and documentation of software’s business requirements, objectives,
deliverables, and specifications on a project-by-project basis in collaboration with internal users and
Assist in defining software development project plans, including scoping, scheduling, providing time
estimates for programming tasks and implementation plans and schedules.
Conduct research on emerging database and application development software products, languages, and
standards in support of procurement and development efforts. E.g. SQL Server 2017
Prepare and distribute work assignments, provide guidance, and/or review the work of local and offshore
development team members.
Develop technical documentation to define the system components, development environment and
Maintain a current awareness of technological developments and trends as it relates to databases,
development methodologies and tools.
Responsible for developing estimates on related project work.
Responsible for staying current with new technology developments and development techniques.
Ability to work with developers, project managers, business analysts, account managers, architects and/or
technical leads to achieve business and functional requirements. Ability to work with front end design team
and/or tech lead to achieve functional requirements.
Cooperate with the Quality Assurance team to define test cases, metrics, and resolve questions about test
results; assist Quality Assurance team in keeping the quality assurance environment in proper condition.
Implement solutions that are reliable, scalable, and perform at a high-level to meet the service levels
associated with mission-critical database solutions.
Work with business users to analyze and recommend business process flow improvements.
Prepare design documents and technical specs explaining and motivating the approaches to be taken in the
deployment of systems.
Deliver high-quality solutions to business owners to ensure alignment of technical solution with business
Lead a small team of developers through the development process.
Document and share knowledge with larger development team.
Work in a team environment.
Clearly communicate problem/resolution process to project management.
The above outlines the principal work and responsibilities in the job and does not specify each and every
task that might be performed.
JOB RESPONSIBILITIES ARE SUBJECT TO CHANGE AS DIRECTED BY MANAGEMENT
The candidate must have the ability to design and implement solutions that are reliable, scalable, and
perform at a high-level to meet the service levels associated with mission-critical SQL Server 2012
Strong knowledge of Transact SQL and advanced SQL querying techniques including Windowing Functions.
Must possess knowledge of how to tune and optimize SQL Server database and solutions including
partitioning, indexing, sharding etc..
Knowledge of newer database architectures, tools and best practices for SQL Server including ORM mapping
Experience with ER data modeling tools ( Embarcadero ER/Studio, ErWin etc.. )
Must have working knowledge of MVC design pattern and other OO design techniques.
Familiarity with SCRUM / Agile development methods.
Ability to direct the construction of appropriate database designs, procedures, and other SQL Server
database objects for both batch oriented and online workloads.
Proven analytical and problem-solving abilities. Ability to assimilate information and quickly discern the
most relevant facts and recommend the quickest, most practical design solution.
Strong logical/analytical skills with a keen ability to anticipate and avoid problems.
Work with architects to define and implement migration strategies from legacy systems to new architecture
Work well within a team environment, and have the will and the ability to succeed in an environment that
includes offshore development.
Ability to work within tight deadlines and effectively prioritize and execute tasks in a high-pressure
Outstanding communication skills (verbal and written) and an ability to communicate with internal and
external customers and all levels of management, including communicating technical information to
Attention to detail and the ability to manage several tasks at once.
Excellent understanding of coding methods and best practices. The software engineer's code must be
worthy of being held up as an example for others to follow, in terms of readability, consistency, adherence
to standards, and performance.
Recognizes good opportunities for code reuse, and ensures that the code is designed and implemented
Ability to design, validate and execute software test plans.
Strong listening skills; ability to capture requirements expressed in design meetings.
Flexible and adaptable in regard to learning and understanding new technologies.
Highly self motivated and directed.
Developing negotiation and persuasion skills; ability to facilitate consensus among a diverse group of
Experience in a BI/Data Warehouse environment with involvement in design and architecture
Experience developing ETL solutions utilizing SSIS including Requirement Gathering, Analysis, Design,
Development and Implementation of Enterprise solutions.
Excellent command and understanding of Dynamic and Advanced SQL queries in MS SQL Server 2012, and
extensively experienced with SQL / T-SQL / SSIS / SSRS.
Excellent Programming experience in writing Complex Stored Procedures, Queries, Views, User Defined
Functions, Cursors and Common Table Expressions using T-SQL.
Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.
Expert in creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation,
integration and consistency.
Excellent understanding of Entity-Relationship/Multidimensional Data Modeling (Star schema, Snowflake
schema), Data Warehouse Life Cycle and SQL Server Analysis Services (SSAS).
Extensively worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to
Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML/SQL/Oracle) to
different targets (DB/Files).
Experience in creating master and child packages, package configurations, logging and in using variables
and expressions in packages.
Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous
System (Oracle preferred) using SQL tools and utilities (SSIS and Bulk Insert).
Worked with tabular reports, matrix reports, parameterized reports according to business requirements in
time restricted environment using SQL server reporting services (SSRS).
Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages.
Experience working in an Agile Environment.
Highly committed, motivated and a natural team player with strong analytical ability.
Expert in developing Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data
matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS
Analysis Services 2012/2008R2.
Experience working with offshore teams preferred.
Experience writing technical specifications for work to be performed by other developers.
3+ (SWE) or 7+ (Sr. SWE) years of overall IT/software development experience
2+ (SWE) or 5+ (Sr. SWE) years of recent and relevant experience as an SQL Server / Oracle developer or
software engineer working on large-scale apps (ERP, CRM, etc.).
Development experience in Transact SQL / C# with good software methodology/practices. Good working
knowledge of Oracle preferred.
Experience in automotive marketing and/or CRM applications preferred.
Team Foundation Server experience preferred.
Informatica experience helpful but not required.
Candidates must possess a Bachelor's degree (and/or 5 years equivalent work experience or specialized
training) in Information Technology (IT), Computer Science (CS), Software Engineering, or a related
Microsoft certifications a plus.
Other Job Information
Salary Range: Up to $130K