• Installation, configuration and upgrading of Microsoft SQL Server/MySQL/Oracle server software and related products.
• Evaluate MSSQL/MySQL/Oracle features and MSSQL/MySQL/Oracle related products.
• Establish and maintain sound backup and recovery policies and procedures.
• Assess and Develop long-term strategic goals for production databases in conjunction with data owners and department managers.
• Maintenance of production database and development database which includes tablespace space management •
• Automated hot backups using a combination of incremental, differential and full RMAN backups.
• Monitoring the database servers to identify any performance issues or bottlenecks.
• Installs, configures and maintains database instances, creates various database objects, creates users with appropriate roles and levels of security.
• Troubleshoot day-to-day database issues to ensure system stability and throughput.
• Responsible for Oracle logical and physical databases design, implementation and
maintenance on Linux and windows.
• •Performs Oracle database performance analysis, capacity planning, system sizing and
ongoing maintenance/tuning to ensure maximum performance
• Migrated and upgraded databases from version from version 9i, 10g to 11g.
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets
• Install and configure relevant network components to ensure database access as well as database consistency and integrity.
• Respond to and resolve database access and performance issues.
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
• Monitor, optimize and allocate physical data storage

• Assisting in database design and Mapping out the conceptual design for a planned database.
• Install, configure and support Oracle, MySQL and MS SQL databases for Business Systems on Linux environments.
• Monitoring performance and managing parameters to provide fast responses to front-end users.
• Monitor database space and capacity, estimate sizing and growth requirements.
• Database memory and performance tuning, indexing, fragmentation detection, index rebuilding and reorganizing, review & tune complex SQL statements
• Safeguards assets by planning and implementing disaster recovery and back-up procedures and information security and control structures.
• Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
• Performs ongoing tuning of the database instances.
• Collaborate with application and infrastructure teams to solve database level issues including availability and stability of the database environments.
• Plans and implements backup and recovery of the databases
• Implements and enforces security for all of the Databases.
• Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
• Enforces and maintains database constraints to ensure integrity of the database .
• Administers all database objects, including tables, table partitions, indexes, triggers, Views, sequences, packages and procedures.
• Commanding knowledge of Oracle PL/SQL and hands on working experience with complex/large database packages, procedures, functions and triggers with Oracle Database 11g R2 or higher.
• Restricting user to application and database server according to the strategies defined.
• Exploring ,analyzing and visualizing data by using python module numpy, pandas and matplotlib module.
• Loading data into hadoop hdfs and hive from local file system and databases such as MySQL and MongoDB.

• Experience in troubleshooting network, hardware, and performance problems on environments running tens to hundreds of servers
• Assisting in database design, development and modeling, and mapping out the conceptual design for a planned database.
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Experience with databases backup, restore and recovery models
• Experience working with Windows server, including Active Directory
• Database Development and driven to maintain interdepartmental transparency through frequent written, visual and verbal communication
• Database Designing, implementation and administration using MS SQL Server / Oracle.
• Hand on experience on complex database procedure writing
• Hand on experience on deployment and maintenance tasks.
• Monitor database space and capacity, estimate sizing and growth requirements.
• Database memory and performance tuning, indexing, fragmentation detection, index rebuilding and reorganizing, review & tune complex SQL statements.
• Experience and knowledge of DTS, Service Broker, Replication of Databases, Backup Servers.
• Experience on ERP, Financial Solutions and backend business logic designing.
• Communicate with Developers, users and higher management
• Capacity planning for data storage, enhancing I/O throughput, indexing and query tuning
• Data modelling and designing, database development, reporting and business logic implementation by using T-SQL and PL/SQL.
• Backup and disaster recovery and High Availability Designing for oracle and SQL server.
• Implementation of Complex query designing and store procedure for making report from database.
• Parsing and storing and retrieving XML data from database through stored procedure.
• Data migration between different database management system and from plat file to different database management system.

• Maintenance of networking systems and troubleshooting LAN network whenever fault arises.
• Router, Switches and firewall deployment, configuration and monitoring
• Deployment of VoIP server such as Linux goautodial/vicidial server on Dell /HP platform.
• Configuration, administration and troubleshooting of goautodial/vicidial server and its component like Asterisk, apache and MySQL database server.
• Regular backup and restore of MySQL, MS SQL and ORACLE databases server.
• Migration of MySQL and ORACLE database to new server.
• Data guard and RAC configuration, administration and troubleshooting.
• SAN storage installation and configuration.
• Performing full and incremental backup of MySQL and oracle and recovery from full backup and binary logs.
• Tuning database performance and memory.
• NDB cluster installation, configuration and administration
• Recovery of ORACLE database whenever files such as data files, control file and hardware failure occur.
• Remote administration of VoIP server in the cloud through SSH and SFTP.
• Monitoring of disk usage and resources consumption.
• Cleaning/purge the hard disk when require.
• Backup and restoration of Linux and Windows server.
• NFS configuration and administration.
• Cooperate Network Designing and Deployment.
• Consistent communication with ISP and VoIP provider and streamlining the network with ISP network.
• Assisting staff in configuring and installing their laptops, computer desktops, printer and other peripheral.
• Provide IT support services both for software and hardware.
• Physical setting up of computers and installation of various computer applications
• Work with vendors to resolve technical problems with server computing equipment and software.
• Wi-Fi router Configuration and cabling (Straight and Cross).
• Window Server (2008, 2012) deployment.
• Deployment, configuring and troubleshooting of AD, DNS and DHCP and PABX.

Working as master trainer oracle in CM Baluchistan ICT program to train government employees working in different government, semi government and private organization, and graduate. I have been teaching oracle OCP 11g for more than 2month on fast track basis.

• Installation of Linux OS Different flavors (Red hat, Fedora, Centos, Window Servers).
• Wireless router access point (AP) configuration and deployment on the network.
• Experience in Strong administration of Red hat Linux and window servers (2003, 2008 and 2012).
• Proficient in Active Directory, DNS, DHCP, Exchange Server, Web server, Window Deployment Server (WDS) etc.
• Experienced with GPO, configure file and share access, delegate control, enterprise security with Restricted GPO, groups such as domain local, Global and universal and there scope limitation.
• Defining GPO (Group Policies) on OUs.
• Configuring VPN for Remote Access (RAS).
• Administering Terminal services for providing V-APP.
• Defining and configuring managed service account for applications such as IIS, SQL etc.
• Software Deployment solution for users and computers in network by publishing or assigning.
• Creating groups such as Domain local, Universal and Global Groups and defining its type security and distribution.
• Proficient in Window Server backup and restore.
• Experienced and strong administration skill on virtualization Technologies such as Hyper-V and VMware (ESXI, vsphere client and vcenter server).
• Administering and troubleshooting Linux and Window servers such as Window Deployment Services (WDS), WSUS, Remote Installation Service (RIS), DNS, AD, SQUID, SAMBA, TMG, IPTABLE, DHCP, NFS, Apache and IIS.
• Technical support for people using network, maintaining systems, troubleshooting IT issues and installing new hardware and software.
• Help Desk/End-user support for hardware, software and Windows operating systems
• Maintenance and troubleshooting of LAN and WAN network.
• Mikrotik Load Balancing.
• Network Management Tool skills and use such as Nagios.
• Exchange server (2007 and 2010) installation and creation mailbox database, mailboxes, mailbox delegation, mail contacts, mail-enables user, Distribution Groups.
• Firewall configuration and management.
• (VoIP )Installing and Administering Linux Asterisk Server i.e., Private Branch Exchange (PBX) creation and user maintenance.