Assistant Manager Database Administrator
Mobilink Microfinance Bank
Total years of experience :9 years, 6 Months
Database RAC 11g/12c Administration along with Disaster recovery site management using Oracle Data Guard for T24 Core Banking, Iris, Irisubps, PrismIB, Moneta.
•MSSQL Database Administration along with Disaster recovery site management using AlwaysOn for GP Dynamics, IHA Stack.
•Managing T24-Insgiht Business Intelligence databases.
•Performing DR fire drill with data sanity, switchover, applications connectivity and revert back to PR.
•Performing on demand refresh of UAT/Test databases from production database
•Automate daily health check of production environment.
•Continuous database performance tuning and security hardening
•Day 2 Day support to Application Team.
•Reporting for the above-mentioned stack, monitoring organic growth, planning to comply with upcoming changes w.r.t Applications.
of Oracle Database 11g, 12c RAC and Single Instance.
•Manage Oracle Dataguard having primary and physical standby databases
•Performing on demand database disaster recovery drill using dataguard
•Performing quarterly backup restore drill using rman and oracle datapump
•Maintaining User Profiles in database (password complexity, password expiry etc
•Designs and administers the structure, definition, control of all production databases, ensuring accuracy, confidentiality, safety, integrity and availability of data.
•Responsible in automating data base maintenance jobs, DBA tasks through shell scripts, implements data archive system and maintains and enforces data integrity rules to ensure data accuracy.
•Provides installation of DBMs, software and maintains software and OS up to date with the latest patch installations.
•Monitors current system performance of the database and assists in identification and correction of performance bottlenecks and ensures the provision of 24 hours data base support.
•Day to day administration of SQL Server databases
•Rehat Linux administration (installation, patching, security hardening).
Projects:
Digiskills (www.digiskills.pk) Online Training System
•Installation and configuration of Windows Server 2016, Visual Studio 2017, Power BI Report Server, SQL Server Reporting Services, and Database SQL Server 2017 on Cloud.
•Enable Firewalls Rules for Restricted Access.
•Security Implementations of Overall Project.
•Backup Strategies and Recovery of overall system, Databases, and Reporting servers.
•Task Scheduling using Windows Task Scheduler, SQL Server Agent.
•Create ETL packages using SQL Server Integration Services.
•Create batch scripts for Download Files from FTP servers.
POF (Pakistan Ordinance Factories) Databases Upgrade
•Upgrade Databases from Oracle 8i to 12c.
•Install and Configure Database 12c with one Container Database and Twenty Pluggable Database.
•Import Oracle 8i Database Dump to 12c.
Oracle
•Installation, configuration and upgrading of Oracle server software and related products on RHEL 4/5.
•Monitoring the database health and ongoing instance tuning.
•Planning and implementation of sound policies for backup and recovery of databases using RMAN/Expdp and Linux shell scripts.
•Creation and maintenance of jobs for index rebuilds and gather statistics of database objects for improved execution plan of queries
•Configuring the Oracle network environment on both Oracle Clients and Oracle Servers
•Administration of database objects including tables, indexes, views, sequences, packages and procedures etc.
•Import/Export of data to and from the production and test databases.
•Optimization of resource consuming queries (SQL tuning advisor etc).
•Generate and maintain archive of performance related data (AWR and ADDM etc) for planning analysis and historical purpose.
•Review performance related database statistics regularly regarding CPU, memory and I/O.
•Implementation and enforcement of security for all of the Oracle Databases (create and maintain users and roles, assign privileges etc.)
•Preparation of ad-hoc reports for the higher management
•Scheduling jobs using operating system crontab utility.
Projects:
Mobilink-Jazz Information Technology Disaster Recovery (MITDR)
•Installation and Configuration of Oracle Database, Oracle Client, Oracle RAC (11g and 12c) on Operating System HPUX, INTEL, FUSION CUBE.
•Restore Databases Using Import/Export and RMAN on HPUX, INTEL, FUSION CUBE.
•Data Guard Configuration 11g, 12c on HPUX, INTEL, FUSION CUBE.
•MySQL two-way replication using master plus slave on both nodes on Oracle Enterprise Linux 6.
•MSSQL Server Always-on Configuration.
Mobile Connect MySQL Cluster
•Preparation of ad-hoc reports for the higher management
•Install and Configure 3-Node MySQL Cluster (One Management Node with Two SQL & Data Nodes).
•MySQL Backup and Recovery.
, and Configure Oracle Data Integrator 11g.
•Extract Load and Transform data from Databases and Flat Files to Cross Databases.
•Written Complex Queries for ETL Batch.
courses: BSCS, International Islamic University Islamabad.