Database Architect SmartSignal

SUMMARY

Are you passionate about writing high quality software Enjoy the setting of a fast-paced and flexible environment

We seek a Database Architect passionate about creating innovative software to solve business problems. In this key role you will serve as the lead member of a product development team responsible for the architecture, design, implementation, and support of the product database while working with other team leads to develop a world-class predictive analytics solution. This will include: optimizing data access; defining next generation data models; recommending hosting and customer configurations; and troubleshooting production systems.
Further, you will:


- Develop new features for commercial software releases including estimation, design, implementation, documentation and unit test.
- Coordinate defect repair with other development leads.
- Recommend evolutionary and revolutionary improvements and optimizations to existing product.
- Follow and help improve all software development processes and procedures.
- Solving complex problems.
- Work with peers to develop the best software possible.
- Communication of and adherence to T.E.A.M. (Teamwork, Energy, Accountability, and Mastery)


What We Get Excited About

Smart people who can think of more than one way to solve a problem
Demonstrated ability and desire to work in a true team environment. Must be able share your toys with others in the sandbox
People with stable and reliable work histories. People who have developed friends and relationships at previous companies
People who have career potential, since we are a growing company
People who not only like to do it but like teaching others how to do it
Effective communicators
What You Should Get Excited About
You will be a visible part of an organization that uses technology to solve business critical issues
Youll work with smart, interesting people who have lives that extend beyond work
You will know company objectives, company financials and have the ability to participate in setting both
Participating in a company undergoing growth, offering the many personal and professional opportunities that growth offers
Opportunity to make a real difference

ABOUT SMARTSIGNAL

This is an exciting opportunity to join a successful, profitable and growing 90+ person software company that provides comprehensive patented solutions to the energy industry. Based in Lisle, IL, SmartSignal offers a supportive, flexible, and team-based working environment. SmartSignal does not offshore, has a casual work environment, and strives to minimize useless meetings.

SmartSignal maximizes worldwide industry equipment performance, availability, and reliability by detecting, diagnosing, and prioritizing equipment and process problems before they become costly failures. Drawing on over 40 patents, SmartSignal delivers specific, relevant, and actionable intelligence that makes people more proactive and productive. SmartSignal serves customers in power generation, oil and gas, mining, aviation, pulp and paper, and other process industries worldwide. SmartSignal and its customers have won over twenty awards for excellence, including a Wall Street Journal Technology Innovation Award and the 2009 ITA (Illinois Technology Association) Lighthouse Award for excellence in product and services.

SmartSignals comprehensive benefits package includes employee health, dental, vision, disability and life insurance, two flexible spending programs, a retirement plan, stock options, team events and awards programs.


POSITION REQUIREMENTS


- Experience developing commercial software products, preferably Microsoft SQL-based products.
- At least 5+ years experience in data modeling and database administration. This job does NOT involve performing regular backups or other database administration duties, but your past experience in doing so will provide the wisdom to design the system to reduce maintenance costs and overhead.
- In-depth knowledge of tuning SQL and analyzing execution plans
- In-depth knowledge of T-SQL with the ability to provide guidance on when to use/not use certain programming techniques
- Strong grasp of SQL Profiler with experience analyzing trace files
- Strong grasp of all aspects of physically tuning a SQL server database instance including: IO subsystem, operating system and network.
- Strong grasp of back-up and recovery techniques with the ability to recommend a strategy based on cost/performance.
- Ability to design a logical relational model as well as dimensional-fact (star-schema) models. Must be able to recommend when one is a better fit based on the situati
- Formal training and knowledge with; logic and flow diagrams, testing and debugging techniques, structured programming languages


Personal characteristics:

Enthusiastic with a great attitude
Desire to solve complex problems through software
Commitment to developing the best software possible
Excellent analytical, troubleshooting and problem solving skills
Ability to present and clearly communicate complex technical problems and solutions.
Good team player with excellent written, verbal and interpersonal communication skills.
Strong analytical skills and meticulous attention to detail
Ability to convert project specifications and requirements into logical designs for coding
Ability to follow plans and schedules
Comfortable task-switching and being interrupted

Experience with any of the following would be a plus:

Experience with partitioned tables
Knowledge of the theoretical basis a plus, including: Relational algebra; Normal Forms up to Boyce-Codd, 4th and 5th Normal Form a plus; Functional Dependencies; minimal cover, loss-less join decomposition, functional decomposition and Armstrong's Axioms
Design of a versioning and deployment paradigm for schema changes
Experience with other DBMS such Oracle or DB2

EDUCATION

Bachelors Degree in Computer Science, Engineering, or equivalent
Relevant training a plus.

Location:	Lisle, IL United States