• Database Links, Creating and Managing Tablespaces and Datafiles, Creating and Rebuilding Indexes, Managing Database Security.
• Managing table spaces, data files, redo logs, tables and its segments.
• RAC Implementation and maintenance
• Performance information and monitoring/interpreting alert log and trace files.
• Use of SQL diagnostic and tuning tools like AUTOTRACE (AWR/ADDM Reports).
• Database Integration with Web sphere.
• Handled database server tuning, application tuning, maintaining documentation, and capacity planning and database security.
• Troubleshooting and maintenance of Oracle Database.
• Attend daily change requests for production database
• Managing Users, Privileges and Roles.
• Coordination with SAN/Storage team
• Handling Import/Export like schema, table, full database
• Maintaining data integrity also managing profiles, resources and password security
• Handling space issues.
• Oracle 11g/12c installation on windows/linux/solaris.

• Response and resolve the queries of claimants about Refund Claim Process System (RCPS) software.
• Sort out the Errors in Running Applications and coordinate with Concerned Department for Solutions.
• Generate Analysis of claims from Database.
• Database Table Data Analysis.
• Reporting to higher authorities for daily, weekly, monthly from Oracle Database Claim Processing Status.
• Researches and troubleshoots problems, and provides feedback to co-workers.
• Response and resolves the issues about claimant’s profiles and Claims.
• Analysis of data backup files of claimants.
• Assists in communicating with various tech support teams for creating support/escalation plans for priority processing
• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security.
• Works with other tech teams to plan/execute any database related work.
• Data integration with ODI (SQL Server to Oracle)
• 24/7 support
• Train the new recruiters

• Communicate with client, understand the requirements,
• Manage and make amendments in Access Control System Software for Naval Head Quarters Pakistan.
• Manage and make amendments in Vehicle Authentication System Software for Naval Head Quarters Pakistan.
• Manage and make amendments in Visitor Management System Software for Naval Head Quarters Pakistan.
• Manage and generate the web reports for Naval Head Quarters Pakistan.
• Manage and take backup of SQL database server
• Troubleshoot running application errors.
• 24/7 support

• Build a detailed database about Radio frequency Links nationwide.
• Coordinate with Government and private Authorities for company benefits.
• Manage File records of all services and Radio frequency links.
• Helping to Sort out the billing issues with team members
• Documentation and Coordination with Pakistan Telecom Authority for New/Renewal of Licenses.
• Generating and providing reports to higher authorities.
• Assists in communicating with various tech support teams for creating support/escalation plans for priority processing
• Completes other assignments or projects as assigned.