SUMMARY

• Experienced DBA (Oracle 9i/10g/11g/12c/19c, PostgreSQL 9.5/9.6, Mongo 2.6/3.2/3.6) on different Operating Systems AIX, Red Hat Enterprise Linux, OEL, HP - UX, and Sun Solaris.
• Experience in working in high availability, 24/7, cluster, replication, standby, development, test and production databases as well as Online Transaction Processing (OLTP) and Decision-Support System (DSS) databases.
• Experience in Installing/Configuring and Maintaining Real Application Cluster 11g and 12c Oracle Grid Infrastructure using ASM
• Hands on experience in NOSQL technology like MongoDB (CRUD OPs, Indexing, Replication, Aggregation, Sharding, various ops manager activity)
• Provision and Support Databases on AWS RDS, Azure cloud environment
• Installed and Configured PostgreSQL 9.5.x and updated to 9.6.x on RHEL 7.
• Expert in Installation and Configuration of oracle 10g/11g/12c/19c databases, Oracle Grid Control and Management of agents in production and development databases.
• Successfully implemented physical standby database using DATAGUARD feature for High availability configuration
• Experienced in tuning, diagnosing and troubleshooting databases, using V$ views, Data Dictionary views, OEM, Explain Plan, Event 10046, SQL Trace / TKPROF, AWR, ADDM, Quest Spotlight, SQL tuning advisor, and SQL access advisor. Used different type of partitioning for large tables. Good knowledge on database waits events and oracle internals.
• Expertise in RMAN-managed backup and restore concepts and options such as Full backup, Incremental, Cumulative backup, Full and incomplete restore.
• Good knowledge of Oracle Downstream and Golden Gate.
• Extensive knowledge on Proactive and reactive approach of database monitoring using PERL DBI, UNIX shell scripting and PL/SQL by automated task scheduler such as crontab, BMC control-M and DBMS job scheduler
• Knowledge of Oracle Flexible Architecture (OFA) Standards, applying software patches and Version upgrades such as Oracle 11.x to Oracle 12.x and Data migration, Listener TNSNAMES configuration.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS

Operating Systems: AIX, Ubuntu, CentOS, SuSE Linux, RHEL, HP-UX, Sun Solaris and Windows 2000/NT/XP/2012.

Databases: Oracle 12cR1, Oracle 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i, Snowflake, POSTGERG SQL, MongoDB, MySQL, Couch DB and MS SQL Server 2012

Storage Technologies: Oracle ASM, Oracle ACFS, ZFS, Veritas NetBackup, IBM Tivoli

Cloud Technologies: Amazon Web Services, Microsoft Azure, MongoDB Atlas

Virtualization: VMware, Oracle Virtual Machine

DR Technologies: Oracle Data Guard, NetApp

Replication Technologies: Oracle Streams,Oracle Golden Gate, EMC RecoveryPoint and Dell Shareplex

Backup recovery Tools: RMAN, flash recovery

Languages: SQL, PL/SQL, Unix Shell Programming, Perl, Java, Java Script, VBScript, C, C++, HTML, Python, JSON.

Tools: Oracle Enterprise Manager (OEM), TOAD, Developer 2000 (Forms & Reports), Visual Basic,office2013/Window 10, Exceed, Reflection, SQL developer, pgAdmin, VERITAS 6.0, TIVOLI, ERWIN, Crystal reports, UTLSTAT, Explain plan, TKPROF, Putty, Spotlight, SQL Optimizer, AWR and ADDM.

Utilities: SQL Loader, Exp/Imp, Data Pump, ADRCI and TKPROF

PROFESSIONAL EXPERIENCE

SENIOR DATABASE ADMINISTRATOR

Confidential, Fort Worth, TX

Responsibilities:

• Involved in implementing and managingboth Oracle12cR1 and 11gR2 RAC with ASM for OLTP and DSS applications, enabled load balancing client-server, server-server as transparent application failover.
• Managed more than 1000 database instances.
• Support EC2 and RDS for Amazon Web Services (AWS)
• Support MySQL and Postgreg
• Performing Oracle 12c/11g database installation, creation, modification and tuning issues of Oracle.
• Providing System support for both development and 24/7 production environment.
• Performed Installation, Configuration and maintenance of Oracle Downstream for Report Server ; Implemented several TABLE and SCHEMA rules on target database; performed extensive tuning on capture and apply process to reduce apply latency using LogMinor and LCR monitor
• Implemented and configured several RMAN scripts for performing Backup/Recovery on thePROD and UAT environments; Performed complete and incomplete restore and recovery.
• Implemented Oracle Partition Table (LIST and RANGE) with automated dynamic strategies to perform split and add new partitions based on requirements.
• Configure Oracle Golden Gate for change data capture.
• Installed Veritas Netbackup 6.5 client in Database servers; Performed link setup between Netbackup oracle home and Created and configured new policies to perform backup jobs.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, AWR and ADDM reports.
• Designed and developed several proactive and reactive approaches for DB monitor such as Alertlog monitor, DB hang check, TNS check, stream health check,, archive disk usage monitoring, AWR generator etc.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity
• Designed and Implement shell script to monitor Schema Growth information for capacity management.
• Configured both LOCAL and Default listener. Configuration of tnsnames.ora, listener.ora and sqlnet.ora files after creating databases.

Environment: Oracle 12c/11g/10g, Oracle 12c/11g/10g ASM, Oracle 11g Infrastructure, AWS, MySQL,Postgreg Oracle Stream, Oracle Golden Gate RHEL 5.6,AIX,HP-UX,Solaris Windows Server 2000, VERITAS Net backup, UNIX Shell Scripts, PERL Scripts, Quest Fog light, OEM, Nagios, TOAD and TKPROF

SENIOR DATABASE ADMINISTRATOR

Confidential, Irving, TX

Responsibilities:

• Involved in the installation and administration of Oracle 10g/11g RAC on a 3-node cluster in Test and Production environment.
• Configured both standalone and multi node cluster Oracle 10g/11g ASM
• Configured and maintained multi terabytes Oracle 9i/10g/11g databases.
• Created and schedule backup jobs through RMAN and KSH scripts.
• Created automated scripting to generate database daily and service availability reports.
• Worked on database backup and recovery using RMAN.
• Performed cloning, data migration using RMAN, Oracle datapump and Oracle Export/Import
• Upgraded databases from 10g to 11gR2 in standalone and 3 to 5 node RAC databases.
• Managed database security by creating and assigning appropriate roles and privileges to users depending on user activity.
• Performance and memory tuning of Databases using various Oracle tools like SQL trace, Explain Plan, ASH, AWR and ADDM.
• Involved in performance testing and tuning tasks for different RAC and standalone databases.
• Worked on Golden Gate, Shareplex and Oracle Stream for replication between Productions and ODS databases.
• Designed and implemented several PL/SQL stored procedures, functions, packages, triggers and SQL for automating daily administration tasks.
• Applied PSU and costume patches and performed testing on TEST and PROD environment.
• Support multiple severity issues and working accordingly with Oracle Support, raising and updating SR/TAR and handling call with Oracle engineers.
• Created and maintained Oracle DBA technical documents and implementation procedures

Environment: Oracle 10g/11g, Linux, HP-UX, Solaris, SAN Storage, RMAN, RAC and ASM, Shell Scripting, PL/SQL, and SQL *PLUS, OEM, and SQL developer.

DATABASE ADMINISTRATOR

Confidential, Irving, TX

Responsibilities:

• Involved in implementing and managing Oracle10g /11gRACdatabases with ASM and enabled load-balancing feature client-server, server-server as Transparent Application Failover (TAF).
• Actively participated in cross platform migration from AIX (64bit) to RHEL5 (64 bit) using RMAN-convert and transport tablespace.
• 24 X 7 Production Database Administration, Support and monitoring to ensure proactive problem recognition and resolution of database issues.
• Performed daily database administration tasks like user management, web connectivity, space monitoring and management, performance monitoring and tuning
• Monitor full and incremental backups by using RMAN
• Configured OEM (grid control) 10g for diagnosing and monitoring performance related problems.
• Write SQL/Unix Shell Scripts for gathering capacity planning information and compiling estimates based on new client requirements.
• Monitor logical Backup and Recovery by import & export, Data pump, for databases.
• Troubleshooting, analyzing explain Plan, STATSPACK reports and tracing user sessions for performance analysis.
• Ensuring high availability of Production, Test, and development databases for users to minimize database downtime.
• Performed database cloning to setup test and development database.

Environment: Oracle 11g/10g/9i, Oracle 11g Infrastructure, Oracle Stream, RHEL 5.6,AIX,HP-UX,Solaris Windows Server 2000, VERITAS Net backup, UNIX Shell Scripts, Quest Fog light, TOAD and TKPROF

DATABASE ADMINISTRATOR

Confidential, Irving, TX

Responsibilities:

• Implemented Data Guard and managed Standby databases.
• Involved in implementing and managing Oracle10g R2RACdatabases with ASM features.
• Implemented Oracle Uni-Directional Streams for a 10g database.
• Creating Materialized views and utilized Data Replication to provide high availability of databases
• Installed, upgraded and patched Oracle software. Setup new servers including Oracle software installation and perform backup testing.
• Tuned SGA/PGA parameters, and I/O tuning via OEM, STATSPACK.
• Involved in installing, configuring and monitoring of Oracle Enterprise Manager (OEM): DB Control, Grid Control 9i/10g.
• Increased the database performance using ASSM and Tablespace Management.
• Developed Shell Scripts to automate database operation and database monitoring.
• Developed and modified some Oracle backup and recovery strategies.
• Used Oracle backup/recovery RMAN utility and manual scripts to implement backup and performed complete and in-complete recovery.
• Performed database tuning using AWR, ADDM, TKPROF, Enterprise Manager and TOAD.
• Performed database performance tuning for memory (SGA), disk I/O contentions, rollback segment contention and application tuning.
• Utilized SAN (Storage Area Network) to transporting data for storage and retrieval.
• Involved in Logical & Physical Schema Design and data modeling using ERWIN.
• Worked with Development team for query optimization.
• Provided 24*7 on-call production database supports.
• Created TAR with oracle support to resolve some critical issues.

Environment: Oracle 10g, 9i RAC, Oracle 10g interMedia, Server Red Hat Enterprise Linux Advanced Server/Enterprise 2.1/3.0,AIX,HP-UX,Solaris Windows Server 2000, VERITAS Net backup, UNIX Shell Scripts, TOAD, TKPROF and SQL*Net/Net8

ASSOCIATE DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Installed and configured oracle 8i/9i Software.
• Managed Oracle Hot backup and Cold backup, and recovery
• Scheduled backup with shell scripting and verified backup.
• Worked with database developer team for created Database Design using E-R diagrams using Erwin
• Developed cursors, stored procedures, packages, functions and triggers in PL/SQL
• Performed installation of Oracle software products and database creation and upgrade.
• Monitored the database for growth and added space to the tablespace as per demands.
• Refresh of theintegration database from the production database.
• Oracle database performance tuning using STATPACK, Explain Plan, TKPROF and OEM.
• Responsible for data integrity and user security.
• Managed Partition Tables& Indexes.
• Created Materialized Views and snapshots for high-end application usage.
• Maintained 9i database and applied necessary Oracle patches.
• Maintained system storage and planned future storage requirements.
• Created schema objects, rollback segments and redo log groups.
• Configuring SQL*Net through tnsnames.ora and listener.ora
• Participated in planning and implementation of off-site Disaster Recovery planning and testing.
• Created and maintained documentation and standards.
• Checked the database backup logs and alert log files and fixed the issues based on the error.

Environment: Windows 2000 Server, IBM AIX, Red Hat Linux, Oracle 8i/9i, ERWIN