Responsible for the planning, designing, implementing and Operating the Technology driven solutions. Senior Database Administrator providing support to Oracle,MS-SQL,MySQL and PostresSQL databases .Configuring and Monitoring Goldengate Replication.Confiuring and Monitoring Oracle enterprise manager.Preparing SOP/WBS for database critical changes .Gathering requirements for new projects.Troubleshooting Database and application performance issues.Creating service improvement documents.Performed upgrade, analysis and testing of the test and production database.Worked with development and operations staff in resolving problems quickly and efficiently.

Responsible for the planning, designing, implementing and Operating the Technology driven solutions for Sony Electronics . Senior Database Administrator providing support to Oracle,MS-SQL and MySQL databases .Migrating On-premises Databases to cloud platforms.Managing AWS services i.e RDS,DMS,EC2,Cloudwatch,SNS,EFS,EBS,ECS,VPC, IAM.Preparing SOP/WBS for database critical changes .Gathering requirements for new projects.Troubleshooting Database and application performance issues.Creating service improvement documents.Performed upgrade, analysis and testing of the test and production database.Worked with development and operations staff in resolving problems quickly and efficiently.

Senior Database Administrator providing 24/7 support to around 10K database all over globe . Resolving tickets and incidents through service tools.Administartion databases through OEM.Troubleshooting application performance issues.Tuning queries using sql profiles and baselines.Troubleshooting RAC issues –Performance ,Node eviction Creating the databases (Asm and Non Asm) depend on client requirement.Creating service improvement documents.Performed upgrade, analysis and testing of the test and production database.Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.Creating users and assigning roles and privileges.Monitoring the scheduled backups, and referring the backups in case of failures.Resizing table space, system shut down and restart, unlocking database table locks, Re-org table spaces, adding additional table space and file space as needed.Cloning from production database to test database by using Duplicate, Hot Clone and COLD cloning methods.Automated several routine tasks – Automating cold/hot backup, Monitoring scripts – table space, alerts, alert log errors, validating backup and alerting DBAs in case of backup failures, Purging trace files, blocking session.Analyze and document system storage requirements.Worked with development and operations staff in resolving problems quickly and efficiently.Interacting with Online Support team for handling Oracle SRs.

Managing 24x7 Oracle databases.Automated many daily schedule tasks.Troubleshooting RAC issues –Performance ,Node eviction Creating the databases (Asm and Non Asm) depend on client requirement.Performed upgrade, analysis and testing of the test and production database.Configuring new build databases in 12c OEM and adding corrective actions.Troubleshooting application performance issues.Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.Creating users and assigning roles and privileges.Monitoring the scheduled backups, and referring the backups in case of failures.Resizing table space, system shut down and restart, unlocking database table locks, Re-org table spaces, adding additional table space and file space as needed.Cloning from production database to test database by using Duplicate, Hot Clone and COLD cloning methods.Automated several routine tasks – Automating cold/hot backup, Monitoring scripts – table space, alerts, alert log errors, validating backup and alerting DBAs in case of backup failures, Purging trace files, blocking session.Monitoring tickets and incidents through Remedy tools.Analyze and document system storage requirements.Worked with development and operations staff in resolving problems quickly and efficiently.Interacting with Online Support team for handling Oracle SRs.

Managing 24x7 Oracle databases.Database daily checklist.Creating database instances for development, testing and production.Installing CPU patches.Managing user accounts.Monitoring the scheduled backups, and referring the backups in case of failures.Cloning from production database to test database by using Hot Clone and COLD cloning methods.Compiling invalid objects.Gathered Database Instance Statistics.Switch over and switch back to primary databases.Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.Interacting with Online Support team for handling Oracle SRs.Troubleshooting the Oracle applications problems.Generating database Daily reports.Dealing with clients and attending technical meetings to implement changes.