Sql Server Oracle Cloud
Resume:
SRIPATHI RAO ERAVELLY
********.********@*****.***
Mobile: 602-***-****
Professional Summary
Having 15 years of total experience in Database, Application, and Cloud technologies.
Manage PostgreSQL databases through multiple product lifecycle environments, from development to mission-critical production systems.
Worked on NoSQL Database admin (Cassandra & MongoDB) and other relational databases (MySQL,MSSQL).
Experience with database migrations to AWS, Azure, and Oracle Cloud. Writing optimized SQL queries for integration with other applications
Designing database tables and dictionaries
Developing scripts, procedures and triggers for application development
Knowledge and experience of cloud technology such as Microsoft Azure (preferred) or Amazon AWS and SQL Server Database IaaS, DBaaS.
Maintaining data quality and backups and overseeing database security
Knowledge in Linux for both day to day tasks and shell scripting.
Worked on SQL, PostgresSQL with troubleshooting and performance tuning.
Experience working with Windows server, including Active Directory
Troubleshoot database instance level performance issues.
Optimize Sql queries by rewriting and adding hints.
Expertise with MySql Replication and Performance issues.
Based on RFP planned Design and Architecture, Upgraded, Installed and configured of large databases.
Setup replication between Mysql/MariaDB Database, Explore methods to improve replication.
Worked on Goldengate and Exadata.
Suggest additional applications/resources that may reduce the overall cost to the project.
Discussed with Development teams and came up with best sql profiles for better performance.
Reactive and proactive alert monitoring to reduce the count of Incidents.
Handling team management and identifying suitable resource to handle a specific task.
Ability to work independently and learn new concepts quickly. Open to work new modules and new technologies.
Skills Profile
Technical
Operating System
Windows NT/XX, Linux, OEL, Sun Solaris
Environment
Oracle E-business suite 11i, R12.1.X, R12.2.X,FMW
Database
ORACLE 9i, 10g, 11g RAC,12c, 19c,Exadata, OCI Cloud.Azure, MYSQL, PostgreSql, Cassandra, Mongo DB.
Internet Tools
OBIEE, Service now, OEM, APEX, Kubernetes
Other
Export/Import, Goldengate, RMAN,Dataguard, SSO, RAC, PLSQL
Professional Experience:
Verizon Sep 2023 – Till date
SOW Resource
Telecommunication
Description: I have contributed to a Telecommunication company by providing architectural solutions and defining implementation strategies tailored to the organization's challenges. My responsibilities have included working on installations and upgrades, configuring and implementing a diverse range of databases such as Oracle, SQL Server, Cassandra, PostgreSQL, and Oracle Cloud, Azure and AWS migration.
Roles & Responsibilities:
Expertise in optimizing and performance tuning of PostgreSQL, including drill-down analysis.
Provided architectural solutions, and define implementation strategies in line with the challenges of an organization
Participated in design, development and deployment projects implementing Azure Cloud solutions and services.
Used pg_upgrade and logical standby for upgrading Database.
Implemented data masking and enabled row level security for one of our clients.
Migrated sql server to Azure portal and maintained, worked on post migration issues.
Installed and upgraded the database server and other application tools.
Performed backup and recovery tasks using logical and physical backup.
Developed HA/DR solutions for SQL Server, and Oracle Databases in a hybrid environment.
Installed and configured new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
Proactively monitor application servers and databases by configuring server monitoring tools such as SolarWinds.
Perform Upgrades/System Administration for web servers, application hosts, all Microsoft SQL servers (including Epicor), SQL Server Report Services (SSRS), SQL Server Integration Services (SSIS), and cloud environments.
Planned physical requirements of the database’s system, like disk space, network requirements and memory.
Modified the database structure using data given by app developers where ever required.
Setting up SQL Server mirroring and AlwaysOn Availability Groups.
Create users’ profiles, and ensures system security by allocating user permissions appropriately.
Maintaining data quality and backups and overseeing database security
MySql Replication and Performance issues.
Linux day to day tasks and implemented few shell scripting for automating regular tasks.
Worked on PostgresSQL with troubleshooting and performance tuning.
Troubleshoot database instance level performance issues.
Optimize Sql queries by rewriting and adding hints.
Based on RFP planned Design and Architecture, Upgraded, Installed and configured of large databases.
Setup replication between Mysql/MariaDB Database, Explore methods to improve replication.
Worked on Goldengate and Exadata.
Discussed with business teams and come up with suitable plans for better performance.
Oracle cloud migrations Hands-on experience in configuring and supporting replication in PostgreSQL.
Performed OCI Administrator tasks, including infrastructure monitoring, creation of user roles and accounts, and managing policies.
Maintained the fundamental setup of the Self-Service Portal and virtualized storage, network, and compute resources available for further configuration and usage.
Worked with different storage services like Block volume, Archive storage, and object storage.
Migration of databases from On-prem to OCI and Azure using ZDM and other migration techniques.
Hosted applications on Cloud using Compute Engine, App Engine, Cloud SQL, Kubernetes Engine, and Cloud Storage.
Worked with highly available and scalable on-prem Oracle/MySQL/DB2 databases, AWS RDS MySQL/PostgreSQL/Aurora MySQL/Aurora PostgreSQL Database on AWS.
Network configuration and security rules management for AWS and Oracle Cloud.
Managed ASM and ASM disk groups using DBCA.
Worked on Ansible and Terraform for automating routine tasks.
Maintained configuration, compliance, and audit program to effectively manage AWS accounts and resources.
Migrated on-premises Windows servers (ranging from Windows Server 2012 R2 to Server 2019) and some Linux servers (Ubuntu and CentOS) to the cloud (AWS).
Created database objects like Tables, Tablespaces, Rollback segments, Multiplexing control files, Data files, Redo log files, Partition tables, Views, Indexes, Synonyms, Materialized views. Audited, implemented, scripts/tools to help roll out and manage Oracle in a global distributed Environment.
Participated in design, development, and deployment projects implementing Azure Cloud solutions and services.
Worked on Fast Start Failover setup for our Data Guard and tested the functionality.
Wrote shell scripts and scheduled them as cron jobs for monitoring the Database health.
Ability to follow strict procedures and be disciplined in installation, documentation, event handling, and change control.
Basic understanding of Project Management Principles.
Implemented bidirectional GoldenGate for replication of our data.
Worked on Oracle cloud migrations involving multiple technologies like Oracle, Azure, and GCP.
Configured SSO and OID and documented steps as per the Post refresh requirements.
Installed and upgraded APEX on all instances as per the project requirement in both standalone and as a REST service WebLogic deployment.
Environment: PostgreSQL, Cassandra, Oracle, RedhatLinux, OEL, Sun Solaris.
Capgemini(Subaru) Mar 2016 – Aug 2023
Senior Consultant
Automobile
Description: I have contributed to a motor vehicle manufacturing company by providing architectural solutions and defining implementation strategies tailored to the organization's challenges. My responsibilities have included working on Apex installations and upgrades, configuring and implementing a diverse range of databases such as Oracle, SQL Server, Cassandra, PostgreSQL, and Oracle Cloud, Azure and AWS migration. Additionally, I have experience in configuring GoldenGate for real-time syncing, as well as working with RAC and ASM with PDBs.
Roles & Responsibilities:
Expertise in optimizing and performance tuning of PostgreSQL, including drill-down analysis.
Provided architectural solutions, and define implementation strategies in line with the challenges of an organization
Participated in design, development and deployment projects implementing Azure Cloud solutions and services.
Migrated oracle databases to postgres using ora2pg tool and worked with few other scenarios.
Migrated sql server to Azure portal and maintained, worked on post migration issues.
Installed and upgraded the database server and other application tools.
Developed HA/DR solutions for SQL Server, and Oracle Databases in a hybrid environment.
Installed and configured new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
Proactively monitor application servers and databases by configuring server monitoring tools such as SolarWinds.
Perform Upgrades/System Administration for web servers, application hosts, all Microsoft SQL servers (including Epicor), SQL Server Report Services (SSRS), SQL Server Integration Services (SSIS), and cloud environments.
Planned physical requirements of the database’s system, like disk space, network requirements and memory.
Modified the database structure using data given by app developers where ever required.
Setting up SQL Server mirroring and AlwaysOn Availability Groups.
Create users’ profiles, and ensures system security by allocating user permissions appropriately.
Maintaining data quality and backups and overseeing database security
MySql Replication and Performance issues.
Linux day to day tasks and implemented few shell scripting for automatings regular tasks.
Worked on PostgresSQL with troubleshooting and performance tuning.
Troubleshoot database instance level performance issues.
Optimize Sql queries by rewriting and adding hints.
Based on RFP planned Design and Architecture, Upgraded, Installed and configured of large databases.
Setup replication between Mysql/MariaDB Database, Explore methods to improve replication.
Having knowledge on Phython scripting.
Worked on Goldengate and Exadata.
Discussed with business teams and come up with suitable plans for better performance.
Oracle cloud migrations Hands-on experience in configuring and supporting replication in PostgreSQL.
Performed OCI Administrator tasks, including infrastructure monitoring, creation of user roles and accounts, and managing policies.
Maintained the fundamental setup of the Self-Service Portal and virtualized storage, network, and compute resources available for further configuration and usage.
Worked with different storage services like Block volume, Archive storage, and object storage.
Migration of databases from On-prem to OCI and Azure using ZDM and other migration techniques.
Hosted applications on Cloud using Compute Engine, App Engine, Cloud SQL, Kubernetes Engine, and Cloud Storage.
Worked with highly available and scalable on-prem Oracle/MySQL/DB2 databases, AWS RDS MySQL/PostgreSQL/Aurora MySQL/Aurora PostgreSQL Database on AWS.
Network configuration and security rules management for AWS and Oracle Cloud.
Managed ASM and ASM disk groups using DBCA.
Maintained configuration, compliance, and audit program to effectively manage AWS accounts and resources.
Migrated on-premises Windows servers (ranging from Windows Server 2012 R2 to Server 2019) and some Linux servers (Ubuntu and CentOS) to the cloud (AWS).
Created database objects like Tables, Tablespaces, Rollback segments, Multiplexing control files, Data files, Redo log files, Partition tables, Views, Indexes, Synonyms, Materialized views. Audited, implemented, scripts/tools to help roll out and manage Oracle in a global distributed Environment.
Participated in design, development, and deployment projects implementing Azure Cloud solutions and services.
Worked on Fast Start Failover setup for our Data Guard and tested the functionality.
Wrote shell scripts and scheduled them as cron jobs for monitoring the Database health.
Ability to follow strict procedures and be disciplined in installation, documentation, event handling, and change control.
Basic understanding of Project Management Principles.
Implemented bidirectional GoldenGate for replication of our data.
Worked on Oracle cloud migrations involving multiple technologies like Oracle, Azure, and GCP.
Configured SSO and OID and documented steps as per the Post refresh requirements.
Installed and upgraded APEX on all instances as per the project requirement in both standalone and as a REST service WebLogic deployment.
Environment: Oracle Application R12.2, Oracle Cloud, Azure, PostgreSQL, FMW/SOA Admin, APEX, OBIEE, WebLogic, 19c DB Support, RedhatLinux, OEL, Sun Solaris.
Oracle Oct 2012 to Mar 2016
Technical Analyst
Construction Pharma and Oil resource
Description: Worked on database upgrade from 12c to 19c along with EBS applications from 12.1 to 12.2.6, Configured SSO and documented Cloning procedure with most of the steps automated, Implemented SQL tuning as a regular habit and provided solutions that reduced load on the server and performed other troubleshooting.
Roles & Responsibilities:
Customization Updates and working on Code promotions and deploying to the target instance
Automated cloning using shell script which reduced overall manual effort with alerts to trigger the progress.
Importing & exporting the database schemas.
Maintaining Archive logs and their spaces for routine administration alert and trace monitoring.
Granting & Revoking the roles & Privileges to users
Scheduling and Monitoring of RMAN backups.
Setting jobs and events using Enterprise manager(OEM) Console, enrolled users and maintained security by
Controlling and monitoring user access to the Database.
Installed patchsets and upgraded Oracle (RDBMS).
Administering and maintaining Production Apps R12 instances, 24X7 Database Support and maintenance.
Involved in DB Upgrade from 10g to 11g and Apps Upgrade from 11.5.10.2 to R12 (12.0.6)
Refreshing the database schemas and Databases.
Responsible for online/Offline backups of database and managed recovering database using RMAN.
Maintained Oracle 11gR2 RAC high availability with ASM file system with Cluster Stat and Grid infrastructure on Linux environments.
Applying CPU / PSU patches.
Performed Informatica, OBIEE Cloning.
Knowledge on Weblogic.
Troubleshooting forms server, Apache server issues
Troubleshooting concurrent manager issues.
Knowledge in Essbase admin activities.
Knowledge in Informatica& OBIEE admin activities.
Had exposure to RAC environment and R12 instances.
Knowledge in SSO/OID
Used ticketing systems like Managenow
Environment: Oracle Application R12.2, Oracle Cloud, Azure, FMW/SOA Admin, APEX, OBIEE, WebLogic, 19c DB Support, RedhatLinux, OEL, Sun Solaris.
IBM July 2008 – Oct 2012
System Engineer
HRMS, Manufacturing, Financials
Description: Migrated Database from Solaris to Linux platform while upgrading the database to the latest version once done configured dataguard and tested switchover, worked on multiple point and version upgrades for both database and applications.
Roles & Responsibilities:
Upgrade Oracle Applications from 12.1.3 to 12.2.6.
Knowledge in adop patching, maintenance activities.
Worked on Dataguard Install and configure and tested switchover for one of our DR test activity.
Cloning Oracle application/Database using ADCLONE and Rapid clone to create new TEST/PROD Instance.
Up-grading Oracle Application to latest patch level using Maintenance Patch (e.g.12.2.1 -> 12.2.6).
Up-grading application Database 11.2.0.2 to 11.2.0.4
Installing 3rd party tools (Vertex Upgrade, Noetix Upgrade).
Knowledge in Informatica& OBIEE admin activities.
Knowledge in STAT and Kintana Tools
Knowledge in TOMCAT, OC4J Deployments.
Knowledge in CPU Patching.
Analyzing various SQL profiles and implementing the best suited profile for the optimum utilization of the resources.
Implemented shell scripts for various day to day routines to reduce manual effort.
Maintained Oracle 11gR2 RAC high availability with ASM file system with Cluster Stat and Grid infrastructure on Linux environments.
Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 11g RAC.
Migrating Databases to Oracle Exadata Database Machine.
Setup resources using IORM and DBRM for different databases.
Done performance tuning of the upgrade process to reduce the down time.
Had configured Kintana scripts to various instances.
Environment: Oracle Application R12.2, FMW/SOA Admin, RAC, Dataguard, OBIEE, WebLogic, 19c DB Support, RedhatLinux, OEL, Sun Solaris.
Higher Education Qualification:
Bachelor of technology In Electronics from JNT University, Hyderabad,2008.
Contact this candidate