Senior Oracle Database Engineer Resume Lexington, MA - Hire IT People

OBJECTIVE

Seeking a challenging position as a Database Engineer/Developer on data modeling, data processing, and ETL

TECHNICAL SKILLS

Database & Tools: ETL, Oracle 11g, 10g, 9i, 8i, PL/SQL, Pro*C, DataPump, SQL*Loader, Oracle Enterprise Manager, Oracle AuditVault, TOAD, dbArtisan.

Languages: PL/SQL, SQL, C, UNIX shell script, Perl, FORTRAN, Pascal.

Systems: Sun Ultra/SPARC/Solaris/SunOS, HP - 9000/HP-UX, PC/Linux/Windows

Others: JDBC/ODBC, Sarbanes Oxley/SOX.

PROFESSIONAL EXPERIENCE

Confidential, Lexington, MA

Senior Oracle Database Engineer

Responsibilities:

Application data structure design, object creation, process implementation and maintenance.
Data Logic structure design and implementation.
Created store procedure toolset APIs (PL/SQL) for data creation, conversion, access, archive and restore.
New customer data structure creation.
Partition management automation (partition creation, compression, drop) via scheduled jobs.
Automated customer data archive and restore process with PL/SQL procedures and Unix script.
Data compression process design and implementation.
Developed, customized, and monitored various of ETL processes. Customer and application data were loaded into staging tables and merged into existing application data via scheduled unix jobs, SQL*Loader, and PL/SQL post processes.
Application and ETL process performance tuning by SQL optimizing, resource allocation, data statistics collection, and parallel processing.
Database and application job scheduling via dbms job scheduler and unix job scheduler.
Data warehouse storage high growth planning, analyzing, controlling, and monitoring.
Managed Oracle 10g, 11g RAC production data warehouse on SUN Solaris, Linux environment.
Worked on database application migration from Oracle 9i to 10g, and from Oracle 10g to 11g.
Develop and QA database refresh with Oracle Data Pump.
Database user and application permission management by profile, role, resource management.
Database performance monitoring by OEM, scheduled PL/SQL jobs and shell script jobs.
Worked extensively with tools like DB Artisan and OEM Grid Control.
Modified, maintained, and monitored in-house application data reports.

Confidential

Senior Oracle Database Administrator

Responsibilities:

Manage Oracle development, QA and production databases for multiple applications. Apply Oracle quarterly CPU patches and DST patch to 8i and 9i DEV, QA and Production databases.
Installed Oracle 10g and upgrade DEV, QA 9i databases to 10.2.0.2. Implemented scripts for tables, schemas and full database refresh.
Responsible for assessing all DEV, QA and Production databases compliance with regulatory Sarbanes Oxley requirements. Implemented UNIX and SQL scripts to enhanced database and SQL*net security controls and reports to meet Sarbanes Oxley requirements.

Confidential

Senior Database Application Supporter

Responsibilities:

Supported warehouse management application systems and back-end Oracle 8i, 9i databases.
Effectively troubleshoot performance, resource contention, application data flow and connection issues to ensure real-time execution of orders, inventory, and shipment process in customer’s databases and application systems.

Confidential, Lowell, MA

Senior Computer System Analyst

Responsibilities:

Review functional testing requirements and user procedures with business analyst, IS, and end users. Created test requirements and test plans in Mercury TestDirector for User Acceptance Testing.
Automated testing script development for Oracle E-Business CRM modules with Mercury QuickTest Professional.
TestDirector and the associated Oracle database maintenance (Oracle Installation, SQL *Net configuration, database instance creation/configuration, and backup implementation).
Implemented infrastructure monitoring including system, network, database back-end server, database application server utilization, response time, usage, and resource availability with Mercury SiteScope.

Confidential

Senior Software Engineer

Responsibilities:

Network equipment management application software development.
Database layer stored procedure development, test, and maintain.
Monitor databases and database host for capacity planning and performance (load, transaction rate, Disk I/O, CPU utilization, buffer) tuning.
Involved a project of high reliable/efficient data loading system to load large amount of network traffic data to a network performance monitoring database using PL/SQL, SQL*Loader, and UNIX scripts.

Confidential

Senior Software Developer

Responsibilities:

Designed and implemented information transportation server which transfers protocol specific data elements among related system entities through its message interface to support call features.
Completed least cost routing feature to allow different routes to be chosen depending on the time of day for outgoing network calls from an ISDN terminal.

We provide IT Staff Augmentation Services!

Senior Oracle Database Engineer Resume

Lexington, MA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship