I'm currently working as Oracle certified Database Consultant with experience proven oracle technical skills in database production support, analytical, development, data processing, modeling and testing. I have acquired 8 years of oracle database experience working in different environments OLTP, Data warehouse, Data Center with Oracle 9i, 10g - 11g - 11gR2 . I'm looking for a setting that I can use my technical skills to contribute toward the success and progress of the company.

QUALIFICATIONS

• Installation, configuration, management and troubleshooting Oracle databases and servers.
• Experience in Oracle database 10g, 11g on Linux, UNIX and windows DBA .
• Experience in Oracle Standalone, Real Cluster Application RAC and Data guard.
• Experience in Performance tuning Query/SQL and System.
• Backup and recovery using RMAN Or Flash recovery area.
• Data Architecture, designing and modeling
• SQL, PL/SQL and Java
• Sql Developer, Toad, and Power Designer
• Shell scripting Linux, UNIX and Windows.
• Database Data Migration, Upgrade, patching and Duplication.
• Cloning database and database refresh.
• Database monitoring and customization.
• Database securities, Authentication and Authorization.
• Automatic Storage Management and GRID Control
• Team management Technical Lead and Supervisor
• Proven ability of providing production support for 24X7 on multiple databases
• Able to remotely work from home, holidays, weekends, late nights, and extended hours.
• Expertise in data modeling and data validation of web-based applications.
• Microsoft applications Visio, word, excel, power point, adobe and more.
• Multitask, team player, good coordination and development skills.
• Effective communication, documentation and presentation.
• QA methodologies experience Agile and waterfall.

EXPERIENCE

Confidential

Oracle database Consultant

Key Responsibility

• Install, design and develop databases 11g, 11gR2 for business use
• Co-ordination, analysis and Implementation of HDS databases PROD Non-PROD
• Performance tuning query tuning, system tuning, indexing, table partitioning, compression, Outline, AWR, TKPROF, ASH, ADDM and more.....
• Troubleshooting different applications to improve performance and response time.
• Involved in SQL review and rewrite against performance tuning or to resolve database issues.
• Strong experience in oracle SQL daily sql tuning against database performance Tuning Bad Queries
• Proactively monitoring database object to detect and resolve bottlenecks
• Monitoring and supporting PL/SQL/Linux Batch jobs and processes
• Maintain and develop pl/sql for different applications
• Recompiling SQL, procedures, functions and triggers scripts
• Research on failed jobs, queries and missing data
• Troubleshooting and resolving RAC issues
• Maintaining and supporting RAC databases on different nodes
• Data migration Data pump 10g - 11gR2 .
• Data movement to test load performance for production database by using utilities like Export/Import.
• Backup and recovery maintenance with physical DBA RMAN and FRA
• Manual disaster recovery development and backup initiative
• Engage in Data replication development and implementation
• Proactively ensured database environments meet Oracle Flexible Architecture standards
• Proactively design OLTP and Data warehouse database against load capacity and performance
• Extensively use of OEM, Power Designer, Sql Developer, Sqlplus, Sql Navigator and Toad tools.
• Implementing HDS database compliance and logical and physical development.
• Supporting 100 databases with terabytes of data and over 5000 thousand of users.
• Data modeling, Data analysis and reverse engineer data structure for different applications and databases
• Supporting automatic partition maintenance
• Database architecture and providing database flow diagram process
• Data extraction for Business Objects and crystal report groups
• Data import IBMi series applications for business and clients need
• Creating physical and logical table and DDL generation for different environment.
• Ensuring regular build are accurate and promoting to QA and PRD OLTP and Data warehouse Working with various groups to promote monthly, weekly and year builds
• Group management/ Short PM Project Manager and coordination for database enhancement, migration, design and development
• Performing KT Knowledge Transfer session for Logical Physical FedEx new hires DBA's
• Onsite technical lead for 4 Offshore team in Indian
• VDI Virtual Desktop Interface coordination for my Offshore team in India
• Weekly Internal KT session with Offshore members in India.
• User management, database security and connectivity issues
• On-call database support and application help ticket issues SAS, CDC and BUSINESS OBJECT
• Hub scan extract process initial support
• Working with Logical and physical DBA, PL/SQL Developers, Java Developers and QA Group.
• Done analysis of Source, Requirements, existing OLTP system and identification of required dimensions and facts from the Database.
• Weekend on-call support for maintenance window
• ICE request process for regular build and Replay all prod changes
• Compliance control database update, assessment and implementation
• DDL generation and execution New build or Reverse Engineer
• Maintain database related policies, standards, naming conventions, operating procedures and best practices.

Confidential

Oracle Developer/ DBA

Key responsibilities:

• Planned, designed, installed, configured, and managed Oracle database 11g on Linux.
• Database performance tuning Query/SQL and system tuning.
• Implementing table partitioning, compression, store outline to improve performance, data management and day to day database monitoring
• Perform daily performance monitoring of Oracle instances on many database servers using AWR, ADDM, TKPROF, ASH, SQL TUNING and all the advisories to maintain high database performance.
• Database date modeling to establish solid data layout, design, and to enhance database performance and data architecture.
• Maintained PL/SQL stored procedures, functions, triggers, packages to maintain good database resources.
• Korn, Shell scripting as needed
• Strong experience in shell scripting
• Writing efficient coding to improve load performance in the database
• Configuring and monitoring database to detect and resolve bottlenecks and tuning poor performing SQL statement
• Troubleshooting and resolving database integrity, blocking and deadlocking issues.
• Extensively using DATAPUMP to move data and for logical backups.
• Strong experience with design, development, and testing of backup and recovery to ensure complete recoverability.
• Backup and recovery using RMAN catalog and scheduling set up of RMAN backups.
• Established backup and recovery strategy using daily hot backups, RMAN and weekly full backup.
• Configuring various RMAN parameters.
• Database duplication of using RMAN.
• Database Upgrades 10.1.0.2 Patchset to Patchset to 10.1.0.4.2/10.1.0. 10g to 11g Patchset to11g2 .
• Migrate from DB2 to Oracle
• Creating views, materialize views and other database objects
• Administering database user accounts. Create, modify and deactivate user accounts.
• Monitor user access rights by granting and revoking privileges to users and Roles.
• Monitoring user sessions and take appropriate action to kill the inactive sessions.
• Auditing the users to improve Authentication, authorization and safety management
• Customization and troubleshooting of Oracle database 10g and 11g on Linux and Windows OS.
• Monitor table spaces, memory structures, undo segments, logs and space allocation
• Managed and configure oracle database dataguard standby database .
• Install, configure and maintain RAC on 5 nodes 11gR2
• Troubleshooting RAC servers and other components CRSCTL, SRVCTL, ASMCMD and more
• Administering vote disk and cluster registry
• Troubleshoot and resolved log gap in Data Guard Configuration.
• Stimulating failover on dataguard as yearly maintenance routine and during inclement weather.
• Handling Critical, Emergency Issues in all production environments and On Call Support over the weekend 24X7 assistance .
• Provided Oracle network troubleshooting, technical and administrative duties.
• Developed and enforced database related trainings, policies, standards, naming conventions, operating procedures and best practices.
• Developed a strategic plan for the database development that supports the organizations operational requirements.

Confidential

Key responsibilities:

• Install, manage and configure Oracle database plus Mongo database.
• Develops web content and maintains the mango.org site using the content management system, including page creation and updates
• Installed and applied several Oracle critical patches
• Monitored, optimized and allocated physical data storage for database systems.
• Installed and configured relevant network components to ensure database access as well as database consistency and integrity
• Performed various RMAN, cold and hot backups.
• Created PL/SQL procedures
• Created triggers to fire before and after DML operations as needed.
• Worked on PL/SQL Stored Procedures, Functions, Packages, Package bodies, and anonymous blocks
• Troubleshoot and resolved various Oracle problems such as connectivity problems, backup and performance issues.
• Created and managed documentation on the configuration and support of the Oracle Databases
• Cluster Database Installations and Upgrades 10.1.0.2 to 10.1.0.4.2/10.1.0. 10g to11g2 .
• Performed bulk load into the database using SQL Loader
• Tuned a database and performed applications for faster and better performance also performed Goal-oriented tuning as necessary.
• Performed Oracle database Upgrade and Migration from Oracle 10g to 11g
• Managed oracle automatic storage management ASM
• Configured Real Application Cluster RAC and Data guard.
• Oracle Clusterware/Grid Infrastructure on a multi-node cluster to include Active/Passive failovers RAC software tuning.
• Managed Real application cluster RAC
• Managed RAC databases using CRSCTL, SRVCTL and grid control
• Troubleshoot and resolved log gap in Data Guard Configuration.
• Install, manage and configure oracle database data guard standby database .
• Stimulating failover on data guard as yearly maintenance routine and during inclement weather.

Confidential

Key responsibilities:

• Maintained full responsibility for Oracle 9i,10g, 11g logical and physical database design, implementation, and maintenance
• Maintained full responsibility of handling database server tuning, application tuning, maintaining documentation, capacity planning and database security. - Provided a 24/7 availability and coverage of technical assistance through the use of emails, cell
• Retrieved data from very large Database VLDB .
• Upgrade from 9i to 10g and 10g t0 11g
• Provide database administration on production, testing and development database servers.
• Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g database on Linux and Windows servers.
• Created and manipulated tables, indexes and views.
• Displayed data from multiple tables
• Worked on PL/SQL Stored Procedures, Functions, Packages, Package bodies, and anonymous blocks
• Created PL/SQL procedures and functions
• Ability to handle multiple projects with deadlines to meet SLAs and have good coordination skills with management, development teams, vendors and systems administrators.
• Worked in tandem with developers to define the overall Database design, Database modeling, and Normalization along with capturing it in the form of Entity Relationship Diagrams ERD using ERWIN and Toad Data Modeler.
• Created triggers to fire before and after DML operations as needed.
• Managed Real application cluster RAC
• Oracle Clusterware/Grid Infrastructure on a multi-node cluster to include Active/Passive failovers RAC software tuning.
• Managed RAC databases using CRSCTL, SRVCTL and grid control.
• Oracle Export and import Datapump .
• Problem identification and consulting database backups and recovery using RMAN and the application of software maintenance provided regularly by vendors.
• Implemented the use of Oracle Recovery Manager RMAN using rman catalog to back up the databases.
• Performance tuning, using ADDM, AWR, Optimizer, Explain, SQL Advisor using Enterprise Manager to tune databases.
• Member of Infrastructure team and performed Upgrade of Oracle 10gR2 to Oracle 11g and 11gR2.
• Applied quarterly Critical Patch Updates CPU and Patch Set Update on various platforms to ensure a stable and robust Oracle environment.
• Developed, implemented and performed backup and disaster recovery strategy.
• Installed and managed Oracle database using Grid and database control on 10g and 11g.
• Maintained stored procedures, functions, triggers, packages and views used by the database instance.
• Documented database structure, changes, problems, issues for future reference.
• Managed and configure oracle database dataguard standby database .
• Troubleshoot and resolved log gap in Data Guard Configuration.
• Stimulating failover on dataguard as yearly maintenance routine and during inclement weather.