Rudram

Oracle Database Administrator

203-***-****

ad40ui@r.postjobfree.com

SUMMARY

● Seasoned Oracle Database Administrator (DBA) with over 9 years of expertise in managing mission-critical, high-performance environments.

● Demonstrated expertise in architecting, designing, implementing, and maintaining complex Oracle database solutions across diverse industries.

● Proven track record in leading database projects, from conception to successful deployment, ensuring alignment with organizational goals and best practices.

● Advanced skills in Oracle Database performance tuning and optimization, utilizing advanced features such as Oracle Exadata, In-Memory Database, and Partitioning to achieve unparalleled system efficiency.

● Extensive experience in designing and implementing highly available and scalable database architectures using Oracle Real Application Clusters (RAC) and Oracle Grid Infrastructure.

● Proficient in Oracle Data Guard configuration and management for disaster recovery, ensuring data protection and business continuity in the event of failures or disasters.

● Having in-depth knowledge in oracle Architecture. Installation, setup and configuration of Oracle 11g, 12c and 19c on Linux platform.

● Expertise in advanced database security implementations, including Oracle Transparent Data Encryption (TDE), Virtual Private Database (VPD), and Database Vault, to safeguard sensitive data.

● Skilled in Oracle Multitenant architecture, enabling efficient consolidation, resource sharing, and management of multiple pluggable databases within a single container database.

● Hands-on experience with Oracle Enterprise Manager (OEM) for centralized database monitoring, administration, and automation, enhancing operational efficiency and reducing downtime.

● Proficient in Oracle Cloud Infrastructure (OCI) deployment and management, including database migration, backup, and recovery in cloud environments.

● Strong command of SQL and PL/SQL programming for database automation, customization, and advanced data manipulation.

● Expertise in advanced database features such as Advanced Compression, Automatic Storage Management (ASM), and Flashback Technology for data management and recovery.

● Strong knowledge on Exadata Hardware, Software, Networking and Monitoring Architectures

● Strong knowledge on Exadata Storage Server unique features like Smart Scan,Storage Indexes,

● Smart Flash Cache, Hybrid Columnar Compression and IORM Plans.

● Monitoring the Infiniband Switches/ports, PDUs, Cisco Switches, Cell Servers, DB Nodes and Instances via OEM.

● Remote monitoring and administration using Integrated Lights Out Manager (ILOM) using both GUI and command line prompt. Generating ILOM snapshots for Oracle Support.

● As DMA Provided Exadata upgrades and data center migration support as needed.

● As DMA Assisted with ZFS/ ZDLRA configuration, integration, patching and support as specified with Exadata.

● Experienced in implementing database partitioning strategies for improved query performance, data manageability, and scalability.

● Skilled in database capacity planning, resource allocation, and workload management to ensure optimal performance and scalability.

● Proven ability to troubleshoot complex database issues, analyze performance bottlenecks, and implement corrective actions to optimize database performance.

● Excellent communication and interpersonal skills, with a collaborative approach to working within cross-functional teams and stakeholders to achieve project objectives.

● Strong commitment to continuous learning and professional development, staying updated with the latest Oracle database technologies, best practices, and industry trends.

● Proficient in documenting database architectures, configurations, procedures, and guidelines to maintain comprehensive documentation and ensure knowledge sharing. TECHNICAL SKILLS

Languages SQL, Java, C++, C and PL/SQL, COBOL, CICS, JCL Solaris Databases Oracle Versions 11gR1&R2/12c/19c DB Technologies Exadata,RAC, Data Guard, ASM & Flashback, OEDA tool,OECA tool,DCLI DBA Tools OEM, VNcC Viewer, WinSCP, Toad, Putty, Service Now/Remedy Tuning Tools TKPROF, AWR, ADDM, ASH

Backup &amp Recovery : EXP/IMP, EXPDP/IMPDP, RMAN, hot-cold Databases: Oracle 9i/10g/11i, MySQL, DB2, TOAD, SQL Developer,DB2,Mongo DB.

Operating Systems: Linux, OEL6/7, Windows, IBM-AIX, Sun, Unix, Windows 9x/2000/XP Version Control Systems: ClearCase (CC), Visual SourceSafe (VSS), CVS, Git, Subversion, Bitbucket

Methodology/Technology Agile development (Sprints), waterfall development methodology. Scripting Languages Shell scripting

PROFESSIONAL EXPERIENCE

Walmart, Jersey City, NJ May 2022- Till Date

Oracle DBA

Description: Walmart is a global retail giant known for its extensive network of stores offering a wide range of products. Established in 1962 by Sam Walton, it has become one of the largest retailers globally. Walmart focuses on providing low prices, convenience, and a seamless shopping experience, both in-store and online.

Responsibilities:

● To support, enhance & maintain supply chain engineering team in the area of Master

● Data Management involving Product Information Management (PIM) & Product Data

● Exchange (PDX). Oracle EBS 12.2.9 and 19C back end.

● Enhanced materialized view to add more data columns for business evaluations.

● Enhanced XML publisher Item Attribute Verification Report to add ICC, Creation Date, EU Preference Origin attributes.

● Enhanced Nifi integrations to log the transactions in Oracle DB, to call Rest Services to publish PIM data.

● More Than Two Years of Oracle DBA Proficiency in Overseeing Databases Larger Than 30 Terabytes

● Responsible for managing and supporting all Production, Development and Staging instances of Oracle

● Version 11g,12c and 19c.

● Proficient in offering support for OLTP and Data Warehouse ecosystems.

● Proficiency in working with EDB Postgres Advanced Server.

● Familiarity with backup and recovery tools like Rubrik.

● Configured and Installed, Involved using AWS services such as EC2, Data-Pipeline, S3, RDS and EMR

● Architecting new DBA solutions in AWS.

● Installed the application on AWS EC2 instances and Configured the storage on S3 buckets.

● Worked on migrating Oracle databases to AWS RDS using utility AWS Database Migration Service(DMS).

● Familiarity with using MongoDB Atlas in practical scenarios.

● Design & manage PostgreSQL database schemas.

● Experience designing database structures, indexes, views, partitioning.

● Install and configured OEM 12c agents different operating systems.

● Good experience in shell scripting language

● Possesses advanced proficiency in Active Data Guard, RMAN, RAC, and GDS.

● Monitoring and Managing RAC database performance issue using AWR,ASH,ADDR, and OSWatcher

● Upgraded Oracle databases from 12.1.0.2 to 19.0.0.0

● Performed Instantiations using exp/imp and expdp/impdp at table level.

● Performing daily incremental backups, weekly backups using RMAN.

● Configured physical standby database (DATAGUARD) and tested for failover and switchover.

● Good experience in Performance Tuning.

● Monitored all services and cluster using SRVCTL & CRSCTL utilities.

● Installed & Configured Oracle Golden Gate v11.2, v12.1 and v19c in a Standalone Environment Upgrading.

● Have Good experience on DML replication.

● Analyzed trail files using logdump utility.

● Resolving GoldenGate sync issues and ensuring proper replication.

● End-to-End support for Exadata Platinum Patching. Scheduling Patching,Firewall open for port 22,verifying patches downloaded, monitoring patching although the process, verifying versions after patching. DR patching. Leftover Oracle Homes patching, etc. Environment:RHEL, Sun OS, Foreign Exchange Application, Oracle 11g/12c/19c, Goldengate, DG Broker, EXADATA

Evoke technologies, India July 2020 – March 2022

Oracle DBA

Description: Evoke Technologies is an India-based IT services company that specializes in providing software development, consulting, and outsourcing solutions to global clients. With a focus on cutting-edge technologies, Evoke offers services in areas such as cloud computing, data analytics, artificial intelligence, and enterprise mobility. The company is known for its innovative approach to solving complex business challenges and delivering high-quality, cost-effective solutions. Evoke Technologies has a strong reputation for client satisfaction and has successfully completed numerous projects across various industries, including healthcare, finance, and retail. Through its skilled workforce and commitment to excellence, Evoke continues to be a trusted partner for organizations seeking digital transformation. Responsibilities:

● Background in the banking sector.

● Extensive Oracle DBA Background with 100 TB+ Database Support for Over 2 Years

● Background in providing assistance for both OLTP and Data Warehouse settings.

● Exceptionally skilled in Active Data Guard, RMAN, RAC, and GDS.

● Familiarity with EDB Postgres Advanced Server experience.

● Implementing of logical and physical backups.

● Monitor and manage database indexes for enhancing the performance.

● Proficient in the use of Data Domain and Rubrik for backup and recovery.

● Proficiency in working with MongoDB Atlas.

● Competency in utilizing scripting languages, including BASH, KSH, and PowerShell.

● Applied PSU patches on standalone and RAC environments in rolling fashion

● Ensuring BCP SYNC with the production post Password Remediation.

● Good experience in shell scripting language

● Good in handling and debugging the scripts during remediation.

● Good Experience of authoring code in SQL, PL/SQL on Unix/Linux

● Administering the Clusterware and RAC Database through CRSCTL and SRVCTL.

● Worked on DataGuard configuration and DR Monitoring, gap resolutions.

● Worked on ASM databases (Checked free space on Disk groups, communication of database

● instances with disk groups)

Environment: RHEL, Sun OS, Foreign Exchange Application, Oracle 11g/12c/19c, Goldengate, DG Broker, EXADATA

Cyient Insights, India Nov 2018- June 2020

Oracle DBA

Descriptions: Cyient Insights is a platform within Cyient, a global engineering and technology solutions company, focused on providing thought leadership and industry expertise. It offers a variety of resources.

Responsibilities:

● Expertise in the financial services industry.

● Proven 3+ Years of Oracle DBA Proficiency in Managing Databases Exceeding 250+ TB

● Familiarity with supporting both OLTP and Data Warehouse environments.

● Demonstrates a high level of expertise in Active Data Guard, RMAN, RAC, and GDS.

● Skillset includes experience using EDB Postgres Advanced Server.

● Hands-on experience with backup and recovery solutions, including Data Domain and Rubrik.

● Proficient in the use of scripting languages like BASH, KSH, and PowerShell.

● Monitoring & resolving of the service calls, incident calls.

● Refresh the database, Schema using export/import, EXPDP/IMPDP from production to development

● database for further testing purposes.

● Managed and administered physical standby databases.

● Taking Backup of Database using Logical, Physical Backup and RMAN backup.

● Scheduling and creating scripts for archive log gap and RMAN backups.

● Resolving archive log gap between Primary and Standby databases.

● Applied PSU patch on Oracle and Grid homes.

● Rescheduling backups as and when required.

Environment: RHEL-5.x,6.x, Sun-Solaris, Oracle 11g R1&R2, RAC 11g/12c, Srvctl, Crsctl, ocr config, ASM,Dataguard, AWR, ADDM, ASH, RMAN, Data pump, OPatch, Materialized views, Putty,EXADATA

Incessant Technologies, India Aug 2014- Nov 2018

Oracle DBA

Descriptions: Incessant Technologies, formerly known as an NIIT Technologies company, was a leader in digital integration and the agile delivery of enterprise iBPM solutions. They offered expertise in areas like CRM, case management, and analytics, working with clients in various sectors like finance, insurance, and manufacturing. Responsibilities:

● Expertise in the insurance field/ healthcare platforms, particularly within the healthcare sector.

● Extensive Oracle DBA Career Spanning 2+ Years, Focusing on Databases Greater Than 25 TB

● Experienced in installing different versions of Oracle on Linux

● Monitoring and troubleshooting space and backup and scheduled job-related errors from OEM.

● Database RMAN restorations to Test or UAT environments from Production.

● Creating table spaces & monitoring their growth & Resize or add more data files to database or

● tablespaces for space related issues.

● Created scripts and scheduled backups in cron for RMAN database backups.

● User creation and assigning necessary Roles, Privileges and quota as per the request.

● Database cloning/exp/imp to set up identical databases in the production and development environments.

Environment: RHEL 5.x, 6.x, Sun-Solaris, and Oracle 11g R1 & R2, with expertise in RAC 11g/12c. Key tools and technologies used are Srvctl, Crsctl, ocr config, ASM, Dataguard, AWR, ADDM, ASH, RMAN, Data pump, OPatch, and Putty. Additionally, specialized hardware like EXADATA is utilized for optimized performance.

Contact this candidate