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