SUMMARY:

• Oracle DBA and PL/SQL Developer with 6+ years of experience and Oracle APEX Developer with 3 years of experience.
• Oracle Certified Associate (OCA) Database Administrator.
• Expertise in Writing PL/SQL Stored Procedures, Triggers, Packages, Functions, Cursors, creating schedules and mail sending using inbuilt Packages.
• Experience in working with Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Proficient in logical and physical Data Modeling using normalizing Techniques.
• Developed materialized views for data replication in distributed environments.
• Experienced in building ETL scripts using PL/SQL, SQL Loader and Confidential SSIS.
• Experience with developing reports using Crystal Reports.
• Knowledge of Core Java and integrating applications on Java with Oracle backend.
• Expertise in Database Activities like creation of Databases, tables, users and maintaining security, integrity and availability of database.
• Installed, configured, upgraded, migrated and patched Oracle databases in heterogeneous environments.
• Involved in Installation, Configuration and deployment of Real Application Clusters RAC on different nodes and experience in adding and removing nodes.
• Experience in setting up and maintaining Oracle Data Guard for production databases.
• Good knowledge on Oracle ASM Automatic storage management.
• Experienced with Oracle backup and recovery by both manual and using RMAN.
• Experience with Database Upgrades and Migrations using Data Pump Export/Import and RMAN techniques.
• Experience in Shell Scripting to build automated scripts for database creation, upgrade and migration.
• Good Knowledge in Performance Tuning for Database, System and Application using AWR, ADDM, DBMS SQLTUNE, SQL ADVISOR, DBMS STATS, Explain Plan, SQL Trace, TKPROF, Query Optimizer, Execution Plans and Indexes.
• Experienced in Database and Application Support Activities which included 24*7 supports for critical applications having SLA’s of 2 hours.
• Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.
• Proficient in building web based applications using Oracle Application Express, Java Script and HTML.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, UNIX Shell Scripting, JavaScript, HTML

OS: Red hat Linux 3.0/4.0,Oracle Enterprise Linux, Windows XP/2007

Databases: Oracle 9i/10g/11g/12c, MS SQL Server 2000/2005, MS Access 2000

Reporting Tool: Crystal Reports 2003, SSRSETL Tool: SQL Loader, SSIS, Informatica

Other Tools: Oracle Enterprise Manager, Oracle Grid Control, ASM, SQL Developer, Oracle Enterprise Manager (OEM), RMAN Oracle Recovery Manager, TOAD, SQL *Loader, SQL Plus, Putty, SVN, Oracle Application Express 3.2/4.0/4.2 (APEX), WinSCP, Autosys, Remedy,Crystal Reports

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Oracle DBA, Pl/SQL Developer

Responsibilities:

• Provide database administration on production, testing and development database servers.
• Analyze the Data structure and procedures in place and suggest changes that could strengthen the security and performance issues.
• Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS.
• Improved the performance by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Set up, configured and maintained Data Guard to ensure disaster recovery, high availability and data protection.
• Switch over and Fail over between Primary and Standby whenever needed.
• Installed and manage Oracle Enterprise Manager.
• Configuring various RMAN parameters as per the requirement.
• Performing physical backups using RMAN utility.
• Performed incremental backups using RMAN.
• Extensively using DATAPUMP and Export /Import utilities for logical backups.

Oracle DBA, Pl/SQL Developer

Responsibilities:

• Created procedures and packages that could implement the role based security, hierarchical managerial information integrating it with LDAP directory
• Worked as a DBA, creating and managing the database for the application.
• Suggested some changes on the data model that helped in improving the performance of the application.
• Worked on functionality in the application which could generate a questionnaire for the customer containing questions pertaining to various aspects of migration.
• This questionnaire could be then loaded into BP to get the estimating and complexity model.
• To have this application for external use, worked on OSM.(Oracle Services Marketplace)
• Worked on building a synchronizing script between BP and OSM which were linked to the main tables down 4 levels following star schema architecture.
• Wrote UNIX Shell scripts and PL/SQL for performing development and DBA activities.
• Worked on database refreshes and patching.
• Working on automatic generated alerts, warnings and space related issues.

Oracle DBA, Pl/SQL Developer, APEX Developer

Responsibilities:

• Built a SQL Script that could analyze the source and target databases and pull information which would be useful in deciding the approach (Data pump, RMAN, TTS, XTTS, Golden Gate) feasible for migration.
• Built an APEX application around the fetched data repository which would Provide us with reports on users, tablespaces, segments etc for all the databases.
• Built shell and SQL scripts that could create target databases on which the migration technique could be applied.
• Built automation scripts that could use Data pump expdp. Impdp, RMAN technique to migrate data from one version to the other.
• Database installations and configurations, Database upgrade and migrations from Non - RAC to RAC.

Oracle DBA, Pl/SQL Developer, APEX Developer

Responsibilities:

• Maintaining and Refreshing the Database using impdp and expdp utilities.
• Building packages and procedures to support various functionalities of the application.
• The reporting functionality was implemented using APEX. Though the entire application was built on ADF, some reports were accessed through APEX. Designing and creating these reports using in built features and PL/SQL capabilities.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

APEX Developer

Responsibilities:

• Gathering the requirements and proposing the website templates on how the website should look like.
• Proposing an apt data model for the process and the levels of users and security that should be constrained on them.
• Documenting the requirements and the processes that should exist to meet the needs of the application.
• Building the application using the page templates in APEX as per the look and feel. Authentication theme integrated with Oracle SSO using the LDAP directory.
• Writing test cases and doing through the initial testing.
• Co ordinate with the users on UAT and fixing the errors.
• Creating various reports for the managers and sending these reports through email which could give them an overview of the businesses with Oracle.
• Involved in implementing the data migration activity from the tool that was previously in use to this new system.

PL/SQL Developer

Responsibilities:

• Provide day-to-day technical support in maintaining the information system, including responsibility for ensuring processes and outputs to be complete and error free.
• Develop an in-depth understanding of the business processes supported by the system.
• Consult with customers to evaluate, design, test and implement the requested enhancement to the system.
• Identify, analyze, and resolve problems in production applications independently or with the help of other stakeholders.
• Develop and maintain technical documentation and operational procedures on the system.
• Participation in all phases of application support.
• Involved in writing several Queries and Procedures.
• Build reports as per the client requirements using crystal reports.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes to cater to the change requests by the clients on the existing applications.
• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Migrating data from MS access to Oracle 10g database.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Re-worked on the BAD Files that were generated by SQL Loader.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Worked in developing SSIS packages that would push financial data from flat files to databases after necessary validations.
• Involved the splitting of two schemas in an existing database into another database. The Application schema and the data Warehouse schema needed to be hosted in two different database servers so that the performance of the application could be enhanced.
• Choosing the best option to do the same viz. Materialized Views, Procedures or Data Pump so that the objective is fulfilled with best performance and least time.
• Creation of Packages and Procedures that could push the data from one database to the other with the help of database links.
• Scheduling these jobs to populate the Data Warehouse tables daily.
• Creating views so that the Business Objects can access only the required information to generate reports.