SUMMARY

• Having around 11 years of IT experience with telecommunications and banking industry. Skilled in Oracle/RAC Database, WebLogic, JBoss, Mongo, Cassandra, Postgres and Couch base databases, Kafka, Zookeeper, ANSIBLE, AWS, OpenStack, Linux/Unix System Administration and Deploying NetCracker products in Client production servers. Knowledge in Problem solving, Troubleshooting and Performance tuning skills, Excellent communication, and interpersonal skills.
• Proficient in Oracle 9i to 19c /RAC/ASM/Data guard Databases with experience within very large - scale data warehouse environment and mission critical large OLTP systems involving installation, migration, refresh, configuration, upgrades, backup and recovery of databases along with database design and management.
• Good knowledge of Oracle Architecture, RAC architecture, Data guard, database design.
• Worked on Oracle to Postgres migration using ORA2PG tool.
• Automated RMAN Backups, Data pump, cloning, space management, database security, cloning, migration. Proficient in supporting databases running on AIX, O.E.L, R.H.E.L, Sun-Solaris and windows platforms.
• Worked on Oracle upgradation from lower higher versions.
• Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms.
• Configure high availability systems like Data Guard and RAC environments.
• Worked on AWS for creating oracle databases instances.
• Worked on S3 buckets and Cloud trails to monitor logs and backups.
• Expert in Deploying NetCracker products RBM, CM, AMM, DOC1 and Vault.
• Experience in Mongo, Cassandra, Postgres and Couch base databases.
• Experience in Kafka, Spark, Zookeeper and Ignite.
• Experience in WebLogic and Jboss installation, administration and clustering.
• Experience in Docker and Kubernetes support and administration.
• Experience in Deployed and maintained physical, active standby databases in Data Guard.
• Worked on configuring and troubleshooting Active Mediation Manager (AMM)
• Configuring cron jobs & task scheduler to automate the routine tasks
• Experience in Cassandra, Kafka, Spark, Zookeeper clusters.
• Proficient experience in migrating huge volumes of oracle databases within quoted downtime and minimal errors.
• Taking schedules backups using RMAN, export and Data pump utilities
• Performed Database Cloning from Production to Test environment
• Check Alert Log errors and make necessary actions to rectify them
• Oracle Server & Client Installation on Linux/AIX/Solaris environments in Various version (9i, 10g & 11g,12c)
• Experience in managing FRA and Disk groups
• Configured Physical standby databases from Primary database
• Experience Shell scripting and basic Ansible scripting.
• Experience Open Stack and AWS cloud environments for snapshot creation and restorations od oracle databases.
• Experience in Linux administration, Docker and Kubernetes.

PROFESSIONAL EXPERIENCE

Confidential

Lead technology Engineer

Responsibilities:

• Performed Database Cloning from Production to Test environment
• Worked on Oracle upgradation from lower higher versions.
• Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms.
• Configure high availability systems like Data Guard and RAC environments.
• Expert in Deploying NetCracker products RBM, CM, AMM, DOC1 and Vault.
• Hands on experience in installation and up gradation of Oracle databases.
• Experience in Application cloning activities and sync with databases accordingly as per the requirement which related to RBM product.
• Experience in Cassandra Clustering, Kafka, Spark, Zookeeper and Ignite.
• Experience in WebLogic and Jboss installation, administration and clustering.
• Deployed and maintained physical, active standby databases in Data Guard.
• Highly Analytical, resourceful and determined thinker with superior problem-solving skills. Capable of creative and unconventional solutions.
• Worked on AWS for creating oracle databases instances.
• Experience in Open stack Cloud for instances and Volume snapshot restorations.
• Experience in Shell scripting, Ansible scripting, understanding the ansible flow and debugging skills in ansible scripts.

Confidential

Lead technology Engineer

Responsibilities:

• Hands on experience in installation, configuration and up gradation of databases.
• Taking schedules backups using RMAN, export and Data pump utilities
• Performed Database Cloning from Production to Test environment
• Experience in ASM and Datagurad
• Experience in creating service requests to Oracle if any bugs and issues
• Experience with Cloning of Databases from RAC to standalone
• Experience with Cloning of Databases from standalone to RAC
• Check Alert Log errors and make necessary actions to rectify them
• Oracle Server & Client Installation on Linux/AIX/Solaris environments in Various version (9i, 10g & 11g,12c)
• Experience in Extract, Replicate and Data pump processes using golden gate.
• Working on 2, 3 and 5-node RAC configured databases
• Experience in managing FRA and Disk groups
• Configured Physical standby databases from Primary database
• Gathering stats in Table/Schema and Database level
• Worked on ORACLE AGENT installation
• Database cloning activities as per client request in regularly

Confidential

Database Administrator

Responsibilities:

• Worked on up gradation of database from 9i to 11g and 10g to 11g
• Creation Of Database through DBCA and Manually
• Taking schedules backups using RMAN, export and Data pump utilities
• Performed Database Cloning from Production to Test environment
• Performed Query Tuning by using Explain Plan, TK prof and Stats pack reports.
• Configured Physical standby databases from Primary database
• Worked on Database reorganization
• Worked on Cold, Hot and RMAN backups
• Worked on cron jobs for daily and weekly jobs
• Troubleshooting performance issues
• Experience in RAC
• Experience in ASM and Datagurad
• Experience in creating service requests to Oracle if any bugs and issues
• Experience with Cloning of Databases from RAC to standalone
• Experience with Cloning of Databases from standalone to RAC
• Experience in Cascade standby databases
• Experience in Troubleshooting ORA errors
• Gathering stats in Table level, Schema level and Database level
• Tables, Schemas and Database level refresh for Development & testing

Confidential

Database Administrator

Responsibilities:

• Experience in User management, table space management and allocation of quota to users as per requirement
• Database clone using cold/hot/RMAN backups and Logical backups.
• Oracle 9i, 10g and 11g Database cloning for developing and testing purpose.
• Working with traditional and data pump utility for the selective data export & Import on Production/Dev/Val/Test on client/online team request basis.
• Proactively checking and fixing the archive gaps on physical primary and standby Databases.
• Written the Shell Scripts in coordination with system admin for monitoring the alter logs, disk spaces at O/ S level, table spaces at DB level, to check the availability of database and listeners, and automated jobs through cronjobs.
• Query tuning using Explain plan and tk proof utilities and for this we need to interact with development team for functionality of the batch process and tuned accordingly
• Data refreshes from 9i to 10g,10g to 11g and 9i to 11g in Table level, Schema level, Full database
• Implemented Flashback technology on Oracle 11g on test environment.
• Experience in User management, table space management and allocation of quota to users as per requirement
• Database clone using cold/hot/RMAN backups and Logical backups.
• Oracle 9i, 10g and 11g Database cloning for developing and testing purpose.
• Working with traditional and data pump utility for the selective data export & Import on Production/Dev/Val/Test on client/online team request basis.
• Query tuning using Explain plan and tk prof utilities and for this we need to interact with development team for functionality of the batch process and tuned accordingly
• Data refreshes from 9i to 10g,10g to 11g and 9i to 11g in Table level, Schema level, Full database