OBJECTIVE

• I am an Oracle Certified Database Administrator. I am willing to be a part of the challenging team which strives for the better growth of the organization and which explores my potential and provides me with the opportunity to enhance my talent with an intention to be an asset of the company.

SUMMARY

• 12+ years of Experience in IT industry as Senior Oracle database Administrator (Database Creation, Backup methodologies, User management and Space management).
• 5+ years of experience in MySQL database and Sql server database Administrator.
• 3 years of experience in DB2 database Admin, Teradata database Admin and PL/SQL developer.
• 6 months experience in Azure cloud solution architect level (Azure VM, Storage account, Dashboard creation,Azure Managed SQL)
• Good Knowledge on MongoDB database architecture, Installation, Administration and replication set.
• Good Knowledge on AWS Cloud solution architect level (AWS IAM, EC2, Route 53, VPC, RDS, Cloud watch, SQS, SNS, SWF, CloudFormation and LAMDA function)
• Expertise in Oracle 10g/11g/12c Installation, Administration, Upgrade, Monitoring, Database Backup and recovery, RAC and Datagaurd
• Expertise in MySQL community edition 5.X, MySQL enterprise edition 7.X Installation, Administration, Migration from community to enterprise edition, Database Backup and recovery, Master slave configuration.
• Good Knowledge on ITIL process like Incident, Request and Change management, problem management process & compliance process.
• Supported 24/7 production and other critical environments.
• Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer services.
• Database performance tuning, Troubleshooting database issues, proficient in SQL and PL/SQL knowledge

TECHNICAL SKILLS

• Windows /95/98/ /XP
• HP Unix, AIX, Sun Solaris, Linux
• Oracle9i/10g/11g,12c SQL,PL/SQL
• MySQL 5.6, 5.7
• Teradata V2R6
• MS SQL Server 2000,2005,2012,2014
• DB2 V9.5
• Unix Shell Scripting
• C,C++
• Azure cloud portal
• Toad
• Putty
• SQL Server Management Studio
• Teradata Administrator
• BTEQ
• Nagios
• BMC Remedy
• Foglight
• Quest chef
• JIRA
• Bamboo

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential

Responsibilities:

• Creating and maintaining all DBs required for development, testing, staging and production usage
• Supported Oracle version 8i,9i,10g,11g and 12c.
• Database upgrade from 10.2.0.4 to 11g and from Oracle 9i to 11g.
• Expertise in installation and configuration of Oracle and large databases on Unix Operating System.
• Critical patch apply in all version of oracle DB’s
• Database maintenance by taking regular backup of databases On daily basis. Backup involve cold backup and rman backup using rman utility and logical backup using expdp/impdp utility.
• Experience on Oracle enterprise manager OEM .
• Schema refresh from production to development or test environment.
• Supporting performance tuning in Database side as well as capacity planning also performed in DB side and done partition table purging in production and gained around 650GB
• Experience in resolving some of the common DBA issues which includes FRA usage issues, oracle ASM disk group full issues
• Involved in construction of Disaster Recovery (DR) for the required production databases using Data Guard (Physical Standby).
• Familiar with level skills in troubleshooting performance issues using Automated Workload Repository (AWR) and Active Session History (ASH) for optimum performance of database.
• Installed and configured of GoldenGate on 11g database for data replication.
• Involved in database troubleshooting and maintenance activities and solve some GoldenGate issues such like abended, lagging, long transaction issues.
• Resolved the issues in conflicts between the target and source database in GoldenGate
• Experience in planning, installing, configuring, and administering multiple Oracle RAC in Linux and Non RAC databases in Linux/UNIX.
• Add or Remove Node from RAC.
• Migrated Non - ASM Single Instance to ASM RAC Instance.
• Experience on oracle ASM .
• Add candidate disk to oracle ASM data, recover disk groups and Resizing disk groups .
• Implemented optimal space utilization in table space by avoiding fragmentation.
• Used partitions to improve the query performance and manageability.
• Responsible for continuous database monitoring and reorganization for ensuring optimum performance.
• Expert in SRVCTL and CRSCTL to manager RAC environment activities.
• Monitored top wait events /top SQLs/ top sessions using OEM.

Mysql DBA

Confidential

Responsibilities:

• Experience in Mysql version from Mysql 4.x/5.x/5.5/5.5.33 and Mysql enterprise edition 5.6 and 5.7
• Carried out the migration activity from community edition 5.X to Enterprise Edition 5.7
• Configured Mysql enterprise monitor to monitor the Mysql enterprise databases and community edition databases performance and other related DB activities to monitor.
• Configured MEB backup for the enterprise databases.
• Configured replication set up for the critical databases.
• Configured SSL certificate to accept the more secure connection in the database.
• Carried out many deployment activities in production and non-production environments.
• Monitor database usage and growth trends to forecast future storage needs as Capacity planning measure.
• Maintaining, Creating users and giving permission to them as per user requirement.
• Backup and recovery of Mysql databases using Mysqldump utility
• Administer the Mysql replication on Master-Slave setup.
• Performance tuning and optimization of Mysql Databases .
• Managing security of Mysql database with grants and privileges
• Resolving some of the common database connectivity issues of Mysql Databases from application server

SQL SERVER DBA

Confidential

Responsibilities:

• Refreshing UAT and Test Databases from Production server databases
• Performed production server database changes like changing database objects, granting
• Permissions across database objects, running the required development scripts, changing the configuration settings of SQL server etc. by following the change management process
• Perform planned fail-over of the SQL server instance from one node to another to balance the load between two nodes
• Experience in fixing some of the common database server issues like database in suspect mode, database corruption problems.
• Troubleshooting performance issues of SQL server using SQL server activity monitor, task manager, running the scripts.
• Configured Maintenance plan for weekly full backup, daily differential backup and an hourly transaction log backup
• Managing database security using database logins, users and database and server level roles

Teradata DBA

Confidential

Responsibilities:

• Creating and managing the User account with appropriate security.
• Creating/maintaining Roles and Profiles and assigning them to users.
• Refreshed the Data by using the ARC utilities use of Data dictionary tables and views to manage the system.
• Validating and monitoring the backups.
• Space management
• Backup and restoring the table using Teradata manager.
• Performing collect statistics on table as well as column.
• Running the application scripts in the production as per the proper approval and testing done in the non-production environment.