We provide IT Staff Augmentation Services!

Couchbase/mongo Dba Resume

Houston, TX

SUMMARY

  • Experienced IT Professional with 8+years Database Administration experience with Couchbase, MongoDB and Oracle database technologies and 4 years hands on with couchbase and MongoDB Administration comprising of Oracle 12c &11g Installation and configuration on Linux & Windows Platform.
  • Experienced with building huge clusters on premise and on AWS cloud, hands with XDCR (cross data center migration.
  • 24 x 7 Production support - on-site & remotely working on couchbase MongoDB and AWS.
  • Couchbase and MongoDB Database: Installation & Configuration couchbase 6.0.4 with Installation, configuring and monitoring couchbase cluster, 90 nodes 3 DC’s.
  • Oracle Database: Installation & Configuration: Oracle 12c/11g Installation for RAC and single node Installation. Patches installation & DB upgrade, Migration 11g to 12c.
  • Backup & Restore: Implemented robust hot backup strategies using Oracle’s RMAN technology, Logical backup using ‘export’ and recovered using ‘import’ features for object level recovery. Flashback of databases using (guaranteed) restore point. Backup & restore using datapump.
  • Disaster Recovery & High Availability: Implemented DR Solution using Oracle ‘Data Guard’ did planned switch-over while setting up DR solution for Production boxes and Maintenance.
  • Performance Tuning: Detecting and diagnosing production system performance problem by Analyzing Oracle trace file, analyzing SQL statements, querying Oracle dynamic data dictionary views; pin plans, SQL statement tuning for OLTP & data warehouse using TKPROF, SQL Trace and EXPLAIN PLAN tools. Generating & Analyzing AWR & ADDM reports. Enhance performance by Table partitioning for large tables.

TECHNICAL SKILLS

Platforms: Linux (Red Hart Enterprise Linux, Oracle Enterprise Linux)Sun Solaris 9, 10, AIX 5.x, Windows XP, Windows 7, HP-UX

Programming Languages: SQL, PL/SQL, Shell Scripting, C, N1QL, PromQL

Databases: Oracle 11g/10g/9i, 12c, Couchbase 2.x.x to 6.0.1, MongoDB 2.x to 4.2.x

Tools: Golden Gate, EXP/IMP, EXPDP/IMPDP(DATA PUMP), RMAN, SQL Loader, SQL Developer, Toad, OEM, DBCA, DBUA, CBbackup, CBrestore, Mongo Dump and Mongo Restore

Tuning Tools: TKPROF, Statspack, Sql Trace, Explain Plan, AWR, ADDM, ASH, SQL Tuning Advisors

PROFESSIONAL EXPERIENCE

Confidential, Houston, Tx

Couchbase/Mongo DBA

Responsibilities:

  • Spinning nosql (couchbase database) clusters
  • Providing security, creating access to users
  • Crating and configuring couchbase clusters on cloud using amazon cloud formation scripts
  • Installing SSL certificates, providing secure access from application sdk
  • Performed live cross data center migration between couchbase clusters in different data centers
  • Worked on setting up couchbase DR2.0 project in two different data centers
  • Creating and configuration of primary secondary secondary (PSS)architecture MongoDB replica set
  • Worked on setting disaster recovery environment for MongoDB replica sets
  • Knowledge on Amazon Document DB and Dynamo DB
  • Granted users access on Amazon Document DB and helped application users to connect document DB from third party tools like Mongo compass, Robo3t and Studio 3t.
  • Install, monitor and upgrade NoSQL (Couchbase and MongoDB)Databases on all environments (DEV, QA, STAGE and PROD).
  • Expertise in setting upMongoDBclusters inAzure and AWScloud Environments.
  • Configuring SSL certificates(Security) toMongo and couchbase Clusters. Creating Users and User defined roles inMongoDatabase.
  • Working and fixing issues related to DBA. Working on MongoDB Ops Manager configuration.
  • Integrate Active Directory to Ops Manager.
  • Installation ofNoSQL MongoDBon physical machines, Virtual machines as well asAWS
  • Setting up MongoDB clusters for Automation, monitoring, backup & restore through Ops Manager.
  • Providing knowledge transfer to other teams onMongoDBtechnology & tools. Help other teams in troubleshooting and fixingMongoDBissues.
  • Couchbase cluster Tuning and Configuration. Operationalization and Runbook Creation. Review & Provide Subject Matter Expertise during the course of the project kickoff.
  • Enabled SSL, PEMKeyFile, CAFile and coordinated withDevopsteam and Linux Admins regards to Root Certificate.
  • Assist with N1QL tuning.
  • Manual Backups and Restore are done using Mongodump, mongoexport and mongoimport depending on the needs.
  • Assist with Performance Testing and Optimization
  • Assist with incident resolution by working withCouchbaseengineering Support team Assist app teams during stress testing application withCouchbase.
  • Assist with designCouchbasehigh availability and failover capabilities, to meet application requirement.
  • Test and provide feedback on new version Features and functionalities Assist with design of XDCR and High availability setup to meet application requirements.
  • Hands on experience working with NoSQL database systems.
  • Designed and developed NoSQL solutions for all users.
  • Managed and Administered NoSQL database, Mongo and Couchbase databases.
  • Suggested latest upgrades and technologies for NoSQL database
  • Performed database migration from on premise NoSQL to AWS Cloud

Confidential, Newyork

Database Administrator

Responsibilities:

  • Spinning Couchbase clusters with data and index nodes in QA and DEV environments followed with Production
  • Responsible for upgrading Couchbase servers to latest versions
  • Determined Use Case would bring various data from different applications and create a single view of the data for quick access.
  • Created data model and imported data using mongo import.
  • Granted users authorization and authentication. Backed up databases using Mongodb backup facility in OPS manager.
  • Developed, deployed and managed several MongoDB clusters whilst implementing robustness and scalability via replication, utilize open-source tools for performance tuning and system monitoring.
  • Worked on MongoDB database concepts such as locking, transactions, indexes, replication, schema design.
  • Developed enhancements to MongoDB architecture to improve performance and scalability.
  • Collaborated with development teams to define and apply best practices for using MongoDB.
  • Consulted with the operations team on deploying, migrating data, monitoring, analyzing, and tuning MongoDB applications.
  • Used various MongoDB utilities (mongostat, mongotop) to monitor database.
  • Changed priority of replicaset nodes to keep Primary on specific data nodes.Worked on BulkWrite operations in MongoDB

Confidential

Oracle DBA

Responsibilities:

  • Review the alert log in 12c
  • Determine if there is block level corruption. Report new blocks corrupted and corrupted blocks remaining from the previous report
  • Verify the status of last backup. Report new backup corruption and previous unmitigated backup corruption events.
  • Look for newly invalidated objects and unusable indexes and for any hung resumable sessions and blocked sessions.
  • Backed up control file to trace in 12c.
  • Participated in Oracle Golden Gate 11.2 installation, configuration and management, and supporting Bi-directional data replication.
  • Configured High availability and setup custom monitoring through Heart beat tables using Golden Gate.
  • Upgraded golden gate from 11.1 version to 11.2 version on 11gR2.
  • Worked with application team for setting up conflict handlers in Golden gate.
  • Used BATCHSQL, RANGE functions to improve throughput in Golden gate REPLICATES.
  • Troubleshoot slow running EXTRACTS, REPLICATES and tuning.
  • Performed Oracle 11g RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging activities.
  • Involved in implementing 11g RAC with ASM disk on Linux servers.
  • Migrated database Schemas from Single instance to RAC,Duplicated RAC Databases in non-production environment through RMAN.
  • Implemented and troubleshooting Data Guard (Standby) for high availability/disaster recovery purpose.
  • Installation and configuration of Oracle Grid Control and installing OEM agents on all the database server hosts.
  • Installed Oracle 10g/11g/12c stand-alone and RAC systems in HA environment in different O.S platforms (AIX, Linux, Solaris, RHEL and VMware).
  • Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, ISOSTAT and TOP.
  • Database recovering using Veritas, Netbackup and RMAN.
  • Performed backups and recoveries using RMAN/conventional hot & cold backups.
  • Setting up and monitoring RMAN backups that include archive log backups, full database backups, and incremental backups and troubleshooting ORA errors for backup issues.
  • SQL Profiling, SQL Plan Baselines, SQL Trace, ADDM, AWR, ASH and Explain Plan tools to diagnose performance issues.
  • Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
  • Monitoring of the queries with high response time, high disk read per execution, SQL Query performance tuning for optimized results using tools like Explain Plan, SQL TRACE, and TKPROF.
  • Performing daily maintenance tasks like memory management, Tablespace management, Lock conflicts, Indexes and daily health check of Databases.
  • Applied database schema changes in Production and Development environments.

Confidential

Oracle DBA

Responsibilities:

  • Installed & Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 10g to 11g.
  • Responsible for maintenance of around 20 databases combined on all the production, development and testing environments.
  • Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
  • Implemented Oracle Database 10g Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
  • Configured Oracle Data guard for Oracle Disaster recovery.
  • Responsible for Restoration and Recovery of databases at the time of occurrence of critical failures.
  • Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
  • Achieved High Availability, Data protection and Maximum performance by maintaining a physical standby database.
  • Extensive use of Oracle Data pumps, Exports/Imports utility for moving data among the servers.
  • Performed large batch jobs, and tuning of SQL queries and database systems.
  • Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
  • Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
  • Performed Point in time recovery using RMAN.
  • Performed automated backups and scheduling using scripting.
  • Management of Objects, Schemas, Partitioning the tables and Indexes.
  • Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.
  • Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
  • Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
  • Analyzed Alert Logs and Trace Files to resolve the errors.
  • Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Hire Now