Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
    Kapil Dev

    Kapil Dev

    Database Administrator

    Karachi, Pakistan

    English, Hindi, Sindhi and Urdu speaking

     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),...Read more 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/defragm  ent, 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).

    • $10
      /hr
    Contact

    Skills

    auditdatabase administrationdata archivalinformation securitymicrosoft sql server administrationmysql administrationoracle ebsoracle patchingperformance managementperformance tuning
    Industry expertise: IT, Software and Technology

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    Aug 22 2019
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Aug 22 2019
    Response time
    instantly

    Skills

    auditdatabase administrationdata archivalinformation securitymicrosoft sql server administrationmysql administrationoracle ebsoracle patchingperformance managementperformance tuning
    Industry expertise: IT, Software and Technology

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    Aug 22 2019
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Aug 22 2019
    Response time
    instantly
    Skills Insights

    Insights

    Freelancer Buyer
    Projects listed
    0
    Freelancers worked with
    0
    Last active
    Aug 22 2019
    Response time
    instantly

    Insights

    Freelancer Buyer
    Projects worked on
    0
    Buyers worked with
    0
    Last active
    Aug 22 2019
    Response time
    instantly
    Skills Insights
    auditdatabase administrationdata archivalinformation securitymicrosoft sql server administrationmysql administrationoracle ebsoracle patchingperformance managementperformance tuning
    Industry expertise: IT, Software and Technology
    • Reviews
    • Purchases
    • Endorsements
    Hide feedback
    The user has no activity as a Freelancer

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2022 People Per Hour Ltd
    We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy