Home

Revanth kumar - Oracle Sql Developer

[email protected]

Location: Texas City, Texas, USA

Relocation:

Visa:

REVANTH KUMAR CONTACT:9798032236 Experience in Oracle, Ibm db2, No Sql db, Aix, Sun Solaris and Linux technologies progressively challenging experience in the field of Information Technology, Banking, Entertainment, Finance and Insurance. Major Demonstrated Strengths Installation, upgrade, migration, patching and cloning of Oracle Databases on a broad set of platforms like Linux, Aix, Hp-ux and Solaris Experienced in high availability solutions like RAC, Data Guard, ASM, ACFS, Golden Gate platforms like Linux, Aix, HP-UX and Solaris Managing and planning of backup and recovery using RMAN, Data Pump and Export & Import Experienced in database logical design, physical design & data modeling Designed and Developed scripts which compares the unique tables between oracle and Hana database Designed and Developed scripts for sox compliance Experience in Sap brtools to take backup, recover and restore using RMAN. Experience in handling, configuration and administration of databases like MySQL and NoSQL databases like MongoDB and Cassandra. Experience in working with databases like Mongodb, MySQL ,Cassandra , Aerospike, Postgre and Couchbase Strong MySQL and MongoDB administration skills in Unix, Linux and Aix Self-motivated, quick learner, goal-oriented, resourceful and innovative team player Managing Mysql database on Aws Rds services Excellent team spirit and leadership qualities with good communication and interpersonal skills Certification: IBM DB2 9 Family Fundamentals -730 IBM DB2 9.7 dba for Linux, Unix and Windows 541 Oracle Certified professional (OCA) ORACLE11g No Sql databases certified ( Mongodb , Cassandra, Aerospike and Couchbase) Technical Skill Set: Languages: C/C++, JAVA, SQL,PL/SQL,shell,perl ,Python scripting Operating Systems: Unix , HP-UX, Solaris, Red Hat Linux, AIX Databases: Mainly Oracle with hands on experience on managing Ibm db2 , Mongo, MySQL, Cassandra ,PostgreSql & Couchbase databases Special Software: Toad for Oracle, Putty, OEM, Performance Monitors, Space Analysis, ASM, Oracle Data pump, SQL loader, Splunk, Gem fire, Httpwatch, Rumba(Mainframe),Golden Gate Scripting: UNIX Shell Scripting (Korn/Bourne) Education: Bachelor of Technology in Electrical & Electronics Engineering from Jawaharlal Nehru Technological University Dish Senior database engineer Denver, CO (March 21 Present) Responsible for migrating oracle databases from physical server to virtual ESX host Worked on a project migrating data from oracle tables to mongo collections Worked on IOT project to build a platform on aws environment for a new product Worked on operations day to day activities and got a chance to work on tools like zabbix, dynatrace ,theia and custom tools Managing Mysql database on Aws RDS services Provision and Support databases on Aws RDS cloud environment PAYPAL Senior Database Admin San Jose, CA (May 16 March 21) Supporting Payments and Risk, which enables upwards of $25,000 in transaction per second at its peak We are a reactive group, think of us as fire fighters, we fight against any issue which may occur on our applications, APIs to Data Base Layer and causes our end users a bad experience and not just that, we strive to create processes, practices and tools to forecast and quickly mitigate any that may happen to the site. We strive to provide best customer experience and brand value through our core infrastructure availability and data security. My current role provides me a 360-degree insight of PayPal Tech Platform as a well-oiled machine and its relationship with its different components and how they work together in a synchronous way to keep our business up and running. In this endeavor of mine, I get an opportunity to work with many cross functional teams like Operations/pd/Release engineering/sre/Change Management/Problem Management along with several core infra teams and vendors team vendors ORACLE Worked on 11G to 12c migration, having the downtime limit of 30 secs Performing TTS on 20 TB table on production database to move the table from Traditional table to Partition table using GG Performing Partitioning maintenance on live production tables Setting up the Oem from the scratch to perform patching, deploy oracle rac and databases Setting up the GG on downstream replication Constantly working on performance issues Shading of the database for 250M users to multiple db s Mongo Worked on analyzing and visualizing the data along with data modeling. Worked in managing large shared MongoDB cluster Worked in trouble shooting /performance tuning. Worked in diagnosing the problems and resolving issue across various servers. Worked in MongoDB installation, patching, troubleshooting, performance, tracking/tuning, back - up and recovery in dynamic environments. Worked in managing life cycle of MongoDB including sizing, automation, monitoring and tuning. Worked with complex data environments. Worked on working with MongoDB Ops Manager, Cloud Manager and Atlas Manager Worked in integrating databases like MongoDB with webpages like HTML, PHP and CSS to update, insert, delete and retrieve data with simple ad-hoc queries MySQL Installation and setup of MySQL 5.1 Enterprise and Community servers on Linux Configuration of primary and disaster recovery sites for application and database servers. Assisted in configuring, monitoring, upgrading and maintaining application database related infrastructure. Managed Application Database system using MySQL and resolved all performance issues. Executed database security standards along with the database maintenance Creating procedures and functions for reporting and ETL purpose Database optimization by tuning queries for various modules in the project for better performance Created validation rules for performing data validations based on the user profile and their record type Created and customized reports and dashboards Working with various MySQL tools like MySQL workbench, MySQL Administrator, MySQL GUI tools, MySQL performance monitor, MySQL migration toolkit PostgreSQL Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases Monitoring databases to optimize database performance and diagnosing any issues Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases Implement data models, database designs, data access, table maintenance and code changes together with our development team Experience in code migration, database change management through various stages of development life cycle Implement and monitor replication for high availability and disaster recovery scenarios. Review new database schema changes Monitor and manage database indexes for optimal performance Automate the configuration management of database and Big Data systems Performing schema management, database sizing, maintaining privileges. Daily log analysis using pgbadger tool and query tuning. Monitoring the bloat repot on every table and performing maintenance with minimal downtime. Performing minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications Professional Experience: EBAY Senior Database Admin San Jose, CA (May 15 MAR 16) Responsible for day to day duties and worked on split project between PAYPAL and EBAY. Migrated databases to respective severs and setup the Data guard, Golden Gate Split involved migration of 800 oracle databases. It starts from the pre-assessment of new servers build, install oracle product, generating remote authentication keys between central servers. Installing golden gate and switch over EBAY to PAYPAL. Responsibilities: Provide 24X7 support for all the production and development databases Monitoring alerts and tickets and working on it Installing oracle on the new production Paypal server Cloning the database from the Standby and then converting it to production Worked and followed up with application team for cutover of the database Monitoring stability of the application on the new production server Upgrading the production databases to the newer version(11204/12C) Installing and setup of the golden gate Worked on ssl setup on jdbc thin client configuration SSL setup encryption and server authentication Worked on network data encryption Smo backup capturing failures Worked on Dr failover tests Worked on Golden Gate relocation Worked on upgrading Sap databases from 11202 to 11204 and 11202 to 12c Worked on schema level migration Learned and Worked on Sql server and Sap Hana databases Worked on Sail point implementation project Worked on R server and installing the R packages Worked on integrating the R server to Sap hana Worked on RAC database implementation Under the Employer TCS APPLE, Sunnyvale, CA Senior Database Admin (June 13 May15) The responsibility to execute these assignments end-to-end and has placed people with various skill-sets on multiple roles including Project management, production support, development, and testing. The smooth and proper functioning of databases. The project requires expert Database Administration professional with knowledge of the Database administration and performance monitoring. These skills are required to support business applications at Apple. As this project will ask for intensive customer interaction to understand their business requirement and then implement the systems to best suit their business Responsibilities: Provided 24X7 support for all the production and development databases. Implement Dd Boost backup in all the production and development databases. Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance. Restoration and Recovery of databases at the times of occurrence of critical failures. Writing Sql query programs for new business requirement. Creating Documents and checklist for upgrades from 11g to 12c. Monitoring the health of the database post upgrade . Creating new users for database & defining their access. Programming basic shell scripts for database operations. Create new database structures, installing and implementing the fixes. Applying patches for databases. Writing Oracle Stored Procedures for automating monthly archival of a partitioned table, monthly purge of History table, Daily statistics collecting routine. Managing backup activities for database. Performance Monitoring and sql Tuning for Oracle Database. Implementing change requests and solving trouble tickets escalated by Application/Development users. Provide support to maintain databases for application development groups. Enabled auditing in all the production systems as per Sox standards. Developed scripts to delete the data in audit trail. Created User accounts, Roles/Profiles and granting required access permissions and privileges to the database based on the Sox Standards. Performed upgrades from Oracle10g to 11gr2 and 11g to 12c Responsible in configuring and backing up database using rman, Hot backups, Cold backups and Logical backups. Worked with Data Pump to take the logical backups of databases. Experienced in performing Point-in-Time Recovery. Documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference. Implemented Oracle database backup & recovery solutions using Rman and manual methods. Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference. State Farm, Bloomington, IL Senior Database Admin (Jan 12 May 13) The current Distributed Unix server environment at State Farm consists of multiple proprietary Unix operating systems (Os) including: Ibm Aix, Hp-Ux, and Solaris. State Farm has chosen to standardize on the Red Hat Enterprise Linux Operating System (Rhel). A roadmap for the Unix to Linux migration has been completed and now State Farm intends to implement this Road map over a period of 2-1/2 years . The business drivers for this strategy are to reduce costs and infrastructure complexity. Maintaining multiple platforms and operating systems is inefficient and costly to support and maintain. Migrating to a single platform, Linux, can reduce many of the areas of cost and complexity by mandating a standardized hardware and operating system platform. Responsibilities: Migration Oracle Db from Hp Unix, Aix to Linux servers Provide detailed planning for each of the Unix migration variants Create Roadmap for the deliverables Performed Software migration (application and technology/tools) Data conversion and migration Virtualization Script Updates Oracle software installation on the Target Linux server. Applying version patch for oracle database. Applying bug patches. Create new database structures, installing and implementing the fixes. Provide support to databases for application during application checkout in the Linux server. Troubleshooting Oracle issues with Application Stored Procedures, Connectivity problems, Space issues, Access issues Perform testing and validation of the migrated system, application, and code against all functional and technical requirements RMAN for cloning. Non-ASM to Asm file migration using man. Implementation of Physical standby & applying logs. State Farm, Bloomington, IL Senior Database Admin (Apr 11 Jan 12) Responsibilities: Performed cross platform migration for Ibm Db2 Luw from Aix to Linux and Hp-ux to Linux. Provide detailed planning for each of the Unix migration variants. Using various data movement utilities. Develop and enhance Unix shell scripts on Aix and Linux. Played major role in performing the assessment and suggesting pre-requisites for migration of Dpf databases. Prepared scripts for creating the objects from the source to target databases. Resolving issues that are reported by any of the support teams. Perform testing and validation of the migrated system, application, and code against all functional and technical requirements. Working on performance enhancement Techniques. Keywords: cprogramm cplusplus quality analyst user experience database active directory rlang information technology hewlett packard procedural language California Colorado Illinois