TECHNICAL SKILLS:

Others Technology and Tools: ORACLE DBA17 years (8i, 9i, 10g, 11g, 12c) SQL SERVER DBA 3 years (2000, 2005, 2008) MySQL DBA1 year Server Administration1 year ORACLE programming15 years UNIX18 years Shell Scripting18 years POWERSHELL 1 year C 7 years Informix 5 years

PLATFORMS: Sun Sparc and Solaris, Linux, NT, Dec Alpha, HP, AIX, Sequent, Intergraph, Windows SERVER 2005, 2008, Red Hat Enterprise Linux Server release 5.11, sun4v sparc, Oracle ODA

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Designing Oracle 12c Weblogic and APEX configuration of Air Force applications. Supporting Air Force applications using Sql Server. Helping move

Confidential

Responsibilities:

• Oracle dba for PERSONSD, at Confidential, creating and maintaining oracle databases, for Army applications. Wrote and updated Unix shell scripts, including CRON jobs, to update, migrate, and backup Oracle databases. Configured, installed, and tuned Weblogic for development group, as well as, test,, and prod environments. Optimized developer code, and maintained database security, capacity management, for Oracle release 11 and 12 databases. Worked with development team, utilizing Remedy and Serena, to implement releases for release and change tracking. Support development team to optimize database code and develop three
• Confidential Resource Command applications. Helped design and implement release projects on development, test,, and production databases. Utilize Oracle Enterprise Manager, Dataguard, RMAN, ODA, TOAD, Korn shell, LDAP, exadata, and standby databases for disaster recover, and production releases. Used datapump, import/export, to refresh development, test, and environments from production. Monitored databases, via security, status, and audit logs, for security Implemented, first of its kind, database obfuscation scripts for Army applications to conceal personally identifiable information, utilizing merge and correlated subqueries. Created or eliminated indexes, views, materialized views, foreign keys, and triggers to optimize application reaction time. Worked with STIG development, documentation, and implementation. Administered on Keyview data warehouse.

Confidential

Responsibilities:

• Oracle dba for PERSONSD, at Confidential, creating and maintaining oracle databases. Designed, first of its kind, obfuscation scripts for Army retain to web application to conceal personally identifiable information. Researched and developed database encrypting scripts to secure sensitive data for the Army. Wrote documentation for these and other efforts as part of the Keystone project.

Confidential

Responsibilities:

• Created, monitored, troubleshoot, and design company new MYSQL database and website network. Linux Server and MYSQL database
• Administration, php, and apache designing and troubleshooting, (LAMP). Web application configuration, and Kaltura, server security.

Confidential

ORACLE/SQL SERVER Database Administrator

Responsibilities:

• Helped change the university databases and applications from mainframe (IBM), and DB2 databases to Sun Sparc SERVERs, ORACLE web applications, 9i databases and application SERVERs. Created and maintained application databases, and data ETL (extraction, transformation, and loading), via Streva and Essential. Implemented of Confidential Operational Data Store application and ORACLE Data Warehouse. Developed and maintain proactive monitoring of the database environment, via GRID control and Automatic Workload Repository, and Spotlightfrom Quest, as well as developed scripts accessing Dynamic performance views, utilizing Exadata monitoring tools
• Used Oracle Data Pump, and RMAN, coordinated installation of Oracle and application patches. Lead disaster recovery project for all SQL SERVER instances, via mirroring technology, including SHAREPOINT. Experience installing and utilizing .NET. Implemented SQL SERVER upgrade from, using visio, MS Project. Converting DTS packages to SSIS. Maintain twelve SQL SERVER 2005 instances, containing two hundred and fifty four databases. Involved in migrations, updates, patches, performance tuning, monitoring, backup and recovery, capacity planning of those databases. Support the applications and users utilizing these databases. Created ORACLE APPWORX jobs. Created notification system for all instances. Creating documentation and project template for SQL SERVER upgrade. Fixed installation of ORACLE Enterprise Manager Grid application, including templates, thresholds, object configuration, notification system, and created forecasting system for capacity and resource management. Led project to update 30 to 40 SQL SERVER databases from, as well as, documentation effort. Interface with users, vendors, to support project, including Titanium, Millenium, Pave, TCAPP, Scholar, Imaging,
• Footprints, ILLIAD, Foghorn, EPO4, Hershey Imaging, SHAREPOINT, and STG. *Planned and implemented backup, security, and capacity planning. Designed linked SERVERs between SQL SERVER 2005 and ORACLE 10.2.0.4 for various applications. Upgraded ORACLE 9i to 10g Banner databases. Ran Banner maintenance jobs for Finance and Finaid. Supported and administered ORACLE, Banner, APPWORX, and Stat applications, installed upgrades and patches, using RMAN, OEM 9i and 10g, and Toad. Created and monitored audit policies for security, writing Unix scripts for performance tuning, creating statistics, and business rules. Designed disaster recovery via standby databases at remote site. Aided developers creating application database structures. Used remote desktop and ssh2. Created Streams, to populate ORACLE data mart, utilizing Banner tables. Created Central Management SERVER, POWERSHELL scripts for database monitoring and resource forecasting, CMS policies, SQL SERVER mirroring instances, for monitoring and security.

Confidential

ORACLE Database Administrator

Responsibilities:

• Administered very Confidential Databases, included capacity planning and management, performance tuning, script development, job monitoring, trouble - shooting, and on-call production support, on Solaris Platform, using SQLplus, OEM, and OMS. Part of 8i to 9i upgrade, where we finished the upgrade in 20% of the time allocated, thereby saving Bell South several millions of dollars in fines.

Confidential

ORACLE Database Administrator

Responsibilities:

• Developed and maintain ORACLE 9i databases for Confidential contract. Developed ORACLE Forms/Reports, for interagency application, IELS. Developed documentation, ran user, and full project life-cycle contract. Developed shell scripts for performance tuning, error detection and handling, and backups. Managed security, users, roles, and object creation, using SQL Navigator, OMS, and Embarcadero tools. Created Java Applets for Web site.

Confidential

SQL SERVER DBA/Application Developer

Responsibilities:

• Developed, created, and maintained replication for thirty SQL SERVER 2000 databases. Developed Access Forms and Reports, and queries, for Plant 4D engineering application. Developed shell scripts for performance tuning and backups.

Confidential

ORACLE Database Administrator

Responsibilities:

• Designed, created, patched, upgraded (8.0.5 to 8.1.5 to 8.1.6), and managed all Confidential databases from scratch, including development, test, and production, on LINIX SERVERs. Developed shell scripts for performance tuning. Created advanced replication with dual masters, and standby database with transparent failover, for disaster recovery. Developed embedded java scripts.
• Created, implemented, and maintained all security processes. Designed and implemented all database hot and cold backup UNIX scripts, and RMAN. Created and implemented SourceSafe repository, and created scripts and process to coordinate releases to synchronize changes to the database and application code. Designed and created ERD data models for all databases. Created and maintained all database objects, including tables, indexes, schemas, triggers, sequences, primary and foreign keys, views, and all constraints. Did all interfacing with thirty person programming department, made all database changes needed by them, and trained them on SQL queries. Used SQL Navigator, Enterprise Manager, Spotlight, and NT and Linux SERVERs.

Confidential

ORACLE Database Programmer

Responsibilities:

• Maintained and enhanced a large group of Pro-C modules, and UNIX shell scripts on a very large ORACLE database, using Maestro, SQL Navigator, and Silver Run to plan, tune, and optimize schema, using NT workstation, and Sun Sparc SERVERs. Taught myself HTML, and used on job to develop HTML web pages for production.

Confidential

ORACLE Database Developer

Responsibilities:

• Developed applications on client-SERVER system for Glaxo-Welcome using ORACLE and SQL Navigator, PL/SQL, SQL Plus, for a pharmaceutical database. Used APPWORX, and Remedy on Dec Alpha, Sun Sparc, and Windows NT systems. Developed new applications and interfaces for production, including first-of-its-kind application to apply Geocodes to customer data, integrating third party software, CODE-1.

Confidential

Database Developer

Responsibilities:

• Designed and maintained Ratemaster, a large, menu driven software package using INFORMIX, to support world wide, ocean going freight shipment tariff documents. Used AIX, Sequent, Risc, and HP SERVERs, NT and Win 95 clients. *Developed next generation Ratemaster, using Visual Basic and rpcs to INFORMIX database.

Confidential

ORACLE Software Developer

Responsibilities:

• Designed phone accounting system, COMTAX tax system, using ORACLE 7.1.3, on HP SERVERs and NT clients, using Pro C, and SQL Plus. Developed first of its kind mass credit card verification system, tax subsystem, tickler interface, concurrent invoice, and cut off data applications, integrating CODE-1 GEOCODE software into our applications.

Confidential

CInformix Database Programmer

Responsibilities:

• Designed INFORMIX code for GIS applications, on Intergraph Microstation. Maintained Multiple Imposition, Imposition Manager, and Imposition Screener, Metafile Interpreter, Extended Color Tables, maintained Map2 film writer, and device drivers. Used Intergraph System V, Microstation, and CAD/CAM workstations for large cartographic applications.

Confidential

Technology Software Engineer

Responsibilities:

• Developed Army missile flight simulation software and hardware feedback loop. Used PC/AT, and Zaiaz Clipper UNIX System, Assembler, FORTRAN, and C. Developed menu-driven systems to remotely operate videocassette recorders, oscillographs, audio/video switchers, 9-track mag tape recorders. Automated a servo mounted tracking system using two programs, in DOS and UNIX, in parallel, with GPIB and IEEE 488 interface and communication
• Developed Fiber optic test system using motion controllers, and A/D data acquisition equipment, controlled from AT. Developed image analysis system and device driver for video frame grabber, and 8744 and 8051 microprocessors, as part of the Fiber Optic Guided Missile Program.