Sql Developer On-Call

CAREER SUMMARY

Over **+ 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, 12C and 19C with experience in very large scale database environment and mission critical large OLTP and OLAP systems.( size=100TB)

Involved with installation and maintenance of ORACLE 10g RAC/oracle 11gRAC, 12CRAC and 19CRAC 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/19C RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)On Premise environment.

writing stored Procedures, PL/SQL Packages, Triggers, functions, ref Cursors, Collections and Bulk Collect, using various oracle utilities to implement the business logic.

Experience in dealing with RDBMS, including Normalization, Stored Procedures, Constraints, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

Experience with database tools TOAD, PL SQL Developer and SQL Plus.

Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections.

Good experience RAC Clusterware administration, Configuration and Patching.

Good experience Mysql, Mysql Cluster, Mysql router, Proxysql, Maridba Maxscale, Mysql Replication, Mysqldump, Mysql Enterprise Backup, Mysql Enterprise Monitor, PMM, Mariadb Server, Maridb Replication, 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, 18c, 19c On Premise Environment

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.

Successfully used JIRA ticketing query system to fix the customers issues.

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

Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle Cloud Infrastructure 2019 Certified Cloud Operations Associate

Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Oracle Cloud Infrastructure 2019 Certified Architect Associate

Oracle Cloud Infrastructure 2019 Certified Architect Professional

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 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,AWS Migration Toolkit, Flashback,Partitioning,Mariadb,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, GIT,Maven,Ant scripts,Oracle Weblogic, Jboss, Tomcat,Docker,Exadata,Proxysql,Oracle, Python, Ansible, Zfs file system,

Connection Manager(CMAN),Mysql Router,HAPROXY

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 Scalabilitycourse

Mysql For Database AdministratorsED3 - Oracle University

EXPERIENCE:

1.Verizon Wireless

Remote Oracle/Goldengate Dba Team Lead

Apr 2019 -

Ashburn, Virginia

Installed and Configured 3 node 12.2 Oracle Rac Cluster

Installed and Configured 19c Rac Cluster

Upgraded 12.1.0.2 databases to 19C

Upgraded 11.2.0.3 Rac Databases to 12.2.0.1 with zero downtime migration using goldengate

Applied Latest Psu on 12.2 Rac Databases.

Applied latest psu on 19c rac databases

Upgraded goldengate from 12.3 to 21.9

Configured oracle options like oracle text, oracle xml, OLAP, TDE (latest version of 19c)

Used datamining option to mining archivlogs file to extract the data and sqls from archivelog files

Configured custom shell scripts to Monitor Goldengate and Oracle databases

Installed and Configured OEM 13R3 to monitor Oracle databases

Installed and configured Goldengate 12.3 and applied latest psu

Configured Parallel integrated replicat in goldengate 12.3 to speed up replicat process

Configured autocdr in goldengate 12.3 for active-active configuration

Successfully configured encryption between goldengate instances.

Automated Goldengate error handling and auto fix error’s.

Automated Goldengate ddl replication on Peoplesoft Application.

Troubleshooted performane issues on goldengate using trace,trace2,utl_spadv(streams performance advisor), integrated capture and integrated replicat health check script and etc..

Troubleshooted performance issues when upgrading database to 12.2 version

Used custom scripts to monitor and fix performance issues on Oracle databases.

Upgraded 3 node rac grid software from 12.2 to 19.3 in place upgrade

Upgraded 3 node rac cluster database from 12.2 to 19c using in place upgrade

Upgraded 12.2 database to 19c using oracle goldengate with zero downtime migration To new environment

2.Xperton

Remote Mysql/Oracle/AWS DBA

Dec 2017 – Apr 2019

Arlington, Virginia

Install and Configure Mysql5.7 version on Amazon RDS

Successfully installed and Configured Proxysql for load balancing and failovering between the mysql nodes

Successfully installed amazon CLI to monitor and manage amazon instances

Enable Enhanced monitoring on Amazon Rds instances

Install and configure Percona Monitoring and Management tool (PMM) on Amazon AWS

Install and configure percona tools for advanced monitoring.

Configured Full and Incrimental backups through percona xtrabackup

Configured Percona Xtradb cluster 5.7 on Amazon EC2 instances

Installed and Configured Oracle 12r2 Rac databases

Installed and Configured OEM 13R3 to monitor Oracle databases On Premise Environment

Successfully Migrated 30TB Oracle rac Database to Amazon ec2.

Successfully configured HugePages for Oracle 12R2 databases

Successfully configure Oracle Connection Manager(CMAN) for securing Oracle connections.

Successfully installed 18c database On Premise Environment

Configured shell scripts to take a backup on Redhat7 and Solaris operating systems

Successfully migrated databases to Vmware virtualization.

Successfully Upgraded 12r1 databases to 12r2 version

Sucessfully implemented Goldengate 12c R3 on Oracle servers.

Developed some code to Encrypt PII data on lower environments

3.USPTO(UNATED STATES PATENT AND TRADEMARK OFFICE)

SME Oracle/Mongodb DBA

May 2017- Nov 2017

Alexandria,Virginia

Responsibilities:

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

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

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

Sucessfully configured TDE(Transparent data Encryption) for ORACLE 12c RAC

Successfully Configured oracle datbabase with OID(Oracle internet directory)

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 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

Sucessfully wrote scripts on PL/SQL that includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader

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

Successfully Configured HA Goldengate On Premise Environment

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)

Migrated Oracle Database 11g To Amazon RDS

Migrated database to Exadata X6

Installed and configured Maxscale 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

Installed and Configure 4 node Percona Geo Cluster 5.6

Sucessfully upgraded 4 node PerconaCLuster(mysql) from 5.6 to 5.7

Sucessfully upgraded Galera Arbitrator from 5.6 to 5.7

4.Verizon

Senior Oracle 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

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 On Premise Environment

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 configuredGoldengate 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

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

Migrated Oracle Database 11g To Amazon RDS

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

Installed and configured Mariadb Maxscale for failover and load balancing For Percona Cluster

Installed and configured Galera arbitrator for PerconaMysql Cluster

Created Xtrabackup incremental backups for Percona cluster/ Maridb

Used mysqldump for exporting mysql/maridb( schemas, tables )

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

Installed and Configure 4 node Percona Geo Cluster 5.6

Sucessfully upgraded 4 node PerconaCLuster(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

5.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 On Premise Environment

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 Vmwareenvironments)

Installed and configuredGoldengate 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 unixplatforms)

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 GoldengateMsSqlto 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 (Vimware) in Linux Redhat

Created and Configured Oracle Data vault

Created and configured Relams, 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 Mysqldatabaseses

Used mysqldump for exporting mysql( schemas, tables )

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

Installed and Configured Mongodb Instances

Configured HA for Mongodb Instances

Used Mongodump and Mongorestore for backup and restore mongodb Databases

Installed and Configured Mongodb OPS Manager For Monitoring Mongdb databases

6.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 andScheduled Backups for Mysql database

Created and Installed CVS server

Created and Installed Development Environment (Database and Applications)

Involved in 24x7 production database maintenance and on-call support.

Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 9i to Oracle 10g environment.

Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.

Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.

Instance cloning done to create test and training environments.

Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers

Partitioned large tables to increase the performance.

Configured scripts to monitor activity with database.

Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

7.State Committee On Property Issues Of Azerbaijan Republic, Baku, Azerbaijan

Oracle DBA

Oct 2004- Sep 2010

Baku, Azerbaijan

Responsibilities:

Created and Installed Oracle Real Application Cluster Database (with 2 nodes)

Installed and Configured Physical standby database for Production Database

Installed and Configured Application Servers (Jboss, Dal, Eyeks, Oturum)

Created and Scheduled Rman and expdp Backups for Production Database

Created and Installed Development Environment (Database and Applications)

Created andScheduled Backups for Application servers

Created and Installed CVS server

Migrated All previously Installed Databases into one Production Database

Created and Configured Automated Document Management Systems

Managing and maintaining Oracle databases running on Linux

Involved in 24x7 production database maintenance and on-call support.

Responsible for administering and supporting production and development Oracle 8i databases. Migrated production and development environments from Oracle 8i to Oracle 9i environment.

Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance.

Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.

Instance cloning done to create test and training environments.

Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers

Partitioned large tables to increase the performance.

Configured scripts to monitor activity with database.

Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Installed and Configured Sql Server replication and log shipping

Installed and Configured Sql Server 2005

Upgraded All Sql 200 servers to 2005 and migrated all Databases to SQL 2005

EDUCATION

Azerbaijan State Economics University (Master in Finance)

Baku State University (Bachelor in Economics)

Contact this candidate