Database Developer Resume
San Antonio, TX
SUMMARY:
- Database Development Specialist with experience diagnosing and resolving technical problems for multiple projects in a multi - user environment
- Extensive experience in Database Development and Maintenance, primarily with Oracle
- Certified Computer Information Scientist
- Demonstrated ability to independently recognize, isolate, and resolve complex technical problems
- Learn new technologies quickly and can communicate technical issues to end users at all levels
TECHNICAL PROFICIENCY:
Operating Systems: OS/390, OS/400, MS DOS, UNIX, VSE, Novell, VMSWindows 9x, NT 4.0, 2K, XP, Vista, and 7
Development & Case Tools: SQL, PL/SQL, T-SQL, Oracle Developer, Oracle Forms, Oracle Reports, COBOL 74, COBOL 85, RPG/AS400, MS Visual Basic, MS Visual C++, Oracle Pro-C, Apache Tomcat
Database Expertise: Oracle 7.3, 8i, 9i, & 10g, 12c, SQL Server 7.0 & 2000, Access, Data- Access, Administration, Analysis, Modeling, Planning, Quality Assurance, Security, Standards & Procedures, Storage Devices.
Database: Capacity Planning, Design, Modeling Tools, Reorganization, Testing Tools/Utilities, Management, Development.
Database Tools: Oracle Forms & Reports, Sequel Server Enterprise Manager & Query Analyzer, SQL*Loader, SQL*Plus, Toad, PLEdit32, Golden32
Hardware: IBM AS/400, IBM S390, Digital Alpha Server 400 & 1000, VAX, Dell PowerEdge 6600
People Management: Building & Managing Teams, Coaching/Counseling, Conflict Management, Employee Performance & Salary Reviews, Encouraging Creativity & Innovation, Hire/Fire Decision Making, Influence & Persuasion, Interviewing, Leading teams, Managing Change, Managing Customer Service, Motivating & Energizing, Negotiating, Planning & Organizing, Resource & Unit Management
Communications: Formal Presentations, Listening Skills, 1 to 1, Excellent Oral & Written Communications, Proofreading & Editing
Organizational Management: Policy & Procedure Setting, Process Improvement, Set & Maintain Priorities
EMPLOYMENT HISTORY:
Confidential, San Antonio, TX
Database Developer
Responsibilities:
- Working under the Department of Defense for the DCPDS HR System.
- Primarily working with Oracle Enterprise Business Suite maintaining Forms & Reports via PL/SQL development.
- The Defense Civilian Personnel Data System(DCPDS) is the Central HR system for all civilian personnel
Confidential, Tulsa, OK
Database Developer
Responsibilities:
- This position, unlike prior assignments, is an effort in building the company’s database completely on my own.
- This is a small startup company and the project is to computerize all previous and current operations.
- Some DBA experience with this, plus the usual schema creation, tables, triggers, stored procedures, cursors, indexes, views, mapping, etc., even some minor networking.
- Primary work centers around PL/SQL in one form or another.
- Utilized Oracle 10g as the database for all information.
Confidential, Cheyenne, WY
Consultant Conversion Analyst
Responsibilities:
- Brought onto the project primarily for writing conversion programs. The ETL process was done in 3 stages using batch jobs then the cleansing through PL/SQL Packages.
- Converted the legacy system (ADABASE/Natural) to Oracle 9i, then later 10g for a new eligibility system for the Department of Family Services.
- PL/SQL Packages, Batch jobs; Excel Spreadsheets for mapping; Writing scripts and Ad Hoc reports; performance tuning; tracing defects; Documentation.
- Earned a reputation for always staying on top of issues, completing all work on time, most well ahead.
- Commended for dedication and ability to "Get the job done, and get it done right”.
- Demonstrated ability to uncover logic and data errors, and provide a solution to correct them as expeditiously as possible.
Confidential, San Diego, CA
Database Developer/Administrator
Responsibilities:
- Developed Stored Procedures, Triggers, and Cursors.
- Created Database Tables, Indexes, Primary Keys, and Views to increase database efficiency and eliminate duplicate records and corrupt or outdated data. Wrote custom SQL scripts for reports.
- Updated and modified tables as required by management.
- Altered Table Spaces in order to add Data Files for growing Database.
- Serviced 3 permanent staff and up to 40 contractors in the field via phone and email to resolve customer issues to completion.
- Responsible for all system related problems involving troubleshooting, reporting and coding.
- Wrote Base Files for Tables, Indexes, Triggers, Cursors, Stored Procedures, Views, etc.
- Cleaned up the procedural code itself to improve readability and maintainability.
- Lots of performance tuning as well.
- Wrote purge scripts to remove outdated material that was time sensitive and incorporated some of these into the cursors and triggers in order to automate the process
Confidential, San Diego, CA
Database Developer/Engineer/Administrator
Responsibilities:
- Served as the technical point of contact for resolution of Host/Service Center Database related issues in several multi-platform, production toll system environments. Troubleshoot, research, diagnose, document, and resolve technical problems surrounding database related issues.
- Earned a reputation for quickly responding to database problems, prioritizing user requests, and resolving complex issues.
- Worked closely with end-users to troubleshoot and resolve internal system or user related errors. Redesigned Forms and Reports improving accuracy & productivity. Created, installed, and tested software. Environment was heterogeneous and project specific with Oracle on VMS and NT Platforms.
- 30% of projects were SQL Server on a Win NT or Win 2000 operating system.
- Served as tier 2 point of contact with customers in the event of critical issues in a 24/7 environment.
- Worked with collectors and field techs in troubleshooting efforts, as well as with project auditors and managers to locate the exact nature of problems, discuss functionality issues, and follow ups after resolution to insure quality assurance and maintain a good working relationship.
- Corrected logic errors in code for broken or poorly written queries and modules.
- Conducted research on proposed system upgrades, identified potentially beneficial products, and organized demonstrations.
- Was offered a permanent position with the company within 45 days of a 6 month contract based on technical troubleshooting & resolution skills, positive work ethic, dedication to teamwork, and ability to communicate technical concepts to end users of all levels.