Expert Profile
BI\Database Administration & Development (9 years)
• Provided data safety, system and database optimization, conducted backups and restored databases, defined physical and logical architecture of databases, managed permissions, performance tuning.
• Collect and document user's requirements
• Design and develop database architecture for information systems projects
• Operate database management systems to analyze data.
• Research and document data requirements, data collection and administration policy, and data access rules
• Conduct research and provide advice to other information systems professionals regarding the collection, availability and suitability of data
• Programmed in languages: T-SQL, ASP, VB, VBScript. Certified developer in Visual Studio 6 environment
• Used SSIS, SAS and SSRS technologies for 4 years.
• Worked with: Microsoft SQL Server 6. 5, 7. 0, 2000 & 2005, 2008, SharePoint 2007, ILM 2007(MIIS 2003)
• Operating systems: Windows 98, 2000, XP, 2003, 2008, Vista.
• To see my Microsoft Transcript use Transcript ID ( ***** ) and the Access Code (Avital1297) on https://mcp. microsoft. com/authenticate/validatemcp. aspx.
Personal Skills
• Excellent verbal and written skills
• Result-oriented
• Proactive
• Proven team player open to learn from and to teach others.
Database Administrator\Developer, Business Intelligence Developer TekSystems, Montreal 08/2009 –
• Developed stored procedures, triggers, constraints, functions, SSIS, SSRS in SQL2005 and 2008, using latest features of Microsoft SQL Server as Execute As and others.
• Optimizing stored procedures written by application developers.
• Assessment of existing environment and producing recommendations on how to improve
• Work with Development , QA and Production environments
• Participation in TransCanada project – supervising TSQL development, supporting developers, responsible for database design and performance
• Saxon Mortgages project – development of reports in SSRS 2005, helped in establishing requirements and designing TSQL code for reports
Database Administrator\Developer Advanced 3W Telecom, Montreal 06/2009 – 08/2009
• Internal databases support
• Defined physical and logical architecture of databases, managed permissions.
• Responsible for data safety, system and database optimization, backups and restores databases.
• Performance tuning.
• Developed stored procedures, triggers, constraints, functions, SSIS, SSRS in SQL 2008, using latest features of Microsoft SQL Server as Execute As and others.
• Optimizing stored procedures written by application developers.
• Assessment of existing environment and producing recommendations on how to improve
• Managed Development , QA and Production environments
• Achievements – installing high availability infrastructure for internal databases including planning and installing 2-node cluster on Windows 2008 and SQL Server 2008.
• To see my with your Microsoft Transcript use Transcript ID (*****) and the Access Code (Avital1297) on https://mcp.microsoft.com/authenticate/validatemcp.aspx .
• BA in Computer Science and Information Systems in Afula Academic College
• Cisco Network Academy