Senior DBA
Profectus
Total years of experience :13 years, 11 Months
- SQL Server DBA :
Installed and configured new SQL Server 2017 in Windows Server 2016 platform
Deployed creating new database in Production after testing done in UAT environment for Claim Management System
Backed up and restored Sub-System from old SQL Server 2003 to new SQL Server 2017
Upgraded SQL Server from 2003 to SQL Server 2017
Activated Query Store and update compatibility
Implemented AlwaysOn High Availability for Cluster 2 nodes including configured Cluster Window failover
Tested failover/switchover for HA group
Created backup strategy and set up auto backup job
Detailed document for recovery plan to make it ready if any database crash happens
Created SQL script and ran it to figure out any SQL injection stored inside database may cause risk for database and Business
Created alert job for auto mail if backup failed, SQL Server Service stopped
Activated audit feature on sensitive tables
Estimated resource needed for Database ( RAM, Disk…)
Daily activities:
o Shrink transaction log file when it too large
o Monitor SQL database health and review slow SQL queries to optimize using SSMS, SQL Server Profiler, Database Engine Tuning Advisor
o Tuning Database: indexes, partition, Slow SQL Queries
o Monitor and solve Deadlock on SQL Database
o Review audit for sensitive data
o Monitor HA group: check status of each replica, window clustering and witness share folder
o Check SQL Server and SQL Agent logs
o Trouble shooting for bad performance or database crashed
o Create and manage logins, users, permission
- Oracle Database DBA:
Installed and configure Oracle 12c on Redhat Linux platform for Production, Development and UAT environment
Estimated resource needed for Database ( RAM, Disk…)
Update linux package needed for Oracle if required
Migrated Oracle Database from 11gR2 to Oracle 12c using backup and recovery method
Configured active standby for DR and Reporting system
Created RMAN backup strategy and set up crontab in Linux for automation
Created crontab for sending email if any tablespace is full, Oracle service and listener is down or backup job failed
Monitoring and performing database auditing
Optimizing Oracle Database performance: create or rebuild indexes, partition huge transaction tables, create SQL Profile…
Create and manage l users/schemas, permission required to Oracle Database for Application, Dev Team and Reporting Team
Monitor and troubleshoot if any issue in transfer log from primary to standby
- Reporting Support:
Supported end user to create and run SQL scripts to collect data for analysis
Create some dashboard reports for end user using Sisense BI platform
Training end user how to view and filter data on Dashboard reports
Worked with customers in gathering business requirements for data migration needs.
Worked across multiple functional projects to understand data usage and implications for data migration.
Assisted in designing, planning and managing the data migration process.
Worked with subject matter experts and project team to identify, define, collate, document and communicate the data migration requirements.
Prepared data migration plans including migration risk, milestones, quality and business sign-off details.
Managed assigned risks and monitor potential impacts as part of the data migration plan.
Developed best practice, processes, and standards for effectively carrying out data migration activities.
Performed source system data analysis in order to manage source to target data mapping.
Performed migration and testing of static data and transaction data from one core system to another.
Performed data migration audit, reconciliation and exception reporting.
Managed cross-program data assurance for physical data items in source and target systems.
DBA activity: install, config, monitor, maintain, troobleshooting and tuning database such as SQL Server, Postgres
Design and work on ETL process from data source( SQL Server, csv file..) into Postgres
Support and train Analyst Team to generate report for claim management
Improve database performance, performed database restores, implemented recovery procedures, managed performance tuning and conducted regular system back-up’s both Oracle Database and SAP HANA
Design and implement report system
Design ETL processes to transfer data from Oracle to SAP HANA using Smart Data Integration (SDI), from terminal to Oracle using APIs
Implement ETL and monitor data both source (Oracle) and target database (SAP HANA)
Turning Replication Task to enhance performance
Support and fix error for EDI file from Terminal data to Oracle database
Manage Server database server relating to Oracle and SAP HANA, both Linux (redhat and Suse linux) and Window
Set up standby system for failover
Enhanced database structure in organization of tables, table space, data file, archive log, redo log, trace file properly
Key Result Areas:
Shouldered responsibility of managing ERP Oracle Database along with its subsystem supporting ERP Application
Improved database performance, performed database restores, implemented recovery procedures, managed performance tuning and conducted regular system back-up’s
Scrutinized and tuned ERP database system to adjust in time with issues related to performance getting high, deadlock transactions or bad SQL including optimize memory, sql statement, create index, partitions, sql profile or propose solutions about upgrade database patches, upgrade of hardware server patches/memory on both Linux and Windows Operating System
Recommend solutions to highly complex technical problems such, as performance issues, reliability issues, and data quality issues
Enhanced database structure in organization of tables, table space, data file, archive log, redo log, trace file properly
Monitored sizing database parameter such as memory target, sga_target & pga_target to achieve best performance
Performed troubleshooting related to ERP Oracle database, Database and Application Server to ensure ERP system in the most secured and availability
Devised and deployed the most effective back-up & recovery strategy using RMAN, listed out all scenarios that may occur in making ERP system down and developed detail script in orders to recover EPR system with the shortest downtime
Drafted automatic warning shell script scheduled in crontab to alert critical problems immediately
Analyzed, evaluated and extracted data for complex reports in order meet with business ( Sale, marketing, accounting, purchasing, inventory, service)
Upgraded database software using patches and interface with Oracle Support Team
Supervised installation and configuration in RAC environment when needed or for production and test system using SAN storage
Assisted posting data from text file to table in ERP database using Imp/Exp Dump or SQL*loader
Integrated data using Oracle Data Integration for ETL/ELT Processes to build Data warehouse
Design, build and maintain data movement solutions (ETL) from transactional systems to databases (DWH) using ETL tools ( Oracle Data Integration) and custom query from multi source ( such as DB2, Oracle, MS SQL, MySQL or Flat file)
Design and build ETL processes and programs to ensure data movement between transactional systems and DWH environment.
Configured Change Capture Data (CDC) and Goldengate using ODI for real-time synchronization
Liaised with development team in integration of Q-Mobile management software such as ERP, E-commerce (Web App and Mobile App), Delivery System (Web App and Mobile App), POS (Web App and Mobile App of Point of Sell) system
Supported and trained end users about business process ERP Application, POS Application, Delivery Application and eCommerce
Supported testing internal applications
Key Result Areas:
Supervised maintenance of core banking database including DC and DR site
Ensured safety and availability of Core and Card System databases together with other database related to small HRM System and Bank Website Database
Monitored and tuned Oracle Core Banking database to solve issues immediately and ensurecore system work smoothly and enhances performance
Elevated performance including memory, segment & sql statements
Improved performance and decreased running time in sql query by create index, partitions, sql profile or propose solutions about upgrade database patches, gain hardware server on both Linux and Windows Operating System
Troubleshot relating to ERP Oracle Database/ Card System SQL Server Database and Database and Application Server to ensure stable, standby databases were synchronous data fully
Scrutinized and tuned SQL Server Card System database to solve issues immediately and ensure database works smoothly and increases performance
Built-up log shipping to clone data between production database and standby database for Card System SQL Server database
Entrusted with the task of supporting:
Bank IT Team to communicate with Vendor Team in order to meet exact understanding about their requirements in updating or changing database or database parameters
Development Team in developing new module by writing functions, procedures, views or packages from requirements of others departments
EOD team working in night shifts to resolve problems of data synchronous or updated changing data to fix errors from Vendor Team
EstablishedDR site using logical standby for failover system, beside report database system
Accomplishments:
Pivotal in offering solution to integrate Card System Database in to Core Banking Database
Played a key role in increasing:
Performance in peak times less than 25% (instead of over 60% as before) for database system
Database security and cost efficiency by 5% for database system
Pivotal in decreasing large report running time to 30%
Minimized cost for hiring Business Analyst for in-house software development
