Kapil Dev

KAPIL DEV th Address: Flat # G-5/2 5 floor, Iqbal Center, opp: Jama Cloth, M.A Jinnah Road, Karachi, Pakistan Mobile:- Email:-Skype: kapil.langhani LinkedIn: https://www.linkedin.com/in/kapil-dev-/ PROFESSION SUMMARY Over 5 years’ experience in Information Technology and consulting including System analysis, Security, development, and implementation in Oracle , Oracle e-Business Suite, SQL SERVER and MySQL Databases. Core expertise in Oracle DBA and AppsDBA experience using Oracle E-Business Suite R12, 11i and Oracle Database 10g, 11g and 12c environment. ACADEMIC Jul 2016 -December 2017 M.S (Data Engineering & Information Management) NED University of Engineering & Technology Karachi, Sindh – Pakistan B.E (Computer & Info System Engineering) Jan 2011 –December 2014 Aug 2008 – July 2010 NED University of Engineering & Technology Karachi, Sindh – Pakistan HSC (Pre-Engineering) Board of Intermediate Education Karachi, Sindh – Pakistan SSC (Science Group) April 2006 – May 2008 Board of Intermediate & Secondary Education Mirpurkhas, Sindh – Pakistan EXPERIENCE  Working at Jubilee General Insurance as Assistant Vice President Database Administrator from May 2019 to date Working on Oracle (12c, 11g RAC), Microsoft SQLSERVER (2008R2), MySQL Databases (5.5) Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics Implementation of Oracle Grid Infrastructure and Database on Oracle 12c Linux. Apply Latest Patches Database Encryption (Backup Encryption) Performance Tuning, Monitoring and Query optimization by following the ADDM and AWR Physical Dataguard to primary switchover drills and vice versa Backups Management using RMAN and Oracle Data Pump  Worked at Telenor Microfinance Bank as Manager Database Administrator from January 2019 to May 2019        Working on Oracle (12c, 11g 10g, RAC 11g &12c), Oracle ERP (R12.2.5, R12.0.4), Microsoft SQLSERVER (2017, 2016, 2014, 2012, 2008R2), MySQL Databases (5.5, 5.6)  Performance Tuning, Monitoring of all Databases on Daily Basis Applying Latest Patch, Opatch SQL SERVER upgrade from 2008R2 to 2016 Migration of Core Banking Database from Oracle RAC 11g upgrade to Oracle 12c On Exadata Machine in Progress Migration of Oracle EBS Database Oracle12c on Exadata Machine in progress Database Encryption (Backup Encryption, Tablespace Encryption, Column Encryption)  Worked at Telenor Microfinance Bank as Assistant Manager Database Administrator from Oct 2016 to December 2018    Working on Oracle (12c, 11g 10g, RAC 11g &12c), Oracle ERP (R12.2.5, R12.0.4), Microsoft SQLSERVER (2017,2014,2016,2012,2008R2) , MySQL Databases(5.5, 5.6) Daily base Tasks Backups , Data pump, Data guard (Switch over and Failover Activity)                EBS R12 activities (patching, cloning, concurrent, Create users and System Administrator Responsibility etc.) Data Center Migration Activity (Create Contingency setup of all Databases) Databases Monitoring and Performance Tuning activities. Mirroring and Log Shipping Configuration (MS SQLSERVER 2008,2012) Master to Master and Master to Slave Activities (MYSQL) Upgrade of Oracle E-Business Suite from R 12.0.4 to R12.2.5 with DB Upgrade from 10g to 12c Working on NoSQL Databases (Mongo DB, Cassandra, Redshifts etc.) Working on Big Data and Cloud Working on Hadoop Cluster(single and Multiple nodes) Working on Data Analytics using Excel, R, Python, SPSS and Rapid Miner. Working on Database Security (DBSAT, Tablespace and Backup level Encryption) Database Archiving Configured All Databases(Oracle , SQL SERVER) Alerts on Mail Databases Licenses Activity and Consolidations  Worked at Jaffer Brothers (PVT) Limited as Oracle Database Administrator/Apps DBA from October 2015 to September 2016.                Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics  Oracle standalone database Installation and Configuration Maintain and administer database security access  Perform database Ad-hoc backups and restores  Trouble shoot and resolve database connectivity issues  Upgraded Database from 11G to 12C  Cloning of single/dual file system edition  Online or hot patching (ADOP) option Data guard Configured  Performance Tuning of database and application level.  Installation of RAC with ASM  Query optimization by following the ADDM and AWR Restoration of database through RMAN backup Estimating Database size growth (Database Size Management)  Analyzing Schema (Gather Schema Statistics) Project: Jubilee General Insurance Responsibilities:  Implementation of Oracle Grid Infrastructure and Database on Oracle 11g Linux.  Migration of Single instance to RAC 11g Database.  Performance Tuning, Monitoring and Query optimization by following the ADDM and AWR  Oracle RAC to single Instance Datagaurd (Physical) Implementation  Physical Datagaurd to primary switchover drills and vice versa  Backups Management using RMAN and Oracle Data Pump (Exp/Imp)  Enterprise Manager Configuration Project: South Asia Pakistan Terminals Limited (SAPT) Responsibilities:  Assisted my team mate in Configuration of Oracle 6-Node Real Application Cluster with dual HP 3-PAR Storage, Provided redundancy among Nodes as well as Storage's Project: Crescent Steel & Allied Products Limited Responsibilities:  EBS Application Support  Patching and Cloning  Monitoring and Performance Tuning Project: Al-Rahim Textile Industry (Lintaz) Responsibilities:  EBS Application Support  Patching and Cloning  Monitoring and Performance Tuning          Worked at Dig8labs as Oracle Consultant/Information Security Consultant from December 2014 to October 2015. Database Administration Activities Worked on Oracle Data Masking Oracle Database Gateway for Heterogeneous Databases IBM Guardiam Data Transparency Encryption DTE. Oracle Security Assessment Tool 3.X(SAT 3.X) Oracle Enterprise Manager OEM 11g ,12C Cloud Control Beyond Trust Software for Password and Privilege Management.   KALI Linux Web Application and Wireless Network Security Tools (e.g. Appscan, Netsparkar and Retina). at Webxzone as a software Engineer from August 2013 to October 2014.   Worked  Worked on Online Notice Board, Online Shopping System, and Online Testing System, Lawn booking projects using (HTML5, CSS3, JavaScript & Jquery, PHP and MySQL). INTERNSHIPS  Worked at PAKISTAN INTERNATIONAL AIRLINES (PIA) as Web and Mobile, Developer from 28May-2013 to28-June-2013.  Worked on Icenium Graphite (for Phone Gap).  Worked on Dreamweaver (PHP). MySQL, HTML5, CSS3 WITH JAVASCRIPT AND JQERY Worked at Webxzone in Karachi as Web DEVELOPER, from 01-Dec-2012 to 10-jan-2013.   Worked on Dreamweaver (PHP), Word Press, MySQL.  Worked as AES TRAINING INSTITUTE as .NET Development from June 2012 to October 2012 .    Worked on Visual Studio and SQL Server 2008R2. Win Form and console Application CERTIFICATIONS/TRAINING           Upgrade to Oracle Database 12c Certified Professional (OCP) Oracle Golden Gate 12c Training from Oracle Oracle RAC 12c Training from Oracle Online Training Oracle Fusion Middleware. Oracle Database 11g Administrator Certified Professional (OCP). Oracle Database 11g Administrator Certified Associate (OCA). Microsoft Certified in HTML5 with JavaScript and CSS3 (70-480). Attending Training and workshop of DB2 held by IBM in NED University. Certifications in Web Development (Dot Net, PHP) rd Participated in NED CACHE Event 2012 & got 3 Position. COMPUTER SKILLS                 Database Administrator:  Installing, Patching and upgrading Oracle Database and application tools  Silent Configuration of Oracle 11g,12c ASM and GRID  Setup, Configuration and Management of Oracle Enterprise Manager  Data Pump(Import and Export) of Oracle Databases  SQL/PLSQL Queries with DML, DDL, DCL and TCL operations.  Shell Scripting  Managing & Monitoring of Different Databases through Grid Control 11g.  Creating Altering users, User Profiles, User resource groups, Granting privileges & roles  Apply Patch, Opatch, Cloning  Worked on RAC and Data guard  Oracle Data Masking  Oracle Database Gateway Installation & Configuration on Linux for MS SQL  Backup and recovery activities using RMAN(Hot and Cold)  Configuration of Auto Schedule Backup  Auto config and Concurrent Manager  Performance Tuning, Monitoring of all Databases on Daily Basis  Virtualization (Oracle VM , VMware) OTHER SKILLS • • • • Capable of learning new concepts in very short period. Ability to work independently under demanding situations. Enthusiastic, hardworking and passionate team player. Aptitude towards meeting the deadlines under extreme condition PERSONAL INFORMATION Father Name: Dasrat Kumar Nationality: Pakistani Domicile: Tharparkar(R) Passport No: AJ- REFERENCES References & Other details will be furnished on request. Marital Status: Married CNIC No:- Gender: Male