- Design, develop and implement database schema, Microsoft SQL Server objects ( tables, views, functions, stored procedures, etc.)
- Follow Agile practice
- Design, develop and deploy ETL software, primarily in SQL Server Integration Services
- Ongoing support and maintenance of databases for data warehouse applications
- Write and debug complex SQL and understand the best ways to incorporate database requests into application programs
- Perform database change management, performance tuning for data warehouse
- Write the documentation of design specifications and implementation details
- Collaborate with other team members to develop system designs, interfaces and protocols etc.
- Collaborate with system DBAs
- Coordinate with Information Systems Application groups and Vendors for SQL Server upgrades
- Manages workload to deliver quality deliverables that meet requirements and timelines
- Assists Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team members
- Provide backup support for Systems DBA
Qualifications :
- 4 + years of SQL Server database development experience; knowledge of software systems, infrastructures and Data Warehouse concepts and ETL development
- Strong analysis and troubleshooting skills
- Strong organizational skills with attention to detail a must as well as good interpersonal and time management skills required
- Working knowledge of computer operating systems (mainly Microsoft Windows Servers )
- Bachelor's degree in Computer Science, Information Systems and/or related fields
Skills :
- Working knowledge of SQL Server Databases and T-SQL programming (at least 4 years of proven experience)
- Strong understanding of SQL Server database security
- Experience with SQL Server from 2000 - current preferred
- Experience in ETL package development using Microsoft SQL Server Integration Services (SSIS)
- Basic knowledge of Web Services
- Basic Windows server administration experience
- Basic Networking experience
- Excellent written and oral communication skills
- Knowledge of ITIL best practices is a plus