Database Developer / Dba
• Maintain and evolve the internally built portfolio management reporting system which is a key insight and reporting tool for the investments team, traders and senior management.• Maintain and evolve the back-office system, a heavy-weight IT processing system that handles position keeping, clearance, settlement, etc• Develop reports using iReports, QlikView, SSRS• Develop databases/forms/reports using Microsoft Access 2007• Developed applications, Delphi 7 & SQL2000, Visual… Show more • Maintain and evolve the internally built portfolio management reporting system which is a key insight and reporting tool for the investments team, traders and senior management.• Maintain and evolve the back-office system, a heavy-weight IT processing system that handles position keeping, clearance, settlement, etc• Develop reports using iReports, QlikView, SSRS• Develop databases/forms/reports using Microsoft Access 2007• Developed applications, Delphi 7 & SQL2000, Visual Studio & SQL 2005-2012• Develop a bunch of internally built ASP. NET / MVC / C# applications• Data warehousing (SSIS) and Multidimensional Modelling (SSAS). • Writing and tuning SQL queries, stored procedures, functions, tables, views, etc.• Performance tuning (Database Engine Tuning Advisor, DMVs, SQL Server Profiler)• Monitoring and maintaining of data integrity and the management of all automated processes.• Load XML data into existing databases (SSIS).• Designing and writing ETL to load data from external systems (Moscow Exchange and National Depository Centre) into data warehouse (SSIS).• Data warehousing and Multidimensional Modelling (SSIS + SSAS).• Import data from online trading and news systems, i.e. Reuters• Excel Data Analysis: Sort, Filter, PivotTables, Formulas. Some VBA code.• Technical support for the company's end users and customers.• Troubleshoot, analyse and enhance existing computer systems.• Additional responsibilities: manage and monitor network services, recommend and acquire equipment replacements and upgrades, maintain an inventory of all network devices, integrate new technologies into the existing environment, perform routine audits of systems and software, troubleshoot any reported problems.Environment:MS SQL Server 2000/2005/2012, MS SQL Server Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), MS Excel, Business Intelligence Development Studio, Visual Studio 2012 Show less
