Sohail Aslam

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