PROFESSIONAL PROFILE

• Over 9 years of DBA experience in the industry.
• Oracle Certified Professional OCP DBA highest scored 98 in North America in OCA exam with extensive qualifications including Oracle 11/10g RAC, EM grid control, active data guard, data analysis, modeling, designing, data formatting, loading, database create and managements backup recovery, security maintenances , infrastructure development with multisite networks, hardware/software acquisitions and configurations.
• CITRIX Certified Associate CCA5 IT professional, proficient in selection and implementation of computer systems that provide real time business solutions and increase organizational efficiencies/productivities.
• Highly efficient and multi-tasking capability including documenting regarding subject matters, and enable to work in-group and independently.

Technical Skills:

• Database: Oracle 12c, 11/10gR2, 9i/8i, SQL Server 2012/2008R2, IBM DB2 and People Soft HR/Fin , Sybase, PostgreSQL v9.4, SAP, MS Access
• Oracle Tools: SQL, PL/SQL, Oracle SQL Plus, Oracle RAC 11/10g ,OWB, Data Guard, ASM, Oracle E-Business SuiteR12/SOA, Oracle Identity Manager OIM /Oracle Access Manager OAM / Oracle Single Sign On SSO , Oracle SQL Loader, DB Partitioning, Oracle Apex 3.0/3.0.1 forms and web , Reporting BAM, Oracle Report, Discover, Reports Builders, IBM Cognos, Crystal ,DB Modeling Tools MS-Visio, Toad, ERWin, Power Designer, Oracle Developer suit6i , DBMS Tools OEM Grid Control, Golden Gate, Toad Oracle 11.5/10.7, DB Artisan, HP Openview , Oracle Enterprise Management Console 11/10g , Data Pump, Export/Import, Backups Recovery RMAN, EMC Data Domain, VERITAS Netbackup ,Oracle Identity Manager OIM , Application Server BPEL,Apache / HTTP / Web Logic 11g,Fusion Middleware 11/10G, Oracle Application Manager , Monitoring Tools BNC Quest Spot Light, Fog Light,Confio Ignite8, Ticketing Remedy7.X, SM7,Magic,Serena , Oracle Golden Gate 11gR2,Oracle Exadata, Oracle Database Appliance v2.1
• SQL Server Tools: SSMS, SSIS, SQL Server Agent, Configuration Manager, Import/Export SQL Data, SQL DM. SQL Server BI Development Studio, MS VSS, SQL profiler, Query Analyzer, SQL Clustering
• Others: C , VB scripting, UNIX shell scripting ksh/csh , .Net, HTML, PERL, Java Jvm 1.5.x, Jboss v4.x, XML, ERP, GIS ESRI/ArcSDE/ArcInfo , Feature Manipulation Engine FME , People Tool People Soft HR/Finance , Peloton SiteView WellView
• Platforms: Sun Solaris 5.x , Redhat Linux Server, HP UNIX, AIX, Citrix 4.0 PS, Citrix XenApp 5.0, VMware 5.0/60, ESX, Biz Talk 2012 SOA , Windows 2003/2008 Server.

Jobs Experience

Confidential

Database Administrator

• Provided day to day operational and technical supports for the databases prod/dev/uat and applications issues under Oracle RAC 11g/10gR2 enterprise grid control environments.
• Installed, configured and maintained new created databases Oracle 12C/11gR2 required for development and testing purposes.
• Setup vendor recommended databases and applications monitoring tools Oracle 11gR2 Enterprise Manager OEM , Fog lights and setup database health alert system.
• Setup databases disaster recovery systems such as Oracle 11gR2 RAC , Data Guard Active DataGuard .
• Monitored performance of the running production databases including Sybase, PostgreSQL, oracle Exadata , user connected session's activities, locks, latches, alert.log, block corruptions, segment fragmentation, security threats, and tune databases when it was needed.
• Performed huge database tuning activities systems and SQL query using available tools and techniques such Oracle Tuning Pack, Tkprof, Plan Table, SQL Tracing, Statspack, AWR,ADDM,
• Down loaded and applied vendor released my oracle support critical patches and upgraded database instances as per SLA Service Level Agreement .
• Planned and implemented databases backup incremental/differential hot cold and recovery RMAN systems for all new created databases test and dev .
• Monitored daily backups logs activities, verified and tested backup pieces using db verify utilities before sending to the secondary storage locations.
• Lead the team members offshore applications developers , WF ICMP applications Iowa farming mortgage and loan deployment and provided project progresses to the project manager during weekly meeting.
• Controlled migrations of all database programs oracle 11gR2 , especially database changing, reference data changing and menu changing through the development life cycle.
• Migrated existing old databases IBM DB2, SQL Server2005, Sybase, Oracle 8i, and Oracle 9i to new Oracle 11gR1/R2 database environments using available Wells Fargo provided tools and techniques like Oracle Golden Gate, Oracle SQL Developer, and SwisSQL.
• Initiated change management procedure and released new changes into productions and non productions database systems environments.
• Implement database auditing, data security and Remediate high-risk violation in production environment.
• Performed databases modeling activities using Erwin, Visio, Power Designer, as required assisting performance and ensuring maximum uptime of the database.
• Evaluated the vendor released products and tools, and other provided third parties running applications, hardware and software products to ensure that the site was running the products that were most appropriate.
• Administered all of the database objects, including tables, clusters, indexes, views, materialized views, sequences, packages and procedures.
• Scripted and wrote PL/SQL codes, stored procedures, created news, roles, materialized views to administer databases easily.
• Assisted with the impact analysis of any changes made to the database objects.
• Troubleshoot regarding the problems and bugs of the databases, running applications and development tools.
• Installed, configured and maintained oracle application servers Fusion Middleware11g, Web Logic 10.3 Oracle Business Intelligent Enterprise Edition OBIEE with SOA.
• Provided on call support 24/7 On Call in production database environment by rotations.

Environment: Oracle RDBMS 12C/11/10gR2, Oracle 11R2/10gR2 RAC, Data Guard, Oracle Enterprise Manager OEM Grid Control 11R2/10gR2, Oracle Identity Manager OIM , Oracle Access Manager OAM ,Oracle SQL Loader, Oracle Golden Gate 11gR2, EM Database Console, RMAN, Explain Plan, Statspack, Tkprof, SqlTrace, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10,linux,aix, hp Unix , Web Logic Server 10.3, Oracle Fusion Middleware 11G,VMware 2.0 server/Citrix XenApp 5.5,BMC Software Remedy 7.2 ,IBM Tivoli, Quest Software Oracle TOAD 11.5, Oracle TOAD Analyzer ,Embarcadero Software DB Artisan , Sybase,PostgreSQL,Oracle Exadata Appliance, Oracle Database Appliance v2.1, shell scripting ksh,csh .

Confidential

Oracle DBA

• Installed and maintained databases Oracle 11/10g required for development, testing and production environments.
• Provided day to day databases operational and technical supports for production environments under Window/UNIX Operating Systems.
• Setup recommended databases monitoring tools OEM 11g Grid Control and disaster recovery systems Oracle 11gR1 RAC , Oracle Active Data Guard.
• Monitored performance of the running databases, ongoing tuning activities, and applied vendor released critical patches and upgraded database instances.
• Upgraded database patching and application server patching using available utilities and techniques OPatch, adpatch,admrgpatch etc
• Planned and implemented databases backup and recovery RMAN systems for all three environments prod, test dev .
• Lead the team members junior DBA and 12 applications offshore developers , and provided project progresses to the project manager during weekly meeting.
• Controlled migrations of all database programs oracle 11g , especially database changing, reference data changing and menu changing through the development life cycle.
• Migrated existing old databases IBM DB2, Sybase, Oracle 8i, Oracle 9i to new Oracle 11gR1/R2 database environments.
• Initiated and implemented change management procedure and released new update into productions and non productions database systems environments.
• Implemented database label of securities and applied those label of securities for all of the running databases productions and non productions environments.
• Performed databases re-structuring, and re-modeling activities as required assisting performance and ensuring maximum uptime of the database.
• Evaluated the release of the oracle products and tools, and vendors provided running third party applications, hardware and software products to ensure that the site was running the products that were most appropriate.
• Enforced and maintained database constraints to ensure integrity of the database.
• Administered all database objects, including tables, clusters, indexes, views, materialized views, sequences, packages and procedures.
• Scripted and wrote PL/SQL codes, stored procedures, created news, roles, materialized views to administer databases easily.
• Assisted with impact analysis of any changes made to the database objects.
• Troubleshoot regarding the problems and bugs of the databases, running applications and development tools.
• Installed, configured and maintained oracle application servers Fusion Middleware11g, Web Logic 10.3, IIS Server
• Provided on call support 24/7 On Call in production database environment by rotations.

Environment: Oracle RDBMS 11/10g,9i, Oracle 11/10g RAC, Data Guard, Oracle Enterprise Manager OEM Grid Control 10g R2, Oracle Identity Manager OIM ,Oracle Access Manager OAM ,Oracle SQL Loader, Oracle Golden Gate 11gR2, Enterprise Manager Database Console, RMAN, Explain Plan, Statspack, Tkprof, SqlTrace, Spotlights, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10,linux,aix, hp Unix , Windows 2005/2008 servers, Web Logic Server 10.3,VMware 2.0 server/Citrix XenApp 5.5,BMC Software Remedy 7.2 ,IBM Tivoli, Quest Software Oracle TOAD 10.7, Oracle TOAD Analyzer ,Embarcadero Software DB Artisan ,shell scripting ksh, csh .

Confidential

Sr.Oracle DBA

• Performed installations, configurations, coordinating and administering databases Oracle 11/10g/9i/8i, People Soft HR/FS server hardware/ software, and setup backup recovery systems as designed by the organization.
• Provided day to day databases Oracle 11/10g, 9/8i, SQL server 2012/2008R2/2005, PostgreSQL operational supports, maintenance and upgraded patches in all environments prod/dev./test .
• Created/removed user profiles, groups, roles, privileges, authentications, encryptions and scripted for easy database administration.
• Developed the daily/weekly databases maintenance and backup plans RMAN, IBM Tivoli, and Veritas and restoration of all critical systems and data, in terms of using disaster and recovery methods.
• Created huge number of new batch jobs, views, materialized views, synonyms and scheduled those jobs, stored procedures and packages and run them when needed in terms of end user and developer requests.
• Performed scripting and broken jobs fixing in Oracle/SQL server environments for running smooth operations.
• Upgraded database patching and application server OAM patching using available utilities and techniques OPatch, adpatch,admrgpatch etc
• Provided on call support 24/7 On Call in production database environment.
• o Assisted and supported end users, and prepared Bible documentations as it transferred from test projects to productions promoting , familiarizing with the expected performance and results of the applications.
• Provided supports for running oracle application servers Fusion Middleware11g, Web Logic 10.3, HTTP servers
• Monitored database systems performance using various tools and techniques OEM Grid Control, Active Data Guard , and maintained database backup and recovery processes, data security, data integrity, disk space requirements and provided reports on database server performance.
• Added new database instances to Oracle 10gR2 RAC and 11gR1 RAC environment 4 nodes .
• Tuned databases and running applications and ensured best performance of the systems.
• Participated in the database promotions and data fixing processes.

Environment: Oracle RDBMS 11/10g,9/8i, Oracle 10g RAC, Data Guard, Oracle Enterprise Manager OEM Grid Control 11g, Oracle Golden Gate 11R2, Oracle SQL Developer, Enterprise manager Database Control, OUI to both install and apply patchsets, OPatch, RMAN, Explain Plan, Statspack, Tkprof, SqlTrace, Spotlights, Fog Lights, SQL DM, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10,linux,aix , Windows 2000/2005/2008 servers, People Soft 8.0, PostgreSQL,Web Logic Server 10.3,VMware 2.0 server/Citrix XenApp 5.5,HP Open views, BMC Software Remedy 7.2 ,Quest Software Oracle TOAD 10.7, Oracle TOAD Analyzer ,DB Artisan, Confio Ignite 8, Oracle Exadata, Oracle Appliance v2.1

Confidential

Sr.Oracle DBA

• Analyzed, designed, developed, deployed implemented Exxon Mobil Oracle Enterprise Database Oracle 11/10g, 9i, 8i systems.
• Provided support in database modifications in all three production/testing/development environments and designed structures.
• Installed and maintained upgraded databases, patches under various OS platforms Sun Solaris 5.X/Windows 200X .
• Setup DB disasters and recovery systems Oracle 11gR1/10R2 RAC, Oracle 11g Active Data Guard .
• Upgraded Sun Solaris versions 5.8 to Sun Solaris 5.10, 5.11 and Window Server 2000/2005.
• Developed database applications forms, banner using Oracle Application Express Apex 4.0 and maintained databases backup and recovery systems RMAN .
• Created/removed databases user profiles/setting accounts and granted resources for smooth database operations.
• Installed, and configured oracle application servers Fusion Middleware11g, Web Logic 10.3, IIS Server
• Provided after-hours on-call support of production environments.
• Monitored databases, applications and hosts OEM, HP Open view, Fog Lights , analyzed performance of the data health and tuned/refreshed the databases when needed.
• Provided databases and applications technical support to Exxon Mobil users using Oracle Golden Gate 11.1.1.1, TOAD Oracle 10.7, DB Artisan, and Remedy10.7.

Environment: Oracle RDBMS 11/10g,9/8i, Oracle 10g RAC, Data Guard, Oracle Enterprise Manager OEM Grid Control 10g Rel. 5, Oracle SQL Loader , Enterprise manager Database Console, OUI to both install and apply patchsets, OPatch, RMAN, Explain Plan, Statspack, Tkprof, Tuning Packs SQL analyzer, Oracle

• Expert, Oracle index tuning wizard , SqlTrace, Spotlights, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10,linux,aix , Windows 2000/2005 servers, Web Logic Server 10.3,VMware 2.0 server/Citrix XenApp 5.5,HP Open views, BMC Software Remedy 7.2 ,Quest Software Oracle TOAD 10.7, Oracle TOAD Analyzer ,Embarcadero Software DB Artisan , SwisSQL,IBM Tivoli, Oracle SQL Developer.

Confidential

Oracle DBA

• Performed VERIZON enterprise databases Oracle10/11g,9i/SQL server 2005/2008,DB2, PostgreSQL and Middle Tier Applications Server HTTP 2.1/WebLogic 10.3 software installations, configurations, upgrading patch systems, and provided life cycle support, management and administration under UNIX Sun Solaris 5.8,5.9,5.10 /Windows 200x platforms.
• Analyzed the customers/vendors/contractors others third parties requirements tickets and provided accesses on the databases/applications according to the privileges and agreements.
• Received escalated trouble tickets TTs regarding the database servers / running applications issues during the on call 24/7 provided immediate client supports and technical solutions.
• Provided solutions regarding infrastructure development and implementation of the database applications security features e.g. roles, privileges, authentication and scripting .
• Migrated existing data from SQL 2003 to SQL 2005 server, and Oracle 8i, 9i to Oracle 10/11g.
• Performed daily backups hot/cold recovery systems RMAN , database troubleshooting, tuning and diagnostics activities for analyzing database performances.
• Added new database instances into the Oracle 10g RAC and OEM environments.
• Monitored database health and connectivity via various database management utilities OEM, Fog lights, HP Openview, TOAD 10.X,DB Artisan and Oracle Golden Gate
• Audited FGA and controlled VERIZON host database and modified when needed.
• Participated weekly VERIZON world conferences discussed weekly progresses, incoming problems identification and possible recommended solutions .
• Kept up to date documentation and online reporting for the future references.
• Environment: Oracle RDBMS 11/10g,9/8i, Oracle 10g RAC, Data Guard, Oracle Enterprise Manager OEM Grid Control 10g Rel. 5, Oracle SQL Loader , Enterprise manager Database Console, OUI to both install and apply patchsets, OPatch, RMAN,Veritas, Explain Plan, Statspack, Tkprof, SqlTrace, Fog lights, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10,linux,aix , Windows 2000/2005 servers, VMware 2.0 server, Web Logic Server 10.3,/Citrix XenApp 5.5,BMC Software Remedy 7.2 ,Quest Software Oracle TOAD 10.7, Oracle TOAD Analyzer ,Embarcadero Software DB Artisan .

Confidential

Oracle DBA

• Provided support for 24/7 operations on Oracle based highly transactional production systems under UNIX Sun Solaris 5.X /Windows environments.
• Developed and documented backup/recovery policies successfully.
• Sent successful backup notification emails to all onsite DBA including team leader.
• Monitored database performance and assisted with several recommendations OEM, Active Data Guard, and Oracle 10gR2 RAC to improve system performance. I trained the operators to manage the DBs into the Solaris environments.
• Performed Installation and upgrade of Oracle on Sun Servers and applied patches as required.
• Setup new environments for development, production etc.
• Setup and Install Oracle Enterprise Manager OEM and performed the configuration of the backup routines using Enterprise Manager Interface.
• Wrote shell scripts for backup and recovery, import and export procedure.
• Established database sizing, tablespace management and undo sizing
• Performance tuning, memory tuning, using either queries from the v views or gather performance metrics from the AWR by means of the Enterprise Manager DB Control Console.
• Defined the backup policies and disaster recovery criteria.
• Involved in data loading using SQL Loader/Parallel loads and direct path data loading.
• Maintained the databases updating and applied the latest patchsets available for the all three databases environments production/development/test .
• Performed capacity planning to prevent resource shortage
• Validated applications prior to perform upgrade databases from Oracle 10g to Oracle 11g on production environments.
• Upgraded databases from 10g to 11g, as well as other upgrades from databases in 9i to 10g.
• Performed data movements from the productions to a test and development environment using DataPump, data export/import, RMAN and other third party tools.
• Developed applications forms, banner using Oracle Application Express Apex 3.0
• Traced and troubleshoot highly resource consumer sessions that slow down DB performance.

Environment: Oracle RDBMS 11/10g,9/8i, Oracle 10g RAC, Data Guard, Oracle Enterprise Manager OEM Grid Control 10g Rel. 5, Oracle SQL Loader , Enterprise manager Database Console, OUI to both install and apply patchsets, OPatch, RMAN, Explain Plan, Statspack, Tkprof, SqlTrace, Spotlights, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10.linux,aix , Windows 2000/2005 servers, VMware 2.0 server/Citrix XenApp 5.5,BMC Software Remedy 7.2, ,Quest Software Oracle TOAD 10.7, Oracle TOAD Analyzer

Confidential

Oracle DBA

• Performed enterprise database Oracle 10/11g and applications server Web Logic 10.3 software installations, configurations, upgrading patches, database management and administrations under various operating systems Linux, Sun Solaris 5.10/Windows 2003 .
• Created user profiles, groups, roles and scripting for easy database administration.
• Approved all productions database designs and schema changes.
• Controlled all migrations Oracle 8i and SQL Server 2000 to Oracle 10/11g of the database schema objects and ensure the data availabilities.
• Performed daily backup recovery system RMAN and Veritas.
• Setup databases performance monitoring system tools OEM 10g Grid Control
• Monitored database HP Open view and performance tuning and others diagnostic activities.
• Provided On Call 24/7 technical supports when needed.

Environment: Oracle RDBMS 11/10g,9/8i, Oracle 10g RAC, Data Guard, Oracle Enterprise Manager OEM Grid Control 10g , Oracle SQL Loader , Oracle Data Integrator ODI ,Oracle Warehouse Builder OWB Enterprise manager Database Console, OUI to both install and apply patchsets, OPatch, RMAN,Veritas, Explain Plan, Statspack, Tkprof, SqlTrace, Spotlights, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10,linux,aix , Windows 2000/2005 servers, VMware 2.0 server/Citrix XenApp 5.5,BMC Software Remedy 7.2, ,Quest Software Oracle TOAD 10.7, Oracle TOAD Analyzer .

Confidential

Oracle DBA

• Installed and configured Oracle10g databases under UNIX/Windows 2003 OS systems.
• Installed and configured Oracle Database Applications for 15 databases.
• Migrated databases from SQL Server 2000/Oracle 8.x to 10.2.0.3 on Sun OS 5.8,Redhat 4.1
• To upgrade Oracle 8.0.6 on Solaris8-32 bit server to Oracle 9.0.2 on Sun SPARC 64 bit server.
• Cloned databases used utility such as RMAN Duplication.
• Used latest available Oracle Patches for Upgrade the various Oracle versions.
• Created scripts Configured hot backup and cold backup by RMAN
• Installed and Configured Oracle Enterprise Manager 10g Databases.
• Configured TNSNAMES.ORA and LISTENER.ORA for Client-Server connections.
• Performed DB tuning explain plan, stat pack, Tkprof ,third party tools,ADDM reports
• Created P/L SQL functions, package, stored procedure, and triggers.
• Created Oracle forms, reports and data modeling with Erwin, MS Visio 3.0, Design Engineer.
• Developed customized data extraction routines using SQL Loader, Export/Import/data pump
• Provided remote databases supporting through RSA token connectivity under VMware 5.0/Citrix PS. 4.0 environments.
• Troubleshooting on Productions/Develop/Tests databases according to Remedy tickets.
• Management of database users, granting/revoking of system/object privileges, management of roles resources and setting of init.ora parameter
• Supporting 24 7 production database

Environment: Oracle RDBMS 11/10g,9/8i, Oracle 10g RAC, Data Guard, Oracle Enterprise Manager OEM Grid Control 10g , Oracle SQL Loader , Oracle Data Integrator ODI ,Oracle Warehouse Builder OWB Enterprise manager Database Console, OUI to both install and apply patchsets, OPatch, RMAN, Explain Plan, Statspack, Tkprof, SqlTrace, Spotlights, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10,Linux,Aix ,windows2000/2005,BMC Software Remedy 7.2, ,Quest Software Oracle TOAD 10.7, Oracle TOAD Analyzer .

Confidential

Oracle DBA

o Performed installations, configurations of Oracle database 10g/9i /application HTTP 2.0 servers and upgrading patches under various OS platforms Window 200X/UNIX .

• Migrated and replicated databases and applications from other environments SQL Server 2000, Oracle 8i, and MS Access to Oracle 10g.
• Changed data modeling, designed and developed new databases for the clients.
• Investigated existing systems and recommended hardware /software and other utilities monitoring tools for clients to maintenance databases and applications easily.
• Installed Oracle database 10 g RAC under various OS UNIX/ windows 2003/VMware5.0 .
• Performed tuning cleaned up databases to ensure optimum performances.
• Scripting to easily maintaining databases and backups recover RMAN systems.
• Added newly developed databases with OEM environments to make sure that developed database objects are functioning properly.
• Tested implemented databases with user feedback and closing the project works.

Confidential

Confidential

• Performed server software Oracle 10g, 9i enterprise / SQL server 2000 installations, configurations, provided life cycle supports and database administration under UNIX Sun Solaris 5.8, Linux Redhat Windows 2003 server, Window NT 3.0 platforms.
• Created database and relational schema objects tables, indexes, functions, and triggers , PL/SQL stored procedures, SQL scripts for easy database administration.
• Tested and applied relevant patches and upgraded Database.
• Received all types of running database / applications related trouble tickets 24/7 On Call and provided immediate technical supports to ensure financial smooth operations.
• Monitored database performance and connectivity HP Open view and tuned when needed.
• Migrated existing data from SQL 2000 to Oracle 10g / 9i enterprise.
• Performed daily backups and restorations RMAN and updated documentations.

Environment: Oracle RDBMS 10g,9/8i, Data Guard, Oracle Enterprise Manager OEM Grid Control 10g , Oracle SQL Loader ,Oracle Enterprise manager Database Console, OUI to both install and apply patchsets, OPatch, RMAN, Explain Plan, Statspack, Tkprof, SqlTrace, Spotlights, AWR,ADDM, ASM, SQL Plus, UNIX Sun Solaris 5.9,5.10,linux,aix , Windows 2000/2005 Servers, BMC Software Remedy 6.0, ,Quest Software Oracle TOAD 10.0, Oracle TOAD Analyzer .