Developer Oracle
Resume:
Warren Killian
Indianapolis, IN 46278
Cell: 317-***-****
*************@*****.***
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: *************@*****.***
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