Sateesh Reddy

Experience

• 

  Tata Consultancy Services

  Jan 2006 - Jul 2016

  Project & Role: British Telecommunications Infrastructure DBA, Oracle DBA Lead•Lead project team of Oracle DBAs and responsible for managing a team of 34 support personnel, their operational duties covering over 360 application databases. •Responsible for implementation, installation, upgrades, support of Oracle databases on 9i/10g/11g/12c and automation of monitoring across databases to alert on issues proactively. •End to end database support during major incidents and providing root cause analysis.•Reports to senior management and operational support metrics for KPI management. •Database migrations using cross platform incremental backups and administering DB issues. •Managing OEM 11g Grid control and evaluation of new technologies though POCs. •Oracle database builds, software installations, deployments, database migrations, clustering, version upgrades and patching, data replication, backup and recovery, disaster recovery, OEM grid monitoring and performance tuning of Oracle databases.•Responsible for performance tuning, failover setup (Data Guard) and testing of databases. Show less Project & Role: BT Billing and Payments Database Support, Oracle DBA •Worked with Oracle databases, installed, configured, and supported various versions of Oracle systems on Linux, Windows, and Unix operating systems. •Standard DBA responsibilities, maintenance, and performance tuning of production/test DBs.•Performed environment builds, Oracle upgrades and tuning activities as table re-organizations, indexes rebuild, memory tuning, database initialization parameter tuning. •FRA setup, backup monitoring and recovery solutions implemented and builds with Oracle 11g Active Cloning (CPIB) and RMAN, data guard performed. Golden Gate replication solutions implemented and was involved with physical and logical standby database builds for applications. •Responsible for capacity planning and space analysis of databases. •Oracle cluster ware setup, RAC, ASM installations and Oracle database upgrades. •Oracle PSU patches applied to databases proactively and standard monitoring of databases. Show less

  • Senior Oracle DBA, Lead & Performance Consultant

    Oct 2012 - Jul 2016

  • Oracle DBA

    Jan 2006 - Sept 2012
• 

  AIS (Applied Information Sciences)

  Aug 2016 - now

  Lead Data DevOps DBA

  Project: Resilinc, Data DevOps Engineer •Database migration support for on-prem PostgreSQL to Azure PostgreSQL flexible server•Implement Azure DMS data pipelines for replication of data.•POC and product evaluation of Azure PostgreSQL flexible server, DMS•Migration planning and data migration implementation.•Performance tuning, Backup, HA, and DR configuration of Azure PostgreSQL flexible server.•Data validation and automation of task, other migration activities with Linux shell scripting.Project: WindCreek Hospitality, Data Engineer•Oracle DB migration from OCI to Azure SQL Server and Snowflake Cloud. •Implementation of Fivetran replication for migration from OCI, SQL Server to Snowflake.•Data ingestion with Azure SQL Server CDC to Snowflake with Azure Data Factory, ADLS.•Snowpipe data ingestion and implementation of DBT transformation for ETL.•SQL and PL/SQL code migration.•Support data requirements for testing of PowerBI reports migrated to Snowflake.Project: Quest Diagnostics, Data Engineer•Database migration support for migrating data from on-premises Oracle to Azure PostgreSQL. •Implemented Oracle Golden Gate replication for migrating data from on-premises to Azure.•ORA2PG conversion and modification of code to convert Oracle SQL/PLSQL to PostgreSQL.•Data pipelines maintenance, testing data, and cutover of applications from Oracle to PostgreSQL.Project: GEICO, Senior Data Engineer Oracle DBA•Responsible for cloud implementations, migrating on-prem DBs to Oracle OCI, and upgrading databases.•Support for Microsoft SQL Server, Cosmos and PostgreSQL databases on Azure.•DBA L2/L3 operational support of Oracle databases. •Consulting, builds, DB software installations, deployments, migrations, clustering, upgrades and patching, replication, backup and recovery, DR, monitoring, and performance tuning.•Collaborate with Server admins, Storage, Middleware, Application users, and other project teams for DBs hosted on Linux, Windows. Show less

• 

  PWin.ai

  May 2024 - now

  Data DevOps Engineer