­­­­­­­­­­­­­­­­­

PROFESSIONAL SUMMARY:

• IT Professionals with Experience in ORALCE DATABASE ADMINISTRATION / ARCHITECT / DATA ANALYST / Application DBA experience with full life cycle Development and Implementation, Data Migration expertise with Oracle Certified Professional (OCP) and PMP Certified.
• Consistently for 9 years working with Confidential &T as ORALCE DATABASE ADMINISTARTOR/ ADBA/DATA Analyst Role. Currently In Richardson, TX
• More than 15 years of IT experience in playing dynamic Roles & Responsibility.
• Expertise in creating database tables, schemas, indexes, normalizing database design
• Expertise in Performance Tuning of Oracle SQL
• Expertise in Re org of database
• Extensive Data Modeling/Migration experience
• Experience in Oracle Backend programming in SQL and PL/SQL, Writing Stored Packages, Procedures, and triggers.
• Expertise in Managing DATABASE OBJECT/Data Dictionary.
• Expert in DML, DDL, DCL, Transactional Control
• Expertise in Security and Database Hardening Implementation
• Expertise in Data pump, Export, Import
• Expertise in Installation
• Expert In Managing PARTITION Tables for Big Database
• Expertise in Oracle Enterprise Monitoring - AWR, ADDM report
• Expertise in troubleshooting
• Maintaining Table spaces, Storage Management, Undo Management.
• User management and provide Database security
• Experience in planning and implementation of Backup and Recovery strategy, used physical backup and logical backup using Export/Import/Data pump.
• Setting up Database Hot and Cold backups using shell scripts.
• Setting up RMAN backups and maintaining catalog schema.
• Migrating Oracle 9i to 10g and 10g to 11g.
• Design and Implementation of Physical standby Database.
• Performing export and import operations, database/schema/table refreshes from production to development and test environments.
• Managing Partitioning of tables. Maintaining Purging/Dropping Large Partition Tables
• Knowledge of Golden Gate done POC for one way replication in Oracle
• Knowledge of Oracle Identity and Access Manger attended Oracle
• Knowledge of Oracle Projects/Oracle Financial /AR/AP application attended .
• Knowledge of Nosql, Mango db

TECHNICAL SUMMARY

RDBMS: Oracle 11g RAC,11g,10g,9i,8i, SYBASE

Languages: SQL, PL/SQL, SQL*PLUS,UNIX shell Script, COBOL

Operating System: UNIX, LINUX, Sun Solaris, DOS, Windows

Development Tools: ERwin, Developer 2000, ORACLE Forms/Reports, Pro*CExp, Imp, SQL*Loader, RMAN

GUI: Oracle Enterprise Manager 10g Grid Control (OEM) 12c

Hardware: SUN Solaris, RS600, HP,Linux

Replication: Golden Gate knowledge one way Replication POC DONE

Application: OIM,OAM,SOS

PROFESSIONAL EXPERIENCE:

Confidential, San Ramon/Richardson, CA

DATABASE ADMINISTRATOR

Software and Platform : Oracle 11g RAC, .Oracle 11g RAC on Cloud

Responsibilities:

• Storage Management, Managing Space, Table spaces, Segments and Extents, & Data Dictionary
• Schedule Gather Schema statistics on regular basis.
• Managing performance & housekeeping activities Purge Concurrent Request, Index Rebuilding, etc.
• Database growth monitor
• Us e r adm inist rat ion an d p ass wo rd p o li cy m an ag e m e n t
• Creation of Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM ) report for Performance Tuning
• Monitoring DB using OEM implementing Profiles for Query, Running Advisor jobs
• Monitoring of alert log files for any ORA errors
• Adding Hints to the query as per requirements for better performance.
• Solving Database issues troubleshooting & resolution
• Perform DB maintenance RE ORG
• Created Database link to access the object on remote database and script to check the connectivity among all the databases.
• Perform ASRP Database Compliance related activities
• Setup customized db monitoring jobs as needed
• Support application Releases (deploy production database code changes, post-release performance monitor)
• Support application team for db related issues
• Participate in impact analysis of any changes made to the database objects (including design review)
• Grant object privileges) as required (work with PDBA on some databases)
• Migration of Schema to Multi Location as per business needs
• Partition Table Maintenance, Dropping Partitions for huge Table.
• Materialized View managing.
• Extensively used new features of 11g like Import, Export and Data Pump logical backup
• Support PMT team (performance review of ad-hoc queries)
• Support db upgrade & application upgrade
• External team support (those who access EDD databases)
• Assist Purge & Archive jobs to Optim team
• Support server maintenance activities
• Manage UAM access to prod & non-prod servers for our team
• Work with Oracle support on technical issues (open SRs, consult onsite support etc)
• Participate in VPMO planning (fill out ITO DBA questionnaire, answer questions from ITO planners, etc.)
• Evaluate Oracle new features and related products & provide recommendation

Confidential

DATABASE ADMINISTRATOR

Software and Platform: Oracle 11g, PL/SQL, SQL, OEM, TOAD

Responsibilities:

• Performance Tuning of Query and Application
• Provided Performance Plan and cost of the query to application team
• Generate AWR and ADDM Reports.
• Suggested changes to the Developers
• Memory, Database and Sql/Pl/sql tuning

Confidential

Database Administrator

Software and Platform Oracle 10g Database

Responsibilities:

• Identify Database Vulnerabilities and Threats
• Create a documentation/presentation outlining the Techniques used by hackers to exploit database flaws and vulnerabilities for customer presentations.
• Build/identify database assessment and database penetration toolkit
• Create Database Hardening process for Commonly used databases

Confidential

Project Manager

Software and Platform Oracle 10g Database, Oracle Identity and Access Management

Responsibilities:

• Interaction with onsite Test coordinator, Developer coordinator
• Involved in BAU setting up Environment
• Involved in writing the automated scripts for the PeopleSoft database to Compensation Advisor for the Outbound and Inbound Interface.
• Involved in Joint SIT and UAT for Bank Of Montreal.
• Data Migration - prepared automated database scripts.

Confidential

Test Manager

Software and Platform People Soft, Web Based My HR

Responsibilities:

• Involved in BAU setting up the application access and validation of Application Access.
• Data Migration as per business requirements for Confidential client.

Confidential

System Analyst /Team Lead

Software and Platform Oracle 9i, Oracle Developer 2000

Responsibilities:

• Full life cycle project I was involved in requirement study to Development and Implementation. I was leading 4 team members.
• Data Migration as per business requirements for Confidential client.

Confidential

Database Administrator

Software and Platform Oracle 9i, Oracle Developer 2000, Java

Responsibilities:

• Installation of Oracle 9i
• User creation and Access to the development team
• Maintenance of Database and Refreshment