We provide IT Staff Augmentation Services!

Senior Oracle Dba Resume

Washington, DC

SUMMARY:

  • Confidential has over 15 years of experience in relational database installation, configuration, creation, tuning, and maintenance and user management.
  • He has extensive experience as a Lead Oracle Administrator, Application/database Performance tuner, data warehouse/transaction databases and system architecture specialist.
  • Serving as the team lead for various projects and an Oracle instructor, he is excellent at assisting other members of the project team.
  • He has been involved in multiple oracle installations and upgrades.
  • He has managed, administered and coordinated complete life cycles of multiple system and applications projects in multiple industries including financial, manufacturing, music, and telecommunication and consulting.
  • Strong technical and leadership skills including working as an instructor in areas top universities.
  • (Teaching Oracle 111G DBA/Application Development) and assisting students in obtaining Oracle certification.
  • Ability to work and manage projects independently, with a proven ability to meet and exceed set goals and deadlines.
  • Work effectively with colleagues and clients at all levels.
  • Expert PeopleSoft and Oracle Apps DBA.
  • Detail oriented multi - faceted skill set, with exemplary organization and project management skills.
  • Strategic thinker and planner, skilled in the design and execution of effective IT solutions.
  • Strong skills in business process analysis, relationship development and strategic alliances building.
  • Supported Mercury Quality Center, PVCS, Arriba, See beyond, STAT, Team Track and PeopleSoft application.
  • Working experience of Microsoft SQL Server clustering, replication & mirroring.
  • Expert in RAC (Real Application Clustering) and expert in RMAN (Oracle recovery Manager)

TECHNICAL PROFICIENCIES:

Products: PIA, BEA Tuxedo, Application Servers, Confidential WebSphere5.2, Web Logic 8.1, Quest STAT

RDBMS / DBMS: Oracle 11g/10g/9i/8i/8/7.x, DB2, SQL Server

Component Interface: SQR, Business Object.

Oracle Tools: OEM, RAC, RMAN, Erwin, Export/Import, SQL*Loader, Data pump.

Languages: C/C++, JAVA, Java Script, XML, JDBC, Java, J2EE, JMS, CORBA, SOAP, ASP, VB Script, JavaScript, JBoss

Application Server: Oracle Application Server, Oracle 9i AS

Operating Systems: Linux, Sun Solaris, HP UX, AIX, and Windows 2003/XP/NT

Hardware: Sun, AIX, Digital Alpha server 1200, Compaq Server, Pentium Based servers and workstations.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Senior Oracle DBA

Responsibilities:

  • Successfully Designed, Implemented, and Administering Oracle 12c/11g R2 RAC on Oracle/Linux. Installed Oracle 11g data guard between two data centers for Disaster recovery plan.
  • Hands on experience working with Oracle 12c multitenant Container Databases (CDB) and Pluggable Databases (PDB)-unplug a PDB from a CDB and plug it back into another CDB. Working as lead Oracle DBA in OLTP/DSS environment, Oracle Fusion middleware. Involved in migration of the Oracle Warehouse Builder (OWB) to Oracle Data Integrator (ODI) 12c.
  • Backup and restore using RMAN, Data pump, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environments. Created RMAN cronjobs for backup. Expert in DSS (Data warehouse) and OLTP systems. Experience using Oracle Warehouse Builder (OWB) to build, manage and maintain data integration processes. Involved in full/incremental data load. Used Oracle Streams for table level replication.
  • Working closely with Customers, functional and Development team. Resolving day to day issues in Development/Production environment. Acting as a mentor for the oracle Developers. Involved in iterative/incremental Agile software development. Time Boxed iterative approach for adaptive planning, evolutionary development and delivery. Running jobs through Autosys. Working on Terabyte databases.
  • Applied Oracle Security Vulnerability/SQL injection patches, CPU & PSU patches. Lead the Migration activities - AIX to Linux Platform (HIGLAS) project. Designed architect layout of all servers. Changing Oracle Database character set using CSSCAN/CSALTER. Worked as Change management Admin. Implemented, Maintained, Tuning Oracle databases on Amazon Cloud (AWS).
  • Configured and Installed Oracle 11g Grid Control (Cloud Control) day to day administration, maintenance and Performance tuning. Involved in real-time data integration using Golden gate. Involved in Golden Gate installation, configuration, replication, tuning, maintenance, patching, and problem diagnosis and resolution.
  • Extensively used Oracle AWR, ASH, RDA, SQLT, RAT, ADDM, SQL Optimizer and explain plan. Performance tuned all cost intensive processes. Worked with Data Vault/ encryption. Lead DBA for Oracle Discoverer.
  • Worked as lead DBA to implement/maintain Oracle Spatial to store and retrieve geographical/location information. Creating materialized views and partitioning large tables (using Range-Hash, Range-List, Range-Range, List-Range, List-Hash) for performance improvement. Closely working with development team.
  • Supporting Teradata/Exadata prod/non-prod databases including correcting issues, supporting routine/ad-hoc change requests, creating documentation, implementing and monitoring daily/nightly maintenance jobs, and monitoring/diagnosing/responding to system failures. Improve system performance, including reducing system downtime.
  • Hands on experience working as an Oracle APPS DBA on EBS R12.2.4- Installation, cloning, patching.

Environment: Oracle 12c/11G, AIX, Linux, Sun Solaris, Windows NT server, Toad, Data Guard, RMAN, Netezza 6.08

Confidential, Virginia

Senior Oracle DBA

Responsibilities:

  • Design, test, document & implement the RMAN backup and recovery strategy for all the databases and develop scripts for seamless integration with automated backup. Implementing Oracle Internet Directory (OID) and migrating from onames to oid.
  • Implemented strategy for partitioning, compression and management of historical data tables. Experienced in Oracle Portal for building, deploying, and managing enterprise portals. Implemented new Oracle Security features.
  • Monitor system resources and estimate the hardware/software resources needed to run Oracle DB.
  • Worked with new features of Data pump to improve data import performance. Work closely with developers to design databases objects, tune SQL/PLSQL statements, and resolve data migration/import issues. Expert in PL/SQL subprograms (Procedures/Function/Packages/Triggers).
  • Expert in data migration, data load. Worked on TERA database migrations. Expert Using Data Integrator to extract data, creating staging database and using Extract/Transform/Load to populate the Target Database. Used Oracle Data Migration Assistant for migration data across databases. Managed Exadata databases. Involved in migrating, Patching, Upgrade and monitoring Exadata databases.
  • Database re-org carried out at regular intervals in order to optimize space and avoid tablespace fragmentation these includes tablespace design and management, modifying object sizes etc.
  • Installing Web logic (Fusion Middleware/SOA) and working as a support Web logic Admin. Involved in single sign-on integration between Oracle and ERP applications (PeopleSoft, SAP). Experience in Oracle Rapid - installing file system, database files, multi-node system, load balancing and shared APPL TOP.
  • System performance tuning which includes constant monitoring of the database through dynamic system, tables, oracle parameters and UNIX shell scripts. Auditing the database, tables, users, and sessions through audit utility of Oracle.
  • Automate database administrative process including job scheduling, logs, events & alerts. Proactively monitor, diagnose, and rectify database related problems.
  • Install, configure, maintain SQL server Databases. Involved in backup and database clone.
  • Installed, configured and maintain Oracle Grid Controller 12c to assist with WebLogic changes, WebLogic server cloning and server backups.
  • Expert Oracle Apps DBA-Installed/Configured Oracle HTTP Server Oracle Application Server Containers for J2EE /Oracle Application Server Web Cache/Oracle Application Server Forms Services/Oracle Application Server Reports Services/Oracle Business Intelligence (OBIEE).

Environment: Oracle 11G/10G, Linux, Sun Solaris 10, AIX, SQLPLUS, Toad, Hadoop, Oracle Apps, Oracle Rapid.

Confidential, Virginia

Senior Oracle DBA

Responsibilities:

  • Senior Oracle administrator, involved in 24/7 day-to-day administration. Responsibilities include monitoring oracle RAC databases, ASM, RMAN and Data Guard.
  • Involved in database migration across data centers.Building oracle database servers across data centers and testing failover .Involed in Oracle database and environnent setup , Installation, design, Testing, Capacity Planning , Space Management and administration. Involved in Sybase to Oracle migration.
  • Performed logical/physical database backups using various methods, including exports, data pump, cold backups, hot backups, and Oracle Recovery Manager backups. Involved in oracle partitioning and creating materialized views .Used SQL*LOADER for loader data.
  • Involved in performance tuning, Load balancing, improving data load, optimizing queries.Used AWR, ADDM, SQL Optimizer tools for performance improvment.
  • Involved in database security.Creating roles for diffèrent user groups
  • Conducted installation, configuration & administration of an Oracle 10g RAC with ASM as shared storage and SAN as shared storage sub-system.
  • Expert in oracle RAC databases ( ASM , Oracle Clusterware ). Perform RAC database upgrade and patch (All-Node Patch with minimum downtime). Responsible for adding/deleting nodes to/from existing RAC setup.
  • Tuned long running queries & queries having high CPU. Involved in monitoring and performance of batch jobs. Resolving alert log errors.
  • Re-organized heavy transaction tables and temp tables in separate tablespaces as part of database re-org to improve performance with uniform extent size and NOLOGGING for temp tables.
  • Automated Refresh of non-production databases from production environment.
  • Experienced in the development and implementation of sql/unix scripting. Expertise in SQL tuning including PlSql programming, stored packages/procedures/functions.
  • Logical and physical database/data modeling using tools designer. Apply database patches (this includes periodic CPU patches and specific problem related)
  • Setting up databases for new applications in Development, QA and Production. 24*7 on call DBA blackberry pager support. Setting up jobs through Autosys.
  • Creation and maintenance schema objects (Users, Tablespaces, Tables, Constraints, Synonyms, Sequences, Roles, Privileges and Triggers). Implementation and Scheduling of scripts for purging the old data from tables.
  • Tuning PlSql packages, procedures and functions (used for the batch jobs). Implementing DATPUMP scripts to export the data across environments.
  • Used Oracle Enterprise Manager (OEM) with Oracle WebLogic Server Management pack to diagnosis issues within Oracle Fusion Middleware server components.
  • Physical and logical designing of database with the distribution of data-files on different disks. Created and Maintained environmental documentation by updating documentation, in a timely fashion, to reflect infrastructure changes, tuning procedures, other techniques.
  • Responsible for the maintenance of installation of Oracle Identity Manager 11g create and maintain users, groups and roles.
  • Expert PeopleSoft DBA - Configuring Web logic/Appserver/Process Scheduler. Tuning SQR/People code/App Engine. PeopleSoft HR/Financial - Tools 8.5, Application 9.1

Environment: Oracle 11G/10G, AIX, Linux, Sun Solaris, Windows NT server, Designer, DBArtisan, Toad, Rapid SQL

Confidential, Washington, DC

Senior Oracle DBA

Responsibilities:

  • Installation and Configuration of Oracle 11G.Data Migration using SQL Loader.
  • Developed Database packages, procedures, functions, and database triggers.
  • Involved in Oracle database level performance tuning and backup and recovery using RMAN . Extensively used Oracle AWR, ADDM , SQL Optimizer, Explain plan for over all Database performance analyzing tables, using explain plan, adding optimizer hints, TKPROF and SQLPLUS Auto trace. Developed PL/SQL stored procedures and triggers.
  • Expert Oracle RAC (Real Application Clustering).Setting up Oracle Data Guard .
  • Responsible for CRS installation and RAC database creation, adding/deleting nodes to/from existing RAC setup, backing up restoring and multiplexing of Voting Disk and OCR files, monitoring RAC specific wait events.
  • Installation of Oracle on unix and Windows platforms. Created and configured the Instance, Tablespaces/datafiles, RBS, Schemas, Users and Roles for Development & Test database.
  • Coded conversion packages using PL/SQL stored procedures, functions and views to convert the data. SQL tuning including PlSql programming, stored packages/procedures/functions.
  • Performance Tuning, Backups and Recovery with RMAN, RAC, Security Management, Database Administration and Monitoring.
  • Expert at the installation, creation, up-gradation, configuration, administration, and tuning of multiple databases within mission-critical, 24x7 production environments.
  • Setting up databases for new applications in Development, QA and Production. Setting up traditional cron jobs for tablespace monitoring/ alerts/ exports/ hot backup and archives.
  • Helped development team in Forms/Reports errors.
  • Involved in database upgrade. Worked as a production support DBA on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular working hours. Involved in database refresh, backup, restore and recovery.

Environment: Oracle, AIX, Linux, Windows 2003 server, Forms/Reports, SQL*PLUS, TOAD.

Confidential, Virginia

Senior Oracle DBA

Responsibilities:

  • Worked as lead Oracle DBA managing multiple production/test databases . Spécialise in Oracle, Advanced PL/SQL queries, DBMS, RAC installation, Data Guard databases for multiple applications, performance tuning .
  • Involved in database installation, configuration, creation, tuning, maintenance and user management.
  • Sr. IT Specialist and responsible for supporting multiple clients for production support of Oracle databases including 3 rd party software’s.
  • Involved in supporting production/test/development databases. Responsible for refresh ing of the development databases from production database.
  • Implemented Data Guard, maintain primary and standby database.
  • Responsible for database backups and recovery as and when required including testing disaster recovery using RMAN .
  • Tuned long running queries & queries having high CPU. Involved in 24/7 monitoring and performance of batch jobs.
  • Performed logical/physical database backups using various methods, including exports, cold backups, hot backups, and Oracle Recovery Manager backups. Involved in oracle partitioning and creating materialized views .
  • Expert in PL/SQL packages, stored procedures functions and triggers.
  • Involved in Oracle 10g database level performance tuning and backup and recovery using RMAN . Extensively used Oracle 10g AWR, ADDM , SQL Optimizer, Explain plan for over all Database performance.
  • Developed and proposed new backup strategies in accordance with customer needs. Apply Oracle database releases and patches.
  • Performance analysis and evaluation of queries and Databases in a slow running application and monitoring / optimizing / tuning the performance.
  • Worked on creating troubleshooting documents for production support as reference document for other members of the team.
  • Developed and automated UNIX shell scripts to backup both logical and physical backups to tape using the OS backup.
  • Implemented materialized views in Oracle Teradata database. Worked as lead DBA in DSS systems.
  • Automated Refresh of non-production databases and PeopleSoft file system from production environment.
  • Creating new databases for new application upgrades or for new application testing.
  • Writing SQL &, Shell Scripts to automate batch jobs and performance monitoring.
  • Worked as a team member in implementing and Configuring Oracle Real Application clustering (RAC).
  • Resolve network issues for oracle databases, tnsnames.ora, sqlnet.ora, listener.ora
  • Worked extensively with PVCS - change management tool.
  • Oracle 11G instructor at George Town University.

Environment: Oracle 10/11G, HP UNIX, Linux, Sun, PL/SQL, SQL*Plus, Windows XP, NT, ERP (PeopleSoft), Oracle Reports.

Confidential, Washington, DC

Oracle DBA

Responsibilities:

  • Upgrade oracle database, expert in database tuning/space management.Upgraded databases from 9i to 10g.
  • Expert in data conversion and performance management.
  • Managing Database Structure, Storage Allocation, Building objects Table/Index segments, Views, Constraints, Database Access, Security Roles and Privilèges.
  • Tuning and running simultaneous data conversion.
  • Expert in PL/SQL packages, stored procedures functions and triggers.
  • Involved in Oracle Database refresh/clone, database creation, rman configuration, Data Guard configuration .
  • Wrote PERL scripts to run jobs through the Crontab. Developed shell scripts to execute and automate to run SQL loader & pl/sql packages and added in crontab file for daily, weekly and Monthly cronjobs
  • Applied required oracle patches and fixes. Maintenance of Oracle Databases, Capacity planning.
  • Configure production and QA databases with new performance monitor database.
  • Involved in Configuring and maintaining Oracle Real Application clusterning ( RAC ).
  • Used RMAN for oracle backup recovery/recovery and database clone.
  • Worked extensively with internal and external auditors to get Sarbanes Oxley certification.
  • Worked with Ascential ETL mappings in reference to creation of ODS and correcting errors for FSCM destructive/incrémental loads.
  • Perform Export and Import of User, Tables, Schemas and Database. Monitoring data files, archive log files space issues.
  • Meet with the customers to define requirements.Constant monitoring of database space and space management.
  • Create Partitions by range, list and Maintained Partitions, Rebuild Indexes, Coalesce tablespaces.
  • Create new oracle release demo, dev and QA databases. Also refresh of non-production oracle databases from production database.
  • Installation, configuration, managing Quest STAT for version and change management tool for PeopleSoft/Oracle applications.
  • Provide necessary training to new team members and troubleshoot issues for developers .

Environment: Oracle 9i/10G, Sun Solaris, PL/SQL, SQL*Plus, Windows 2000, ERP (Peoplesoft), Oracle Reports, Oracle Enterprise Manager Grid control.

Confidential, Virginia

Oracle DBA

Responsibilities:

  • Worked as technical Lead for oracle database upgrade, database tuning, space management.
  • Performe performance tuning at database/memory/SQL level.
  • Oracle 10g database performance tuning and backup and recovery using RMAN in RAC environnements.
  • Create Development, QA, UAT Databases for IMF Implementation.
  • Device Project Plan and Execute a Data Migration projects for migrating data from application PeopleSoft7 onto PeopleSoft8 HRMS.
  • Intégration of Development, QA efforts and Implementation into production.
  • Monitor performance and tune where appropriate using Statspack, OEM, UTLBSTAT/UTLESTAT, TKPROF, SQL Trace and the Plan table
  • Performed logical/physical database backups using various methods, including exports, cold backups, hot backups, and Oracle Recovery Manager backups.
  • Performed database refresh from global database to local development databases.
  • Responsible for applying patches to the Oracle environnements.

Environment: Oracle 8i/9i, HP UNIX, PL/SQL, SQL*Plus, Windows XP, NT, ERP.

Hire Now