SUMMARY:

• I am an Oracle DBA with more than five years of experience spanning the entire life cycle of application development on medium to very large software projects.
• As an Oracle Database Administrator, I enjoy demanding projects and always strive to implement the best in class technical solutions.
• With experience across a variety of industries, I am seeking a new challenge to call upon my technical background. I constantly work to keep abreast of Oracle technology, and possess excellent documentation skills and strong aptitude to analyze and resolve problems.
• I am fluent in English, French, and Italian; and I am currently working toward my 11g OCP.
• Experience in fulfilling DBA daily activities, including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (tablespace, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.
• Involved in each phase of system development life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, production and production support activities.
• Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration, data replication, as well as configuring and supporting high - availability and 24x7 Oracle instances and SQL-server databases.
• Successfully developed and implemented client/Server applications on multiple platforms. Actively involved in software development, implementation, software maintenance, software support, troubleshooting, documentation, training, etc…
• Experience of reverse engineering, migrating and porting of applications and databases across different hardware/OS/database platforms.
• Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, and work under pressure.
• Authoritative in design, development, documentation and review according to standards.
• Excellent team player and works independently. Actively participates in team meetings and maintains good relations with everyone on the team and other teams.
• Backup and recovery (using OS scripts, RMAN and Log Miner).
• High availability (Oracle Dataguard, Oracle FailSafe & AIX HACMP).
• RAC with ASM (on Veritas CFS).
• Database level performance tuning (using OEM, statspack, tkprof and trace analyzer).
• Oracle Server installation and patching.
• Database design, creation, patching and migration.
• SQL*Net configuration (over TCP/IP).
• Replication (snapshots/materialized views/Oracle Streams).
• Bulk loads and data migrations (using SQL*Loader, data pump import/export).
• UNIX shell scripting.

TECHNICAL SKILLS:

Databases: Microsoft Access, MS SQL Server 2000, 2005, Oracle 9i, 10g, 11g

Database Proficiency: MS SQL Server (SQL Enterprise Manager, Query Analyzer, SQL Profiler) Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX, PeopleSoft Server Administration release 8.4 and 8.48 Ed 2

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

Remote Tools: Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop

EMPLOYMENT HISTORY:

Confidential, MD

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 OLTP environment).
• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 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.
• Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 10g database control, oracle 10g Grid Control as well as other third party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
• Analyzing schema of databases created to collect statistics using the DBMS STATS package.
• Use AWR/ADDM for 10g Statistics management & database tuning following creation of new databases and periodically thereafter.
• Troubleshoot installation errors both independently and with Oracle support (via My oracle Support).
• Application of Oracle software patches when/where necessary.
• Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
• Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
• Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Confidential, MD

Oracle Database Administrator

Responsibilities:

• Created new databases (10g/11g) and users: set up backups, export, and other monitoring scripts.
• Managed internal databases, from planning and testing stages through implementation and support.
• Ensured Oracle database systems operate efficiently and securely.
• Administer database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights.
• Create database Objects, Tablespaces, Schemas as needed.
• Develop a strategic plan for the database development that supports the organizations operational requirements.
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Schema migrations from Development to Production via Tech Test environments.
• IBM TSM (Tivoli Storage Manager) install/upgrade from version 3.1.00 to version 4.0.10.
• 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 at role & table levels, as well as final Project Performance Assessment/Evaluation.
• Implemented Logical and Physical Standby Databases using Data Guard feature of Oracle 11g R2.
• Backup/Recovery monitoring and reporting using both Oracle RMAN and OS Scripts.
• Used Oracle Flashback Technology to recover for logical corruptions.

Confidential

Oracle Database Administrator

Responsibilities:

• Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc…
• 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 support for all the production and development databases.

Confidential

Network admin

Responsibilities:

• Build, upgrade, secure and support LAN, WAN, and WLAN networks for numerous business clients, installing Windows 2003 Small Business Server domain controllers, setting up active directory, DHCP, DNS, WINS and various group policies.
• Install, manage and support exchange server 2003 for business clients for OWA.
• Perform Smartphone and Exchange Server email integration for various business corporate Clients.
• Perform hardware, drivers and firmware upgrades for mostly Dell and HP family/blade servers.
• Implement software security solutions using application packages like, Symantec, and McAfee.
• Perform daily on site and remote network support for various business clients.
• Installed and networked Windows Operating Systems ( XP/2000/Vista) on Desktop peripherals.
• Provided fist tech support for both English and French clients.
• Performed configurations, upgrades, maintenance, and troubleshooting for PC's, printers and telephones.
• Monitored, examined and installed latest Microsoft updates/patches.
• Cleaned, backed up and restored data on secondary storage devices.