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