Lokesh J. Email & Phone Number

Provo, Ut And Seattle, Wa, Us

Dublin 2, Ie

☞ Senior Database Administrator with 11+ years of extensive experience in administrating Oracle, PostgreSQL & MongoDB databases with good skills in performance tuning, replication, installation, migration, backup recovery, cloning, high availability and database security.☞ Leading a team of 20+ DBAs responsible for creating/maintaining/monitoring/supporting 800+ Oracle, PostgreSQL & MongoDB enterprise databases on various platforms in 24*7 production environments.☞ Experience in handling large sized databases, handled multi tera bytes (~60TB +) sized databases for ATG ecommerce/ Peoplesoft /Ordering /Sales & Billing applications.☞ Experienced in Configuration, Setup, Design, Install, Implementation & Administration of Oracle 11g & 12c RAC (Real Application Clusters) multiple RAC Node, ASM, TAF, Load Balancing, RMAN, Data guard etc.☞ Expertise in Oracle Golden Gate (OGG) with 50+ one-directional & bidirectional replication setup in production environments with good OGG processes performance tuning & troubleshooting skills.☞ Good knowledge of database internals and strong hold in database performance tuning areas including various DB processes, memory & SQL tuning.☞ Experience in migrating Oracle databases to PostgreSQL and administrating PostgreSQL databases which include backup & recovery, performance tuning, load balancing, streaming replication & upgrading PostgreSQL databases. ☞ MongoDB Database Administration with installation, upgrade & configuration of MongoDB versions 3.x in different environments, setting up replication, managing CRUD operations, sharding, OPS manager and scaling MongoDB clusters. ☞ Implement proactive database monitoring using various tools for Oracle, PostgreSQL & MongoDB and automation of database maintenance, diagnostic reports, databases repots & regular database operation tasks.☞ Handful Experience on Unix scripting for Automation of task and for monitoring of databases.

Dublin 2, Ie

☞ Lead a database engineering team of various database technologies.☞ Performed database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance.☞ Upgraded existing databases, installed new versions and applied periodic maintenance fixes/patches.☞ Implemented Golden gate replication methods between multiple databases.☞ Setup Oracle 12c Cloud Control and monitoring of production databases.☞ Performed performance tuning which includes Memory, Application, SQL and Network Tuning using Oracle Advisor, ASH Reports, ADDM, AWR SQL Reports and Cloud control.☞ Planned Backup/Restoration Strategy planned and scheduled Backups, taking Logical Backups with Export/Import utilities and RMAN.☞ Coordinated with data security to provide appropriate security, SOX compliance and secondary authorization. Implemented DB security modules for data protection (e.g. VPD, TDE encryption to protect client confidential SPI/PCI data, Voltage implementation etc.).2