SUMMARY:

• 17+ years of IT experience in analysis and design, 5+ years as an oracle instructor. Taught oracle 8i and 9i & 10g certification programs.
• 15+ years’ experience as an Oracle DBA using Oracle 6.x, 7.x, 8i.x,9i.x, 10g.x and 11g.x and 12c.x
• Over 3 years’ experience implementing Apache Hadoop, Big data administration and big data systems deployment
• NoSQL database expertise ( MongoDB, Oracle NoSQL, Cassandra, HBASE )
• Good experience designing, administering and troubleshooting MongoDB clusters in replica sets and sharded environments on - premise and on amazon cloud
• Experience in installing and managing Cloudera Hadoop clusters and Hadoop file system (HDFS), using Cloudera Manager
• Experience in Big Data Hadoop echo system including Map Reduce, Map reduce 2, YARN, flume, Sqoop, Hive, Apache Spark, Scala
• Extensive experience writing scripts in SQL, PL/SQL packages, procedures, functions and triggers in multiple Oracle environments.
• Extensive experience scripting in SED, AWK, GREP and KORN shell
• Proficiency in oracle database installation, migration, upgrade, patching, administration and performance tuning proficiency in Linux, Solaris, HP, AIX and windows
• Python programming experience
• Excellent written and verbal communications skills plus strong analytical, problem solving and troubleshooting skills
• Good understanding of oracle big data( Oracle NoSQL, Big data appliance )
• Full life-cycle software development expertise in OLTP and data warehouse environments with 24*7 support
• Solid experience managing multiple databases and projects, in multi-terabytes environments, overseeing and managing multiple personnel
• Extensive knowledge of Real Application Cluster configuration, installation, administration and performance tuning in multiple OS environment
• Good sysadmin experience on multiple flavours of Unix
• Good DevOps experience utilizing open source technologies such as GitHub, Docker, Jenkins, Chef and Puppet
• Experience with continuous development and deployment to Confidential (AWS)
• Analytical, reporting and data visualization experience using MapR, Talend and Tableau
• Exadata (x-2 - x-5) installation, administration and performance tuning experience

TECHNICAL SKILLS:

Operating Systems: HP-UX, SUN SOLARIS, AIX, RHEL, Windows 95/98/ME/NT/2000/XP/Vista/7/8/10, UBUNTU, CentOS

RDBMS: Oracle 7x,8i,9i,10g,11g,12c MS SQL server 7.0/2000, DB2, MySQL, Amazon Redshift

Languages: SQL, PL/SQL, C, C++, Java, Unix shell scripting, PERL, COBOL, assembly language, HTML, XML, PHP

Tools: &Utilities TOAD, Crystal Report Generator, OEM grid control, GoldenGate, Real Application Testing (RAT), Eclipse, VirtualBox, VNC, SQL developer

Network& Storage: EMC timefinder, Veritas NetBackup, Veritas volume manager, Veritas cluster server IBM TSM, HP data protector, HP service guard, IBM HACMP, SAN, ASM, Oracle ZFS storage appliance, RAID technology

Webservers: WebLogic, Tomcat, IIS WebSphere, WebMethods

NoSql DB: MongoDB, Cassandra, Oracle NoSQL database, HBASE, DynamoDB

Engineered systems: Exadata v2, x2-3,x3-3,x2-8,x3-8,x4-2,x5-2,ZFS storage appliance, Big data appliance, Database appliance, Exalogic, Exalytics

Big Data: Hadoop Administration, Cloudera, Flume, Sqoop, Apache Spark, Apache Scala, Solr, Mapreduce, Hive, Pig Latin, Mahout, Impala, Zookeeper, Oozie, storm

CLOUD: Confidential, AZURE, Google, Oracle Cloud

DevOps: GitHub, Jenkins, Docker, Chef, Puppet, Ansible, Saltstack, Ngnix, SVN, PXE, Kickstart

Confidential: Ethereum, Hyperledger, Multi-chain, Bitcoin, Heterogenous chains, Cryptocurrency, IPFS, WASM

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Enterprise Solutions Architect

Responsibilities:

• Successfully designed, configured and deployed high availability using geographical multi-sharded replica sets across multiple data centres on physical, virtual nodes and on AWS.
• Extensive experience in MonogDB database optimization, upgrades, troubleshooting and overall monitoring using MMS
• Responsible for MongoDB cluster maintenance, node add/remove, job scheduling, cluster monitoring, capacity planning and troubleshooting, manage and review backup and logfiles
• Successfully utilized MongoDB third party mtools such as Atlas, compass, udacity, OpManager and mongo-built in binaries to monitor and analyse logfiles and performance of MongoDB
• Full life cycle experience in highly secure, extremely large-scale Hadoop deployments of very high volumes of critical data with authentication using Kerberos and apache sentry
• Responsible for architecting scalable distributed big data solutions using apache HDFS, HBase, Mapreduce(MRv1) and YARN (MRv2)
• Responsible for multi-node Hadoop cluster maintenance, node add/remove, job scheduling, cluster monitoring, capacity planning and troubleshooting, manage and review backup and logfiles
• Successfully designed and deployed Simple to complex Mapreduce, data capture and job scheduling tasks using Hbase, hive, pig, zookeeper, Oozie, flume and sqoop
• Experience in using Sequence files, RCFile, AVRO and SerDe file formats
• Designed and implemented a data analytics engine based on Scala/spark to provide trend, regression analysis and machine learning predictions as web services for survey data
• Extensive experienced working with Spark tools like RDD transformations, Spark MLlib and spark SQL
• Proficient in big data ingestion tools like flume, kafka, spark streaming and Sqoop for streaming and batch data ingestion

Confidential

Responsibilities:

• Hands-on experience trading cryptocurrencies and digital assets through emerging marketplace technologies
• In-depth knowledge of Smart contracts and smart contract service platforms
• Implemented a private Ethereum Confidential, bitcoin and Multi-chain on AWS cloud and created new cryptocurrency
• Good knowledge and use case analysis of DLT\ Confidential (Hyperledger, Bitcoin, Multi-chain, Heterogeneous Chain - polkadot)
• Theoretical and hands-on knowledge of Hyperledger Famework (Iroha, Fabric, sawtooth, indy, burrow) and tools (composer, explorer, cello)
• POC using external data sources (Oracles such as MongoDB and other external data sources) to feed smart contracts
• Technical advisor to multiple companies launching ICOs
• Knowledge of other technologies such as webassembly, gRPC, IPFS, ECC, etc
• Smart contracts and cryptography implementation using Python as the primary language
• Project management and organizational skills with conducting workshops, requirements assessment, migration plan, etc
• Active participant in Fintech and Confidential technologies innovation and startup ecosystem
• Active participant in the local Confidential meetups and groups locally and globally

Confidential

Responsibilities:

• Responsible for using big data appliance to process large quantities of data in batch/parallel and filtering, transforming and sorting it before loading into Exadata enterprise data warehouse
• Extensive experience using big data lite as test bed for testing, developing and benchmarking big data appliance components and new features
• Good Experience using oracle connectors to import/export data between HDFS, External File and hive metastore to oracle Exadata database
• Good experience creating and deploying oracle NoSQL DB, with hands-on experience using Big data SQL and big data discovery
• Hands-on experience using big data SQL for Seamlessly querying data across Oracle Database, Hadoop, and NoSQL sources
• Good experience configuring Exadata machines and managing switches, InfiniBand, Storage cells, flash & grid disks and ZFS storage appliance
• Hands-on experience with Exadata troubleshooting, performance tuning, patching, upgrading and setting up health check scripts for several clients
• Successfully migrated several customers to Exadata using RMAN, datapump and goldengate and successfully optimized customer's database systems

Confidential

Responsibilities:

• Built and managed a large deployment of Linux instances systems with Chef Automation and Wrote recipes, tools, shell scripts, and monitoring checks
• Designed and implemented fully automated server build, management, monitoring and deployment solutions spanning multiple platforms, tools and technologies including Jenkins, GitHub, Chef, Puppet, and Amazon EC2 .

SysAdmin

Responsibilities:

• Good experience as Unix sysadmin which includes setting up accounts, access, debugging and troubleshooting issues on multiple flavours of Unix
• Responsible for maintaining Linux platform build standards, including all aspects of OS configuration and deployment
• Solid experience using bash scripting to automate complex tasks and provide tools for systems management
• Architecting, deploying, and maintaining single instance, RAC and Exadata database environment with a strong emphasis on reliability, scalability, security and performance
• Implementing & supporting enterprise-level oracle solutions for both corporate & client remote data centres
• Successfully upgraded and migrated several oracle databases using a variety of migration and upgrade tools and methodology (DMA, DMU, scripts, manual)
• Handled day-to-day database administration, capacity planning, troubleshooting, debugging and performance tuning duties
• Solid goldengate Installation, configuration and administration expertise, architecting and deploying bi-directional, Unidirectional and zero-downtime migration replication solutions on single instances, RAC and Exadata machines
• Designed and implemented active-active/active-passive goldengate processes that encompass transaction filtering, conflict detection & resolution, performance tuning and troubleshooting
• Successfully designed and implemented several disaster recovery strategies using oracle dataguard and broker
• Successfully designed and implemented several backup and recovery strategies using RMAN
• Successfully migrated client to PaaS to develop and deploy applications, to eliminate cost and complexity of managing customer's underlying application platforms
• Responsible for leading business-focused, enterprise-level, architecture initiatives engaged with business/IT customer stakeholders, partners, and Oracle sales and consulting teams
• Good experience with designing, architecting and implementing dbaas solutions (on-premise, cloud, private, public) for clients with attention to security and optimization
• Excellent communication and leadership skillset and ability to handle multiple projects and interact with different levels of staff

Confidential

Responsibilities:

• Experience in configuring and managing AWS EC2, S3, VPC, RDS, CloudWatch, CloudFormation, CloudTrail, IAM, Lambda, loadbalancer, Security and much more
• Experience in deploying scalable Hadoop cluster on AWS using S3, EBS and EFS as underlying file system for Hadoop
• Perform expert-level AWS development and design, including logic and I/O design and AWS analysis and systems engineering
• Designing, managing and migrating Databases (oracle, MongoDB, etc) to Amazon cloud
• Act as SME and serve as primary liaison and provide guidance and work leadership to clients and other engineers and developers

Confidential

Responsibilities:

• IoT Security/ Penetration analysis and certification for product prototypes using iControl, ZigBee & Z-Wave protocols
• Product conceptualization, design and prototype delivery for Arduino, Intel Edison and raspberry Pi based electronics
• Developed POC and design strategies for wearable technologies such as fitness trackers, wearable cameras, smart watches, heart rate monitors, and GPS tracking devices

Environment: Hadoop, MapReduce, Hive, HDFS, PIG, Sqoop, Cassandra, Spark, MapR, Oozie, Flume, HBase, Nagios, Ganglia, MongoDB, Hue, Hortonworks, ZooKeeper, Impala, HDP 2.1/2.2/2.3, Oracle, NoSQL and Unix/Linux, CDH4/5, Exadata (x2-x5), Big data appliance (x5), Big data lite (4.x),HBase, Oracle, R, impala, Linux, Oracle Nosql, Oracle goldengate, Flume, Cloudera distributed hadoop, MongoDB, Cassandra, Apache spark/Scala/kafka, Hadoop, Cloudera manager

Confidential, Atlanta, GA

Lead Oracle Exadata, GG Architect/MongoDB Admin/Big data consultant

Responsibilities:

• Deployed and managed Oracle big data appliance in a test environment, using Cloudera enterprise Hadoop distribution
• Installed and managed Cloudera Hadoop clusters and Hadoop file system (HDFS)
• Worked on Big Data Hadoop echo systems including Map Reduce, Map reduce2, YARN, flume, Sqoop, Hive, Apache Scala and Spark
• Developed, deployed and managed several MongoDB clusters whilst implementing robustness and scalability via Sharding and replication, including automating tasks with own scripts and open-source tools for performance tuning and system monitoring
• Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design
• Worked on other NoSQL databases such as Cassandra and Oracle NoSQL, Hbase
• Successfully installed, validated and deployed Exadata (x2-2, x3-2, x4-2 and x5-2), eighth, quarter, half and full rack for various clients
• Configured and activated Exadata ASR and associated assets for hardware fault monitoring, and alerting. Configured oracle 12c OEM for comprehensive Exadata administration, performance tuning and monitoring
• Successfully migrated several clients (Siebel, SAP, proprietary) from both single and RAC instance onto Exadata machines using several migration methodologies to meet client’s need
• Successfully maximized database performance on Exadata using smart scan technologies such as storage index, Hybrid columnar compression and predicate and column filtering
• Designed and implemented database backup and recovery strategy on several multi-terabyte Exadata systems over ZFS storage appliance subsystems for various customers
• Solid experience with Installation, configuration and administration of Goldengate for bi-directional, Unidirectional and zero-downtime migration replication on single instances, RAC and Exadata machines
• Designed and implemented extracts and replicats for loading, refreshing, and keeping oracle databases in sync, near real-time via incremental transaction and DDL replication using Goldengate versions 10g, 11g and 12c
• Designed and implemented active-active/active-passive Goldengate processes that encompass transaction filtering, conflict detection & resolution, performance tuning and troubleshooting
• Successfully configured, installed and managed several multi-terabyte databases from oracle 8i through 12c in both single instance and RAC cluster environments
• Successfully upgraded and migrated several customers to 11g and 12c using a variety of migration and upgrade tools and methodology (DMA, DMU, scripts, manual)
• Implemented solid and effective DR strategies for multiple clients using Dataguard and implemented effective backup and recovery strategies using RMAN
• Resolved several performance tuning issues and successfully used troubleshooting and problem solving skills to improve database performance in single instance, RAC and Exadata environments

Environment: Oracle Linux, Oracle RAC, 11gr2, 12c, x2-2,x3-2,x4-2 and x5-2 Exadata database Machine, Oracle Big data appliance,, Oracle golden gate (11g.x,12c.x), Oracle VM for SPARC, MongoDB, Cloudera, Hadoop

Confidential, Atlanta, GA

Lead oracle DBA/ RAC, Golden Gate Architect

Responsibilities:

• Successfully compressed over 30+ v490's, v880's,v440's v240's into Sun SPARC 3*T4-2 (Prod and DR) and 2*T4-1 (UAT) data center
• Saved Confidential 500k over 12month period, with savings in cooling, power, weight and space of over 83%
• Successfully designed and installed oracle 11gR2 Clusterware and ASM on top of oracle 10g RAC database
• Successfully managed multiple oracle RAC databases on oracle VM server for SPARC LDOMS and zones
• Successfully managed both single instance zones and RAC LDOMS from development, UAT, go-live, to production support
• Resolved RAC performance issues on oracle VM server for SPARC LDOMS
• Successfully implemented and utilized Oracle real applications testing (RAT) for workload management and analysing and optimizing SQL performance
• Implemented, setup and utilized oracle cluster health monitor for diagnosis and fixing cluster issues
• Utilized RAC check utility to also diagnose CRS, ASM and RAC database setup issues
• Successfully designed, implemented and managed oracle physical and logical dataguard solutions
• Implemented RMAN strategy for all backups, refreshes and restores
• Designed, installed and configured oracle golden gate on both Unix and windows platform
• Designed, implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle goldengate product suite
• Tuned extract and replicate lags and implemented golden gate monitoring scripts
• Wrote several PL/SQL procedures and SQL scripts, used by golden gate processes for data filtering, computation and transformation
• Wrote conflict resolution scripts for bi-directional support to maintain data integrity in high performance, high volume databases
• Implemented DDL replication, resolved performance tuning issues on extract and replicate processes

Environment: Solaris 10 & 11, Oracle RAC 10g, 11gr2, Solaris Zones, LDOMS, Windows 8, Oracle data guard, Oracle golden gate 11x, Oracle VM for SPARC

Confidential, Atlanta, GA

Lead oracle DBA/Architect

Responsibilities:

• Managed multiple databases on both RAC and single instance on Linux
• Successfully migrated several QA/test, staging and multi-tera byte production 9i/10g HP/Solaris DB to oracle 11gr2 DB using RMAN TTS on Linux and documented migration procedures
• Managed and updated several automated Unix scripts used for the migration project to expedite the migration process with minimal manual intervention
• Resolved numerous performance issues like top wait events, sub-optimal execution plans, outdated statistics, data fragmentation, latch contention, CPU constraints, physical & logical I/O, disk usage, query optimization, hard/soft parsing by application tuning, disk I/O and memory tuning.
• Performed troubleshooting duties on Oracle production databases and determined RCA (Root Cause Analysis) and resolved known issues
• Developed fully optimized SQL and PL/SQL scripts that successfully assisted with timely offloading of reporting data and analytical data

Environment: Linux, HP, Windows XP, 9i, 10g, 11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, streams

Confidential, Atlanta, GA

Lead (RAC) oracle DBA/Architect

Responsibilities:

• Successfully Installed and implemented multiple oracle 11gr2 RAC databases on customer client sites
• Diagnosed and resolved performance and workload issues using Oracle real application testing tool and documented best practise procedures.
• Managed Oracle active data guard & standby database and provided critical solution with strategic disaster recovery plans with different recovery procedures and methods
• Designed implemented, and supported both unidirectional and bidirectional replication leveraging multiple features within the Oracle goldengate product suite
• Identified and resolved causes of slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components
• Utilized Oracle goldengate troubleshooting tools such as knowledge documents, documentation, SHOWSYNTAX parameter, and the Logdump utility

Environment: Linux, Windows XP, 10g, 11gr2, Dbconsole, Grid control, Dataguard, VERITAS cluster, Golden Gate 11.x.

Confidential, St Paul, MN

Lead (RAC) oracle DBA/Architect

Responsibilities:

• Developed and deployed SQL, PL/SQL stored procedures, functions and triggers for several in-house projects
• Created and maintained physical, logical and snapshot standby databases for disaster recovery, near real-time reporting, load-testing and production database backup
• Utilized Oracle automatic storage management (ASM), Oracle managed files (OMF) and recovery manager (RMAN) to improve I/O performance, reduce administration overhead and provide a comprehensive backup and recovery strategy.
• Successfully implemented and utilized Oracle real applications testing (RAT) for workload management and analysing and optimizing SQL performance
• Proven Knowledge of golden gate architecture and database replication using golden gate technology
• Diagnosed and resolved extract, replicate and network issues during goldengate replication and developed monitoring scripts to monitor goldengate
• Unix shell scripting, SED, AWK scripting for automating several DBA tasks
• Resolved smart scan performance problems, like passthrough mode and selective fallback to block IO - with Exadata Snapper
• Effectively utilized Exadata Hybrid columnar compression on historical data which led to realizing 6-7 times SQL performance gains

Environment: Linux, Windows XP, 10g, 11gr2, Dbconsole, Grid control, dataguard, VERITAS cluster, Exadata v2, goldengate 10

Confidential, Memphis, TN

Advanced Customer Service Engineer

Responsibilities:

• Diagnosed and resolved oracle RAC performance issues using SQLT and AWR
• Upgraded 10g RAC database to 11gr2 RAC databases
• Used OEM, CVU &SRVCTL, and CRSCTL commands extensively to maintain the RAC environment like add/remove node, start/stop clusterware app services on node and add TAF services.
• Diagnosed and resolved client RAC related data corruption, ASM and clusterware corruption issues and resolved cache fusion related contention issues
• Supported multi-tera byte oracle 10g, 11g RAC databases and data guard DR solutions on multiple platforms
• Successfully installed and deployed oracle golden gate in unidirectional and bidirectional modes on Linux platform
• Developed and implemented administrative scripts for supporting, monitoring and tuning golden gate replication and monitoring replication lags
• Worked on various conflict detection and resolution scenarios for different types of DML, including quantitative resolution and transactional resolution
• Resolved all ongoing support and problem determination of data replication issues, including identifying and resolving data inconsistencies and data replication lag
• Supported and deployed goldengate in a heterogeneous replication environment
• Served as SME (subject matter expert) and project lead in a variety of areas including Oracle streams, database security and auditing, backup and recovery, performance tuning and UNIX shell scripting
• Created and published standards and operational procedures to provide continuity of operations between geographically distributed DBA groups.

Environment: AIX, HP, Linux, Oracle 10g, 11gr1, 11gr2, RMAN, Grid control, Dataguard, GoldenGate