SUMMARY:

Passionate and highly organized professional, technically strong and having rich production support experience, Oracle - certified professional with solid history of success and impressive record of accomplishment in IT domain (expert in diverse environments). Extensive knowledge of Oracle Databases administration. Strong ability to manage/implement projects and team which includes project plan, completion on-time, on-budget, and on-target delivery. Well-versed in developing/implementing processes and procedures that enhance productivity and operational efficiencies.

EXPERTISE:

• Database Administration.
• Performance Tuning.
• Datacenter Migrations.
• Quality Assurance, Testing and security.
• Client Relationship Management.
• Process Improvements.
• Problem Resolution / Troubleshooting.
• User Training and Support.

TECHNICAL PROFICIENCIES:

Databases: Oracle (7i-12c), Cassandra, SQL Server, MySQL, Postgres, MongoDB, Neo4j, Essbase,HBase,Hive.

Languages: SQL, PL/SQL, Shell scripting, Python, JavaScript,ASP.Net,VB.

Systems: Linux(RedHat), UNIX (IBM AIX, Solaris), Oracle Linux, Windows NT-2012

Tools: /Others:: OEM(11g and 12C), RAC, TOAD, Agile PLM, Hyperion and Essbase, OBIEE, Informatica, ASM, Oracle Application Server, Apache, Tomcat, WebLogic, SSL, Rally, Jenkins, SVN and GitHub, Tableau, ELK Stack (Elasticsearch, Logstash and Kibana), Splunk, PL/SQL, SQL loader, RMAN, EXP/IMP, Data pump, LDAP,Data Guard, Golden Gate, Oracle Streams, SharePlex, Confidential, OpsCenter, Solr, spark, DevCenter, Neo4J, Putty, Secure CRT, Hummingbird, JIRA, Remedy, Sharepoint, Subverson. Sharepoint, Microsoft project, Erwin Data Modeler, DTS, AWS.

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

Sr. Oracle and Big Data Administrator

Responsibilities:

• Administrator (Oracle) databases which includes database creation, up-gradation, and migration, backup/recovery.
• Golden Gate setup / troubleshooting.
• Experience in Performance tuning and SQL tuning.
• Implemented disaster recovery solution.
• Performance tuning of database and application.
• Monitor databases using product tools.
• Automate jobs using scripting language. Implemented DB replication.
• Utilized ELK/Tableau/splunk to analyze server/DB logs.
• AWS Relational Database management.
• Tuned the databases and applications, which were not meeting the customer SLA.
• Automated the deployment process.

Confidential, Milpitas, CA

Senior Oracle Database Administrator

Responsibilities:

• Build, administrator, patching, cloning and supported Production/Stage/Test/Dev databases/applications running for different applications like Oracle E-Business Suit, Agile, Demantra, BI, SOA, MES and OBIEE. Set-up backup, recovery, security and monitoring processes for the databases/applications.
• Installed/Supported/upgraded EBS, Agile PLM, Demantra, Informatica and OBIEE applications. Supervised/migrated all databases and IT applications hosted in Oracle-On-Demand to new JDSU data center).
• Developed and automated processes where team can deliver their best in 24*7 environment.
• Tuned the databases and applications. Set-up DB replication and error handing. Trained and supported team members.
• Set-up, administrator, patching, upgrade and supported EBS, Agile, Demantra, BI, SOA, ESSBASE, Informatica, MES and OBIEE applications.
• Migrated the databases and applications from Oracle-On-Demand to In-house.
• Set-up monitoring/resolution/escalation processes for databases and applications.
• Set-up backup and DR policies for all applications.
• Developed and automated new processes.
• Played significant role tuning databases and applications.
• Automated database’s refresh (Size in GB and TB) and application cloning using shell script.

Confidential, West Des Moines, IA

Senior Oracle Database Administrator

Responsibilities:

• Leading one team of database administrator to support well Fargo Core Application. Configured and supported databases running for different core applications.
• Enhanced deployment processes. Set-up backup/recovery, Confidential, monitoring and migration processes for the databases.
• Migrated the data from Oracle to SQL Server. Set-up DB replication. Tuned databases and application based on SLA.
• Enhanced deployment/development and monitoring process.
• Supervised a team, supported multiple applications and provide the best support during the tenure.

Confidential, San Ramon, CA

Senior System Analyst

Responsibilities:

• Confidential is Information Technology division of Confidential and DMS is a group which manages databases of Confidential .
• There are more than 600 databases supported by DMS DBA Team.
• These databases consists critical information, which are monitored and maintained in 24/7 support.
• My role involves in database administration, migration, maintaining databases/applications servers, implementation of backup and recovery strategies, monitoring databases, resolving critical issues, performance tuning of databases/applications.
• Oracle ERP DB and application cloning, installation, configuration, patching, upgrade.Automating process, setting up jobs and replication process.
• Troubleshooting of issues and performance tuning for DB and ERP Apps.
• Parallel concurrent processing, debugging concurrent managers.
• Worked in Audit and SOX controls .
• Involved in process documentation.
• Manage Offshore and Onsite DBA Services.
• Trained and supported team members across the globe.
• Supervised DBA Services and operations.