| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address
(C) PHONE NUMBER AVAILABLEEMAIL AVAILABLEOBJECTIVE Seeking an opportunity as Oracle DBA.SUMMARY Oracle Certified DBA with an extensive experience in Oracle Database Designing, managing and administering multiple databases on Unix & Windows platforms. I have extremely good skills in requirements gathering, analysis, data modeling, design and development of commercial systems under RDBMS environment and Client Server Architecture. My expertise involves in installing, administrating, configuring, maintaining, tuning, upgrade and support of e-Business Suite 11i and R12 databases. I also have experience in leading, mentoring and supporting developers and database administrators.EDUCATION MS (Information Systems), VCU, Richmond, VA GPA 3.8 2001- 2003CERTIFICATION Oracle Certified Professional (OCP in DBA)TECHNICAL SKILLSHardware Platforms: HP-9000 series, Linux, Sun Sparc Station, Gateway ALRsOperating Systems: HP-UX 11 & 10.20, Solaris 2.5, AIX, Windows 2003/2K/2008/2012Languages: SQL, PL/SQL, Unix Shell scriptingSoftware & Utilities: 12c, 11g Grid, RMAN, 13c/12c OEM, SQL*Forms rel 4.5, Pro*C, SQL*Loader, Qwest Tools - I/Watch, SQL*LAB, Instance Monitor, Space Manager, Precise tools, Q-Diagnostics, Toad, Oracle Discoverer, Warehouse Builder, OLAP, Perl, SQL*Loader, TKPROF, Export/Import, Utlbstat & Utlestat, Statspack, AWR, ErwinNetworking: TCP/IP, SQL*NetRDBMS: Oracle 12c, 11g, 10g, 9i, 8.x and 7.3, SQL Server 2000, Data Warehousing, PostGresSQL, ETLOracle Applications R12, 11.x and 11.0.3SPONSORSHIP US CitizenEXPERIENCESr. Oracle DBA, ArcelorMittal, WV Feb. Jun. 2017I am working as a senior Oracle DBA consultant on part-time basis supporting various Oracle databases.Responsibilities:Supporting Oracle instances including Production and testing.Designed and supported custom built based applications following SDLC model.Developed scripts to automate the cloning process.Configured Hot and Cold backups for production instancesUpgraded 8/9i to 10g/11g/12c.Install and configured 12c Oracle Fusion Middleware for custom application.Involved in Printer setups, monitoring concurrent managers, Apache tuning and configurations.Configured and Managed Control M tool.Tuning, maintaining 12c, 11g, 10g, 9i Oracle non-apps databases using OEM, statspack and Explain plan.Participated in disaster recovery testing.Scheduling/monitoring daily, weekly events/reportsInstalled and configured 12c, 11g, 10g Grid control.Lead Oracle DBA, Kollmorgen Oct. 2014 Feb. 2017I had worked and managed with off-shore team providing Production Oracle Applications support.Responsibilities:Supporting eBusiness instances including - Production, acceptance, test and development.Implement RMAN and automate clone process.Involved in customer integration.Daily DBA dutiesOn-call supportSpace and Storage ManagementSupport Development teamCode MigrationCloning, patching & troubleshooting.Scheduling/monitoring daily, weekly events/reportsConfiguring Workflow, Printers and resolving issues.Tuning Sql-Pl/Sqls, database, Concurrent managers and tech stack ( middle tier) (at DB/OS level optimization)Monitor proactively to avoid potential issuesSupported DMZ architecture for i-modules iSupplier, iSupport, including customization.Support modules like General Ledger, Oracle Payables, Receivables, Inventory, Fixed Assets and Purchasing Modules; iSupport, iExpense.Sr. Oracle Apps DBA, Remote DBA Experts (RDBA), PA Oct. 2009 Feb. 2014I supported multiple projects on different platform having Production Oracle Applications. I managed new implementations and upgrades.Responsibilities:Supporting eBusiness instances including - Production, acceptance, test and development.Cross-platform upgrade of 11.5.8 on 9i on Solaris to 11.5.10.2, 11gR2 on Linux.Support R12 production instance.Upgraded 12.1.1 to 12.1.3.Installed, configured and supported R12 ASCP instancesInvolved in customer integration.Cloning, patching & troubleshooting.Space and Storage ManagementConfiguring Workflow, Printers and resolving issues.Tuning Sql-Pl/Sqls, database, Concurrent managers and tech stack ( middle tier)Supported DMZ architecture for i-modules iSupplier, iSupportSupport modules like General Ledger, Oracle Payables, Receivables, Inventory, Fixed Assets and Purchasing Modules; iSupport, iExpense.Support ADI, Discoverer.Upgraded Discoverer from 4i to 11.1Installed OBIEE. Support data warehouse, GRCM.RMAN setup and support.Support RAC instances.Monitor proactively to avoid potential issues.Standby database support using data guard.Sr. Oracle Apps DBA, MittalSteel, Weirton, WV July 2006 Oct. 2009I worked as a senior Oracle APPS DBA consultant for MittalSteel USA. I am lead oracle DBA working on multiple projects supporting Oracle Apps and non-apps databases. My main responsibilities include performance tuning databases.Responsibilities:Supporting eBusiness instances including - Production, acceptance, test and development.Supported ADI, Workflow configuration and administration, applying patches using adpatch.Supported AR, AP, GL, OTL, OE, HR modules.Supported custom built based applications.Developed scripts to automate the cloning process.Configured Hot and Cold backups for production instancesUpgraded 9i to 10gMigration of 8.1.7.4 Database from US7ASCII to UTF.Wrote script for automation of cloning processes from prod to non-prod.Applied patches on apps and DB levelMonitor proactively to avoid potential issuesInvolved in Printer setups, monitoring concurrent managers, Apache tuning and configurations.Tuning, maintaining 10g, 9i Oracle non-apps databases using statspack and Explain plan.Installed and configured 10g Grid control & 10gAS.Oracle Apps DBA, Fisher Scientific, Pittsburgh, PA Aug. 2003 July 2006Worked as Sr. Oracle Apps DBA with a global Bio-Medical organization, in Pittsburgh. I was responsible for supporting multiple 11i, 10g, 9i and SQL Server databases. My main responsibilities involved supporting & upgrading 11.0.3 to 11.5.10 on Sun Solaris. I also supported Data Warehousing related projects.a) Oracle Apps DBA responsibilitiesSupport e-Business suite 11.5.10 (Financial and HR modules) on Sun Solaris Platform.Installation, Cloning (Rapidclone), Patching of Oracle apps instances utilizing adpatch, autoconfig, admin etc.Configured multi-tier architecture using load balancing.Assist in the logical and physical designing of databases.Participating in 24x7 On-call production support.Developed Procedures, Packages, Functions, triggers and Materialized views using new functionality of 9i.Configure ADI, apply Vertex patches, tuning Apache server, monitor concurrent managersPerformance tuning of Batch jobs and SQL queries, using Statspack, Explain plan, bstat/estatPlanning Backup and Disaster recovery strategies.Maintenance and configuration of Oracle 11.5.10, Oracle 9i/8i, iAS, Forms server, Report server and Apache server.Tar Management and On-call support for 24x7 environments.b) SQL Server 2000 database responsibilitiesInstallation SQL server, creating database, administrating security aspects, Creating and scheduling DTS packages, schedule backups and restore databases to Pittsburgh data center.Configured replication and scheduled replication jobsMonitored scheduled jobs and provided troubleshooting efforts to fix broken jobs.Installed and configured Analysis services (OLAP)Refreshed cubesReferences: Available on Request |
