SUMMARY

• 8 Years in Infrastructure team as an Oracle DBA for planning, designing, implementing and maintaining mission critical Oracle databases with Production database skills.
• Work experience in Oracle DB Administration, Production Planning, Change Management, Capacity planning, DR Management, DB upgrades, Migrations, Patching, Performance tuning, Monitoring and Day to Day Core Support on DB performance, data management, data sync, data copy and DB availability, delivery and management end key portfolios.
• Work experience in Oracle from 9i to 11g, 10g/11g/12c RAC, Oracle ASM, OEM and Oracle 9i/10g/11g/12c.
• Primary focus to performance issues in production database, tuning, cost analysis for poor queries, table/index partitioning, scripting and real time monitoring on performance issues.
• Creating automated tools to monitor CPU 100% issue. Tool auto monitors and detects the root cause SQL’s. Fixing is made through tuning efforts, the issue gets resolved.
• Sound Knowledge in building Automation tools to monitor database, tools which work between UNIX and database, knowledge to build instant shell scripts in UNIX.
• Working Knowledge in oracle tools like RMAN, export/import, data pump, OEM, database configuration assistant(dbca), client configuration(net manager).

TECHNICAL SKILLS

Operating System/ Hardware: IBM AIX 5.3 (pseries), IBM AIX 6.1, 4.3.3 / RS6000 (P680, M80 6H1 Model), Sun Solaris 10, Red Hat Linux 3.0, Suse 10, SCO 5.0.5, HP - UX 11.0, Sun Clusters 3.2

Databases (RDBMS): Oracle 10g/ 11g, Sybase 12/15.0, Informix 4, UDB(db2)

Development/Productivity Tools: SQL Loader, Toad 9.1, 10.1, DBArtician, ISQL, SQLPLUS, PL/SQL, Embarcadero DB Artician

Languages: UNIX Shell scripts, SQL*Plus, PL/SQLOracle Tools ASM, RMAN, dbca, export/import, data pump, Net manager

Other Tools: Awk, Ksh scripting, Perl, db2top

Others: Tripwire 7.0, Grid Control, OEM, Autosys, Control-M, Erwin

Data Modeling Tools: Toad Data Modeler 3.4

Server Models: IBM p5-550, p-series, IBM RS6000, M80, P680, S85, HP 9000, K-class, L-class, HP ProLiant BL685c, Sun4u sparc, Veritas Storage

PROFESSIONAL EXPERIENCE

Confidential, VA

Senior Oracle DBA

Responsibilities:

• Manage and administer oracle 11.2.0.3 RAC in production/UAT.
• Perform Oracle migration to migrate database from 11gR1 to 11gR2.
• Manage physical standby in 11gR2, manage/administer ASM.
• Performance tuning in RAC & standalone database develops tools that can record the run time of SQL queries.
• Data copy between production and development servers using data pump utility or RMAN restore.
• Analyzing the 11g optimizer behavior with respect to performance issues and stats gather process.
• Install oracle database 11gR2 in Linux with ASM or GRID home.
• Create/modify backup scripts for oracle which can perform RMAN and TSM backup through autosys jobs.
• Reducing the manual efforts and automating the repeated request. Team saves time on manual efforts.
• Manage and administer UDB(db2), perform database administration work for UDB databases.
• Develop various database tools using shell script, bulk start/stop of database, automated refresh scripts etc.

Confidential, North Wales, PA

Oracle DBA

Responsibilities:

• Managing Oracle servers in Confidential
• Installation of Oracle 10g database in newly configured servers and creation of 10g database.
• Performance tuning on Oracle RAC 10g in Linux (RHEL 3.0).
• Configuration of RMAN backups according to Confidential standards.
• Managing partition tables and index for huge tables. Performing re-organization for partitioned tables.
• Data copy between production and development servers using export/import or data pump utility.
• Analysis of long running inserts, bulk loading and building statistics on redo generation in session level.
• Patching oracle server from 10.2.0.2 to 10.2.0.4.
• Experience in performance tool like tkprof, sql tuning package, OEM and sql trace.
• Experience in DB and Sybase. Performing ETL transformations between heterogeneous databases.

Confidential, NJ

Oracle DBA

Responsibilities:

• Setting up a new 10g database for upcoming projects (Oracle Software installation & database creations).
• Setting up various dev environments using flash copy (breaking the SAN mirror) of production.
• Performance tuning on CPU bottle neck in production AIX servers.
• Range Partitioning of huge tables (> 40 GB) to speed up the regular queries & dbms jobs queries.
• Raising SR’s with Confidential to resolve database bugs(ORA-600) and site specific issues.
• Data copy between production and development servers.
• Monitoring production database using OEM 10g and resolving issues created by poor design of SQL.
• Partition table & partition index re-organization and analyzing of tables/index for better performance.
• Setting up DBA alters for log switching, temporary tablespace issues and issues that require frequent pro-active monitoring.
• SQL tuning using 10g SQL tuning advisor.
• Managing 11g RAC in AIX servers.
• RMAN recovery test in DR site to ensure the production backup are in a recoverable state.
• Automation of database deployment scripts & db deployment procedure in various environment (Production, CVT, QA, Development).
• Checking the health condition of global mirror in off-site (Chicago).
• Re-organization of db objects for better performance and housekeeping activities.
• Setting up 11g test/development environments for impact analysis.
• Analyzing ASH, AWR, explain plan, tkprof and ADDM reports for tuning.
• Refreshing materialized views (mviews) and ETL.

Confidential, NJ

Oracle DBA

Responsibilities:

• Creates and maintains all databases required for development, testing, education and production usage.
• Performs the capacity planning required to create and maintain thedatabases. The DBA works closely with system administration staff becausecomputers often have applications or tools on them in addition to the OracleDatabases.
• Performs ongoing tuning of the database instances.
• Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
• Plans and implements backup and recovery of the Oracle database.
• Controls migrations of programs, database changes, reference data changesand menu changes through the development life cycle.
• Implements and enforces security for all of the Oracle Databases.
• Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.