Sr. Oracle Database Administrator Resume
SUMMARY
- Fifteen years 15+ years of IT experience.8 years of extensive experience in managing and administrating Oracle database v.7, v8x, 10g, 11g. 7 years of experience as MS SQL DBA v6.5, v7, 2000, 2005. # years experience as Project Manager.
- 10 years experience as Oracle core DBA
- 6 years experience as Oracle Application DBA R12 (Financial)
- 1 year experience of Postgres SQL
- Experienced with Operating systems Sun, HP - UX, Linux, AIX, Wintel (NT/2000).
- Experience includes full project life cycle, e-commerce and web development, application integration, custom application development and technical support in industries like Sales and Retail, Manufacturing, Financials and Telecommunications, B2B, B2C.
- Experience in client/server technology, GUI design, Relational Database Management Systems (RDBMS), and Rapid Application Development methodology using Oracle and Developer/2000.
- Experience in Design system diagrams and database architecture and data modeling.
- Extensively hands on experience with database development writing stored procedures, functions, packages, and data base triggers using SQL, PL/SQL.
- Experience in evaluating and performance testing of database applications. Implemented indexes on tables for better performances on data retrieval from oracle.
- Modified database structures including tables, views, triggers, stored procedures to support application enhancement.
- Extensively worked in the performance tuning of the programs, ETL Procedures and processes, tuning the SQL used in Transformations and fine-tuning the database.
- Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the form of flat files and load the extracted data into the new application.
- Strong writing and documentation skills for the management, development and control of documentation and Involved in the end-user training.
- Outstanding problem solving and customer focus skills.
- Excellent interpersonal and communication skills, very good team player and capable of working independently.
- Integration of ChRM, Product Hub, HR, Oracle Projects on E-Business Suite.
- Experienced on Oracle upgrade from 10g to 11g to 12c.
- Oracle application and database cloning, patching
TECHNICAL SKILLS
Platform: UNIX (Sun SPARC Solaris 8.0, IBM AIX 4.3, HP-UX 11.x), Linux (Red Hat Linux 6.2, 7.1, 7.3), Windows (95, 98, NT 4.0, 2000)
Operating System: MS DOS, Windows 95/98/2000, NT, Sun Solaris
Programming Languages: Oracle PL/SQL, SQL*Plus, Foxpro, Visual Basic, Visual Foxpro, Clipper
Database: MS SQL Server v6.5, v7, 2000, 2005, Oracle Database Server versions 7, 8, 8i, 9i, 10g,11g Personal Oracle versions 7, 8, 8i, OLAP, OLTP
Tools: Oracle Warehouse Builder 10g, Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer, T.O.A.D., SQL Loader, Visio, FTP, Secure CRT, SQL Navigator, Cognos Report 8.2, Oracle SQL Developer, Oracle Expert, SQL Analyzer, Statspack, DB Artisan, TOAD, Big Brother, Spotlight, Oracle grid control, ERWIN, HP archiving, Litespeed, IBM Data Mirror, HP Data Protector, Oracle Integration Manager, Recovery Manager (RMAN), Oracle cube, Harvest, Hyperroll, Reflection, Veritas cluster, Crystal Report, Embarcadero, Autosys, OEM 11g, Oracle E-business Suite v12.x, UNICA, EDI, COGNOS, Hyperroll, OPTIM data archiving, PGP
PROFESSIONAL EXPERIENCE
Confidential
Sr. Oracle Database Administrator
Responsibilities:
- Confidential is a prepaid mobile phone provider. A subsidiary of America Movil which provides service in the United States, Puerto Rico and United Stats Virgin Islands. Tracfone provides five brands of service: Tracfone, NET10, Safelink Wireless, Straight Talk, and Senior Value Cellphone.
- Implementation of database and/or codes releases
- Develop shell scripts for automated notification, of database monitoring and maintenance of archive logs, alerts, trace/dump files
- Automated scripts to provide reports of DDL, logins as Oracle auditing in compliance with the requirement of IT Sec and/or SOX.
- Primary responsible for capacity planning, backup monitoringManaging partition tables in various databases especially in Data Warehouse and report database.
- Managing and providing support for Oracle E-business Suite 12.1.x, applying patches in database and applications.
- Perform database refresh from Production copy to Development (database cloning).
- Perform Oracle apps database and application refresh/clone (E-business suite).
- Apply database update/upgrade, hotpatch, fix patches and upgrades of database from Oracle 10.2.0.3, 10.2.0.4, Oracle 11.0.1, 11.2.2.
- Apply application hot patches, fix, update patches for E-business suite 12.1.2
- Upgrade E-business suite - v12.1.2 to v12.1.3.
- Upgrade Database from 11g to 12c
- Manage and/or schedule jobs in cron and using Autosys for all database management jobs.
- Provide support for business users, and developers in SQL tunning best practices.
- Maintain all Oracle software and manage database service and user accounts
- Design and implement backup and recovery system
- Implement Oracle database rollout, change requests, failover
- Performs database re-organization as required to ensure the maximum uptime and performance of the database
- Develops and designs codes to manage and monitors database accounts, queries, and all activities in the database
- Established standards to ensure all application design and code are produced with proper integrity, security and performance.
- Evaluates releases of Oracle RDMBS/E-Business Suite and its tools, and third party products to ensure its running at the most appropriate.
- Implements/Enforces security for all Oracle databases.
- Creates database, business and service level users.
- Provide IT DBA documentation, Development standards, automation and project planning.
- Primary responsible in managing resources (space/capacity, performance).
- Production Oracle DBA provides database support 24/7.
- Configured Integrated SOA Gateway (ISG) on E-business Suite
- Configured SSL enabled on EBS
Environment: HP-UX v9,11.21, Oracle 10.2.0.4, Oracle 11.2.0.1, Oracle 12c, IBM Data Mirror, Oracle Database 10g, SQL*Plus, TOAD, Oracle PL SQL Developer, Cognos, Autosys, OEM, Oracle E-business Suite 12.1.2/.3, Data Protector, Embarcadero,Oracle SOA, APEX, UNICA, EDI, E-Business Suite (R12)
Confidential
Oracle/MS SQL Server DBA
Responsibilities:
- Confidential is committed to leveraging information technology, build long-term relations, deliver innovative solutions and drive customer satisfaction.
- Primary responsible for installation, configuration of Oracle 9,10g in HP-UX environment
- Maintain online service and batch processing schedules while managing and implementing required changes.
- Administering user, indexes, batch data loading
- Primary involvement in database migration from SQL Server 2000 - 2005 and Oracle 9x to 10g.
- Involved in requirement analysis, design, implementation, testing and deployment of the system
- Build up new cluster and non-cluster server
- Involved in requirement analysis, design, implementation, testing and deployment of the new system.
- Developed packages, procedures, triggers and views to bridge the gaps between the old and new application using SQL Navigator.
Environment: Windows ‘98/2000, Oracle 10.2.0.3, Oracle 9i, Big brother, SQL Server 2000, 2005, Embarcadero.
Confidential
Oracle Database Administrator
Responsibilities:
- Upgraded Data Warehouse database from Oracle 9.2.0.8 to 10.2.0.3.
- Maintain online service and batch processing schedules and managed required database parameter changes.
- Administer partitions, indexes and data batch loading
- Perform SQL tuning
- Apply Oracle database Critical Patch Updates/fixes
- Developed generation of reports related to transaction and process involved in Customer Care and Finance using Oracle Reports
- Developed stored procedures for table population to production of Active Subscriber Count Reports.
- Develop and automate backup scripts using shell scripts, RMAN and Data Protector tool.
- Populated data from table using SQL Loader to Database.
- Reviews application system to ensure compliance with standards;
- Provided postproduction support during testing and migration to production.
- Provided documentation for Oracle monitoring and maintenance standards.
- 24/7 Database Production support for all 180 Prod and Dev servers.
Environment: HP-UX v10, Red-Hat Linux, Oracle 9i, 10g, RMAN, Dataprotector, Reflection, TOAD v9, OEM, Cognos, Spotlight, Data Guard, ADM, SUN 10, Oracle Streams.
Confidential
Oracle Database Administrator/Manager
Responsibilities:
- Loans Originating System (LOS) - A web application used by Chinatrust to monitor and manage all types of loans applications.
- Installation and configuration of Oracle database, applications to DR Sites - Establishing Disaster & Recovery Sites
- Involved in requirement analysis, design, implementation, testing and deployment of the system
- Performed data analysis recommended changes to the developers if necessary for performance optimization.
- Developed Oracle programming standards and methods, modeling, administration and maintenance of development, test and production databases.
- Developed and design Disaster and Recovery Plan and administer/implemented it.
- Created new database, database Partitions, Indexes and dynamic SQLs to improve DB performance.
- Administer and automate database maintenance, backup, statistics etc.
- Generation of ad hoc reports requested by users using SQL, PL/SQL and SQL*Plus
- Checked and verified all possible performance tuning opportunity.
- Created Documentation for SQL development writing standards, optimization tips, etc.
- Post-production technical support 24/7.
Environment: Database Server Oracle9i/ 10g, Red Hat Linux 7.3, Windows 2000, PL/SQL, SQL, TOAD, and SQL*Plus, Visual SourceSafe Server (Version Control)
Confidential
Project Manager/Oracle DBA
Responsibilities:
- Performed analysis, enhancements and revisions for all Proctor and Gamble applications
- Designed system diagrams such as business process modeling, data flow, entity relationship diagram, and matrix.
- Manage database and application change requests, and revise and enhance existing modules.
- Provided technical support/solutions and troubleshoot encountered including batch jobs failed transactions, data error etc.
- Resolved problems encountered by the business users during the user testing
- Implements rollout for new system enhancements in production.
- Coordinated with other support system groups (QA, and Data Center Operators)
- Prepared program documentation including operating instructions
- Provided 24/7 production support.
Environment: HP-UX, Windows 98/2000, UNIX, PL/SQL, SQL Plus, TOAD (Tools for Oracle Application Development), Oracle 8i, 9i, Oracle Analyzer, Control-M, Harvest, Omega, Hyperroll