Oppenheimer Companies, Inc.SQL DBA
Sep. 2011 - Sep. 2012Boise, Idaho Area• Maintains company’s reporting web application in C#,VB.Net and ASP.Net.
• Manages MS SQL Server 2008 R2 backups, configuration and upgrades. • Analyzed and optimized MS SQL Server 2008 R2 production databases.
• Developed & maintains scripts, utility jobs or functions needed for the production databases.
• Developed utility programs for MS SQL Server using C#.
• Other jobs include maintaining, creating and configuring SQL Server.
• Integration Services (SSIS), SQL Server Reporting Services (SSRS) and some SQL Server Analysis Services(SSAS).
• Created Excel models and complex TSQL.