Database Developer

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

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

49 лет (родился 28 октября 1976)

Харьков, готов к переезду: Москва, Санкт-Петербург и ещё 12 городов

Занятость

не указано

Гражданство

не указано

Контакты

Телефон

Почта

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

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

Опыт работы 8 лет и 9 месяцев

- Март 2017 – работает сейчас
- 8 лет и 9 месяцев
Oracle DBA, Developer, Architect
Online Oracle Advising
http://online-oracle-advising.com
Oracle Development and Optimization
Обязанности и достижения:
All activity, related to Oracle and MS SQL Databases for my Customers. Several long-term projects and ad-hoc request solving

Обо мне

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

Oracle Database 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 Resources, User 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