We provide IT Staff Augmentation Services!

Senior Cassandra Database Architect Resume

Bellevue, WA

SUMMARY

  • Around 14 years of IT experience specializing in Design, configure and managing databases
  • Installation, configuration, administration, design and managing Oracle, NoSQL databases
  • Datastax Certified professional on Apache Cassandra and Oracle Certified Professional DBA
  • Designed and implemented large cluster environments in Cassandra and Oracle
  • Cluster node management like adding and removing nodes and services
  • Installing and setup Cassandra clusters on openstack VM and AWS cloud
  • Setup and configuration DSE - spark, opscenter and DSE-solr cluster
  • Managed and setup the Cassandra clusters using datastax opscenter
  • Troubleshoot Cassandra consistency issues and repair the data consistency issues
  • Managing Cassandra cluster and keyspaces using tools cqlsh, nodetool
  • Configured Cassandra backups and monitoring alerts
  • Installed, designed, configured and managed oracle databases on exadata machines
  • Expertise in database replication, migrations and upgrades using oracle GoldenGate
  • Expert in database activity monitoring and fix the issues and keep the system up always
  • Expert in installation and configuration of Oracle 12c OEM and grid control
  • Expert in planning migrating databases as part of datacenter migrations
  • Expert in setup and manage Oracle 12c Pluggable (PDB) and Container (CDB) databases
  • Database user and security administration activities
  • Good experience on AWS skills on EC2, VPC, S3, ECS and IAM roles
  • Provided on-call support 24x7 regarding production-related database problems.
  • Good experience on Hadoop cluster and migrated databases to Hadoop cluster
  • Extensive experience on Oracle Real Application Clusters (RAC)
  • Experience in configuring and administering the ASM instances.
  • Experience on install, setup and using oracle veridata in migration, replication and upgrades
  • Prepared database technical documents for design, implementation and troubleshooting
  • Expert in managing the file systems ASM cluster file system (ACFS), OCFS and ZFS
  • Expertise in setup the database replication using oracle streams and Golden Gate
  • Expert in setup the Golden Gate for zero downtime database migrations and upgrades

TECHNICAL SKILLS

Operating System: IBM-AIX, Solaris, Linux, HP-UX, Exadata and Windows

Products/Tools: Opscenter, Devcenter, Datastax studio, OEM, Erwin, VSS, TOAD, Oracle Golden Gate, AWS, Splink, Nagios, Zabbix

Languages: PL/SQL, Perl, Shell

Databases: Oracle, Cassandra, MongoDB, Couch database, PostgreSQL, Hadoop, MS SQL Server

Business Domains: Finance, Telecom, Healthcare, Airlines, Manufacturing and Logistics

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Senior Cassandra Database Architect

Responsibilities:

  • Design and implement NoSQL database systems as inCassandraDB
  • Setup cluster security and secure client communication
  • Monitor availability and performance of production and developmentCassandraclusters
  • Configuring Cassandra clusters and keyspaces on RHEL openstack and AWS cloud
  • Installed and setup apache spark and solr
  • MonitoringCassandracluster for resource utilization
  • ManagingCassandraclusters using Datastax opscenter
  • Monitored, Tuned IO, CPU and memory issues
  • Configured internode communication betweenCassandranodes and client using SSL
  • DesignedCassandraData model considering current application functionality
  • Configured authorization toCassandracluster using Password Authenticator
  • Installed and configuredCassandracluster and CQL on the cluster.
  • Used opscenter to monitor cluster Metrics and enable the services and alerts.
  • Performed Stress and Performance testing, benchmark on the cluster.

Confidential, Brentwood, TN

Senior Cassandra Database Architect

Responsibilities:

  • Design and implement NoSQL database systems as inCassandraDB
  • Monitor availability and performance of production and developmentCassandraclusters
  • MonitoringCassandracluster for resource utilization
  • ManagingCassandraclusters using Datastax opscenter
  • Configured internode communication betweenCassandranodes and client using SSL
  • DesignedCassandraData model considering current application functionality
  • Configured authorization toCassandracluster using Password Authenticator
  • Installed and configuredCassandracluster and CQL on the cluster.
  • Used opscenter to monitor cluster Metrics and enable the services and alerts.
  • Performed Stress and Performance testing, benchmark on the cluster.
  • Migrated Oracle databases to Cassandra keyspaces
  • Configured and setup Cassandra clusters on AWS multi region

Confidential, IL

Senior Cassandra/Oracle Database Architect

Responsibilities:

  • Design and implement NoSQL database systems as inCassandraDB
  • Monitor availability and performance of production and developmentCassandraclusters
  • MonitoringCassandracluster for resource utilization
  • ManagingCassandraclusters using Datastax opscenter
  • Configured internode communication betweenCassandranodes and client using SSL
  • DesignedCassandraData model considering current application functionality
  • Configured authorization toCassandracluster using Password Authenticator
  • Installed and configuredCassandracluster and CQL on the cluster.
  • Used opscenter to monitor cluster Metrics and enable the services and alerts.
  • Performed Stress and Performance testing, benchmark on the cluster.
  • Migrated Oracle databases to Cassandra keyspaces
  • Configured and setup Cassandra clusters on AWS multi region
  • Installed and configured Oracle 11g and 12c databases on RHEL, Exadata
  • Installed and setup Oracle active dataguard databases
  • Configured multi-node Hadoop cluster and migrated oracle database using sqoop
  • Tuned Oracle database instances and provided and implemented SQL tuning
  • Worked on AWR and ASH reports to improve the database performance
  • Created and managed pluggable (PDB) and container (CDB) databases
  • Installed and configured databases on Exadata and Oracle database appliance machines
  • Installed grid software, ASM and setup RAC databases
  • Oracle databases migrated to AWS cloud machines using RDS migration tool
  • Setup and executed Oracle RMAN backups and tested restore of backups
  • Used oracle data pump to refresh the oracle databases and schemas
  • Analyzed and implemented Oracle database performance recommendations
  • Installed and configured oracle golden gate for replication between databases
  • Migrated and upgraded databases using Oracle GoldenGate
  • Installed and setup oracle 12c OEM Goldengate plug-in and alerts for goldengate processes
  • Analyzed and resolved the goldengate replication slow performance issues
  • Handled storage area network (SAN) and allocated storage from SAN
  • Installed and setup Oracle Veridata to compare and fix the data between source and target
  • Developed PL/SQL programs to automate the database tasks and audit records
  • Installed, configured and used business intelligence reporting software
  • Provided oracle security design and hardening database support
  • Installed and configured Oracle 12c OEM agents
  • Setup and Configured data redaction policies
  • Created and modified Oracle schemas and objects
  • Regularly monitoring the database activity for any issues
  • Configured data masking for sensitive data
  • Monitored security activity for the entire deployment
  • Managed and distributed policies system wide using imperva
  • Monitoring oracle databases using Oracle 12c OEM cloud control
  • Installed, configured and used database vulnerability management tool
  • Oracle databases migrated to Amazon cloud service machines
  • Applied oracle patches. Monitor environment health from a single imperva console
  • Setup the database vault and audit vault for data security
  • Good experience on database auditing using database vault and audit vault
  • Setup database security and handled cyber security
  • Database and user security events reported to GSIRT
  • Refreshing the test databases and schemas using production data
  • Space management and create the application schemas
  • Resolved the Oracle database instance and application SQL performance issues using tools AWR, ASH, SQL Trace, explain plan and quest SQL optimizer
  • SAP database administration including configuration, management and security setup
  • Creating and follow up Oracle SRs for database issues

Confidential, Memphis, TN

Senior Database Administrator

Responsibilities:

  • Installed, setup ad configured Oracle and Sybase databases
  • Oracle data cloning between oracle databases using golden gate.
  • Migrated and upgraded databases across platforms
  • Oracle RAC database installation and configured on RHEL operating system.
  • Application code reviewed before implementation into production.
  • The databases migrated to Amazon AWS cloud systems
  • Installed, configured and managed the oracle ASM instance and disks
  • Configured Oracle active data guard database.
  • Provided oracle security design and hardening database support
  • Siebel database administration including configuration, management and security setup
  • SAP database administration including configuration, management and security setup
  • Developed PL/SQL programs for database administration
  • Installation and administration of weblogic servers
  • Configured data masking for sensitive data
  • Database designing and capacity management for application new tables and changes.
  • Scheduled the automate scripts for RMAN backups and daily database status mails
  • Scheduling the database monitoring scripts and backup status.
  • Handled storage area network (SAN) and allocated storage from SAN
  • Oracle 12c OEM installation and configured for central database administration.
  • Configured Oracle Golden Gate for data replication between databases.
  • Oracle database backups using backtrack tool
  • Setup and Configured data redaction policies
  • Installed, configured and used database vulnerability management tool
  • Refreshing the test databases and schemas using datapump and RMAN backup
  • Resolved the database performance related issues.
  • Maintained and audited Application and data servers.
  • Resolved the Oracle database instance and application SQL performance issues using tools AWR, ASH, SQL Trace and explain plan

Confidential, New York

Senior Database Administrator

Responsibilities:

  • Oracle RAC Databases migrated from Windows to RHEL.
  • Oracle database cloning between oracle database environments using expdp and TTS.
  • Oracle databases migrated and upgraded from Oracle 10g to 11g version
  • Oracle database cloned across platforms using the RMAN convert option
  • Oracle RAC database environments tuned for best performance.
  • Added new ASM disks in Linux and Windows environments
  • Configured Oracle active dataguard database.
  • Installed and configured Sybase databases
  • Scheduled the automate scripts for RMAN backups and daily status mails
  • Scheduling the database monitoring scripts and backup status.
  • Installed and setup database and operating system(OS) security configuration
  • Installation and administration of weblogic servers
  • Developed PL/SQL programs for database administration
  • Siebel database administration including configuration, management and security setup
  • Handled storage area network (SAN) and allocated storage from SAN
  • Setup and Configured Oracle 12c OEM and alerts for database management.
  • Configured the Oracle Golden Gate for data replication between databases
  • Configured data masking for sensitive data
  • Refreshing the test databases using datapump, hot backup and RMAN backup
  • Involved with team in setup the weblogic server for applications and servers
  • Resolved the RAC database performance related issues
  • Resolved the Oracle database instance and application SQL performance issues using tools
  • Used oracle data pump to refresh the oracle databases and schemas
  • Implemented automatic shared memory management (ASMM).
  • Implemented flashback recovery option to roll back the database in case any issues
  • Conducted the regular performance review of databases for business critical applications
  • Implemented the oracle data masking for critical data using the tools like TDE
  • Setup the database vault and audit vault for data security

Confidential, New York

Senior Database Administrator

Responsibilities:

  • Regular monitoring of all Oracle and SQL databases
  • Oracle 11g RAC database installation and configuration with ASM
  • Oracle RAC database upgraded from version 10g to 11g
  • Configured the Oracle 11g grid control for system alerts
  • RMAN backup configuration and Dataguard setup has been done for oracle databases.
  • Regular Backup configuration has been done for MS SQL databases
  • Migrated and upgraded the database from version 10g to 11g
  • Installed and configured the Oracle Golden Gate for database replication
  • Monitoring the database backups and scheduled scripts
  • Checking and resolving database performance issues
  • Handled storage area network (SAN) and allocated storage from SAN
  • Daily checking the high system resources usage sessions
  • Refreshing the test databases. Setup database audit and database vault
  • Used oracle data pump to refresh the oracle databases and schemas
  • Setup the TDE and wallet for sensitive data protection
  • Configured data masking for sensitive data
  • Taking the backup and sending over the FTP servers for testing the applications.
  • Checking the Index usage and rebuilding the indexes.
  • Database space management includes datafile and tablespace size.
  • Server storage space management. Written ad hoc basis SQL scripts for the data reports.
  • Tuned the SQL queries for best performance.
  • Implemented audit mechanism on production databases.
  • Resolved the database performance issues
  • Developed PL/SQL programs for database administration
  • Configured the data replication between databases using shareflex tool.
  • Archiving the large and log tables on regular basis.
  • Configured the Oracle streams for replication
  • Estimated the hardware configuration for the new servers.
  • Created linked servers between Oracle and SQL databases for reports.

Confidential

Senior Database Administrator

Responsibilities:

  • Database Space management
  • Configuration of Cluster nodes, RAC and ASM instances
  • Administering the Oracle 10g and 11g RAC databases
  • Migrated and upgraded the databases from IBM-AIX to RHEL machines
  • Configured the oracle streams for data replication and data movement between databases
  • Handled storage area network (SAN) and allocated storage from SAN
  • Creation of database tables, synonyms and indexes with proper storage managements
  • Monitoring Production servers by checking the file systems, data files and tablespaces.
  • Used oracle data pump to refresh the oracle databases and schemas
  • Storage management, sizing the database objects, monitoring file Systems
  • Set up the database replication using tools Golden Gate, Streams and Shareplex
  • Schema Design and Security Administration for the database
  • Written PL/SQL Programs like Packages, Procedures and Triggers
  • Implemented Cursors to handle Database Performance issues
  • Resizing the SGA, PGA and tablespaces, added data files as when necessary.
  • Implemented the automatic shared memory management
  • Developing, testing, continuously monitoring, and updating the Backup.
  • Taking logical and physical backups periodically.
  • Managed Oracle Siebel applications. Scheduling the cronjobs.
  • Designing & implementing indexes. Oracle net configuration.
  • Improving Query Performance by rewriting the problematic queries.
  • Maintaining the standby database for data security.
  • Oracle Software Installation, database creation and regular RMAN backup scheduling

Confidential

Database Administrator

Responsibilities:

  • Creating and Altering tables and materialized views.
  • Create and reuse metadata and job components.
  • Run, monitor and schedule the jobs.
  • Creation of schemas and giving roles, privileges to schemas.
  • Handled storage area network (SAN) and allocated storage from SAN
  • Taking logical backups. Database performance monitoring.
  • Creation of indexes, primary keys and unique key indexes by checking the performance.
  • Creation of materialized views.
  • Oracle TDE is used for data encryption.
  • Creation of dimensional and fact tables and giving relationship between them.
  • Data modeling issues by exporting and importing data from
  • Taking logical backups periodically

Confidential

Database Administrator

Responsibilities:

  • Database Space management.
  • Create and configure new databases
  • Creation of database tables, synonyms and indexes with proper storage managements.
  • Monitoring Production servers by checking the file systems, data files and table spaces.
  • Storage management, sizing the database objects, monitoring file Systems.
  • Schema Design and Security Administration for the database.
  • Resizing the SGA and tablespaces, added data files as when necessary.
  • Developing, testing, continuously monitoring, and updating the Backup.
  • Taking logical and physical backups periodically.
  • Scheduling the cronjobs and Oracle net configuration.
  • Designing & implementing indexes.
  • Improving Query Performance by rewriting the problematic queries.
  • Maintaining the standby database for data security.

Confidential

Database Administrator

Responsibilities:

  • Database space management.
  • Test databases refresh with production data using export/import
  • Monitoring production servers (CPU, Memory, No of sessions, stray sessions etc.)
  • Creation of schemas and tables and indexes. Installed and setup Oracle RAC and Dataguard
  • Database performance monitoring.
  • Checking the alert log files and taking the action if any problem persists.
  • Designing and implementing the indexes.
  • Improving Query Performance by rewriting the problematic queries.
  • Creation of materialized views and data transfer between the different databases.
  • Taking logical and physical backups hot backup, cold backup and RMAN.

Confidential

Database Administrator

Responsibilities:

  • Creation of Database and location of initial data files, redo log files, control files and multiplexing them editing database initialization parameter files.
  • Creating users, roles, profiles, assigning roles and profiles to users.
  • Creating tablespaces, Data files, Log files and control files.
  • Taking logical and physical backups periodically.
  • Tuning Oralce9i database server using tools
  • Oracle Networking, Configure Oracle client using DBCA tool
  • Creating networking Configuration files, and creating service name.
  • Configured Oracle9i database server using Net Manager Tool
  • Creating configuration files such as LISTENER.ORA, Specify network protocol such as TCP/IP.
  • Storage management, sizing the database objects, monitoring file Systems
  • Choosing different types of data storages
  • Used parallel query options and SQL hints for better performance.
  • Parallelized SQL statement execution where appropriate tables.
  • Used oracle enterprise manager to monitor the multiple databases.
  • Performance tuning & Query Optimization.

Hire Now