SUMMARY:

• Over 10 years as Oracle Database Administrator, Proficient in Oracle Database Administration Activities like day-to-day support, troubleshooting, Performance tuning, database design, modeling, administration and building large OLTP/OLAP databases on a variety of UNIX flavors Solaris, HP-UX, AIX, Linux and Windows NT 4.0/2000/2003 machines with Oracle Versions 7.x, 8.0.5, 8i, 9i, 10g, 11g, 12c etc.
• Involved in capacity planning, developed strategies, maintenance plans and implemented the same with monitoring, security, disaster recovery, load balancing and replication methodologies.
• Oracle RAC and ASM expert. Experienced in planning, designing, developing, deploying, maintaining and supporting RAC environment, Patching/upgrading RAC Nodes with 11gR2/R1/10 Oracle Versions.
• Hands on experience with Oracle Data guard 9i/10g/11g - both logical Physical Standby.
• Installed, configured and maintained enterprise environments with 24X7 production databases.
• Support performance testing, identify tuning and design changes to gain performance with AWR, Statspack, ADDM, SPM, SQLTXPLAIN etc. Engineering Large Scale Database Design and Tuning. Involved in optimizing SQL queries. Monitoring and optimizing the Performance of the database, Change Management, capacity planning, and SQL tuning.
• Expertise in 12c/11g/10g Grid Control.
• Experience with database backup, restore, and disaster recovery procedures. Hands on experience of database backups and Recovery strategies using RMAN 9i/10g/11g , Data pump expdp, impdp , Export/Import and Transportable Tablespaces.
• Used Oracle 10g streams for Data replication, Data warehouse loading, Event notification as well as business event management.
• Experience in Implementation of Fine Grain Access Control FGAC .
• Monitor and manage Oracle database Security by implementing SOX Policies through Shell Scripting, OEM Grid Control and monitoring through Autosys schedulers.
• Extensive experience in Data warehouse environments with Star Schema and SnowFlake Architecture.
• Extensive experience with Oracle Database Migrations/Upgrade/Patching.
• Strong Knowledge on 12c,11g 10g Release and New Features.
• Strong experience with Database Modeling, Data Analysis and Conceptual, Logical and Physical modeling for Online Transactional processing OLTP and Online Analytical Processing OLAP systems.
• Expertise in Environment using Oracle Veritas HA Cluster and Cluster automatic failover configurations.
• Expertise in Creating/troubleshooting/monitoring script, creation of log files, packages development of scripts for SQL Loader, Export, Import, PL/SQL, Involved in optimizing SQL queries. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, Statspack tkprof .Strong experience in tuning database performance from system as well as query tuning perspective.
• Expertise in Entity/Relation Data Modeling using ER-Win and Designer. Used and supported Informatica for ETL Transformations, Discoverer for adhoc query, Crystal Reports for reporting.
• Working experience with Very-Large databases VLDB up to 10 terabytes, data migration against Oracle other databases such as MS Access, SQL Server.

Technical Skills:

Experience Details:

Presently working as a Sr. Oracle DBA for a client in Financial Industry, providing support for development, system integration testing, UAT and production systems by administering mission-critical databases with full accountability for problem resolution, security, backup, replication, capacity planning, etc., thereby ensuring operational excellence to corporate portfolio of Banking, Credit Card, Mortgage, Home Loan Auto Loan markets Directly accountable for design, data model, develop, install, configure, patch, upgrade, maintain, troubleshoot, tune, monitor databases with multiple instances and ensure high availability of the system.

Confidnetial

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Working as Primary DBA providing L2 and L3 support for 24 7 Oracle Production Databases, administering 120 instances 80 as primary 40 as Secondary , varying in size from 150 GB to 15 terra bytes, supporting the mission critical financial applications, data marts and large data warehouses.
• Review Turn Over Log TOL reported by L1 on a daily basis for issues, and perform extensive root cause analysis, trouble shooting, proposing solution and applying the fix.
• Review backup, audit, capacity projection, table space, fragmentation, Access role, public direct grants , profile, DB link, file system monitoring and several other reports, and take necessary actions as required.
• Extensive experience in Installing configuring 12C 11G Oracle Databases from scratch on Solaris 5.10/5.9 SUSE Linux ES 10 platforms with stand alone and Veritas Cluster Server for High Availability VCS HA configurations.
• Installed and configured multiple 2 Node RAC with 2 Node physical Standby on Solaris 5.10 platform with 11.2.0.3 Oracle Database and Grid Infrastructure using shared SAN storage.
• Installed and configured physical StandBy Database DataGuard replicating data from Reston datacenter to Urbana datacenter in an effort to commission new application.
• Upgraded more than 30 instances from 10.2.0.4 and 11.2.0.2 to 11.2.0.3 11.2.0.4 with stand-alone and cluster configuration.
• Ensure the DB's are security compliant through quarterly patching on both RAC and standalone databases. Applied Oracle Patch Set Update PSU to nearly 80 instances in last 6 months.
• Extensive experience in troubleshooting performance issues using AWR, SQL Tuning Advisor, SQL Tuning Set, ADDM etc.,
• Experienced in optimizing and/or tuning SQL, PL/SQL code using various methods like SQL rewriting, where clause optimization, index optimization, Execution Plan Stabilization using SQL Plan Management SPM , SQL Profiling and outline.
• Currently evaluating testing Oracle 12C to certify and support companywide implementation.
• Extensively used Oracle Data pump to take daily logical backup of the production databases and to clone/refresh the lower environment databases.
• Automated end-to-end export/import process to refresh Production data to lower environment using Shell Scripting.
• Used Oracle Flashback Database feature to restore database back in time.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE, DBMS STATS.
• Installed 12C Grid Agent on target hosts using Cloning method.

Environment: Oracle 12c/11g/10g, 12C OEM Grid Control, Linux SUSE ES 10 , Sun Solaris 10, HP-UX, Windows 2008, Autosys, Net backup, UNIX Shell Scripting, Unix CRON jobs, SQL scripting, Weblogic, SQL Server 2005/2000, PL/SQL, SQL Scripting, Unix CRON jobs, AWR, ADDM, STATSPACK, DBArtisan, TOAD etc.

Confidnetial

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Worked as Primary DBA for 24 7 Oracle Production Databases administering more than 50 instances varying in size from 50 GB to 8 terra bytes, supporting the mission critical financial applications, data marts and large data warehouses.
• Successfully migrated 11G R2 development, SIT, UAT, QA PRODUCTION databases from HP-UX to IBM AIX 5.8 6.0 in an effort to move from HP to IBM Hardware.
• Currently working on a project to migrate 10G R2 HIBERNIA BANK databases to CAPITAL ONE BANK in Plano Data Center and standardize the environments as per the Capital One standards.
• Upgraded 10G R2 databases to 11G R2 along with an effort to migrate from HIBERNIA domain to COF Cap One Financial domain.
• Diligently worked with Oracle Golden Gate Team Replication Team to provide fail back plan in an effort to migrate Production databases from Hibernia Bank to Capital One Bank.
• Performed Real Application Testing RAT on new Capital One environment to identify and fix the potential problem before the migrating from Hibernia Bank to Capital One Bank.
• Used SCN based Oracle Flashback Database features during the migration effort.
• Restructured table spaces, roles, privileges, User ID's etc., to suite different components of the business like Teller, Sales Service and Admin Tools there by ensuring the optimal performance of the Application.
• Performed complete Hardware Assessment and through Capacity Planning to migrate databases from Hibernia Bank to Capital One Bank.
• Ensure databases are security compliant with frequent scans via NEZUMI and by applying quarterly Oracle PSU's, thereby maintaining highest level of Data integrity standards.
• Determined Backup strategies to Banking Applications Touch Point XPRESS and worked with scheduling team Control-M in configuring them.
• Performed automation including Backups, exports imports, and archiving old records
• Periodic trimming of Oracle system log files and removal of old redo log archives
• Installed and Configured 2 Node RAC on Red Hat Linux platform.
• Configured multiple 11g R2 RAC with Automatic Storage Manager ASM on Linux servers and NFS/SAN file system and also configured workload management both server side and client side Load Balancing .
• Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled tested their physical and logical backups.
• Worked on apply patches, troubleshooting different problems in RAC and Non RAC env. In dev, test, pre-prod, production env.
• Worked with Oracle Support to resolve ongoing issues in current env and worked with Oracle Development team for oracle related bugs.
• Gathered requirements for New Application from database perspective and developed strategies to host database for them accordingly.
• Configured development, SIT, UAT, QA Production database, monitor database growth and provide capacity planning for application expansion.
• Created RAC Database on Dev Hosts refreshed them with the latest snapshot of data from Prod Environment.
• Investigating new features of Oracle 11g for possible implementation.
• Extensively used Oracle Data pump to take daily logical backup of the production databases and to clone/refresh the lower environment databases.
• Installation, setup and configuration of logical and physical StandBy Database using data DataGuard.
• Successfully designed, tested, implemented and maintained disaster recovery system using Oracle Data Guard to replicate the production data from Plano, TX to Richmond, US to ensure company's business continuity plan.
• Troubleshoot Database Performance issues using Automated Workload Repository AWR , SQL Tuning Advisor and Automatic Database Diagnostics Monitor ADDM . Tuned database for optimum performance.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE, DBMS STATS. Evaluated monitored database to resolve performance issues including troubleshooting errors, recovering databases from failures as needed.
• Create database maintenance plans, including updating statistics, indexing, structure modifications, capacity plans, and index analysis.
• Work with project team as project database administrator for large-scale modifications and new product release. Also involved in determine resource consumption estimates and recommend system upgrades.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments. Provided Technical assistance and guidance to the development group. Responsible for supporting and managing database activity during the development cycle. Creating and maintaining the data model and physical integrity of the databases.
• Ensure all production databases are in compliance with Sarbanes Oxley data security and data integrity standards.

Environment: Oracle11g/10g,OEM Grid Control 10.2.0.5,AIX 5.2/5.3/5.8/6.0 Linux RHEL AS 4 , HP-UX, Windows 2008, TSM backup, COMMVAULT backup, Shell Scripting, Unix CRON jobs, SQL scripting, Weblogic, SQL Server 2005/2000 ,Grid Control,PL/SQL, SQL Scripting, UNIX Shell Scripting, Unix CRON jobs, AWR, ADDM, DBArtisan, TOAD, SQL Developer, Erwin Data Modler etc.

Confidnetial

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Worked as Primary DBA for 24 7 Oracle Production Databases administering more than 30 instances varying in size from 500 GB to 7 terra bytes, supporting the mission critical financial applications, data marts and large data warehouses.
• Installed and Configured 4 Node RAC on Red Hat Linux platform.
• Configured multiple 10g R2 RAC with Automatic Storage Manager ASM on Sun Solaris servers and NFS/SAN file system and also configured workload management both server side and client side Load Balancing .
• Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled tested their physical and logical backups.
• Worked on apply patches, troubleshooting different problems in RAC and Non RAC env. In dev, test, pre-prod, production env.
• Worked with Oracle Support to resolve ongoing issues in current env and worked with Oracle Development team for oracle related bugs.
• Created RAC Database on Dev Hosts refreshed them with the latest snapshot of data from Prod Environment.
• Setup up Stage Dev/TEST/QA environment from Production database using Cold and hot backup.
• Investigating new features of Oracle 11g for possible implementation.
• Setup Oracle Streams based replication of Fannie Mae databases, Conflict handling solutions using handlers.
• Installed Configured Oracle 10g Grid Control for monitoring over 200 Prod / Non Prod Hosts.
• Upgraded the Oracle 10.2.0.1 Grid Control Setup Including OMS, Database and Agent to version 10.2.0.4
• Installed Grid Agent at target hosts using Agent Download Method and Cloning methods.
• Migrated the OMS repository from 10.2.0.3 Grid Control to newly setup 10.2.0.4 Grid Setup Successfully to see the historical reports using new Grid Control.
• Extensively used Oracle Data pump to take daily logical backup of the production databases and to clone/refresh the lower environment databases.
• Created RMAN catalog for 9i/10g/11g databases and configured backups for databases with Netbackup storage. Restored database to alternate node using RMAN DUPLICATE command. . Managed and performed Troubleshooting of all backup issues as a routine day to day task.
• Installation, setup and configuration of logical and physical StandBy Database using data DataGuard.
• Successfully designed, tested, implemented and maintained disaster recovery system using Oracle Data Guard to replicate the production data from Reston, US to Urbana, US to ensure company's business continuity plan.
• De-fragmentation/Reorganizing of database using Export/Import, Rebuild Index and move table.
• Cloning/Duplicating production databases using scripts as well as RMAN.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Troubleshoot Database Performance Tuning issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM . Tuned database for optimum performance.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE, DBMS STATS.
• Evaluated monitored database to resolve performance issues including troubleshooting errors, recovering databases from failures as needed.
• Create database maintenance plans, including updating statistics, reindexing, structure modifications, capacity plans, and index analysis.
• Work with project team as project database administrator for large-scale modifications and new product release. Also involved in determine resource consumption estimates and recommend system upgrades.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Database Refreshing / Replication from production to testing using hot backup.
• Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments. Provided Technical assistance and guidance to the development group. Responsible for supporting and managing database activity during the development cycle. Creating and maintaining the data model and physical integrity of the databases.
• Ensure all production databases are in compliance with Sarbanes Oxley data security and data integrity standards.

Environment: Oracle11g/10g,OEM Grid Control 10.2.0.5, Linux RHEL AS 4 , Sun Solaris 10, HP-UX, Windows 2008, HP Service Guard, Net backup, Shell Scripting, Unix CRON jobs, SQL scripting, Weblogic, SQL Server 2005/2000 ,Grid Control,PL/SQL, SQL Scripting, UNIX Shell Scripting, Unix CRON jobs, AWR, ADDM, STATSPACK, DBArtisan, TOAD, Netbackup etc.

Confidnetial

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Installed Oracle 10.2.0.3 on Production DB Servers, applied OPatches to fix the known bugs and Upgraded 15 production databases sizing between 700GB and 2 TB from Oracle 9.2.0.7 to 10.2.0.3.
• Implemented the Oracle Physical Data Guard in Maximum Performance Mode for re hosting of T-Mobile data center using Data Guard.
• Installed Oracle Clusterware CRS, Clustered Install of Oracle 10g, applying opatch in clustered environments, created database / instances on a four node cluster, troubleshooted RAC at OS / OCR / CRS / DB Level.
• Upgraded T-Mobile Oracle Databases from 9i to 10g.
• Configured 10g R2 RAC with ASM on AIX servers and GPFS cluster file system and also configured workload management both server side and client side Load Balancing .
• Installed and Configured Oracle 10.2.0.1 Grid Control.
• Implement backup and recovery procedures using RMAN and TDP for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups hot, cold and incremental .
• De-fragmentation/Reorganizing of database using Export/Import, Rebuild Index and move table.
• Writing Shell scripts for Alerts for ORA- errors, backup and recovery, Import and export procedure, Unix Shell scripting in csh, ksh to be controlled from Crontab.
• Used Oracle streams for Data replication, Data warehouse loading, Event notification as well as business event mgt.
• Member of SOX team in implementing security on DB side.
• Troubleshoot Database performance tuning issues using Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks SAN .
• Configuration/scripting for SQL Loader to load data from Mainframe.
• Involved in upgradation of more than 25 Databases each sizing at least 500GB to 2TB from 9i to 10g also involved in Migration from SQL Server2005 to Oracle 10g.
• Downsizing and defragmenting the Very Large Databases by export / import, Cloning them using RMAN Duplicate features and then upgrading them to Oracle 10g.
• Involved in Data Warehousing, Data Modeling, Database Design and Creation
• Used Oracle Warehouse Builder for designing, deploying, and managing data warehouse
• Designed and developed logical and physical data models using CASE tools such as ERWin and Oracle Designer 10g and using manual methods as well.
• Setup backup and recovery procedures using OEM, RMAN and third party tools like Veritas. Used hot backups and cold backups, incremental and full backups.
• Used Flashback technology to recover Point-in-Time-Recovery accidentally dropped or modified database objects.
• Responsible for data integrity, user security, daily monitoring for production and non-production systems. Used standard, value-based and FGA auditing.
• Implemented backup strategies for archiving and non-archiving databases. Involved in planning, implementation and testing of disaster recovery.
• Created Scripts to test the user connections generator scripts for automatic generation of SQL.
• Developed new technique for reducing the downtime in migration of big database.

Environment: Oracle 8i,9i/10g ,SQL Server 2005, Linux RHEL ,IBM AIX 5.3, Open VMS, Windows NT, Dell poweredge 4400, IBM POWER5 Servers, IBM RS/6000,HP9000, Sun E5000, SAN, Erwin 7.1, Pro C, PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, AWR, ADDM, DBArtisan, TOAD

Confidnetial

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Involved in 24 7 Remote / Onsite DBA support to Production Data Centers of Luxottica retail and interacting with offshore team in India and meeting the timelines of various projects.
• Provide day-to-day databases support for users application teams. Implementing database backup and restorations.
• Involved in upgradation of more than 35 Databases having sizes varying from 500GB to 3 TB.
• Creation and setup of Dev/TEST/QA environment from Production database
• Installation, Upgrade and Configuration of Oracle 9i, 10g and 10g EM.
• Setting up and Auditing RMAN Hot and Cold Backups, Exports.
• Implement backup and recovery procedures using RMAN for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups hot, cold and incremental .
• Installed 10g Physical Data Guard in Maximum Performance Mode. Verify the Redo Generation, Redo Transfer and Redo Apply Services between the primary and standby database. Performed the Switchover, Switchback and Failure tests of the primary and physical standby and verified the successful catching up of standby with the primary DB.
• Configured 10g R2 RAC with ASM on HP servers and OCFS cluster file system and also configured workload management both server side and client side Load Balancing .
• Database migrating Oracle 9i to 10g.
• Migration of Oracle Databases from HP UX to Linux
• Plan and Schedule the Online/Offline Backups.
• Database and Log Backups Restoration, Backup Strategies, Scheduling Backups. Backing up master system databases and restoring them when necessary.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• De-fragmentation/Reorganizing of database using Export/Import.
• Involved in Creating / Renaming the database and implementing SOX policy.
• Implemented Password Administration, User Schema Account Naming by using standard Oracle profiles ,enable password encryption , data encryption in accordance to the SOX policies of the company
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Extensive Performance Tuning, Memory SGA Tuning, etc.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE DBMS STATS and evaluating monitoring database to resolve performance issues including troubleshooting errors, recovering databases and failures as needed.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.

Environment: AIX 5L, Sun Solaris 9, HP-UX 11.0, Windows NT, IBM RS/6000,HP9000, Sun E5000, SAN, VERITAS, Oracle 9i/10g , Pro C, PL/SQL, SQL Scripting, Unix Shell Scripting, Unix CRON jobs

Confidnetial

Role: Sr. Oracle DBA

RESPONSIBILITIES:

• Creation and setup of Dev/TEST/QA environment from Production database.
• Performed several RDBMS upgrades from 8i to 9i,9i to 10g on HP 64 bit platforms.
• Setting up and Auditing RMAN Hot and Cold Backups, Exports.
• Implement backup and recovery procedures using RMAN for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups hot, cold and incremental .
• Migration of Oracle Databases from Solaris to IBM AIX 5.3.
• Managing Veritas Clusters for HA Implementation.
• Configuration of Oracle Enterprise Manager OEM 9i 10g tools for monitoring, performance enhancement and debugging.
• Used Veritas FlashSnap Warehouse, RMAN, DDL and Wizard OEM Management Server for Export backups on schema level hot backups.
• Real Application Clusters monitoring, tuning, load balancing using SRVCTL, OEM Oracle Enterprise Manager , Statspack,and GV dynamic views.
• Automated failover of applications within a data center or to remote data centers.
• Implemented Fine Grained Access Control FGAC as per multi Organizational security.
• Design and create Logical and Physical data Models using ERWIN.
• Created dimensions and extensive use of export/import utilities in Oracle Warehouse Builder.
• Provided disaster recovery testing without affecting the primary environment.
• Implemented fine grained auditing using dbms fga of Oracle 9i in order to comply the SOX policy of the Company.
• Installation, setup and configuration of logical and physical Standby Database using DataGuard.
• Installation and Configuration of SQL server 2005 on windows server.
• Involved in Shell script Shell and SQL to automate database Backup, monitoring and other DBA functions. Data and schema transfers from oracle to oracle, oracle to flat files vice-versa, SQL server to SQL server, SQL server to text files and vice versa.
• Assist with the loading and configuration of Oracle software starting from space requirements, kernel parameters setup to the Oracle installation and successful execution of DBCA.
• Assist with the loading of internal and third-party applications using DB Artisan, SQL Navigator etc to do various SQL / DBA tasks using GUI Environment.
• Assist with database tuning and best practices involving OS level tuning, SGA tuning, SQL Tuning and considering other contention / IO issues.
• Configured supported oracle Advanced replication Multimaster
• Writing error handler procedures for, update and delete conflict and writing the cause of error to log files.
• Extensive Performance Tuning, Memory SGA Tuning, etc. using Statspack, ADDM other advisors.
• Provided technical support to development team to fine tune SQL and PL/SQL code using SQL Execution Plan, SQL TRACE, ANALYZE DBMS STATS and evaluating monitoring database to resolve performance issues including troubleshooting errors, recovering databases and failures as needed.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Database Refreshing / Replication from production to testing using hot backup.
• Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Rendering 24 7 Oncall Production database support.

Environment: Linux RHEL , Sun Solaris, HP-UX 11.0, AIX 5.3, Windows NT, Sun E5000, SAN, VERITAS, Oracle 10g/9i , SQL Server 2005/2000, Questa Shareplex,Erwin 7.1,OWB, DataStage 7.5 EE, Pro C, PL/SQL, SQL Scripting, UNIX Shell Scripting, STATSPACK, DBArtisan, TOAD

Confidnetial

Role: Oracle Developer/DBA

RESPONSIBILITIES:

• Installation of Oracle 8.0.4, 8i.
• Analyzed Requirement, Designed ER-Diagrams tables. Wrote PL/SQL packages procedures and functions for various tasks
• Performance tuning, memory SGA tuning
• Installed and configured OEM and RMAN.
• Setting up new production and non-production environments and servers on new Unix servers. This included server kernel parameter setting, Oracle server installation and configuration, manual database creation on raw devices.
• Creating tables, tablespaces, objects, setting privileges, indexes, user logins, passwords.
• Writing scripts for backup and recovery and import/export.
• Unix Shell scripting for automating startup/shutdown of databases.
• Administered 4 production and over 50 development and test Oracle databases on HP-UX servers.
• Refreshed test databases with subsets of production data.
• Space management of large multi-terabyte databases with raw disk devices on EMC Symmetrix.
• Partition management of large partitioned tables and indexes.
• Developed, tested and enhanced DBA utilities that the DBA team routinely used.
• Designed and developed security policy for the application.