SUMMARY OF EXPERIENCE:

• Hands on experience as an Oracle DBA over 10+ years Teradata/Mongo/Cassandara/Couchabase/Aerospike DB in IT industry and Support of Oracle 9i/10g/11g/12c in Production, Development and QA environment. Exposure to Teradata,Mongo,Casendra,Couchbase,Aerospike database administration activities.
• Excellent experience as an Oracle DBA in various platforms such as Vmware,Sun Solaris, HP - UX, AIX, Red Hat Linux, Windows etc..
• Taking ownership of architecting, designing, developing, and deploying a new game changing highly efficient, scalable, high performance storage and systems product.
• Recovery of Databases (Recovering from Media failure, Recovering Tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Experience in Distributed Systems and scalable systems design.
• Work wif customer support to efficiently handle engineering escalations for the products.
• Learning experience working wif Cloud platforms such as AWS/Azure/Google Cloud.

TECHNICAL SKILLS:

Operating System: Sun Solaris 10 sparc, Windows NT/2000/2003, IBM AIX 5.2 & 5.3, RHEL 4, HP-UX.

Hardware/Storage: Sun Sparc MS Windows.

RDBMS: Oracle 9i, Oracle 10g, 11g R2, Oracle Gloden Gate, Oracle 11g Release 2,12c, Teradata, Sql Server 2014,Mongo,Casedra DB,Couchbase,Aerospike.

Applications: Oracle Fusion Middle-ware, SOA App.

Database Tools: Oracle 12c grid, 13c Cloud Control, RMAN, SQL Server 14, Toad, SQL Navigator, expdp/impdp.

Languages: SQL, UNIX shells scripting.

PROFESSIONAL EXPERIENCE:

Confidential, SanJose, CA

Responsibilities:

• E-Commerce / Financial database administration support.
• Working on Oracle 11g, 12c DB, OEM 13c Cloud Control and performing L1, L2 level activity in Mongo, Casendra DB.
• DB Refresh using RMAN and OEM.
• NoSql DB - Mongo DB,Casendra DB,Aerospike,Couchbase DB.
• Patching on more TEMPthan 150 db in current projects.
• Performance tuning, Oracle Client installation, Backup scheduling through OEM 12C.
• Supporting on Oracle 11g, 12c DB, OEM 13c Cloud Control and performing L1, L2 level activity in SQLServer DB.
• DB Refresh using RMAN and OEM.
• Patching on more TEMPthan 190 db in current projects.
• Performance tuning, Oracle Client installation, Backup scheduling through OEM 12C.

Previous Project

Confidential

Responsibilities:

• Providing expert technical solutions and guidance to Project Managers and team DBA’s on adopting best Oracle practices and standards to enable the IT objectives and initiatives of the Cognizant Group to be attained in most efficient manner.
• Direct the Backup and Recovery strategy of the group so as to ensure dat disaster recovery, business continuity and protection of critical data service level agreements are both met as well as improved.
• Upgrading production and development databases to Oracle 11g.
• Installation, Configuration and Administration of Oracle 11g RAC.
• Applied patches to Oracle Databases and Oracle Applications.
• Applied Oracle Applications and database patches.
• Perform other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Day to day DBA activities like managing the databases, users, roles, profiles & access in both Prod, QA & Dev.
• Well versed wif Teradata Tools & Utilities like Manager, Administrator, SQL Assistant, Viewpoint etc
• Releasing Utility Locks of Fastload / Multiload. Monitoring performance of the system.
• Restoration of tables as per the requirement of client on the production/ development server from available backup set.
• Space Management and Creating Teradata Manager Profiles and users.

Confidential

IT Consultant Oracle DBA.

Responsibilities:

• Installation, Configuration and Administration of Oracle 9i, 10g RAC and 11g RAC databases for Testing, Development and Production.
• Converted single instance to RAC
• Added nodes to RAC.
• Upgraded Oracle different version from 10.2.0.4 to 11.2.0.4
• Support Oracle 10g RAC Env. On Solaris 10.Support SIEBEL Application database wif Oracle 10G.Support 10 Productions DB. Monitor RMAN backup and Export jobs. Oracle Fusion middle ware, SOA Application, Oracle Streams.
• Provide support for SOA application.
• Migration of over 50 production databases from Oracle 10 to Oracle 11g and 10g wif minimal downtime to business.
• Implementing Oracle 10g RAC wif ASM to provide a resilient solution wif optimal performance for a key business critical system.
• Provided DBA support for nightly batch operations; monitored resource usage and took corrective action when required.
• Banking database administration support.
• Senior member of a team of 12 DBA’s providing 24x7 production support for over 20 databases on the corporate bank network ranging in size from 5GB to over 1TB.