SUMMARY:

• Around 14 years of IT experience specializing in Design, configure and managing databases
• Installation, configuration, administration, design and managing Oracle, Cassandra & Hadoop
• 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, 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 in Cassandra DB
• Setup cluster security and secure client communication
• Monitor availability and performance of production and development Cassandra clusters
• Configuring Cassandra clusters and keyspaces on RHEL openstack
• Installed and setup apache spark.
• Monitoring Cassandra cluster for resource utilization
• Managing Cassandra clusters using Datastax opscenter
• Configured multi-node Hadoop cluster and migrated oracle database using sqoop
• Configured internode communication between Cassandra nodes and client using SSL
• Designed Cassandra Data model considering current application functionality
• Configured authorization to Cassandra cluster using Password Authenticator
• Installed and configured Cassandra cluster 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 in Cassandra DB
• Monitor availability and performance of production and development Cassandra clusters
• Monitoring Cassandra cluster for resource utilization
• Managing Cassandra clusters using Datastax opscenter
• Configured internode communication between Cassandra nodes and client using SSL
• Designed Cassandra Data model considering current application functionality
• Configured authorization to Cassandra cluster using Password Authenticator
• Installed and configured Cassandra cluster 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 in Cassandra DB
• Monitor availability and performance of production and development Cassandra clusters
• Monitoring Cassandra cluster for resource utilization
• Managing Cassandra clusters using Datastax opscenter
• Configured internode communication between Cassandra nodes and client using SSL
• Designed Cassandra Data model considering current application functionality
• Configured authorization to Cassandra cluster using Password Authenticator
• Installed and configured Cassandra cluster 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 e Confidential yption.
• 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.

Confidential

Database Administrator

Responsibilities:

• Installed Oracle 8i and created databases
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints.
• Creating users, roles, profiles, assigning roles and profiles to users.
• Tablespace management and Oracle net 8 configuration
• Analyzing tables, indexes and schema. Rebuilding indexes.
• Taking logical and physical backups periodically.