| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLESUMMARY:Over 20 years of experience in Oracle Technology, Administration5 years of experience in Oracle RAC database administration2+ Year experience in ATLAS and FACETS application patching and maintenance2+ Years of experience in Oracle Apps, OBIEE Administration & Development15+ Years of experience in all oracle tools like PL/SQL, SQL Loader, expdp/impdp,Installed and upgraded ORACLE 19c/13c/12c/11g/10g RAC and ASM on Linux and AIXInstalled and Configured Linux VM and Configured Oracle HA ClusterDesigned, Developed, Installed and Configured Oracle13c OMS Cloud ControlCreated backup scripts and Automated RMAN Backup & Recovery operationsExpert level knowledge in Oracle Tools and UtilitiesImplemented security plans for a secured Oracle environmentCreated entity relational data model Star and Snowflake schemasDesigned and developed OBIEE Repository (.rpd), Dashboards and reportsDesigned and managed ETL feeds and data extraction and loadsSound knowledge of IBM, HP_UX, Sun Solaris, Linux AdministrationDeveloped OEM and Shell scripts to monitor and maintain databasesDesigned and developed several applications using COBOL, ORACLE and OBIEE5 years of experience in batch and on-line processing using COBOL and JCL1 Year experience in supporting Oracle19c on AWS CloudSKILLS:RDBMS: Oracle(19c/13c/12c/11g/10g/9i/8i/7.x/6.0), RAC, SQL ServerOBIEE: OBIEE, Web logic, BI Publisher/Interactive Dashboards/AnswersOracle Tools: Cloud, Golden Gate,ASM, RMAN, OEM/OMS, Active Data Guard, OCR, ADDM/AWR,SQL Developer, APEX, PL/SQL, SQL, Datapump, SQL*Loader, WebLogic, ShareplexETL: VISIO, Oracle Warehouse Builder, COGNOS, InformaticaOS: Linux, OCFS2, AIX, Sun Solaris, HP-UX, WindowsOther: Shell script, DPA, Spotlight, DB Artisan, Banner, TOAD, ERStudio, Erwin, Java, XML & COBOLWORK EXPERIENCE:11/2019 to Current: Sr. Oracle DBA, Orbcomm, Oracle Cloud, ODA Oracle 19c/12c/11g RAC One node, AWS,Linux 5/6,Dataguard, OEM, RMAN, ACFS, Datapump, APEX, SQL-Loader, PLSQL, Toad, DPAWorking as Database Architect, Database Designer and Senior Database AdministratorResponsible for providing all aspects of Database Engineering, Administration, support ing multi TB DatabasesInstalled Oracle12c database software and Oracle12c Golden Gate softwareDesigning proposed system; defining database physical structure, schema objects as per MAA architecture.Identified and resolved database performance issues and OS level changes required on the servers.Worked on Database performance issues and changed database structure and parameters for better performanceRecommended best partitioning and indexing strategies for performance and ease of maintenanceWrote many data massgae plsql procedures to delete, update, move and backup Terrobytes of data.Designed partition pruning, converted non-partition big tables to partition tables and loaded dataConverted Interval partitions to Range partition tables for ease of maintenanceSeparated database tables and indexes as per the application designSupporting Oracle and AWS Cloud, Production, QA, Test and Development EnvironmentsDeveloped Application Development using Oracle SQL, PL/SQL, and APEXWorked on data loading from flat files to fact and dimension tables using SQL*Loader06/2014 to 3/2019: Database Administrator,1-800-Flowers, Oracle 13c/Oracle12C/11G/10g, AIX, Linux,SUN OS, OEM, RMAN, Shareplex, Flashback, Datapump, SQL Developer, ToadMaintaining and supporting multi terra-byte Oracle Apps and Oracle databases.Managed Oracle Database, Oracle EBS and Offshore database teamInstalled and configured Bi-directional Shareplex to replicate Oracle-to-Oracle replication.Ensuring CDC, Shareplex and Oracle Standby databases are refreshed from time to time.Installed and Upgraded Oracle 11g database to Oracle 12 Rel 2.Designed, Developed, Installed and Configured Oracle13c OMS Cloud ControlDesigned RMAN Backup and Recovery operations and ensure successful backups taken everydayWorking with SA team and make sure there is enough storage is allocated for database growth.Experience in SOX IT General Controls compliance in the areas of Change management and approvalsMigrated ATLAS, MBP to new platforms, identify and decommissioned/EOL databasesActively involved in in-house application deployments and migrationsCreated SQL, PL/SQL and Shell scripts to provide periodic reporting and database monitoringWorked on PUPPET auto setup on Linux and Oracle 12c documentationMigrated Oracle databases from Unix to Linux 7 environment and Oracle 12cProvided solutions for critical performance problems and improved database overall performancePerformed code reviews and identified logic flaw and gave recommendations to development teamsTuned SQL Queries using explain plan, TKPROF with SQL trace and SQL Tuning AdvisorCreated and Monitoring RMAN Full, Archive log and export backupsHandling day-to-day DBA activities and proactively working on database related issues and problems.Providing 24x7 on-call support and coordinating with off-shore DBA teamManaging DBA Team and supporting enterprise Oracle database operations12/2011 to 03/2014: Database Administrator, CDPHP, oracle12C/11G/10g, AIX, Linux, SQL Server, FACETS,ASM, OEM, RMAN, Golden Gate, Flashback, Datapump, SQL Developer, ToadSupported FACETS application and applied monthly Trizetto FACETS patchesInstalled and configured Oracle12c/Oracle11g Oracle on Linux/AIX serversTested and implemented 12c/11g new features Multi-Tenant and Flashback databaseAutomated Fair Health Dental, HCPCS, MDR(Medical & Dental), Configuration backend loadsDesigned, developed environment refresh schedules using Datapump and Golden GateCreated RMAN catalogs, configured RMAN backups and restored the databases from corruptions.Provided solutions for critical performance problems and improved database overall performancePlanned system growth and monitored database capacity usage for new hardware requirements.Worked with architects and archived historical data, moved data to various data martsDeveloped detailed documentation for FACETS patching, DR proceduresProvided on-call support in adherence to specific business and customer Service Level Agreements09/2011 to 12/2011: Oracle DBA, Database Designer, Verizon Wireless, Oracle11g, Linux/HP-UX, OEM, RMAN, SQL Developer, PL/SQL DeveloperInstalled and created and upgraded Oracle 10g/11g R2, OEM, Grid Control and Oracle databasesDeveloped and setup database monitoring and maintenance scripts in UNIX and OEMRefreshed and Clone Databases as per customer requirementsMaintained and supported multi-terabyte Data Warehouse and OLTP Production and Development databasesImplemented backup and recovery using RMAN in all environmentsPlanned for system growth and monitor capacity usage for new hardware requirementsWorked directly with software developers to develop and enhance applications and data conversions.Provided technical guidance to DBA staff, Consultants and application developers5/2007 to 3/2011: SUNY, Oracle 11g/10g RAC DBA, Database Designer,Oracle11g/10g RAC, Linux, OCFS2, OEM, OBIEE Admin/Developer, Dashboard, Answers, PL/SQL Developer, VISIO and BannerInstalled and configured Grid Infrastructure and Oracle RAC databasesImplemented 2 Node RAC databases, Data Guard, Standby database with OCFS2 on LinuxMigrated Oracle 10g RAC/ Non-RAC Oracle databases to Oracle 11gR2 RAC using RMANPopulated RAC databases using datapump from stand-alone database instancesDesigned and developed the Siebel Analytics Metadata Repository (.rpd) for SUNY students repository databasesWorked extensively with Physical Layer, Business Layer and Presentation LayerCreated different types of Customized Reports Drilldown, Aggregation to meet client requirementsManaged security privileges for each subject area and dashboards according to user requirementsImported Dimensions, Facts & Aggregates with Referential Integrity constraints into Physical LayerDesigned and developed backup and recovery strategy using RMAN, configured automated OCR backupsDesigned Source, Staging area and Target tables, transformation and relationshipsDeveloped BI dashboards, Answers requests, charts, pivot table layouts, dashboard promptsSQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning Advisor3/2004 to 5/2007: Database Management Advisory, JPMorgan Chase, Oracle10g/9i, Oracle10gAS/9iAS, Customer Profitability WarehouseSupported Oracle, OracleAS, Infrastructure, Middle Tier componentsInstalled and upgraded Oracle9i/10gAS and applied Oracle patches to Oracle and Oracle9iASImplemented standards across the systems and databasesConfigured the kernel parameters on Sun Solaris and installed and created Oracle databasesCustomized the environment setup scripts for Oracle and OracleAS instancesDeveloped and Customized RMAN backups and tested the recovery procedures with user participationCustomized the database as per the security baselineDeveloped scripts to create, update, start and stop Oracle10g/9i Portal, J2EE, and BI_FormsDeveloped scripts to deploy, redeploy and un deploy Oracle10g/9i Portal, J2EE, and BI_Forms8/2002 to 3/2003: NY State, Oracle DBA, OTDA Warehouse Database, Oracle9i on HP-UX 9000 64BitImproved database performance by splitting the very large partitions in to small partitionsTested and implemented locally managed tablespaces with extent managed auto featureCreated and maintained the automatic managed UNDO tablespacesRestored and recovered the databases from media failuresIncreased database performance by modifying the database structure and memory parametersCreated scripts to extract and load the data in to the warehouse database from text filesCreated PL/SQL procedures to move data to resolved, pending, reject target tablesIdentified and created required bit map indexes for query performance4/2000 to 5/2002: FIDELITY INVESTMENTS, Oracle DBA for Equity Trading Warehouse databases, Oracle8i/9i, Sun Enterprise 6800/4500Monitored and maintained Oracle distributed Trading databases across the globe 24/7Created and maintained the snapshots for the required tables from the remote databasesDesigned and Maintained Yearly/Monthly/Weekly/Daily partitions based on requirementsDesigned and automated the process to create the tablespaces for these partitionsAutomated archival process to purge older data and to load to the historical databaseEDUCATION: Bachelors Degree in Science, Diploma in Computer Science |
