SUMMARY

• Oracle Certified Cloud Infrastructure Foundations 2020 Associate and Certified Applications DBA for R12 with 20+ years of experience in Oracle Application administration and Database administration on Linux, Solaris & Windows platforms.
• I am also Real Application Clusters Administrator Certified Expert. I have expertise in Oracle Financials (R11.5.10.2, R12.13, R12.2.7, R12.2.9), Oracle Database (19c,12.1,11g,10g,9i,8i,8.x,7.x), Oracle RAC(12.1, 10G, 9i), configuring and managing high availability standby databases.
• I have managed multiple mission critical 24*7 databases for world’s leading pharmaceutical and Payroll companies: Pfizer, Sanofi & Paychex. I have expertise in Installation, maintenance, performance tuning, support & training.
• I have extremely good skills in requirements gathering, analysis, design, development of commercial systems under RDBMS environment and Client Server Architect.
• I have experience in wide variety of application areas like Oracle Financial Applications, Pharmaceutical Applications, & Management Information Systems. Experience in leading, mentoring and supporting developers and database administrators

TECHNICAL SKILLS

Hardware: HP - 9000, IBM AIX, SUN-SPARC, Red Hat Linux, Oracle Linux

Operating System: OEL 7x, OEL 6x, HP-UX 11i, 11.00, 10.20, Sun Solaris 2.0, AIX, LINUX 6.2, Windows 9x, Windows NT, Win2000, DOS.

Software: Oracle 12, 11G, 10G, 9i, 8.x & 7.3, 10GRAC, 9i RAC, Veritas cluster manager 3.5 update 3.5, RMAN, EMC Storage, Developer 2000, Forms 4.0, 4.5 & 5.0, SQL*ReportWriter 1.0 & 1.1, Reports 2.0 &2.5, SQL*Loader, SQL*Plus 3.0 & 8.0,PL/SQL 1.0, 2.0 & 8.0, SQL*Menu 5.0.

ERP: Oracle Application 11.5.10.2, 12.1.3, 12.2.7, Oracle Application Server Tomcat, Weblogic

DBA Tools: Precise, OEM, SQL Navigator, DB Artisan, DBA Studio, Quest database suites, RMAN

Database Utilities: Awr, Datapump Export/Import, Statspack, SQL*Loader, TKPROF, Utlbstat, Utlestat

X-Windows/Term: Reflections, CRT, Putty, Terminal Service

Languages: Unix shell (sh, csh, ksh), awk /sed, SQL, PL/SQL

Sabrix Tax software: Sabrix solution, Sabrix connection AP/AR, Sabrix Reports. Thompson Reports

Vertex Tax Software: Vertex 7 and Vertex 9

PROFESSIONAL EXPERIENCE

Senior Oracle Applications DBA

Confidential, Chesapeake, Virginia

Responsibilities:

• Upgrade of Oracle Applications from 12.1.3 to 12.2.9
• Upgrade of Oracle Applications from 12.1.3 to 12.2.7
• Upgrade of Oracle Applications from 11. .1.3
• Install and Configuration of Oracle Database on Linux, HP, Solaris and Windows operating system.
• DB upgrade from 12c to 19c
• Database upgrade from 11g to 12c
• Convert non-RAC to RAC database
• Convert RAC to non-RAC database
• Improvement of overall upgrade time from 12.1.3 to 12.2.9 following best practices
• Setting up https SSL EBS URL
• SSL/Wallet setup on EBS Confidential server and renew SSL certs
• Load balancer configuration and setting up EBS to use Load balancer
• External I-supplier node configuration on External node
• EBS scale-up from 1 node to multiple nodes load balanced on a load balancer
• JRE upgrade
• Performance tuning of slow running jobs
• Troubleshoot cloning issues
• Data center migration/Tech Refresh for multiple EBS/vertex environments
• Oracle Time and Labor implementation for approximately 14,000 users
• Performance tuning of oracle ERP to support concurrent logins
• Noetix integration with EBS
• Markview integration with EBS
• Markview upgrade
• Discover integration with EBS
• Kbace integration with EBS
• ODI integration with EBS
• Vertex integration with EBS
• External node configuration on EBS 2 node
• SSL/Wallet setup on EBS Confidential server and renew SSL certs
• Cloning non-prod environments
• Performance tuning for database and ERP
• Patching Database and ERP
• Hyperian/SQR install
• Markview install
• Java upgrade on EBS
• Markview upgrade on EBS
• Implemented Data security procedures like TDE “Transparent Data Encryption” and SSL, SSH, TSL 1.2 in production, test and development.
• Upgrade vertex from Vertex 7 to Vertex 9
• Install and setup of vertex o series 7 environment
• Install and setup of Vertex o series 9 environment
• SSL setup on Vertex 7 and Vertex 9
• Renew SSL certs on vertex
• Patching Vertex 7
• Clone configuration/setup for vertex
• Vertex user setup
• Working with oracle support for Oracle Trace File Analyzer and uploading trace to oracle.
• FNDLOAD/SQL Loader to run application loads and DB loads.
• EBS scale-up from 1 node to multiple nodes load balanced on a F5 load balancer
• Oracle export and import using datapump utility
• Platform migration from HP to Linux
• Writing SQL queries for user and database monitoring and Pl/SQL blocks
• Unix scripting and schedule jobs on cron.
• Oracle Monitoring alerts setup for Database, availability, blocking locks etc
• Ship-console install and setup
• DR setup for EBS and vertex
• Oracle Database monitoring using Diagnostics and Tuning packs
• OEM Cloud Control 12c monitoring for Database, Configuration, Patch and Alerts
• Tar Management and support with Oracle via Metalink
• Strong Database design concepts for physical and logical and File system management.
• Configuration of jdbc/odbc and oracle NET connections with integration of application.
• Work with offshore teams.

Senior Oracle Applications DBA

Confidential, Chesapeake, Virginia

Responsibilities:

• Upgrade of Oracle Applications from 11i to R12.1.2
• Upgrade of Discoverer from 4i to 11g for Oracle Application R12
• Noetix Platform and View upgrade
• Automation of Oracle Application Cloning process.
• Experience includes Oracle Applications - 11.5.x (11.5.1-11.5.10 ) on HP-UX/Solaris in modules Finance/Projects
• Installed/Configured/Maintain Sabrix application, Database, Sabrix Reports, Oracle Application server and Sabrix connection from Oracle ERP to Sabrix.
• Upgraded Sabrix reports
• Database upgrade of oracle ERP from 9i to 10G
• Database upgrade of oracle ERP from 10G to 11G
• Implemented OATM on ERP
• Performed various Oracle Application system administration activities including setup of users/responsibilities, Printer, Custom Application setup, Concurrent managers, defining profile options
• Implemented Oracle Workflow Administration
• Performed Oracle Application 11i & Database cloning.
• Performed Oracle Apps & DB patching
• Oracle Application 11i Patch Management- Analysis & application of patches to both application & database.
• Experience includes Oracle Application Server - as10g (9.0.4.1 -10.1.2 ) forms, reports, discoverer, portal, sso installation, configuration & upgrades.
• Extensive uses of ad utilities like adpatch, adctrl, adrelink, adadmin, aderelink.sh, LicenseMgr, adident, adautoconfig for maintenance of Oracle application.
• Extensive Application & Database tuning for optimal performance involved setting up CBO & collecting statistics regularly, tuning init.ora parameters & kernel parameters.
• Documentation of various process & procedures.
• Lead the “Database server upgrade and consolidation project” which involved setting up 10G RAC on 2 node HP servers with VERITAS cluster manager 3.5 update 3. Implemented 10GRAC on Test/QA& Production databases.
• Setting up 9i RAC on Linux using Oracle cluster File system (OCFS)
• Involved in “Data Center Migration project” from database aspect which involved moving all databases from New Jersey to Chesapeake
• Lead the “Disk consolidation project” from database aspect for databases across the data center
• Lead the “Password Change” project and helped reduce the time taken to change password from Approx 2 weeks to 1 day.
• Lead the “Database Capacity and Trend Analysis” project for the company and came up with a no cost solution PERL was used with Oracle back end to provide database, tablespace and trend analysis reports to our clients.
• Lead the database setup, install, patch, document and manage Database project for Solvay fusion project. Solvay’s fusion project was also announced as the Top 10 Best IT projects for 2007 by IT Industry Magazine, InfoWorld
• Lead the Sanofi Reorg project which reclaimed 542GB from database and helped Sanofi client in crisis disk emergency situation.
• Establishing baseline performance parameters and implementing tuning and performance improvement measures.
• Database upgrades from 8x to 10G, 8x to 9x, 9x to 10G
• Database patches from 8.17.0 to 8.1.7.4, 9.2.0.1 to 9.2.0.5
• Database migration from UNIX to Win2000.
• Installing, Migrating, Upgrading and applying patches to multiple databases on multiple platforms
• Involved in Data Replication & Partitioning
• Database refreshes which involves copy from a production database to a test or dev database.
• Performance analysis and tuning and resolving Performance issues.
• Planning and implementing backup and recovery strategy for databases.
• Partial & Full database recovery
• Tar Management and support with Oracle Support via Metalink.
• Involved in setting up Oracle names server.
• Using Precise, Statspack, Quest, DBArtisan & Toad for Database Performance Tuning
• Created hot / cold backup scripts, export/import scripts for multiple production, patch, test, dev databases
• Provided 24x 7 On-calls DBA support.
• Creating & managing multiple databases on Unix & NT
• Training junior DBA’s and providing technical leadership in mentoring the team of database administrator.

Senior Consultant

Confidential, Reston, Virginia

Responsibilities:

• Creating and Configuring Production, Development and test Databases running 24*7 on multiple platforms especially UNIX.
• Logical and physical design of the database
• Performance tuning for an Oracle Database
• Responsible for systems analysis & design, data modeling, development of unit & system test cases
• Identifying performance problems in SQL queries in the application & providing expertise solution for tuning of problematic SQL statements
• Control user access and privileges
• Making and tuning complex stored Procedures and Functions in a short deadline period.
• Writing Cursors and Handling Errors through Exceptions
• Providing the technical assistance for the DBA and development team

Database Administrator

Confidential, Fairfax, Virginia

Responsibilities:

• Logical and physical design of databases.
• Creating primary database objects; and creating procedures, packages, functions and triggers to boost the application performance.
• Involved in installation, performance analysis, tuning, capacity planning, implementing backup and recovery strategy for application and database
• Collecting and analyzing performance data using various tools, establishing baseline performance parameters, and implementing tuning and performance improvement measures.
• Imparting training to database team on Oracle DBA, SQL, PL/SQL

Database Administrator

Confidential

Responsibilities:

• Installation and Configuration of Oracle 8.0 database.
• Creating the Database, Tables, Tablespaces and Database Objects, setting privileges, indexes user logins and defining Security strategy
• Performance Tuning & Optimization
• Train students on oracle fundamentals
• Train students on oracle SQL
• Train students on oracle database administration
• Train students on oracle backup and recovery

Database Administrator

Confidential

Responsibilities:

• Creating the Database, Tables, Tablespaces and Database Objects, setting Privileges, indexes, User logins and defining Security strategy
• Performance Tuning & Optimization
• Backup and Recovery - Physical (Hot and Cold) and Logical (Import and Export)
• Developed scripts for database backup and recovery
• Managed security for the data and users
• Installed, implemented, tuned and troubleshoot Oracle 7.x & 8.0 databases
• Provided database administration training