SUMMARY:

• Experienced Oracle database administrator in the Unix/Linux environment includes development and programming in PL/SQL, Unix Shell, SQL, Pro C, Java, C/C++ which are used to automate, and manage the systems for Data refresh/sync/load/transform and to send monitoring alerts to ensure uptime, availability and security event/audit tracking.
• 8+ years of experience with Oracle database administration in Unix environment
• SQL programming
• PL/SQL programming - Packages, Stored procedures
• Unix Shell programming, also C / C++ and Java proficient
• Setup and test oracle network listeners, VIP rac, database alerts and monitoring scripts, monitor throughput
• Unix cron jobs, FTP, SCP
• Excellent communication skills
• Oracle partitioned tables, indexes, partitioned tables, replication, triggers, functions, clone db
• Backup and restore, export import, RMAN, Hot backup, OEM
• Experience working on 10g/11g RAC database applications, OEM Grid control, RMAN. Toad, Sqlplus
• Knowledge of database, table, index, partitions and view storage structures
• Creating/modifying tables, views, materialized views and indexes
• Experience migrating database objects from development through test and into production
• Perform necessary database upgrades and patches
• Oracle Export/Import Data Pump experience
• Perform PL/SQL development - packages, stored procedures
• Basic understanding of Oracle listener connection pooling and middleware software such as Oracle VIPs
• Provide management with timely reporting related to application performance
• Strong verbal and written communication skill
• Ability to work independently and as a team member
• Strong customer and business focus
• Ability to create and maintain positive and professional business relationships with both internal associates and external partners.
• Ability to manage multiple concurrent objectives, projects, or activities
• Evaluate and make recommendations on new and existing end-user tools and production
• Manage complex projects and initiatives that significantly impact business results, and require a high degree of cross-functional participation and coordination

PROFESSIONAL EXPERIENCE:

Oracle Database Administrator

Confidential, Warren, New Jersey

Responsibilities:

• Working on IaaS dba team, supporting multiple backends for multiple highly visible mission critical applications.
• Do releases, administering dev environment, sync data between prod and test, support releases, trouble tickets, migrations, patching, data transfer support for development team. Oracle 10g and Oracle 11gr2, Oracle RAC w/ ASM, Shareplex, Dataguard active/standby.
• Designs and codes from specifications, analyzes, evaluates, tests, debugs, documents, and implements moderately complex software applications
• Under general direction, devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results
• Change Control Test, Backout, Implementation, Montoring, change control description plan and implementation documents,
• Strong analytical & troubleshooting skills
• 5+ years Oracle PL/SQL, ProC, Unix Shell scripting, SQLplus, Java, C, Perl
• Experienced in back end development using Pro*C, PL/SQL, unix cron
• Toad, and unix command line Sqlplus
• Overseas with family supported myself doing day trading equities with personal brokerage account.
• Learned Spanish language, speaking reading, writing. Family has immigrated to US and became permanent residents

Oracle Database Administrator Unix

Confidential, Warren, New Jersey

Responsibilities:

• Have 8+ years hands on experience supporting Oracle RDBMS 9/10g/11g with installing, patching, cloning, upgrades, monitoring, maintain, performance tuning on Solaris UNIX platform this includes cloning database for development, test, production environments, and working with Unix admins and network people as required for disk storage and access support/enablement .
• RMAN backups nightly onto Tivoli/TSM disk storage. Increased dba productivity by 20% because of task automation accomplished by shell scripting, sql, pl/sql data management programs. Scheduling of automatic jobs via Unix cron scripts for Oracle RMAN backup/restore and partition maintenance
• Developed Oracle technical solutions using Shell, PL/SQL, SQL - these were in support of automating tasks, data conversion or load or compare, bulk load of data, import, export of data in support of dev, test, and prod environments
• Developed scripts for, tested and planned change controls and implemented oracle database production deployment. Mirror changes into the test and qa environments to keep in sync. To help reduce deployment errors or omissions, I instituted version control using sccs and clearcase
• My task was to manage, deploy and support Development, Testing, Stage and Production Oracle 9/10/11 databases. This includes database creation, application development support, and database production support. Participated in planning of and implementation of production database change controls and during overnight hours. On call duty, rotating as needed. Developed and implement solutions to monitor and troubleshoot production outages using Oracle Grid and shell scripts, PL/SQL
• Proactively managed the daily interface with developers, test, unix sys admins, network admins, trouble tickets to keep all running smoothly to maintain high level of throughput, and identify problems before end user impact, intervene contact relevant parties and take action when necessary.
• Refresh Data Development and QA tables from Production
• Performance of databases and tuning - Oracle sql performance tuning - tkprof, explain plan. AWR reports, both infrastructure side turning, and code tuning, this enabled me to give web developers quick turnaround time increases of up to 50 % on database queries. Used communication skills with java developers to get them to employ bind variables for performance improvement and reduced statement parsing in the db by at least 20% or more
• Physical design (database configuration, capacity planning and monitoring, performance tuning, troubleshooting, and new technology integration)
• Logical design (data modeling, database documentation, schema source management, and physical schema maintenance)
• Replication of data using Quest shareplex, Oracle DataGuard, export import, ctas, data load - bulk load, insert, and conversion, data check programming, Export, DataPump
• Database performance tuning: Oracle AWR and statspack monitoring, mining for tuning of sql statements, identify problem sql and work with developers to improve performance and eliminate bottleneck and hot spots Daily activity included tuning individual SQL queries, and optimizing databases for performance with understanding ofAWR and StatsPackreports, database performance tuning.