工作经历

公司标识
Database Developer/Administrator
Soloinsight Inc.
Oct 2019 - 代表 | Lahore, Pakistan

Mysql
·        Install and maintain the performance of MySql database servers.
·        Develop processes for optimizing database security.
·        Set and maintain database standards.
·        Manage database access.
·        Performance tuning of database systems.
·        Install, upgrade, and manage database applications.
·        Diagnose and troubleshoot database errors.
·        Solid knowledge of Linux and experience in shell programming.
·        Create policies and strategies for backup/recovery, upgrades, and migrations.
·        Expert knowledge with DBA activities like create database, users, tables, views, stored procedures, checking profiles, roles, grant/revoke permissions, space management and troubleshooting, database monitoring and periodic performance tuning.
·        CDC implementation using Kafka and Maxwell to capture changes till table level.
 
Percona
·        Install and maintain the performance of Percona database servers.
·        Expert knowledge with DBA activities like create database, users, tables, views, stored procedures, checking profiles, roles, grant/revoke permissions, space management and troubleshooting, database monitoring and periodic performance tuning.
·        Percona Xtra-DB Cluster Implementation and Configurations.

公司标识
Software Engineer Client-Items
HIQU Systems
Jan 2019 - Oct 2019 | Islamabad, Pakistan

• Create functions, scripts, stored procedures and triggers to support application development.
• Design, develop and implement database systems based on customer requirements.
• Optimize database systems for performance efficiency.
• Develop database tables and dictionaries.
• Ensure data quality and integrity in databases.
• Identify any issues related to database performance and provide corrective measures.
• Participate in database design and architecture to support application development projects.
• Perform data back-ups.
• Monitor Application related Jobs and Data Replications.

公司标识
Database Administrator
Teralight
Dec 2014 - Dec 2018 | Islamabad, Pakistan

Teralight is Telecom company , its Prevail Software System provides bypass fraud Call Detection and other types of network fraud detection services via passive methodology, in which our system analysis the client’s provided CDRs and detects Bypass fraud in the network

• Serving more than 10 Telecom operators around the globe.
• Creation of Client Accounts for Client Tool.
• Generation and Updation of Reports per Client’s request.
• Generation of Reports on the basis of CDRs provided by Clients.
• Working on Backup Servers Replication.
• Working on Data Migration.
• Generation and Improvement of CSV data files for different clients.
• Ensuring smooth functioning of whole business process associated with or related to Database.
• Managing SIMBOX, VOIP / Internet bypass fraud detection with the help of Details CDR analysis and devising up to date rules to catch various frauds like grey traffic etc.
• Development of new controls for fraud detection and Revenue leakages in various areas based on CDR analysis by Research and Development.
• Monitoring the Voice, SMS and GPRS traffic of GSM Postpaid and Prepaid Subscribers.
• Coordinate closely with other business functions to design, develop, and implement best practices
• Resolving day to day queries provided by Our Telecom engineers along with daily Calls on Different Operators using TARGET CALL GENERATION (TCG).

公司标识
Oracle Developer
Ora-Tech Systems Pvt Ltd
Dec 2013 - Dec 2014 | Islamabad, Pakistan

Worked as Oracle Developer.

Primary Role is to work either in an individual capacity or with a team of consultants to complete assigned project tasks involving Oracle Financials within due timelines
• Meeting with clients for Application Demo.
• Propose all possible solutions to senior Management for identified issues.
• Studied, analysed business needs, gathered requirements, identifying gaps, designed and implemented Oracle Applications.
• Reviewed as-is (existing) business process and prepared to-be (new) process flows for multiple business scenarios.
• Prepared BP 40 document based on AS IS and BP 80 on TO BE using the flow charts.
• Assisted Technical team for Data Migration and Data Integration.
• Prepared test scripts, Master data scripts and assisted technical team for data migration.

学历

National University of Science and Technology
Bachelors in Engineering, Computer System Engineering‎
Database System, Programming, Networking
CGPA 2.3/4
2012
Public School
中级/A级, 理学院(工程预科), HSSC‎
等级 B
2008
Public School
大学入学/0级, 科学, SSC‎
等级 B+
2006

技能

熟练 SQL and Crystal reports
熟练 Crystal Reports
熟练 Crystal Reports for SAP Business ONE
熟练 CV Screening Skills
中级 Database
熟练 Database Development
中级 Database Functions
熟练 Database Management
熟练 Database Performance
熟练 Database Programming
中级 Linux
熟练 MS SQL
熟练 MySQL
中级 Oracle
中级 PL and SQL
熟练 Query Language
熟练 RDBMS Command
熟练 SQL 2008/2005/2000
熟练 SQL CLR
熟练 SQL Swever
中级 Troubleshooting

语言

熟练 乌尔都语
中级 英语
中级 旁遮普语