We provide IT Staff Augmentation Services!

Database & Unix Administrator Resume

2.00/5 (Submit Your Rating)

Lafayette, LA

SUMMARY:

  • Certified Oracle Database Administrator and Developer Professional with extensive experience as a Unix Administrator, senior systems analyst, and programmer.
  • Adept at managing the design and development of business applications using a wide range of systems and software.
  • Control program migrations, database changes, database reorganizations and change - requests throughout the development life cycle.
  • Enforce security and establish standards to ensure all design and code meet site standards.

TECHNOLOGY SKILLS:

Software: ORACLE Database, RMAN, OEM, RAC, SQL Server, ORACLE*Forms, Developer/2000, Designer/2000, SQL*Reports, ORACLE CASE*Dictionary, PRO*C, PL/SQL, SQL*Loader, AWR, PL/SQL Developer, SQL Developer, PowerBuilder, Visual Basic, LabVIEW, WATCOM, JDeveloper, Crystal Reports, Lawson LAUA, Tax Factory, Dell Storage Manager, Agile Methodologies, Scrum, JIRA

Applications: Aviation, Inventory, Electronic Flight Bag, Financial Accounting, Inventory, Payroll, Lawson HRMS, Work Order System, Weight & Balance, Pilot & Mechanic Qualifications, Pilot & Aircraft Scheduling, Kronos Workforce Central, Order Processing

Languages: PL/SQL, SQL, Unix Shell Scripts, c, c++, BASIC, Fortran, COBOL, Pascal

Operating Systems: Unix, IBM - AIX, Linux, MS-WINDOWS

Hardware: IBM, LAN, DEC/Compaq/HP, Dell Compellent

EXPERIENCE:

Confidential, Lafayette, LA

Database & Unix Administrator

Responsibilities:

  • Maintained all Oracle and SQL Server databases.
  • Managed all Unix and Linux servers and Dell Storage System.
  • Altered memory variables, optimized Storages, and tuned all production databases for better performance.
  • Recovered data using RMAN, PL/SQL developer tools and cloned databases with Dell-Compellent replays/storage replications.
  • Maintained Change Requests, provided statistics of servers, databases and users to auditors for SOX complient.

Senior Systems Analyst

Confidential

Responsibilities:

  • Administered aviation application Ramco with a technical team serving abroad.
  • Maintained Accounting / payroll system Lawson and enabled interfaces with many other systems.
  • Derived logics and prepared specifications for User-Requirements explained to Developers.
  • Frequently tuned and applied patches to Ramco and Lawson applications, Oracle Databases, Unix Servers and other needed tools.
  • Electronic Flight Bag (EFB) package, including a “Weight and Balances” module to assist pilots in arranging passengers and luggage to ensure a balanced helicopter. (This replaced handheld calculators.)
  • Served on Ramco Implementation Team and guided development and creation of reports.
  • Migrated data from old system “GOLD” to new system “Ramco”.
  • Integrated all major systems and also with other sub-systems.

Confidential, Lafayette, LA

Software Consultant

Responsibilities:

  • Pilot Qualifications, Mechanic Qualification and Pilot Times modules in complete SDLC.
  • Automated Maintenance System (AMS), including work order and labor collection modules (SDLC).
  • Interfaced all above systems with HR Payroll and GOLD systems and loaded data from mainframe to new ORACLE database.
  • Inventory Accounting (GOLD) System.
  • Designed and developed various Inventory Reports from GOLD/Inventory database.
  • Played a significant role in design and development of Pilot Scheduling, and helped with training, customer support, and DBA activities.

Confidential, Denver, CO

Programmer / Analyst

Responsibilities:

  • Worked with multiple complicated forms, such as Maintain Members and Membership Processing.
  • Designed and developed packages and triggers in PL/SQL (2.3) for processing assessments, allotments and transfers.

Confidential, Calabasas, CA

Programmer / Analyst

Responsibilities:

  • Developed complicated forms which require dynamic SQL to enforce business rules for Attachment Module.
  • Developed functions procedures and packages in PL/SQL (2.3) for Work Order Module.
  • Used PL/SQL tables to implement the multidimensional arrays of COBOL.
  • Used DBMS-PIPE to trap and handle errors / exceptions. Object oriented PL/SQL package design.

We'd love your feedback!