Hery Purnama – Trainer in Database Administration (DBA) and Programming

 

Profile: Hery Purnama – Certified Trainer in Database Administration (DBA) and Programming

Contact: Hery Purnama | WhatsApp: 081-223344-506

Hery Purnama is a highly skilled trainer in Database Administration (DBA), offering comprehensive training in both relational and non-relational databases. He specializes in teaching participants how to manage, optimize, and secure databases across multiple platforms, including Oracle DBA, SQL Server, MySQL, MariaDB, PostgreSQL, and NoSQL databases like DynamoDB and SQLite. With hands-on exercises and real-world use cases, his training equips professionals with the practical knowledge needed to handle complex database systems.

---

Expertise:

1. Oracle DBA

   • Comprehensive training on Oracle Database Administration:
     • Database architecture, installation, and configuration.
     • Backup and recovery strategies.
     • Performance tuning and optimization.
     • Security management and user privileges.
     • Managing data storage, partitions, and clusters.
     • Automating administrative tasks using PL/SQL and Oracle tools.

2. SQL Server DBA / SRSS (SQL Server Reporting Services) / Business Intelligence

   • SQL Server DBA training covers:
     • Installation, configuration, and maintenance of SQL Server.
     • Managing databases, security, and permissions.
     • Performance tuning and query optimization.
     • Implementing backup, recovery, and disaster recovery plans.
     • SRSS: Building, deploying, and managing reports using SQL Server Reporting Services.
     • Business Intelligence: Data integration and analysis, transforming raw data into actionable insights using SQL Server BI tools.

3. Microsoft Access 2013/2016 Fundamental & VBA Programming

   • In-depth training on Microsoft Access database development and VBA programming:
     • Creating and managing databases, forms, queries, and reports.
     • Automating processes and creating custom solutions with VBA (Visual Basic for Applications).
     • Linking Microsoft Access with other Office applications for data integration.
     • Best practices for database design and management in small-scale environments.

4. MySQL / MariaDB (DBA)

   • MySQL and MariaDB training focuses on:
     • Database setup, configuration, and administration.
     • Managing users, permissions, and roles.
     • Query optimization and indexing for improved performance.
     • Backup and recovery strategies.
     • Replication, clustering, and high availability.

5. PostgreSQL / PostGIS DBA

   • Training on PostgreSQL DBA covers:
     • Database installation, configuration, and tuning.
     • Implementing backup and recovery solutions.
     • Query optimization for performance enhancement.
     • PostGIS: Extending PostgreSQL with geospatial capabilities for mapping and GIS applications.
     • Spatial data types and geospatial indexing for efficient querying.

6. SQLite

   • Focused on the use of SQLite for lightweight and embedded database management:
     • SQLite database creation, configuration, and management.
     • Querying and indexing for small-scale or embedded applications.
     • SQLite’s role in mobile and IoT development.
     • Optimizing performance in resource-constrained environments.

7. DynamoDB

   • Non-relational database training on DynamoDB focuses on:
     • Understanding AWS DynamoDB architecture and use cases.
     • Designing efficient NoSQL schemas.
     • Optimizing read/write capacity for high throughput.
     • Managing scaling, backup, and recovery on AWS.
     • Integrating DynamoDB with other AWS services for a complete cloud-based data solution.

---

Why Choose Hery Purnama?

• Hands-On Learning: Hery emphasizes practical experience, ensuring participants not only learn database theory but also gain hands-on exposure to database management tasks.

• Multi-Platform Expertise: Whether you’re working with relational databases like Oracle and SQL Server or non-relational databases like DynamoDB, Hery’s diverse expertise ensures comprehensive coverage of the topics.

• Tailored Solutions: The training is adaptable to various skill levels, from foundational courses to advanced DBA topics for experienced professionals.

For more information or to schedule a training session with Hery Purnama, contact via WhatsApp at 081-223344-506.