Database administrator
Ministry of Home Affairs
Total years of experience :11 years, 4 Months
(DBA) with extensive experience designing, coding, testing and supporting next-generation database solutions in Oracle enterprise and SQL Server environments. Proficient in an assortment of technologies, including Oracle 9i/10g/11g, Access, MS SQL Server, JDBC, Visio, Apache Web server and Jasper Reports.
DBA skills include:
• Oracle 9i/10g/11g Database Administration
• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Oracle Forms and Reports Development
• Oracle 9i/10g/11g Installation
• SQL Tuning in an Oracle Environment
Another responsibilities is data analytics from quality side, data cleansing and deduplications and then manage regional database administration to Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements and profiling data.
Key projects:
• Served project lead in the completion of medium to large scale implementations, managing projects from business requirements analysis to solutions delivery and support
• Managed 514 Regional Database Administrator to consolidated data and information from regional offices to data center
• Integrated and replicated about 250 million indonesian citizen database for public service, healthy insurance and banking applications
• Developed and tested storage strategies and disaster-recovery plan and delivering solution that guaranteed recovery performance and high availability
• Enhanced end users dan regional database administrator to understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials
• Interpret data, analyze results using statistical techniques and provide ongoing reports
• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Identify, analyze, and interpret trends or patterns in complex data sets
• Filter and “clean” data by reviewing computer reports, and performance indicators to locate and correct code problems
• Work with management to prioritize business and information needs
• Locate and define new process improvement opportunities
• Data Profiling and Reports with SAS and Tableau
courses: SAS Data management (2016), Oracle SQL (2011), Hardware (2012)