SUMMARY:

• Results - driven, reliable, resourceful, and professional Oracle Database Administrator with over 7 years of IT experience in designing, implementing and maintaining Oracle 10g and 11g RDBMS.
• Knowledge of System Analysis, Designing, Testing Development & Support of Oracle 9i, 10g & 11g in Production, Staging, and Development environments.
• Highly motivated, enthusiastic, and dedicated to providing excellent client support.

TECHNICAL SKILLS:

• Oracle 10g/11g Database Administration
• Enterprise Manager/ Grid Control Administration
• Data Integrity & Security
• Upgrade & Patch Application
• Data Load & Migration
• Performance Tuning & Capacity Monitoring
• Backup & Recovery (RMAN)
• Data Guard Administration
• Automatic storage management
• Real Application Cluster Administration
• Project Documentation for Requirement Spec (FRS)

RDBMS: Oracle database, OEM, Oracle Data guard, Toad, Export/Import, Data Pump, AWR, ADDM, statspack, TKPROF, Spot light, VERITAS Cluster / Net backup, RMAN, SQL expert, RAC, Oracle EBS / Middle Tier 11.0.3, 11i, R12 / Oracle 9iAS, 10gAS, Apache, Web Sphere RDBMS Oracle (8.x, 9.x, ... ... - 10g), 11g ... ... 12c:

LANGUAGES: Oracle SQL, Linux Shell Scripting

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

SOFTWARE/APPLICATIONS/TOOLS: SQL*PLUS, DBCA, DBUA Netca, Net Manager, Recovery Manager (RMAN), Data Pump (expdp, impdp), SQL*Loader, Oracle Enterprise Manager (OEM), Grid Control TUNING TOOLS SQL TRACE, AWR, and ADDM

WEB TOOLS: HTML, XML

WORK EXPERIENCE:

Confidential, Greenbelt, MD

Produce Manager

• Negotiate with suppliers for favorable prices, terms, quality, and delivery
• Purchase produce following guidelines of marketing plan, e.g., priority, for local, Organic)
• Research new or alternative sources of supply
• Receive produce deliveries or oversee receiving, following established receiving procedures
• Price produce to achieve margin and sales goals, while maintaining a competitive pricing profile
• Plan attractive produce displays, using color and texture to enhance
• Ensure displays are replenished, rotated, culled several times daily. Set quality standards for culling.
• Select items for specials; mark down items as needed to reduce losses
• Assist customers with produce questions and special orders. Offer samples and suggestions for purchase and preparation in a friendly, courteous manner
• Provide product information for newsletter, promotions, and customer inquiries
• Get credit from suppliers where applicable for returned, damaged, spoiled goods. Coordinate storage of items to be returned to suppliers. See that unsellable items are properly disposed of
• Maintain produce display, prep and storage areas in clean, orderly condition, meeting health department standards
• Participate in quarterly inventory counts. Conduct inventories as requested by the General Manager
• Participate in setting sales and margin goals for department.
• Review departmental financial reports, (sales, labor, margin, turns) and take corrective action as needed

Bulk Buyer and Floor Manager, Bethesda, MD

Confidential

• Negotiate with suppliers for favorable prices, terms, quality, and delivery
• Purchase items following product selection guidelines & marketing plan.(e.g., priority for local, organic)
• Evaluate suppliers and investigate new sources of supply
• Purchase for special deals and promotions; Ensure adequate and timely supply of promoted products
• Receive orders, or ensure proper receiving by Department Clerks
• Calculate prices as needed, or provide pricing guidelines to Clerks or other staff
• Ensure accurate, up-to-date prices and information for bulk department products in POS system and shelf tags
• Coordinate handling returns and obtaining credit from suppliers for bulk department products
• Coordinate and assist with inventory counts for designated product departments

Confidential

Stocker/ Produce Buyer

• Carries out lead responsibilities in the absence of the Produce Manager on duty in accordance with Sprouts policies, including oversight of team, compliance with the Sweep program, and supervisory functions.
• Responds positively to customer's inquiries and assists customers with questions, information and product selection.
• Ensures cleanliness of Produce department, storage area, and work area for safety; includes cleaning of shelves and products, keeping floors free of spills or water, removing hazardous debris from floor and sweeping.
• Stocks Produce department; includes presentation of product, facing, filling, and organization of all product items as set by the Produce Department schematics as well as ensuring tag and pricing accuracy.
• Examines the rotation of all Produce products paying particular attention to expired stock and properly discarding outdated or spoiled items pursuant to Sprouts standards.
• Receives, inspects, and logs products for accuracy of shipment, temperature, and quality.
• Requires operating and using equipment such as knives, scales, wrappers, compactors, garbage disposals, pallet jacks, and hand trucks.
• Ensures all wet racks are stocked, clean, and maintain proper temperatures.
• Cleans and sanitizes work area (including tables, floor, scales, cases, cooler, etc.)
• Participates in pre-inventory preparation; includes back stock and assuring tags match products.
• Sustains a high level of product knowledge and product preparation.
• Walks department regularly to ensure an organized, sanitary, and overall clean appearance at all times.
• Follows all safety practices and procedures.
• Other related duties as assigned.

Confidential, College Park, MD

Floor Stocker

• Ensuring that all customers receive excellent service through direct salesmanship, and prompt and courteous service. 
• Assisting customers with questions, needs and purchases.
• Attending weekly sales meetings.
• Cultivating successful relationships with retail customers. 
• Completing each transaction in a quick and efficient manner. 
• Leading all social media sales initiatives.
• Cleaning shelves, counters, and tables.
• Greeting each customer that comes into the store in a warm manner. 
• Identifying customer requirements. 
• Preparing merchandise for display.
• Assisting customers with purchase decisions. 
• Assisting in physical inventory counts. 
• Implementing all visual merchandising standards. 
• Setting up merchandise on the sales floor.
• Making sure that customers receive receipts on all purchases. 
• Helping customers try on or fit merchandise.
• Watching out for loss prevention through leakage and theft. 

Confidential,  Pittsburgh, PA

Oracle DBA

• Installation, configuration and upgrading of Oracle database server software and related products
• Install and configure Oracle 11g RAC with Grid Infrastructure (GI) on 4 nodes on Red Hat Enterprise Linux 5.7, upgrade production databases from 10.2.0.2 to 10.2.0.4 and 10.2.0.4 to 11.2.0.2 on RHEL 5.7/5.9 and applied quarterly Critical patch updates and patch set updates as needed provide 24/7 on-call support on a rotation bases and developed ad hoc shell scripts to provide temporary work-around for issues in production database Performed capacity planning for the database and added nodes to RAC database to make 2 node RAC Performed database Audits/fine Grained auditing, reports regarding the SOX-compliance activities against financial data, in regular bases on user operations involving sensitive database objects analyzed EXPLAIN PLAN,TKPROF,SQLTRACE and used ANALYZE, HINTS for performance enhancement.
• Implement database security
• Perform backup and recovery according to policies and procedures using RMAN utility
• Execute performance tuning using ADDM/AWR reports
• Ran AWR, ADDM, ASH reports to analyze the database behavior and implemented new strategies for Database performance tuning
• Perform data migration using Oracle Export/Import utility
• Perform Plan growth and changes (Capacity Planning)
• Configure database network such tnsname and listener
• Apply CPU critical patch to GI and RDBMS database
• Performed migration of the oracle databases whose database sizes vary from 300 to 500GB from Oracle 10.2.0.4/11.1.0.7/11.2.0.1 to Oracle 11.2.0.3 using Exp/Imp and Expdp/Impdp.
• Set up Active Dataguard Configurations for oracle database 11.2.0.3 for thirty databases whose size varies from 2TB to 5TB on a 3 node RAC
• Utilize grid control and database control to manage databases
• Setting up Physical Standby Database Data Guard for Disaster recovery and implemented failover and switchover mechanisms
• Migrated Non ASM file system to ASM File system for better space management.
• Configuring database entries, monitoring and maintaining user security for all of the databases using Oracle Enterprise Manager (OEM) Grid Control and Enterprise Security Manager (ESM) Installed and configured cloud control 12c to monitor all databases.
• Data Refresh from Test to Production and Development environments using RMAN Duplicate Database.
• Experience with Oracle Very Large Databases (VLDB) of 1TB to 8TB. Implemented security features like Auditing and user management in Oracle 11gR2 and SQL Server Databases.
• Working with VERITAS, SAN and EMC Net Backup Technology to take the hot and cold backups.
• Involved Oracle query tuning for a data warehouse and STAR schema design and use of bit-map indexes.
• Managed the Very Large Tablespaces and tables in 12 TB size of Database. Created Database Schema, development, administration and testing using Oracle.
• Maintain database integrity & security (Grant, Create User Role & Privileges)
• Identified bugs and applied required patches like CPU, PSU Patches as per the oracle recommendations.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring, Alert Log monitoring and backup monitoring
• Developed Shell-Scripts for RMAN, Hot and Cold backups.
• Refresh the database from PROD to UAT, QA, and DEV using RMAN
• Provided on-call support for production-related database problems. Environment: Oracle 11g R2 RAC, SQL Server, Solaris, HP-UX, AIX, Red Hat Enterprise Linux 5.5, Data Guard, Grid, OEM, ASM, ASH, RMAN, ASSM, AWR, Toad, Spotlight, PL/SQL, Shell scripting.
• ENVIRONMENT: Oracle 11g, 10g, Linux, Solaris, ASM, Data Guard, RMAN, OEM

Confidential, Pittsburgh, PA

Remote Oracle DBA

• Supported 50+ databases including RAC Production database, a Data warehouse database and lot of Development and Test databases
• Planned, installed, configured, managed and troubleshot Oracle 10g and 11g databases on Linux and Windows platform.
• 24 X 7 Production Oracle database support, administration and on call rotation
• Managed and monitored database storage usage (Capacity Planning)
• Cloned database with RMAN and without RMAN.
• Installation and configuration of oracle 10g and 11gR2RACdatabases.
• Upgrading databases from 10g to 11.2.0.3.
• Configured initial and incremental load using golden gate.
• Upgraded database from 10.2.0.4 to 11.2.0.3 using Golden Gate with zero downtime.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption) Responsible for setup and implementation of 2 Node RAC on IBM-AIX in 10g and 11g R2 using VERITAS Cluster Server
• Performed bulk load into the database using SQL Loader
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Monitoring space requirement for production databases
• Configured Oracle grid control to manage the entire database in single centralized location Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control. Creating table spaces, tables, and users for custom applications
• Automation of Startup Shutdown on all Production and Development Database. Implemented oracle high availability solution using Oracle Physical & Logical Standby
• Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some of the activities performed for better performance
• Worked on schemas creation and maintaining large partitioning tables. Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Performed physical backups using RMAN Utility
• Performed data migration using Oracle Export/Import Utility
• Set up database auditing
• Installed and configured Golden Gate director server/client for monitoring golden gate processes.
• Application Tuning: Identifying the sql's causing I/O bottlenecks, sql's of high cost and giving recommendations to the development teams accordingly.
• Database backup & Recovery with export and import for non archive and archive database with RMAN commands Developed Scripts for transferring data from production server to testing/development servers
• Upgraded OWB repository from 10g to 11.2.0.3
• Diagnosed and troubleshoot typical SQL Tuning issues using
• SQLTXPLAIN.SQL Shell scripting and PL/SQL programming to resolve business problems of various nature
• Maintained and upgraded databases Developed and maintained the applications by utilizing ASP.NETand software
• Worked on database refresh using hot backup and rman backups.
• SQL explain plans and query performance, session tracing
• Managed database objects such as procedure and functions
• Worked on rolling patch apply throughout the environment with no downtime.
• Planned and implemented a backup and recovery strategy using RMAN and Data Guard
• Monitored system resources and takes action to keep the system at optimal performance using Grid Control.
• Communicated and coordinated with Oracle using My Oracle support for major database issues/ database problems
• Environment: Oracle 10g/Oracle 11g/RAC, Linux, Solaris 10, Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard.

Confidential, Chicago, IL

Junior Oracle Database ADMIN

• Installed Solaris 10 server
• Involved in installation, configuration and support of Oracle 11g RAC. Involved in 24x7 Oracle Production Database Administration. Refresh/Cloning of Database and applications for development and testing purpose
• Created directories and files in UNIX
• Involved in Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g
• Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Statspack.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration
• Inserted and edited text into files using the vi editor
• Design, document, implement, and maintain all backup, recovery including disaster recovery procedures
• Assigned dynamic internet protocol addresses into Solaris10 server
• Performed User Management, creation, monitoring and management of database users, altered passwords of users and granted and revoked system/object privileges, roles, audited user actions in the database
• Troubleshot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) for optimum database performance
• Created physical standby database (for disaster recovery) from hot backup of primary database
• Resolved gaps between primary and standby databases (Gap Resolution) Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Creating Tables, indexes, & triggers to assist developers
• Managing, troubleshooting and resolving oracle database, RAC and applications issues
• Refresh/Cloning of Database and applications for development and testing purpose
• Was involved in developing a disaster recovery (DR) plan
• Used to perform back up and recovery using Veritas NetBackup integrated into RMAN.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Writing UNIX shell Scripts and Scheduling through crontab.
• Providing Solutions to the Problems Faced by end Users or Programmers
• Scripts for Analyzing of Tables and Rebuilding of Indexes.
• Automation of Backups
• Interfacing with Oracle Corporation for technical support
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc for easy and effective management of Oracle networking
• Migrated databases from Oracle 10g on Solaris 10 to Oracle 11g on Linux
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities
• Configured listener for external procedure calls.
• Created and managed user, table spaces, data files and archive log
• Performance tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise manager and monitored the Stats pack report generated from snapshots taken at the peak business hours.
• Environment: Oracle 9i, 10.2.0.2, 11.1.0.7, Maestro 7.0, HP service desk, Remedy, SQL Server 2000/2005, OEM 10g grid, SQL*Loader, Windows XP, IBM AIX 5.3, WebSphere, Solaris5.9, Informatica Power center 8.1x and 8.6.