Sohail Aslam

Sohail Aslam

Oracle Programmer

Followers of Sohail Aslam520 followers
location of Sohail AslamLeeds, England, United Kingdom

Connect with Sohail Aslam to Send Message

Connect

Connect with Sohail Aslam to Send Message

Connect
  • Timeline

  • About me

    Senior Oracle DBA at Capita Customer Management

  • Education

    • QA

      -
      Oracle
    • QA

      -
    • American International College

      1999 - 2000
      PGD Computer Sciences (Silver Medal)
    • University of the Punjab

      1993 - 1995
      MBE Business Education (Bronze Medal)
    • University of the Punjab

      1991 - 1993
      B.Com. Commerce
  • Experience

    • Interwoodmobel Pvt Ltd

      Mar 2004 - Feb 2008
      Oracle Programmer
    • MUFG Pension & Market Services

      Jun 2008 - Jun 2014
      Database Configuration Specialist

      Key Responsibilities:.DBA support for development/test databases (Oracle 9i, 10g, 11g, SQL Server 2005, 2008, 2012) and server support (Unix) (50+ databases). Database development standards development and implementation (database design/code review). Configuration and Release ManagementAchievements:Nominated for “Service Excellence Award” - 2011Developed and implemented database standards. Data integrity improved by 500%. Auditing improved by 500%. Performance improved. Code standardardised.Introduced source control for database objects.Built and deployed 3000+ database releases to dev / test environments with a success rate of almost 100% (50+ databases).LIVE database deployments (450+ releases, 1000+ release patches) are done. 100% success rate.Resolved numerous SQL performance issues (both in LIVE and test environments) that helped avoid serious breaches or helped towards meeting critical delivery deadlines.Devised and implemented process for applying DML changes to LIVE database.Implemented and improvised the process of database release deployment.Automated the reporting of database release deployment status across live and test environments.Developed and automated the setup of the IT Dev team’s database access across test databases. Brought database access of IT Dev team (on LIVE database) to a minimum, in line with IT security policy. As part of database re-factoring, data cleansing done on LIVE database and applied 300 + integrity constraints, indices etc. Show less

    • MUFG Pension & Market Services

      Aug 2014 - Jul 2016
      Database Developer / Designer

      Key achievements:Upgraded/migrated Oracle 9i unix to 11g windows.Archived off the data and refactored the database to reduce the size by 30%.

    • Capita

      Jul 2016 - now
      Senior Oracle Database Administrator

      Administering 54 Oracle and 10+ MongoDB production databases in a team of 7 DBAs, providing 24x7 support.Key achievements:Designed and created complete SDLC environments for MongoDB with optimum resilience and high availability using replica set and standard backup procedure.Setup monitoring for 54 production databases using Dell's FOGLIGHT tool.Documented key standard operating procedures of the team for knowledge transfer.Upgraded/migrated Oracle databases from 10g, 11g to 12c.Upgraded Oracle database from 12c to 18c and 19c Show less

  • Licenses & Certifications

    • ITIL Foundation V3

      ISEB Ltd
      Jan 2008
    • Oracle Database 11g Administrator Certified Professional

      Oracle
      Feb 2016
      View certificate certificate
    • OCP Oracle Database - Program with PL/SQL 11g

      Oracle
      Mar 2012
      View certificate certificate
    • OCA Oracle Database SQL Certified Expert (11g)

      Oracle
      Jan 2012
      View certificate certificate
    • IOC Investment Operations Certificate - with merit

      The Chartered Institute for Securities & Investment (The CISI)
      Aug 2011