We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

0/5 (Submit Your Rating)

Bothell, WA

SUMMARY

  • Over Eight years of experience working for major corporate clients in several challenging projects. Worked in various phases of Analysis, Design, Implementation and Support which includes Databases, Applications on SUN Solaris, Linux, HP/UX and Windows NT.
  • 8 years of wide Oracle 7.3, 8.0, 9i, 10g & 11g in production environment.
  • Experienced in relational DB designing, comprising physical/logical designing.
  • Passed on experience with the Oracle designer, Developers, Oracle Form/Report/Enterprise Manager/OEM
  • Experienced with Unix, Solaris, AIX, NT, Linux, & Window 2000
  • Installed, configured, maintained RAC databases
  • Experienced in Installing, maintaining Standby DR servers using Dataguard
  • Design and implement of database backup strategy and performed full, incremental and Cumulative backups using RMAN. Troubleshooting with RMAN backup problem.
  • Performance monitoring/tuning/troubleshooting on for systems: Oracle, UNIX, Linux, and Windows NT/2000/2003 servers.
  • System resource management including bottleneck detection, contention tuning on SGA, CPU, Memory and I/O etc.
  • Ability to prioritize and meet operational deadlines in fast paced environment with good stress management skills.
  • Unix Shell scripts for hot backups, SQL*Loader, export and import of database.
  • Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager, ADDM, TOAD, monitor users, table spaces, memory structures, rollback segments, logs, and alerts.
  • Extensive experience in 7*24 production database support.
  • Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
  • Design, development, and testing of backup and recovery to ensure complete recoverability.
  • Solid experience in disaster recovery, routine maintenance for Oracle databases.
  • Security management for database, network, and operating systems.
  • SQL Net installation/configuration/troubleshooting (Server and Client side).
  • Storage Management including fragmentation detection, tablespace growth ratio.
  • Excellent interpersonal and strong analytical, problem - solving skills.
  • Experience in oracle features like Oracle Streams (capture, sharing, apply) and Replications

TECHNICAL SKILLS

Operating Systems: Windows NT4.0, Sun Solaris, Linux, HP-UX, AIX

Languages: SQL, SQL*Plus, PL/SQL, C/Unix, C++, UNIX Shell Programming, C, C#, V.NET

Databases/Tools: Oracle 8/8i/9i/10g/11g, Oracle Enterprise Manager(OEM), SQL*Loader, RMAN Export/Import, Data pump, Oracle Tuning Pack, Erwin

PROFESSIONAL EXPERIENCE

Senior Oracle DBA

Confidential, Bothell, WA

Responsibilities:

  • Installation, Configuration and Administration of Oracle 11g database.
  • Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
  • Build 2 Terra Bite Data Warehouse on 11gR2 RAC (2 node) with ASM on UNIX platforms
  • Responsible for allocating system storage and planning future storage requirements 10gigabyte- 45terrabyte for the database system.
  • Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance bottlenecks using STATSPACK, UTLBSTAT, UTLESTAT, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE and TKPROF.
  • Written UNIX Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding
  • Implemented backup and recovery procedures using RMAN with VERITAS Net Backup, Import/Export & Data Pump (impdp/expdp).
  • Worked on testing, pre-production stages of RAC implementation on UNIX.
  • Created, upgraded, and cloned Oracle databases for Development and testing databases.
  • Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
  • Installed and configured OEM Grid Control and intensively used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
  • Created users, roles and granted privileges according to the business requirements.
  • Supporting both production and development activities. Worked with the databases sizes ranging from and the number of databases are 84.
  • Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
  • Successfully providing 24x7 supports for production, development, and test database.

Environment: UNIX, Oracle 11g, OEM, RAC, Data Guard, PL/SQL, Export/Import, RMAN, ADDM, AWR, TOAD

Senior Oracle DBA

Confidential, Minneapolis, MN

Responsibilities:

  • Responsible for Oracle11g logical and physical databases design, implementation and maintenance on UNIX.
  • Supported an environment consisting of 11g RAC and standalone databases on UNIX
  • Worked on Oracle configuration and Performance Tuning
  • Extensively experienced in Oracle Database monitoring and Tuning using GRID control/Oracle Enterprise Manager (OEM) monitoring.
  • Installed and configured standby DR servers using Dataguard
  • Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software Legato troubleshoot and backup testing.
  • Developed some Shell scripts to automate database operation and database monitoring.
  • Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN to implement Oracle backup and performed a number of times of disaster recovery.
  • Support ETL functions for Data warehouse/Data Mining
  • Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
  • Performed database tuning using Explain Plan, hints, utlbstat/utlestat, Toad, AWR, ADDM and Enterprise Manager.
  • Provided on-call production database support. Moved database Schema changes to stage or production. Installed and setup replicated instance of Oracle database for supporting Internet application and reporting.
  • Utilized various options available in exp, expdp and imp, impdp
  • Designed and architected database server for higher availability, performance and capacity.
  • Designed and developed data model for application enhancements.
  • Re-organized database and re-architected application server to resolve performance issues.
  • Coordinated with System administrators, application developers, DBA team players before Applied Opatch in 11g.
  • Monitored database and application, tuned SQL queries, indexes, Oracle initialization parameters, and clustered application servers.

Environment: UNIX, Oracle 11g, OEM, RAC, Data Guard, PL/SQL, Export/Import, TOAD

Senior Oracle DBA

Confidential, Minneapolis, MN

Responsibilities:

  • Installed and configured Oracle 11g database server for multiple applications involving DSF & OLTP systems.
  • Implement and maintain database security (create and maintain users and roles, assign privileges).
  • Responsibilities included data modeling, backup and recovery, performance tuning, maintaining data security, applying upgrades and patches to the database servers and Oracle 11g software, storage monitoring, ETL process design, development, implementation and automation via scripting and scheduling.
  • Installed and configured 11g Real Application Cluster (RAC) databases on Redhat Linux versions 4 and 5 and Windows 2003 Advanced Server using both Oracle Cluster File System (OCFS) and Automated Storage Management (ASM).
  • Designed, built, and configured several distributed Oracle 11g Application Server web environments whose components include Oracle Portal, Oracle Web Cache Oracle Internet Directory, Oracle Single-Sign On Server, Oracle Discoverer, Oracle Forms and Reports.
  • Monitored the hosts via the monitoring tools: Tivoli, HP Service manager and Mail Tools, as well as on NT.
  • Assisted customers in developing backup and recovery strategies.
  • Performed various tasks in administration of databases including capacity planning, instance creation, performance tuning, storage management, backup and recovery and general troubleshooting.
  • Participated in various database development activities such as designing and implementing ETL processes using PL/SQL stored procedures, SQL scripting, and various interfaces to disparate database systems.
  • Installed and configured an array of server-side software including Oracle Designer, Oracle Warehouse Builder, Oracle 11g Enterprise Manager Grid Control, Oracle Lite, Oracle Mobile Development Kit.
  • Performed reports requirements gathering and developed reports using Oracle Discoverer reporting tool.
  • Supported and maintained 3 production database servers.
  • Loaded Data into Oracle Database using SQL*Loader.
  • Wrote SQL*Loader control files for uploading legacy data to tables.
  • Monitoring the database, archiving, tuning.
  • Using Oracle Enterprise Manager (OEM) for different DBA activities on daily basis.
  • Good experience working with various FTP protocols like FTP, SCP using SSH protocol.
  • Provide 24x7 on-call support for OLTP database and disaster recovery support.
  • Provide assistance and guidance to Application Services, Operations, System Support, and other business partners as needed.

Environment: Oracle 11g, RAC, Linux 5, PL/SQL, SQL * Loader, OEM, Export/Import

Senior Oracle DBA

Confidential, Bay Area, CA

Responsibilities:

  • Installation of Oracle 10g database server on HP UNIX, and Sun Solaris UNIX. and creating new databases.
  • Administered as many as 24 high traffic databases Confidential a time, representing approximately 14 Terabytes of data accessed by users on and off-site daily.
  • Conducted planning and sizing for Oracle databases running on Windows NT 4.0, Windows 2000, HP UNIX, and Sun Solaris UNIX.
  • Perform the installation of Oracle database server software and creation of Oracle databases and objects on Windows NT 4.0, Windows 2000, HP UNIX, and Sun Solaris for the Aspect Customer DataMart product.
  • Carrying out upgrades of databases using the Oracle Installer. Applying patches to Oracle using Installer and to Oracle Financials using the adpatch utility.
  • Relinking Oracle applications programs and regeneration of Oracle Forms and Reports.
  • Refreshing development database from production using export/import.
  • Be on-call, attend to problems on a daily basis and resolve various database-related issues and customer requests.
  • Creating tablespaces and planning the location of data, index and rollback tablespaces redo log files and control files in adherence to the Optimal Flexible Architecture.
  • Database reorganization of existing databases to meet standards or improve performance.
  • Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
  • Sizing database objects for effective space management and optimal performance.
  • Database server tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.
  • Analyzing tables on a regular basis for the Oracle optimizer.
  • Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases.
  • Monitoring rollback segments. Adopting proactive maintenance strategies to curb extensive shrinking and wrapping of rollback segments.
  • Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
  • Data loading using SQL*Loader to assist Data Warehouse developers.
  • Performed 30+ installations, upgrades, and configuration of Oracle 10g on server and client machines.

Environment: HP-UNIX, Oracle 10g, OEM, RAC, Data Guard, PL/SQL, SQL * Loader, Export/Import, TOAD

Oracle DBA

Confidential, Santa Ana, CA

Responsibilities:

  • Designed and managed production and test databases on Oracle 9i
  • Maintained Oracle DSS data warehouse on both Sun Solaris and Windows 2000 platforms.
  • Created more than 200 tables, indexes, views, sequences etc.
  • Constructed procedures, functions, packages, and triggers using PL/SQL.
  • Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
  • Maintained regular free space checking and daily alert log checking by using UNIX cron jobs.
  • Wrote Triggers (After and Instead of) and stored procedures to capture updated and deleted data from OLTP systems.
  • Installation of Oracle 9i on Solaris 3/4 systems.
  • Configured client/server environment through SQL*Net.
  • Used SQL*Loader to load data into tables.
  • Allocated resources through developing profiles.
  • Audited database for statements, privileges, and schema objects.
  • Performed daily hot backup, weekly cold backup and full export/import.
  • Recovered database to point of time in the past and point of failure.
  • Tested database performance and tuned database based on database performance ratios.
  • Participated in migration from Oracle8 to Oracle9i.
  • Managed large tables using index and table partitions.
  • Database troubleshooting and on-call supporting.

Environment: Sun Solaris, Oracle 9i, OEM, RAC, Data Guard, PL/SQL, SQL * NET, SQL * Loader, Export/Import, TOAD

Oracle DBA

Confidential

Responsibilities:

  • Created and maintained Oracle8i databases on Unix to store the structural analysis data of different projects.
  • Generated reports from the database using PL/SQL and SQL.
  • Developed various computer programs to automate the post processing of finite element structural analysis using C++.
  • Created different Unix Shell scripts to help stress analysis tasks.
  • Added more new features to existing analysis software tools.
  • Developed MS Excel Macros for different applications.

Environment: PL\SQL, SQL*PLUS, Oracle 8.0 and Oracle 8.i., SQL Navigator, MS Access 2000, MS Word 2000, MS Excel 2000, MS PowerPoint 2000

Oracle DBA

Confidential

Responsibilities:

  • Installation and configuration of Oracle 8.1.6 server and creation of databases.
  • Creating tablespaces and database files based on the OFA model. Implemented physical database design after sizing tables and indexes and creating tablespaces taking into account I/O load distribution.
  • Locally managed tablespaces were used which track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.
  • Performed SQL tuning by using Explain Plan and Tkprof.
  • Making structural changes to the databases when database design changes are to be implemented.
  • Implementation and maintenance of read only snapshots and snapshot logs.
  • Migration from Oracle 7.3.4 to Oracle 8.1.6 using Oracle Data Migration Assistant and mig utility.
  • Refreshing development/test database from production using Export/Import. This is done so that the latest data is available in the development/test database.
  • Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.

Environment: Oracle 8.1.6/7.3.4 , HP-UX 10.2/11.0, HP 9000, Windows NT 4.0, Compaq Proliant, ERWin 3.5, Informatica PowerMart 4.6, Oracle Replication Manager, Export/Import, Unix Shell Scripts, TOAD, Tkprof and SQL*Net

We'd love your feedback!