PostJob

Job Title: Sr. SQL Server Database Developer


Job Location: IL - Chicago
Job Description:


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 
users.

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

Responsibilities

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 
departments.

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 
implementation planning/strategies

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 
objectives

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

Skills

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 
databases.

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 
tools.

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 
and technologies.

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 
environment.

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 
nontechnical audiences.

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 
accordingly.

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 
stakeholders.

Experience

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.

 

Education Requirements

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 
discipline.

Microsoft certifications a plus.



Other Job Information


City:
Salary Range: Up to $130K
Relocate: