Dulguun Otgondalai
Database Engineer, DBA
Gunma, Maebashi
Summary
I love working with Big Data. I have Experience with Cassandra, Data lake, MongoDB, Redis, Oracle DBA, Oracle RAC, Oracle migration, and Performance Tuning. Have worked on Repmgr in PostgreDB as well as Failover Situation. I have worked as Oracle RAC DBA with Finance sector clients. Have worked on migration activities and would like to work on technologies that will enhance my career.
Overview
4
4
years of professional experience
3
3
Languages
Work History
PCA (Principal Component Analysis)
National University Of Mongolia
04.2023 - 10.2023
- Maintained clean and safe environment for patients, reducing risk of infections and accidents.
- Data normalization
- Data transformation in new dimensional space
- Eigenvectors and eigenvalues
Database Administrator
Unitel LLC
07.2022 - 02.2023
- NoSQL datamigrations ( Cassandra, Redis, MongoDB)
- PostgreDB data migration between NOSQL
- Installation, Configuration, Implementation,Upgrade ( Cassandra, Redis, MongoDB, PostgreDB)
- Implement monitoring tools on NoSQL DB's
Database Engineer
Khan Bank
02.2020 - 07.2022
- Reduced query execution time by analyzing and fine-tuning SQL statements in complex applications.
- Developed custom scripts to automate routine tasks, resulting in significant time savings for team.
- Contributed significantly to organization''s productivity by maintaining high availability and reliability of critical database systems.
- Identified opportunities for cost savings through effective capacity planning and resource allocation decisions in large-scale database environments.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Streamlined backup and recovery processes, enhancing overall system stability and availability.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Optimized database performance by monitoring health and implementing tuning recommendations.
- Developed and updated databases to handle customer data.
- Oracle administration RAC GI, DB 11g & 18c &19c
- Oracle GoldenGate administration/Data warehousing,
- Oracle to MSSQL, Oracle to Oracle/
- Oracle Dataguard, DG Broker
- Oracle Enterprise Manager‑ Oracle performance tuning‑
- Oracle database backup, restore, recovery /RMAN, Dump, Flashback/‑
- Data migration between SQL server and Oracle 11G and Oracle 18c, 19c, Cassandra, Datalake
- AWR, ADDM, ASH Report analyzing‑
- Apache Cassandra Cluster, Ring‑ Apache Solr
- Apache Spark‑ Cassandra data modeling‑
- NoSQL Datastax‑Hadoop Upgrade DSE,Cassandra,Oracle
- Daily Task operation automation (Ansible, DevOps)
Education
Bachelor of Science - Computer Science
Nation University Of Mongolia
Ulaanbaatar, Mongolia 09.2016 - 2020.06
Skills
Database monitoring
Database Management
Database Administration
Backup and recovery
Relational databases
Running backups
Performance Tuning
Database Design
Database Troubleshooting
Query Optimization
Database Development
Data Migration
Linux Operating System
Data Security
Replication Management
SQL Proficiency
Patch management
Relational Database Management
Index Management
Database Normalization
Data Warehousing
Data Modeling
Data Analysis
SQL and Databases
ETL development
SQL Programming
RDBMS
Database Security
NoSQL Databases
Indexing Strategies
Replication Techniques
Problem-Solving
Achievements
DSE 101‑220 courses
DataStax Academy Apache Cassandra™ Administrator
DataStax Academy Apache Cassandra™ Developer
IKM TEST
ORACLE 19C DATABASE ADMINISTRATION - 89%
MICROSOFT SQL SERVER 2016/2017 DATABASE ADMINISTRATION - 77%
Timeline
PCA (Principal Component Analysis)
National University Of Mongolia
04.2023 - 10.2023
Database Administrator
Unitel LLC
07.2022 - 02.2023
Database Engineer
Khan Bank
02.2020 - 07.2022
Bachelor of Science - Computer Science
Nation University Of Mongolia
09.2016 - 2020.06
Similar Profiles
Purevsuren ErdenebayarPurevsuren Erdenebayar
Research Work at National University Of MongoliaResearch Work at National University Of Mongolia
Altantsooj BatsukhAltantsooj Batsukh
Teacher at National University of MongoliaTeacher at National University of Mongolia
Purevjargal ErdenebilegPurevjargal Erdenebileg
Senior Data Analyst at National Statistics Office Of MongoliaSenior Data Analyst at National Statistics Office Of Mongolia