¸¹Àº Áö½Ä°ú °æÇèÀ» ¹ÙÅÁÀ¸·Î °í°´ÀÇ ¿ä±¸»çÇ׿¡ ÃÖÀûÀÇ ¹æ¾ÈÀ» Á¦½Ã ¹× ¼ºñ½º¸¦ ÁöÇâÇÏ´Â
°íµµÀÇ ±â¾÷Çü ¸ÂÃ㼺ñ½º¸¦ Á¦°øÇÕ´Ï´Ù.
°¡Ä¡ÀÖ´Â DATA·Î »õ·Ó°Ô âÃâ ÇÒ ¼ö ÀÖµµ·Ï º¸ÀåÇØ ÁÝ´Ï´Ù. ÇöÀçÀÇ ±¸¼º»óÅ¿¡¼ Ãß°¡ ¹× º¯°æ¿¡
´ëÇÑ Çʿ信 À¯¿¬È÷ ´ëóÇÒ ¼ö ÀÖµµ·Ï ÇöÀçÀÇ »óŸ¦
°¡Àå ÃÖ¼ÒÈÇϵµ·Ï °·ÂÇÑ ¸ðµ¨¸µÀ» Á¦°øÇÕ´Ï´Ù.
(System
±¸Ãà½Ã ºÐ¼®, ¼³°è ´Ü°è¿¡¼ È¿À²ÀûÀÎ Data ModelingÀ» ÅëÇØ
System Design¿¡ ´ëÇÑ ConsultingÀ» Á¦°øÇÏ´Â Service)
Customer
RequirementÀ» ±â¹ÝÀ¸·Î Capacity Planning
HA
Architecture Design
Transaction
Processing Architecture Design
Database
Security Architecture Design
Benchmarking
Test Áö¿ø
(À߸øµÈ
Modeling¿¡ ÀÇÇÑ ±¸Á¶ÀûÀÎ Performance ¹®Á¦°¡ ¹ß»ýÇÏÁö ¾Êµµ·Ï ÃÖÀûÈµÈ Physical
ModelingÀ» Á¦°ø, °ËÁõÇÏ´Â Service)
Performance¸¦
À§ÇÑ Denormalization ¹× °ËÁõ
´ë¿ë·®
Data¿¡ ´ëÇÑ Partitioning Àü·« ¼ö¸³
I/O
ºÐ»ê/ÃÖÀûȸ¦ À§ÇÑ Clustering Àü·« ¼ö¸³
Size¸¦
°¨¾ÈÇÑ ÀûÀýÇÑ Physical Storage Attribute ¼³Á¤
ºÐ¼®À»
ÅëÇÑ ÃÖÀûÀÇ Schema Design
Index
Key ±¸¼ºÀÇ ÀûÇÕ¼º ºÐ¼®
(¿î¿µ
SystemÀÇ ÇöȲ¿¡ °üÇÑ Á¤º¸¸¦ Á¾ÇÕÀûÀ¸·Î ºÐ¼®, Áø´ÜÇÏ¿© ¹®Á¦Á¡À» µµÃâÇÏ°í ¼º´É°³¼± °ú ÇÔ²²
ÃÖ»óÀÇ System ¿î¿µ ¹× °ü¸® »óŸ¦ À¯Áö)
Monitoring
ToolÀ» ÅëÇÑ CPU,I/O,Memory Utilization ºÐ¼®
°í°´
MeetingÀ» ÅëÇÑ ¹®Á¦Á¡ ÆÄ¾Ç ¹× ¸ñǥġ ¼³Á¤
ü°èȵÈ
¹æ¹ý·ÐÀ» ÅëÇÑ SQL Tuning
Application
Logic Tuning
Access
Path ºÐ¼® ¹× Index Àü·« ¼ö¸³
Oracle
Parameter ºÐ¼® ¹× Tuning
(´ë¿ë·®
DB ¿î¿µ¿¡¼ ÇØ¸¶´Ù ´Ã¾î³ª´Â DataÀÇ °ü¸®±â¹ý¿¡ ´ëÇÑ Àü·«À» ¼ö¸³ÇÏ°í ¼öÇàÇÏ´Â Service)
´©Àû
Data ºÐ¼® ¹× °ü¸® Àü·« ¼ö¸³
Áߺ¹
Data ºÐ¼® ¹× ÅëÇÕ Àü·« ¼ö¸³
±âŸ
Object ºÐ¼® ¹× °ü¸® Àü·« ¼ö¸³
Data
°ü¸® È¿À²¼º °ËÁõ
(Backup
& Recovery¸¦ °í°´ÀÇ ¿î¿µÈ¯°æ¿¡ ¸Â°Ô ½Å¼ÓÇϰí Á¤È®ÇÏ°Ô ¼öÇàÇÒ ¼ö ÀÖµµ·Ï Àü·«À»
¼ö¸³ÇÏ´Â Service)
°í°´
MeetingÀ» ÅëÇÑ MTTR(Mean Time To Recovery) ±âÁØ ¼³Á¤
È¿À²ÀûÀÎ
Backup Àü·« ¼ö¸³
Àå¾Öº°
º¹±¸ ½Ã³ª¸®¿À ¼³Á¤ ¹× Test
Test
°á°ú¿¡ µû¸¥ ÃÖÁ¾ Backup & Recovery Àü·« ¼ö¸³
(SystemÀÇ
¾ÈÁ¤¼º ¹× ¼º´É È®º¸¸¦ À§ÇØ ÇöÀçÀÇ ¿î¿µ SystemÀ» ºÐ¼®, Áø´ÜÇÏ¿© ¿¹»óµÇ´Â ¹®Á¦Á¡À» µµÃâÇÏ¿©
±Ç°í¾È ¹× ÇØ°áÃ¥À» Á¦°øÇÏ´Â Service)
ÀüüÀûÀÎ
System ¿î¿µ ȯ°æ ºÐ¼®
Monitoring
ToolÀ» ÅëÇÑ ¼º´É ÃßÀÌ ºÐ¼®
Database
Object È¿À²¼º ¹× ÀûÇÕ¼º ºÐ¼®
HA(RAC/OPS),
Backup & recovery Àü·«À» ÅëÇÑ °¡¿ë¼º ºÐ¼®
Á¾Çպм®µÈ
³»¿ëÀ¸·Î Áø´Ü, ¹®Á¦Á¡ µµÃâ, ±Ç°í¾È, ÇØ°áÃ¥ Á¦½Ã
(Ÿ
DB¿¡¼ Oracle DB·Î Migration, OS°¡ ´Ù¸¥ Platform°£ÀÇ Migration,
Oracle Version Upgrade¿¡ µû¸¥ MigrationÀ» Á¤ÇØÁø ±âÇÑ ³»¿¡ ÃÖÀûÀÇ
¹æ¹ýÀ¸·Î ¼öÇàÇÏ´Â Service)
Source,
Target System ȯ°æ ºÐ¼®
Migration¿¡
ÇÒ´çµÈ ½Ã°£À» °í·ÁÇÑ Àü·« ¼ö¸³
Àü·«¼ö¸³¿¡
µû¸¥ Tool ¼±Åà ¹× ÇÊ¿ä ½Ã Program ÀÛ¼º
¼ö
Â÷·ÊÀÇ Migration Test¸¦ ÅëÇÑ ¹®Á¦Á¡ ºÐ¼®, º¸¿Ï ¹× °ËÁõ
ÃÖÁ¾
Migration¾È ¼ö¸³ ¹× ¼öÇà
(񃬣
¹× °æÇèÀÌ ÇÊ¿äÇÑ DB Administration ÀÛ¾÷À» Support ÇÏ´Â Service)
DBA
¾÷¹« ÀýÂ÷ ¹× ±â¼úºÎ¹® Guide
DB
Lifecycle °ü¸® Àü·« Guide
Daily
/ Weekly / Monthly DB Á¡°Ë Guide
Expert
DBA Task Á¤ÀÇ ¹× ÀýÂ÷ ¼ö¸³
DB
¼º´É °³¼± ¹× À¯Áö ¹æ¾È ¼ö¸³
ü°èÀûÀÎ
DB °ü¸® ¹æ¹ý·Ð Guide
(Developer,
DBA¸¦ ´ë»óÀ¸·Î °í°´ ¿ä±¸ »çÇ×À» ±âÃÊÇÏ¿© ±âº» Concept, °³¹ß ¹× ¿î¿µ¿¡ ÇʼöÀûÀÎ Technical
Knowledge¸¦ ±³À°ÇÏ´Â Service)
°í°´ÀÇ
¿ä±¸ »çÇ×À» ±âÃÊ·Î ½Ã±â¿Í ±â°£ ¹× LevelÀ» °í·ÁÇÑ ¸ÂÃã½Ä ±³À°
Developer¡¯s
Guide, AdministrationµîÀ» ½Ç¹« °æÇèÀ» À§ÁÖ·Î ±³À°
DB
Performance Tuning, SQL Performance Tuning, DB Administration,
RAC/OPS Architecture,
Backup & Recovery |