We provide IT Staff Augmentation Services!

Database Administrator Resume

Columbus, OH

SUMMARY

  • Work as a highly motivated Oracle DBA with team skills, problem solving skills and communication skills maintaining high customer satisfaction and increasing productivity of the company.

TECHNICAL SKILLS

Tools: Oracle 9i/10g/11g, RAC, Data guard, Streams, ASM, RMAN, EM Grid 9i/10g/11g, expdp, impdp SQL loader, SQL developer, TOAD, SQL, PLSQL, AWR, ADDM, TSM/TDP

Operating Systems: Linux, Unix, AIX, Sun Solaris, Windows 2003

Databases: Oracle 9i, 10g, 11g, SQL Server 2005/2008 R2

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Columbus, OH

Responsibilities:

  • Administer multiple Oracle databases including versions 9i, 10gR2, 11gR2
  • Administer Oracle 11g Grid control.
  • Build Oracle databases, apply patches on regular basis.
  • Build SQL server cluster databases.
  • Provide day - to-day support to Oracle databases and SQL server 2005/2008 R2.
  • Provide support to different application teams.
  • Refresh data from production to non-production databases
  • Provide support to backup and recovery of databases using RMAN with TSM/TDP.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

  • Provide production support for multiple databases non-RAC, RAC, Streams and Grid11g.
  • Support database versions 10gR2, 11R2 on Linux servers.
  • Do ETL of data from non-oracle sources to oracle tables using SQL loader and automate the process using windows scripts, triggers and transform data using procedures.
  • Provide support to end-users from different teams like development, business etc.
  • Provide admin support to APEX applications.
  • Provide support for security vulnerabilities for the databases.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

  • Provide 24/7 on-call support for multi-terabyte databases version 9i, 10g and 11g through Grid10g.
  • Provide production support for multiple databases non-RAC, RAC, ASM, Data Guard and Streams.
  • Provide support to applications like Retek, WMS, SOA.
  • Ensure data and media recoverability by doing RMAN backups on recovery.
  • Convert non-ASM to ASM databases and vice-versa.
  • Clone Production databases to Development, QA and Training databases based on requests.
  • Coordinate with different customers like business users, developers, managers etc for business reasons.
  • Load and unload data using data pump, export and import into partition tables.
  • Install, configure and maintain Oracle database and Oracle client as business requirement.
  • Set up procedure to audit database regularly to comply with the PCI standards.
  • Upgrade and apply Critical Patch Updates to databases and oracle software for security reasons.
  • Handle databases on multiple operating systems like AIX, Sun Solaris, Unix, Linux, Windows 2003
  • Monitor and tune the database using AWR, ADDM, SQL Tuning Advisor for optimum performance
  • Write shell scripts and cron jobs against the databases for business reasons.
  • Create objects based on customer requirements for project enhancement.
  • Partition tables based on business needs for a better performance.
  • Worked on complete project/software life cycle and co-ordinate with different teams to complete projects.

Oracle DBA

Confidential, Columbus, OH

Responsibilities:

  • Doing Oracle DBA Production Support, to make sure the database is available 24/7
  • Backup Production, Development, QA and Training databases everyday using RMAN and NetVault.
  • Cloning production databases for Development, QA testing and Training based on requests.
  • Upgrade database to versions which is compatible for the patch updates.
  • Apply CPU to databases of all different versions for security requirements.
  • Monitor the database using EM Grid10g.
  • Do data pump, export and import for data loading and unloading.
  • Trouble shooting any issues and make sure database was available to the developers 24/7.
  • Troubleshoot any backup failures and fix the issues and do database recovery when necessary.
  • Coordinate with developers and users determine their requirements.
  • Work with different team to assist with different projects and cross-functional projects.
  • Restore any database based on the requirement of the IT team.
  • Create roles, db links, privileges based on the business needs and assign them to the users.
  • Do any database installs as well as forms/reports installs as and when required.
  • Manage and Administer Business Objects accounts for developers.
  • Work on data dictionaries and schemas.
  • Document all troubleshooting steps for future reference.

Hire Now