خلاصہ

Proficient in database administration, database management, analysis, design, development and reporting. Expertise in database optimization & performance tuning, backup, recovery, database auditing, security implementation, server configuration and maintenance with troubleshooting capabilities. Hands-on experience on administering SQL Server High Availability and Disaster Recovery solutions like Clustering, Replication and Mirroring.

Expertise in T-SQL writing stored procedures, triggers and functions. Upgraded production and development environments from SQL Server 2008 R2 to SQL Server 2012 and then 2012 to SQL Server 2014 and SQL Server 2016.
Effective usage of monitoring tools, like Ignite and Solarwinds to troubleshoot the performance and slowness issues related to Web and application Servers.
I have started my career with Oracle Database Administration 11g from 01/01/2018. My areas of specialization are Oracle Databases 11g, High availability solutions especially (Data Guard) on Linux/Unix.

I am always keen to work in a challenging and motivated environment to get more expertise. My commitment is always with quality of work related to my job. I understand my responsibilities and business need of employers. I believe in honesty, hard work and discipline

پراجیکٹس

RMS (Retail Management System)
Data Migration

تجربہ

کمپنی کا لوگو
Lead Database Administrator
CSD
جنوری ۲۰۱۸ - موجودہ | Rawalpindi, Pakistan

·         Installation, configuration of Oracle Database 11g, 12C on Oracle Linux, Redhat, Oracle Linux & other Oracle server software and related products
·          Working on Oracle Tools Toad & Oracle SQL Developer
·          Oracle Database Administration 11g
·         Implementation of Oracle Data Guard (Physical/Logical/Active) Technology on Windows and UNIX family.
·          Implement and maintain database security (create & maintain users & roles, assign privileges)
·         Perform backup and Recovery using RMAN. Command on Export, Import and Data Pump.
·         Responsible for maintenance and support for company 24/7production database.
·          Take care of the Database design and implementation
·          Scheduling Crontab Jobs & Password Policy Periodically in Oracle 11g.
·          Create Users, Grant, Revoke Responsibilities in Oracle 11g
·         Daily Monitoring of Production Servers
·          Reset Password of Users in Oracle Apps & Reporting to concern Departments.

کمپنی کا لوگو
Lead Database Administrator
CSD
مئی ۲۰۱۲ - موجودہ | Rawalpindi, Pakistan

• Create a secure production infrastructure with multiple resources across different platforms. • Design, and scale infrastructure. • Architect and build continuous deployment pipelines. • Create tools to empower developers to manage production infrastructure. • Upgraded development, UAT & Production environments from SQL Server 2008 & 2012 to SQL Server 2014 & 2016. • Developed & implemented enterprise wise automated maintenance infrastructure. • Automated DBA’s daily tasks like Index rebuild & reorganization, and weekly maintenance for statistics updates. • Installation, configuration, up-gradation and migration of systems. • Capacity planning for DB Servers, and recommendations for hardware upgrade, and change in architecture. • Managing deployments on development, staging and production environments. • Designed & implemented database backup & recovery SOP for all databases, i.e. Production and development. • Configured and administered Database replication with Mirroring
• Disaster recovery of databases and SQL server

کمپنی کا لوگو
Lead Database Administrator
MTBC
جنوری ۲۰۱۵ - اپریل ۲۰۱۷ | Islamabad, Pakistan

 
·         To perform day-to-day database system administration, including daily checklists, backup verification, log review, security maintenance, performance tuning (analysis, indexing, etc.).
·         Create, update and maintain database objects in coordination with our reporting team.
·         Create, review and maintain code in our database systems to optimize, standardize and/or prepare for upgrades.
·         Perform data/database/process consolidations as coordinated with applicable internal staff.
·         Upgrade, configure and maintain server and database monitoring software to baseline system performance and proactively identify (and remedy) potential issues. Resource monitoring and capacity planning.
·         Review, test, update and document detailed disaster recovery/business continuity plans for key production SQL Servers (database mirroring, log shipping, replication, clustering) in a VM/SAN environment.
·         Performs database backup and recovery as required, including periodic testing.
·         Reviews, tests, recommends and installs upgrades of database software, including patches and major releases.
·         Ongoing review and completion of trouble tickets related to the database systems.
·         Train and mentor junior team members on process and technology.
·         Performs data analysis and other reporting tasks. This involves data investigation and cleansing.
·         The primary duties of this position occur during business hours; however, there is some weekend work related to projects, planned maintenance, and on-call support. Administer database replication among global servers.
·          Implemented and administered replication on production servers between multiple datacenters spanning different geolocations.

کمپنی کا لوگو
Senior Database Developer
MTBC
دسمبر ۲۰۱۰ - اپریل ۲۰۱۷ | Rawalpindi, Pakistan

·         Good experience with Reporting Services,
·         Create functions, scripts, stored procedures and triggers to support application development.
·         Design, develop and implement database systems based on customer requirements.
·         Develop database tables and Views.
·         Participate in database design and architecture to support application development projects.
·         Troubleshoot database related issues in a timely fashion.
·         Develop best practices for database design and development activities.

تعلیم

University of Arid Agricultre Rawalpindi
ماسٹرز, ماسٹرز ان سائنس, ‎
Computer Science
CGPA 3.2/4
2011

پیشہ ورانہ مہارتیں

ماہر Database Administration
ماہر Database Analysis
ماہر .NET Framework
ماہر 11gR2
ماہر 4 Knowledge of Taxation
متوسط Automatic Storage Management
ماہر CV Screening Skills
ماہر Database
ماہر Database Admin
ماہر Database Analysis
ماہر Database Applications
ماہر Database Desigining Skills
ماہر Database Developer
ماہر Database Development
ماہر Database Management
ماہر Database Mirroring
ماہر Database Modeling
ماہر Database Performance Tuning
ماہر Database Support
ماہر DB Security
ماہر Disaster Recovery
ابتدائی Enterprise GIS
متوسط ETL Tools
ابتدائی Grid Infrastructure
متوسط Hora
ماہر Linux
متوسط Linux Servers
ماہر Linux/RedHat
ابتدائی Microsoft Access
متوسط Microsoft Applications Experience
متوسط Microsoft Excel
ماہر Microsoft SQL Server
ماہر Monitoring
ماہر MS SQL
ماہر MSQL
ماہر MSSQL
متوسط MySQL
ابتدائی OOBDMS
ماہر Operating Systems
ماہر Optimizing
ماہر Oracle
ماہر Oracle admin
ماہر Oracle Administration
ماہر Oracle Developer
متوسط Oracle EBS Database Adminsitration
ماہر Oracle RDBMS
ماہر Oracle SQL Developer
ماہر PL and SQL
ابتدائی PostgreSQL
ماہر PR Campaign Management

زبانیں

متوسط انگریزی
ماہر اردو

آپ کن کمپنیز کی پیروی کر رہے ہیں