SUMMARY:

• Oracle 8 - 12c: RDBMS. Logical and physical database design for OLTP and OLAP environments. (10 years)
• Memsql: Cluster schema and partitioning design, data migration, pipelines, performance tuning, support. AWS and on-prem. (3 years)
• Amazon AWS, RDS: Initial VPC design. Migration of on-prem Oracle Mysql and Memsql environment to RDS. Support in AWS. Heavy automation via AWS api. Worked on Oracle Cloud. (4 years)
• Devops: chef, Puppet, Ansible implementations for database related components. (4 years)
• Automation: extremely lazy DBA: run thing first time, script on second run. Golang if cant script. (10 years)
• Oracle DBA things: SQL tuning and tuning and tuning. RMAN. Import/export. DB Cloning. User management. Network/storage level encryption. Compression. Resource management. Partitioning. SQLNet advanced setup. LDAP setup. DBs over SAN/NFS/dNFS/local, on ASM and cooked file system. OEM/Custom DB monitoring. Worked with 300+TB DB. Worked in DMZ environments. Heavy use of storage snapshots in DB world. DB upgrades. Transportable tablespaces. POC/Benchmarking of Exadata (10 years)
• Oracle Real Application Cluster (RAC): install, setup and tuning. ASM, ASMLib. OCFS2. Migration to RAC form single instance. RAC on extended cluster. RAC specific optimization. ONS/FAN integration with UCP and ICC. (7 years)
• Replication: Golden gate, Streams, Shareplex. Setup for various replication topologies: bidirectional multi-master environments. Development of DML/DDL handlers, rule-base transformations. Error handling infrastructure. Administration, optimization and troubleshooting. Custom monitoring. Table validation infrastructure. Oracle Advance Queuing (AQ). Extensive experience in DataGuard. (8 years)
• DB virtualization: over: VMware, Oracle VM, KVM, Xen (8 years)
• PL/SQL development: Triggers, stored procedures, packages development. Dynamic SQL. Oracle objects. SQL optimization. Oracle analytic functions. (6 years)
• DB benchmarking: SwingBench, DBbench, SLOB (8 years)
• Full software development cycle: Documentation. Reporting. Version management. Testing. Agile environments. (10 years)

TECHNICAL SKILLS:

Databases: Oracle, MySQL, Memsql, Mongo, Hadoop, Postgresql, Hbase. Familiar: MS SQL, DB2.

OSs: Linux and Linux and Linux (Red Hat, Centos, Suse, OEL, Ubuntu).

Languages: PL/SQL, SQL, GoLang, bash, perl, VBA. Familiar: java, C++, ruby.

Storage: 3Par/HP, Netapp, EMC, Xiotech. Over: SAN, NFS/dNFS, ISCSI.

Tools: ErWin, ErStudio, SQL Developer, RMAN, SQLPlus, OEM, SQL loader, SQLT, OSWatcher,loadjava, svn, git, oradebug, lsof, strace, dtrace, linux perf events.

App servers: Weblogic, jBoss, Tomcat, Jetty.

Technology: NUMA, Hugepages, Jumbo frames, NIC Bonding/Teaming, Multipathing, VLAN tagging.

PROFESSIONAL EXPERIENCE:

Confidential

Principal DBA and Big data Consultant

• Design, implementation and support of Memsql cluster for real time analytics. Data migration and pipeline setup.
• Standardizing all environments under Chef. Worked with puppet and Ansible. Played with Docker.
• Moved several environments to AWS RDS. Data sync onprem <-->AWS.
• Designed universal tool in goLang to sync database passwords with Active Directory. It address historical problem of DB not been able to integrate with AD.
• MongoDB design for risk management application. Implementation and flow automation.
• RAC 10.2 - 12.1 virtualization over (vmware, Oracle VM)
• 24/7 support of very busy OLTP .com environment (~3000tps).
• SQL optimization what is beyond Oracle optimizer implemented features
• Successful Migration of 4 nodes Oracle 10.2 RAC ASM on Windows to 6 nodes Oracle 10.2 RAC ASM on RHEL5.
• Extending 6 node 11.2 RAC to 8 node RAC on highly active OLTP environment..
• Total automation of DB refresh process from prod to QA (Using 3Par snapshot, nid, ASM RMAN copy).
• Total automation of DB part of release management to fit 100% automated agile development environment. Integrated with git and svn api.
• Total automation of Oracle patching process.
• Design/improve of backup strategy using 3Par snapshots.
• Physical Active Data Guard setup.
• Bi-directional Goldengate and Shareplex setup.
• Implementing streams downstream capture on 10.2 with complex ETL transformation logic to feed Netezza data source.
• Development of complex context search engine based on oracle text, for fraud detection.

Confidential, NJ

Senior Oracle DBA consultant.

• Oracle 10.2 RAC installation on Linux RHEL5 with ASM with ASMLib. EMC storage. Linux multipath. Using RAW devices for voting disk and OCR. Using Bonding and Jumbo frame for interconnect.
• Oracle 10.2 Data Guard setup. Primary and failover sites are RAC DB. Developing scripts to automate failover site startup based on RAC callout scripts functionality.
• DB/Hardware benchmarking using SwingBench. Testing of performance degradation caused by DB Flashback functionality. Testing of performance degradation caused by Maximum availability DG mode vs. Maximum performance DG mode.
• Tuning RMAN strategies to optimize backups for different environments. Automating arch log files utilization. Incremental backups. Backups of DB copy. Full usage of Flash Recovery Area functionality to increase ratio (disk backups)/(tape backups).
• Setup Streams on 2 RAC DB on Solaris 10/Oracle 10.2. Set up infrastructure for streams monitoring error processing and DB synch validation. Applying streams best practices. Pre-production testing and production support.
• Demonstrating example of usage streams as ETL tool.

Confidential, NJ

Senior Oracle DBA consultant.

• Setup Streams on 2 RAC DB on Solaris 10/Oracle 10.2. Set up infrastructure for streams monitoring error processing and DB synch validation. Applying streams best practices. Pre-production testing and production support.
• Developing strategy for application and DB migration from Oracle 9.2 to Oracle 10.2.
• Setup infrastructure to compare DB structures for distributed environment.
• Network hardware problems troubleshooting from OS/DB level.
• Managing classes for local IBM Oracle DBAs on subject of distributed environment.

Confidential, St. Louis, MO

Senior Oracle DBA consultant.

• Setup Streams on 2 RAC DB on Windows Server 2003/Oracle 10.2. Set up infrastructure for streams monitoring error processing and DB synch validation. Applying streams best practices. Pre-production testing and production support.
• LDAP infrastructure setup.
• Developing strategy for multi terabyte DB cloning with no downtime.

Confidential, Los Angeles CA

Senior Oracle DBA consultant.

• DB cross platform migration and version upgrade to from 9.2 to 10.2.0.4 using transportable tablespaces. Source OS: HP Tru64, Destination OS: Linux RHEL 4.
• DB cross platform migration and version upgrade to using transportable databases (new feature of Oracle 10.2) Source OS: HP-UX 64, Destination OS: Linux RHEL 4.
• Oracle Streams setup on 10.2 with demo of all functionality: predefined and custom DML and Error handlers, declarative and custom rule based transformation, conflict simulation, etc.

Confidential, Tampa, FL

Senior Oracle DBA consultant.

• Design and support of Application Based on AQ technology. Using AQ for implementation different dataflow structures: FIFO, FILO. ANYDATA, XML queues. Usage of specific AQ features: Asynchronous notification, Rule-based subscribers, Transformation, Multiple queue listening, Buffered queues, Commit time queues. Integration of AQ and Streams.
• General DBA level help in tuning new application (indexes, partitions, table structure and ref constraints structure)
• Tuning of RMAN backup strategies to use Oracle 10 functionality optimally for the environment.

Confidential

Senior Oracle DBA.

• Oracle 8-9i-10g administration on Linux, Solaris and Windows platforms. DBA maintenance (RMAN, expdp/impdp, exp/imp, DB clone, release upgrades, security policies implementation) and optimization (SQL level, Physical storage (I/O) level, memory distribution level, DB structure level).
• 24/7 system support.
• Design and implementation data replication environment (distribution and merge) using Oracle streams technology. Bi-directional, multi-master environment. Design logical level replication model (‘Star’ schema). Physical Implementation of the model: Oracle streams environment setup. Improvement of flexibility and resolving business requirements via creation DML/DDL handlers, rule-base transformation procedures.
• Oracle 10.2 Real Application Cluster (RAC) setup and administration on Linux using Automatic Storage Management (ASM) as Shared Storage. OCFS2 for clusterware. Migration from single instance DB to RAC DB. RAC optimization on application and DB levels. RMAN setup for RAC.
• Oracle Data Guard (Physical and Logical Standby): Design implementation and testing of Physical and Logical Data Guard system. RAC as primary database and RAC/Single instance as standby. Using Physical Standby for RMAN backups and Logical Standby for reporting.
• Oracle Grid Control enterprise setup, mass deployment and support.
• Complex SQL and PL/SQL dynamic coding. SQL optimization.
• Development and implementation dynamic security model for Oracle application.
• Development intelligent synchronization and validation process to validate (compare) group of Oracle databases on metadata and data level. Network traffic minimization using data hashing.
• Development of Distribution and Merge system using Oracle Data Pump technology. Automated moving of big tables over network from central DB to branch DBs. Network traffic optimization. Automatic network failover.
• Performing maintenance and development work to move application from 8i to 9.2i version of Oracle. New Oracle features implementation.
• Performing maintenance and development work to move application from 9.2i to 10.2g version of Oracle. New Oracle features implementation.
• Work with GIS (maps) databases.

Confidential

Oracle DBA. PL/SQL developer

• Oracle 8-9i administration. General database optimization and tuning. SQL optimization. Troubleshooting. I/O tuning. Undo/rollback management. Environment set-up. Network setup. Physical storage design/optimization. RMAN backup.
• (Oracle on Windows 2000, Linux, Solaris).
• UNIX (Linux Red Hat, Solaris), Shell scripting, BASH. Creating shell scripts for environment set-up and Oracle backups. OS administration from Oracle DBA perspective.
• OLTP system development (Financial). Creating/editing/tuning PL/SQL code. Triggers, stored procedures, packages, functions development. LOBs. Dynamic SQL. SQL optimization. Editing database schemas, correcting client/server interface, editing application code.
• Project development for scientific laboratory (server side of the project - PL/SQL). Creating flexible (dynamic) schema to store structure-changeable information for production reports.
• Creating/editing/tuning PL/SQL code. Triggers, stored procedures, packages, functions development.
• ETL using PL/SQL. Reading from external sources, Analyzing and Transformation data according to business rules. Staging tables. Creating PL/SQL stored procedures, packages. Dynamic SQL. SQL design. COM integration.