Certified Database Administrator, with 5 years of experience designing, installing, upgrading, and maintaining 10g,11g and 12c databases in different OS platforms. Professional skills include Backup and Recovery methodologies (RMAN), Performance Tuning, Production Support, Upgrades & Patches, Migration, Security and User Management. Implemented and administered 3 Node RAC, configured physical and logical standby databases for disaster recover. Configured and administered Golden gates for real time replication. Including complete life cycle knowledge. Established the appropriate monitoring and alerting of solution events related to performance, scalability, availability, and reliability.
Five(5) years experience with ORACLE DATABASE ADMINISTRATION (10g, 11g and 12c)
Five(5) years working on Windows 2008/2012, Solaris, and Red Hat Linux
Set and maintaining of streaming replication and logical replication.
Configured pgLogical for database upgrade from postgres9.5 to 10.
Installation and configuration of Replication server(XDB) from oracle to postgres and postgres to postgres or EDB
Implementing REINDEX for cleaning out index bloat.
General maintenance: upgrades, backups, troubleshooting, recovery.
Configured and maintained pg_pool and pg_bouncer for connection pooling
Two(2) years of experience with MS SQL SERVER & POSTGRESQL, INSTALLATION AND ADMINISTRATION, PERFORMANCE TUNING, BACKUP AND RECOVERY, CREATING USERS, TABLES, GRANTING PRIVILEDGES.
One(1) year of experience configuring and managing COMMVAULT BACKUP
Performed general maintenance: upgrades, backups, troubleshooting, recovery. Designed, installed and configured DATABASES. Performed security, performance tuning and monitoring of databases. Assisted developers.
Five(5) years experience with ORACLE DATABASE ADMINISTRATION (10g, 11g and 12c)
Five (5) years of PERFORMANCE TUNNING experience (Database, Memory and SQL Tuning using the AWR, ASH, ADDM, EXPLAIN PLAN).
Five (5) years of experience configuring and admistering DATA GUARD for disaster recovery. Configured both physical and logical standby databases. Configured dataguard BROKER to ease the role transition.
Five (5) years using RMAN- (backups, recovery and cloning).
Five(5) Years of experience with MIGRATING . from similar to different operating system such as Linux Red Hat, AIX, Solaris, Windows using DATAPUMP, GOLDENGATE, TRANSPORTABLE TABLESPACE, CREATE TABLE AS, and many other strategies.
Five(5) years working in OLTP and 1 year OLAP Environments
Five (5) years of experience MONITORING THE DATABASE WITH TOOLS ( TOAD, SQL Developer, OEM 12c, …).
Five (5) Years of experience implementing SECURITY (Auditing, TDE, Network Encryption,…).
Five (5) Years of experience UPGRADING & PATCHING (CPU and PSU).
Five (5) Years of experinece managing Oracle GOLDENGATE (both 11g and 12c). I did both unidirectional and bidirectional configuration.
Five(5) years of experience managing and administering 2 NODE RAC (11g and 12c) using ASM, ACFS and OCFS storage
Two(2) years of experience with DATA WAREHOUSE
Two (2) managing and maintening sql server database using MMS and Tsql
Two (2) maintening postgresql using PgAdmin 4, Psql, pg_dump,Pg_basebackup, pgBackrest
Sun Products Corporation - Salt Lake City, Utah
January 2018 – Present
Capacity planning: Allocate system storage and plan future storage requirements.
Installed, Configured, Setup, Maintained and Supported Oracle 11g, 12c Standalones and 3 nodes RAC, Physical and Logical Standby database for Test, Development and Production, and staging on Linux, AIX and Windows environments for various home-developed applications like Portfolio Management Systems, vendor applications such SAP Business solutions and so on.
Upgraded Grid Infrastructure and databases from 11g to 12c manually or using DBUA. Involved in applying upgrade patch, maintenance and interim (Opatch) patches on all the databases for security and bug fixes.
Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts to provide reports.
Performing backup, restore and creating databases using PgAdmin 4, pg_dump and pg_basebackup on PostgreSQL 9.6,10 and EDB.
Setup of logical replication
Installed and configured pg_badger and pg_hero for Reporting.
Installed and configured MTK for migration from Oracle to postgresql and EDB advance server.
Maintaining postgresql with PgAdmin 4, Psql, pg_dump, Pg_basebackup, pgBackrest.
Used GIT, SALT/SALTSTACK for automating server and database related tasks.
Used of pg_view, pg_activity for monitoring of databases.
Creating Tablespaces, Schemas, Users, profiles and implementing various adjustments in postgresql.conf file and granting users and application access through pg_hba.conf file etc..
Experience in system Monitoring, Database Tuning, Memory and SQL Tuning using OEM 12c, Top command, VMSTATS, IOSTATS, Explain plan, SQL Trace, TKPROF, AWR, ADDM, ASH, Cluster Interconnect Tuning (RAC). And Assisted in providing consultation such as creating Materialized views, adding indexes, dropping unnecessary indexes, using hints wherever possible.
Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
Scheduled and monitored on Crontab repetitive activities such gathering schema statistics, table space usage report, Refreshing Dev and Test instances with data from Production using Datapump and to monitor blocking sessions.
Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
Designed, installed and configured databases in an Oracle Cloud environment.
General maintenance: hardware, upgrades, backups, troubleshooting, recovery.
Migration, security, performance tuning and monitoring of databases.
Assisted Developers with tuning slow running sql statements
Granted privileges on PACKAGES, PROCEDURES, FUNCTIONS.
Created and monitored Physical and Active standby databases, running on maximum protection, or performance modes for Disaster Recovery and High Availability on 11g and 12c Oracle databases.
Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, ASM, RMAN.
Performing backup, restore and creating databases using PgAdmin 4, pg_dump and pg_basebackup on PostgreSQL 9.6,10 and EDB
Setup log shipping and database mirroring in sql server using MMS
Sometimes work with security team to perform vulnerability scan using wireshark and Nessus
Equifax - Atlanta, GA
August 2014 – December 2017
Oracle Database Administrator
Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
Created, monitored and troubleshoot Physical Standby databases using RMAN and scripts with zero downtime. Performed Failover and Switchover Operations using Data Guard Broker and manually during DR testing and whenever required.
Handled daily production problems/change requests with Oracle.
Performed Physical backup (hot and cold) as well as Logical backup (Export/Import)
Trained in installation, troubleshooting, maintenance and command line interface for Windows 7, Windows 8.1, Mac OS and Linux and general computer hardware repair.
Automated and monitored databases, backup and recovery activities through Cron jobs and also customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
Worked with a team for installation and maintenance of ORACLE 10g and 11g RAC, ASM databases for high availability.
Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using AWR, ADDM and ASH reports, SQL TRACE, TKPROF, Explain Plan, TOAD.
Performed database, schema & table level Refresh from production to test/development environment Using RMAN and Data pump utilities. Also Implemented Oracle's Transportable Tablespace (TTS) feature (Oracle 11g, 12c) to quickly move Tablespaces across Oracle databases servers.
Involved in a Client-Server environment using tnsnames, LISTENER, Net Configuration Assistant and other configuration files.
Used Oracle Flashback Technology for logical recovery purpose with sometimes the need to create a Guaranteed restore point right after a recovery or during switchover operations.
Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM.
Used stackbuilder plus 4.1.0 to install and upgrade postgres softwares.
EDUCATION & CERTICATIONS
Bachelor’s Degree in information Technology
Upgrade to Oracle Database 12c (OCA)
REFERENCES: Available upon request