SUMMARY:

• DBA: Performance tuning. Finding bottlenecks. Tracing. Performing proactive maintenance for database storage and tablespaces, etc.
• RMAN (cloning, duplicating, including cross - platform), HA/DR, Data Guard (including Active DG), Transportable tablespaces, Migration
• Installations, administration, cloning, patching, managing Oracle servers.
• ADDM, Flashback, Partitioning (all types), DB growth control, effective disk space usage. DBMS REDEFINITION
• Deciding and implementing backups, restore and recovery strategies. Strengthening Business Continuity by an internal disaster recovery test and periodically validating restore, recovery
• Oracle Enterprise Linux (RHEL), Windows platforms
• Database architect and Developer. Fine tuning DB objects. Deep database normalization. Locking. Transactions. Simultaneously access. Complex SQL - queries. Parallelism. Analytical functions. Advanced queuing. Loading scheduling and balancing. Ensuring data logical integrity. Stored procedures. Pipelined functions. Database and Table - level triggers.
• MS SQL Server
• T-SQL, Stored Procedures and Functions (Scalar and Table-Valued). Indexes. Statistics
• Deep understanding of MS SQL security model. Audit with several ways, including basic.
• Development databases with deep normalization for new applications for decreasing physical and logical IO for highest possible performance.
• Tuning performance of all database-related components (database engine, data models, stored procedures, etc.) in complex applications. Tracing
• Investigating and resolving any database-related production issues and incidents; performing root cause analysis and propose/implement solutions to eliminate problems
• Administration of Microsoft SQL Server 2012, 2014. Backup/Recovery. Log Shipping
• Providing support for development teams
• High Availability (AlwaysOn). BI Stack: SSRS, SSIS (average experience)
• MS Dynamics Ax 2009, 2012
• Accounts Payable, Account Receivable, Inventory Management, General Ledger, Fixed Assets, Cash and Bank Management, Human ResourcesUser Interface Tools
• Oracle Application Express (APEX). Oracle Discoverer. Tableau. Glassfish
• Miscellaneous
• Windows Server administration, Domains, Active Directory, Hyper-V, VMWare, PowerShell, DNS, DHCP, TCP/IP
• Finance & Accounting. Financial modeling. Logistics. “Cost Volume Profit” analysis. Business process optimization and modeling, UML, OBM, IDEF1x. Customer Relationship Management (CRM). Supply Chain Management (SCM). Data analysis, modeling and optimization. Development enterprise standards (Naming Convention, etc.). Environment documenting

PROFESSIONAL EXPERIENCE:

Confidential

MS SQL DBA

Responsibilities:

• Significantly improved main query performance and significantly decreased CPU workload, implemented on BSB, ready to SB
• Developed new Access Control List (ACL) rules for SB MS SQL, based on AD groups, instead of direct MS SQL logins
• Improved database model for existing applications for increasing performance and cleansing data
• Support Development Team, Support ETL-processes
• Providing s for developers, related to MS SQL

Confidential

Oracle PL/SQL developer, DBA

Responsibilities:

• Architect, developed “from zero” OLTP system for medical organization. Just one author of system. Oracle Database 11g, Oracle Application Express (APEX)

Confidential

Responsibilities:

• Analyzing incoming Request for Change (RFC) from business customers; Building architecture of modification or suggest existing functionality; Analyzing influence on other components; Reconcile implementability with the developer; Development Functional design (FD); Testing developed modifications for correctness and performance.
• Development procedures for eliminating data inconsistences for General Ledger, Customer\Vendors and Inventory Management — all data errors must be fixed

Confidential

Oracle developer, DBA

Responsibilities:

• Installed and maintenance Oracle database server. Planned, created database structure for Very Large Database (VLDB, planned growth up to 2 TB now). Analyzed gathered game logs (retrieved as almost plain-text and stored on MySQL)
• Data cleansed — consolidating data within a database by removing inconsistent data, removing duplicates, data normalization and converting to relational format in order to achieve the most accurate and concise database. Data quality sufficiently increased for eliminating unreliable results
• Developed ETL procedures for filling DWH. Developed facts, analytical reports, using OLAP, BI, BA

Confidential

Oracle PL/SQL developer, DBA

Responsibilities:

• Architect, developed “from zero”, support “cold” Billing system for medium - size Internet provider
• Collect requirements; analyze best practices, competitive solutions. Developed: logical and physical model of database, usability interface program modules, Data Warehouse, Reports
• Using Oracle AIM (as SDLC base) & PMBoK methodology. Oracle Database 11gR2, Oracle Discoverer.
• Support of developed system
• Just one author of system — from business challenge and idea to support production system.

Confidential

Associate

Responsibilities:

• center management for project KSA - 2008 (Complex Engineering Automation System, http://www. Confidential ). Conducted learning more, than 350 employees on 40 courses. More, than 120 groups, 300 group-day, 12 000 hours
• Development Project Management Office (PMO) and introducing Project Management

Confidential

Oracle Developer

Responsibilities:

• The Project on development and introduction Information-Analytical system for working on Wholesale market of the Electric Energy. Project architect
• Designed the structure of database and Data Warehouse (the facts, measurements)
• Technologically system is based on Oracle Database 10g and Oracle BI

Confidential

Oracle Developer

Responsibilities:

• Introduced Mercury IT Governance Center. Introduced ITIL processes. Developed modifications, based on Oracle Database 9i

Confidential

IT - Consultant

Responsibilities:

• Technical support for customers on all modules of Axapta. More, than 400 requests processed in first year. More, than 20 customers. 4 VIP - customers.
• Developed efficient channel of interacting with Microsoft Business Solutions.
• Developed and started new service “Technical audit”, based on Oracle Database.