We provide IT Staff Augmentation Services!

Database Administrator Resume

San Ramon Richardson, CA

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

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

Hire Now