Candidates About

 

Fikrat Ismayilov

CAREER SUMMARY

·         Over 13 years’ of experience in IT Industry working as a DBA in multiple industries

·         Experience as On-Call 24x7 production DBA support, application/development DBA.

·         Extensive knowledge on database administration for Oracle 9i, 10g, 11g, and 12C with experience in very large scale database environment and mission critical large OLTP and OLAP systems.( size=10TB)

·         Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC and and 12CRAC and standby database for High Availability and Disaster Recovery purpose.

·         Experience in managing Oracle databases running on MS-Windows, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.

·         Hands on experience in Oracle 10g/11g/12C RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).

·         Good experience RAC Clusterware administration, Configuration and Patching.

·         Good experience Mysql, Mysql Cluster, Mysql router, Proxysql, Maxscale, Mysql Replication, Mysqldump, Mysql Enterprise Backup, Mysql Enterprise Monitor, PMM, Mariadb, Percona Xtrabackup

·         Extensive experience in Dataguard configuration, implementing and maintaining standby databases.

·         Hands on experience in Grid control, Materialized views, GoldenGate Replication.

·         Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.

·         Setup Oracle Enterprise Manager (OEM) 10g & Grid Control (11g) & Cloud Control (12c,13c) for database monitoring/performance/diagnostics.

·         Extensive experience in database Backups RMAN ((Full/Incremental backups) and in traditional hot/cold backups and in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces

·         Good experience in writing/editing UNIX Shell Scripts.

·         Good Experience in PATCHING AND UPGRADATION and upgrading Oracle Development and Production databases from 9i to 10g & 11g, 10g to 11g, 11g to 12C.

·         Successfully migrated   Databases To Amazon Cloud System.

·         Extensive knowledge and experience on managing very large Data Warehouse databases.

·         Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers.

·         Installed and Configured Vmware ESX

·         Good knowledge on ITIL standards and best practices. 

 

Certificates

·         Oracle Database 10g : Real Application Cluster Administrator Certified Expert

·         Oracle 11g Database Administrator Certified Associate

·         Oracle Database 11g Administrator Certified Professional

·         Oracle Database 11g Performance Tuning Certified Expert

·         Oracle Partner Network Certified Specialist

 

Technical Skills

Operating System	Red Hat Linux, Unix, Solaris, HP-UX, AIX, Windows 2003/XP/7/8.
Databases	Oracle 9i/10g/11g/12c,RAC 10g/11g/12c, MS Access, Mysql 5.5/5.6/5.7,Mysql Cluster, MsSql Server(2005-2014),Mongodb
Virtualization Technologies	VMware, Oracle Virtual Machine
Languages	SQL, PLSQL,  UNIX shell scripting, Ant scripting, Batch Scripting
Web Servers	Apache Tomcat, Web logic, Jboss
Tools and Utilities(ORACLE)	Oracle Cloud Control (12,13), Oracle Grid Control, Oracle Enterprise Manager,Sql Developer, PL/SQL Developer,Import/Export, Data pump,ODI, Database Vault,Oracle Enterprise User Security (EUS),DBSAT(Oracle Database Security Assesment Tool),ODAT(Oracle Database Attacking Tool),ORACHK,EXACHK, Oracle Label Security, SQL * Loader, SQL Trace, OEM, Explain Plan, Oracle data reduction,Dataguard,Oracle Streams,HA, Snapshot Standby,Mysql Replication,Statspack, Golden Gate, AWR,ASH, ADDM, RMAN, Oracle Secure Backup, FTP, TKPROF,Amazon RDS,Amazon EC2, Amazon Cloudwatch,AWS Migration Toolkit, Flashback,Partitioning,Mysql Enterprise Backup,Mysql Dump,Percona XtraDB Cluster, Percona Xtrabackup,Mongodb Replication,Oracle Goldengate(11,12),Mysql Enterprise Monitor,Performance Tuning,Disaster Recovery, OLTP, OLAP,Datawarehouse, ASM, CRS, SRVCTL, Sql Loader, Bash, Data Mining,Sql, PL SQL, Top, AWK, SED,Veritas,CVS,SVN , Oracle Weblogic, Jboss, Tomcat ,Docker,Exadata
Other Tools	SQL Developer, OEM, VMware, putty, TOAD, WINSCP,PMM

 

 

Other trainings

·         Jboss,Eyeks,Dal Application servers,Ldap

·         Oracle 10G Real Application Clusters training-  Oracle University

·         Oracle Database 11g Administration Workshop 1 -Oracle University

·         Oracle Database 11g Performance Tuning course - Oracle University

·         Oracle 11g Rac and Grid Infrastructure Administration Accelerated Release 2 - Oracle University

·         Intermediate System Administration for the Solaris 10 OS(SA-200-S10)

·         Advanced System Administration for the Solaris 10 OS (SA-202-S10)

·         Solaris 10 Network Administration (SA-300)

·         VeritasNetBackup 6.x for Unix, Administration

·         VMware vSphere: Manage Availability

·         VMware vSphere4: Install, Configure, Manage course

·         VMware vSphere: Manage Scalability course

·         Mysql For Database Administrators ED3 - Oracle University

 

Experience:

1.       USPTO(UNATED STATES PATENT AND TRADEMARK OFFICE)

        SME Oracle DBA

         May 2017-

        Alexandria,Virginia

       Responsibilities: 

·         Handled On call issues and jump into Sev1 /2 calls and ensure timely restoration of database services. Take care of critical Database tasks and ensure end-to-end delivery of work 

·         Extensively worked on multiple 12C RAC environments on ASM, 12c DATAGUARD setups & RMAN

·         Applied quarterly PSU Patches to RAC/Non-RAC databases. 

·         Space Management in ASM Diskgroups, Addition of new disks etc

·         Troubleshooted RAC, DATAGUARD, and ASM issues 

·         Successfully configured TDE for ORACLE 12c RAC

·         Successfully Configured oracle datababase with OID(Oracle internet directory)

·         Successfully upgraded 11g Rac databases to 12C rac database

·         Succeffully Configured HA Rac Standby Database for Primary Rac Databases

·         Configured of RMAN backups/Monitoring for RAC databases, refresh stage databases 

·         Setup multiple Dataguard Setups (deployed Dataguard Broker-DGMGRL) for 2/3 Node 11g RAC Clusters, Enabled Faststart Failover

·         Setup and configured OEM 13C Grid Control agent installs on servers, configure new databases for monitoring, Setup jobs, alerts, notifications etc. 

·         Installed and Configured Goldengate plugin to OEM13C to monitor Goldengate instances via OEM

·         Installed and configured Goldengate replication. Perform zero downtime migrations 

·         Export and import of tables, schemas and Full db as per development/Application team req. using Data pump /Exp-Imp 

·         Configured RMAN backups for databases and schedule them through Oem

·         Performance Tuning of problem queries 

·         Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.

·         Installed and Configured Oracle Active-Active Goldengate 12.2

·         Successfully Configured HA Goldengate

·         Implemented and maintained Database security (create and maintain users and roles, assign privileges)

·         Implementation of High Availability Solutions with Oracle 12c with Oracle dataguard broker (Automatic Failover)

·         Configured Role Based Access Control (RBAC), and assigned privileges to individual users or a group of users, to ensure security in Oracle(11g,12c)

·         Implemented Oracle Enterprise User Security(EUS) configured authentication via LDAP

·         Successfully implemented TLS/SSL configuration On Oracle database 12c

·         Configured Network Encryption between Oracle Databases and Application servers

·         Migrated Oracle Database 12c to Amazon RDS

·         Migrated database to Exadata X6

·         Sucessfully Patched Exadata x6 (infiniband switches, compute Nodes, Cell servers)

·         Sucessfully implemented Oracle data redaction(dbms_redact) to secure sensitive data

 

 

 

2.       Verizon

Senior Oracle/Mysql DBA 

Oct 2016– Apr 2017

Ashburn, Virginia

Responsibilities: 

·         Handled On call issues and jump into Sev1 /2 calls and ensure timely restoration of database services. Take care of critical Database tasks and ensure end-to-end delivery of work 

·         Extensively worked on multiple 12C RAC environments on ASM, 12c DATAGUARD setups & RMAN

·         Successfully managed more than 1000+ Oracle databases at the same time

·         Applied quarterly PSU Patches to RAC/Non-RAC databases. 

·         Space Management in ASM Diskgroups, Addition of new disks etc

·         Troubleshooted RAC, DATAGUARD, and ASM issues 

·         Creation of new RAC databases, conversion from single instance to RAC 

·         Configured of RMAN backups/Monitoring for RAC databases, refresh stage databases 

·         Setup multiple Dataguard Setups (deployed Dataguard Broker-DGMGRL) for 2/3 Node 11g RAC Clusters, Enabled Faststart Failover

·         Perform DR drills e.g. Switchover/Switchback using DG Broker etc.

·         Setup and configured OEM 12C Grid Control agent installs on servers, configure new databases for monitoring, Setup jobs, alerts, notifications etc. 

·         Installed and configured Goldengate replication. Perform zero downtime migrations 

·         Export and import of tables, schemas and Full db as per development/Application team req. using Data pump /Exp-Imp 

·         Configured RMAN backups for databases and schedule them through Crontab 

·         Resolved common database issues like Locking, FreeSpace, connectivity issues, Applying patches etc 

·         Performance Tuning of problem queries 

·         Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.

·         Installed and Configured Oracle Active-Active Goldengate 12.2

·         Configured from Oracle 11g to Mysql 5.6 replication via Goldengate 12.2

·         Installed and Configured Galera Cluster

·         Implemented and maintained Database security (create and maintain users and roles, assign privileges)

·         Implementation of High Availability Solutions with Oracle 11g, 12c Rac, Physical and Logical Standby Databases and Replication using Oracle Streams

·         Migrated Oracle Database 11g to Amazon RDS

·         Enabled Amazon Cloudwatch to monitor Amazon RDS instances

·         Sucessfully installed and configured Amazon Commandline tools (awscli) for managing Amazon RDS and EC2 instances

·         Successfully implemented AWS Migration toolkit (DMS) to migrate Databases to Amazon Cloud System

·         Installed and configured Maxscale/Proxysql for failover and load balancing for Percona Cluster

·         Installed and configured Galera arbitrator for PerconaMysql Cluster

·         Created Xtrabackup incremental backups for Percona cluster

·         Used mysqldump for exporting   mysql( schemas, tables....)

·         Installed and Configured Mysql Enterprise Monitor installed agents to mysql instances  to monitor Mysql Databases

·         Sucessfully installed and configured Percona tools  for better solving problems on mylsq/maridb/percona databases.

·         Sucessfully implemented pt-query-digest for analyzing slow_query_log files, tspdump files and mysqlbinlog files on Mysql/Maridb databases

·         Sucessfully implemented pt-deadlock-logger for analyzing and solving deadlock issues on mysql/maridb databases

·         Installed and Configure 4 node Percona Geo Cluster 5.6

·         Sucessfully upgraded 4 node Percona CLuster(mysql) from 5.6 to 5.7

·         Sucessfully upgraded Galera Arbitrator from 5.6 to 5.7

·         Installed and Configured Mongodb Failover Cluster 3.4

·         Used Mongodb Ops manager for taking snapshot Backup for Mongodb databases

·         Used Mongodump and Mongorestore for backup and restore mongodb Databases

·         Installed and Configured Mongodb OPS Manager For Monitoring Mongdb databases on Amazon EC2.

·         Installed and Configured Neo4J 6 Node Casual Cluster on Amazon EC2

·         Installed and Configured Neo4J 3 Node HA Cluster on Amazon EC2

·         Successfully Configured Full and Incremental Backups for Neo4j  Databases

·          

 

3.       Ministry Of Taxes of Azerbaijan

Senior Oracle DBA 

Apr 2012 - Apr  2016

Baku, Azerbaijan

Responsibilities: 

·         Handled On call issues and jump into Sev1 /2 calls and ensure timely restoration of database services. Take care of critical Database tasks and ensure end-to-end delivery of work 

·         Extensively worked on multiple 11gR2 RAC environments on ASM, 11g/12c DATAGUARD setups & RMAN

·         Applied quarterly PSU Patches to RAC/Non-RAC databases. 

·         Applied CRS Bundle patches/PSU to CRS on RAC clusters.

·         Upgraded from  11.2.0.2 CRS/ASM to 11.2.0.4 GRID Infrastructure

·         Space Management in ASM Diskgroups, Addition of new disks etc.

·         Troubleshooted RAC, DATAGUARD, and ASM issues 

·         Creation of new RAC databases, conversion from single instance to RAC 

·         Installed and Configured 2/3 Node 11gR2 setups with ASM on Linux & HP-UX 

·         Configured of RMAN backups/Monitoring for RAC databases, refresh stage databases 

·         Setup 11g Standby database setups, Active Dataguard 

·         Created 2 node 11gR2 Real application cluster on Oracle Virtual Machine

·         Migrated data from physical server to OVM

·         Setup multiple Dataguard Setups (deployed Dataguard Broker-DGMGRL) for 2/3 Node 11g RAC Clusters, Enabled Faststart Failover

·         Perform DR drills e.g. Switchover/Switchback using DG Broker etc.

·         Upgraded RAC-Dataguard setups from 11.2.0.4 to 12.1.0.2 

·         Setup and configured OEM 12C Grid Control agent installs on servers, configure new databases for monitoring, Setup jobs, alerts, notifications etc. 

·         Support RAC & Single Instance Production/Stage/Dev databases on (Redhat, Solaris, And Vmware environments) 

·         Installed and configured Goldengate replication. Perform zero downtime migrations 

·         Export and import of tables, schemas and Full db as per development/Application team req. using Data pump /Exp-Imp 

·         Configured RMAN backups for databases and schedule them through Crontab 

·         Resolved common database issues like Locking, FreeSpace, connectivity issues, Applying patches etc 

·         Performance Tuning of problem queries 

·         Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.

·         Installed and Configured Oracle Goldengate 12.2 on (windows, linux and unix platforms)

·         Configured from Oracle 11g to Mysql 5.6 replication via Goldengate 12.2

·         Configured Oracle Goldengate 12.2 from Oracle11g (windows platform) to Oracle 11g (Solaris sparc platform) replication

·         Configured Oracle Goldengate MsSql to Oracle (linux platform) replication

·         Upgraded Oracle GoldenGate from 11.2 to 12.2

·         Implemented and maintained Database security (create and maintain users and roles, assign privileges)

·         Migrated Physical Oracle 11g databases to Virtualization (Oracle Virtual Machine)

·         Implementation of  High Availability Solutions with Oracle 11g,12c Rac, Physical and Logical Standby Databases and Replication using Oracle Streams

·         Installed and Configured Oracle Database Vault

·         Migrated Physical Oracle Databases to Virtualization Environments (Vmware) in Linux Redhat

·         Created and Configured Oracle Data vault

·         Created and configured Realms, Command Rules, Rule Sets, Factors integrated with Oracle Label Security for Oracle data Vault

·         Used oracle data reduction to  perform column masking to prevent sensitive data 

·         Migrated Oracle Database  11g To Amazon RDS

·         Successfully implemented  AWS Migration toolkit to migrate Databases To Amazon Cloud System

·         Installed and configured Mysql (5.5,5.6,5.7) Mysql  instances

·         Installed and configured Mysql Cluster configured Load balancing with Mysql router, created backup with ndb backup

·         Crreated backup with Mysql enterprise backup for Mysql databaseses

·         Used mysqldump for exporting  mysql( schemas, tables....)

·         Installed and Configured Mysql Enterprise Monitor installed agents to mysql instances  to monitor Mysql Databases

·         Successfully installed and configured Ms Sql Server(2014,2016) Enterprise editions.

·         Successfully implemented SSIS( SQL SERVER Integration services) on sql 2016.

·         Successfully configured Log shipping for Mssql 2016 server.

 

4.       CDB - Caspian Development Bank, Baku, Azerbaijan

Senior Oracle DBA

Oct 2010- Mar 2012

Baku, Azerbaijan

Responsibilities: 

·         Installed Real Application Cluster Databases (4 different cluster database)

·         Installed and Configured Physical standby database for Production Databases

·         Installed and Configured Application Servers (Jboss)

·         Created and Scheduled Rman and expdp Backups for Production Database and Application servers

·         Created and Installed Mysql database for integration for other organizations

·         Created and Scheduled Backups for Mysql database