Pulla Nuthan Goud

Experience

• 

  IGT

  Oct 2012 - Nov 2014

  Database Adminstrator

  • Database Up-gradation from 10g (10.2.0.2.0) to 10g (10.2.0.5.0).• Coordinating 24 * 7 Production support for mission critical databases• Handling On-call duty and attending client and handling escalations• Role in representing best shore team to the client• Administrating database and Dataguard standby.• Handling application performance issues• Installing 11g,10g oracle software and creating databases• Database upgrades• Database backup and restore (, RMAN)• Database backups using BCV and ERM technologies.• Data Validation / Exception monitoring / Clients request details.• Health checking of databases and security policy assurance• Handling block corruptions• Handling promotions and data fixes• Handling data refreshes (PROD / UAT / DEV)• Applying patches• Worked on 3 Node RAC environment Show less

• 

  Virtusa

  Dec 2014 - Aug 2015

  Consultant

  • Creation and Maintenance of Oracle Databases as per the requirement.• Managing the Physical & Logical structure of the Databases. • Creation and Managing of ASM in oracle 10g & 11g.• Creating and maintaining standby databases.• Creating and maintaining active data guard and snapshot standby database.• Creating and maintaining Oracle Grid Control.• Using datapump to export/import Tables, Schemas and Databases.• Tuning Sql Query depends upon request from seniors and developer• Export / Import of Tables, Schemas and Database• Create, configure, clone and utilize RMAN• Generated and analyzed AWR, ASH and ADDM reports and monitored statistics for performance• Analyze the index if necessary rebuild or Coalesce index to rectify segment fragmentation.• Monitoring the table fragmentation and rectify by online redefinition of Tables. • Gathering Schema level statistics and Table level statistics using DBMS_STATS Procedure in non business hours. .• User managed and server managed backup (Hot and Cold backups).• Partitioning table to improve performance.• Extensive experience in backup and recovery strategies.• Creation and Managing of Oracle Steams (down streams) • Recovering lost objects by using Export backup. • Scheduling/ automating tasks using DBMS_JOBS/ Crontab.• Monitor the locks and releases the locked objects. • Creating materialized views and database links.• Created and managing Partition tables. • Using Flashback recovery to recover dropped tables.• Check Alert Log errors. • Creation of Schema with Quota maintenance and roles and privileges. • Creating Profiles and setting Password management. • Used SQL-Loader utility to load data into oracle database from external file.• Auditing table access by users.• Worked on BCV and ERM (EMC) backup Technologies Show less

• 

  Infosys

  Sept 2015 - Jul 2020

  • Extensive knowledge of VPC architecture, EC2 formation, IAM management, S3, CloudWatch, Elastic IPs and managing securing groups on AWS.• Creating S3 buckets and managing policies for S3 buckets and Utilized S3 bucket for storage and backup on AWS.• Managing Amazon web services (AWS) infrastructure with automation• Proficient in implementing and maintaining Oracle Engineered systems (ODA)• Oracle Fusion Middleware upgrades, patches, scheduler maintenance, and installing of maintenance releases.• WebLogic installation, Configuration, Clustering, administration and user management• Migrated cross platform Oracle EBS database. Configured Application in production environment.• Migrated the Standalone and RAC huge database’s using TTS method. Refreshed the database using RMAN from production to lower environments.• Configured and managing the commvault tool. Recovered and restored the database’s using this tool.Implemented robust security configurations for Kafka clusters, ensuring secure operations through Kerberos authentication.Proficient in querying data from Cassandra for diverse purposes, including searching, grouping, and sorting.Configured Jenkins to establish efficient CI/CD pipelines, encompassing automated builds, promotion across environments, code analysis, and versioning for multiple projects.Leveraged Kubernetes and Docker to create optimized runtime environments for the CI/CD system, facilitating streamlined building, testing, and deployment processes.Designed and implemented data pipelines as per specific business requirements, efficiently scheduling them using Oozie Coordinators.Demonstrated expertise in Linux/Unix environments, adeptly writing Shell Scripts to automate tasks and streamline operations.Hands-on experience in machine learning, big data processing, data visualization, R and S development, Linux administration, SQL, and version control using GIT/GitHub. Show less

  • Senior Consultant

    Sept 2016 - Jul 2020

  • Consultant

    Sept 2015 - Sept 2016
• 

  Oracle

  Jul 2020 - Sept 2021

  Senior Database Engineer

  Working as a part of Fusion Apps Environment Operations Team at Oracle in supporting Development and QA of Oracle next generation Application product - Fusion Applications. Install, Configure, Patch and Support Fusion Applications, Databases and Fusion Middleware stacks on different releases most of the times much ahead of the products released to Customers.Involved in provisioning the fusion environments on OCI. Patching the fusion application in OCI.Worked on automation script using shell script to do pre and post work for provisioning the fusion application.Working experience on Oracle cloud backup modulesInstallation of 19c,18c,12c,11g RAC / Standalone databases and on various PlatformsConfiguring of Physical and logical Standby databases, Active Data guard RAC and Standalone environments.Expertise in Configuring 13c/12c/11g Oracle Enterprise Manager and grid agents for the targetsExpertise in Administrating EBS applications R12/11iExpertise upgrading EBS environments to RPC5Implementation and Upgrade and databases from 11.2.0.4 to 12.1.0.2Applying quarterly PSU/CPU Patches to the Databases. Show less

• 

  Empower

  Oct 2021 - Feb 2023

  Lead Data engineer

  Developed ETL flows and leveraged MapReduce techniques to process data from AWS S3, facilitating seamless data transfer to DynamoDB and Redshift.Proficient in importing and exporting data between HDFS and RDBMS systems such as Teradata (Sales Data Warehouse) and SQL-Server, as well as non-relational systems like HBase, using efficient column mappings to maintain data uniformity.An accomplished IT professional with progressive experience involving the Planning, implementation and maintenance of Infrastructure solutions and operations in an enterprise environment.An experienced oracle/postgresql database administrator performed various tasks like migration (EBS to ODA) , installation, administration, configuration, upgrades, patching backup and recovery, performance monitoring, performance tuning, cloning, space management, database security and production support.Cloud Database Migration Specialist with a proven track record of seamlessly migrating complex databases to cloud platforms, minimizing downtime and maximizing efficiency.Experienced AWS/GCP Data Engineer with expertise in designing, building and maintaining scalable data pipelines for efficient data processing and analysis.Exadata Database Machine administration and configurationHandled run and maintenance and BAU of very huge size and many in number of Oracle, Postgres and Mysql databasesSuccessfully executed data migration projects, transferring data from Oracle to Teradata databases with accuracy and precision.Proficient in developing Automation Regression Scripts using Python to validate ETL processes across multiple databases, including Oracle, SQL Server, Hive, and MongoDB.Extensive experience with Hadoop tools such as Hive, Pig, and Sqoop, enabling efficient data warehousing and extraction from these tools onto clusters.Skilled in utilizing the Oozie Workflow Engine for running workflow jobs, incorporating Hadoop Map/Reduce and Pig actions.Demonstrated ability to design Informatica mappi Show less

• 

  Synechron

  Feb 2023 - now

  Associate Specialist

  Data Engineer, Data Analyst, Data Integrator, and Big Data Specialist, demonstrating expertise in Data Modeling (Logical and Physical) as well as implementing Business Applications using the Oracle Relational Database Management System (RDBMS).Extensive hands-on experience in a wide range of technologies such as Hadoop, MapReduce, Hive, Spark (PySpark), Sqoop, Airflow, Autosys, Snowflake, Teradata, Oracle, RDMS, Python, Scala, ETL, and Data Visualization.Proven track record of delivering successful data and analytics solutions using cloud data lakes, with a focus on AWS, Azure, and similar Cloud platforms.Proficient in utilizing various AWS services including Amazon EC2, Amazon S3, Amazon RDS, VPC, IAM, Amazon Elastic Load Balancing, Auto Scaling, CloudFront, CloudWatch, SNS, SES, SQS, and others.A notable achievement in developing PySpark Streaming applications capable of processing both static and streaming data from diverse sources.Adept at adapting to different industries and demonstrating flexibility in utilizing cutting-edge technologies in the field of data engineering and analytics.Proficient in SQL script analysis and designing PySpark solutions for efficient data processing.Leveraged Spark Streaming to receive real-time data from Apache, storing it in HDFS using Python, and seamlessly integrating with NoSQL databases such as HBase and Cassandra.Developed Spark/Scala and Python projects in the Hadoop/Hive environment, utilizing regular expressions (regex) to handle large-scale data processing on both Linux and Windows platforms.Implemented data transformations using AWS Glue dynamic frames in conjunction with PySpark to ensure streamlined data processing.Utilized Scala components to design and implement credit line policies, applying them to Spark data frames for efficient credit evaluation.Designed and executed real-time stream processing applications using Spark, Kafka, Scala, and Hive, enabling Show less