We provide IT Staff Augmentation Services!

Oracle Dba Resume

New York, NY

SUMMARY:

  • Oracle DBA with over ten years of experience
  • An Expert in Backup & Recovery
  • Master of SQL query performance tuning
  • A unique DBA, who started the career as a Developer
  • Certified in all Oracle Database versions beginning from Oracle 8i to 12c.
  • Clear concepts of internals - How a query travels from the client to the database & back.
  • Guru in High Availability solutions like RAC, Standby databases, Data Guard, Golden Gate
  • Fast problem solver with OEM Grid Control, Exadata and Big Data Appliance
  • Oracle Forms & Reports,Apex Developer. Expert in Stored Procedures, Functions & Packages
  • Robust in ETL warehouse data integration, Oracle Data Integrator workflows
  • Certified SQL Server DBA. Expert in T-SQL, Reporting (SSRS) & Integration Services(SSIS)
  • Languages: SQL, PL/SQL, T-SQL, Postgres SQL, Spark Scala, Java, Python, Unix Shell Scripting
  • An out-of-box thinker, team player, mentor and a leader in innovative ideas
  • A clear picture of Big Data Hadoop Ecosystems. JSON format logs import into the HDFS. Running of Big Data SQL at HDFS & Hive (AVRO) External tables, Integration via Oracle Data Integrator, Oracle Loader for Hadoop and Sqoop. Data Miner and R Analytics use to predict future models.

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Oracle DBA

Responsibilities:

  • Supporting Ellucian Banner 9 ERP Applications with Oracle 11g databases for Admission, HR, etc.
  • Creating new Physical Standby databases for disaster recovery. Created documentation.
  • Mentoring DBA team with performance tuning of SQL queries while using OEM 13c.
  • Created alert email system for databases and hosts using OEM 13c.
  • Wrote scripts to startup and shutdown of the databases, listeners and OEM Agents with scripts.
  • Cloned databases using RMAN DUBILICATE. It is required for migration to new hardware.
  • Applied latest Security Patches to the databases, OEM 13c OMS, Agents and Plugins.
  • Configured daily online backups for databases using Cloud Control. Supported Museum App.

Confidential, Brooklyn, NY

Oracle DBA

Responsibilities:

  • Helped current DBAs to use OEM 12c Tuning Adviser as a tool for performance tuning.
  • DBA support for Production, Development and QA databases running Oracle 11gR2.
  • Performedquarterly Patching and maintenance of QA, Staging, and Development .
  • Automated patch deploymentusing Enterprise Manager.
  • Improved 24/7 alert and maintenance of databases by solelyconfigur ingOEM Alert Rules.
  • Configured daily backup using Enterprise Manager.
  • Added new devices to RAC Cluster s and with ASM disk storage.
  • Providing OS level support as Linux Admin as there are none.
  • Improved workload times by configuring SQL Profiles on queries.

Confidential, Montvale, NJ

Oracle DBA

Responsibilities:

  • Created POC environment on Exadata X3 two RAC Clusters. Installed Golden Gate.
  • Restricted privileged access to data using Database Vault and Audit Vault with Advanced Security Options (ASO).
  • Securedata at rest using Encrypted tablespaces with a Database Wallet having a master key. Laid out Master Key rotation policies.
  • Configured GDS (Global Data Service) Application to provide transparent servicefailover across multiple RAC clusters.
  • Installed and configured Oracle Enterprise Manager 12c Cloud Control for monitoring.
  • Migrated data from Mainframe Unisys 2200 to an Exadata5 -2 machine running 12c RAC cluster. Data sync using Golden Gate replication.
  • DR useGolden Gate replication, Active Data Guard and ZDLRA (Zero Data Loss Recovery Appliance). It provides block-level backup sync at both primary and DR site.
  • Configured Golden Gate replication using ACFS ASM shared afile system. Created Golden Gate resource in a RAC Cluster for failover.
  • TrainAS400 staff to use Linux and Oracle Database 12c to maintain data.
  • Provided solution to upgrade large 4 TB databases from Oracle 11g to 12c which had a physical standby database. Upgrade used plugin method of 12c package DBMS PDB.
  • Secured primary data by creating an Oracle 12c Data Guard Active Standby database.
  • Worked in Cloud connecting Exadata with Oracle Big Data Appliance to bring Hadoop HDFS data into an Oracle database. Used Flume to extract web logs into HDFS and NoSQL databases. Created Hive JSON external tables. Joined them with data warehouse external tables to integrate data. Ran R queries to analyze data and predict future models.
  • Configured customized email notification system for all targets in Oracle Cloud Control 12c.
  • ConfigureGolden Gate High Availability solution for Data Warehouse running over 11g RAC.
  • Performed Oracle Golden Gate installation on the source and target servers with Data Pump.
  • Loaded target tables with Golden Gate Initial Direct Load and Direct Load to File methods.

Confidential, New York, NY

Oracle DBA

Responsibilities:

  • Consultant to help create RAC clusters on Linux with ASM. Provide DR & high availability solutions.
  • Cut down runtime for 90% of heavy queries from 10-20 minutes to under a second.
  • Convinced DBA team to use EM12c for troubleshooting, admin & performance tuning.
  • Resolved mysterious date timestamp issue relating to time zones of listeners and database.
  • Introduced latest methods of SQL monitoring & tuning using EM12c. They were using old methods.
  • Set up two nodes 11gR2 Linux Redhat 6.4 RAC Cluster with ASM & Data Guard.
  • Configured Single Node Standby database for a three node RAC. Wrote ETL routines.
  • Cloned databases using RMAN Active Duplicate. Configured a 3-node Linux RAC Cluster
  • Extended two nodes RAC cluster to three nodes & instances.
  • Upgraded OEM 12c. Upgraded OMS, Repository& Agents.
  • Provided OEM Read-only access to developers. Trained them to tune their queries themselves.
  • Provided performance tuning of ATG book buying application without touching the source code.
  • Deployed ASM disk groups over Violin flash drives using 4K sector size blocks.
  • Installed SQL Server 2014. Set up backups. Tuned SQL queries in Management Studio.

Confidential, New York, NY

Oracle DBA Engineer

Responsibilities:

  • Served one year in Federal Reserve National IT as Production DBA at New Jersey location.
  • Solely developed two in-house applications from scratch called Dashboard & Calendar. Applications used secure SSL HTTPS connections and Active Directory LDAP authentication. They were built using License free Oracle Application Express (APEX). Dashboard provided real-time status of hosts & databases. Managers used them to know information about applications and check the current status of all servers. Live data pulled from Grid Control, Postwar databases with local tables. BI Publisher used to publish formatted reports and customized forms.
  • Set up Enterprise Manager EM12c Cloud Control with Sun Enterprise Directory LDAP Authentication using WebLogic server. Integrated Oracle Ops Center 12c and Oracle VM.
  • Wrote Partitioning Procedures for Data Warehouse application to partition data on daily, weekly and monthly basis. Procedures are running in all Production databases error free since Feb 2009.
  • Implemented Oracle Wallet for secure database connections used by applications.
  • Implemented Data Masking procedures in the Markets Department. It is used to mask Production data with real looking fake data, which used in Development environments.
  • Established new rules for DBA access auditing in applications and databases.
  • Installed six-node 11gR2 RAC cluster on AIX with ASM, Grid Infrastructure with RAC One Node databases. Set up disaster recovery with Data Guard at three nodes cluster.
  • Supported RAC and ASM and RAC One Node. Created services for users.
  • Responsibilities include Production ProblemsDebugging and Performance Tuning of slow queries.
  • Provided Tier-3 performance tuning support of Data Warehouse&OLTP slow query problems.
  • Implemented Oracle Grid Control 11g with Cold Failover Cluster (CFC) set up.
  • Prepared storage pool of ASM disks for Oracle Automatic Storage Management ASM on a two node Linux cluster using Oracle ASMLib.
  • Installed and configured Oracle Grid Infrastructure release 11.2 for RAC on two nodes Linux cluster. Configure ASM Disk Groups for OCR and Voting Disk files.
  • Installed Oracle 11gR2 Real Application Clusters RAC software on thethree-node cluster. Created a RAC database using the Database Configuration Assistant.

Confidential, New York, NY

Oracle & SQL Server DBA

Responsibilities:

  • Played a vital role in company’s transition from Oracle 8i database infrastructure to the10g structure while upgrading from Lawson E-Business Suite of Applications from 7.2 to Lawson 9.0. Helped setup new Lawson supporting apps,i.e.,Image now, Document Express (MHC), Crystal Reports and custom apps to work with WebSphere.
  • Supported all NY- HQ databases along with a fleet of 517 database servers all over the USA and UK.
  • Cut down Warehouse data availability time from 20 days to 5 days after redesigning outdated loading process. Installed and tested 11g with new features for warehouse upgrade.
  • Regularly loaded and maintained company Oracle data warehouse in Chicago.
  • Every two weeks loaded data from hundreds of PostgreSQL database servers.
  • Resolved many MS SQL Server 2005 database backup problems serving image keeping applications Power-Docs&Imagenow and company web URL filtering app Websense.
  • Installed two nodes Oracle RAC cluster on Linux boxes with 11g database.
  • Configured Standby Database with Data Guard using maximum protection.
  • Created Shell scripts to run RMAN for daily backup of databases using Cron jobs.
  • Lead a team of seven developers enhancing Benchmark and Newton applications storing data in Oracle and PostgreSQL. Helpthe developer team in troubleshooting queries.

Confidential, New York, NY

Oracle DBA & Data Architect

Responsibilities:

  • Worked as a Data Architect to design database models.
  • Assisted developers in fine tuning SQL queries and writing efficient code.
  • Successfully added five new applications in theinventory list. Lead multiple teams of software architects & developers in assisting Rational Rose DOM design. It helped in designing efficient database ERD models using Erwin 4.0. Wrote ETL Procedures, workflows to integrate data.
  • Lead a team of consultants from Mexico with themigration of 45 J2EE and ETL applications fromiPlanet to JBoss application servers along with database upgrades from 8i to 9i/10g.
  • Completed a six-month project 42 days earlier than the projected date. Installed MS SQL Server 2005 and configured user objects.
  • Prevented a major crisis about thestandard process of restoring databases by finding out NOLOGGING tablespaces present in different environments including Production.

Hire Now