We provide IT Staff Augmentation Services!

Oracle, Aurora Mysql Database Administrator/data Analyst Resume

Moline, IL

SUMMARY:

  • 6+years of experience in the field of Database Technology with experience in designing, developing, implementing Databases, Web development and Application development.
  • AWS RDS instance/Cluster Upgrade and Decommisioning.
  • Scheduled Unix scripts in Jenkins jobs to automate daily tasks like backups,monitoring the alert logs, and backup logs to send notification to emails.
  • Shipping of RDS logs to EC2 Storage.
  • Migration from Oracle platform within AWS to Aurora/MySQL.
  • Experience translating business requirements into conceptual, logical, and physical data models
  • Experience in configuring Oracle network, RMAN, Recovery Catalog, and Performance Tuning of database by optimizing SQL and PL/SQL scripts and instance. Used statspack report, AWR report, ADDM advisors, autotrace and execution plan.
  • Management and implementation of database models, data flow diagrams, database schemas, database scripts, to support a robust data management infrastructure.
  • Experience on Metadata definition, implementation and maintenance, new business rules identification and implementation to data rules, transformation.
  • Working experience of defining triggers events, cursors, stored procedures and packages.
  • Installation, configuration and upgrade of Oracle 10g, 11g RAC.
  • Extensive work experience on Single instance, Oracle RAC databases in both OLTP and OLAP environments.
  • Experience in regular Database Administration activities such as Upgrades, Migration, Patches, my oracle support, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning, script development, and documentation
  • Experience in using 11g features Flash - Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Grid Control
  • Skilled in setting up/Installation and configuration of release 10g RAC R2 with ASM and Raw Devices and 10g CRS.
  • Strong physical and logical Data Guard skills.
  • Upgrade databases from 10g to 11g & 11g to 12c on AWS
  • Experience with new features of 11g R2 which includes SQL Access Advisor, SQL Performance Analyzer, SQL Plan Manager, Table compression enhancement, Active Data Guard, Query Result Caching, Invisible Indexes. etc
  • Pre-patch analysis for the patches and document preparation with pre and post patch installation steps.
  • Experience as Oracle DBA providing support to many Production, Development, Test, CRP instances comprising of some of the more complex and challenging environments from versions 9i to 11g releases.
  • Installing and Upgrading Oracle Server 10g to 11i, 11gR1, 11gR2, R12.
  • Administering Oracle 10g, 11i, 11g Instances
  • Experience with OEM in 11g
  • Experience with Power Designer for reverse engeering and schema conversion.
  • Create and setup PeopleSoft HCM databases, Schemas and Tablespaces
  • Multiple upgrades of Oracle server older versions to newer versions.

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, Aurora/MySQL 5.6

Database Tools: AWS Console,Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, SQL Developer, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, MySQL workbench 5.6 Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy,Power Designer, Keepas(DB logging encryption),Ultra Edit.

Operating Systems: UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450 , Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800 , HP/UX-9000, Red Hat Linux 6.2

Middleware: BEA Weblogic 10.2.3

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization.

PROFESSIONAL EXPERIENCE:

Confidential, Moline, IL

Oracle, Aurora MySQL Database Administrator/Data Analyst

Responsibilities:

  • DBA/Data Analyst supporting five major application/projects from Development to Production on AWS.
  • Intesively used latest 11g/12c on AWS.
  • Migration of oracle app from On Prem to AWS via DMS.
  • Migration from Oracle platform within AWS to Aurora/MySQL.
  • Scheduled Unix scripts in Jenkins jobs to automate daily tasks like backups,monitoring the alert logs, and backup logs to send notification to emails.
  • RDS instance creation on AWS via AWS console.
  • Shipping of RDS logs to EC2 Storage.
  • RDS instance/Cluster Upgrade and Decommisioning within AWS.
  • Reverse engeering of Oracle Schemas via power Designer.
  • Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
  • Quaterly audit compliance to adhere Company policy
  • Security Compliance (User creation and granting of privileges through roles).
  • Ticketing System transtion from Kayako to Rally
  • Purging of obsolete data via ETL job.
  • Extensive use of Sharepoint to Document projects as well as quaterly PSI planing
  • Oracle/Aurora Query Optimization .
  • Some DB2/Postgres experience but willing to expatiate knowledge on these platforms.

Confidential, Miami, FL

Oracle Database Administrator

Responsibilities:

  • DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes range from 4GB to 2TB (in ODS & EDW environments).
  • Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
  • Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, and backup logs to send notification emails.
  • Migrated data to a new ASM Diskgroup to improve the IO performance of the database.
  • Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.
  • Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
  • Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups.
  • Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10g Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.
  • Create oracle databases on configured servers using both the DBCA & Database creation scripts.
  • Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
  • Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
  • Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
  • Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
  • Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
  • Installation, Configuration and administration of Oracle 11g RAC.
  • Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
  • Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
  • Performed capacity planning, space monitoring like tablespace growth, ASM disk space.
  • Resolve critical issues by raising SR with Oracle Support and Root Cause Analysis (RCA).
  • Application of Oracle software patches when/where necessary.
  • Backup/Recovery monitoring and reporting using both BMC SQL Backtrack & Oracle RMAN
  • Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
  • Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both Confidential role & table levels, as well as final Project Performance Assessment/Evaluation.
  • Create database Objects, Tablespaces, Schemas as needed.
  • Schema migrations from Development to Production via Tech Test environments.
  • Database refresh from Production to Tech Test as needed.

Tools: Used: Oracle RMAN, Oracle 10g (9.2.0.8), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Tallahassee, FL

Oracle Database Administrator

Responsibilities:

  • Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
  • Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.
  • Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.
  • Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
  • Maintained the data integrity and security using integrity constraints and database triggers.
  • Provided 24X7 supports for all the production and development databases.
  • Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.
  • Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
  • Implemented disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration
  • Experienced working on non-prod databases which are resided on Virtual Machines and understanding the working process.
  • Worked with different middleware & IDM teams to resolve their issues from the database side.
  • Refreshed non-production environment with production using Datapump & RMAN
  • Applied patches and database re-organization using oracle enterprise manager (OEM).
  • Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
  • Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Extensively used PeopleSoft applications to address the most complex business requirements and provide comprehensive business and industry solutions, enabling organizations to increase productivity, accelerate business performance, and provide a lower cost of ownership.

Tools: Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Confidential, Atlanta, GA & Middletown, NJ

Oracle Junior DBA

Responsibilities:

  • Configure. Implement & Deploy Oracle 10g (9.2.0.8) & Oracle 11g (10.2.0.4), single instances on SunOS 5.9 using files systems for storage & VERITAS Clustering for high availability using IBM’s HACMP
  • Create oracle databases (single instance) on configured servers using both the DBCA & Database creation scripts.
  • Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 11g Grid Control & SQL*Plus, as well as UNIX shell scripts.
  • Worked closely with Application Developers to design/create new Oracle databases/create new schemas/database objects, as well as making database changes from DEV to PROD, via TST following requests/demands from the development team.
  • Backup/Recovery of Oracle 10g/11g databases using Oracle RMAN.

Tools: Used: Oracle 10.2.0.1, Oracle 10g (9.2.0.8), RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Hire Now