We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

Des Moines, IowA

SUMMARY

  • Around 14 years of experience in Software Design, development, Project Management and administration of production and development databases on heterogeneous operating systems Windows servers, RH Linux and Sun Solaris.
  • More than 11 years of Oracle DBA experience and 3 years of Project Management experience (6 years on Oracle 10g/11g, 3 years on RAC and 2 year on Dataguard, 6 years on Oracle 8,8i,9i)
  • Oracle Database 10g Administrator Certified Professional (OCP)
  • Oracle Database 10g Administrator Certified Associate (OCA)
  • Oracle Database 10g: Real Application Clusters (RAC) Administrator Certified Expert
  • Project Management Professional (PMP) Certified from PMI
  • Six Sigma Green Belt Certified
  • SUN Certified Java Professional (JCP)
  • Installation/Configuration and Maintenance of Oracle 11g & 10g Real Application Cluster Databases and achieving High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
  • Configuration and maintenance of oracle 11g, 10g, 9i, 8i databases and applying patches as required under Linux, Sun Solaris and Windows platforms.
  • Installing Oracle Clusterware on Windows Server, Linux environments
  • Experienced as DBA Team Leader/Manager for up to 10 members team.
  • Configured and managed physical Standby database (Data Guard) for BCP/DRP (Business continuity plan and Disaster Recovery Plan).
  • Experienced in Oracle data guard failover procedures.
  • Configured automatic storage management (ASM) to fulfill storage needs.
  • Performed Backup & Recovery (complete & incomplete) of database using hot and cold procedures and RMAN
  • Experienced in cloning databases to create staging/test databases.
  • Extensively used Data pump Export/Import in migration process and to backup databases.
  • Experienced in administering and optimizing database operations on SAN with RAID options.
  • Monitoring, Diagnosing and Tuning of database performance by query optimization and trace using utilities like Explain plan, AWR, STATSPACK, analyze TOAD, SQL Trace, TKPROF and Oracle Enterprise Manager.
  • Implemented scripts using bash, K - shell, Perl for monitoring, alerts and backup purposes
  • Writing backend procedures, functions, packages and triggers using PL/SQL.
  • Provided developers and end-users with 24/7 database support.
  • Implemented advanced features of Oracle 10g such as ADDM, AWR, Automatic Shared Memory Management, Automatic Segment Advisor, Flashback technology.
  • Experience in Designing Logical Data Modeling, System Analysis, and System Design Using Entity relationship diagrams, Data Flow Diagrams, Normalization for removing data redundancy.
  • Performed basic functions like space management, Undo segments management, invalid objects recompilation and creation of primary database storage structures (Tablespaces) and primary objects (Tables, Views, Materialized views, Indexes, Procedures, Functions, Packages and Triggers).
  • Effectively handled multiple tasks simultaneously and have ability to acquire and apply knowledge rapidly and also co-ordination with Oracle Corporation for technical support.
  • Did capacity planning, installation, upgrades of various Oracle versions, monitoring, re-organization of databases and handling large data with table and index partitioning for performance
  • Work closely with application developers, in deploying their applications as well as in managing the dependency of jobs during scheduling
  • Provide on-line oracle technical support, assist with debugging the application errors/problems and prepare the full documentation for the future analysis/reference purpose.
  • Significant experience in Government Services, Energy Services, Finance, Insurance, Telecom, Purchasing, Inventory Control and Real Estate business applications.
  • Exposure to Oracle APEX 4, Oracle ERP and SAP
  • Hands on experience on Windows and Unix servers administration.
  • Strong communication, team management and interpersonal skills. Interacting with the client and project teams to ensure issue resolution and controlling escalation.

TECHNICAL SKILLS

Programmer: UNIX-Shell, Windows batch programmer - Proficiency with awk

Databases: Oracle (11g/10g/9i/8i/7.3.4), Oracle 11g/10g RAC, Data Guard and MS SQL server

Oracle Products: Oracle Enterprise Manager, Oracle 10g grid control and SQL * Loader, RMAN, Tkprof, STATSPACK, TOAD, Developer2000, JDBC

Oracle backups: Scheduling of production database backups such as OS and RMAN backups

Operating System: Unix (Sun-Solaris 8/9, RH Linux 4/5), Windows Server 2000/2003/2008.

Hardware: Sun E15k, Sun Fire E6900, IBM RS6000, HP Super dome

GUIs & Languages: Shell Script (Bourn, Korn), PeopleSoft, PL/SQL, J2EE and Visual Basic

Modeling Tool: Erwin 3.5/4.1 /7.0 and ER Studio

ERP: Oracle Applications 11i, SAP (MM, FI/CO,PP)

Others: XML and HTML

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, Iowa

Sr. Oracle DBA

Responsibilities:

  • Supporting the test and development databases of Confidential Home Mortgage CORE Application.
  • Upgraded 10g RAC with ASM test and development databases to 11gR2.
  • Participating and monitoring in stress tests.
  • Identifying performance bottlenecks using AWR and ADDM reports and resolving them.
  • Identifying deadlocks and other lock contention issues during stress tests.
  • Extensively involved in fine tuning home mortgage application SQL’s.
  • Proactive tuning, suggesting recommendations to avoid performance problems.
  • Extensively used EXPLAIN PLAN, Auto Trace and TKPROF for query refining.
  • Analysis of Execution plans for each and every query for above application and recommending required Indexes, hints and partitioning to improve SQL query performance.
  • Worked with 10g Advisories such as SQL tuning advisor, SQL Access advisor, Undo advisor, Memory advisor, MTTR Advisor, Segment advisor and ADDM.
  • Setup, configuration and installation of the RAC environment and ASM.
  • Developed multiple automation scripts using shell script
  • Used Grid Control and OEM Tool to monitor Stress tests.

Environment: Oracle 11gR2/10g RAC, Red Hat Linux ES 5, Grid Control, OEM tools, RMAN, SQL, PL/SQL, Shell Scripts

Confidential, Philadelphia, PA

Sr. Oracle DBA

Responsibilities:

  • Planning, installing, configuring, upgrading and maintaining multiple Oracle 10g instances on Windows Servers 2003/2008 and RH Linux 4.x environment.
  • Overall database administration, monitoring and control of multiple Oracle 10g databases in BI and OLTP environments
  • Managing performance, availability, security, disaster recovery readiness to SLA requirements.
  • Benchmarking and performance tuning of Oracle database structures and applications.
  • Reviewing logical data model changes and developing physical data models with the goal of meeting performance, availability and scalability targets.
  • Windows and Linux server administration and UNIX shell scripting.
  • Disk partitioning, Apply patches, Monitoring background jobs and services in Windows servers.
  • Jobs Scheduling in Windows and Linux Servers to run daily monitoring scripts and backup scripts.
  • Liaising with client’s IT management and technical staff, and coordinating through Oracle’s TAR escalation process to secure support
  • Interacting with the client and project teams to ensure issue resolution and controlling escalation
  • Installation/configuration/upgrade of all oracle 10g/11g database systems.
  • Ensure the successful backups of databases using RMAN and participate in disaster recovery exercises to test the strategies and evaluate backups periodically.
  • Support application teams/customers for any issues with oracle database systems.
  • Setup reporting scripts for health checking of the databases and servers so that issues can be identified and fixed proactively.
  • Setting up auditing and database security as per the SOX guidelines
  • Installation/configuration and maintenance of Oracle Data Guard environment
  • Perform routine change controls to improve/break-fix the database systems.
  • Continuously monitor the system health using tools like TOAD, OEM or custom built scripts to ensure availability of all the systems including HA systems and Class 1 applications.
  • Apply quarterly security patches to all the affected oracle databases in the environment.
  • Installation, upgrade and support of CleanAddress software for address verifications.
  • Restore oracle database from backups in case of any disaster and also clone databases upon request from business or application teams.
  • Work with onsite Oracle Corporation Support for any bugs and test the solutions with application teams and apply the suggested patches to fix the issues.
  • Documentation of standards and exceptions along with daily work logs for tracking and reference.
  • Developing Adhoc reports for the management and business users.
  • SQL tuning and Oracle database performance tuning
  • Mentoring developers on database related matters

Environment: Oracle 10g, IBM x86 64 bit, Windows Server 2003/2008, Red Hat Linux ES 4, Data Guard, TOAD, RMAN, SQL, PL/SQL, Shell Scripts

Confidential, Walnut Creek, CA

Sr. Oracle DBA

Responsibilities:

  • Oracle 10g RAC design and Implementation.
  • Existing Teradata system analysis and downstream systems impact analysis
  • Hardware, Network design and procurement
  • Oracle 10g RAC build specification
  • Server setup, OS version and libraries specifications
  • Planning, installing and configuring the 4 node RAC environment.
  • Install Oracle Clusterware, database and ASM.
  • Configured automatic storage management (ASM) to fulfill storage needs
  • Developed and implemented Oracle backup and recovery methods and disaster recovery methods using RMAN.
  • Loading EPIC DDL and building necessary indexes
  • Establish effective database performance monitoring procedures.
  • Implementing the column data security using VPD (Virtual Private Database)
  • Conversion of reports from Teradata code to Oracle
  • Allocate systems storage and develop plans for future storage requirements.(Capacity planning)
  • Resolving development database requests, and troubleshooting various database issues.
  • Managing 10g RAC environments using the OEM Grid Control tool.
  • Linux administration and shell scripting.
  • SQL tuning and Oracle database performance tuning.
  • Problem solving and solution development
  • Technical assistance and mentoring the team
  • Set up and maintain documentation and standards.
  • Interacting with the client to understand the requirements.

Environment: Oracle 10g RAC with ASM, IBM x3950 M2, Red Hat ES 4, TOAD, PL-SQL developer, RMAN, SQL, PL/SQL, Shell Scripts, TKPROF, Data pump

Confidential, Atlanta

Sr. Oracle DBA / Project Manager

Responsibilities:

  • Oracle installations, administration and applying patches
  • Install, configure and upgrade Oracle database software and related products in Windows and Unix environments.
  • Create and implement Oracle backup and recovery methods and disaster recovery methods using RMAN.
  • Regular Maintenance activities (Archival & Reorg)
  • Establish effective database performance monitoring procedures.
  • Control and monitor user access to databases and maintain database security.
  • Allocate systems storage and develop plans for future storage requirements.(Capacity planning)
  • Resolving development and production database requests, and troubleshooting various database issues.
  • Managing Oracle 9i and 10g RAC environments using the OEM Grid Control tool.
  • Windows Server and Solaris administration and UNIX shell scripting and Perl.
  • Disk partitioning, Apply patches, Monitoring background jobs and services in Windows servers.
  • Jobs Scheduling in Windows and Unix environments to run daily monitoring scripts and backup scripts.
  • SQL tuning and Oracle database performance tuning.
  • Problem solving and solution development
  • Technical assistance and mentoring the team
  • Administration of automatic storage management (ASM) to fulfill storage needs
  • Design, implement and maintain Oracle high availability solutions like Oracle 10G DataGuard and RAC
  • Involved in implementing Oracle partition tables
  • Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
  • Set up and maintain documentation and standards.
  • 24*7 Production Database Support to ensure availability, efficiency and recoverability.
  • Interacting with users from various locations
  • Involved in project planning and execution using DPMM methodology and Microsoft project tool
  • Interacting with the client and project teams to ensure issue resolution and controlling escalation

Environment: Oracle 10g RAC/9i, Windows Server 2003, Sun Solaris 9, TOAD, PL-SQL developer, RMAN, SQL, PL/SQL, Shell Scripts, TKPROF, Data pump, Data Guard and RMAN

Confidential, Atlanta

Sr. Oracle DBA /Project Manager

Responsibilities:

  • Installation and administration of Oracle 9i and 10g databases in Windows and Unix environments.
  • Review existing schema/model and support for the new feed vendors in setting up physical database using ERWIN Data modeler tool in an enterprise environment.
  • Developed scripts for Data Extraction, Data Mapping and Data Conversion using SQL, PL/SQL and various Shell Scripts
  • Generated the DDL scripts for modifying the dimensions tables as well as for referential integrities and loading historical data.
  • Wrote PL/SQL stored procedures and database triggers to implement business rules and created Tables, Views and Indexes.
  • Involved in debugging complex PL/SQL code for fixing both internal and customer reported bugs.
  • Wrote UNIX shell scripts to customize the ETL process and monitor Autosys jobs for its internal site specific related reports
  • Windows and Unix administration and shell scripting.
  • Jobs Scheduling in Windows and Unix Servers to run daily monitoring scripts and backup scripts.
  • Performed SQL tuning of adhoc queries for internal business users.
  • Analyzed the table statistics and reported the problems, Helped application developers in testing their PL/SQL codes for changed policies.
  • Worked with backup team and was responsible for configuration and implementation of backup strategies using RMAN.
  • Experience in Data Modeling, System Analysis, System Design Using Entity relationship diagrams, Data Flow Diagrams, Normalization for removing data redundancy.
  • Performed Backup & Recovery (complete & incomplete) of database using hot and cold procedures and RMAN
  • Implemented best practices in data warehousing environment using Six sigma models.
  • Involved in project planning and execution using DPMM methodology and Microsoft project tool

Environment: Oracle 10g/9i, Erwin 7.0, Oracle cluster, Informatica, Unix- Solaris, Windows server 2003, TOAD, RMAN, SQL, PL/SQL, Shell Scripts, Solaris 8, Business objects, TKPROF

Confidential

Lead Oracle DBA

Responsibilities:

  • Production DBA Support - Responsible for administration of Billing and Order Management oracle database systems for 24x7 support, databases with sizes upto 15 TB.
  • Administered Oracle database installation, creation, modification and tuning issues of Oracle.
  • Configured database using latest features of Oracle 9i like Undotablespace, Locally Managed Tablespace, Sorting Parameters
  • Analyzed the database so as to allow Oracle optimizer to choose best plan in executing the queries
  • Run oracle stats pack to analyze and tune the databases.
  • Wrote SQL scripts and Unix shell scripts for DB monitoring, and online backups.
  • Creation of database maintenance plans, rebuild/defrag indexes, integrity checks on some instances that have special requirements beyond maintenance plans.
  • Point-in-time Recovery of the production databases, in the event of application failure Veritas Netbackup, recover/restore as necessary, and troubleshoot databases with data consistency .
  • Monitoring disk space utilizations, sizing, running of performance monitor SQL advisor or querying database to identify performance problems when servers experiencing bottlenecks.
  • Creation of change management documents/tickets during production change.
  • Shell scripting for automation of tasks and create databases, tablespaces and rollback segments. Involved in performance tuning issues, space management and schema changes. Creating new users and granting privileges to them.
  • Responsible for creating tables and indexes, performance monitoring of queries, tablespace allocations and data striping, and troubleshooting.
  • Checking of Alert log and Trace files to monitor the database on a daily basis. Also wrote monitoring scripts to check database and server health and scheduled using Crontab.
  • Documentation of standard maintenance operations, procedures.

Environment: Oracle 9i/8i, Sun E15K, SQL*PLUS, OEM, Import/Export, TOAD, Sun Solaris 8, and Windows Server 2003.

Confidential, Texas

Oracle DBA

Responsibilities:

  • Installing Oracle 9i, database creation, and user management
  • Install, upgrade, configure and patch Oracle database and application software.
  • Manage vital monthly updates using exp/imp and SQL Loader.
  • Performed tuning and optimization on SQL queries using Explain Plan, trace utility and TKPROF
  • Execute proper backup and restore procedures (cold and hot backups)
  • Create, maintain and troubleshoot PL/SQL objects, shell scripts and utilities.
  • Manage proprietary ER models using Erwin data modeling software.
  • Development environment creation and administration
  • Space Management and proactive capacity planning
  • Set up Client Server Environment through Net 8, space management, partitions, global and local indexes and database re-org.
  • Work closely with application developers, in deploying their applications as well as in managing the dependence of jobs during scheduling
  • Regular Tablespace management
  • Regular Development and Quality environment refresh
  • UNIX administration and shell scripting.
  • SQL tuning and Oracle database performance tuning.
  • Problem solving and solution development
  • Table and Index Partitioning
  • Database Monitoring using Oracle Enterprise Manager and custom scripts
  • Performed Backup & Recovery (complete & incomplete) of database using hot and cold procedures and RMAN
  • Offshore - Onsite coordination
  • Involved in Project Planning and Interacting with clients

Environment: Oracle 8i/9i, Sun Solaris 8, UNIX Shell Scripts, SQL*Loader, PL/SQL, TOAD, Oracle Discover and Oracle Reports.

Confidential, Denver

Oracle Developer/ DBA

Responsibilities:

  • Managing Database Structures, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
  • Developing and modifying Oracle forms and reports
  • Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export / Import utilities).
  • Sizing the database for future growth.
  • Creation of Tablespaces, Storage Allocation/De-allocation, Table/Index (with free list groups), Rollback Segments, Constraints, Roles & Privileges
  • Maintaining a Test & Development Databases.
  • Reorganization of the database to remove fragmentation.
  • Tuning & Monitoring the Database Performance
  • Developed stored procedures in PL/SQL to populate tables at runtime to generate complex reports in Oracle.
  • Troubleshoot performance issues and bugs within packages using Explain plan, trace and TKPROF.
  • Create primary storage structure and the objects, and run SQL Tuning scripts to gather performance data on sorts, gets, misses, cache hits, disk I/O activity, disk reads, etc.
  • Scheduled execution of PL/SQL Procedures using Unix Shell scripts for updating Base tables from Transaction Tables.
  • Created Materialized views to calculate aggregated data, such as a sum of monthly revenue
  • Used FTP to transfer dump files from production server to testing server.
  • Implemented the client side validations.

Environment: Oracle 8i, PL/SQL, Forms & Reports 6i, UNIX, SQL*PLUS, Toad

Confidential

Oracle Developer / DBA

Responsibilities:

  • Analysis, Conversion and Testing
  • Installing Oracle 7 and ISBS software
  • Developing test cases and Acceptance Testing Support
  • Implementation and Post conversion Support
  • Created Development, Test & Production Databases
  • Data Architect: Performed Disk layouts, capacity planning, sizing of Database objects and created Physical Database.
  • Backup & Recovery: Developed & implemented Backup procedures.
  • Updating the ERD and physical database to reflect the latest specification as per requirement of the project.
  • Identifying and resolving year 2000 date related issues.
  • Suggested the Audit & Archive process for implementation in the System.
  • Development: Written Pl/SQL Packages, Procedures, and Functions to implement Business Rules.
  • Guiding Developers in tuning SQL, suggesting the proper method of coding and explaining the Database design.
  • Mentoring Junior DBA/Developers.
  • Implemented the ISBS application with Oracle as backend in 5 different branches of BOB in Fiji Islands.

Environment: Oracle 8i viz. v8.1.7 Server, D2K, HP-UNIX, DRS 6000, Windows NT, TOAD, and Oracle Enterprise Manager.

Hire Now