ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Resume Of David Kragness

•Download as DOC, PDF•
•
O
OmahaDBA

David Kragness has over 20 years of experience as an Oracle DBA. He has experience managing Oracle databases from versions 8i to 12c. He has expertise in database administration, performance tuning, high availability, and disaster recovery. Kragness has worked with various organizations in industries such as manufacturing, retail, and election systems. He provides database support and assists development teams with data modeling.

1 of 3
Downloaded 19 times
Resume of David Kragness PROFESSIONAL SUMMARY: • Database Administration: o Maintained, developed and implemented policies and procedures for ensuring security and integrity of company databases. o Resolved database performance issues, database capacity issues, replication, and other distributed data issues. o Provided solid technical solutions and support for the implementation and integration of a variety of systems. o Managed multiple database environments (production-OLTP and DW, development, test, training, demo) o Managed ETL, data conversion and migration as required to achieve corporate objectives. o Migrated to new releases of RDBMS. • Remote Database Management: o Helped support database needs for many large organizations as well as the needs of internal development o Provided global support (London, Detroit and Chicago) with the capability to manage Oracle databases from personal PC and/or Mac • Work with Development Staff: o Provided support and design assistance to application development teams. o Implemented data models and database designs, data access and table maintenance codes for new systems and software. HIGHLIGHTS OF EXPERIENCE: • Experience with all Oracle versions 8 to 10g. • Oracle Partitioning • Physical Standby Database and Oracle Data Guard • Oracle Reports • Oracle Discoverer • Oracle Enterprise Manager and Grid Control • Oracle RAC and ASM PROFESSIONAL EXPERIENCE: Solutionary, Inc (Contract) 06/2008 - 10/2008 Oracle DBA Omaha, NE Responsibilities: • Maintained, developed, and implemented installations of Oracle Grid Control for database monitoring and performance metric gathering. • Assisted RDBMS upgrade of Oracle 9i installation to Oracle 10g • Resolved database performance issues, database capacity issues, replication, RAC, ASM and other distributed data issues. Agro National Inc. (Contract) 03/2008 - 05/2008 Oracle DBA Omaha, NE Responsibilities: • Reverse engineered an Oracle 9i database that had been acquired by a client. • Data modeling and stored procedure documentation • Client operating system was Windows
Election Systems & Software (Contract) 01/2007 - 10/2007 Oracle DBA Omaha, NE Responsibilities: • Maintained, developed, and implemented policies and procedures to ensure security and integrity of company databases. • Planned and implemented upgrades of multiple states databases from Oracle 9i to Oracle 10g. • Maintained, developed, and implemented installations of Oracle Grid Control for database monitoring and performance metric gathering. • Maintained, developed, and implemented policies and procedures for ensuring security and integrity of company databases. • Resolved database performance issues, database capacity issues, replication, and other distributed data issues. • Worked on large project that would replicate data from local county based databases to the master database maintained for state wide voter registration information. • Client operating system was Red Hat Linux Schawk, Inc (Contract) 08/2005 - 05/2006 Oracle DBA Chicago, IL Responsibilities: • Maintained, developed, and implemented policies and procedures for ensuring security and integrity of company databases. • Managed and created a new login auditing system using triggers and stored procedures. • Trained new DBA asset in management of the entire system, including issues that would occur and the responses needed to resolve them. Oracle version 9i • Resolved database performance issues, database capacity issues, replication, and other distributed data issues. • Database operating system was Red Hat Linux and Solaris Meridian, Inc 01/1998 - 08/2005 Oracle DBA Omaha, NE Responsibilities: • Maintained, developed, and implemented policies and procedures for ensuring security and integrity of company databases. • Resolved database performance issues, database capacity issues, replication, and other distributed data issues. • Provided solid technical solutions and support for the implementation and integration of a variety of systems. • Managed multiple database environments (production, development, test, training, demo) • Performed data conversion and migration as required to achieve corporate objectives. • Database operating system was Red Hat Linux and Solaris • Migrated to new releases of RDBMS – from 8 to 8i, 9i, and finally 10g. • Interacted with the development staff, business analysts and customers on several large projects. • Managed the installation, implementation and user training as well as adaptation of a new Oracle product - Oracle Application Server. Our implementation focused on: Oracle Files – Collaboration Suite, Oracle Reports, and Oracle Discoverer • Worked with an internal business analyst and used the Discoverer tool to examine actual time spent in
each stage of the production cycle. Discovered inefficiencies which were changed to improve the cost per page which in turn led to increased profitability. • The new installation of Reports led to our ability to run reports off hours and in batches, delivering them to the necessary recipients via email to await them arriving in the morning. This saved employee time as well as removed workload against the database during working hours. • Created and managed a sales analysis database, ETL procedures and reports to extract required information daily, weekly, and monthly. Extensive data modeling was required to create not only the basic database but also to assist in the creation of the required reports. Used a combination of triggers and stored procedures to audit all updates and deletes to any of the sales data on the nightly ETL runs. Much of the ETL required trigger and stored procedure usage. • Worked on a project to create an application and back-end database for creating the weekly advertising circulars for a regional and national retailer. When the sales analysis data warehouse was completed there was also a tie-in done between the two systems. Database auditing done through 2 means, the application would store a string of changes made, while triggers and stored procedures captured the before and after data on updates. Orent Graphic Arts 02/1996 - 01/1998 Systems Administrator Omaha, NE Responsibilities: • Managed environment of Windows and Macintosh desktops • Assisted with Solaris Server administration

More Related Content

Resume Of David Kragness

  • 1. Resume of David Kragness PROFESSIONAL SUMMARY: • Database Administration: o Maintained, developed and implemented policies and procedures for ensuring security and integrity of company databases. o Resolved database performance issues, database capacity issues, replication, and other distributed data issues. o Provided solid technical solutions and support for the implementation and integration of a variety of systems. o Managed multiple database environments (production-OLTP and DW, development, test, training, demo) o Managed ETL, data conversion and migration as required to achieve corporate objectives. o Migrated to new releases of RDBMS. • Remote Database Management: o Helped support database needs for many large organizations as well as the needs of internal development o Provided global support (London, Detroit and Chicago) with the capability to manage Oracle databases from personal PC and/or Mac • Work with Development Staff: o Provided support and design assistance to application development teams. o Implemented data models and database designs, data access and table maintenance codes for new systems and software. HIGHLIGHTS OF EXPERIENCE: • Experience with all Oracle versions 8 to 10g. • Oracle Partitioning • Physical Standby Database and Oracle Data Guard • Oracle Reports • Oracle Discoverer • Oracle Enterprise Manager and Grid Control • Oracle RAC and ASM PROFESSIONAL EXPERIENCE: Solutionary, Inc (Contract) 06/2008 - 10/2008 Oracle DBA Omaha, NE Responsibilities: • Maintained, developed, and implemented installations of Oracle Grid Control for database monitoring and performance metric gathering. • Assisted RDBMS upgrade of Oracle 9i installation to Oracle 10g • Resolved database performance issues, database capacity issues, replication, RAC, ASM and other distributed data issues. Agro National Inc. (Contract) 03/2008 - 05/2008 Oracle DBA Omaha, NE Responsibilities: • Reverse engineered an Oracle 9i database that had been acquired by a client. • Data modeling and stored procedure documentation • Client operating system was Windows
  • 2. Election Systems & Software (Contract) 01/2007 - 10/2007 Oracle DBA Omaha, NE Responsibilities: • Maintained, developed, and implemented policies and procedures to ensure security and integrity of company databases. • Planned and implemented upgrades of multiple states databases from Oracle 9i to Oracle 10g. • Maintained, developed, and implemented installations of Oracle Grid Control for database monitoring and performance metric gathering. • Maintained, developed, and implemented policies and procedures for ensuring security and integrity of company databases. • Resolved database performance issues, database capacity issues, replication, and other distributed data issues. • Worked on large project that would replicate data from local county based databases to the master database maintained for state wide voter registration information. • Client operating system was Red Hat Linux Schawk, Inc (Contract) 08/2005 - 05/2006 Oracle DBA Chicago, IL Responsibilities: • Maintained, developed, and implemented policies and procedures for ensuring security and integrity of company databases. • Managed and created a new login auditing system using triggers and stored procedures. • Trained new DBA asset in management of the entire system, including issues that would occur and the responses needed to resolve them. Oracle version 9i • Resolved database performance issues, database capacity issues, replication, and other distributed data issues. • Database operating system was Red Hat Linux and Solaris Meridian, Inc 01/1998 - 08/2005 Oracle DBA Omaha, NE Responsibilities: • Maintained, developed, and implemented policies and procedures for ensuring security and integrity of company databases. • Resolved database performance issues, database capacity issues, replication, and other distributed data issues. • Provided solid technical solutions and support for the implementation and integration of a variety of systems. • Managed multiple database environments (production, development, test, training, demo) • Performed data conversion and migration as required to achieve corporate objectives. • Database operating system was Red Hat Linux and Solaris • Migrated to new releases of RDBMS – from 8 to 8i, 9i, and finally 10g. • Interacted with the development staff, business analysts and customers on several large projects. • Managed the installation, implementation and user training as well as adaptation of a new Oracle product - Oracle Application Server. Our implementation focused on: Oracle Files – Collaboration Suite, Oracle Reports, and Oracle Discoverer • Worked with an internal business analyst and used the Discoverer tool to examine actual time spent in
  • 3. each stage of the production cycle. Discovered inefficiencies which were changed to improve the cost per page which in turn led to increased profitability. • The new installation of Reports led to our ability to run reports off hours and in batches, delivering them to the necessary recipients via email to await them arriving in the morning. This saved employee time as well as removed workload against the database during working hours. • Created and managed a sales analysis database, ETL procedures and reports to extract required information daily, weekly, and monthly. Extensive data modeling was required to create not only the basic database but also to assist in the creation of the required reports. Used a combination of triggers and stored procedures to audit all updates and deletes to any of the sales data on the nightly ETL runs. Much of the ETL required trigger and stored procedure usage. • Worked on a project to create an application and back-end database for creating the weekly advertising circulars for a regional and national retailer. When the sales analysis data warehouse was completed there was also a tie-in done between the two systems. Database auditing done through 2 means, the application would store a string of changes made, while triggers and stored procedures captured the before and after data on updates. Orent Graphic Arts 02/1996 - 01/1998 Systems Administrator Omaha, NE Responsibilities: • Managed environment of Windows and Macintosh desktops • Assisted with Solaris Server administration