We provide IT Staff Augmentation Services!

Oracle Dba Administrator Resume

Midland, TX

SUMMARY:

  • Having 12 years’ experience in IT as Oracle database administrator in high - end enterprise environment (DB size: from 80GB to 12TB).
  • Solid hands-on experiences and outstanding troubleshooting skills of ASM and Data Guard.
  • Installation, configuration, upgrading and migration of Oracle database software (8i/9i/10g/11g). Applying patches under Unix (AIX/HP-UX/Solaris), Linux and Windows platform.
  • Proficient in database backup skills such as user-managed backup, RMAN-managed backup with or without catalog, OS backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.
  • Install, support, tuning, backup, restore and maintain Window server 2003, 2008 and SQL server 2000, 2005, 2008.
  • Performing customer service, cash count and checking product availability;
  • Placing orders and maintaining location with the highest level of customer service;
  • Performing data analysis;
  • Performing statistical analysis; and
  • Performing data modeling.
  • Expertise in Monitoring and Performance Tuning of Oracle database through Tuning Applications, Tuning Memory and Planning Disk Usage.
  • Highly skilled in Partitioning, Rebuilding Tables/Indexes, SQL Tuning, Materialize Views, Parallel Query, TKPROF, AWR, ADDM.
  • Excellent knowledge in Oracle Enterprise Manager (OEM), grid control, third-party tools such as TOAD.
  • Experiences with data modeling, logical and physical database design using Erwin.
  • Excellent English writing, verbal and communications skills. Strong team player and be able to work alone. Highly self-motivated and able to adapt and learn new technologies quickly.

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/2003/XP, Sun Solaris, HP-UX and UNIX

Languages: SQL, Oracle, Visual Basic, Visual Web Developer, Visual Studio, Java, HTML

Databases: Oracle 8i,9i,10g,11g and SQL SERVER 7.0

FRONT END Tools: Visual Basic 6.0,TOAD 7.4,Developer 2000, Erwin 4.0, Business Objects XIR2

TOOLS: OEM 1.x/2.x,SQL*LOADER,SQLPLUS,SQL*Net8,RM

PROFESSIONAL EXPERIENCE:

Confidential, Midland, TX

Oracle DBA Administrator

Responsibilities:

  • Providing production and development database support and maintaining them stable.
  • Cloning the databases when and where required for development and testing activities.
  • Installed RAC on Oracle 10g and worked on ASM feature of Oracle
  • Space management proactively adding space for smooth execution of the jobs.
  • Monitoring the daily backups of all the production databases.
  • Imported and exported files, databases, schemas and tables using utilities when required.
  • Developing Backup strategies (Snapshot, Hot, and Cold) for weekend backups on all environments.
  • Upgrading databases from Oracle 10g to 11g.
  • Co - ordinate with UNIX administrators for space managements on various servers.
  • Resolved table space issues, disk space issues and problems like listener down, tns names errors etc from the end user interaction.
  • Applying patches both Server side and Client side
  • Used GUI like Oracle Enterprise Manager and TOAD to monitor the databases.
  • Implemented data guard.
  • Granted and revoked privileges to users as per requests and maintained database security procedures.
  • Setup backup and recovery procedures using RMAN.
  • Developed Cron jobs to automate the backups, monitoring Alerts.
  • Allocating system storage and planning future storage requirements for the new environment to be set up.
  • Performed Database and SQL tuning by using various Tools like AWR and EXPLAIN PLAN.
  • Improved Performance of the database by troubleshooting whenever payroll run happens on the database for high performance output.
  • Extended Work on planned weekend outages for critical projects and bug fixes based on the criticality.
  • Worked on the Service Now to handle user tickets, Incidents and Service requests.

Environment: Oracle 9i, 10g, and 11g, SQL, Oracle Enterprise Manager (OEM), SQL plus, Putty, RMAN, ERWIN, Service Now Tool, AWR, EXPLAIN PLAN, FTP professional, TOAD, Solaris and Linux, Exp 9i, 10g, Imp 9i, 10g.

Confidential, Deerfield, IL

Oracle DBA Administrator

Responsibility:

  • Working on Database high availability planning and deployment. Installed, configured and maintained Oracle 10g/11g), Oracle grid on Redhat Enterprise Linux 4 serials, IBM AIX 5.3 and Sun Solaries.
  • Set up and maintained oracle disaster recovery site using Data Guard.
  • Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export / Import utilities and SQL*Loader. Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.
  • Setup, support Oracle advance replication to mange standby database.
  • Installed Oracle database 10g/11g, and upgraded Oracle 9i to 10g/11g. Patched Oracle Database Server 9i and 10g using Opatch. Cloned and refreshed production database to testing and development environments.
  • Install and configured databases on Window server 2003, 2008 servers
  • Trouble shooting and resolving any database and/or application issues or errors that occurred.
  • Technical lead for a large number of tuning projects. Performed application, SQL, and database instance tuning using a wide range of technologies including ADDM, AWR, Statspack, OEM Performance Manager, Spotlight, and custom scripts by using bash, perl.
  • Created an automated, enterprise wide monitoring infrastructure using several key technologies including UNIX shell scripts, Perl, Java, and SQL. This allowed our operational DBA team to efficiently gather database metadata, exceptions, and performance statistics for remote clients running Oracle using a consolidated Intranet approach.
  • Modified database structures including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
  • Provided on-call support regarding production-related database problems.
  • Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
  • Worked with Vendors, IT managers and application developers to ensure the database integrity, high availability and security. Provided all kinds of DBA support to development teams as well as production support to various applications.

Environment: Oracle 9i/10g, Server Red Hat Enterprise Linux Advanced Server/Enterprise 2.1/3.0,AIX,HP-UX,Solaris Windows Server 2000, VERITAS Net backup, UNIX Shell Scripts, TOAD.

Confidential

Database Administrator

Responsibilities:

  • Improved the scalability, accuracy and automation of technical reports for critical company assets.
  • Developed, maintained, and conducted quality control of transportation reports
  • Created technical documentation, process documentation and provided program and technical training to analysts to efficiently utilize databases for operations reporting. coordinated firewall requirements to enable applications, coordinated connectivity requirements (sizing, testing, equipment provisioning and vpn), coordinated NDA requirements associated with network security, coordinated hardware provisioning (data center, pc's, servers, laser printers), coordinated data storage requirements (space calculations, managed & unmanaged, back-up and contingency expectations), coordinated software requirements (tools, connectivity, common firewall issues), managed Oracle database administration related tasks, managed Unix system administration related tasks, managed files server, version control, managed workstation issues, and accommodated other project requests as value-added service. For all,
  • I used skills and tools like sql, unix shells/commands, windows batch commands, msoffice suite and, free tcp/ip software

Confidential

Database Tester/Programmer

Responsibilities:

  • Performed data and statistical analysis for key metrics.
  • Administered and maintained databases while performing data modeling.
  • Create a backup and recovery policy. 24*7 production Support of more than 110 critical Production databases. Installation of Oracle 8i/9i/10g/11g and database creation
  • Scheduling jobs at regular intervals- using DBMS JOBS, CRONTAB and in OEM. Removal of Row Chaining/Migration. Proper Setting of Initialization parameters. Implementing Patches for upgrades, fixes bugs. Performed database upgrade from 10g to 11g. Statistics Collection for Performance Improvement.
  • Generating stats pack reports/AWR on regular basis to identify the database performance at peak load. Tuning the SQL statement by analyzing the explain plan and ADDM reports. Migrating the data from one database to the other using Export / Import Utility. Scripting the Backup of Development and End-To-End Environment using RMAN utility on to Disk / Tape. Migrating the databases from one server to the other using RMAN utility. Setting and maintaining database high availability solutions like Real Application Clusters.
  • Generated reports and ensured development complies with internal and international coding standards.

Confidential

DBA Consultant

Responsibilities:

  • Software Installation, Upgrade, Patch implementation on Oracle versions 10g 11g & 12c and on all operating platforms including Linux, Solaris.
  • Setting up Data Guard for replication. Failing over, switchover, and configuring broker etc.
  • Experience in Unix Shell Scripting and SQL scripting.
  • Good understanding of security and backup strategies to ensure database integrity, and excellent knowledge in database Backup & Recovery, and Database Cloning/Refresh.
  • Experience in Capacity Planning and Space Management. Performing customer service, cash count and checking product availability;
  • Placing orders and maintaining location with the highest level of customer service;
  • Performing data analysis;
  • Performing statistical analysis; and
  • Performing data modeling.

Hire Now