IQBAL SHAIKH

*** ***** ***** **

ALPHARETTA GA **005.

470-***-****

ac24cf@r.postjobfree.com

Database Administrator

SUMMARY:

11+ years of experience as Oracle Database Administrator, providing 24x7 production, development and integration support on oracle 12c/11g/10g/9i/8i databases on different Platform.

2+ years of experience in MS SQL Server 2012/2008/2005 database administration activities and troubleshooting in Windows platforms for approximately over 250+ instances.

1+ years in Managing/Installing/Troubleshooting MySQL and Maria DB in production and development on Linux environments.

Around 3+ years of experience in AWS, analysis, design, development, implementation and testing of systems primarily in the distributed web application and client/server environment.

Manage and configure AWS EC2 instances services as per the business needs (EC2, Route53, S3, RDS, Cloud Watch, IAM, SNS, VPC).

Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.

Proficient in Oracle Database Administration on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions (RAC & Data Guard) and Backup & Recovery (RMAN).

Designs and Configures Logical and Physical Database Design and Construction with ERWIN and BDA tools

Expert in DBA activities such as Patches, TAR support, Cloning, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation

Monitor and create alerts in Enterprise Manager 13c /12 c

Agent Installation and Target Discovery in Enterprise Manager 12c

Troubleshooting OEM 12c/11g issues by viewing Log Files and Trace Files

Installation of EM 12c

Continuous review of Business-Critical Database to proactively identify space issues, performance tuning issue.

Installed oracle database server on HP-UX, AIX, WINDOWS, REDHAT LINUX and migration of oracle server from9i to 10g, 10g to 11g and 11g to 12c.

Hands on experience in Data guard, Grid control, stream& replication, monitoring batch performance.

Handled entire DBA activity on server move for VERITAS cluster and Data warehouse servers.

Administration, migration, health check, resource management, patching/upgrade and SQL tuning.

STATSPACK, SQL TRACE, ORADEBUG, 11g/12c OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Experience with SQL coding including DDL, DML and fine-tuning those SQL’s for better performance.

Experience in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring.

Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views.

Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.

Installation of SQL Server Reporting Services and Folders creation and assign rights to Users.

Ensuring that all databases are backed up on a regular basis, fixing backup failures, and address implemented resolutions.

Performed MySQL Replication setup and administration on Master-Slave and Master-Master.

Perform database migrations from MSSQL and Oracle to Maria DB/MySQL.

Actively involved in Database transitioning from MySQL to Maria DB.

Worked on many Unplanned power outage and restored the DB

Manage and configure AWS EC2 instances services as per the business needs (EC2, Route53, S3, RDS, Cloud Watch, IAM, SNS, VPC).

Professional Skills:

Operating Systems

RHEL, HP-UX, AIX, Windows

Data Bases

Oracle12c/11g/10g/9i, MSSQLServer 2012/2008/2005, MySQL 5.x, MariaDB 5.x.x /10.x.x/

Software Applications

Web logic, Oracle Application servers, ERWIN, VERITAS Backup, SQL Loader, OBIEE, Oracle Cloud, HP OVO, Apache, Tomcat, Apex, EMC / Netapp, FSC, HP, Java, Jmeter, AWS

Ticketing Tools

HP Service Manager, Nagios Tool, Remedy tool

Languages

SQL, PL/SQL, JSP, C#, C, C++, XML, UNIX Shell Scripting, Perl, JBoss, Qlik, SVN, J2EE

Database Tools

Oracle Enterprise Manager 12c /13c, SCOM 2007, Toad, RMAN, dbvault, ZFS

Tuning Tools

TKPROF, Explain Plan, Statspack, AWR, ADDM, Grid Control Tuning Advisors

Education, Certifications and training:

Master of computer Applications, DBMU India.

Oracle 10g DBA Certified-OCA

Attended boot camp training on RAC

ITIL V3 certified training @Fujitsu India Consulting.

Pursuing AWS

E

Professional Experience:

AT & T, SAlpharetta, GA

Database Administrator Nov’17 – Till Date

Responsibilities:

Install, configure and administer OEM12c and 13c.

Monitor and proactively tuned Oracle databases 12c via OEM cloud control (13c).

Install, Configure and manage Oracle Data guard on 12c

Database cloning/refresh using nimble Snapclone and rman and data pump for developer testing

Creation of oracle documentation, planning and implementing of PSU.

Administration and configuration of oracle Golden Gate 12c.

Performance Monitoring and Tuning of Oracle 9i through 12c Databases.

Installed and configured MySQL on Linux and Windows environments.

Oracle golden gate administration in production and development environments

Managing MySQL 5.1 and Maria DB 10.1.6 in production and development environments

Performed installation, new databases design, configuration, backup, recovery, security, upgrade and

schema changes, tuning and data integrity.

Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.

Assisted with sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security including other administration functions as part of profiling plan.

Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.

Converted existing Master-Slave Replication to Galera Cluster

Setup a Hybrid replication alongside the Galera Cluster

Implemented load balancing using HAproxy on Galera Cluster

Generated proof of concept for Maxscale in a MariaDB Hybrid Cluster and implemented it

Incorporated check_mysql_health plugin into existing Nagios monitoring tool

Created and refined stored procedures, routines and triggers

Supported and configured MariaDB clusters over WAN to avoid node partitioning

Upgraded MariaDB from 5.5 to 10.1

Perform full and incremental backups

Perform database migrations from MSSQL and Oracle to MariaDB/MySQL using DB convert

Recover backups and perform point in time recoveries as needed

Management of MySQL's underlying storage engine.

Apply MySQL/MariaDB best practices

Analyze existing databases and device best sharding goals

Configure and monitor Replica sets

Environment: MySQL /MariaDB 10.1.16 Galera Cluster, Oracle 13c/12c, Oracle 12c, Web Server /Apache Server, Jmeter, Shell Scripting, Linux 7, Cloud infrastructure Services AWS.

Fujitsu, Pune India

Smithfield Project Dec ’2009 – June ‘2012

Technical Lead Database Administrator

Responsibilities:

Involved in the analysis, design, build, and testing phase of the life cycle for the largest reinsurance project.

Handled Entire DBA activates on datacenter environment and maintained around huge TB’s of production servers.

Provided L3 Support for IT infrastructure, Involved in the installation of new database 12c on Red hat Linux for Production and development environments.

Using Amazon RDS with multi-AZ for automatic failover & high availability at database tier for oracle workloads.

Configured scalable infrastructure on Amazon Web Services (AWS).

Created EC2 instances, configured its specifications and ran specific AMI's on them as per requirement.

Automated different AWS resources like EC2 Instances, S3 Buckets, Security Groups, VPC and Databases using CloudFormation Templates.

Build application and database servers using AWS EC2 and create AMIs as well as use RDS for Oracle DB.

Hands on experience in Oracle Apps installation of R12.1.1on RHEL 5 and Database upgrades from 8i, 9i to 10g, 9i to 11g, 10g to 11gR1, 10g to 11gR2.

Designs and Configures Logical and Physical Database Design and Construction with ERWIN and BMC BDA tools

Migrated Database from 11.2.0.3 to 12.1.0.2 for both Production and Development environment.

Configured flash recovery area, created RMAN scripts and export scripts for regular backups.

Cloned/Refreshed Oracle Databases as per schedules and request.

Responsible for database backup strategies, database recovery and validation & reporting database statistics.

Implemented Disaster Recovery plans.

Responsible for optimizing the queries and application tuning.

Perform SQL tuning and assist developers with coding PL/SQL.

Worked on several shell scripts to maintain the database activities

Mentoring the Database Performance using automated scripts.

Answerable for setting and managing User Accounts, Granting required privileges to users.

Experienced in Security Administration and Space Management

Perform other regular DBA activities including space management and performance monitoring.

Involved in process improvement, Oracle Server Installations/Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data guard, Oracle Advanced Replication, Real Application Clusters, Oracle standby services.

Involved in setting up oracle http server 11g for in house HP applications.

Having regular interaction with client for regular issues.

Working for German client. Which is having more than 200 databases on Linux

Installation of SQL server 2008 SP3 and 2012 with SP1_CU2.

Failover Cluster Installations in SQL 2008/2012 and Failover resources between nodes in Downtimes.

SAN Disk replacement in 4 NODE Cluster environments.

Performing Deactivation\De-installation of SQL Server instances in SQL 2005 & 2008.

Applying Service packs and Hot fixes on SQL Server.

Performing backups of SQL databases by setting up backup schedules at regular intervals and also restoring databases.

Performing Security Administration Tasks like Creating users and Delegating appropriate permissions to the users as required.

Creating and Monitoring the Maintenance plans – scheduling tasks to run daily and/or on weekends tasks like rebuilding indexes, defragmenting Databases, Shrink Database.

Migrating Database from lower version to higher version SQL Server.

Copying the databases between several servers as a part of DB refreshments.

Proactive monitoring of all Databases & Backups.

Ensuring high availability of the database exploiting the concepts of DB mirroring.

Checking the general Health of the servers for identifying SQL Job failures & Bottlenecks.

Environment: Oracle 11g R2 RAC, Oracle 12c/11g, OEM 12C, Oracle Exadata, AWS cloud infrastructure Services, ODI, Informatica, OBIEE, Shell Scripting, Linux, Solaris, HP-UX, MSSQL server 2008/2012

Wipro Pune, India

Deutsche Bank project Aug ’2006 – dec 2009

Senior Database Administrator

Responsibilities:

Installed and Configured OEM Grid Control 11g and deployed agents across more than 30 production and development servers.

Monitoring the Queue and perform system updates, respond to BARS as first point of contact resolution for database issue and troubleshooting.

Migrated Oracle databases to ASM using RMAN.

Knowledge on Database indexing, buffer and cache management, monitoring databases for faults & errors, reorganizing databases, managing database space & table.

Administration of all database objects, tables, clusters, indexes, views, sequences, packages and procedures.

Troubleshooting administration problems, Query management, Integrity, Configuration and stored procedures.

Installation, configuration and maintenance of RAC, Parallel Configuration Processing, and Data guard Standby database, Installed and configured Oracle 11G RAC, CRS, using ASM.

Implemented DR by creating NON-RAC and RAC standby Data Guard for RAC Physical database and maintenance of DR databases, troubleshooting of various DG issues.

Troubleshooting of various RAC issues include node eviction, HAIP Configuration, OCR Voting disk recoveries.

Configure and build Golden Gate Extracts/replicate for multiple databases.

Installed RAC setup and DR setup using data guard.

Provide Oracle DBA 24x7 support for multiple large databases in production development and test environments for various types of databases - OLTP

Coordinated with Infrastructure and storage teams to resolve performance issues and to improve system response and run times.

Generated AWR/ADDM reports from 10g/11g database and analyzed the reports for Oracle wait events and time consuming AQL queries.

Tuning memory related issues like undersized SGA/PGA by using different memory target advisor.

Worked on SQL execution plans using SQL plan management to tune poorly performed SQL's.

Generated and analyzed STATSPACK reports and created statistics jobs for database performance

Perform Patching, Cloning, and Installation

Troubleshoot issues/errors/incidents etc.

Communicating with Oracle support on different Technical Assistant Requests TARs and bugs related to Standard Oracle Application Security.

Environment: Oracle 11g/10g, Oracle 11g RAC/ASM, Oracle Dataguard, Shell Scripting, Linux.

Om systems and Service,Hyderabad, India

AP Secreteriat Projet Sep ’2005 – Aug 2006

Database Administrator

Responsibilities

Working with the Information / Data Architect and Database Designer / Modeler to help implement the physical data model for the development and production environments for Data Warehouse and OLTP systems.

Coordinating with storage team to design/optimize the storage system by using IBM GPFS (General Parallel File System), Oracle/Sun ZFS and Exadata Servers.

Lead for a large number of tuning projects. Working with third party vendor developers on SQL code review and quality control. Performance load testing and tuning application, SQL code, and database instance by using a wide range of technologies including ADDM, AWR, Statspack, OEM Performance Manager, Spotlight and home-cooked scripts by using korn shell/Perl.

Designing and implementing High Availability Oracle GoldenGate (OGG) from front-end OLTP environments to back-end Data Warehouse (ODS) systems on Oracle 11gR2 RAC environments. Troubleshooting typical OGG technical problems such as unique key violation / long transaction.

Abending by using GGSCI / Log dump / discard file analysis etc. Performance Tuning OGG in extremely high data volume environments. Installing and configuring OGG heterogeneous environments (from Oracle to MS SQL Server).

Designing the production system monitoring framework, Configuring/Tuning Oracle Enterprise Management 12c (OEM), developing and maintaining the korn shell based home-cooked monitoring scripts to monitor database instance status, table space usage, GoldenGate process running status, J2EE/Weblogic server status, etc.

Established database backup/recovery strategy for different databases. Utilized RMAN for backup and recovery strategy. Completed export and import of different databases using Oracle Export / Import utilities and SQL*Loader.

Applied different recovery procedures for complete and incomplete recoveries depending on the type of failure.

Environment:

Oracle 11g, RAC, Golden gate, ASM, ODI, Informatica, OBIEE, Shell Scripting, Linux, windows, Nagios tool.

Contact this candidate