Muhammad Sohail
Database Engineer
I am I.T professional and I have over all 16 years experience in the I.T industry. In which, I have 8 years’ experience at Banking Side. Where I involved in implementation of Core Banking ERP and supported various running application in the Bank. I have worked in different organization on different positions with different responsibilities. I have both sides Software Development, Data Migration, Application Upgrade and DBA experience. I started my career in 2006 as an Oracle Developer and DBA assistant. We are currently working on automation. Database migration is our expertise. Analyzing different database syntaxes and handling according to database conversion. Writing complex queries, Function, Procedures and optimizing long running queries. And I have also migrated Forms 10g into Oracle Apex. I have worked on Oracle E-Business Suite and Apex.
Careers
Oracle PL/SQL Developer
mLogica LLC (7NSoft Systems)
- Currently working on MS-Sql, Oracle 12c,18c,19c and Postgres database.
- Analyzing existing database objects, like schema, function, procedures, packages, tables, views and etc.
- Troubleshoot and corrected object defects during migration and resolve these.
- Queries optimizing in the target database.
- Managing Oracle and Postgres and Ms- Sql databases and supporting these.
- Analyzing different database syntaxes and handling according to database conversion.
- We are building database Migration Tool. Where I am supporting and working at back end.
Senior Database Engineer
Sybrid Pvt Ltd. (Lakson Group)
- Worked on Oracle 11g, 18c and SQL, PL/SQL and Ms-Sql , T-Sql.
- Managing Oracle , Ms-SQL Databases.
- Worked on Packages, Store Procedures, Functions, Triggers, jobs and etc…
- Designed database, schemas, tables, integrity constraints, indexes and normalizing, deformalizing.
- Write complex logic, queries and Optimized queries and back-end processes
Senior Technical Consultant
Sapphire Consulting Pvt Ltd.
- Worked on Customization, SQL, PL/SQL, Apex, Form and Report, OAF and RICE.
- Worked on Oracle EBS R12 HRMS Module. Worked on Work Structure, Employee, Jobs, Positions and Assignments, Elements, Time & Labor(OTL), Absence Management, Benefits, Oracle Payroll, Payment Methods, Pre and Post Run and SSHR. Core HR process (recruit, select, onboarding, offboarding)
- Worked on HR APIs and use Interface table, Inbound and Outbound and worked AOL module.
- Supported different clients during Oracle EBS implementation and after go live.
- Prepared, Maintained and Monitoring Production and UAT servers.
Education
Self-taught
Self-taught
Self-taught
Self-taught
Self-taught
Self-taught
Sir Syed University of Engineering & Technology
DOT NET FRAMEWORK – WEB BASE CLIENT DEVELOPMENT
University Of Karachi
Bachelor Of Commerce
Orasoft Training Institute
ORACLE DEVELOPER SUITE AND DATABASE
Board of Intermediate Education Karachi
Math, Chemistry, English, Physics
My projects
Migrating from Sybase to Postgres Aurora - AWS
No image available
We have migrated Sybase ASA database into PostgreSQL with Meta Data. We are replacing all its Databases with Postgres Aurora. Currently there are about 580 databases running. I am currently optimizing queries and procedures, functions after migrate it.
Role: SQL Developer
Completed: 11/2023
Live project: Nil
- 1
- 2
- 3
- 4
- 5
Welcome to Outdefine
A free tokenized community dedicated to connecting global tech talent with remote job opportunities. Our platform is designed to help you connect, learn, and earn in the tech industry while providing the chance to collect DEF tokens. Join our vibrant community today and explore a world of possibilities for your tech career!
Join for free