SUMMARY

• Total 7 years of experience as IT Professional experience as Database Administrator.
• Specialization in configuring and maintaining very large Databases and Data Warehouse environments, Backup/Recovery using RMAN and high availability procedures like Hot Standby Databases.
• Sharp eye for finding synergy between multiple broad objectives
• Experience in Linux, Solaris, Aix os and windows env as well
• Fully conversant with all aspects of systems analysis, design and SDLC
• Skilled communicator, thorough in explaining complex IT knowledge to subordinates, and management
• Keen problem solving, troubleshooting, and communication skills.
• Excellent knowledge and understanding of Database High Availability features for instance Data guard (physical standby), Replication, DB Mirroring, Log Shipping, Master/Slave, Always On etc.
• Modify Database structures as required by developers due to business and application requirement.
• Experience in implementing and supporting high availability and disaster recovery solutions for mission - critical 24*4*365
• Creation of new scripts to automate the procedures to generate statistics on Database Space Management, Performance and for Proactive Monitoring.
• Extensively used DBA Utilities, RMAN, SQL*Loader, and Expdp/Impdp, Performance Monitoring and Backup & Recovery
• Acute knowledge of hardware, software, networking and applications.
• Adept in Performance Tuning, Query Optimization and improving performance of an application using Explain Plan and Tkprof
• Document database procedures and responsible for organizing for installer to perform upgrade oracle database and application from Oracle 10g to11g,11gR2 to 12cR1/R2 & 19c in place upgradation
• Having good hands of experience about Sql Server 2005, 2008r2, 2012,2014,2016, PostgreSql(9,10) and setup HA Transactional Replication etc.

TECHNICAL SKILLS

Languages: SQL,, T-SQL, java, C, Visual Basic 6.0.

Hardware: Sun F-15K/E-10K, IBM p660/680/690, HP-9000, IBM PCs.

Software: Oracle ( 11.2.0.2.0 , 11.1.0.7.5 , 10.x, 9.x, 8.1.x, 8.x), 9i, SQL Server 7.0/2000,2008 r2

Technologies: Client Server, Web - enabled.

Operating Systems: Sun-Solaris 2.7/2.8/2.9, AIX 4.33/5.x, HP-UX 9.x/10.x/11.x, Linux 6.x/7.x/8.x, Win NT, Win 2000/2003 Server.

Tools: RMAN, Statspack, text pad, winscp etc.

Databases: ORACLE 8i, 9i, 10g, 11g,12c,12cr2, Sql Server 2008 r2,2014,2016.

PROFESSIONAL EXPERIENCE

Confidential

Oracle/Sql Server DBA

Responsibilities:

• Upgrade databases 11g to 12c(R1, R2)
• Oracle database character set conversion with DMU tool (WE8MSWIN1252 to AL32UTF8)
• Provided on-call production database support.
• Decommission the old databases as per application requirement
• Experienced in Installation and configuration Oracle Golden Gate (service gg) for Data warehouse environment.
• Handled Development and production support incidents. Worked with application teams to handle failover and switchover scenarios and handled any database and replication issues occurring during this process.
• Experienced in using 11g, 10g features Data Pump, Flash-Back Recovery, AWR etc.
• Configured ASM disk groups to store Data files, redo log files, and control files.
• Expertise with different Backup and Recovery strategies, Cloning (using Recovery Manager - RMAN), creating RMAN scripts, Export / Import, Data Pump
• Performing periodical Backup and Restoration and recovery using RMAN (full & incremental) and RMAN incrementally updated backups.
• Extensively experienced in Oracle Database monitoring and tuning using Oracle Enterprise Manager (OEM 13c) monitoring.
• Data migration between environments using Export/Import, Expdp /Impdp
• Expertise in creating Users, Roles and Profiles and Privilege management with role-based security.
• Monitored the performance on UNIX Servers using TOP, VMSTAT, IOSTAT, NETSTAT and SAR.
• Analyzing slow-running SQL queries and generating statistics using the Execution Plan and recommended solutions for faster execution.
• Performed Data Guard testing (Switchover) to ensure High Availability.
• Used RMAN Clone to refresh Dev/Test from Production
• Worked with Oracle Support processes for technical issues.
• Capacity Planning: Allocate system storage and plan future storage requirements.
• Monitoring and maintenance of multiple databases for production, development and testing.
• Implemented database refresh with the hot backup using DUPLICATE or full export.

Environment: Oracle 12cR1/12cR2/11g/10g, RAC, RMAN, EXPDP/IMPDP, PL/SQL, Stored procedures, EMC, ASM, Toad for Oracle, OEM, Auditing, Linux, AIX, Data Guard.

Confidential, Austin, TX

Oracle Database Administrator

Responsibilities:

• Upgrade number of databases from Oracle 10.2.0.4 to 11.1.0.7.5 and 11.2.0.2.0
• Implemented Data Guard with maximum protection and performed switch over between primary and standby databases.
• Expert in using export/import, expdp, impdp, Sql Loader, DBV utilities.
• RMAN backup setup via cronjob on daily full, differential etc.
• Develop and maintains DBMS related standards and procedures, knows where they are located, and makes full use of them. Follows corporate software development processes.
• Created Physical standby database using DBVISIT and delete the archive logs standby side manually.
• Monitoring database on daily basis for long running queries, sessions and identified those sessions which are hanged or consuming more resources.
• Tuning the SQL queries for best performance, with proper hints, gather proper and scalable statistics for tables as well as for schemas and by creating the adequate indexes on conditional columns.
• Tune queries and implement stored outlines or SQL Plan Baselines to force good execution plan.
• Perform Oracle software installation using OUI and silent install.
• Participating in performance analysis & tuning of oracle servers, maintenance, space management, and backup and recovery strategies.
• Performing database migration/upgrades in different environments.
• Maintaining the Space Management in different database environments.
• Performs the capacity planning required to create and maintain the databases.
• Time to time replicating the different schema’s from different servers (UNIX) and from different databases as per requirements of database teams.
• Work with other teams to promote changes to production and other environments
• Creating procedures to monitor the database sessions activity, written shell scripts to get alerts by email.
• Providing On-call support 24X7 in rotational manner.
• Configured Oracle database get alerts and messages regarding space issues, blocking sessions etc.
• Documenting, whatever the activities performed in production database.

Environment: Oracle 9.2, 10g, 11g,12r1,12r2, Sql server 2008R2/2012,2014.2016,Ubuntu,Sun F-15K/E-10K,, Solaris 2.7/2.8/2.9, AIX 4.3.3/5.x, Win2K, HP-UX 11.x