Sr. Oracle Dba Resume
Richmond, VA
SUMMARY
- Over 7 Years of experience in full application life cycle development, testing and production in Information Technology - Software Industry.
- Experience with Oracle 9i, 10g and 11g on Unix & Windows operating systems.
- Experience with RMAN, Oracle Enterprise Manager (OEM), OEM Grid control, Oracle Automatic Storage Management (ASM), Data warehousing, Oracle Data Guard, Oracle Data pump.
- Extensive knowledge of ORACLE Data Guard & Real Application Clusters (RAC).
- Extensive DBA experience in supporting multiple instances of ORACLE database including Development, Reporting, Data Warehousing, User acceptance testing & Production.
- Experience in cloning/replicating production database using RMAN & OEM Grid Control.
- Job scheduling through crontab, O/S updates and upgrades, patches loading.
- Experience in backup/restore, disaster recovery using RMAN & OEM Grid Control.
- Experience in using data pump import/exposure utility of ORACLE.
- Experience in database migration by designing and implementing database logical and physical storage structures.
- Experience in optimizing database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
- Extensive experience in daily batch and report monitoring, space management, index rebuilds, statistics collection and other Oracle housekeeping tasks.
- Developed database support processes and automated tasks through tools, PL/SQL and UNIX Shell Scripting. Oracle SQL*Net, SQL, PL/SQL, writing triggers, functions and PL/SQL procedures.
- Strong analytical and problem solving skills.
- Expertise in data modeling and database designing.
- Involved in data model design and database development including PL/SQL stored procedures, functions.
- Strong Oracle PL/SQL development background besides DBA skills.
- Experience in database security strategies by creating database users, user roles, profiles and audits.
- Upgrading and Migrating Databases from lower versions to higher versions.
- Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing test and development databases, Monitoring, Trouble shooting & Tuning.
- Experience in analyzing database & rebuilding indexes to improve database performance.
- Experience in Leading, Motivating and coordinating team of developers.
- Implemented & monitored daily, weekly and monthly batch jobs in database.
TECHNICAL SKILLS
RDBMS: Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008.
DB Tools: Erwin, Toad, Export, Import, Data pump, RMAN, SQL Loader, Log Miner, Change Manager, Streams,AWR,ADDM,STATSTPACK,tkprof.,SQL developer.
Hardware: EMC Clarion with RAID5, Sun Sparc E15K/E4500/420, Sun-Fire v440/v890
Operating System: Windows 2003/2005/2008 server, Sun Solaris, RH Linux 2,3,4,5, HP-UX, AIX.
Oracle Tools: Oracle 9i IAS, Designer 6i, Discoverer 2000, Oracle Web Server, Oracle Enterprise Manager & Grid Control, Forms 4.5/5.0/6i, Reports 4.5/5.0/6i, AD Utility, SQL, PL/SQL.
Other Tools: AUTOSYS, Pac2000, Net meeting, VMware Server.
Languages: SQL, PL/SQL, UNIX Shell Programming, PERL Scripting.
PROFESSIONAL EXPERIENCE
Confidential, Richmond, VA
Sr. Oracle DBA
Responsibilities:
- Installed, upgraded and patched Oracle Software and associated application.
- Involved in design and implementation of Oracle Data guard.
- Involved in Backup, Restoration and Recovery strategy.
- Responsible for Oracle database upgradation from 9i to 10g and 10g to 11g.
- Setup 2 node 11g RAC database using ASM on Linux.
- Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
- Performed I/O tuning, Performance Tuning and benchmarking using TeamQuest
- Worked intensively with Oracle support in identifying and patching the 11gR1 bugs.
- Implemented backup and recovery solutions using Shadow Image technologies and RMAN.
- Built 2 node RAC databases using oracle 10.2.0.4 CRS/ASM/RDBMS on Sun T2000.
- Maintaining Tablespaces, Storage management (SGA), Undo Management.
- Routine database activities like applying patches, Cloning maintenance & performance monitoring.
- Configured RMAN backup to tape and scheduled through Autosys on dev and UAT RAC environment.
- Generated and analyzed STATSPACK reports and monitoring statistics for performance tuning of the database.
- Tuned PL/SQL, SQL with Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM)
- Performed Database health checks, and used the notification tool to send the alerts in OEM Grid Control.
- Supported and managed Oracle 9i Real Application Clusters (RAC) environment on Red Hat Linux.
- Applied Database software fixes/patches.
- Built Physical standby databases using Data guard as part of the BCP disaster recovery strategy.
- Identified database bottlenecks using OEM Grid Control, AWR, ADDM, STATSPACK, UTLBSTAT, UTLESTAT, ESTIMATE, ANALYSE, INDEXES, EXPLAINPLAN, SQLTRACE and TKPROF.
- Monitoring and tuned daily Oracle database batch and reports by making available oracle resources.
- Created database security strategies by creating database users, user roles, profiles and audits.
- Involved as an architect for Interfaces and extraction routine for electronic transfer of files from/to different company using SQL, PL/SQL, Stored Procedures and Triggers.
- Shell scripting for automated batch process.
- Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
- Used data pump import/exposure utility of ORACLE to create other development and test databases.
Environment: Oracle 10g/11g, RMAN, Data Guard, Shell Scripting, Toad, RAC, Windows2005/2008, UNIX, ASM, SQL, PL/SQL.
Confidential, Danbury, CT
Oracle DBA
Responsibilities:
- Involved as Oracle DBA and as a PL/SQL Sr. Programmer Analyst
- Database Backup and Recovery solutions including RMAN Hot and cold backups, data pump and export backups, and backup scripting.
- Monitoring and tuned daily Oracle database batch and reports by making available oracle resources.
- Configured RMAN backup to tape and scheduled through Autosys on dev and UAT RAC environment. Involved in creating Production database replication/clones using RMAN/OEM to create development, reporting and user acceptance testing databases & their maintenance on different server.
- Involved in creating database maintenance plans, collecting statistic, rebuild/defrag indexes.
- Involved in Oracle database upgrade from 9i to 10g.
- Implemented ARCHIVE LOG Process and procedures for automatic copying files to development server as they generated.
- Activities included allocation and maintenance of rollback segments, tablespaces, data files, redo log files, mirroring of redo log files across multiple disks, creating Standby Databases and applying patches.
- Installed, Configured and fine tuned RAC for the production databases.
- Implemented optimal backup and recovery procedures using RMAN, and planned for Disaster recovery sites.
- Successfully provided 24x7 support for production, development, and test database.
- Performed Schema Management, Index rebuilding, Analyzing the tables and indexes, removing the row chaining.
- Implemented Automatic Electronic Data Exchange as per HL7 Standards.
- Responsible for making sure data storage and transmission is Secure and Auditable according to HIPAA regulations.
- Involved in conversion of data from old DB2 to Oracle database.
- Upgraded and migrated databases from Oracle 9i to 10g.
- Created database security strategies by creating database users, user roles, profiles and audits .
- Involved in the writing Interface and extraction routine for electronic transfer of files from/to different Bureaus on Oracle database using SQL, PL/SQL, Stored Procedures and Triggers.
- Created Oracle PL/SQL programs, Shell scripting for automated batch process.
- Perform tuning of databases based on analysis of utilities such as TKPROF, EXPLAIN PLAN, etc.
- Used data pump import/exposure utility of ORACLE to create other development and test databases.
Environment: Oracle 9i/10g, RMAN, Putty, Shell Scripting, RAC, HL7, HIPAA Toad, PL/SQL Developer, Windows, UNIX, IBM RS6000.
Confidential, Coral Glabes, FL.
Oracle DBA
Responsibilities:
- Involved in development of different modules using Oracle PL/SQL.
- Involved in the writing extract & Interface routine for electronic transfer of files from/to different agencies on Oracle database using SQL, PL/SQL, Stored Procedures and Triggers.
- Design and implement database backup/recovery and security strategies.
- Responsible for Database monitoring and tuning.
- Extensively used Disaster recovery techniques using RMAN.
- Responsible for application programming, Implementation and Testing.
- Involved in documenting business/functional/design requirements.
- Developed data entry screens using object oriented programming concepts such as inheritance, reusable Objects reusable functions.
- Used window functions, Structures, used dynamic data window, extensively used PowerBuilder PFC.
- Involved in designing the application using PowerBuilder and advanced PL/SQL.
- Involved in developing data entry screens for ICPC, ICJ, DYC & others.
- Responsible for Object Oriented Analysis and design techniques.
- Used PVCS version control software for configuration management.
- Development of Oracle PL/SQL programming (dynamic procedures).
- Interacted with end user to solve their production related problems.
- Attended day-to-day Database related issues and trouble shoot to resolve them.
Environment: Oracle 10g/9i, UNIX, Windows Shell Scripts, PowerBuilder, SQL, PLSQL, RMAN, Crystal Reports.
Confidential
DBA
Responsibilities:
- Installing & upgrading the Oracle database server v 9i.
- Installing & applying patches to the Oracle database server v 9i on Linux.
- Monitoring and optimizing the performance of the database. Controlling and monitoring user access to the database.
- Generated and analyzed STATSPACK reports and monitoring statistics for performance tuning (SQL usingTKPROF) of the database.
- Database Recovery (both complete and incomplete) from media failure
- Sound experience in administrating the large live production (24X7) databases.
- Performed database administration tasks for the project.
- Responsible for writing Database stored Procedures & Triggers.
- Designed and developed the general accounts module.
- Implemented Locally Managed Tablespace to manage space more efficiently, to reduce fragmentation and to increase reliability.
- Good Co-ordination with System Administrators and Network Administrators to achieve zero down time and better server performance.
- Implemented the Master module of the Sales Order Processing System.
- Extensively involved in maintaining & updating the database documentation. Migrated the Sales Order Processing from PowerBuilder V5.0 to V6.0 then to V7.0.
- Conversion of the database from MS SQL Server V6.5 to V7.0.
Environment: Oracle Enterprise Manager, Oracle 9i/10g, MS SQL Server V6.5 & V7.0, PowerBuilder, Windows 95/98/2000/NT.