Programmer / Software Developer / Database Administrator / Systems Administrator / IT Specialist

Был больше месяца назад

По договорённости

50 лет (родился 05 сентября 1975)

Город за рубежом, готов к переезду

Занятость

не указано

Гражданство

Дальнее зарубежье

Контакты

Телефон

Почта

Будут доступны после открытия

Фото, имя и контакты доступны только авторизованным пользователям

Опыт работы 25 лет и 2 месяца

- Март 2009 – работает сейчас
- 16 лет и 9 месяцев
IT-специалист
CSC Life Science Center
Обязанности и достижения:
IT-Specialist, CSC Life Science Center, Espoo, Finland Main Tasks & Areas of Responsibility Database Management & Administration; • Design, testing and implementation of database structures, using MySQL and MS-SQL. • Installing and maintaining SQL Server database systems; ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc. • Coordinating with the Systems Administration team; installing and maintaining application software and systems that integrate perfectly with the corresponding database systems. • Updating database systems by reviewing, planning, testing and installing database security patches and service packs. • Designing, documenting, and promoting security "best practices", policies, standards and protocols. • Migrating application code and objects from development/test environments to production. • Working with development and systems teams to perform application and database tuning. • In conjunction with development teams, defining and maintaining database and code standards, and naming conventions for the organization to ensure consistency in database and code development. • Installing, Upgrading, and consequently, Migrating databases from SQL Server 2005 to SQL Server 2008, and to SQL Server 2012. • Setup and maintenance of appropriate database and application monitoring. • Setup, test and maintain business continuity/disaster recovery infrastructure database and applications. • Providing highly available database and application infrastructure according to Business Continuity Plans & Requirements, using SQL clustering, load-balancing, etc. • Evaluating data modeling, database administration, and database backup and recovery tools, and making recommendations. • Setting up and monitoring transactional replication, and database mirroring on Production and QA Servers. • Monitoring and troubleshooting Log Shipping. • Reviewing physical and logical database designs; promoting the reliability of database designs by ensuring appropriate referential data integrity is implemented, and appropriate data types are used. • Creating processes and procedures for application code and database object migrations, to support an efficient and reliable system development lifecycle. • Extract Transform Load (ETL) development, using SQL Server Integration Services (SSIS). • Creating new database objects like Tables, Procedures, Functions, Indexes and Views, using T-SQL in both development and production environments, for SQL Servers (2005, 2008, and 2012) • Working in Active/Active, and Active/Passive Cluster environments, as high-availability solutions. • Failover cluster testing and resolution on HP servers, as well as monitoring and backup reporting setup with Microsoft Operations Manager, and backup teams. • Tuning queries which are running slowly, using Profiler and Statistics; using different methods for evaluating joins and indexes; updating Statistics and code modifications. • Creating complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for applications, using T-SQL. • Checking Database Health, using DBCC Commands and DMVS • Monitoring and modifying performance, using execution plans and index-tuning. • Preparing documentation for Disaster Recovery Plans (DRP) • Daily routine DBA tasks, like Backups and Restorations; handling user-permissions and space issues on both production and semi-production servers; as well as handling maintenance Jobs. • Handling monthly Database Refresh in QA-Test environment, for testing new deployments and builds. • Highly-skilled in Data Modeling and Metadata Services. • Table partitioning mechanism to allow the SQL Server engine to escalate locks to the partition level, before the table level. • Using Transparent Encryption, Table Compression, Database Compression and merge statements (SQL server 2008). • Using Policy Based Administration feature (SQL Server 2008). • Using 'upsert' commands to programmatically INSERT data if it does not exist, or UPDATE the data, if it does. • Performing Backup/Restore to/from Legato server (Tape) and Disk • Handling Database security and integrity planning • Generating periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS). Microsoft Servers & Tools • Installing, testing, and maintaining Microsoft Exchange Servers; identifying and resolving problems/issues arising on the Exchange email systems. • Installing security policies and procedures on the Microsoft Exchange Servers. • Managing and supporting Exchange 2010 infrastructure, consisting of clustered back-end servers and front-end servers. • Configuring Windows Server Active Directory Domains; configuring DNS, DHCP, trust relationships & permissions. • Upgrading Microsoft Servers with new technologies. • Performing regular tests on the server’s disaster recovery systems. • Monitoring daily requests from users and responding accordingly. • Troubleshooting server errors/issues • Coordinating with various teams to install servers. • Maintained the server’s operating system configurations. • Performing security checks and capacity reporting to ensure the smooth functioning of the operating system.. • Preparing documentation of the various system configurations, policies and procedures.. • Message tracking and troubleshooting to resolve mail delivery issues; supporting Offline Address books. • Creating, replicating, and assigning rights to Public Folders. • Monitoring message queues. Performing Exchange Server backup and restore. • Planning and configuring Microsoft Exchange, and providing support to various other email applications, such as Outlook 2010, etc. • Implementing disaster-recovery programs on a regular basis; upgrading security technologies in the system when required. • Administering the Exchange Server as a whole, and providing support wherever needed. Networks and Monitoring • Using NAGIOS systems & server monitoring; • Designing and building web-based applications and tools. • Supervising existing internet networks (lan/wan) by following routine procedures; • Performing research and development; • Providing solutions to different companies for building their LAN; • Administration of office LANs, based on Windows Server 2003, Windows XP, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012; • Coordinating R&D progress with Systems Administrators and Engineers on a weekly basis. • Maintenance of internal servers: WWW, IIS/Apache, Email (send mail), FTP, Proxy Servers, DNS Servers (windows/linux), Access Servers, Routers, Switches; Identity & Customer Management • Design, implementation, customization and administration of a fully-functional Identity Management (IDM) system ---- first with Sun IDM, and then later replacing this with Novell IDM; • Troubleshooting; Maintenance & customer follow-up • Making on-site software design changes to meet the specific needs of the customer; • Dealing with customer complaints regarding the system, its functions and technical aspects; • Generate and execute scripts, using: Perl, Unix Shell, VisualBasic, PHP, Xpress; • Perform usability testing and synthesize data into concrete design proposals; present key design ideas using flowcharts, prototypes and mock-ups. Customer Service & Relations • Concept design; Contract/Vendor Negotiations; Conducting Executive Briefings; • Building and leading teams; Client Negotiation; • Hands-on Technical Leadership; Technical Support; User Training and Support; • Service Level Agreements; Technology Transfer; • Customer Service Delivery; Operations/Infrastructure Management; ARCGIS • ArcGIS project management and GIS applications; GIS system architecture design; assessing the current state of affairs; • Mapping available GIS data, using: ArcGIS 9.x/10.x, ArcMap, ArcCatalog, ArcToolbox; Spatial Analyst, 3D Analyst, Network Analyst, ArcInfo Workstation; ArcIMS 9, ArcView 3.3; VisualBasic (VBA and ArcObjects), XTools Pro for ArcGIS, Global Mapper; • Elaborating a comprehensive User Needs analysis, in terms of data mapping, GIS, as well as hard and soft architecture; • Managing the database of the geographical ECWP (upgrade, integration, creation and updating); • Classification of aerial / satellite photographs; • Managing evaluation using ESRI ArcGIS products; • Coordinating system and datum transformations; data conversion from CAD to GIS, and vice versa; • Collection GPS locations; converting GPS data into GIS format; • Creating interactive GIS/Flash web applications Projects • Creating, developing, installing, and implementing a Sun Identity Manager (IDM) system (with full & complete integration into different Resources and eDirectories, including: MS-SQL database, MySQL database, LDAP, Active Directory, and Exchange Server) • Creating, developing, installing, and implementing a Novell Identity Manager (IDM) system (with full & complete integration into different Resources and eDirectories, including: MS-SQL database, MySQL database, LDAP, Active Directory, and Exchange Server) • Installing, developing, and configuring a fully-functional Customer Relationship Management (CRM) system. • Serving as DBA and project leader in the completion of several medium- to large-scale implementations; managing projects, from business requirements analysis to solutions delivery and support. • Managed a $1.2 million data-integration project for financial services firm that consolidated information from accounting applications, third-party market data and internal equities/fixed income applications. • Created Web-enabled, group-scheduling system for a large university, allowing students to view and print schedules for current and future semesters. Delivered solution on time, on spec and on budget. • Innovated time-saving, robust employee data-intake system that automated database update functions, enabling new salary and process-exception information to be automatically populated. • Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability. • Enhanced end users' understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials. • Developed approximately 25 custom financial and auditing reports using Crystal Reports with T-SQL, JDE Report Design Aid, MS Excel and Access. • Managed all phases of the software development lifecycle (SDLC) for dozens of custom solutions. • Led design and multinational rollout of robust, scalable and secure electronic data interchange (EDI), enterprise resource planning (ERP) and point-of-sale (POS) systems for clients
- Сентябрь 2008 – ноябрь 2008
- 3 месяца
Applications Developer
Zolvia Oy (ComActivity Oy)
Обязанности и достижения:
Main Tasks & Areas of Responsibility • Building model-based development tools for interaction with operational applications (such as MOVEX (M3)); • Designing and building web-based applications and tools, using ComActivity; • Using the same model-based tool to design and implement more efficient database structures; • Making on-site software design changes to meet the specific needs of the customer; • Troubleshooting and maintenance; customer feedbacks and follow-ups; Projects (My time spent at Zolvia Oy was too short to warrant any mention. However, I was involved in the early stages of one of Zolvia’s first projects: the assessment and feasibility study for installing and implementing the “ComActivity” software in one of Finland’s largest companies: Stora Enso)
- Октябрь 2007 – август 2008
- 11 месяцев
Software Developer
DC Tieto Oy
Обязанности и достижения:
Main Tasks & Areas of Responsibility • Develop advanced multi-browser and object-oriented Javascript; Developed UNIX and Windows applications in C, using low-level operating system functions. • Develop Perl scripts to generate HTML and JavaScript reports, to reflect the real-time status of running builds; • Perform usability testing and synthesize data into concrete design proposals; present key design ideas using flowcharts, prototypes and mock-ups. (Played a key role in closing contracts valued at more than 1 million Euros); • Occasional on-site implementation of software and hardware projects. Projects • Creating, developing and implementing a multi-process-driven accounting system for a financial company. Consequently, designed a new system for computerizing the company’s transport & logistics inventory (this involved the overhauling of the company’s entire invoicing system) • Designed and developed CRM and ERP applications using Java, Java Servlets and other Java components Created function specific applets for different websites, tested and implemented for cross browser compatibility Integrated Java and other programs to develop multi-functional web-servlets Served as a Web Logic administrator and optimized system performance Handled documentation for every project Ensured that the standard practices are followed throughout the projects • Improved the overall quality of the Java/J2EE based online Internet System for our clients. • Migrated a poorly performing and outdated application from SWING, EJB 1.1 session beans, entity beans and Websphere Apps Server-based architecture to an EJB 2.1 Session Beans, Spring, Hibernate, Tapestry, JiBX, and JBoss Apps Server based architecture. • Integrated other sub-systems through JMS and XML. • Developed JMX services to be run on JBoss Apps Serve • Fixed memory leaks and transactional issues on a J2EE-based online system. • Designed and developed an improved J2EE/Java based framework to an existing centralized file maintenance system, which improved maintainability, security and performance. • Developed an e-Commerce B2B Portal, using J2EE technology. The system involved content management and customer experience. The Weblogic App Server was used with the EJB, Servlets, JSP, Java, and MVC framework • Developed Online SMS Loaning Systems (www.superlaina.fi, www.onnilaina.fi, www.fokuslaina.fi) • Online casino website • Designed database processor components, to maintain the connection for specified drivers and URL strings, using Oracle • Created, designed and implemented online systems for testing, documentation, tracking and reporting, which provided sharing of plans, forecasts and results among all team members, thereby reducing test cycle duration, decreasing duplication, and improving tracking of all areas, especially proven trouble spots. • Created and designed a utility which enable the creation of downloadable packages with remote Storage Array controller operating code version dependencies, and displayable attribute identifiers
- Июль 1997 – сентябрь 2004
- 7 лет и 3 месяца
Programmer
Russia OnLine
Обязанности и достижения:
Main Tasks & Areas of Responsibility • Basic programming tasks, using mainly Cobol, but additionally: C+, C++, and Unix. • Direct conceptual, strategic and tactical creation of GUI Website and Web Application Solutions, using HTML, XHTML, JavaScript, and Oracle; • Manage multiple simulataneous projects, successfully meeting all budgets and timeframes (Drove 6 technically complex, large-scale projects from conceptual stages to delivery in less than 8 months; • Lead and co-ordinate a cross-functional design & engineering team; maintain a goal-oriented environment, while facilitating boundary questioning and creative thinking Projects • Designed, built, tested and implemented a website for the company’s online marketing and advertising; • Defined and built a database system for the Credit & Loans Department of one of russia’s largest savings banks (www.sberbank.ru)

Образование

- Магистр
- Дневная/Очная
- 1997
Institute of Data Processing Management
Факультет: Information Technology
Специальность: Data Processing; Programming; Statistics; Business Methods; Quantitative Analysis; Systems Analysis

Обо мне

Дополнительные сведения:

Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) Software architecture planning: X Data warehouse (data warehousing and reporting): X Integration skills and EAI: X Systems expert`s tasks: X User interface design: X Implementation and transfer to production: X Hardware and network design: X Business needs mapping: X User support tasks: X Sales support tasks: X Object oriented modelling: X Project management: X Process consultation: X Application development, programming: X Application requirement specification: X Technical consultation: X Technical design: X Testing: X Test planning: X Database design: X Network know-how: X PROGRAMMING LANGUAGES & DEVELOPERS Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) .NET: X C: X C#: X C++: X Cobol: X EJB: X HTML5: X J2EE: X J2ME: X J2SE: X Java Servlets: X Perl: X PHP: X SQL: X XML: X Ruby on Rails: X DATABASES & DATABASE MANAGEMENT Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) DB2: X Microsoft SQL Server 2003 X SQL Server 2005 X SQL Server 2008 X SQL Server 2010 X SQL Server 2012 X Oracle: X SAS: X Sybase: X My SQL X Business Objects: X SERVER PRODUCTS Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) BEA WebLogic: X IBM WebSphere: X Apache: X JBoss: X Tomcat: X Documentum: X Microsoft server products X Oracle server products X UML: X Sharepoint / MOSS X OPERATING SYSTEMS Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) HP-UX: X Sun Solaris: X Unix: X Linux X Windows Server 2000 X Windows Server 2003 X Windows Server 2005 X Windows Server 2008 X Windows Server 2008 R2 X Microsoft Windows XP: X Microsoft Windows NT: X Symbian: X Windows Mobile: X Mobile Linux: X TESTING TOOLS Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) LoadRunner: X Silk Test: X TestDirectory: X WinRunner: X Testlink: X JAVA SKILLS Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) EJB 2: X EJB 3: X Spring: X Hibernate: X Eclipse: X JBuilder: X Java Studio: X Maven 1: X Maven 2: X Java Applets X JBoss AOP: X TEST DESIGNERS & TESTERS Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) Operational testing: X Unit testing: X Integration testing: X User interface testing: X Test case design: X Test project management: X Version management: X Configuration management: X Load testing: X Performance testing: X Test documentation management X Implementation planning: X Test environment installation X PROJECT MANAGEMENT Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) Management by projects and project phasing: X Workload assessment: X Budgeting: X Specification skills: X Requirements management: X Project methods and processes: X Project management software and tools: X Documentation management: X Steering group work: X Team leadership, supervisory skills: X Cooperation skills: X Business sector experience: X APPLICATIONS & TOOLS Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) CRM: X CMS X ERP: X MS Office: X MS Project: X MS Visio: X SAS X JIRA X Azure X Magento X SYSTEMS MANAGEMENT Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) HP-UX: X Linux: X Microsoft Exchange Server: X Microsoft Internet Information Server: X Microsoft SQL Server: X Microsoft Windows Server: X Microsoft Windows, workstation support: X Unix: X Active Directory: X IBM server products: X Oracle server products: X Sun server products: X DBA tasks: X NETWORKS / PROTOCOLS / SECURITY Beginner (1) Junior (2) Advanced (3) Expert (4) Guru (5) LAN X WLAN X VPN X Citrix X CVS X SCRUM X POP3 X IMAP X HTTP X SMTP X TCP/IP X USB X Antiviruses X Security Patch Installation X Mail Server X Documentation X Customer Service X