We provide IT Staff Augmentation Services!

Oracle Database Administrator (dba) Resume

Arlington, VA

SUMMARY:

  • Oracle 11g - Oracle Certified.
  • Database administration experience ranging from managing, upgrading, performance tuning, replication, troubleshooting, testing in multiple OS/environments.
  • Skilled in reducing cost by driving process improvements. Strong background and proficiency in database design, analysis, data security and integrity.
  • Create and manage users and ensure data security by granting privileges, roles and profiles to users.
  • Repository Administrating Utility SQL*Net Configuration.
  • Operating Systems: Oracle unbreakable Linux, Windows, UNIX (Oracle, Sun Solaris), Linux including Linux scripting skills.
  • Languages (& scripting):SQL,PL/SQL, J2EE, PHP, Drupal, Kornshell
  • Oracle Experience: Oracle Database 10g/11g, Data Guard, Golden Gate implementation, Oracle Critical Patch Update, Oracle Rightnow Cloud Service.
  • Experience in data advanced security administration role in Label security, Audit vault, Data vault.
  • Performed database refreshes using RMAN and created standby databases.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Oracle Database Administrator (DBA)

Responsibilities:

  • Responsible for Oracle 11g logical and physical database design, implementation, and maintenance. Reorganize databases and size database objects to meet standards and improve performance.
  • Administered and managed 20+ RAC production databases of sizes up to 10TB in various datacenters.
  • Performed migrations of Oracle 10gR2 databases from LDOMs (Oracle VM) to Oracle 11gR2 ASM databases.
  • Perform daily incremental backup level one and weekly incremental backup level 0.
  • Monitored daily RMAN reports and created status update to teh higher management.
  • Performed database refreshes using RMAN and created standby databases.
  • Managed multiple DataGuard Disaster Recovery and System Replication processes using Streams, ensured synchronization between teh primary and standby database, and performed manual intervention when required.
  • Used customized templates to create teh target databases based on teh Oracle components installed in teh source databases.
  • Performed migrations as per client standards, regulations, security, policies and procedures. Worked with teh Migration Team, Team Leads and Sys Admins.
  • Coordinated teh migrations with teh Application Team and teh Applications DBAs. Performed validation reports comparing teh source and target databases.
  • Documented teh procedure for a Data Pump migration of source databases having encrypted data and Oracle Wallet.
  • Created new databases, involving importing and exporting; installed and configured database software for Oracle Application development environment.
  • Handled database server tuning, application tuning, maintaining documentation, and Capacity planning and database security.
  • Provided a 24/7 availability and coverage of technical assistance through teh use of emails and cell phones for mission critical Databases.
  • Provided 24*7 support and report to teh Operations Manager and teh VP of Operations.
  • Installed Oracle 10g cluster, ASM and database on Windows 2008.
  • Assisted teh application developers with performance issues and database change requests.
  • Coordinated system maintenance with Support Specialists and System Engineers.
  • Managed space allocation and work with teh Storage and Network Engineer.

Confidential

Oracle Database Administrator (DBA)

Responsibilities:

  • Collaborated with teh system Administrator to configure any software and hardware requirements that will function with teh Oracle Database
  • Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis, Design, Test and Implementation through teh phases of System Development Life Cycle.
  • Worked with application developers to address and clarify data requirements to resolve technical and functional issues by enforcing corporate business rules through adequate user/resource/object management.
  • Reconciled functional and technical problems through interaction with clients by researching and identifying teh defined issues and by fully testing and confirming possible solutions to teh problems encountered.
  • Installed, created and configured Oracle 10g and 11g Oracle Databases (Windows and UNIX) platforms using Oracle Database Configuration Assistant or manually by using Oracle Database Dictionary, table spaces.
  • Established capacity planning of table spaces, tables, indexes, and databases to allow for growth potential.
  • Established, designed, tested and implemented backup and recovery solutions including automated daily hot/cold backups depending on criticality of teh Database - (RMAN, EXP/IMP, DATAPUMP and shell scripts) and database migration.
  • Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, and production environments.
  • Provided performance tuning activities for Oracle database improvement, Tuned Database through initialization parameter, SQL statement and memory by performing routine checks of teh SGA. CPU, Logical and Physical me/O and contention.
  • Techniques like applying recent patches and upgrades, appropriate user grants, permissions and profile management.
  • Restructured, tuned tracked, proactively monitored database load, fragmentation, contention, and overall performance for optimal performance of teh existing database.
  • Monitored database growth, created objects, administered users and tuned expensive SQL statements using EXPLAIN PLAN and SQL TUNING ADVISOR...
  • Provided a 24/7 availability and coverage of technical assistance through teh use of emails, cell phones, and PDA’s for mission critical Databases.

Confidential

Business Analyst - Oracle Support

Responsibilities:

  • Identified new value sources by conducting industry and client research and Designed/administered business processes and systems.
  • Facilitated deliverable transition between project life cycle stages and ensured that key project deliverables were effectively transitioned and placed under configuration management.
  • Implemented quality management processes such as process and product quality assurance (PPQA) and other quality-related reviews (e.g., Quality and Process Improvement or QPI best practice reviews)
  • Provided system architecture recommendations to reflect OFA Recommended RAID levels and STRIPE Sets.
  • Configured UNIX System kernel that is semaphore settings and shared memory.
  • Developed Backup and Recovery strategies using both RMAN and operating system scripts for Oracle databases supported. Recovered and refreshed databases made up of one terabyte of business data using RMAN.
  • Utilized teh Automatic Workload Repository and Automatic Database Diagnostic Monitor for performance tuning.
  • Configured and maintained data loads in huge Data warehousing systems using teh Information Power Center ETL tool; Supported data warehousing and databases.
  • Performed troubleshooting and fixed Oracle internal database errors with support from Oracle support. Did security update and patch/bug fixes as recommended by Oracle Support.
  • Responsible for database tuning; including table re-orgs; index rebuild; ESTAT report analysis. Detect and tablespace fragmentation and migrations. Tuned SQL queries using “ EXPLAIN PLAN” and TKPROF utilities.

Confidential

Data Entry

Responsibilities:

  • Prepares source data for computer entry by compiling and sorting information establishing entry priorities Processes customer and account source documents by reviewing data for deficiencies; resolving discrepancies by using standard procedures or returning incomplete documents to teh team leader for resolution;
  • Enters customer and account data by inputting alphabetic and numeric information on keyboard or opticalscanner according to screen format;
  • Maintains data entry requirements by following data program techniques and procedures.
  • Verifies entered customer and account data by reviewing, correcting, deleting, or reentering data; combining data from both systems when account information is incomplete; purging files to eliminate duplication of data.
  • Tests customer and account system changes and upgrades by inputting new data; reviewing output.
  • Secures information by completing data base backups.
  • Maintains operations by following policies and procedures; reporting needed changes.
  • Maintains customer confidence and protects operations by keeping information confidential.
  • Contributes to team effort by accomplishing related results as needed.

Hire Now