SUMMARY:

• A professional with around 6 Years of experience as a Sr. PERFORMANCE DATABASE ADMINSTRATOR AT Confidential
• Resolving performance bottlenecks and providing recommendations on SQL Tuning, Application Tuning, OS and hardware, logical schema design, partitioning and index strategy query rewrite etc
• Configuring Oracle Data Guard (All versions). Performing the role transition as per requirement and troubleshooting Data guard/standby issues and providing DR Solutions
• Capacity Planning, Technology Evaluation and Database Scaling for large sized databases using methods recommend by Oracle such as RAT and many other
• Review software vendor security vulnerability announcements to determine impact to Confidential
• Handling database DR Testing / Standby / Replication / Data Guard/ GoldenGate/Streams.
• Knowledge and experience on RAC (Real Application Clusters) of database versions 9i, 10g and 11g. Setup, Standby creation,replication Upgrade, patch, recovery and conversion of single to multiple instances and vice versa.
• Extensive Knowledge and real time performance issue resolution, setup and configuration on Exadata environments.
• Knowledge and real time experience of Streams configuration, setup and management.
• Real time experience on working with OEM (Oracle Enterprise Manager)
• Knowledge and experience in reading and understanding explain plan, 10046,oradebug traces and providing suggestions.
• Worked on upgrade of databases among various versions.
• Knowledge on conversion of ASM to NON ASM and Non ASM to ASM(experience).
• Planning & executing large database migration projects including migration across the data - centers.
• Developed and automated critical package/RPMS for RDBMS and RAC installation procedure.
• Performance tuning using (AWR/ADRCI/Explain paln/Tkprof).
• Actively involved in Analysis, Estimation, Resource Planning, Budgeting, Design, Development, Testing, and Implementation of HP Vertica 7 for multi-tenant environment.
• Performance Tuning using Database Designer and Query Specific Projections.
• Big Data Solutions - Installing & configuring Vertica for a single 3/14 - node cluster, Projection design for query specific, and monitoring database in Multi-tenant environment, Administration with AdminTools. Expertise with Vertica DBD, tuple mover, move out, merge out tasks, partitions, and Resource pools Management in highly concurrent system and use workload analyzer for optimization.
• Database Migration specialist - Expertise in migrating data from any Relational DB (Oracle ) to HP Vertica
• Expertise in HP Vertica Health Checks and Advanced Performance Tuning with the best implementation practices for improved performance in High-Volume reporting and Real time Analytics.
• NoSQL DBS:Mongo
• Experience in deploying, managing and developing MongoDB clusters on Linux and Windows environment
• Database management for scheduling, tuning, taking backups using on premise MMS monitoring and backup solution.
• Point in time Backup and recovery in MongoDB using MMS. Data modeling for data from RDBMS to and MongoDB for optimal reads and writes.
• Responsible for managing MongoDB environment with high availability, performance and scalability perspectives.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, Stored outlines, Statistics.
• Worked on different storage engines in Mongo. Managing Mongo databases using MMS monitoring tool. Worked on balancer issues and chunk migration failures.
• Created users in mongo database and assigned specific roles to maintain security of Database.
• Performance tuning and stress-testing of Mongo database using Mongo utilities.
• Troubleshooting of different versions of Mongo database systems and cluster configurations to ensure high-availability in various crash scenarios and restoring roll backs to avoid loss of Data.
• Upgraded Mongo systems from 2.6 to 3.0.5. Also involved with creating shards, replica sets, monitoring, and projections for Mongo Systems.
• Explain plan of mongodb java scripts and suggested tuning of queries when and where it is required.
• Developed JavaScript's to monitor health of Mongo databases and perform ad-hoc backups using Mongodump/mongoexport and Mongorestore/mongoimport.
• Created a monitoring tool which have performance metrics, lag information and host information helpful in capacity planning, dB growth trending and form a graphical and generate alerts using java script .
• Written splunk search xml codes to depict cpu trends using charting mechanisms and various tools .
• Implemented reporting tools for performance monitoring such as top sql reports(via email),index fragmentation reports,health check,undo usage, global rac report for mission critical systems.
• Creation Of Pages Using APEX
• Developed complex PL/SQL procedures and packages as part of Transformation and data cleansing(Shell Scripting)
• Developed App Mongo console for capacity planning,reporting,trending and segregation of alerts/reports/environment details and analysis using splunk, Java Scripts and Python Scripts.
• Made Customized Wrapper Scripts such as AWR, Buffer Hit Ratio, Library hit ratio, Soft parse%, top 5 wait events, health check scripts etc using PL/SQL packages and functions.
• Created producers,consumer and zookeeper setup for oracle to kafka replication
• Deployed Oracle No sql databases

STRENGTHS:

Disciplined, Hard-working, Dedication towards work, Determined Patience, Good Listener, Positive attitude

AREAS/APPLICATIONS:

• Oracle Database (12c/11g/10g and 9i)
• Shell Scripting, Ansible Play Books, PL/SQL Programing, APEX page designing
• Developed Apps using Python and Java Script
• Expertise in No Sql Databases:
• Design, Architecture, Capacity planning, Support etc
• Design,Architecture, Capacity planning, Support etc
• Design,Architecture, Capacity planning, Support etc
• SPLUNK search codes, setup, graphical trending codes etc
• Kafka Deployment and Integration With Oracle Databases.
• Sql Deveolper,Eclipse,TOAD,Remedy,Espresso etc

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, California

Oracle Database Administrator

Responsibilities:

• Working in Confidential performance - DB engineering team and is responsible to provide support in case of performance issues during Confidential critical launch activity.
• Created Mongo Application using mmsrepoistory for trending,capacity planning, segregation of alerts/reports/environment details and analysis using java scripts and python scripts.
• Created producers,consumer and zookeeper setup for oracle to kafka replication
• Working and real knowledge of streams and Golden gate.
• Written SPLUNK search code for depicting and creating various SPLUNK Dashboard. Onboarding databases on SPLUNK
• Developing automation scripts which help in monitoring database
• Recommend database disaster recovery approaches for an application and work with infrastructure teams to implement the agreed upon approach.
• Proactively analyse storage management and capacity planning needs of database environments and make corrections before problems occur.
• Created pages and application via Oracle APEX (Application Express).
• Developed complex PL/SQL procedures, packages, triggers sql queries as a part of Data transformation and cleaning
• Vertica database Administration, automation of various health check and recommendation, backup, Installation, creation of databases, performance tuning aspects.
• Evaluate new dbms versions to determine the impact on the database environment and its effect on the overall technical architecture.
• Manage the database software lifecycle, including upgrades to maintain databases on supported versions and patches for security vulnerabilities.
• Expertise in Install/Upgrade/Patching/Cloning and Migration of database.
• Rollout 15 kits of X2/X3 Oracle Exadata installation and configuration in our environment.
• Setup Oracle 12c OEM install/configure/monitoring to all the oracle targets in our environment.
• Developing recovery and back up strategies during the course of data loss including RMAN.
• Expertise in applying various RDBMS, Cluster, ASM and Exadata CPU/PSU/One-off/BP9 patches..
• Setup/manage/troubleshooting of Oracle 11g/10g/9i RAC systems on various platforms & OS.
• Capacity Planning, Technology Evaluation and Database Scaling for large sized databases using methods recommend by Oracle such as RAT and many other

Confidential

Oracle Database Administrator

Responsibilities:

• Work according to the ITIL process (Incident, Problem, Change Management...etc).
• Goldengate implementation for oracle fallback between 9i to 10g. Day to day production activity, RAC upgradation new build and patching Quarterly releases.
• Grid Setup configuration and Management.
• Written SQL Queries, Triggers, PL /SQL Procedures to apply and maintain the Business Rules.
• Install and configure Real Application Cluster 11g R1, 11gR2.
• Worked on implementation of Physical standby on single instance and RAC
• Installation, cloning, Patch application.Setting up static and dynamic parameters.
• Extensive knowledge and working experience on Dataguard
• Working and real time experience on RAC clusters from 3 node to 7 nodes
• Scheduling backup activities on UNIX, through cron and AUTOSYS. These Backup were on Disk as well as on tapes using tools like SQL-Back Track
• Taking and analysis of reports such as AWR, awrexpt, ADDM etc
• Creating ADRCI and RDA reports/packages.
• Application of CPU and PSU PATCHES for the various database versions
• Application of listener patches on RAC and Standalone databases .
• Characterset utlity(csscan)
• Using segment space adviser to reorganize the segments (DBMA SPACE.ASA recommendations)
• Managing backup strategies like cold, hot and logical Proficient in RMAN.
• Maintain and enhance the existing physical database model for various releases of the application.
• Performed refreshes at database, schema, table and index levels
• Performed space management, defragmentation of the database, extent management and db block management.
• Real time experience on features such as flashback, Explain Plan, Autotrace, Tkprof etc
• Configuring Database links.
• Rebuilt indexes on monthly basis for tables which have lot of DML activity using database table monitoring.
• Refreshed schemas from one environment to another using exp/imp utility.
• Managed Temporary tablespace and Rollback segments and monitored their growth
• Optimization of init.ora files to best utilize the new system resources.
• Proficiency in use of various ticketing and beeper systems such as remedy, autosys, SRS and SMS.
• Handling ON-CALL‘s Weekdays and Weekends

Confidential

Oracle Database Administrator

Responsibilities:

• Multi-master replication using Materialized views
• Backup administration and scheduling ( Using RMAN Backups )
• Installation, cloning, Patch application.
• Upgrade environment from 9i to 10g and from 10g to 11g
• Configuring and maintaining databases using OEM Grid Control.
• Restore/Refresh the data between various databases.
• Creating cronjob Shell Scripts for Proactive monitoring of application & databases.
• Managing remedy ticket queues, Troubleshooting issues, handling escalations.
• Performing Backup and Recovery through RMAN Backups.
• Troubleshooting basic database issues in RAC Environment.
• Restoring the backups which were taken from PROD to UAT, DEV, CNTNG databases.
• Identifying and fixing various ORA errors and raising SR to the Oracle support team when required.
• Maintenance Activities like Backup and executing scripts.
• Database maintenance activities like startup, shutdown, DBhealth checkup etc
• Creation of tablespaces, addition of datafiles and all tasks related to tablespace maintenance operations.
• Implemented Confidential for databases.
• Created Materialized View for improving online performance.
• Involved in implementing the CR (Change Request) from the developers and will make sure the CR will be updated in the Production database along with the release change