SUMMARY

• Senior database performance tuning specialist with over 12 years diverse experience with expert noledge in SQL tuning. Highly skilled in performance analysis and tuning. Experienced in various environments: OLTP, Data Warehouses, VLDB and mixed, RAC, Exadata.
• Wide experience in identifying of performance bottlenecks and performance tuning
• More than 12 years of design and development server - side business logic in Oracle Database (8i- 11g);
• Experienced in various environments: low latency OLTP (>500 tps), VLDB and mixed, RAC, Exadata.
• Extensive experience in development and tuning: Partitioning, Parallel Processing, Advanced Queues, Heterogeneous Services, Compression, B-Tree and Bitmap Indexes, Hierarchical Queries, Bulk Operations, Analytic Functions, Regular Expressions, Materialized Views, Direct-Path and Conventional Loading
• Good noledge of Exadata architecture. Performance analysis and tuning of Exadata features as Offloading, Smart Scan, Storage Indexing, Hybrid Columnar Compression
• Excellent noledge of SQL and PL/SQL. Deep understanding of SQL Processing, Oracle Cost Based Optimizer (CBO).
• Data Design (logical and physical)
• Experienced in Unix and Linux
• Full software development life cycle experience

PROFESSIONAL EXPERIENCE

Senior Technical Analyst

Confidential, Colorado Springs, US

Responsibilities:

• Performance Analysis, Tuning and Troubleshooting in various environments including OLTP, VLDB, Exadata, In-Memory using various methods and diagnostics tools including hanganalyze, system state dumps, OS Watcher, dtrace, and many others
• Analyzed source code, identified defects, suggested enhancements
• Tier-1 engineer, handled and resolved highly escalated issues

Senior Technical Specialist

Confidential

Responsibilities:

• Performance Analysis, Tuning and Troubleshooting
• Exadata Installation, Configuration, Upgrade, Multi-rack setup, Patching
• Big Data Appliance installation and configuration

Environment: Exadata, SPARC Supercluster, Oracle 11g-12c, RAC, ASM, Cloud Control 12c, Solaris 10/11, Linux, Cloud Control, dtrace, Oracle performance tools (AWR, ASH, tkprof, trcess, dbms profiler, oradebug, etc).

Senior Oracle Developer

Confidential

Responsibilities:

• Developed objects and logic, critical from performance point of view
• Analyzed performance, identified performance bottlenecks and deliver solutions on the basis of analysis
• Performed SQL, PL/SQL, instance tuning as well as improvement of whole database architecture
• Carried out regular review of new design and code from development teams
• Wrote white papers about performance bottlenecks and improvements
• Actively participated in Oracle SIG (Special Interests Group) inside Confidential as SQL and performance tuning professional
• Provided on-call support for urgent performance issues
• Investigated and test migration to Exadata

Environment: Oracle 10g-11g, RAC, Exadata, Solaris 10 x86, PL/SQL Developer, Oracle SQL Developer, Grid Control, Perforce, Oracle performance tools (AWR, ASH, tkprof, trcess, dbms profiler, oradebug, etc).

Senior Oracle Engineer

Confidential

Responsibilities:

• Designed and developed billing for heavy loaded (> 500 tps) OLTP database, in part of team of two people.
• Designed logical and physical data models using Sybase Power Designer, and Embercadero Studio
• Developed and implemented ETL procedures
• Performed SQL and PL/SQL tuning Oracle DBA
• Performed administration (maintenance, installation, patching) of a production, development and test databases, transactional and reporting (up to 3Tb), more than 15 databases.
• Build an infrastructure of high availability using Data Guard
• Deployed and used Grid Control for monitor of databases and entire system
• Cloned databases for development, QA environments
• Planned and implemented of backup and recovery strategy
• Carried out performance analysis and tuning
• Developed shell scripts for solve administration routines

Environment: Oracle 9i-11g, Solaris 10, Linux SLES 11, Linux CentOS 5, Windows 2003, PL/SQL Developer 7, Oracle SQL Developer, Embercadero Studio, NetBeans 6, Oracle tools and utilities: AWR, ASH, Imp/Exp, Data Pump, tkprof, trcsess, OraSRP, oradebug.

Senior Developer/DBA

Confidential

Responsibilities:

• Designed and developed billing
• Generated reports from the database using PL/SQL and complex SQL queries
• Performed maintenance and administration of a production databases
• Implemented standby servers using Oracle 9i, Oracle 10g
• Carried out performance analysis and tuning

Environment: Oracle 9i-10g, Windows 2003 Server, Linux SUSE, PL/SQL Developer 7, Oracle tools and utilities SQL*Plus, Imp/Exp, Data Pump, TKProf, SRP.

Oracle Developer

Confidential

Responsibilities:

• Designed and developed billing using Oracle 9i, 10g.
• Carried out performance analysis and tuning
• Generated reports from the database using PL/SQL and complex SQL queries.
• Held communication between IT department and other company departments. Instructed users about new information system operation.

Environment: Oracle 8i-10g, Solaris, Windows 2000 Server, PL/SQL Developer 5/6, Oracle tools and utilities SQL1 2Plus, Imp/Exp, TKProf.