Warren Killian

**** ***** **** *****

Indianapolis, IN 46278

Cell: 317-***-****

acpauc@r.postjobfree.com

To whom it may concern,

My name is Warren Killian. I wish to find a position as an Oracle

DBA/Developer. I would be a fantastic addition to a team of DBA's who are

looking to bring on an educated and certified DBA to augment their existing

staff.

I have worked with Oracle database as a developer since 2001. I have

worked as an Oracle 11g Jr. DBA for three years. I have passed the Oracle

11g Database Certified Professional exam and taken the Oracle training

class Oracle Database 11g: Administration Workshop II Ed. While studying

for my MS in Computer Science, my Master's project was an implementation of

Complex Query Modeling implemented in Oracle 11g. I love working with

Oracle database and am very excited and passionate about working as an

Oracle DBA. I am a member of the Indiana Oracle Users Group and attend

their meetings whenever possible.

If you ever have a need for an Oracle DBA, please consider me as a

candidate. I am a very dedicated and motivated person. I am very honest,

trustworthy and detail oriented. I have been working long and hard towards

an opportunity to work as a Oracle DBA. Please don't hesitate to contact

me regarding my application. I look forward to hearing from you.

Sincerely,

Warren R. Killian

Warren R. Killian

8487 Thorn Bend Drive, Indianapolis, IN 46278

Cell Phone: 317-***-****

E-mail: acpauc@r.postjobfree.com

Job Objective:

My job objective is to find a position as an Oracle Database

Administrator/Developer or a member of an Oracle Administration/Developer

team. I have been working as an Oracle database

designer/developer/administrator for several years now. I love the work

and want to take my experience and skills to the next level with these

incredible technologies.

Certifications:

. Oracle 11g Database Certified Professional, Oct. 25, 2014

. Oracle 11g Database Certified Associate, March 2012

. Oracle Certified Solaris Associate, Solaris 10 OS, Feb., 2011

. CompTIA Security+, Dec., 2010

. DoD IT-I Security Clearence, 2010

. Oracle SQL Fundamentals I (1Z0-051), January 29, 2010.

. Sun Certified Java Programmer for Java 2 Platform, Standard Edition

5.0 on February 13, 2006.

. Sun Certified Web Component Developer for Java J2EE Platform 1.4 on

September 8, 2006.

Oracle 10g/11g Database Skills:

. Planning, installation, configuration and management of Oracle 10g and

11g database.

. Strong and demonstrated SQL skills. I have passed the Oracle 11g SQL

Fundamentals I exam.

. PL/SQL development and debugging skills: packaged PL/SQL functions

and procedures; row-level and statement-level before and after

triggers.

. Relational database schema design, creation and maintenance.

. ETL experience: formatting and loading textual data into the database

using SQL*Loader and custom SQL*Loader script definition. I have much

experience moving data from one database to another using Oracle

DataPump utility and creation of DataPump parameter files.

. I have implemented database security using Roles and views and/or a

combination of the two. I have helped in the establishment and

enforcement of database security and data management policies, and am

familiar with database auditing.

. Experience managing the Oracle NET environment on both the client and

server.

. Knowledgeable of various backup strategies and techniques using RMAN:

user-managed and server managed, on-line/off-line and

full/incremental. I have worked with DBAs to troubleshoot backup

issues.

. Planning for and implementing database changes in response to

continuing web application development changes and corporate project

needs.

. Project Management tasks including time and cost estimates with

regards to proposed database changes.

. Proficient with OEM Database Control, SQL*Plus, SQL*Developer.

. I possess 10+ years of experience working in a UNIX based environment

(Solaris 10, Linux, FreeBSD), have good shell scripting skills. In

the past, was very familiar with Perl, Perl DBI/DBD packages and have

used them for both sys admin and web application development purposes.

Education:

. M.S. in Computer Science, Purdue University (IUPUI), August 2006. My

Masters project was an implementation of Complex Query Modelling

implemented on Oracle 11g database.

. Graduated with distinction from I.U. Bloomington, Dec. 1993. Bachelor

of Arts & Sciences; Double major in Chinese language and

Telecommunications. Dean's list at I.U. Bloomington, 1988 - Dec.

1993.

. Dean's list at Ball State University, spring 1988.

. Attended classes at the Mandarin Training Center of National Taiwan

Normal University, Sept. 1, 1990 - May 23, 1992.

. Awarded scholarship for second year of study in Taiwan from the Taiwan

Ministry of Education, 1992.

. While in Taiwan, I conducted independent research into the

broadcasting system there, including its laws, programming history,

etc. Parts of this report were used as instructional material in a

class on foreign broadcasting systems at I.U. Bloomington.

Work Experience:

Oct. 2011 - present

Developer at The Regenstrief Institute on an inpatient/outpatient

order entry system for a major local hospital.

Monitor daily database logs for space usage, block corruption, user

access privileges. Add space to tablespaces as needed. I work

closely with both the DBA and Developer staff to write SQL scripts to

help get general application data migrated through the various

computing environments. Schema design, Anonymous PL/SQL and packaged

procedures and function written in PL/SQL. SQL queries to perform a

wide variety of reporting for various people in the organization.

Investigation and analysis of new techniques of data storage which may

help improve systems the organization must work with. Have regularly

presented various Oracle related topics at developer meetings, etc.

I am highly involved in a certification effort for the SureScripts e-

prescribing part of the application. This involves designing,

creating and testing interface definitions and translations from/to

different HL7 and XML schema, identifying test data required for

certification purposes and writing scripts to migrate the data through

different environments where certification testing is to be performed.

Oct. 13, 2010 - Oct. 2011

Web Application Administrator for PTI at DFAS.

I configure, build, install, maintain, patch, upgrade and administer

the DFAS mid-tier computing architecture including, but not limited

to, the Apache web servers, Tomcat Servlet containers, Solaris OS. I

configure, compile, install and maintain Apache server modules used in

all of our environments: mod_ssl, mod_rewrite, mod_weblogic, mod_php,

mod_ajp, mod_proxy_ajp module, etc. I configure multiple data

resources within Tomcat and Weblogic. I manage multiple projects'

development life cycles from an enterprise administrator perspective.

Ex: the myriad of details involved in bringing web applications to

deployment: app server, DNS, PKI/SSL configuration, IRB/IRWG approval,

etc. I routinely assist in the administration and configuration of

TSO-CS Commercial Off-The-Shelf (COTS) and Government Of-The-Shelf

(GOTS) Software such as Remedy, LDRPS, Magnolia CMS, PKESSO, etc.

I look up and verify user account access to database objects in Oracle

10g/11g environments. I use TNSPing to verify communication between

web apps and TNSListeners configured in our environment. I query log

files to identify problems with applications, implement solutions to

problems, and provide application logs from production environments.

I provide application support and testing of web base applications to

developers. I answer customer's questions about server and

environment configuration. I facilitate customer requests for custom

server configurations. I reply to all e-mails and phone calls in a

prompt and timely manner.

I write custom "test" web applications to test required Java

functionality in our Tomcat Servlet containers: JSPs, Servlet, Custom

JSP tags, JNDI DataSource lookups, HttpRequest Listeners,

HttpSessionListeners, ServletContext Listeners, etc.

I create and maintain the PKI Infrastructure for web servers: I create

PKI keys, SSL Certificate Signing Requests, and configure our web

servers with the resulting SSL Server Certificates. I ensure that our

Apache http servers and Tomcat Servlet containers are configured

according to DISA Security Technical Implementation Guides (STIG)

guidelines. I configure multiple data sources for web apps utilizing

encrypted login credentials. I regularly perform upgrades of mid-tier

software and services in order to keep our computing environment IAVA

compliant. I worked extensively preparing Apache http servers and

Apache Tomcat Servlet containers across all environments for the 2011

CCRI (Command Cyber Readiness Inspection). I created custom BASH

shell scripts to ssh into various environments to check on compliance

with various Security Technical Implementation Guideline (STIG) rules.

I work closely with our Fed. Govt. customers to schedule the timely

deployment of their applications into the TSO-CS production

environments. I work with customers to determine any custom

environment configuration needs their applications may have prior to

deployment.

November 2007 - Oct. 12, 2010

Lead Oracle database 10g/11g developer and Jr. DBA for Performance

Strategies, Inc.. Performed all routine daily database maintenance

tasks such as user account management, role definition and assignment,

Oracle NET client configuration, etc. I was responsible for upgrade

of the development environment from 10g to 11g database. I worked

with Project Managers to plan, design and implement all database

schema and object design for 20 different web applications. I worked

with Project Managers and customers to provide time and cost estimates

of proposed changed to various database schema in response to ongoing

software application changes. I was responsible for frequently

performing many different database data loads of customer supplied

textual data into the database using SQL*Loader and custom SQL*Loader

scripts. I was responsible for the frequent bulk migration of data

between development and production environments using Oracle DataPump

utility. I was responsible to Project Managers and Sr. Management for

the creation of many different reports and database development

initiatives. I was frequently called upon to create and utilize

advanced SQL queries, views and data manipulations using MERGE to

perform common business reporting functions. I worked with Sr. DBA to

troubleshoot issues with our nightly user-managed, off-line database

backups utilizing Perl scripts. I worked with the sys admin staff and

Sr. DBA to ensure proper network configuration and database available

during network reconfigurations. I worked as the first line of

customer support in the event of application and/or database related

issues.

February 2010

Volunteer web application developer and Postresql database

administrator for Traders Point Christian Academy. I designed their

first interactive on-line auction web site (think E-Bay lite) using

Java Servlets, JSP, JSTL, JDBC and Postgresql database. The on-line

auction web site raised over $8,000.00 for the school in their Spring,

2010 auction. The application features J2EE Container Based

Authentication and Authorization, multiple e-mail notifications to

users, bid validation logic and other features.

Contact this candidate