SUMMARY

• Highly accomplished and seasoned Oracle Database Administrator with knowledge on other RDBMS such as MS SQL Server databases, PostgreSQL running on on - premises/Azure and AWS RDS instances.
• I Have over 7 years of extensive knowledge and proficiency as a database administration. I have worked on large production databases ranging from 400GB to 8TB performing different types of DBA tasks, such as configuration/installations, monitoring, Migration, Upgrade/Patching, management, protection (backup & recovery) and security, respectively.
• Experience in the Implementation of different database high availability solutions like Real Application Cluster (RAC), DATAGUARD and GOLDEN GATE, Always On Availability Group, Mirroring, and log Shipping across multiple platforms like LINUX, UNIX and Windows.
• I have Proactively monitored and tuned system available resources using tools and utilities like OEM, customized scripts, AWR report, ASH, the Explain plan SQL tuning advisor SQL Profiler to keep the performance of database system up and running. Possess complete SDLC knowledge with great working experience on Oracle 10g, 11g, 12c and 19c versions, and Sql Server 2008-2016 Respectively.

AREAS OF EXPERTISE

• Oracle 10g, 11g, 12c,19C
• MSSQL SERVER 2008-2017
• Sun Solaris 9.x, 10.x
• AIX 5.3, 6.1
• TOAD
• OEM Cloud Control
• Goldengate
• Performance tuning
• RMAN
• DATA GUARD
• Upgrades and patches
• Cloud migration
• Oracle Enterprise Manager (OEM)
• Real Application Cluster (RAC)
• SQL SERVER MANAGEMENT STUDIO
• Mai
• PL/SQL
• Windows PowerShell
• Data pump
• AWR
• ADDM
• ASH
• EXPLAIN ANALYZE
• Explain Plan
• STATSPACK
• Putty
• Database replication
• AWS RDS
• S3 BUCKET
• CloudWatch
• IAM
• Database security
• Database backups
• Data migration
• SQL*Plus
• SQL*Loader
• Service Now
• Strong interpersonal skills
• Excellent written and verbal communicator
• Ms sql Server Backup/recovery
• Linux and windows operating system support
• Active Directory, Azure Active Directory setup and troubleshooting

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

Database Administrator

Responsibilities:

• Designed Network Security Groups (NSGs) to control inbound and outbound access to network interfaces (NICs), VMs and subnets.
• Setup Azure Virtual Appliances (VMs) to meet security requirements as software-based appliance functions (firewall, WAN optimization and intrusion detections).
• Create User Accounts in Azure Active Directory (AAD) and Active Directory (AD).
• Managed users account through AD and AAD.
• Troubleshoot Linux and Windows based VM related issues.
• Assist in analyzing and resolving network issues occurring in Azure Environment.
• Patch Virtual Machines and make sure the environment is up to date.
• Upgraded Oracle databases from 12C to 19C.
• Migrated QA and PRODUCTION databases to cloud (AWS)
• Experience troubleshooting automated backups and metric management
• Experience working with Performance Metrics and Plan Management
• Experience implementing TDE (Transparent Data Encryption) and DDM (Dynamic Data Masking) Features
• Working with Azure SQL Databases for Excel and Power BI Reporting Tools
• Usage of DBCC Utilities to maintain the consistency and integrity of each database in the server
• Performed server installation and configurations for SQL Server 2008 and SQL Server 2016
• Performed installation of SQL Server Service Packs.
• Upgraded databases from SQL Server 2008 to SQL Server 2016.
• Involved in capacity planning, sizing, and database growth projections.
• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.
• Setup backup and restoration jobs for development and QA environments
• Created transactional replication for the reporting applications.
• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.
• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
• Used SQL Server Profiler to monitor and record database activities of users and applications.
• Used DBCC commands to troubleshoot issues related to database consistency.
• Used Index tuning wizard to redesign and created the indexes for better performance.
• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
• Implemented trigger and stored procedures and enforced business rules via checks and constrain
• Experienced in creating RDS instances to serve data through servers for responding to requests.
• Configured S3 buckets with various life cycle policies to archive the infrequently accessed data to storage classes based on requirement.
• Performed Query Optimization to increase the performance by tuning SQL queries using Profiler and Execution Plans
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Provided support for 24x7 availability of database Services and ensure to meet the SLA
• Monitored all databases status including CPU, Memory, I/O, Space Management, Backup and Recovery using OEM, TOAD as well as customized scripts
• Developed Automated Backup jobs and DBCC scripts for databases and transaction logs
• Hands on experience in GGSCI utility for administering Extract, Pump, Replicate & reviewing the error logs as well as troubleshooting Abend scenarios.
• Configured Golden Gate UNI-DIRECTIONAL replication and extensively used error handling parameters Like HANDLECOLLISION
• Used DATAGUARD BROKER to manage, configure and Monitor dataguard Environment
• Efficient in using Dataguard Broker for all DataGuard tasks. Performed database switchover operation using dataguard broker.
• Configured disk groups with different redundancy levels, created failure groups, managing and tuning ASM parameters
• Created, configured, and setup RMAN catalog databases to managed backup metadata
• Work with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents
• Great experience in backup and recovery for data protection, media recovery and data corruption protection using RMAN
• Successful in installation and maintenance of Postgresql 9, 10 and 11
• Administer databases using PGADMIN
• 24/7 support with on call rotation in all prod, QA and dev environment.
• Proactive Performance monitoring and tuning using PGANALYSE, ANALYSE, EXPLAIN, AUTOVACUUM.
• Perform backups on regular basis by implementing a stable and effective backup strategy as per the SLA using PGBACKREST
• Management of schema objects, partitioning of tables & indexes.
• Perform physical and logical streaming replication.
• I have automate failover using EFM
• I have done upgrade from version 9.6 uptil 11.
• I have done point in time recovery using the PGBASEBACKUP.
• Migrate from Oracle to Postgresql using EDB MTK.
• Handled High volume Oracle production databases around 5TB size along with Physical standby databases.
• Setup and configure RMAN jobs for daily full backups, incremental backups and archive log backups which are schedule through Oracle Enterprise manager.
• Administering the RAC Environment through SRVCTL, CRSCTL, ocrconfig, CVU, ASMCMD utilities and applied patches in rolling fashion
• Worked on 12c RAC new builds and administering 12c RAC as well as managing ASM on RAC.
• Used RMAN to implement required recovery strategies and recover databases in instances of crashes and media/disk failures
• Perform Oracle database administration tasks include configuration management, backup/recovery, performance optimization, and space management
• Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
• Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, SQL TRACE.
• Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager.

Confidential

Oracle Database Administrator

Responsibilities:

• Troubleshoot RAC issues using Cluster ware and database logs
• Utilized Opatch to apply Cluster ware and RDBMS patches such as PSU and bug resolution one-off patches
• Upgraded all RAC and standalone databases from 10g to 11g, 11g to 12c to improve performance through increase features
• Created, configured, and setup RMAN catalog databases, used to register targeted databases
• Ensured zero downtime while creating physical standby databases using RMAN, working extensively with-it regarding troubleshooting, switchover, and switchback
• Installed and tested Goldengate 11 and 12 on DBFS and ACFS filesystems, applying latest patches as needed Improved target data replication through use of Goldengate integrated and coordinated replicate
• Maintained Data guard environment with TBs of log shipping daily, troubleshooting as necessary
• Successful in installation and maintenance of Postgresql 9, 10 and 11.
• Create Databases, schemas, users, tables
• Grant roles and privileges as requested.
• Administer databases using PGADMIN
• 24/7 support with on call rotation in all prod, QA and dev environment.
• Proactive Performance monitoring and tuning using PGANALYSE, ANALYSE, EXPLAIN, AUTOVACUUM.
• Performed failover and switchover with Data guard Broker and manually as needed
• Designed optimized database parameters and capacity designs for heavy loaded high end OLTP systems
• Utilized automated scripts/processes and reports to manage database capacity while collaborating with storage teams for ASM disks
• Installation and configuration of new databases instances
• Administered databases running on MSSQL SERVER, performed database tuning, and ensured data integrity and security of the databases as well as upgrading and patching of SQL SERVER
• Design, implement and maintain database security based on company policy
• Have experience in Implementing & Administering SQL Server High Availability and Disaster Recovery strategies like LOG SHIPPING AND DATABASE MIRRORING
• Have experience in Implementing & Administering SQL Server High Availability and Disaster Recovery strategies like LOG SHIPPING AND DATABASE MIRRORING
• Successfully migrated data from server to server with little downtime and productivity issues, including non-ASM to ASM
• Setup and implemented 2 node RAC on Linux in 10g and 11gR2 and configured Data guard physical and standby databases for high availability
• Implemented ASM and utilized it to manage disks and disk groups on RAC and standalone databases root cause analysis
• Upgraded databases from 11.2.0.3 to 12c for proof-of-concept on QA database
• Monitored tablespace free space, table space requirements, and indexes, ensuring high database performance
• Efficiently allocated system storage with planning for future storage requirements for new and existing databases
• Created proactive performance monitoring with automated jobs alerts through UNIX scripts
• Used stated requirements to size SGA, database buffers, shared SQL area, and log buffers.
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server in OLTP Environments.
• Implemented and successfully tested Database Mirroring in SQL Server.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Implemented and successfully tested Log Shipping in SQL Server. Implemented different types of Replication Models such as Transaction, Snapshot and Merge in SQL Server in OLTP Environments.
• Implemented and successfully tested Database Mirroring in SQL Server.
• Implemented and successfully tested Log Shipping in SQL Server.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• MSSQL SERVER backups and recovery.