Job Detail
Great technical challenges in an employee friendly company.The Database Developer and Business Intelligence Specialist will have both development and operational database responsibilities. The ideal candidate will have experience supporting and maintaining Microsoft SQL Server OR MySQL databases and solid development experience with the product. This candidate should also have experience developing ETL’s and have some exposure to the entire Microsoft Business Intelligence stack and a desire to expand their BI expertise.
Essential Duties / Responsibilities:• Database design (logical/physical), architecture and data modeling for relational, OLTP and OLAP databases.
• DBA support of data marts and BI environments (security, performance, maintenance plans, etc).
• Setup, automate, support and monitor database replication.
• Develop views, stored procedures, indexes, functions, triggers and other database objects to facilitate efficient data ETL, manipulation and consistency.
• Develop and implement solutions to improve SQL performance utilizing built-in monitoring and tuning tools.
• Develop ETL’s to load data marts and or data warehouse.
• Provide design and support on the Business Intelligence delivery system.
• Review and approve database objects being promoted to production.
• Provide database support the application developers
• Create and maintain technical documentation for environments
• Analyzes and evaluates various data base software packages and design aids for possible use in the computing environment. Interacts with vendors and recommends purchases
Knowledge, Skill & Ability:• Solid SSIS development skills.
• Ability to quickly and accurately analyze complex database environments.
• Provide technical leadership and expertise to define and adhere to best practices for building and delivering high performing, stable database systems (OLTP and OLAP).
• Ttroubleshooting skills.
• A passion to continue learning new technologies and approaches.
• Ability to work independently and in team environments.
• Strong communication and multitasking skills.
Education / Training / Certifications:• College graduate (or equivalent work experience)
• MCSE: Data Platform, or BI (Preferred)
Experience:• 3 – 5 recent years MSSQL OR MySQL development.
• 2+ recent years SSIS development.
• 5+ years in the IT industry.
• 2+ years providing Business Intelligence solutions
Debra Mayek952-841-9510 ext. 2debra@involveit.comContact UsSubmit Resume