We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Concord, NH

SUMMARY:

  • Oracle Database Administration Exposure: Experience administering Oracle 9i and 11gR2 instances on HP/UX, Oracle/Linux 6 platforms.
  • Able to review, implement PL/SQL, DDL, DML code installations in support of database testing.
  • Strong knowledge of database refresh / cloning methods. Strong Unix / Linux command line usage. Exposure to RMAN methods.
  • Ability to create, manage objects, manage user schema’s permissions and passwords.
  • Able to monitor database performance, review / analyze Oracle logs. Strong understanding of RDBMS testing life cycle.
  • Service oriented communicator, provides support for end users, developers, analysts.
  • 6 year’s experience using advanced SQL in enterprise level database environments
  • Transform large amounts of raw, complex data into meaningful information.
  • Strong understanding of data warehousing concepts. Advanced SQL query writing (inner and outer joins, sub queries, string functions, data type conversion).
  • Logistics data analysis, financial data analysis, ad - hoc reporting, reconciliation, data modeling, custom database creation, ETL.
  • Reconcile data from dissimilar sources. Able to juggle multiple projects, set priorities, and meet deadlines with spot on accuracy.
  • Additional hands-on Oracle training (see detail): Upgrades, Patching, Backup and Recovery methods, ASM, Performance tuning, Security, Troubleshooting, Real Application Clusters (RAC)
  • Installed and upgraded Oracle 10.2.3 to 10.2.4 to 11gr2 on Linux platform
  • Implemented pre-installation, pre-upgrade, pre-migration checks and recommendations
  • Upgraded OPATCH, installed PSU patch set updates
  • Migrated databases, utilized Data Pump full export to relocate schemas
  • Performed schema comparisons to ensure all objects migrated successfully
  • Used Vi to edit pfile's, .bash profile, Unix shell scripts
  • Linux kernels used: Red Hat, Oracle Enterprise Linux, Fedora
  • Installed and configured Linux and Oracle software on VMWare, VirtualBox
  • Utilized common shells and utilities including Bourne, Korn and C Shells
  • Strong utilization of Linux command line vs GUI tools
  • Implemented Oracle Data Guard physical standby database with Data Guard Broker
  • Configured flash recovery area, fast recovery area, archive logs, RMAN repository and catalog
  • Restored lost data files, redo logs, tablespaces and control files
  • Performed recovery using Flashback Database, Table, Query, Transaction
  • Performed database cloning using backup control file to trace
  • Developed hot/cold/full/incremental user managed backup scripts and recovery strategies
  • Utilized transportable table spaces to export/import objects between databases
  • Created and configured Automatic Storage Management instance
  • Relocated database objects from file system management to ASM with Oracle Managed Files
  • Managed ASM instances using ASM CLI (command line interface) or Enterprise Manager
  • Setup disk groups, configured mirroring, created failure groups
  • Reorganized database using locally managed tablespaces, uniform extents
  • Implemented automatic memory management (AMM)
  • Conducted instance tuning using pfile adjustments to optimizer, targets, buffers
  • Interrogated Shared Pool, Buffer Cache statistics using SQL, Statspack, UTLSTAT
  • Interrogated Latch Status and Contention Metrics using dynamic views or Enterprise Manager
  • Performed SQL Autotrace, utilized TKPROF, explain plan to examine SQL execution plans
  • Implemented suggestions generated by SQL Tuning, SQL Access and Segment Advisors
  • Optimized database performance using Memory, Undo, and Storage Advisors
  • Improved SQL performance using indexes, sequences, hints, profiling
  • Optimized SQL performance by moving indexes into their own tablespaces
  • Reorganized indexes to use Automatic Segment Space Management versus manual
  • Investigated Top SQL, Top wait events via Enterprise Manager or Statspack
  • Utilized Automatic Workload Repository (AWR) via Enterprise Manager or command line
  • Created ADDM, ASH reports using Enterprise Manager or SQL (addmrpt.sql, ashrpt.sql)
  • Generated Workload Repository Compare Period (“diff-diff” ) reports
  • Created and transported SQL Plan Baselines using SQL Plus
  • Influenced the optimizer using extended statistics, index coalesce, adjust PCTFREE
  • Performed security analysis using interrogation scripts, tools and checklists
  • Implemented security best practices following DoD Security Technical Implementation Guide
  • Protected, restricted permissions on Oracle binary files and listener.ora
  • Identified and changed default passwords, enabled password verification function
  • Enforced rules / restrictions regarding login attempts, password changes and resource limits
  • Restricted privileges for users, oracle supplied packages, objects, data dictionary
  • Managed user accounts, profiles, roles, resources using GRANT
  • Monitored database activity using audit log analysis, Logminer
  • Examined diag directory’s database alert logs, user and system trace files
  • Resolved ORA errors using Oracle documentation and various forums
  • Installed Grid Infrastructure, RAC binaries and application software on Oracle/Linux platform
  • Installed, configured, administered, patched RAC and RAC One Node database
  • Installed, configured Instant Client to simulate testing in a client/server environment
  • Conducted testing for automatic eviction, fencing, node re-join
  • Observed / monitored CRSD, CSSD, alert.log files during various test scenarios
  • Created Linux shell scripts to implement Fast Application Notification (FAN) callouts
  • Utilized SRVCTL to manage and monitor instances, create and relocate services
  • Created entries for new services in tnsnames.ora files using Vi editor
  • Implemented, tested automatic and manual Service Failover
  • Configured, implemented Transparent Application Failover policies
  • Configured RMAN to perform full parallel backups of archive logs, control files, spfile's
  • Configured Network File Sharing, enabled shared directories used for cluster wide updates
  • Applied Opatch upgrade to Oracle and Grid Homes, installed rolling Patch Set Updates (PSU)
  • Configured ASM, Oracle Managed Files, Fast Recovery Area in new cluster environments
  • Utilized Cluster Verification Utility (CVU) to verify cluster health and readiness
  • Utilized CRSCTL to manage cluster resources and verify vote disk
  • Installed, implemented Trace File Analyzer, RAC Check
  • Analyzed Global Cache statistics, gc wait events affecting cache coherency
  • Monitored Cluster Cache Coherency statistics (block access latency, transfer rate)
  • Monitored performance using Cluster Database Performance Pages or SQL scripts
  • Investigated ADDM findings at both cluster and instance level
  • Interrogated interconnect configuration, alerts while troubleshooting
  • Interrogated, resolved database blocking locks
  • Optimized cluster performance by utilizing sequences
  • Reduced sequence contention by increasing cache size for hot sequences
  • Converted single instance database to RAC environment using DBCA
  • Converted existing RAC configuration to a RAC One Node single instance
  • Implemented instance failover and relocation for RAC One Node
  • Restored RAC One Node instance to original RAC configuration
  • Reconfigured Enterprise Manager after conversions between RAC and RAC One Node

TECHNICAL SKILLS:

Tools: Oracle, Unix, Linux, Red Hat, SQL Plus, SQL Developer, TOAD, Enterprise Manager, DBCA, Grid Control, VMWare, VirtualBox, Advanced Access and Excel (formulas, pivot tables, v-lookups), SQL Server, SSRS, MySQL

EXPERIENCE:

Confidential, Concord, NH

Oracle Database Administrator

Responsibilities:

  • Administered Oracle 9i and 11g instances on HP/UX, Oracle Linux 6 platforms
  • Utilized change management software to facilitate database changes
  • Installed PL/SQL, DDL and DML scripts in SIT and UAT test instances using SQL Plus
  • Supported developers in review and implementation of PL/SQL code installations
  • Reviewed, edited PL/SQL procedures, packages, and triggers in support of developers
  • Ensured cursors were closed within PL/SQL code blocks
  • Ensured all dependent schema objects were backed up prior to installing code
  • Identified, recompiled invalid objects after database code changes and installations
  • Analyzed and updated object statistics using DBMS STATS packages
  • Utilized cold backup methods to refresh test and development databases
  • Utilized Vi, Unix shell scripting to edit backup trace control file used for cloning database
  • Utilized dblink to copy objects between instances
  • Performed daily DBA tasks such as verify Oracle processes, monitor alert logs
  • Reviewed and cleaned out old log / trace files
  • Reviewed daily back up logs for production and stand by databases
  • Investigated / resolved RMAN backup errors, verified successful physical tape creation
  • Optimized database performance by adding redo logs
  • Stopped and restarted test instances
  • Performed base install of Oracle/Linux 6 server software
  • Configured Cygwin for use with Oracle Universal Installer GUI
  • Installed Oracle 11gR2 instance, adjusted Linux kernel parameters as prompted by OUI
  • Provided technical support of the RDBMS and managed passwords for end users
  • Created new tables in production and test databases
  • Utilized TOAD to interrogate slow database and SQL performance
  • Participated in production turnover
  • Communicated with developers and business analysts for clarification during the SDLC
  • Utilized shell scripts to invoke processes in support of testing requirements
  • Communicated with application server team to coordinate database vs application changes

Confidential, Tewksbury, MA

Financial (data) Analyst

Responsibilities:

  • Designed / implemented databases via Access and SQL Server Data Warehouse
  • Conducted data modeling analysis in support of business requirements
  • Utilized various schemas and views within the database and data warehouse
  • Wrote SQL queries in order to analyze financial data
  • Responsible for all manual updates to the data warehouse
  • Loaded daily customer .csv invoice files to the accounting database
  • Tested, reviewed, cleaned new customer files due to system upgrades as needed
  • Reviewed, tested files and processes for new internal accounting system
  • Developed creative and logical solutions to solve complex data challenges
  • Implemented ETL solutions (extraction/transformation/loading) for manual processes
  • Ensured data accuracy in support of management decision making and planning
  • Compiled data used for budgeting, forecasting, reconciliation, month end reporting
  • Transformed complex, raw data files from customer into meaningful reports
  • Communicated with all levels of staff and clients to resolve technical issues
  • Collaborated with customers to provide them data meeting their business requirements
  • Provided ad-hoc reporting and analysis for internal and external customers
  • Reconciled $3M per month in A/P inventory
  • Exceeded shrinkage goals of less than .5%

Confidential

Data Analyst / Customer Support

Responsibilities:

  • Analyzed logistics data in a SQL Server data warehouse
  • Created / distributed field reports used for asset tracking and recovery
  • Worked within a team to meet monthly deadlines and goals
  • Improved shrinkage loss by $15k - $20k per month
  • Performed asset recovery via phone and email
  • Supported technicians and customers via phone in a large 24/7 call center
  • Documented materials and labor data used for logistics and reporting

Confidential, Yarmouth, ME

Software Quality Assurance Analyst

Responsibilities:

  • Tested the installation, functionality and GUI of mapping software
  • Created, executed test plans and/or followed structured scripts
  • Performed regression testing
  • Posted materials and labor data in a large 24/7 call center

Hire Now