OBJECTIVE

• To obtain a challenging position Oracle Database Administrator utilizes my skills to contribute to the company’s success.

SUMMARY

• Over Six plus year of expertise in Oracle 9i\10g\11g, Dataguard and Cluster management. Extensive performance tuning experience, specializing in instance tuning. Expert in Database management and Storage management. Expertise includes:
• Experienced with multiple unix flavours like AIX, HP - UX, Solaris, Linux and Windows
• Extensive experience in Installing, upgrading, patching and troubleshooting Oracle DB Server
• CRS resource management: Experienced in Adding/Deleting/Relocating Instances, DB, listener, node apps, Services
• Clusters: Experienced with managing HACMP on AIX, Service Guard for HP-UX and Clusterware on Linux
• Extensive experience in installation of Oracle rdbms, Grid Infrastructure software involving fresh installations, upgrades, patches.
• Experience implementing Backup and Recovery procedures, Performance tuning, database reorganization, space Management, Capacity Planning, Problem resolution.
• Excellent expertise in Data Loading Techniques using SQL* Loader, PL-SQL Collections.
• Configured and Maintained Oracle RMAN Backups along with integration with different tape media library.
• Reorganized databases to avoid disk rotation for maximum performance, shrink datafiles to reclaim fragment space.
• Implemented features like UNDO table spaces, Presumable space management, Segment space management, Redefining Tables, Partitions.
• Planned and implemented DR & high availability solutions using Oracle 9i/10g Dataguard
• Creating Materialized View and Using Query Rewrite for Performance.
• Maintanance of Physical Dataguard and troubleshoot syn issues of primary/standby
• Apply security/PSU patches. Validate database structure. Troubleshoot failed component in upgrade process.
• Upgrade ASM and RAC from 10g to 11g rel-2 with Grid Clusterware configuration and update ASM metadata with 11g using ASMCA
• Sound Logical and Physical Oracle Database Design skills.
• Experience in PL/SQL coding such as Functions, Stored Procedures, Packages and Triggers.
• Experience on Database management tools like Toad, Oracle Grid Control/OEM configuration and Agent installation, templates for dashboards.
• Provided on call support 24x7 and interactions with offshore teams for business continuity

TECHNICAL SKILLS

Operating System: Window Advance Server, openVMS, Solaris, HP-UX, AIX, Redhat

Programming Languages: SQL, PL/SQL, SQL Tuning, Unix Shell Scripting, Visual Basic 6.0

Databases System: Oracle 11g/10g/9i/8i, SQL SERVER, MS Access 2000/2003/2007

Database Tools: SQL Navigator 4.4., OEM Grid, Toad

Web Technologies: HTML, XML, VB-Script, Java-Script, JSP, Oracle APEX

Application Server: Web logic Server, IIS, Websphere

Documentation Tools: MS Word 2000, MS Excel 2000, Microsoft Project, Visio.

Tools: /Utilities: SQL*Loader, Tkprof, Goldengate 10.4/11.1, RMAN, Erwin, Oracle ERP SystemsPeoplesoft, Oracle EBS 11i

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Sr Oracle DBA

Responsibilities:

• Database Planning and Designing which involves deciding about Logical Storage Structures and Forecasting Future Expansions
• Create, maintain and support both stand alone & RAC 11g databases and instances.
• Configuring database with suitable block size, multiple pools and storage parameters for best performance.
• Upgrade from Oracle 10gR2(10.2.0.4) to 11gR2(11.2.0.3)
• Implement 11g features like SQL Plan Management, Dynamic Sampling, GATHER SYSTEM STATS, Extended Statistic, Variations on Histogram, CASCADE & GRANULARITY.
• Install Oracle supplied tools to assist in database and SQL Tuning like SQLT
• RAC Administration involving managing of instances, ASM, cluster resources.
• Managed ASM storage having mulitple databases. ASM cloning.
• Prepare/Add/remove ASM disks. Troubleshoot ASM crashes & memory problem.
• Optimizing the SQL’s for optimum performance by using TKPROF, EXPLAIN PLAN & TOAD.
• Written pl/sql code for ETL process to load reference data from Master Hub repository and code to accomplish business objects on Shipment, On Demant multi-stop itinearies
• Configuration of 11g Dataguard for Higher Availability of Tier-I databases along with 11g RAC Scalability
• Installation and configuration of Goldengate for replication and resolve issues to sync Databases
• Security Administration and Creation of Users, Managing their roles and privileges for peoplesoft HRMS and Financial Systems.
• Developed shell scripts for tracing Oracle errors, free space in the table spaces and free disk space in Archive destination for production database.
• Experience using Datapump utility for taking logical backups on database, schemas, tables with partitioning.
• Managing Instances, redo log files, Table spaces, Data files, storage structures, rollback segments, Undo segments, Temporary segments, Indexes.
• Provided 24x7 support and carried pager on rotation.

Environment: Oracle 10gR2, 11gR2, Solaris 5.x, Linux (Red hat) 7.0, peoplesoft, SQL Server 2005

Confidential -Tempe, AZ

Senior Oracle DBA

Responsibilities:

• Database administration tasks involving installation, performance tuning, space management, user management, backup & recovery strategy planning.
• Supported customers to install the developed application on different operating system
• Security Management: Creating Users, Roles, Database Triggers.
• Installation of Oracle 10g RAC and administering, monitoring, tuning RAC environments.
• Administration of ASM adding/dropping/rebalancing of disks in diskgroups.
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts
• 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.
• Tuning database and helping developers tune Application.
• Cloning Databases with RMAN to create a mock DB for QA testing and training database
• Involved with the development team to write Stored Procedures, Functions, Packages, Handling Exceptions, creating database Triggers using SQL and PL/SQL in Oracle
• Written korn shell scripts for rman backup (Full/Incremental) and archive log monitor script to take care of filesystem fill up
• Backup and Recovery procedures for the Oracle 10g database, which includes documenting the process Addressing DR Tests and prepare documentation addressing weekly/Daily, analyze jobs connectivity and troubleshooting of connectivity problems between databases and client computers.
• Utilizing DBMS SCHEDULER to create/maintain & administer database jobs.

Environment: Oracle 10g, Peoplesoft Campus, TOAD, Korn Shell Scripts, openVMS, J2EE

Confidential -Des Moines, IA

Oracle DBA

Responsibilities:

• Setup and configured 10g RAC on Win2003 /Redhat Linux /AIX 5.2(add/delete instances) with ASM and 10g Grid Control monitor.
• Created Schema (tables, Indexes, views, sequences, synonyms, roles, packages), grant roles to users.
• Installation of Oracle Forms/Reports 6i on Redhat for HSMS application and resolve all technical issues.
• Database recovery / crashes using hot /cold backups and dump/loads.
• Configured and implemented Physical Standby DB (DataGuard) for Oracle 10g RAC environment.
• Created/modified universes with Oracle backend and exported to repository.
• Reorganized existing database to standardize the placement of various databases related files.
• Managed logical/physical backups for these databases depending on the nature of database set up either full export, partial export or export of just the structure of schema objects.
• Using TCP/IP protocol configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Implemented & designed Oracle Portal 10gAS in 3 tier enterprise distributed architecture with SSO/DAS in secure DMZ tier with configuration of HTTPS/SSL and split the customer database (metadata) on different cluster environment for better performance, availability and scalability
• Installation and Up gradation of Sql Server 2000. Monitoring the DB Server health and tunning accordingly.
• Configured Oracle transparent gateway with Microsoft SQL Server2000.

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of oracle database 8i (8.1.7), 9i (9.0.2) on various OS platforms like HP-UX, Linux and Windows NT, 2000
• Creating and Maintaining of databases.
• Creating table spaces, tables, indexes, data files etc.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Perform capacity planning required to create and maintain database environments.
• Helping to the developing team and data warehousing team.
• Prepare the documents of the process and knowledge transferring about the project to the new team members
• Writing complex queries and procedures using sql *plus and toad.
• Developed shell scripts and automated nightly jobs using crone to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB’s.
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Monitoring the background processes activity, setting the appropriate number of DBWR processes, changing the init.ora parameters etc.
• Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Performing tuning of application with RBO, CBO, using Trace, Tkprof, Explain plan, Statspack, AWR and ADDM
• Monitoring table space size, resizing table space, relocating data files for better disk I/O
• Managing archive logs, DB-links, partitions.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases
• Maintain Oracle schemas and SGA region
• Guiding and leading warehousing team for better performance.
• Created PL/SQL procedures (jobs) to automate maintenance tasks

Environment: Oracle 8i/9i, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Import/Export and Linux, HP-UX, Windows NT/2000