Oracle Database Administrator, Resume, NH - Hire IT People

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 (see detail): Upgrades, Patching, Backup and Recovery methods, ASM, Performance tuning, Security, Troubleshooting, Real Application Clusters (RAC)

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Oracle Database Administrator,

Confidential, NH

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

Financial (data) Analyst,

Confidential, Tewksbury, MA

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

Data Analyst / Customer Support,

Responsibilities:

Software Quality Assurance Analyst,

Confidential, Yarmouth, ME

Responsibilities:

Transaction Processing / System Testing,

Confidential,, Boston, MA

Responsibilities:

Tested company wide system integration and conversion projects
Performed user acceptance and regression testing
Created custom test plans based on transaction processing job functions
Lead transaction processing specialist for all failed electronic funds transactions
Acted as a liaison for customers, banks, internal accounting and legal departments
Traded mutual funds, as registered representative with series 6 & 63 s
Acted as a transfer agent, completed transfers, redemptions and exchanges
Corresponded with customers via written and verbal communication