We provide IT Staff Augmentation Services!

Oracle Dba Resume Profile

PERSONAL SUMMARY:

  • Over Seven years of IT experience in analysis, design, development, implementation and testing of applications. Requirement gathering and analysis, Unit Testing and monitoring, documentation and technical support, and with Medical Coding, Media and Insurance Domain knowledge. Proficient at working as a team player with an aim of contributing towards the team's success.
  • 3 years of experience as Oracle Core DBA with extensive skills on Database 10g/11g Installations, Networking, Backup, Recovery, Upgradations, Patching Cloning and 24/7 online Support.
  • 2 years of experience in designed and deployment of UNIX Shell Scripts using K Shell. Experience in DBMS Products Oracle 9i/10g/11g, MS SQL Server 2005/2008.
  • Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages , TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
  • Involved in unit testing, systems integration testing and documented the same. Proficiency on using various Oracle utility tools SQL Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL Loader.
  • Possess good communication and inter personal skills, able to adapt quickly to new technologies and environments. Oracle ddl scripts for the creation of tables, indexes, constraints, and types.
  • Oracle advanced sql using analytical functions, aggregate functions, and case statements. Oracle pl sql using cursors, for, next and open fetch loops, select into, raise application error, pragma exception in it, and autonomous transactions.
  • Used Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow. Good understanding of Oracle Data Dictionary, RDBMS and Normalization Techniques. Oracle data loading into Oracle database from flat files using SQL loader.
  • Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 8i/9i/10g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments. Detailed depth Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
  • Proficiency in Programming Languages PL/SQL and Shell Scripting. Installing RPM's and Hands on LINUX/UNIX Systems and Scheduling jobs using Crontab.
  • I'm an adaptable and efficient team player with excellent communication skills at all levels. I'm looking for a where I can develop my skills further, researching new technologies and reveling in new challenges.

KEY SKILLS

Technical Skills

Oracle PL/SQL Skills:

Backend Oracle 11g/10g/9i Database Enterprise Edition, Oracle 10g/9i Application Server Front end Oracle Developer Suite 10g/9i/2000, SQL Loader, HL 7, Web bases electronic Document, SQL Plus, FORMS Builder 6i, REPORTS Builder 6i, XML ,Oracle XE 10g/11g, Programming ORACLE PL/SQL 11g/10g/9i/8.0, UNIX K Shell Scripting, C,C , JAVA. RDBMS Oracle 9i/10g/11g, MS Access 2000/2002, MS SQL Server 2005/2000/7.0/6.5, Third Party Tools PL/SQL Developer, TOAD 8.6/7.5/7.0, Putty, Workflows , ERWin, Operating System Windows 98/2000/XP/NT, UNIX SunOS 5.7, Solaris 8, HP UX , Redhat Linux 3.0/4.0.

Oracle Database Administrator:

Dataguard, Datapump, Migration, Upgradations, Patching, Cloning, Troubleshooting, User management, Security, s, Profiles, Oracle Networking, SQL Scripting, Performance Tunning, AWR, ADDM, RMAN, Sql Loader, ASM, TKprof, Crontab, PL/SQL, Statspack, Profiles, Toad 12.x, Spotlight, Toad Data Modeler, Benchmark factory, Shell Scripting.

PROFESSIONAL EXPERIENCE:

confidential

: Oracle PL/SQL Developer

Responsibilities:

  • Worked as Oracle pl/sql Developer with the Washington Health Benefit Exchange State project.
  • Discussing New or Enhancement requirements with the business users.
  • Preparing SQL Scripts, Stored Procedures, Functions and Views to implement the Business logic.
  • Working on data fixes to correct the wrong data as per the business user request.
  • Preparing the report to find out the corrupted/invalid business data and share with business.
  • Writing Script/Procedure to fix the corrupted/in valid business data in Database.
  • Supporting the production deployment for data fixes scripts on daily basis.
  • Meeting with the Business analysts to discuss the data fix issues on daily basis.
  • Analyzing the Existing data model and modify the data model to implement the New/Enhancement business requests.
  • Creating New reports for data analysis using the Business Intelligence tool as well as Oracle database.
  • Migrating Existing data into new Source system.
  • Analyzing the gaps between the old source system and new source system and estimate the time frame to complete the gaps.
  • Involving in Code review and Unit Testing of the new development.
  • Preparing report data for validation for pre and post deployment process.
  • Coordinating with onsite team members about the New/Enhancement Requirement analysis, Design and Development.
  • Supporting off shore development team to understand the problem and the fix that is required for the problem.
  • Maintenance and support of the existing source codes and data.

Environment: ORACLE PL/SQL 11g/10g, JAVA. RDBMS Oracle 9i/10g/11g, MS Access 2000/2002, Third Party Tools PL/SQL Developer, TOAD 8.6/7.5/7.0, Putty, Sql Developer.

confidential

: Oracle Pl/SQL Developer

Responsibilities:

  • Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface i implementation and enforce security on critical customer information.
  • Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
  • Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
  • Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF..
  • Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
  • Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS. Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
  • Experience in using various oracle pl/sql collections VARRAYS, NESTED TABLE, ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
  • Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
  • Involved in migrating database from Oracle 9i to 10g database. Involved in developing screens and generating reports.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

Environment: Oracle XE 10g/11g, Programming ORACLE PL/SQL 11g/10g/9i/8.0, UNIX K Shell Scripting, C,C , JAVA. RDBMS Oracle 9i/10g/11g, MS Access 2000/2002, MS SQL Server 2005/2000/7.0/6.5, Third Party Tools PL/SQL Developer, TOAD 8.6/7.5/7.0, Putty, Workflows , ERWin.

confidential

: Oracle Developer

Responsibilities:

  • Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
  • Expertise in Client Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
  • Planned and performed the migration of all Oracle versions 9.2.0.7 to version 10.1.0 and 10.2.0, and from 10.2.0.4 to 11.1.0.7.
  • Excellent in Memory management and Performance tuning using stats pack, Tkprof and AWR reports. Used ADDM to get the useful feedback about the resource utilization and performance.
  • Worked on SQL Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections.
  • Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables. Experience in SQL, PL/SQL, Database procedures, Triggers, Packages.
  • Involved in Unit Testing Stored Procedures and Functions. Generating CSV Files and Importing CSV Files.
  • Created Materialized Views and partitioning tables for performance reasons. Worked on various backend Procedures and Functions using PL/SQL.
  • Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
  • Developed UNIX shell scripts to perform a nightly refresh of the test system from Production databases.
  • Automated data fetch using UNIX shell script.
  • Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.
  • Involved in all phases of the SDLC for Designing giving recommended approach to satisfy the requirements.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
  • Used TOAD, PL/SQL developer tools for faster application design and developments.

Environment: Operating System Windows 98/2000/XP/NT, UNIX SunOS 5.7, Solaris 8, HP UX , Redhat Linux 3.0/4.0, PL/SQL, OEM, TOAD, SQL Developer, SQL Loader.

confidential

: Oracle Dev DBA

Responsibilities:

  • Creating HL 7 files using SQL scripting and PL/SQL. Supporting Medical Coding Department, Design and implement various structures for all physical objects.
  • Creating Procedures, Triggers, and Cursors and writing Shell Scripts for loading data and Automation of Database Tasks.
  • Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008/2005/2000 and Involved in upgrading SQL Server from version 2000 to 2005, Have good experience with partitioned schemas, partitioned tables and indexes, creating File groups using SQL Server 20005.
  • Worked as an Oracle Development DBA Supporting Development Team.
  • Implementing and maintaining database security create and maintain users, s and assign privileges
  • Database tuning, Application Tuning performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
  • Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
  • Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
  • Compared schemas, databases, TNSNAMES.ora file and Tablespaces for better understanding of databases between test and production environment.
  • Unloading Databases data in to flat files and vice versa Using UTL FILE Package. Configuring Database Links, Managing Oracle Networking.
  • Performed logical backup using export and import utilities. Creating tablespaces, tables, views, scripts for automatic operations of the database activities.

Environment: RHEL, Oracle 9i, 10g, 11g, SQL, Oracle Grid Control, OEM, Database Control, TOAD, SQL Developer, SQL Loader, NT, ASM.

confidential

: Junior Oracle DBA

Responsibilities:

  • Involved in Installations, Upgradations, Patching, Cloning and Backups. Logical Backups Using Data pump utility.
  • Installation and implementation of the Oracle9i/10g on Sun Solaris Windows NT 4.0
  • Manage the database for over 10T sizes.
  • Implement the automated Hot Backup scripts for the Daily full backup created in bash Shell.
  • Ongoing proactive database level performance tuning, with a good working knowledge of Oracle internals.
  • Changes were made dynamically whenever possible to fulfill high availability requirements.
  • Maintained standby databases, in both local and remote locations, for fail over purposes.
  • Performed RMAN Incremental and Cumulative Backups, Migration of Schemas from one Database to other Databases on different Platforms.
  • Performance Tuning Using Insider Tool, Writing Shell Scripts Scheduling jobs in Linux Platforms Using Crontab.
  • Loading CSV files using SQL Loader, Creating Cursors in Stored Procedures. Creating ROW and Statement Triggers.
  • Supporting Medical Coding Department. Coordinating with Quntim Lead Project Associates for evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects.

Environment: Oracle 9i, 10g, SQL, Oracle Enterprise Manager Database Control, SQL Developer, PL/SQL, SQL Loader, NT.

Hire Now