| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLEPhone: PHONE NUMBER AVAILABLESummary:Dynamic and results-oriented Oracle Lead / Cloud Engineer OCI, OIC, OAC, GCP and Azure Devops/ SQL Developer with over 13 years of comprehensive experience in IT, specializing in Oracle database administration, cloud infrastructure management, and SQL development. Proven track record of successful project implementations across diverse industries including Banking, Telecom, Insurance, Utilities, Financial, and Healthcare. Adept at designing, implementing, and optimizing Oracle Cloud Infrastructure solutions, with expertise in Oracle databases (10g, 11g, 12c, 18c, 19c), RAC, Golden Gate, Data Guard,OEM and performance tuning. Skilled in leading cross-functional teams, driving change management initiatives, and delivering superior client services.Certifications: Certified Oracle 12C OCP Certified Oracle 11g OCA Certified SQL AdminCloud Certifications: Oracle Cloud Infrastructure 2023 AI OCI Cloud Foundation Associate Oracle Cloud Data Management 2023 Certified Foundations Associate Oracle Database Cloud Administrator Certified Oracle Database Cloud Service Operations Certified Professional Experience:Apex System (Mayo Clinic), Glen Allen, VASenior Cloud AdministratorJan 2024 Present Designed and implemented Oracle Cloud Infrastructure (OCI), (OIC) & (OAC) solutions, optimizing resources for cost-efficiency and performance. Collaborated with cross-functional teams to address infrastructure-related issues and ensure security best practices. Led the migration of on-premises workloads to Oracle Cloud Infrastructure, ensuring seamless transition and minimal downtime. Managed Oracle Cloud services including Compute, Storage, Networking, and Identity and Access Management. Conducted performance tuning and capacity planning, ensuring optimal resource utilization. Participated in disaster recovery planning and testing for OCI environments. Deployed integration solutions using Oracle Integration Cloud (OIC) to streamline business processes and enhance data exchange between various applications such as Fusion Apps and in house integration applications Collaborated with cross-functional teams to gather integration requirements and translate them into effective integration designs. Implemented RESTful APIs web services and orchestrated integrations using OICs visual designer. Leveraged OICs adapters to connect with on-premises and cloud applications, enabling seamless data flow. Conducted performance testing and optimization of integrations to ensure smooth and efficient data transfer. Integrated security best practices into OIC implementations, ensuring data confidentiality and integrity. Troubleshot and resolved integration issues, working closely with stakeholders to ensure timely resolution. Provided technical guidance and mentoring to junior team members, facilitating their understanding of OIC concepts and best practices. Achievements: Successfully streamlined business processes by implementing OIC integration solutions, resulting in a 90% increase in efficiency. Improved data exchange between applications, leading to enhanced collaboration and decision-making across departments. Received positive feedback from stakeholders for delivering robust and reliable integration solutions within scheduled timelines. Mentored junior team members, contributing to their professional growth and the overall effectiveness of the team. Participated in Proof of Concepts (POC) in data replication from Oracle Fusion ADW Google BigQuery GCP Worked on AzureDevops (ADO) platform following Agile methodology. Integrated Active directory workflow using Zscalar subnets Dominion Energy, Richmond, VASr. Oracle DBA / DeveloperJan 2019- Jan 2024 Managed database upgrades and migrations, including Oracle Multitenant implementations. Provided detailed architecture, consulting, and support for database availability, backup, recovery, and performance tuning projects. Supported RAC Clusters, Data Guard environments, and high availability solutions. Engineered, implemented, and documented database upgrades to Oracle 19c, ensuring data integrity and system stability. Led the implementation and support of Oracle Data Guard, Real Application Clusters (RAC), and Oracle Streams. Managed over 2000 databases, providing 24/7 support and performing quarterly patches. Provide Oracle Application Server and Oracle APEX implementation and support. Provide support for Oracle Enterprise Manager Grid Control and Agents. Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/Data Protector, trace analysis, service creation, cluster and system management. Implementation and support of 11g,12C,18C,19C & currently supporting oracle latest database version23C migrations and upgrades from Oracle 11g,12c,18c,19c databases, including RAC (Real Application Clusters) databases on Linux. Engineering, implementation, and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC), Oracle Streams, Oracle Advanced Replication and specific network storage and clustering solutions. Provide afterhours 24x7 database support, engineering, and consulting for trade customers. Engineered, implemented, and supported Oracle 19c SAP & CC&B environment (over 10Tb in size) to use Oracle Data Guard, RAC on Linux for over 4 years. Successfully engineered, implemented, documented, and supported upgrade of the environment to Oracle 19c. Lead engineering effort, implementation and support a migration of an existing Oracle 18c RAC (64cpu/128gb RAM/60Tb ASM disks on Linux) environment worth over 10M in annual revenue to the customer to two (128cpu/192gb RAM/60b ASM disks on Linux) environments. Engineering, implemented, documented and supported builds of new clusters to use Oracle 11g,12c,18c,19c RAC on Linux. Including installing cluster ware, ASM (and shared disks) and creating new databases. Lead engineering effort, implementation, tuning and support of Oracle 11g,12 RAC/Data guard upgrades to Oracle 18c,19c RAC/Data guard. Designed AZURE database creation and install as a proof-of-concept environment to facilitate functionality testing and features, built a pilot environment which mirrored production to do in depth testing, and provided a detailed migration plan to migrate the current production cluster to the new environments. Monitoring OEM alerts for agents/application performance tuning. Creating databases with 12.2 version for PeopleSoft Applications, Oracle E business Suite and implemented Oracle ATP for the ongoing project for Power Plant Quorum, Gas Pipeline, SCADA. As a lead architect for Oracle Customer care and billing implementation, upgrading CC&B (Customer Care and Billing) from 2.3 - 2.5 and 2.5 - 2.9, including fixes and patches. Monitoring batch process / enhancement for CC&B Perform end to end CC&B configuration from customer class, division till billable charge type, adjustment types, rates etc. Create User profile, User template for user creation and upload process, enable SSO integration with CC&B, Created solution design, technical design, and functional document for the team. Developed plug in script, algorithm, and custom batch as per clients requirement for meter management data (MMD), maintained data for MMD clients ensuring 24/7 support. Performing quarterly database patches. Managing 2000+ Databases, which includes monthly server. Providing Oracle Database audit reports when being audited externally & internally Performing pure storage snap backups, Performing database maintenance such as: Taking backups, running corruption commands to make sure database or any datafile residing is not corrupted at Db level or OS level Working closely with Unix & Linux team at the time of OS patching making sure after OS patching is done all stand-alone /RAC/DG databases of Production/Test/Dev are up for business continuity. Supporting On-Call rotations(Every 3 months or when required) Creating materialized views, Creating COs(Change Orders) for database upgrade, database decommissioning, running any SQL command provided by application team, creating databases, database quarterly patching, Updating TNSnames.orafile (Making any change in prod/non-prod) Taking care of application performance, Correcting SQL codes provided by developers and programmers for application performance. Fixing OMS (OEM) issues after server patching. Maintenance of over-all database health performance, Creation of databases, monitoring which includes performance tuning on SQL Server 2016 via SSMS, Installation of Oracle client on windows server 2016. Contributed to the development of change management strategies that improved business process efficiency by 15%, Assisted in implementing service delivery improvements that reduced customer complaints by 25%, Utilized business analysis skills to identify areas for process improvement, directly contributing to a 10% reduction in operational costs. Pioneered change strategies and led a team of 15 to effect business transformation, successfully revamping 3 major processes and boosting overall efficiency by 40% .Spearheaded the implementation of ITIL frameworks, resulting in improved service delivery and a decrease in system downtime by 30%, Leveraged expertise in change management to foster stakeholder engagement, improving the successful change implementation rate by 60%,Used PRINCE2 methodology to oversee project delivery, meeting all project deliverables 3 months ahead of schedule. Revamped risk management procedures, reducing process-related errors by 15% and improving the system resilience. Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances. Created management analysis reporting using Parallel Queries, Java stored procedure, HTPP Package. Participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in a timely manner. Involved in creating UNIX shell Scripting. De-fragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain. Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle. Used SQL Server SSIS & SSRS tool to build high performance data integration solutions including extraction, transformation, and load packages for data warehousing. Extracted data from the XML file and loaded it into the database. Designed and developed Oracle forms & reports generating up to 60 reports. Performed modifications on existing form as per change request and maintained it. Used Crystal Reports to track logins, mouse overs, click-through, session duration and demo graphical comparisons with SQL database of customer information. Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL_FILE, DMBS_SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions, and packages for Front End Module. Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures for ERP based applications Involved in the continuous enhancements and fixing of production problems. Designed, implemented, and tuned interfaces and batch jobs using PL/SQL, Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes. Built databases and table structures following n-tier architecture methodology for web applications. Analyzed and designed relational databases using ER Studio and Erwin Data Model tool. Help build Oracle BI reports, OTBI reports In depth knowledge in Oracle ERP cloud modules;AP,AR,GL,FA etc Oracle Corporation, Austin, TexasSr. Technical EngineerApr 2015 Dec 2018 Provided support for Production database SRs, specializing in High Availability solutions including RMAN, Data Guard, and Golden Gate. Collaborated with development teams to create and review technical documents for issue resolution and automation. Worked on Cloud SRs including DbaaS, IaaS, PaaS, SaaS, and AWS, resolving technical issues and implementing solutions.IBM, New York, NYSr. Oracle DBA / Data Stage Developer / Database Technical Lead Mar 2012 Apr 2015 Built and managed RAC Clusters, providing support for Oracle, SQL, Netezza, and Sybase databases. Managed Security and Audit compliance for multiple accounts, ensuring data integrity and regulatory compliance. Led Change Management processes, managing CRQs and ensuring SLA adherence. Migrated databases and performed capacity planning, ensuring optimal performance and scalability. uild and supported Data Guard Environments Managed Security / Audit compliance of more than 30 accounts (Consisting of platforms: Oracle, SQL, DB2) Managed Oracle EBS Financial Sector and dealt directly with Clients Worked with storage teams for ASM needs. Worked on many performances related issues. Managed and met SLAs timings. Evaluated Team performances and helped by mentoring team if needed Managed Change Management process of CRQS (Consisting of platforms: SQL, DB2) Managed in-house Oracle Databases running on various operating systems like Windows. Installation of Oracle Database and Oracle products. Implementing Backup/Recovery Strategies. Implementation of high availability of solutions with Oracle10g RAC, Physical and Logical standby databases (Data Guard), Materialized View, VCS and Golden Gate Installed Golden Gate Experience in replication using Golden Gate and Materialized Views Replication and Extracting data and applying on production databases using Golden Gate, supported HVR replication for clients and installed HVR software upon clients request and maintained / monitored. Using Enterprise Backup utilities for backup. Writing scripts for backup and recovery. Database creation, Installation, patching and database upgrades. System tuning for better performance. Written Shell script & also performed partitioning, Data Archiving and Purging Responding immediately to any critical conditions, and proactively to any developing conditions, including Database locking, Database corruption, Low disk. spaces and Performance issues. Applied CPU and quarterly patches in the development and production environments using Patch utility. Used 12C OEM to run AWR reports, 12C MA agents registration Installed 12C MA Agents on Linux, AIX, Solaris Platform. Creating packages and database triggers. Creating users and maintaining database security. Worked with application developers to debug PL/SQL procedures, tuning queries and Writing UNIX shell scripts for backup and recovery. Database/Schema Refresh as per client requirement. Worked on capacity planning. Worked on weekends for deployments with offshore teams. Used AWR, ADDM, TKPROF, and SQL Trace for database performance statistics. OEM Grid Control installation and configuration for monitoring and performance tuning. Performed Range Partitioning as a cause to improve the performance of the database. Performed Cross platform migration using transportable tablespaces and RMAN. Performed Import and Export using Oracle Data pump utilities Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases. Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations, and configurations on an as needed basis. Add new nodes to RAC 11g Cluster to distribute the load. Installed and implemented 11g RAC with 4 nodes with ASM. Upgraded Databases from 10g to 11g and applied patches as per requirement. Worked extensively on data center migrations on multiple database versions. Responsible for installing and configuring Golden Gate on Oracle Servers. Database migration from 10g to 11g. Designed, configured, and maintained backup and recovery policies using RMAN. Compared and contrasted multiple snapshots using AWR. Experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor. Discoverer Administration includes the design and administration of Business Setting up privileges to create local and remote objects. Create materialized views to refresh data at regular intervals. Using materialized view logs to reduce the replication time costs for fast refreshes. Upgrading/Migration from Oracle 10g databases 11g Oracle Databases Installing of quarterly security patches on all non-production and production servers. Cloning/replicating/refreshing production databases to test/ development environments. Worked on SQL Server 2005 and 2008 instances. Administered, managed, Backup / Restore / Recover SQL Server Databases. Actively participated in Oracle and SQL Server Load Tests. Migrated over 100 TB of Data to IBM Netezza platform from multiple DB2/SQL and Oracle warehouses. Involved in Requirement gathering, Table design, ETL Design/testing and implementation. Worked on migrating 1000+ DataStage jobs from Infosphere Information Server Actively participating in decision making and QA meetings and regularly interacting with the Business Analysts and development team to gain a better understanding of the business process, requirements & design. Using DataStage as an ETL tool to extract data from source systems, loaded the data into the IBM DB2. Working with Business Analysts to identify and develop business requirements, transforming it into technical requirements and responsible for deliverables. Implementing join, lookup, aggregates, filters, rank, and update strategy transformations. Working towards optimal performance when using stages like lookup, join, and merge. Extensively working with DataStage Designer and Director to load data from source extract files to the warehouse. Providing the staging solutions for data validation and cleansing with PL/SQL and DataStage ETL jobs. Developing various jobs using database connectors, aggregators, and sequential file stages. Designing and developing DataStage jobs for loading staging data from different sources like files, Oracle, SQL server DB into data warehouse applying business rules which consist of data loads, data cleansing, and data massaging. Creating a shared container to simplify the DataStage design and used it as a common job component throughout the project. Tuning DataStage jobs for better performance by creating DataStage lookup files for staging the data and lookups.IBM, New York, NYJunior Oracle DBA / DeveloperMar 2011 Mar 2012Responsibilities: Created Oracle databases 11g, ensuring proper configuration and optimization for performance. Assisted team members in creating users and granting roles, ensuring appropriate access controls. Migrated Oracle Databases with the same version across mixed platforms using RMAN, ensuring data integrity and minimal downtime. Applied patches on Test and UAT environments, ensuring consistency and stability across different environments. Developed Logon Triggers to enforce security policies and automate tasks upon user login. Monitored database alerts and promptly addressed any issues to maintain system stability and performance.Achievements: Designed and developed a data warehouse solution, resulting in a 30% improvement in data accessibility and analysis capabilities for the organization. Implemented data quality solutions, reducing data errors by 25% and enhancing overall data accuracy and reliability. Collaborated with cross-functional teams to develop and maintain reporting solutions, providing actionable insights to stakeholders and facilitating data-driven decision-making. Created and maintained database objects such as tables, views, stored procedures, and functions, ensuring efficient data storage and retrieval. Implemented and maintained database security measures to ensure data confidentiality and compliance with industry regulations. Developed and maintained data models and data dictionaries, enhancing data organization and understanding.DATASTAGE SERVER MIGRATION PROJECT: Developed DataStage jobs for ETL transformations, loading respective Dimensions and Fact tables as per project requirements. Led an offshore team throughout the project, providing guidance and support, and ensured accurate project documentation. Served as an Application SME for the project implementation, leveraging subject matter expertise to drive successful outcomes. |
