Sr Oracle Dba Resume
SUMMARY:
- 19+ years of IT experience working in different capacity as a Sr Consultant/SME.
- Experienced in Oracle Exadata Machine administration which include Installation using OECA, Administer DB nodes, Cell servers, Cisco switches, Infiniband, PDU, Patch Oracle Exadata Infrastructure
- Delivered responsibilities as Linux Admin, Network Admin, Infrastructure Architect, Oracle Exadata Administrator, Sr Oracle DBA, Application Architect, Architect Business Solutions, design and develop IoT embedded systems, Project Management etc on large projects.
- Diversified functional/industry experience with different functional areas including software development, finance, marketing, healthcare, payroll, energy companies, oil & gas, telecom etc. with top clients including Oracle, SIEMENS, IMF, JP Morgan Chase etc.
- Excellent experience in the installation, configuration & administration of LINUX (RedHat, SuSe, Oracle), UNIX (Solaris, AIX); Oracle DBA and Oracle ExaData administration.
- Excellent experience in performing various administrative tasks using Perl, Unix Shell Scripting.
- Experience in virtualization using Oracle OVM and is experience in Oracle Databases 11gr2 & 12C, Oracle WebLogic 12c/11g, AWS etc.
- Solid experience in various technologies including Oracle ODA, OEM 13c/12c, Oracle E - Business Suite (GL, HR, PO, AP, AR, FA, PA modules), Oracle identity & access management (IAM), Oracle PL/SQL, Oracle PeopleSoft HR/Finance, People Code, People tools, Oracle EBS in RAC 11gr2 environment, SAN storage, Networking.
- Experience includes system and network security, database security, application security, encryption, Oracle RAC Installation, data modelling using Erwin, Oracle App DBA for SAP, Oracle PeopleSoft DBA, Architect solutions in DW using Informatica, Oracle jDeveloper, Oracle SOA Suite, Oracle MAF, Oracle SOA, Oracle Apex, Oracle ZFS etc.
- Experience also includes Java, C++, VC++, Warescape, NFS, ACFS, BigData exposer on Hadoop cluster, Apache HDFS, Apache Pig, hive, HBase, Apache Sqoop, Oozie, Data lakes, BMC scheduler, Amazon Oracle RDS, Amazon SQL Server RDS and more.
- Install configure Oracle MySQL Server 5.5.62 on LINUX environment, configure MySQL database engines for large transaction volumes and concurrency
- This candidate has very good communication and inter-personal skills.
- Worked in agile development environment with frequent incremental and continuous code testing (CI) and deployment (CD) processes and tools.
- Working knowledge and exposer to Idoru, Artifactory, Hudson, Selenium
- Design and develop PL/SQL packages, procedures, functions for OLTP / DW environment
- A pplication development using agile methodology
- Build deploy Oracle SOA Middleware Infrastructure, Design Oracle Service Bus and SOA components, Design develop services for CURD operations, Design and develop JMS messaging services on Oracle Weblogic 11g and Weblogic 12c Infrastructure.
- Design GRID Link data source, configure JDBC connection pool on Oracle Weblogic 11gr2 infrastructure, Configure ONS notification and subscribe ONS notifications on GRID Link data source.
- Administer and maintain Oracle ODA x7-2 appliances, update database appliance software, manage storage, network, Configure ASM storage, Administer Oracle 12c database on appliance using oakcli
- Oracle Applications DBA, Support Oracle databases running e-business suite 11.5.10.2, perform database upgrades, Code migration, database patching and performance tuning of ebs application and databases.
- A dministered & Maintained BIG Oracle databases of size 60 Terabytes on exadata machine, which includes Backup and recovery using ZFS, Performance tuning on exadata
- Application development using JavaScript, XML, HTML and CSS - front end, SOAP, REST - Backend, GitHub, BitBucket, Tomcat, Java and J2ee, Oracle SOA/ Webservices, JMS messaging services
SKILL SET SUMMARY:
Oracle Exadata X5-2, X6-2, Oracle Exadata Machine administration, Configure & Administer cell servers, Oracle RAC 11gr2, Oracle 12c, OEM 12c, OEM 13c, WebLogic 11gr2, WebLogic 12c, Oracle SOA, Oracle JMS, Oracle GRIDLINK datasource, JDeveloper MAF, C++, Perl Scripting, Shell Scripting, JAVA, Oracle OID, Oracle EBS, Oracle PeopleSoft, Oracle DataGuard, RMAN, LINUX, IBM AIX, HP UX, Sun Solaris, ERWIN, Database logical and physical modelling, Informatica, Warescape, SQL Server 2000, Oracle ODA, Oracle golden gate 12c, Oracle EBS R12 Patching, MySQL Database administration, Oracle XDB configuration
EXPERIENCE SUMMARY:
Confidential
Sr Oracle DBAResponsibilities:
- Design and develop data centers on Oracle cloud infrastructure for hosting Oracle PeopleSoft ERP applications.
- Design and deploy templates to create compartments to host DB compute nodes on LINUX VM servers. Capacity planning and designing shapes for DB compute VM.
- Lift and shift Oracle PeopleSoft databases on to Oracle Cloud using golden gate.
- SQL and DB Performance tuning of PeopleSoft databases on Oracle 12c containers.
- Patching Oracle Cloud Infrastructure Cluster Ware, RDBMS & Databases
- Administer Oracle Enterprise Linux (OEL) and Oracle VM Manager (OVM). OS updates on OEL and VM manager.
- Setup VCN Networks on Oracle Cloud, setup routing tables, Firewall screens, subnets, NFS storage, Oracle object storage configuration and more.
- Design / Develop terraform scripts for deploying Oracle VM compute instances, configure and update VM instances hosting Oracle databases on OCI cloud.
- Version Infrastructure templates, patching, configuration etc using terraform scripts.
- Interact with Oracle Cloud API’s and JASON payload using terraform scripts.
- Define relationship and dependency between different components of cloud infrastructure using terraform tools.
- Modular Infrastructure configuration for reusability.
Confidential, Chicago
Sr Oracle DBAResponsibilities:
- Administer Oracle Exadata X5-2 machine, Administer cell servers, Administer Infiniband switches, Cisco Switches, Update DB nodes, Administer Exadata using ILOM console, Administer PDU, Configure resource manager, IORM, Consolidate 12c Multitenant container database for application workload, Configure Active data guard, Configure Golden gate, Performance tuning of Exadata infrastructure.
- Exadata X5-2, X7, Oracle Golden gate, IBM CDC, DD Boost, OEM 13c, Oracle 12c Multitenant databases, Oracle 12c Dataguard, Oracle LINUX, Oracle Exadata cloud,, oracle golden gate, IBM CDC.
- OS and cell updates on Exadata infrastructure.
- System life cycle management and change management . Provide strategy for consolidation of application work loads on Confidential Exadata Farm. Strategy to configure DBRM and allocate system resources to 12c PDBs.
- Install configure Oracle MySQL Server 5.5.62 on LINUX environment, configure MySQL database engines for large transaction volumes and concurrency.
- Configure Oracle MySQL cluster. Configure MySQL, Oracle Apex, Design Webservices using Apex, application connectivity and trouble shoot application connection issues.
- Shell scripting to support infrastructure work.
- Design and develop data lake application using Spring batch and Cassandra for small CHASE merchants to manage and view there invoices, payments etc.
- Install configure Cassandra database on AWS cloud, Configure cqlsh for Cassandra database connectivity, create keyspace, cql for creating database objects, configure gossip, replication across Cassandra cluster, configure commit logs, datafiles .
- Configure Cassandra instance for memory and performance in cassandra.yaml file.
- Install configure HDFS file system, configure HDFS cluster on LINUX, set replication factor.
Technology: Exadata X5-2, Hadoop, JAVA, JDK8, Tomcat, HTML5BIG Data Hadoop, Apache Pig, hive, HBase, Apache Sqoop Oozie, Cassandra database, Mango DB, HTML5, CSSBootstap, JAVA Script, Node JS, oracle golden gateOracle golden gate BIG data adaptor
Confidential, Kansas City, KS
Sr Oracle DBA
Responsibilities:
- Install configure Oracle Exadata X7-2 using OECA, Configure cell servers, ASM Flash Disk, Cell Disk, Infiniband, Cisco switches, PDU, Configure ILOM, SNMP traps, ASR configuration, Discover Exadata Infrastructure on OEM, Install configure ZFS heads, Configure RMAN backups on ZFS, Configure DB compute nodes, Exadata Infrastructure reboot, Patch Exadata Infrastructure DB nodes, Cell servers, Infini band, Cisco switches, PDU
- Patch Oracle Exadata Infrastructure which include OS, cell updates, patch infiniband, cisco switch, PDU on Oracle Exadata infrastructure.
- Shell scripting to support infrastructure work.
- Administer and configure ZFS appliances, configure ZFS on DB compute nodes on Exadata infrastructure.
Technology: Exadata X7-2, ZFS Machine Admin, oracle golden gate
Confidential, Danbury, CT
Sr Oracle DBA
Responsibilities:
- Migrate oracle databases on to AWS and performance tuning of databases using AWR, ADDM, ASH.
- Database backup and recovery using RMAN.
- Performance tuning of SQL statements.
- Support PeopleSoft ERP applications on Exadata infrastructure, Database performance tuning using AWR, ADDM, ASH.
- Database RMAN backup and recovery, Active Dataguard configuration, Setup Golden gate replication on HR and Finance databases.
- Performance tuning of SQL statements. Shell scripting to support infrastructure work.
Technology: Oracle ExadataOracle PeopleSoft, oracle golden gate