Professional Summary:

• Excellent programming skills in PL/SQL and SQL tuning techniques.
• Experience in Oracle Enterprise Manager OEM for databases monitoring.
• Experience in Installing, Configuring, Maintaining, and Upgrading oracle database 9i, 10g, 11g.
• applications with various development tools and languages.
• Skilled in designing and implementing complete life cycle client servers and database
• Over 5 years of experience in RAC, ASM, and Flashback.
• Over 9 years of experience as DBA in development and production environment.
• Performed regular backups and ensure oracle database system operate efficiently and securely.
• Manage internal databases, from planning and testing stages through implementation and support.
• Adept in using Data pump, Export and Import utilities for exporting databases or schemas to refresh non production databases for day to day activities
• Working experience in implementing oracle Data guard technology for Failover and Disaster recovery solutions for High availability.
• Working experience in diverse stages for software development such as application development, middleware administration, RDBMs design, and DBA.
• Familiar with software development life cycle.
• Easily adapts to new roles, great learning ability, responsibilities and environments.
• Excellent learning ability and able to implement cutting edge technology.
• Outstanding interpersonal skills and problem solving sill. Work well with all levels of business.

Skills Summary:

• Database Oracle 9i/10g/11g, MySQL, SQL server
• Operating Systems UNIX, LINUX, MAC, WINDOWS
• IDE Eclipse, MyEclipse, Lomboz Eclipse, NetBean
• Version Control SVN, CVS, Mercury
• Languages Java, J2EE, SQL, PL/SQL, PostgressSQL, C, C , HTML/XML, JavaScript, JSF, JSP, JDBC
• Others Oracle Goldengate, SQL Loader, SQL Navigator, Golden Gate, SSH, Apache, WebSphere Application Server, Dreamweaver, Visual Studio 2005, 2008, 2010, Image and video processing, Computer hardware

Professional Experience:

Confidential

Senior DBA

Responsibilities:

• Implementing and supporting Oracle, Oracle RAC, and ASM.
• Understanding and applying advanced database administration and management techniques using Oracle Enterprise Manager.
• Actively involved in Installation, Creation and Maintenance of Oracle DB 11gR2 RAC.
• Migrate database to ASM storage and implement RMAN backups.
• Disaster Recovery for Oracle Database environments using Dataguard
• Installed RAC 11g on 3 node cluster for large production system
• Upgrade Oracle 10.2.0.2, 10.2.0.4 and ASM to 11gR2.
• Managing tablespaces, user profiles, indexes, storage parameters.
• Monitor the instance and plan for future availability of storage on user's tablespaces.
• Backup and Recovery strategies for Oracle database using RMAN, Datapump utilities, cold and hot backups.
• Monitor Database performance using advanced tools like ASH, AWR and ADDM reports
• Implemented Oracle Flashback technologies in 11gR2 , automatic UNDO management
• Implemented Database auditing to audit DBA access to the database and monitor activity on critical HR tables
• Involved in database refresh procedures for copying production database to Development and Test environments
• Assist developers in SQL tuning, creating necessary indexes and apply SQL Profiling where necessary.
• Using Shell scripts to automate database monitoring and send the alerts to DBA Team.
• Participate in Database auditing, apply patches and follow documented procedures

Environment: Oracle 10g/11g, Java/ J2EE, Net Beans, JDBC, XML, IBM AIX, Linux, Windows, SQL Developer, SQL Loader

Confidential

Oracle DBA

Responsibilities:

• Application development support for all the applications running against development and Production servers.
• Creating primary database storage structures Tablespaces , altering according to the companies requirement, Modifying the database structure, as necessary, from information given by the application developers.
• Creating Nonstandard Block Size Table space.
• Regular Monitoring Alert log Files on Day to Day Basis and Monitoring and Reorganizing Table spaces/Tables/Indexes.
• Performed various routine DBA tasks like Table space Management, Alert Logs UNDO-Table spaces and Temporary TS etc.
• Creating Users, roles, profiles and Auditing of Users according to the application.
• Develop, implement and test Backup and recovery strategies for development databases.

Environment: Oracle 10g/11g, WebSphere application server ND, IBM Http Server, Java/ J2EE, Eclipse, JDBC, XML, TOAD SQL Developer, MS SQL Server, Solaris 5.9/5.10, Linux, Windows

Confidential

Oracle DBA

Responsibilities:

• Table space administration, handling Next extent and Max extent.
• Writing SQL/PLSQL scripts for automate many daily processes.
• Daily system monitoring and performing Health checks as preventive steps to keep the system up and running.
• Maintaining the statistics of the Health Checks for analyzing the system performance as a preemptive measure.
• Row level column level Security control for views using Oracle policies.
• Developed the shell scripts that call the Perl program for importing the data from flat file into temporary tables, procedures for validating the data in temp tables.

Environment: Oracle 9i/10g, Java/ J2EE, Eclipse, JDBC, XML, Linux, SQL Server, SQL loader, Solaris 5.9, Linux, Windows , Mac

Confidential

Oracle DBA

Responsibilities:

• Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
• Responsible for Oracle 10g logical and physical databases design, implementation, and maintenance
• Reorganized databases and sized database objects to meet standards and improve performance
• Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support

Environment: Oracle 9i/10g, Java/ J2EE, Eclipse, JDBC, XML, IBM AIX, Linux.

Confidential

Oracle Developer / DBA

Responsibilities:

• Provided administrative support in UNIX environment.
• Provided primary administrative support for Oracle 9i/10g databases in UNIX and NT environments.
• Migrated SQL and patches, refreshed development and test databases. Created domains, configured AppServer, setup Process Scheduler.
• Participated in the design, analysis and implementation for the engineering database system.
• Installed upgraded and patched Oracle software and associated applications.
• Managed and resolved design issues during development stage. Worked closely with developers.
• Moved database Schema changes to stage or production.
• Developed Oracle backup and recovery strategy and scripts.
• Implemented database refresh using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using Oracle Enterprise Manager.
• Created Unix Shell scripts to automate database operation.

Environment: Oracle 8i/9i, Java/ J2EE, Eclipse, JDBC, XML, Solaris, Linux, Windows