PROFESSIONAL SUMMARY:

• IT professional with over 10 years of Hands - on experience and technical supporting multiple complex IT infrastructures and Enterprise systems.
• 9 years of experience as an Oracle Database Administrator.
• 6 years of managerial experience as a IT business owner involved in hiring, project oversight, payroll and business strategy.
• Comfortable in Full SDLC including Production, Application & Project Support.
• Excellent interpersonal and communication skills, strong analytic and decision-making skills, and ability to juggle multiple priorities effectively.
• Excellent problem solving and Customer needs assessment skills
• Oracle 10g/11g/12c Database Administration
• Installation of Oracle RDBMS versions 10/11/12 on multiple platforms for optimum performance.
• Good mastery of Oracle RDBMS architecture to resolve issues with memory allocation, ORA-00600, ORA-07445, ORA-00700, ORA-27XXX, ORA-04030 and ORA-04031 errors.
• Good mastery of patch installation and upgrade procedures
• Good mastery of DML, DDL and TCL
• Proficient at TDE and database security through the creation of roles, profiles, granting of privileges and general auditing of the database users.
• Experience in setup, configuration and implementation of RAC on Linux with ASM.
• Proficient in Upgrades, Patches (PSU, CPU), Migration and Production support, Cloning, Backup and Recovery, Performance Tuning, capacity planning and Documentation.
• Experienced in Database Backups and Recovery Strategies Using RMAN: Hot and Cold Backup, RMAN Duplicate Databases and FLASHBACK recovery features, including disaster recovery.
• Strong Exposure on High Availability Concepts (RAC, Dataguard), Database Cloning.
• Proactive monitoring, identifying tuning opportunities and tuning using STATSPACK, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring and Oracle Enterprise Manager Cloud Control 12c and 13c.
• 3 years of experience in a utomat ing tasks using shell scripts and Crontab: Backups, exports and imports, archiving old records and verification of such processes , user account operations, etc .
• Proficient in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Optimization, Troubleshooting, tuning backups
• Managing the cluster resources and performing health check of all instances within the cluster.
• Data Migration/Database Cloning
• Proficient at using export/import utilities and Data pump to migrate data across different OS platforms and Oracle RDBMS versions.
• Installed and configured Oracle GoldenGate for classic mode replications and Advanced Configurations (active/active, active/passive).
• Proficient at using RMAN to create standby databases and database clones for DEV and TEST instances.
• Proficient at using SQL Loader to load data into Oracle RDBMS from various sources.
• UNIX/LINUX, AIX, Sun Solaris, Windows Server experience
• Proficient at installing OS and tuning the kernel in preparation for the installation of Oracle RDBMS.
• Proficient at identifying OS Configuration bottlenecks that will negatively impact Oracle RDBMS performance and instance availability.
• Good understanding of the principles of network setup and tuning. Configured BIND DNS servers, NFS Storage Servers and SMTP Servers both at enterprise level and in private projects.
• 2 years experience with administering Oracle RDBMS on Exadata
• 2 years experience administering Oracle databases on AWS and Oracle Cloud Interface.

SUMMARY OF PROFESSIONAL EXPERIENCES:

Confidential, UT

Sr. Oracle DBA/Technical Support Engineer

Responsibilities:

• Interviewed prospective candidates for open positions within DB Manageability Support Group at Oracle Global Customer Support.
• Mentored junior Support Engineers on queue management, ODM compliance and delivering the best customer experience in resolving customer service requests.
• Manage and resolve Service Requests logged by customers (internal and external) on Oracle products and contribute to proactive support activities according to product support strategy and model
• Own and resolve problems and manage customer expectations throughout the Service Request life cycle in accordance with global standards.
• Maintain product expertise within the team. Manage all customer issues with regards to Oracle RDBMS installation, configuration, administration and troubleshooting.
• Proficient at using data migration tools like Datapump and SQL Loader for everyday backup and data loading tasks as well as for database migrations.
• Proficient at diagnosing common database internal errors with particular focus on ORA-00600, ORA-07445, ORA-04030, ORA-04031 and ORA-27xxx memory errors. Analyzed incident tracefiles to find the system memory function that crashed to cause the error.
• Proficient at analyzing and resolving issues with database instance memory configuration parameters for optimum instance and application performance. Troubleshooting high availability solutions including but bot limited to Oracle Dataguard, RAC and Data Warehouses.
• Proficient at the use of Oracle Enterprise Manager Cloud Control 12c and 13c to monitor database instance targets. Working knowledge of the installation and configuration of OEM Cloud Control.
• Used shell scripts to automate DBA tasks such as:
• Weekly security/audit tasks by automating scripts to match existing database user accounts to weekly termination list, ensure that the user accounts and lock/expired.
• Parsing the alert log of all Oracle databases and emailing error details for all critical errors to the DBA group from quick resolution.
• Yearly audit for compliance with DBA profiles.
• Database datapump export and import via shell scripts.
• Maintain an up-to-date and in-depth knowledge of new technology released for supported product. Staying abreast of the Oracle High Availability technologies on multiple OS platforms: RAC and Active Dataguard on MS Windows and Unix platforms. Provide SME level support to customers in the areas of installation, configuration/tuning and administration.
• Work towards, adopting and contributing to new processes and tools (diagnostic methodology, health checks, scripting tools, etc.). Provide expert level support in the use of Oracle Enterprise Manager Cloud Control for monitoring, diagnosing issues, etc.
• Contribute to Knowledge Management content creation and maintenance. Creating Metalink documents on My Oracle Support portal to assist Oracle end users with troubleshooting common and complex Oracle RDBMS issues.
• Work with development on product improvement programs (testing, SRP, BETA programs etc).

Confidential

IT Field Specialist

Responsibilities:

• Configuration and maintenance of LAN and WAN for local academic institutions
• Pricing, purchasing and installation of VSAT equipment for local internet access in Computer Science, specializing in MS Office Suite, Networking, Data Entry
• Computer hardware and software maintenance
• Customizing of computer hardware for clients to suit specific business needs (pricing, purchasing of parts, assembling working CPU’ s and software installation)
• Consulting with and supporting IT departments of local al institutions on design and execution of IT Labs.