Senior Programmer
Greater Jakarta Area, Indonesia
• Develop & Maintenance Multifinance Core System.• Conducted user requirement for change request• Analysed, designed, modified system for change request• Designs and develops application code using .Net or Golang• Performs all levels of testing to ensure that applications will perform error free and according to business specifications when promoted to production. • Responsible for providing 24/7 critical production support to Production, development, and UAT database servers (including after-hours and weekends)• Troubleshooting, TSQL Performance Tuning and solving any production issue• Define and enforce database standards, policies, security, table design guidelines, TSQL best practice to development team• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions)• Decide whether clustering, log shipping, mirroring or replication are the right fit to meet the business requirement and Implement it• Perform database administration activities for database Security (creating logins, users, roles, and assigning permission to them)• Monitor database systems performance, capacity and availability• Responsible to manage all TSQL from developers have been reviewed, tested and tuned - if necessary - before going to production• Automated daily backup/restore processes, implemented batch jobs to automate DBA maintenance tasks (Index Fragmentation, Statistics, Database Corruption, Full/Differential Backups)• Create and manage database maintenance plans and design and implement backup and disaster recovery plans• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments• Developed and implemented high availability and Database Disaster Recovery (DR) on production SQL Server