We provide IT Staff Augmentation Services!

Sr. Oracle & Cassandra Dba Resume

4.00/5 (Submit Your Rating)

Richardson, TX

PROFESSIONAL SUMMARY:

  • Over 11 years of experience in IT industry as an ORACLE& Cassandra DBA working for various organizations.
  • Experience in Financial, Communication, Service and Aviation domains along wif strong analytical problem - solving, organizational, communication, learning and team skills
  • Extensive Experience in Oracle Database administration of DATAGUARD & ADG 9i & 10g & 11g, 12c.
  • Extensive Experience in RAC, EXADATA, ASM, DATAGUARD, Patching, Upgrades & Migrations.
  • Extensive Experience in 11g, 12c, ASM Migration on mission critical databases.
  • Extensive experience on Exadata and migration from Solaris, AIX to EXADATA.
  • MonitoringExadatasystems using OEM 12c, SundiagandExachkutility
  • Extensive Experience in SQL Database administration on 2000, 2005, 2008.
  • Setting up PhysicalStandby&Logical Standby for the databases.
  • Extensive experience in Dataguard switchover and failover test using flashback and snapshot standby.
  • Experience in Implementing & Setup of ORACLEGRID CONTROL (OMS) &OEM. Extensive experience wif Oracle database administration of Oracle 10g, 11g & 12c RAC wif multiple nodes covered all aspects of administration like installation, configuration, migration, replication, sizing and space management.
  • Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN Active database duplication.
  • Skilled in developing RMAN scripts for database backup including hot and cold backup options for both RAC and standalone instances.
  • Experience in Golden Gate, Veridata, Golden Gate Monitor on 11g
  • Has setup backup and recovery wif expertise in performance tuning and troubleshooting of database.
  • Having over 2 years of Developer/DBA experience in Apache Cassandra and Datastax Enterprise Edition installation, configuration, backup configuration, upgrade, nodetool commands, bootstrapping, performance tuning, decommissioning, and migration etc.
  • Hands on experience on Cassandra architecture wif better understanding and write processes including Mem-table, SStable and commit log.
  • Installed and configured Datastax OpsCenter for cluster maintenance, keyspace, table management and setting up alerts
  • Followed benchmarking standards on setting Cassandra configuration for high throughput and productive write-heavy applications
  • Bulk oaded data into Cassandra Tables. Extensively used sstableloder utility to load Big Tables
  • Used Datastax DevCenter query tool for Cassandra.
  • Experince in Data modelling and working on Cassandra Query Language (CQL)
  • Experience in Bootstrapping and decommissioning of nodes along wif monitoring of Cassandra Cluster.
  • Good experience in Cassandra tools like nodetool, Cassandra-stress, Cassandra CLI, Cassandra CQL and backup.
  • Worked on Extensive Data Warehouse environments sizing around 15-50TB.
  • Co-ordinated and Opened SR's wif Oracle and provided the required logs and reports for their Analysis.
  • Expertise in Oracle 12c/11g/10g/9i/8i database administration in high availability 24*7 production environment
  • 12c/11g/10g/9i RAC, Dataguard& Active Dataguard&PHYSICALSTANDBY & Golden Gate implementation & maintenance.
  • Experience in building Cassandra cluster, monitoring Cassandra cluster for resource utilization.
  • Configured Cassandra database on AWS cloud and familiar wif Cassandra management tools
  • Experience in setting up EXADATA X3-2, X4-2 environments and also Migration of databases to Exadata, Patching & all maintenance activities.
  • Solid experience in Oracle Recovery Manager (RMAN)
  • Configured Dataguard Broker and worked on gap resolution between Primary and Standby sites.
  • Worked on setting the physical standby database on a 2 node RAC
  • Experience in installing Oracle 12C Grid Control including monitoring/setup and performance tuning purposes.
  • Expertise in RDBMS Tools like SQL Loader, Import/Export, Data Pump, RMAN, OEM Grid Control and TOAD
  • Good experience in using TransportableTablespace, SQL Tuning Advisor, Data Pump, Flashback Table, Tablespace Management, Materialized Views, and Oracle Streams.
  • Performance monitoring/tuning/troubleshooting on Oracle, UNIX, Linux, and Windows Excellentinterpersonal, analytical and problem-solving skills.
  • Production Support is the main specialization.

TECHNICAL SKILLS:

Operating System: UNIX (Solaris/HP/AIX/Redhat), Sun Sparc servers / HP Enterprise Class Servers, and Windows

Databases: Oracle 10g, 11g, 12c Databases.

Dev. And Admin Tools: Oracle Enterprise Manager, PL/SQL, SQL*LOADER, TOAD, Veridata, RMAN, OpsCenter, Devcenter

Languages: SQL*Plus, PL/SQL, UNIX Shell Scripting, HTML, XML.

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Sr. Oracle & Cassandra DBA

Roles & Responsibilities:

  • Installed and configured Datastax enterprise 4.8/5, open source Apache Cassandra 3 on multi-node, multi-datacenter cluster.
  • Followed benchmarking standards on setting Cassandra configuration for high throughput and productive write-heavy applications
  • Involved in building high performance Cassandra cluster according to best practices Bootstrapping, removing, and decommissioning Cassandra nodes.
  • Bulk loaded data into Cassandra Tables. Extensively used sstableloder utility to load Big Tables
  • Loaded and transformed large set of structured, semi-structured data in various formats like text, zip, XML and CSV.
  • Experience in AWS in setting Cassandra cluster/nodes
  • Experience in performance tuning on Cassandra by tuning GC, choosing compaction strategy and partition etc.
  • Experience wif Cassandra YAML, configuration files, RACK DC properties file, Cassandra-env for JMX configurations.
  • Analyzed the performance of the Cassandra cluster using Nodetool TPstats and CFstats for thread analysis and latency analysis.
  • Involved in building high performance Cassandra cluster in Multi DC according to best practices.
  • Supported mission critical, customer facing Web applications.
  • Implemented Cassandra security for Datastax Cassandra and Apache Cassandra
  • Experienced in implementing security, control, integrity and accessibility of the data
  • Used Datastax OpsCenter for monitoring Cassandra nodes like Monitoring Compaction Reads/Writes.
  • Installed Oracle 11gDATAGUARD on PROD Environments & also RAC on a 2, 3& 4 node clusters on Redhat & Oracle Enterprise Linux - Prod Environment.
  • Handled 12c upgrades, GRID, Database migrations & upgrades.
  • Created and maintained Multiple ORACLE Instances / Databases for porting databases under various operating system platform (UNIX, Windows environment)
  • Worked on Migrations&Upgrades of 10g, 11g, Databases - and on Dataguard too.
  • Migrated databases from File System to ASM and from Single Instance to RAC.
  • Establishing and monitoring database RMAN backups and datapump export of schemas (hot/cold).
  • Worked on Switch over and switch back test for production and standby databases.
  • Configured Physical standby database using Oracle 11gR2 Dataguard for high availability and disaster recovery solution.
  • Extensively used RMAN for Backups and Restores.
  • Created ACFS File systems for Goldengate
  • Served as an ONCALLDBA for all Production databases 24*7 STAR Support.

Environments: Datastax enterprise 4.8/5, Apache Cassandra 3.0,OpsCenter, Devcenter Oracle11g, 12c,ASM, RAC, Dataguard, Grid Control, Goldengate Veridata.

Confidential, Irving, TX

Sr. Oracle DBA /EXADATA DBA

Roles & Responsibilities:

  • Installed Oracle 9i/10g/11gDATAGUARD, PHYSICALSTANDBY on PROD Environments & also RAC on a two node & 3 node clusters on Redhat Enterprise Linux - Prod Environment.
  • Created and maintained Multiple ORACLE Instances /Databases for porting databases under various operating system platform (UNIX, Windows environment)
  • Handled Migrations&Upgrades of 10g & 11g Databases and Dataguard.
  • Installed and Maintained environment including Creating Databases, Buffer pools, logical and Physical design of database storages
  • Scheduled alerts and set up metrics for OEM & GRID CONTROL 11gR2
  • Served as Oracle DBA on large-scaleData Warehouse systems, including Stage and Prod Data Warehouse systems.
  • Provided 24*7 Support for Production Databases as an on-call DBA.
  • Configured, built, planned and installed EXADATA.
  • AdministeringExadatastorage servers usingcellCLIanddCLI.
  • Experience on Exadata Full rack/Half rack/Quarter rack
  • Migrated databases to EXADATA’s (cross platform), Patching & Exadata maintenance activities
  • Worked on X3-2, Quarter RACK Half RACK. X2-2 half RACK & X2-8 Full RACK
  • Handled migrations from AIX to X4-2’s and also working on patching.
  • Ensured all operating system and migrations issues are appropriately addressed by working pro-actively wif UNIX Support, Web Group and Migrations Teams.
  • Created various database objects and implemented referential integrity rules for complex databases
  • Handled Security Administration including: handling Instance / Database Level Authorities and Object Privileges; creating and maintaining users, user groups and schemas for porting applications as well as controlling database access.
  • Supplied product support: Data reorganization, Backup & Recovery of VLDB (version and roll-forwardrecovery) and Managing Log files.
  • Cloned entire database and refreshed production wif new database name for testing and development purpose.
  • Supplied performance monitoring / Tuning wif Event, Snapshot Monitoring and troubleshooting database issues by enabling various Diagnose level settings.
  • Performed tuning through SQL monitoring and working wif application developers to gather information, explain data and advise on SQL tuning tips.
  • Handled database loading, Migration and maintaining data wif datapump and RMAN utilities.
  • Developed some stored procedures, DB triggers in PL/SQL for customization works.
  • Configured and handled fine tuning of Oracle configuration parameters for better response, throughputs and proper utilization of Global memory.
  • Implemented ASM on RAC Systems and also on the single node instances.
  • Establishing and monitoring database RMAN backups and datapump export of schemas (hot/cold).
  • Configured Physical standby database using Oracle 11gR2 Dataguard for high availability and disaster recovery solution.

Environments: Oracle11g, 12c,ASM, RAC, Dataguard, OEM, Grid Control, Goldengate Veridata, Exadata X3-2.

Confidential, Plano, TX

Lead Oracle DBA

Roles & Responsibilities:

  • Installed Oracle 11gR2 wif RAC on a two node clusters on Redhat Enterprise Linux.
  • Created and maintained Multiple ORACLE Instances /Databases for porting databases under various operating system platform (UNIX, Windows environment)
  • Installed and Maintained different environments including Creating Databases, Buffer pools, logical and Physical design of database storages
  • Implemented referential integrity rules and created various database objects for complex databases
  • Provided Security Administration: user / user group creation & maintenance for database access and handledInstance / Database Level Authorities and Object Privileges.
  • Created database clones for testing and development and refreshed production wif updated database name.
  • Used Event, Snapshot Monitoring and enabled diagnose level settings to troubleshoot database issues for Performance Monitoring & Tuning.
  • Collaborated wif application developers in SQL turning efforts.
  • Utilized SQL*LOADER, EXPORT, IMPORT and RMAN utilities for database loading, database migration and data maintenance.
  • Created shell scripts & Cronjobs and collaborated wif UNIX Support, Web Group and Migrations Teams on OS and migration issues.
  • Involved in writing stored procedures, DB triggers in PL/SQL.
  • Improved response, throughputs and proper utilization of Global memory through configuring and fine-tuningOracle configuration parameters.
  • Implemented ASM on single node instance and RAC Systems.
  • Utilized LOAD, EXPORT, IMPORT and RMAN utilities for database loading, migration and data maintenance.
  • Completed Oracle RDBMS software installations.
  • Applied Oracle PSU's on regular Basis.
  • Handled creating the database, tables, Tablespace, data objects, setting privileges, indexes, user logins, and passwords.
  • Created and Implemented Oracle Apps 11i on the Test bed. Planned for Production implementation and capacity planning
  • Created backup strategies, Maintenance plans, as well as handled job scheduling and user maintenance on MS SQL 2000 / 2005,
  • Applied patches to Production and completed DB releases on MS SQL Databases.

Environments: Production and implementation of RAC on RHEL4, and Support for Prod Databases.

Confidential, Queens,New York

Oracle &SQL server DBA

Roles & Responsibilities:

  • Provided Production support for Oracle database 9i/10g/10g RAC and SQL server 2000
  • Involved in the Process of enhancement of various CRM modules, remodeling the Database backup plans for all MS SQL Database production servers, and remote monitoring of the App and the DB Server onDaily basis.
  • Wrote customized shell scripts to monitor the stats of performance issues.
  • Created database triggers in PL/SQL for data security.
  • Handled ASM implementations for RAC Systems and single node instances.
  • Worked on DataModeling concepts and development of Oracle Databases.
  • Installed and maintained environment including Database creation, Buffer pools, logical and Physical design of database storages and Creating and maintaining Multiple Oracle Instances / Databases for porting databases under various operating system platforms (UNIX, Windows environment).
  • Worked wif SQL*LOAD, EXPORT, IMPORT and RMAN utilities.
  • Worked on Oracle Streams Replication.
  • Applied Oracle PSU's on regular Basis.
  • Completed DB releases on MS SQL Databases and applied patches to Production.
  • Performed Data Analysis and Modeling on all databases.
  • Completed implementation and Testing of 10gR2 RAC on test bed.
  • Handled Database Security Procedures (Create and Maintain Users, profiles, Roles wif System and Object level Privileges) and periodical evaluation of security model.
  • Implemented backup and Crash Recovery Procedure using Oracle suggested Online/Offline and logical Methodologies.
  • Handled work for MS SQL 2000 / 2005: creating backup strategies, maintenance plans, job scheduling and user maintenance.

Environments: Worked on Oracle 9i & 10g on prod & stage environments and also SQL 2000, OEM, Grid Control, SQL Developer, TOAD.

We'd love your feedback!