Sr. Database Administrator
Current• database administration support DEV/QA/LAB/Production lifecycle on UNIX (LINUX) platform including Oracle/Timesten/MySQL/PostgreSQL databases in high availability and GEO-redundant, low latency replications, 24x7 environment.• setup N-way master-master real time replication using Oracle Streams 10gR2, 11gR2• setup MySQL master-master replication, each master having multiple downstream slaves• Setup latency in milliseconds by TimesTen database-in-memory technology.• PostgreSQL installation & replication since 9 and 10, start with stream replication on 9.6 and logical replication in version 10,11 • install, configuring symmetricDS replication to replicate between variety databases, oracle to MySQL and PostgreSQL, PostgreSQL-to-PostgreSQL• install and manage Oracle Enterprise Grid Control 10g/11g (OMS/EM13c) for monitoring and performance tuning, job scheduling in production environment. Upgrade to 13c, and create incident rule, notification rule, and send to SNMP trap to NOC tier.• RMAN backup in regularly basis.• Troubleshooting production issue in daily basis, deep investigate issues to drill down bottleneck.• Working with internal user and external customers to resolve performance issue. • Design, implement, automated, documenting production processes, and maintain in time manner.
