Oracle Certified Professional who is comfortable in Windows, UNIX and Red Hat Linux platforms. Specializing in creating users, tables, views and synonyms. Capable of developing scripts using SQL, PL/SQL, Korn and C-Shell scripts.

• Increased staff productivity in fraud research by over 50% by rebuilding of fraud usage tables and indexes to improve access time to the data by use of PL/SQL and Korn Shell scripts
• Reduced maintenance time by writing a series of Korn and PL/SQL scripts to truncate the fraud usage tables
• Reduced time spent adding partitions (tables and indexes) to the Tax Credit Engine tables by over 75% using Korn and SQL scripts
• Created scripts to aid in the installation of Oracle 10g on Red Hat Linux
• Initiated and monitored back up and restoration of database using RMAN and import/export
• Provided ad hoc reports on demand to both technical staff and customers (end-users)
• Created a SQL script to dynamically give permissions to roles, and the roles to users
• Performed troubleshooting tasks on PL/SQL and Korn Shell scripts
• Created and performance tuned distributed database tables that were larger than one gigabyte using internal Korn Shell scripts

Professional Experience

Confidential,Dallas, Texas August 2008 to Present
An accredited member of the Dallas County Community College District and serves a student body of over 15,000 and another 5,000 continuing education students.

Instructor

• Instructed a class on Introduction to SQL, Oracle 10g Administration I and II on Oracle Enterprise Linux

Confidential, Carrollton, Texas May 2007 to June 2008
Industry leader in the creation of software that is used in the apartment community industry by performance conscious owners and managers.

Oracle Database Administrator

• Installed and modified Oracle 10g database on Red-Hat Linux and Sun servers as well as on virtual machines
• Installed and configured Oracle Enterprise Manager (OEM) agent to monitor database activity
• Regulated Oracle 10g development and data fix environments to maintain consistency with production database
• Use Aqua Data Studio to interface with the database

Microsoft Database Analyst

• Created a T-SQL stored procedure to check to see if the current build had a buildnumber greater than one
• Wrote a T-SQL script to find all encrypted sites using temporary tables
• Created a T-SQL stored procedure to add missing directories
• Used T-SQL to calculate the number of non-converted properties based on creation date for marketing purposes
• Troubleshooting of issues of drive space management using in-house programs

Confidential,Dallas, Texas April 2002 to May 2007 
World class creator of electronic chips that are used in everything from automobiles to cell phones.

Member of Disposition Team

• Insured operators fixed problems that could lead to yield loss
• Researched, identified, and prepared components for retesting or kept materials on “hold status” that did not meet customer specifications

Manufacturing Specialist

• Checked components for damage, tracked inventory materials using database, and prepared electronics for shipment to testing and quality control departments
• Tested wafers on V-Series, Polaris and VLCT testing equipment and computer interface
• Trained employees in key positions on VLC Tester, electronic wafer grinding and manufacturing systems processes
• Led 4-person technical team in organizing work stations and storage areas to reduce material losses, increase productivity, and save the company material and labor costs

Confidential, Richardson, Texas September 2000 to October 2001
Israeli based company that helps clients with their billing needs.

Logical Database Administrator

• Wrote script to check for rollback log changes to identify any such changes
• Created scripts to identify broken materialized views and quickly update end-user information
• Maintained Oracle 8 database by creating users, building tables, partitioning tables, creating snapshots and assigning security access for each user created
• Imported and exported data from account to account for synchronization of data in all tables
• Utilized PL/SQL, Korn Shell and C Shell in the performance of various database building and maintenance tasks
• Automated generation of product identification numbers by converting C++ scripts to PL/SQL
• Created ad-hoc reports to help and aid users in figuring out the number of fraudulent calls in a given month

Confidential,Dallas, Texas August 1996 to September 2000

Technical Skills

Database: Installed Oracle 8i, 9i and 10g Databases; Experience in backup and recovery with RMAN and import/export; Oracle Space Management; Configuring and Tuning Oracle Net; Oracle Schema Management; Oracle Database Design and Creation; Knowledgeable about Oracle Net; Windows; Writing PL/SQL scripts; Oracle Enterprise Manager (OEM); Aqua Data Studio; Microsoft SQL Server

Operating Systems: 2000/XP; HP-Unix; Sun Solaris, Red Hat Linux; Writing Korn Shell scripts

Software: Microsoft Office XP/2003/2007; AWK; VI; SED; PERL

Other: A+

Education And Professional Development

Masters of Information Systems/Management