Oracle Developer Production Engineer
Resume:
Pramod Samal
**** ******** ** *********, ** 37221 916-***-**** ******@*****.*** Linked-In : https://www.linkedin.com/in/pramod-samal-a02a513/ Professional Summary
Experienced Database Administrator committed to maintaining cutting edge technical skills and up-to-date industry knowledge. Over 30 years of experience as Database Administrator with various responsibilities as Principal Technical Architect, Senior DBA, Lead DBA, System Analyst, Module leader, Team leader, Analyst and Programmer. Experience as On-Call 24x7 Production DBA support, application/development DBA. Strong Knowledge of SQL, PL/SQL, Shell Scripts, RMAN, RAC, ASM, Exadata, Golden Gate, Data Guard, Performance Tuning, Grid/Cloud Control (OEM) & Oracle Tools, MS SQL Server, Oracle EBS R12 and SOA Cloud. Technical Skills
• Oracle v7 to 12c, Exadata, RAC, Data Guard, Grid/Cloud Control (OEM), Golden Gate, Oracle EBS R12, SOA Cloud, Streams, SQL Server, Green Plum, Informatica
• Performance Tuning & Monitoring using Explain Plan, SQL Trace, AWR and ADDM
• Database Install,Upgrade, Patching, Character Set/Platform Migration
• Development of Interfaces using Shell, SQL, PL/SQL and SQL*Loader, Shell Scripting for Automation, Backup and Monitoring
• Extensive experience in configuring and implementing ASM, proficiency in using ASMCM, ASMLIB
• Oracle Security, FGA, Data Vault, SOX Compliance, TDE, Data Masking
• Database Consolidation using ZONES, LPARS and VMWare
• Disaster Recovery, Backup & Recovery using Cold, Hot, Export, Data Pump & RMAN, Flashback DB
• Environment Refreshes using Shadow Image, Hot Restore, RMAN Duplication, Export
• Development of Standards, Naming Conventions and SOPs using Best Practices
• Client Server Connectivity using SQLNet, JDBC, ODBC Environment
OS : Linux x86_64 (RHEL), Solaris 5.5 - 5.10, HP-UX, AIX 5.3, Windows XP/7 Software/Tool : Oracle 7 to 12c, RAC, Exadata, ASM, DBFS, Streams, AWR/Stats Pack, OEM 12c, Physical/Logical/Active DataGuard, RMAN, VCS, HP Shadow Image, Golden Gate, OWS, Microsoft SQL Server, Green Plum, Informatica, Developer 9i, Designer, Discoverer, Names Server, Connection Manager, Crystal Reports 9, MS Access, Toad, Spotlight, Footlight, SharePlex, SQL*Developer, VMWare, IBM LPAR, Solaris Zone Scripting : Shell, SQL, PL/SQL, T-SQL
Achievements
• Graded as Outstanding Performer for most part of my career
• Implemented Several Infrastructure Projects on time eg. OEM 13c, Gitlab, Oracle EBS Upgrade, High Availability using Golden Gate, Active Data Guard and Exadata
• Highly Successful Performance Tuning for Data Ware House and OLTP Databases Education
Master of Technology, Production Engineering, 1991, Indian Institute of Technology, Bombay, India Bachelor of Engineering, Mechanical, 1989, College of Engineering and Technology, Bhubaneswar, India Professional Trainings
• Golden Gate, Data Guard, Oracle Security, Performance Tuning, RAC, Oracle 9iAS, RMAN
• Oracle EBS R12 Application DBA
• Informatica Power Centre, Developer 2000
• Software Development Life Cycle
• Tackling the Challenges of Big Data – MIT Online Course Pramod Samal Page 2 of 5
Work History
Risingmonks Energies Pvt. Ltd., Pune, India Sr. Oracle DBA Jul'18 – Present
• Co-Founder/Director
• Client Engagements, Acquiring Projects, Collecting Requirements and Translating to high level designs
• Managing a Team of 8 Members
• Taking care of the Database Design/Implementation in AWS using Oracle/MySQL
• Data Refresh, Backup, Performance Tuning
• Scripting in PL/SQL and Shell for Automation/Monitoring Environment : Ubuntu, 12c, RMAN, Shell, OEM13c, SQL, PL/SQL, MySQL Delta Dental of California, San Francisco,CA,USA Sr. Oracle DBA Jul'17 – Jan’18
• New Server build - Installation of binaries, agents, OEM, ASM
• Database Creation and set-up of Active Data Guard using RMAN
• Assisting with Data Conversion/Integration of DD Arizona Data into Main System
• Data Refresh between Environments using RMAN
• POC for Multi-Node RAC with Active Data Guard
• Administration using OEM Grid Control 13c
• Performance Tuning using AWR/ADDM/ASH, Regular DB health check
• Scripting in PL/SQL and Shell for Automation/Monitoring of Repeated Tasks
• Support for Golden Gate Replication
Environment : RHEL 7, RAC, 12c, Data Guard, Golden Gate, RMAN, Shell, OEM13c, SQL, PL/SQL Silver Spring Networks, San Jose,CA,USA Sr. Oracle DBA Jan'16 - May’17
• Database upgrade from 10g/11g to 12c (Multitenant), Install and Patching
• Installation and Configuration of Oracle Cloud Control 12c (OEM) with DR Capability (Monitoring Templates, Roles, Credentials, Baselines, Reports, Backups, SNMP Traps for Nagios and Configured 300+ Databases. End to End Implementation from Inception
• Extensive Performance Tuning, Health Check, Base Lines using AWR/ADDM/ASH
• Automation/Monitoring using Shell and PL/SQL
• Annual Disaster Recovery Drill using EMC Recovery Point Appliance, Data Guard and RMAN Backup
• New Server build - Installation of binaries, agents, OEM, 11gR2 RAC with ASM
• Database Creation and set-up of Active Data Guard using RMAN
• Oracle EBS and SOA Cloud Support. Oracle EBS R12 - Upgrade from 12.1.3 to 12.2.5, Exadata Support
• Partitioning and re-organization of table and indexes. Environment : RHEL 7, 11gR2 RAC, 12c, Data Guard, RMAN, Shell, OEM12c, SQL, PL/SQL, Oracle EBS R12 Genentech, So. San Francisco,CA,USA Sr. Oracle DBA Nov'14 - Dec'15
• Database upgrade from 10g/11g to 12c (Multitenant), Install and Patching
• Database Creation for Single and Multi-Node RAC with Active Data Guard, DB Migration
• Environment Refresh and Support for Clinical Application upgrades
• Administration for OEM Grid Control 12c
• Database Creation for 12c Multitenant Architecture
• Performance Tuning using AWR/ADDM/ASH, Regular DB health check
• Scripting in PL/SQL and Shell for Automation/Monitoring Environment : RHEL 5, Solaris 5, Exadata, 11gR2 RAC, Active Data Guard, RMAN, Shell, OEM 12c, SQL, PL/SQL Accenture, Sacramento,CA,USA Sr. Oracle DBA Jul'14 - Oct'14
• Exadata - Implementation, Migration of Databases to Exadata for CalHEERs Project(Obama Care)
• DB Vault, Label Security, FGA Administration, TDE
• Compression and Archival of Transient Data, Audit Logs and FGA Logs Pramod Samal Page 3 of 5
• Database Creation for RAC 1 and Multi-Node RAC with Active Data Guard
• Disaster Recovery Exercise, Performance Tuning using AWR/ADDM/ASH
• Scripting in PL/SQL and Shell for Automation/Monitoring
• Regular DB health check, DB archival and partition maintenance, Tuning Environment : RHEL 5, Solaris 5, AIX 5.3, VCS, Exadata, 11gR2 RAC, Active Data Guard, RMAN, Shell, OEM 12c RSI & ESS, Roseville,CA,USA Principal Technical Architect Nov'13 - Jul'14
• Capacity Planning, Estimate and Technical Proposal for Hardware/Software for New Clients
• Annual DR Exercise for Various Customers
• Database and Security Guidelines/Standards, Performance Tuning
• SQL Server Administration for 200+ Databases, Data Architecture and Modeling using ER Studio
• Script Review and Preparation of Release Scripts (T-SQL and SQL) Environment : Solaris 5, VCS, Windows XP/7, 10g RAC, Data Guard, RMAN, Shell, SQL*Developer, SQL,T-SQL, PL/SQL, SQL Server 2008, E/R Studio
Franklin Templeton Investments, Rancho Cordova,CA,USA Sr. Oracle DBA Sep'10 - Oct'13
• Implementation and Migration of Databases from Oracle to Exadata X3-2 BP 16. Lead the implementation from inception to Operation. Exadata Quarterly Patching and Bundle Patching
• Design, Capacity Planning, Guidelines/Standards, Performance Tuning
• Regular DB health check, DB archival and partition maintenance, DB environment refreshes
• Database Creation for Single and Multi-Node RAC using DBFS, ASM, OEM, Active Data Guard
• Supported a Number of Financial Apps in Exadata, GreenPlum and Oracle in both OLTP and Data Warehouse
• Annual DR Exercise using SRDF and RMAN
• Technical Lead for the High Availability Implementation using Golden Gate Bi-Directional Replication
• Informatica Administration and Green Plum Support with ZFS File System, Upgrade from 3.3.6 to 4.1.0, Migration from Oracle
• Scripting in PL/SQL and Shell for Automation/Monitoring
• Implementation of Changes from Data Model to the Database(Release), Oracle Patching / Upgrade, Application upgrades.
• Defining the build requirements, space requirements, configuration for new server built, sizing and capacity planning
Environment : RHEL 5, Solaris 5, Green Plum 4, Informatica 9, Exadata, 11gR2 RAC, ASM, Active Data Guard, Golden Gate 11g, RMAN, Shell, OEM, Tivoli, BMC Patrol, TOAD, SQL*Developer, SQL, PL/SQL NEC America, Rancho Cordova,CA,USA Sr. Oracle DBA Jun'10 - Sep'10
• Identity Management Application Support (Finger Print System)
• Setting up new Servers with Installation of binaries, agents, grid control, ASM, 11gR2 RAC with ASM
• Creation of instances, tablespaces and schemas using the supplied data models/documentation
• DB environment refreshes using RMAN, Export, Hot backups
• Batch Data Loading using SQL*Loader, Shell, PL/SQL Scripting
• Standards, Naming conventions and Processes, Performance Tuning using grid control, AWR and ADDM reports. Tuning for disk contention, fragmentation, tuning of SQL queries/views and PL/SQL packages, Regular DB health check
Environment : RHEL 5, Solaris 5, Oracle 10gR2/11gR2, RAC, TOAD, SQL*Developer, SQL, PL/SQL, Shell, RMAN SanDisk, Milpitas,CA,USA Sr. Oracle DBA Feb'10 - Apr'10
• Support for SAP R2 System, GIS, Channel Management, Agile, Aris, BI, Equity Edge, ITSM, Tax Stream
• Batch Data Loading using SQL*Loader and Shell Script from SAP to DW
• Database Upgrade from 10g to 11g, Patching, Database Creation and Data Guard Setup
• Setting up new Solaris Zones machines, Installation of binaries, agents and grid control
• Regular refresh of SAP databases from prod to other environments using HP shadow image and RMAN
• Extensive use of partitions, materialized views and triggers Pramod Samal Page 4 of 5
• Setting up disaster recovery environment in Milpitas for Sacramento Production Environment, setting up physical standby databases
Environment : Solaris 5, Oracle 10gR2/11g R2, Data Guard, VCS, SQL, PL/SQL, Shell, RMAN, SAP R2 Blue Shield of California, El Dorado Hills,CA,USA Sr. Oracle DBA Jan'09 - Jan'10
• Server build using LPARS on AIX - installation of binaries, patches, agent, DG, ASM, VCS, Grid Control
• Database creation, upgrade, patching, cpu patching, character set conversion, consolidation of ASM Disk Groups/Rebalancing, setting-up logical standbys
• Database tuning using Grid Control, AWR/ADDM/STATSPACK, tuning of disk contention, fragmentation, SQL queries/views, PL/SQL packages, bind variables, SQL Trace
• Application Install and Patching, Regular DB health check and archival using partition exchange
• Building Interfaces using stored Procedures/Functions/Packages, SQL*Loader and Shell
• Setting-up Disaster recovery environment for Shield Advance project using Logical standby
• Define the build requirements, space requirements, configuration, sizing & capacity planning
• Defining high level standards and guide lines using naming standards, coding standards, backup standards, best practices for performance
• Feasibility study and proof of concept for new technologies e.g. Solaris containers, cloud computing, 11g implementation, VCS with ASM, 11gRAC
• Environment refresh using RMAN duplication
Environment : AIX 5.3, Solaris 5, Oracle 10gR2/11gR1, Logical Standby, VCS, SQL*Developer, SQL, PL/SQL, Shell Wells Fargo, San Francisco,CA,USA Database Analyst 5 Feb'08 - Dec'08
• New Server Build using VMWare, Installation of Oracle binaries, patches, agent, DG, OEM Grid Control
• Database tuning using Grid Control, STATSPACK/AWR, disk contention, fragmentation, SQL queries/views, PL/SQL packages, SQL Trace
• Database upgrade, patching and consolidation to single VMWare server
• DR Set-up using Data Guard, DG Broker, Streams, VCS and Physical Standby
• Cross Platform Database Migration, Application Support for Financial Applications
• Configuration of Monitoring Alerts using CRON and OEM Grid Control
• Application Support for – SIMS, IA, Bill Pay, wellsfargo.com, Documentum, FX AAA, P2P, vSafe, Amber Point, WIKI
Environment : VMWare ESX 3.x, Solaris 5, RHES 3/4/5, Windows 2003, 10gR2, Data Guard, Toad, SQL, Shell WebEx/Cisco Systems, Santa Clara,CA,USA Sr. Oracle DBA Jul'07 - Feb'08
• 10g RAC, SharePlex Replication, Streams Replication
• Database Tuning using Grid Control, STATSPACK/AWR, Fog light, Spotlight
• Database Consolidation to minimize usage of Materialized views and DB Links
• SOX Security Implementation and establishment of security policies
• Support for the Oracle Applications 11i Upgrade and Environment Refreshes
• Application Support for – SIMS, IA, Bill Pay, wellsfargo.com, Documentum, FX AAA, P2P, vSafe, Amber Point, WIKI
Environment: Solaris 5, RHES 3/4, Sun Spark, Dell 2850 and HP-Itanium, 10gR2 RAC, Data Guard, Streams, VCS, TOAD, Fog light, Spot Light, SharePlex, RMAN, Shadow Image, PL/SQL, Shell, Oracle Apps 11.5 MobiTV, Emeryville,CA,USA Sr. Oracle DBA Nov'06 - Jul'07
• Performance Tuning for Database/Application. Brought down from a Crashing Situation to Normal Operations.
• Monitoring Scripts using Shell, SQL, OEM Grid Control
• Development of Standards/Procedures, Sizing/Capacity planning for the OLTP and Data Warehouse
• Server Build using RHAS/Solaris 5.10 - Binary Install, Patching, Agent, Grid Control
• DB Upgrade and repeatable deployment process using RPM
• Creation of Materialized Views for data warehouse tables, Partitioning maintenance Pramod Samal Page 5 of 5
• Database tuning using Grid Control, STATSPACK/AWR/ADDM, SPOTLIGHT, SQL queries/views, PL/SQL packages, identifying SQLs to use bind variables
• SQL*Loader and cron scripts to load data from OLTP Database to the Data Warehouse
• Client installations, SQLNet, JDBC, ODBC connectivity issues Environment: RHEL4, 10gR2 RAC with Data Guard, OEM, Streams, TOMCAT, PL/SQL, Shell, Spotlight Novartis Vaccines & Diagnostics, Emeryville,CA,USA Lead DBA Nov'99 - Nov'06
• Configuration of 9i AS, Apache Web Server, Forms and Reports, 9i RAC
• Backup and Recovery using Conventional Cold, Hot, Full Export, Data Pump and RMAN
• Names Server, Connection Manager, Client installation, SQL Net, JDBC, ODBC
• Interfaces to pull Data from SAP using Shell Scripts, PL/SQL and SQL Loader
• Development of Custom Applications using Developer 6i/9i
• Database validation using DQ, IQ, OQ and PQ for FDA Validated Systems
• Application Support for Clinical Applications eg. ClinTrial, CTMS, Argus Safety, Documentum Environment: Solaris 5, Windows 2000/2003/NT/XP, VMS, Oracle 7/8/9i/10g, Oracle Developer 6i/9i, SQL*Loader, OWS 4, Oracle 9iAS, 9i RAC, VCS, OEM, ER Studio 6.5, PL/SQL, Shell, TOAD, Crystal Reports 9 Parallax Solutions, Oracle Corp., England,UK Oracle DBA/Developer Jun'98 - Sep'99
• Design/Development of Template Forms/Reports, PL/SQL Objects, Batch Scripts
• Test Plans, Unit/Module Testing and Bug Fixing
Environment: HP Unix, DEC Alpha, Oracle 7/8, Designer 2000 R2.1, PL/SQL, Forms 4.5, Reports 2.5, PRO*C Tata Consultancy Services, Mumbai,India Sr. System Analyst Apr'97 - May'98
• Database Design, Schema building, Development of Forms/Reports for Customer Service Module
• Tuning and Optimization for Integrated Information System (Grindwell Norton)
• Test Specification, Unit/Module Testing, Bug Fixing, UAT
• Design and Development of PL/SQL Libraries
Environment: DEC Alpha, Oracle 7, SQL*Plus, PL/SQL, Designer 2000, Developer 2000(Forms 4.5, Reports 2.5) Larsen & Toubro Ltd., Mumbai,India Production Engineer Nov'93 - Mar'97
• Die and Punch Design for Ellipsoidal Dished Ends, Die and Punch Design for Knuckled Tube Sheets, Employee Performance Appraisal System, Analysis of Landed Inserts
• Design and development of template forms, Database design and creation, Design and development of forms, reports, packaged procedures, libraries, Tuning and optimization of code
• Preparation of test specification, Unit/Module/System testing and bug fixing Environment: Windows 3, Oracle 7, PL/SQL, Developer 2000, C, ‘Q’ Basic, FORTRAN 77, DBase III Walchandnagar Industries, Pune,India Dy. Chief Tool Design Engineer Mar'91 - Oct'93
• Development of systems and procedures in the manufacturing area, Study of manufacturing processes, improving the existing methods and processes, Study of product design and establishment of manufacturing processes, Computer aided design using AutoCAD, NC and CNC programming
Contact this candidate