Senior Oracle Database Administrator Resume
SUMMARY
- Highly Diversified Information Technology Professional offering more than 10+ years’ leadership experience supporting Various IT functions. Expert Level knowledge of Oracle Database Management running on Unix/Linux (Sun Solaris, HP - UX, IBM-AIX, Red Hat Linux, Informatica Power Center), Oracle Relation Database Management System (RDBMS), Oracle HCM Cloud, Software Development Life Cycle (SDLC) and Enterprise Resource Planning (ERP) applications and Windows Operating Systems. Experience with Cloud Technologies, Performance optimization/Services, Agile/Scrum methodologies, Project Management and IT Operations based on ITIL Framework.
- Highly Adaptive Communication co-ordination and communication skills with system administrators, business data analysts and DevOps teams. Experience with Installation of new and/or rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements.
- Actively Managed Database installation, migration and maintenance of: Postgresql, Oracle, MySQL, MSSQL, NoSQL standby database for High Availability and Disaster Recovery purpose. Highly experienced in Oracle System PATCHING AND UPGRADATION. Experience in Performance Tuning using SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
- Expert Level Knowledge of Bit Data Strategy & Implementation of Oracle Enterprise Manager (OEM) Grid Control (11g) & Cloud (12c) for data monitoring/performance/diagnostics. Prior experience with software integration, software testing and Test plans and test scripts. Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
- Experienced in Database Refresh and Database cloning with RMAN and manual methods. Experience in Oracle performance tuning.
- Proficient in raising TAR with Oracle Support and using Metalink to resolve the bottlenecks in the database environments using document Root Cause Analysis and ongoing system documentation.
TECHNICAL SKILLS
Software Tools: DevOps related automation tools to include, but not limited to: source mg(GIT); continuous integration (Jenkins), application configuration management (Puppet, Ansible) and container management tools ( Docker, AWS ECS); Enterprise ITSM and CMDB Tools ;
Languages: Systems administration expertise (Windows, Linux)
Environments: Scripting technologies (Powershell, Bash, Python)
dATABASES: Enterprise Monitoring Tools for infrastructure and applications
Additonal Skills: Oracle Instruction/Curriculum Design Administration skills in sizing, capacity planning in large-scale enterprise environment. IT DBA Team Management.
PROFESSIONAL EXPERIENCE
Senior Oracle Database Administrator
Confidential
Responsibilities:
- Works with the run team to do clusterware patching on several databases.
- Responsible for training and management of DBA/Rapid response team.
- Rapid response for system/ run team addressing daily task such as adding tablespaces, granting or revoking privileges, adding lun, frame migration, addressing failed backup issues, performance tuning, etc.
- Utilized GoldenGate to provide transformation and delivery of transactional data across all database replications (heterogeneous/homogenous).
- Creates user accounts, roles and granting required access permissions and privileges to the users.
- Translates and implements logical and physical data models and migrates objects/schemas between different environments.
- Performs the installation, configuration, tuning and migration of various schema objects and database upgrade from 10g to 11g and 11g to 12c.
- Actively monitor, trace, troubleshoot and resolve performance, capacity and backup-related issues.
- Leverages AWR/ADDM/ASH reports for performance tuning
- Heavily utilizes OEM for monitoring, job scheduling, tuning and other routine DBA activities.
- Create scripts to automate the implementation of all the applications with oracle instances in various environments (DEV, QA and PROD).
- Helps with the mapping and provisioning of all the roles and privileges of the users of the different applications post implementation.
- Manages, maintains and troubleshoots when necessary and takes the necessary backups needed for implementation.
- Used PL SQL to create loops, functions and procedures when necessary.
- Currently working on two new projects; entire system remediation and building several RAC Databases across every single platform.
- AWS migration and implementation to store, manage and process data.
sr Oracle Database Administrator
Confidential
Responsibilities:
- Facilitated Huntington’s switch from software to cloud based HCM to support mobile applications during the acquisition of First Merit Bank.
- Consulted with Business Leadership on the benefits of HCM implementation.
- Responsible for implementation of role-based access control to facilitate the acquisition of First Merit Bank by Huntington Bank.
- Create scripts to automate the implementation of all the applications with oracle instances in various environments (DEV, QA and PROD).
- Documented Root Cause Analysis and ongoing system documentation.
- Responsible for mapping and provisioning of all the roles and privileges of the users of the different applications post implementation.
- Worked with the UNIX servers (AIX) and various databases to ensure that the various environments were created properly in the database and the resource groups were linked properly as per the RBAC model.
- Managed, maintained and trouble shoot when necessary and taken the necessary backups needed for implementation.
Sr. Oracle dba/ Database Manager
Confidential
Responsibilities:
- Administering various Dev/Test/QA Oracle 11.2.0.4 and 12.1.0.2 including production Oracle 11.2.0.4 RAC and DG (physical standby) databases.
- Training and Managing Jr. Level DBA Team on processes/technologies on ORACLE GoldenGate (OGG) software and utilized the software for data replication.
- Utilized travel and expense management to automate and streamline expense report approval and management.
- Used asset lifecycle management to improve productivity with real time analysis and overall improvement of PM schedules. To enforce compliance to better control risks and improve equipment reliability, implant utilization with solutions that offer real-time collaboration and adaptive procedures.
- Planned, designed and implemented a robust backup and recovery strategy using RMAN - physical backup - and Data Pump (Import/Export) - logical backup, respectively. Used production backups to refresh/clone the lower environments.
- Used financial control and reporting for creating and managing transactions while consolidating and reporting regularly.
- Network Administration: Switching, Routing, firewalls, etc.
- Developed and deployed: data driven analytics; event driven analytics; sets of analytics orchestrated through rules engines.
- Utilized lease and management finance management tool to leverage the power of oracle E-Business Suite to help increase revenues through using IT as a strategic differentiator, enabling them to implement accomplished strategies such as managed risk-based returns, improve asset management Administration of various systems within Linux, Windows environments.
- Created User accounts, Roles and granting required access permissions and privileges to the users.
- Heavily utilized OEM for monitoring, job scheduling, tuning, securities and other routine DBA activities using SIEM and Qrader.
- Utilized Oracle cash and treasury management solutions to run core treasury options with improved efficiency, profitability and control.
- Translated and implemented logical and physical data models and migrated objects/schemas between different environments.
- Managed Oracle E-Business Suite to run core treasury operations with improved efficiency, profitability and control.
- Performed the Installation, Configuration, Tuning, and Migration of various schema objects and Database Upgrade from 10g to 11g and 11g to 12c.
- Monitored, traced, troubleshoot and resolved performance, capacity and backup-related issues.
- Leveraged AWR/ADDM/ASH reports for performance tuning
Oracle DataBAse Administrator
Confidential
Responsibilities:
- Mainly designed databases for the food supplied by the company.
- Managed the user access to the production databases and implemented security.
- Frequent backups to ensure proper functioning of database and perform tuning as needed.
- Planned, designed and implemented a robust backup and recovery strategy using RMAN - physical backup - and Data Pump (Import/Export) - logical backup, respectively. I periodically used production backups to refresh/clone the lower environments.
- Provided 24X7 supports for all the production, Quality/Test, development databases.
- Created User accounts, Roles and granting required access permissions and privileges to the users.
- Heavily utilized OEM for monitoring, job scheduling, tuning, and other routine DBA activities.
- Translated and implemented logical and physical data models and migrated objects/schemas between different environments.
- Performed the Installation, Configuration, Tuning, and Migration of various schema objects and Database Upgrade from 10g to 11g.
- Monitored, traced, troubleshoot and resolved performance, capacity and backup-related issues.
AREA FIELD VICE PRESIDENT
Confidential
Responsibilities:
- Responsible for developing new customer relationships and new business opportunities in market segments outside the company’s traditional market base in a record time period.
- Researched and developed new ways to market and promote companies products.
- Purchased products for four offices and trained employees in those offices.
SYSTEMS ANALYST
Confidential
Responsibilities:
- Actively managed, tested and communicated changes for all System upgrades.
- Supported changes in policies and business processes to increase overall profitability more than 75%.
- Lead the redesign and implementation, look, design and ease of use for SharePoint for Wellness Technology.
- Participated in projects teams to automate reports using VB Script, VBA, SQL and C#.