| |
SmartSignal solutions protect over 5,000 assets in the Power Generation, Oil & Gas, Aviation, and Pulp and Paper industries. By employing SmartSignal technology and services, major oil fields, pipelines, and over 300 plants eliminate billions of dollars of equipment and process problems each year. Over the last five years, SmartSignal has grown at a compound rate of over 45% per year and it has increased its number of patents to over 45.
SmartSignal finds potential failures well before traditional condition based monitoring and classical statistical techniques sense them. By addressing equipment problems before they hatch, SmartSignal customers improve their profitability, return on assets, and safety while consuming less fuel.
If you want to make a difference by developing, implementing, marketing, and supporting SmartSignal software products and services please contact us. We’re looking for people who thrive on solving problems and working with the best and brightest in their field.
We provide a supportive, casual, team-based working environment, which is also fast-paced and dynamic. Our comprehensive benefits package includes stock options, team events and awards programs, and, fully paid employee health, dental, vision, disability and life insurance.
Database Architect Role:
Lead member of product development team responsible for the architecture and design of the product database, working with other team leads to develop world-class predictive analytics solution. Including: optimizing data access; defining next generation data models; recommending hosting and customer configurations; and troubleshooting production systems.
Requirements:
- Developing new features for commercial software releases – including estimation, design, implementation, documentation and unit test
- Coordinating defect repair with other development leads.
- Recommending 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)
Experience and Skills:
- Experience developing commercial software products, preferably Microsoft SQL-based products.
- At least 5-7 years experience in data modeling and database administration.
- 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 situation.
- Experience with partitioned tables a plus
- 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 a plus
- Experience with other DBMS such Oracle or DB2 are a plus
Additional Skills:
- 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
- Formal training and knowledge with; logic and flow diagrams, testing and debugging techniques, structured programming languages
For Immediate consideration, please send resume to 21598-CS-1331@smartsignal.hrmdirect.com |
