Oracle Certified Database Administrator Sample Resume Format in Word Free Download

735Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Pierre Vang

Oracle 11g Certified DBA                                                                   Member Data Warehous Association            
Oracle 10g Certified DBA                                                                   Member New York Users Group
Oracle 9i Certified DBA
Oracle 8i Certifed DBA
Oracle 8 Certified DBA
Oracle RAC Certified DBA

Position Sought:  Senior Oracle Database Administrator
Immigration Status: Citizen

2015  Archar Lane, Darien MN 20151  Phone: 551-230-2520, Email: pierre.vang12@hotmail.com
^{________________________________________________________________________________________________________________}

Oracle Database Expert:

I am a well experienced Certified Oracle DBA with more than ten years of experience in supporting Production & Development databases. I am expert in database performance  tuning, administration, modeling & backup/recovery. I have clear understanding of database back-end and application front-end working as I started my career as an Oracle Forms & Reports developer. I have recently developed two applications using Oracle Application Express at Federal Reserve Bank those are running in Production.

My database strengths:

• Database Performance Tuning. Slow running Query optimization. Problem root cause analysis.
• Database design & data modeling. Creation of efficient schemas as needed by application.
• Strong in SQL, PL/SQL. Expert in writing Procedures, Functions and Packages.
• Fast database problems troubleshooting and fixes.
• Master in database backups and recovery using RMAN.
• Expert in setting efficient OLTP & Data Warehouse environments.

Certifications Online:

Oracle 11g Certified DBA                           (Oracle 11g Database Administration)

Oracle 10g Certified DBA                           (Oracle 10g Database Administration)

Oracle RAC Certified Administrator             (Oracle 10g RAC Administration)

Oracle 9i Certified DBA                                         (Oracle 9i Database Administration)

Oracle 8i Certified DBA                                         (Oracle 8i Database Administration)

Oracle 8 Certified DBA                                          (Oracle 8 Database Administration)

Performance Tuning                                             (SQL Query Tuning & Transaction Throughput)

Backup & Recovery                                 (Hot/Cold Backups, Disaster Recovery)

Database Administration                           (Database install, Management, Backup & Recovery)

Network Administration                           (Net8, TCP/IP, Client/Server, Internet directory, Security)

SQL & PL/SQL                                                    (Stored Procedures/Functions, Packages & Triggers)

PL/SQL Program Units                                          (Advanced Procedural Programming/Application logic)

Certified in Oracle Forms                           (Oracle Developer/2000, Forms 6i, Apex 4.0)

Certified in Oracle Reports                         (Oracle Developer/2000, Reports 6i, Apex 4.0)

System Administrator Solaris 8-I                 (Solaris Installation, Maintenance)

System Administrator Solaris 8-II                (Solaris Architecture, Tuning)

Data Warehousing Specialization                (Dakota State University- Data Warehouse & Mining)

Experience:

Oracle DBA - Engineer (Sept 2008 – Present)

Federal Reserve Bank of New York, Manhattan NY

   Accomplishments:

·         Working in Bank’s Proof of Concept Engineering Department to test new Oracle 11g Features. New features are then documented & implemented in Production.

·         Set up Enterpirse Manager EM12c with Enterprise Directory LDAP Authentication. Integrated Oreacle Ops Center and Oracle VM with it. It provides vision of full stack from app to disk/network.

·         Wrote complex Partitioning Procedures for Data Warehouse to partition data on daily, weekly and monthly basis. Procedures are running in all Production databases error free since Feb 2009.

·         Implemented Oracle Wallet for secure database connections used by applications.

·         Set up Software Library in Grid Control for provisioning automatic patches and software.

·         Established new rules for DBA access auditing in applications and databases.

·         Implemented Data Masking procedures in the Markets Department. It is used to mask Production data with real looking fake data, which is then used in Development environments.

·         Developed two applications using Oracle Application Express to report on Data Center Systems in real-time and other one to report all Market Applications as a Dashboard for higher management.

·         Providing Tier-3 performance tuning support of Data Wareshouse &OLTP slow query problems.

·         Upgraded Oracle 10gR2 databases to 11gR1 and then to 11gR2.

·         Implemented Oracle Grid Control 11g with Cold Failover Cluster (CFC) set up.

Technical Team: DBA Engineering Team (5), DBA Production Team (6), Informatica Developers, 4

Technology Environment: EM12c, 11gR2, Oracle 10g 10.2.0.3, Informatica, Active Data Guard, Snapshot Database, Partitioning, Oracle Wallet, Sun Solaris 5.10 boxes with Virtualization, RedHat Linux, RMAN, Oracle Application Express, Data Guard, Oracle Grid Control 10g and 11g, Oracle RAC with Data Guard

Oracle DBA - Production (June 2006 – Sept 2008)

Edison Schools, Manhattan NY

   Accomplishments:

·         Served as main Production DBA and team lead of Lawson and in-house application developers.

·         Played a vital role in company’s transition from Oracle 8i database infrastructure to 10g structure while upgrading from Lawson 7.2 to Lawson 9.0. Helped setup new Lawson supporting apps like Imagenow, Document Express (MHC), Crystal Reports and custom apps to work with Websphere.

·         Supported all NY-HQ databases along with a fleet of 517 database servers all over USA and UK.

·         Cutdown Wareshouse data availability time from 20 days to 5 days after redesigning out dated loading process. Install and tesed 11g with new features, to be considered for warehouse upgrade.

·         Regularly loaded and maintained company Oracle data warehouse in Chicago. Loaded data every two weeks from a fleet of hundreds of Postgres database servers. Optimized queries for peak run.

·         Upgraded Infra ticketing application from version 7 to version 8 running on 10g databases.

·         Successfully debugged many complex problems with legacy applications like Dynamics ERP, PowerDocs and 517 Postgres databases. Brought to live many un-supported dead legacy apps.

·         Troubleshooted and resolved many SQL Server database backup problems serving image keeping applications PowerDocs & Imagenow and company web URL filtering app Websense.

·         Resolved complex database problems logged everyday on company ticketing applicaton Infra-8 serving different front end applications like Lawson, Dynamics, Postgres, SQL Server, PowerDocs, Imagenow, custom Edison-online application (EOL), custom apps like Benchmark, Authoring, AMS.

·         Lead a team of seven developers enhancing Benchmark and Newton applications storing data in Oracle and Postgres databases.  Helped developer team in troubleshooting bugs and tune queries.

Technical Team: 3 DBAs, 6 Application Developers, 3 Business Analysts, 3 Implementation Specialists

Technology Environment: 11g, Oracle 10g, Oracle 9i, Oracle 8.1.7, Lawson 9.0 & 7.3, Lawson Business Intelligence (LBI),  Imagenow, Document Express (MHC), PowerDocs, SQL Server 2005 & 2000 databases, 517 Postgres databases running Sudent Management applications, Wensense, Toad, Dynamics ERP, Infra ticketing application, UNIX Sun Solaris 10 & 8, LINUX Redhat 2.0, Websphere Applicaton server,  Active Directory, remote VPNs, Windows 2003 & 2000 Servers, Sun-Fire-V490 .

Sr. Oracle DBA/Data Architect / (April 2005 – May 2006)

NBC Universal, Manhattan NY

   Accomplishments:

·         Successfully added five new applications in NBC new applications inventory list. Lead multiple teams of software architects/designers/developers in assisting Rational Rose DOM design to independently creating ERD models in Erwin 4.0, physical database creation in development, QA performance testing and their in time move to staging and Production.

·         Worked as Senior Data Architect with full responsibility of accuracy and robust design of database models. Assisted developers in fine tuning SQL queries for peak performance.

·         Lead a team of consultants from Mexico with migration of 45 J2EE and ETL applications from iPlanet to JBOSS application servers along with database upgrades from 8i to 9i/10g. Moved code from Cincinnati to Englewood Cliffs, New Jersey. Completed six-month project 42 days earlier than the projected date.

·         Identified and changed environment of loose security in company by identifying and changing weak passwords of 55 applications running in production. Coordinated with application owners, developers, DBAs and sever operation teams to confirm problem free change.

·         Prevented a major crise about standard process of restoring databases by finding out NOLOGGING tablespaces present in different environments including Production.

·         Configured Oracle Streams for real time update of geographically apart databases.

Technical Team: 3 Data Architect, 3 Software Architects, 5 DBAs, Support team in India 200 people

Technology Environment: Oracle10g RAC running on Redhat Linux, Oracle 9i RAC on Linux, Oracle 9i R2, Rational Rose Clearcase, Sitescope, Single Sign On (SSO), Siteminder, Kintana Ticket System, Erwin 4.0, Toad 7.3, Data Warehouse, Informatica 7.0, AS400, Legacy applications, JBOSS application server, iPlanet application server, Putty, Lotus Sametime, Control-M, MS Visio, Streams, TIPCO, Development/QA/Staging/Production environments, Performance testing /Server Engineering team

Oracle DBA- Development (February 2004 – March 2005)

Ann Taylor, Manhattan NY

Accomplishments:

• Configured a highly available “Zero down time” system by setting replication with materialized views on remote databases using database links. Created a package to update all production tables using DBMS_MVIEW. Provided detailed logging with UTL_FILE package.
• Build solid data defenses: Configured Encryption to store credit card numbers with UTL_RAW package. Improved security further by providing reverse encryption.
• Created a bullet proof secure system by creating individual users, roles and privileges. Enabled auditing on sensitive database objects by access. Scheduled systematic purging of audit table.
• Created a new production database with customized scripts. Moved data form remote databases into new environment. Supported two production, three staging and four development databases.
• Installed and configured new Oracle 10g database. Familiarized users with new 10g features.
• Upgraded old Oracle8i (8.1.7) and 9i (Release 2) database to Oracle 10g databases.
• Designed and build a snowflake data warehouse snowflake schema for sales data.
• Wrote multiple procedure to load data from different & multiple data sources into data warehouse.
• Worked with tables having 4 million to 400 million records. Tuned queries to read fast from them.
• Created portable schema generating scripts for sales representative laptops serving in the field. Created duplicate database using RMAN. Configured RMAN backups.
• Used exclusive PLSQL heavy loading features like ‘Bulk Collect’, ‘For All’ with PL/SQL arrays.
• Reduced time for data extraction and loading process from one and a half days to 20 minutes.
• Assisted in creating 10g Real Application Clusters (RAC) on windows.

Technical Team: 2 System Administer, 5 DBA, 3 Network Administrator, 12 Developers

Technology Environment: Sun E4500 Database servers running Solaris 8 on veritas cluster, Oracle 10g + Oracle 9i (Release 2) + Oracle 8i databases, TOAD 7.6, CRT 4.0, Absolute FTP, PLSQL 9.2.0, Windows XP Pro, (Databases 300 GB)

Oracle DBA - Development (July 2003 – February 2004)

Board of Education, NYC, Wall Street, Manhattan NY

Accomplishments:

• Debugged and reengineered old ETL package after consultation with users.
• Developed a new automated ETL process to load student information from a flat file. New process ran in 20 minutes whereas old process took 90 minutes. File was sent through FTP by education department each Sunday morning.
• New package included five procedures. First dropped indexes, foreign keys, truncated and modified tables. Second created temporary tables. Third ran SQL*Loader to load temporary tables from flat file. Fourth ran transformation procedures loaded data into final tables. Fifth enabled foreign keys and rebuilt indexes with some business rules.
• Installed new Oracle 9i (Release 2) database over Real Application Clusters (RAC). Started with object model and database ER diagrams. Used Erwin 4.0 following BOE admission rules for 8 and 9 grade 187,000 students studying in more than 2000 New York City Public schools. Installed
• Created double-tap ETL data entry system having 60 data entry operators for production. Created a batch process to pickup new records from a remote box and insert or update target schema in production box via a database link. Configured RMAN backups. Restored a file with RMAN.

• Performed Production and Development database tuning. Tuned application queries using bind variables. Reduced response time by 50% by optimizing SGA memory structures.
• Revised database backup procedures for exports and cold backups. Lead team of six developers.
• Installed Oracle 9iAS Application server with J2EE and Web Cache as well as Wireless, Portal and Discoverer. Deployed a J2EE application with data sources providing failover application clustering.

Technical Team: 1 System Administer, 1 DBA, 1 Network Administrator, 6 Developers

Technology Environment: Dell servers, Oracle 9i (Release 2) database, RAC clusters, Web Sphere Application Server, 9iAS, Erwin 4.0, SourceSafe, TOAD, Terminal Services Client, MS Visio, SQL*Plus/PLSQL 9.2.0, Windows 2000 clients, Java application (Databases 10 GB)

Oracle DBA-Development  (Mar 2003 – July 2003)

JPMorgan Chase, Edison, New Jersey

Accomplishments:

• Created ETL Package. Wrote Procedures, Functions and Shell scripts to load data from a feed to many tables using multiple SQL*Loader sessions. Created new logical data models using Erwin. Transformed data according to business requirements before loading into destination tables.
• Wrote API to pass discrete named parameters to be used by MQSeries adapter and Integrator.

• Setup auditing for MQSeries user so that it cannot access unauthorized objects in the database.

• Improved loading process to run in two hours rather than in four days inserting millions of records.
• Wrote user authentication package. It used complex stored procedures to authenticate users and direct them to different Chase web sites according to their security roles and privileges.
• Increased routine runtime by 450% using procedural logic, arrays and index organized lookup tables. Reduced redo size from 600MB to less than 7MB, recursive calls from 47,389 to 265 and latches from 719,802 to 45,674 only. 

Technical Team: 2 System Administer, 3 DBA, 12 Developers

Technology Environment: IBM Mainframe AS400, HP Midframe, Sun 450, Sun Solaris 8, NT4.0, Oracle 8.1.7., Oracle PL/SQL 8.1.7, Oracle Enterprise Manger, Oracle 9i, VISIO, Erwin, Lotus Notes, Oracle Reports 6i, Designer, Net8, SQL*Loader (Client/Server, Databases 50GB)

Asst. Oracle DBA (June 2001-Mar 2003)

Reliance Solutions, Manhattan, NY                

Accomplishments:

• Installed Oracle9i (9.2.0.3.0) Real Application Clusters (RAC) on Tru64 Compaq Unix servers.
• Defined resource plans using DBMS_RESOURCE_MANAGER. Created consumer groups and pending areas. Assigned plan directives to consumer groups as per their priorities. Validated and submitted plans.
• Parsed XML documents for data transformation into relational tables using XDK for PL/SQL. Loaded XML unstructured records to normalized database tables.
• Detected block corruption using different methods like DBVerify utility, ANALYZE, VALIDATE STRUCTURE command, DB_BLOCK_CHECKING parameter, data file recovery, export/import, BMR with RMAN, specially used DBMS_REPAIR for repairs.
• Configured network connections for load balancing and fail over.
• Enabled data encryption using DBMS_OBFUSCATION_TOOLKIT with DES encryption.
• Worked with Informatica Power Center 5.1 Designer, Repository Manager and Server Manager. Created new targets and sources. Created mappings. Created cubes with dimensions. Transformed ETL data using aggregations, lookups and expression operators. Moved data from source tables to target tables using concurrent and sequential batches. Created new repository for metadata with Repository Manager on UNIX server. Worked with Business Objects as user.
• Installed Oracle 9iAS Release 2 (9.0.2-OAS) Application server with infrastructure database having single sign-on and Oracle Internet Directory. Installed multiple instances of Oracle9iAS J2EE & Web Cache, Portal & Wireless, Business Intelligence & Forms, and Unified Messaging on the middle tier.  Configured physical standby database - zero loss Data Guard guaranteed option.
• Installed Sun Solaris 8 on Sun Spark machines and Windows 2000 PCs. Used different installation methods like Standalone and Web Start for Solaris 8 installation on Sun Sparc
• Added and removed software packages from Solaris Software CD-ROM and used admin tool.

• Installed, verified and removed patches. Accessed patches from World Wide Web and anonymous ftp.
• Backed up file systems on local and remote tapes. Restored file systems from tapes.

Technical Team: 2 DBAs, 7 Developers, 1 System Administrator, UNIX Sun Solaris 8

Technology Environment: Tru64 Compaq Unix servers, Sun 450, Solaris 2.6/8.0, NT4.0/Windows 2000, Oracle 8i, RMAN, Oracle PL/SQL 8.1.7, Oracle 9i, Oracle 9iAS Application Server, Oracle Discoverer, Oracle Enterprise Manger, Sybase 11.5, Java Objects, Informatica 5.1, Net8, SQL*Loader, Toad 6.1, Ftp (Databases 5GB to 50GB)

Junior Oracle DBA (July 2000-June 2001)

SmartServ Online, Stamford, CT

Accomplishments:

·         Responsible for support of Oracle database systems, including database administration activities, database performance tuning and disaster recovery.

·         Worked with Collections. Reduced DML time from 00:00:48 to 00:00:22 seconds for populating collections of thousands of rows by wisely using FORALL and BULK COLLECT INTO constructs respectively.

·         Created and used Global Temporary tables, PL/SQL tables and Reference cursors with stored procedures to output record sets for Java and PL/SQL complex processing that could not be done with SQL alone. Created and used Function based indexes.

·         Queried external data as relational tables. It helped to read Alert log file in a view.

·         Configured RMAN with catalog. Used RMAN for daily backups and restorations. Performed incomplete recovery based on time with RMAN.

·         Configured simple replication with one master site and a snapshot site. Created materialized views to be refreshed every one minute. Used logs on master site for fast refreshes and reduced network traffic.

·         Configured Advanced Replication. Ran catrep.sql. Setup master sites and master definition site. Used overwrite for column conflict resolution. Turned replication on and off occasionally. Removed replication.

·         Created Standby database for disaster recovery. Put it in managed recovery mode for automatic application of archived logs. Converted standby database in Read Only mode too.

·         Created Virtual Private Database (VPD). Wrote special packages for creating and setting Application Contexts and Security functions. Applied Security Polices using DBMS_RLS.

·         Used STATSPACK for diagnosing database performance through snapshots.

·         Wrote script for hot backup of all online tablespaces, data files, archived logs and control files using multiple cursors and variables.

·         Undid operations without going into point-in-time recovery. Used Log Miner DBMS_LOGMNR package to analyze archived logs in a specific time period.

·         Served as Reports Administrator. Developed Oracle Forms 6i & Reports 6i and deployed them on Internet with OAS (Oracle Application Server 4.0).

Technical Team: 2 System Administrators, 2 DBAs, 12 Developers

Technology Environment: HP 9000 machine clusters, Sun 2.6/8.0, NT4.0/Windows 2000, Oracle PL/SQL 8.1.7, Oracle 8i, Oracle Parallel Server, Replication Server, Oracle Enterprise Manger, SQL*Plus 8.1.7, RMAN, Erwin 3.0, Exceed, Oracle Forms & Reports (Brokerage App, DB 35GB)

Oracle Developer/Asst.DBA - Development (Feb 1999-July 2000)

Bell Atlantic (Verizon): ECS Dept., Manhattan, NY

Accomplishments:

·         Designed new reporting system with Oracle Developer/2000 Forms & Reports. Created forty-five forms and sixty-eight reports configured for client/server environment.

• Used Oracle Forms 4.5 and Reports 2.5 to convert character applications to easy to use GUIs.
• Increased Data Dictionary hit ratio from 55% to 95%.
• Improved sluggish database performance by taking time-sliced picture of the database using UTLBSTAT and UTLESTAT while 2000 users were running 500 transactions per minute. Used SQL TRACE files and TKPROF to knock down biggest resource consumers.

·         Enhanced Buffer cache hit ratio by 20%. Cached lookup tables into the buffer for performance. Configured multi-part Keep and Recycle pools for distinctive object sustenance and flushing.

• Removed waits on Redo logs. Improved performance by changing redo log sizing and log switching strategy for online website.
• Detected and repaired chained and migrated rows. Adjusted percent free value for blocks.
• Increased memory sorts by reducing disk sorts to less than 10%. Modified sort initialization parameters according to business sort requirements.
• Removed extensive wraps and extends on Rollback segments. Tuned Rollback segments to appropriate size and number.

·         Resolved lock contention by detecting and modifying long running queries holding locks and applications explicitly locking objects.

• Cleaned machine thoroughly after abortive installation. Uninstalled software, cleared registry entries, services, environment variables and manually removed files and directories.
• Enabled auditing for a suspicious user by access. Monitored activity starting from logon to logoff.
• Created automated primary key generation using Sequence and appropriate triggers.
• Developed data models for new business functions. Designed Entity Relation Diagrams explaining full relationships between different entities. Used Designer/2000.

Technical Team: 2 DBAs, 3 Developers, 1 System Administer

Technology Environment: Sun 450 machines, NT4.0, Oracle 8, Oracle 8i, Oracle PL/SQL 8.1.5, Oracle Enterprise Manger, Oracle Forms 5.0, Oracle Reports 3.0, Erwin 3.0, Crystal Reports, SQL Server 7.0, Net8, SQL*Loader, TKPROF, ODBC (Client/Server Oracle Application, Database 45GB)

Skills & Education:

Oracle Instructor (Part time: 1999-2002):         

Netcom Info Institute, Empire State Building (2/2002), (Oracle 8i & 9i Database Admin course)

Skidmore College, White Plains, NY (01/2000-03/2000)(Oracle 8 Database Administration)

Access Institute, Queens, NY, (09/1999-10/1999)(Oracle 8 Database Administration)

Programming Languages:      

PL/SQL, SQL, C++, Visual Basic, ASP, PSP, XML, Java, JavaScript, 

L, Shell scripting

Applications & Operating Systems:

Oracle Databases from 8 to 11g, Application Express 4.0, Enterprise Manager, Toad, Grid Control 11g & EM12c, RMAN Recovery Manager, Exceed, Oracle Streams, LDAP Authentication, Active Data Guard, Snapshot Database, Data Guard with Standby, Oracle Partitioning in 11g, Oracle Wallet, Encryption, Grid Control Provisioning for automatic Patches, Sun Solaris 8-10, Redhat Linux Enterprise 5, Windows 2000/XP to Windows 7

Education:

Masters Degree, SBC, Preston University, Pakistan
Bachelors, Punjab University, Pakistan

Course: Modern Database Management, Dakota State University USA          (Grade: A+)

Course: Data Warehousing and Data Mining, Dakota State University USA    (Grade: A+)

Course: Managing Information Technology, Dakota State University USA      (Grade: A+)

Course: Developer/2000 Tools, Oracle Institute, Pakistan

Course: HTML Web Design, Art Net School, New York, USA

References: 

Available on request

Download Resume Format