SUMMARY

• Expertise in Couchbase, Cassandra, Postgres, Oracle at architectural level and provide end - to-end life cycle support
• Architecteddataingestion for indexing and document level security in Couchbase and Oracle
• Design,Strategize and Administration of Architecture Implement Solution for Couchbase Community Edition 4.0-4.5 & Enterprise Edition 5 & 6 versions and sizing, dockerize configurations,data modeling, install and creation Analytic cluster (using CB EE 6.0)
• Provide guidelines for optimization to teh existing data designs, indexing, assessment of existing data documents and suggesting other document options. Evaluation of partner requirements to determine appropriate fit with business needs.
• Maintained around more TEMPthan 400 CB nodes around seven Princess Cruises, AWS-PROD and Analytics clusters.
• Used both XDCR and Sync-gateway (guest-oriented filter sync) for replications between AWS-PROD & Cruise-PROD as XDCR performance degrades with satellite-connectivity
• Designed to speed Concourse Applications with a Cache services usingRedis Cache
• Used Redis to session data and provided sub-millisecond to millisecond latency
• Designed and managed Neo4J to build to store, query, analyze using native graph storage for USC application
• Completed POC on AWS Neptune to compare benefits against Neo4j
• Created near accurate calculated spreadsheet for Cluster creation and future planning to have 100% resident ratio for identity and security management clusters
• Using Rest API created scripts for Dynatrace to have continuous monitoring on Clusters and intern halped in integrating to Pager-duty app
• Found xMem bug in XDCR for 5.0 versions
• Created Couchbase Document standard for developers and halped in creating N1QL query
• Trained Couchbase L1 Operation Teams to Prod supportusing scripts created from rest-api
• Created Couchbase standards, best practices and contributed to Ocean confluence (wiki)
• Designing of buckets, documents, loading teh documents, backups and recovery, sizing theCouchbase, Automated CLI scripts for Rebalance, Adding/Removal and Fail-over of nodes
• Performed and supported for CB upgrades, data restores from teh backups, failed over teh nodes for maintenance of failed nodes, documented all teh procedures and SOPs for all teh administrative tasks mentioned above.
• Collaborate across multiple groups to design and build document structures for domains
• Experience in MongoDB installation, patching, troubleshooting, performance, tracking/tuning, back - up and recovery in dynamic environments.
• Experience in managing teh life cycle of MongoDB including sizing, automation, monitoring and tuning.
• Experience on working with MongoDB Ops Manager, Cloud Manager and Atlas Manager
• Hands on experience in data processing automation scripts using python3
• Used Python3 to create Gold DM template from existing engagements, data migration and failed SAVE-IT reports
• Maintained aMulti-DatacenterCassandra cluster
• Used Azure Postgres Managed Service for Queuing for tasked job during Sync process between Jira and Couchbase
• Created data model for reporting (replicating of user engagement from Couchbase) using Azure Postgres Managed Service for user specified access for engagements
• Maintained aMulti-DatacenterCassandra cluster
• Experience in performance tuning a Cassandra cluster to optimize writes and reads
• Involved in teh process ofdata modelingCassandra Schema
• Installed and ConfiguredDataStax OpsCenterfor Cassandra Cluster maintenance and alerts.
• Benchmarked Cassandra cluster based on teh expected traffic for teh use case and optimized for low latency
• Built Cassandra Cluster on both thephysicalmachinesand onAWS
• Automated CassandraBuilds/installation/monitoringetc.
• Involved in requirements gathering andcapacityplanningfor multi data center (AWS + 6 PCLs)Cassandra cluster.
• Optimized theCassandracluster by making changes inCassandraconfiguration fileandLinux OSconfigurations.
• Setup, upgrade and maintain Cassandra DSE clusters.
• Building scalable distributeddatasolutions, a design Enterprise level compliant framework to rely upon different types ofDataneeds Analyze, Source and Parse thedatainto Cassandra.
• Strong experience in installation, set-up, implementation, customization, tuning, up-gradation & production support of Oracle database in a 24x7 environment.

TECHNICAL SKILLS

Operating System: UNIX, Mac OS, Windows XP/Vista/2000/NT/98/95.

Database: Couchbase 4.x,5.x,6.x, Postgres, Redis, Neo4j, Oracle 12, SQL-Server, DSE/Apache Cassandra

DB-Synchronization: XDCR, CB Sync-Gateway, Oracle Golden-gate, DSE Advance-replication

Design / Tools: TOAD 8.6, PL/SQL Developer, Business Objects, Visual Code, Atom

Utilities: CB-Backup-Manager, RMAN, 11gRAC, DS Ops-center.

Programming: Python 3.x, C#, ASP.NET, JavaScript, Unix scripting

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

DB Architect & DBA

Responsibilities:

• Design Strategize and Administration of Architecture Implement Solution for Couchbase EE 6.5.
• Involved in teh Couchbase solution architecture, administration, sizing, data modeling
• Trained Couchbase L3 Operation Teams to Prod supportusing scripts created from REST api
• Designing of buckets, documents, loading teh documents, backups and recovery, sizing theCouchbase, Automated CLI scripts for Rebalance, Adding/Removal and Fail-over of nodes
• Designed Multi-dimensional Scaling for Couchbase cluster including HA and DR with a RPO couple of seconds
• Performed data restores from teh backups, failed over teh nodes for maintenance of failed nodes, documented all teh procedures and SOPs for all teh administrative tasks mentioned above.
• Designed to speed Concourse Applications with a Cache services usingRedis Cache
• Used Redis to session data and provided sub-millisecond to millisecond latency
• Designed and managed Neo4J to build to store, query, analyze using native graph storage for USC application
• Participate in new system builds
• Create databases, schemas & deploy standard jobs & monitoring
• Ensure system support abilities prior to production utilization
• Adhere to documented change & incident management policies
• Use established Shared Services support processes & tools to document & track problem resolution
• Develop technical documentation for use in future incident resolution
• Develop requirement recommendations from a project’s inception to its conclusion for a particular Business and IT subject matter area (i.e., simple to complex systems)
• Hands on experience in data processing automation using python3
• Used Python3 to create Gold DM template from existing engagements, data migration and failed SAVE-IT reports
• Maintained aMulti-DatacenterCassandra cluster
• Installed and ConfiguredDataStax OpsCenterfor Cassandra Cluster maintenance and alerts.
• Benchmarked Cassandra cluster based on teh expected traffic for teh use case and optimized for low latency
• Used Azure Postgres Managed Service for Queuing for tasked job during Sync process between Jira and Couchbase
• Created data model for reporting (replicating of user engagement from Couchbase) using Azure Postgres Managed Service for user specified access for engagements
• Involved in teh process of Conceptual andPhysical Data Modelingtechniques.

Confidential, Doral, FL

Lead Architect & Engineer & DBA

Responsibilities:

• Design,Strategize and Administration of Architecture Implement Solution for Couchbase CE (4.5) & EE (5.5 & 6.0).
• Involved in teh Couchbase solution architecture, administration, sizing, dockerize configurations,data modeling, install and creation Analytic cluster (using CB EE 6.0)
• Key person for teh bi-directional data replication of Couchbase Sync-Gateway implementation between shore (AWS) and ships Princess Cruise
• Trained Couchbase L1 Operation Teams to Prod supportusing scripts created from rest-api
• Created Couchbase standards, best practices and contributed to Ocean confluence (wiki)
• Collaborate across multiple groups to design and build document structures for domains
• Provide guidelines for optimization to teh existing data designs, indexing, assessment of existing data documents and suggesting other document options. Evaluation of partner requirements to determine appropriate fit with business needs.
• Involved in creation of Couch-base Index manager for all partners in Ocean
• AdministeringCouchbaseClusters, Querying JSON doc's using N1QL, Utilizing Command line utilities for day-to-day operations andCouchbaseWeb Console for monitoring clustering Operations and Cross Datacenter Replication.
• Strong experience building highly available services with AWS, halped clients migrate their key data systems from on-prem to public cloud (AWS).
• Design and Develop teh code to parse XML & JSONData objectsto Couchbase
• Designing of buckets, documents, loading teh documents, backups and recovery, sizing theCouchbase, Automated CLI scripts for Rebalance, Adding/Removal and Fail-over of nodes
• Performed data restores from teh backups, failed over teh nodes for maintenance of failed nodes, documented all teh procedures and SOPs for all teh administrative tasks mentioned above.
• Experience in MongoDB installation, patching, troubleshooting, performance, tracking/tuning, back - up and recovery in dynamic environments.
• Experience in managing life cycle of MongoDB including sizing, automation, monitoring and tuning.
• Experience on working with MongoDB Ops Manager, Cloud Manager and Atlas Manager
• Maintained aMulti-DatacenterCassandra cluster
• Experience in performance tuning a Cassandra cluster to optimize writes and reads
• Involved in teh process ofdata modelingCassandra Schema
• Installed and ConfiguredDataStax OpsCenterfor Cassandra Cluster maintenance and alerts.
• Benchmarked Cassandra cluster based on teh expected traffic for teh use case and optimized for low latency
• Built Cassandra Cluster on both thephysicalmachinesand onAWS
• Automated CassandraBuilds/installation/monitoringetc.
• Involved in requirements gathering andcapacityplanningfor multi data center (AWS + 6 PCLs)Cassandra cluster.
• Administered and maintainedmulti rackCassandraclusterusingOpsCenterbased on teh use case implemented consistency level for reads and writes.
• Automated and deployedCassandraenvironments usingChef recipes.
• Optimized theCassandracluster by making changes inCassandraconfiguration fileandLinux OSconfigurations.
• Setup, upgrade and maintain Cassandra DSE clusters.
• Building scalable distributed data solutions, a design Enterprise level compliant framework to rely upon different types ofDataneeds Analyze, Source and Parse thedatainto Cassandra.
• Database Architecture and Administration activities which involved Data Modeling, Configuration, Administration, Monitoring, Security Management, Performance Tuning, Replication, Backup/Restore and Troubleshooting of issues.
• Involved in teh process of Conceptual andPhysical Data Modelingtechniques.
• Analyzed teh performance of Cassandra cluster using Nodetool TP stats and CFstats for thread analysis and latency analysis.
• Tune databases and provide design changes and support stress tests to proactively fix problems.
• Designed mission critical large upgrade of a multi-TB OLTP database
• Designed and Implemented DR in Oracle using DG between two AWS regions
• Designed and Architect xiSync using GG in Oracle between Shore and Cruise’s synchronization
• Oracle Enterprise and implementing Oracle partitioning in teh rollout. Benchmarked several architectural options to position teh Client with teh best solution going forward to minimize downtime during teh database and application
• Upgrade by being a driving force in teh tuning of all aspects of a very large SQL / PL/SQL based migration code set and accompanying infrastructure. Used Transportable Tablespaces / TTS and then Golden Gate 12 to migrate from AIX to Linux then upgraded Oracle and upgraded teh application version.

Confidential

Database Architect

Responsibilities:

• Performed new software and hardware installations and upgrades.
• Provided database design and implementation.
• Highly skilled working with Oracle 11G, RAC and RMAN and DR (disaster recovery).
• Provide and implement performance tuning recommendations of all components in teh Exadata database machine.
• Lead and Managed Data Center Move TEMPeffectively and efficiently.
• Gained noledge and experience over teh Complete Infrastructure of teh Organization with teh successful move of Data Center.
• Recover/Clone teh database from ASM to ASM, ASM to File System, File System to ASM using RMAN duplicate command.
• Developed aConceptual modelusing Erwin based on requirements analysis
• Experience in replication using golden gate, materialized views.
• Replication and Extracting data and applying on production using Golden Gate.
• Implemented, documented and support builds of new clusters to use Oracle 11g RAC on Linux. Including installing cluster ware, ASM (and shared disks) and creating new databases.
• Implemented Oracle database in a virtualized UNIX platform.
• Used Model Mart of Erwin for TEMPeffective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developing hot, cold and Logical Backup scripts to automate teh backup procedures.
• Performing daily/weekly monitoring of databases dat includes space usage, fragmentation, Database performance, alert/system logs, and tables/indexes growth.
• Evaluating teh future growth of teh database and estimating disk storage capacity requirements accordingly.
• Maintained, monitored and performance tuned teh database using Oracle Enterprise Manager 11g Grid control Management.
• Migrating data from Development to Production environment using Import/Export utility and SQL Loader.
• Established and maintained sound backup and recovery policies and procedures.
• Restored database services for disaster recovery.
• Recovered teh database in teh event of a hardware or software failure.
• Installing, configuring, and upgrading database server software and related products installation.
• Strong experience in UNIX shell awk scripting.
• Experience with monitoring & managing Oracle 11g/12c databases with TOAD.
• Performed database troubleshooting.
• Performed ongoing database security management
• Performed ongoing configuration management
• Worked as part of a team and providing 24x7 support when required

Environment: Oracle 11g, Oracle X3/X4 full rack Exadata machine IBM AIX 5.3, 7.0, UNIX, PL/SQL, SQL Server, Sun Solaris 5.8, 5.9 & 5.10. RedHat Linux, Golden Gate.

Confidential

Lead Database Administrator

Responsibilities:

• Monitored and supported Production, Test and Development environments
• Support code migrations, DDL changes, and data changes
• Develop, test, and support backup and recovery processes
• Refresh test and development environments as needed
• Strong troubleshooting skills during startup of a warm standby, multi-component SAP landscape.
• Apply and test Oracle patches and support upgrades of Oracle software design, installation, configuration, administration, patching, upgrading and troubleshooting with Oracle Enterprise Database and SAP HANA.
• Provide 24/7 production support on a rotating shift and assist with weekend implementations as needed
• Contributed to data management planning, development, implementation and maintenance
• Proactively monitored and addressed performance issues, including data load and data access performance
• Define, implement, and enforce database design standards
• Assist and support development team with development best practices
• Provided consultation in teh design, implementation, and audit of new and complex data solutions
• Hot cloning databases and migrating databases between platforms
• Knowledge of installation, configuration and sustainment activities of SAP Solution Manager 7.1 or higher with a specific focus on teh use of Maintenance Optimizer for patching and upgrades
• Communicate existing and new features of Oracle to improve existing and new production development
• Worked as part of a team and providing 24x7 support when required

Environment: Oracle 10g/11g, IBM AIX 5.3, 7.0, UNIX, PL/SQL, SQL Server, Sun Solaris 5.8, 5.9 & 5.10. RedHat Linux.

Confidential

Oracle Database Administrator

Responsibilities:

• Installing and configuring Oracle 10g and 11g databases on Sun and Windows NT.
• Establishing and maintaining multiple Oracle database environments for test, development, UAT, and production run.
• Implemented RMAN on UNIX, LINUX environments
• User and security management, database optimization, determining common performance problems.
• Monitoring, configuring servers and efficient in handling front-end activities.
• Involved in teh preparation of technical and business documents.
• Participated in teh Requirement analysis, analyzed project requirements/specifications and designed various software modules using UML diagrams.
• Proficient in programming using PL/SQL.
• Developed several Oracle PL/SQL procedures involving PL/SQL tables, UTL File and database triggers.
• Used conditional formula fields, sub reports, specified groups, built in functions using crystal reports.
• Startup and Shutdown
• Executing ftp, telnet for remote access between UNIX systems.
• Did export, import, parallel load, queries used by partition as a development DBA
• Mastered teh ability to analyze and solve difficult problems under hard deadlines.
• Worked in an offshore team and learnt offshore-onsite communication and coordination.

Environment: Oracle 10g, 11g, PL/SQL, UNIX, SQL*Loader.

Confidential

Systems Admin

Responsibilities:

• Establishing and administering multiple environments for test and staging/QA instances and production.
• Error handling from databases to applications and rectification.
• Planning and administration of backups and recovery strategies.
• Monitoring and handling Concurrent Managers related issues. Monitoring DB processes activities at OS level using top, glance etc.
• Creation of menus, request groups and responsibilities.
• Compilation of custom forms and libraries on UNIX, LINUX environments
• Support functional and development teams for customization or development requirements.
• Assigning teh Program to Concurrent Manager (scheduling).

Environment: Sun Solaris 5.10, Linux, Windows NT.