Database & Unix Administrator Resume
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.