Go Back
Database Engineer LOC: Tucson AZ
2016-12-15 11:22:16
Job Type:
Full Time only
Budget $:
100,000 - 200,000
PRIMARY RESPONSIBILITIES: - Works collaboratively with Java development teams throughout the product design process, to ensure optimal usage of SQL Server for storage and transaction processing
- Develops, enhances, and maintains SQL driven reports using Jaspersoft Studio, and integrates these reports into a SaaS environment
- Writes, refines, and optimizes T-SQL code for maximum performance, reliability, and maintainability
- Analyzes and interprets complex requirements, translating these into efficient backend processes
- Ability to reverse-engineer legacy code at times, improving and refining older T-SQL using newer and more efficient techniques and approaches
- Designs and implements relational databases and structures as needed
- Participates in developing cutting-edge storage design structures and data processing flows
- Creates documentation for both new and existing code
POSITION REQUIREMENTS: - 3+ years working as a database engineer or related role
- Expert level T-SQL experience, including query tuning and optimization
- Experience with reporting platforms, and the ability to translate business needs into functional and efficient T-SQL driven reports
- SQL Server Administration experience is a plus
- ETL experience is also a plus
- Intimate knowledge of SSMS, and working knowledge of the other MS SQL Server Tools
- Ability to work with differing workflows, including agile, to quickly respond to a variety of business needs
- Has a sound knowledge of best practices with regard to database development and coding standards
- Experience with Source Control and workflow ticketing systems
PREFERRED SKILLS: - Jaspersoft Reporting Studio Experience
- IDERA for SQL Server tools, including Diagostic Manager and Admin Toolset
- Advanced SQL Server knowledge, which might include Service Broker, Resource Governor, Temporal Tables or SQL Server 2016 features such as Query Store
JOB COMPLEXITY: - Position can involve complex logic and algorithms, and may require creative solutions at times.
- Leverages experience to promote best practices and help define procedures.
- Works with a team to promote innovation and knowledge transfer across the organization.
EXPERIENCE & EDUCATION: - A Bachelors degree or higher in Computer Science or a related field, or equivalent functional experience in the area.
- 5+ years experience of database administration or development.
Key Skills: