SUMMARY:

• 9+ years of experience as a database administrator with experience on different platforms and provided 24x7 on call production support.
• Providing Client based and service based solutions and was involved in infrastructure planning.
• Created IT support plan to provide 24x7 support along with service level agreements, resource planning, maintenance costing, data analysis etc.
• Hands on experience in implementing high availability technologies like SQl and NoSQL databases like Oracle 11g RAC support, Apache Cassandra Cluster, DataStax Enterprise Custer on different OS platforms like HP - UX, Ubuntu, Solaris, UNIX, and AIX with OLTP, Warehouse and Large scale databases.
• Experience in features like Hive, Pig, Spark, Sqoop, Nodetool, Cqlsh, Repair, Snitching, Partition, ASM, RAC, RMAN, SQL performance analyzer, ADDM.
• Experience in performance tuning and monitoring activities using OPS Center, TPSTATS, CFSTATS, EXPLAIN PLAN, TKPROF, STATSPACK, TOAD, ORADEBUG and ADDM on both oracle and Apache Cassandra databases.
• Hands on experience in installing different SQL and NoSql databases like oracle 9i, 10g, 11g, Apache Cassandra and also experience in upgrading, applying patches, migration experience.
• Experience in handling Apache Cassandra and Oracle databases on HP UX, LINUX, SOLARIS, Ubuntu, and Microsoft WINDOWS.
• Extensive experience in node management, cluster management, backup and recovery, snapshot, replication, cloning, migration, applying patches, export/import, index management etc.
• Expert in disaster recovery plan, backup and recovery strategies on Cluster environments of SQL and NoSQL using features like RAC with ASM and replication, non RAC databases, Flash back, recovery, TSPITR.
• Experienced in analyzing the risk of a change proactively using multimode cluster especially in Cassandra database.
• Performed frequent maintenance activities on Cassandra database like repair, add and remove nodes, rebuild indexes, cleanup.
• Experience in refreshing and cloning of databases using recovery manager RMAN.
• Experienced in Flashback Database, Flashback Table, Flashback Data Archive, Recycle Bin and Restore Points.
• Experience in node monitoring, schema management, application management, security management, auditing, memory management etc. in Cassandra.
• Knowledge in installing, maintaining and monitoring MongoDb servers
• Excellent communication, documentation, training and team management skills.

TECHNICAL SKILLS:

Programming Languages: PL/SQL, Python, CQL, Shell Scripting, HTML.

Database tools: SRVCTL, RMAN, TOAD, STATSPACK, AWR, ADDM, DBCA, NodeTool, OPS Center, spark, solr, pig, sqoop, hive, JConsole, OEM.

Networking: Computer Networks, Network Programming

File System: Fat32, Ext3, Ext4, ADM, HDFS, OCFS, ACFS,NTFS

Operating System: HP - UX, AIX, Solaris, Linux, UNIX, UBUNTU, Windows, MS-DOS.

Other Tools: MS-Office, MS-Access

PROFESSIONAL EXPERIENCE:

Confidential, CA

Database Admin

Responsibilities:

• Performed infrastructure design, installation, and maintenance of NoSql databases like Apache Cassandra, Hadoop servers.
• Created scripts for performance tuning, backup and recovery activities on Cassandra, Hadoop servers.
• Conducted periodic reviews meetings with team members. Provided weekly and monthly status reports to higher management. Participate in business meetings with various stake holders.
• Setup Solr and gathered statistics for dynamic and elastic search.
• Hands on experience in automation of processes for simplifying regular processes.
• My work also involves a high degree of problem solving, decision-making and high cross-team interactions during resolution of problems.
• Migrated data from SQL based databases to NoSql databases.
• Performed daily maintenance tasks like health check, backup procedures, performance monitoring, alerts and log monitoring, and other activities.
• Proposing hardware, database, middleware and front end solutions to client

Environment: Linux, HPUX, Cassandra, nodetool, hubble, GIT, Jenkins, OPS Center, Splunk, Oracle, RMAN, Linux, etc

Confidential, OH

Database Admin

Responsibilities:

• Production planning activities in NoSql and Sql environments such as Cluster Installation and creation of DB, backup and recovery, space management, security management, DB upgrade.
• Active participation in successful implementation of the development projects - roles include capacity planning, technical support on database issues and providing an appropriate high availability solution depending on the requirements.
• Performed installation and setup of Pig, Hive, sqoop, Solr, Hadoop for integration with Cassandra database.
• Worked on Node Management, scalability performance management for Apache Cassandra database.
• Evaluation and implementation of tools needed for memory management, data management, node discovery, data storage, data protection, data deployment.
• Configured and maintained databases to ensure High Availability and Disaster Recovery solutions for enterprise data for Apache Cassandra databases.
• Identified data tuning requirements by analyzing applications/data sources, interviewing appropriate resources and optimizing search queries using Solr.
• Performed Bulk load of Data using Pig, Hive and Hadoop as input into Cassandra database.
• Experience in Database Security by monitoring User Management, Privileges, and Roles, Auditing, Profiling, Authentication and Risk management.
• Follows the methodology for ongoing assessment of production database performance and identification of problem areas in node management and cluster environments.
• Performed maintenance activities like cleanup, repair, add and remove nodes, consistency management on Apache Cassandra database.
• Write scripts to analyze space requirements and maintain keyspaces, creation and maintenance of column families and indexes.
• Performed daily maintenance tasks like cluster health check, backup procedures, performance monitoring, alerts and log monitoring.

Environment: Apache Cassandra, Pig, Hive, Scoop, Hadoop, Solr, Ubuntu, OPS Center, ASM, RMAN, Perfmon, RAC, spark, Data Guard, nodetool, Cassandra-stress, AWS, SAN.

Confidential, De moines,IA

Database Admin

Responsibilities:

• Comprehensive infrastructure planning for software integration with hardware along with detail documentation of all activities
• Active participation in successful implementation of the development projects - roles include capacity planning, technical support on database issues and providing an appropriate high availability solution depending on the requirements.
• Configuration and Administration of Active Data Guard in RAC environments
• Performance Tuning for various databases supporting different applications and operating systemenvironments
• Implemented robust backup and recovery strategies using RMAN with using Advanced EMC de-dup and other backup technologies and Hot Backup Scripts
• Stabilized Oracle Grid Control environment along with Scripting of all installations for repeatability and consistency.
• Automated the database refresh process to refresh non-production environments using shell scripts.
• Created different masking formats and definitions, implemented masking for secured data.
• Migrated data from oracle database to Cassandra database.
• Installed and configured Golden Gate replication between oracle databases
• Provide integration solutions and Knowledge transfer to client staff.
• Monitoring for 24x7 Production environment, resolution of severe performance and user access issues

Environment: LINUX, AIX, Oracle 11g, Apache Cassandra, OPSCenter, nodetool, Cassandra-stress, GRID, SAN, ASM, RMAN, RAC, AWS, ADDM, AWR

Confidential, Phoenix,AZ

Oracle DBA

Responsibilities:

• Worked as a database administrator and handling multiple databases in both OLTP and Warehouse environments of Oracle 11g, 10g, 9i on HP UX, AIX, and LINUX systems.
• Set up an Auxiliary database to perform tablespace point in time recovery (TSPITR).
• Performed Oracle grid control agent installations and setup agent parameters for better parameters and tuned OMS for faster response to agents.
• Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some the activities performed for better performance.
• Helped in SAN storage RAID5 using EMC Navisphere and also created, removed, and resized volumes, add and remove disks based on capacity planning.
• Successfully implemented comprehensive backup plan and disaster recovery strategies at the DR site and used RMAN on ASM for backup and recovery.
• Implemented Java messaging services, ProC, ODP.net, ONS for connection load balancing between instances and implemented application fail over.
• Upgraded data from Oracle 9.2 to 11.1, applied patches from Meta-Link, migrated data from SQL server to Oracle, performed cross plat form migration.
• Setup RMAN in catalog mode for incremental backup, full backup on RAC systems.
• Monitored and performed tablespace management, datafiles management and extent management, segment management, user management and security management
• Performed tuning activities using AWR, ADDM, and SQL tuning advisor to monitor database statistics and also performed RAC interconnect tuning.

Environment: HPUX, LINUX, UNIX, AIX, Oracle 11g, 10g, 9i, ASM, AWR, ADDM, GRID, DATAPUMP, DATA GUARD, WINSCP, RMAN, RAC, SAN

Confidential, Phoenix,AZ

Database infrastructure assistant

Responsibilities:

• Helped in developing business development plan in IT sector.
• Assisted in client based service oriented architecture and in creating service level agreements.
• Guided technical team in providing 24x7 online support along with team management plan, resource requirement plan, and resource scheduling.
• Database Administrative tasks such as Installations, Configurations, Upgrades, Migrations, OS patching and DB patching
• Created database objects, created users, profiles, security, materialized views and also performed tuning, capacity plan and backup and recovery scripts for SQL Server.
• Performed tuning activities using AWR, ADDM, and SQL tuning advisor to monitor database statistics.
• Successfully assisted in comprehensive backup plan and disaster recovery strategies at the DR site and used RMAN on ASM for backup and recovery.
• Performed performance tuning, memory tuning using STATSPACK, ASH, AWR, ADDM and used enterprise manager (EM) for cluster management, load balancing.

Environment: HP UX, HP 9000, Oracle 9i, 10g, SAN DMX3, AWR, ASH, ADDM, DATAPUMP, RMAN, TOAD, ASM, RAC.

Confidential

Oracle DBA

Responsibilities:

• Worked as a database administrator and handled multi-terabyte OLTP and Warehouse databases of Oracle 10g on HP UX Servers.
• Performed tuning activities using AWR, ADDM, and SQL tuning advisor to monitor database statistics and also performed RAC interconnect tuning.
• Created backup and recovery plan to RAC database and scheduled backup and recovery activities to and from tapes, disks.
• Successfully implemented comprehensive backup plan and disaster recovery strategies at the DR site and used RMAN on ASM for backup and recovery.
• Used transportable tablespace for migrating data from OLTP to warehouse and also performed cross platform transportable tablespace with the help of RMAN.
• Migrated database from 9i-10g and applied patches when available.
• Used EMC Navisphere for SAN and also helped in performing disk level mirroring.

Environment: HP UX, HP 9000, Oracle 9i, 10g, AWR, DATAPUMP, Data guard, RMAN, TOAD, ASM, RAC.

Confidential

Oracle DBA

Responsibilities:

• Worked as a database administrator and handled multi-terabyte OLTP and Warehouse databases of Oracle 10g on HP UX and AS400 Servers.
• Administered SAN storage RAID5 using EMC Navisphere and also created, removed, and resized volumes, add and remove disks based on capacity planning.
• Created backup and recovery plan to RAC database and scheduled backup and recovery activities to and from tapes, disks, SAN storage.
• Created physical standby, logical standby using data guard, created clone database.
• Used EMC Navisphere for SAN and also helped in performing disk level mirroring.
• Setup Oracle Meta-link credentials and downloaded available patches and performed upgrade in RAC environment with minimal downtime.