SUMMARY:

• Over 7 years of experience as an Oracle Database Administrator (DBA) having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management and documents.
• Extensive knowledge and experience on database administration for Oracle 10g, 11g and 12c.
• Excellent experience in installation, setup and configuration of Oracle 10g, 11g and 12c in Windows and Linux Environment.
• Experience in Oracle Database Administration in Oracle Linux environment.
• Experience in Performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK, SQL*Trace and TKPROF.
• Experience in regular Database Administration activities such as Upgrades, Migration, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning, script development, and documentation
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
• Experience in complete recovery, incomplete recovery, recovering data files, table spaces, control files and block corruption.
• Proficient with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM).
• Experience in performing Database Tuning and Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Experience in using tools like TOAD and Grid Control to monitor database performance.
• Experience in Data loading using SQL*Loader, Logical backups using full export and DATAPUMP
• Good exposure to oracle technologies like AWR, ASM, Flashback and data pump import/export.
• Having programming experience in stored procedures, functions, triggers and scheduled jobs.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Very strong in Creation, Installation, setup, Administration, Maintenance, Backup restore and recovery of Oracle database Server in Single Instance and RAC for 10g, 11g and 12c.
• Sound Knowledge in Golden gate implementation, monitoring of GG process and GG cleanup scripts.
• Good working experience with Container databases or Pluggable Databases (PDBs).
• Exposure to providing 24*7 production database support with Support to developers and end-users.
• Excellent interpersonal and strong analytical skills, Documentation and Problem-solving skills with customer service oriented attitude. A very good team player, self and highly motivated, quick learner, hungry to learn new technologies, dedicated in any work environment.

TECHNICAL SKILLS:

Programming Languages: C, C++, C#, SQL, PL/SQL, ASP.net

Database: Oracle 12c/ 11g/ 10g, SQL Server 2014/ 2012/ 2008 R2/ 2008/ 2005

Frameworks: Dot Net Framework

IDEs: Visual Studio

BI Tools: Tableau

Tools: OEM (Oracle Enterprise Manager)

Operating System: Windows, Linux

PROFESSIONAL EXPERIENCE:

Confidential

Oracle and MS SQL DBA Administrator

Responsibilities:

• Installed, configured and maintained Enterprise Manager Cloud Control to monitor and managed regular databases
• Worked on SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.
• Analyzed and troubleshot both critical and non-critical situations
• Allocated system storage and planning future storage requirements for Oracle databases.
• Monitored and tuned production environment utilizing Automatic Database Diagnostic Monitor.
• Analyzed performance Automatic Workload Repository (AWR) snapshots, Active Session History (ASH) reports and SQL Monitoring Reports.
• Provided performance review and tuned recommendations for Oracle applications.
• Performed MS SQL Server database administration, backup, restore and refresh as well as performance tuning and query optimization.
• Installed and configured SQL server 2005/2008 Enterprise and Standard editions.
• Worked on database migrations from SQL 2005 to SQL 2008/2008 R2
• Developed and implemented backup and recovery strategies and procedures, and enforced security for all of the databases in compliance with corporate standards.
• Monitored and audited the database access.
• Performed system analysis and prepare high and low level design documents.
• Ensured compliance with Oracle license agreement.
• Contacted SAP and Oracle Corporation for technical support.
• Provided 24x7 remote and onsite support for customers.

Environment: Oracle 11g, 11gR2 RAC, Red hat 6, SQL Server 2005/2008R2, Windows 2000 and windows 2008, SQL Developer.

Confidential, Sacramento, CA

Responsibilities:

• Installed, upgraded and maintained Oracle RDBMS on UNIX, Linux platforms.
• Maintained databases from all the environments from all pre-production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.
• Installed, configured and upgraded ORACLE 10g.
• Participated in System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
• Worked with lead DBAs for preparing cluster, configuring, installing Cluster ware and Oracle 10g RAC on AIX and HACMP.
• Configured, maintained and deployed the Data Guard and grid control.
• Installed and maintained Oracle GRID CONTROL.
• Configured Workload Management, JDBC, FAN, TAF, ASM and RMAN for maximum performance.
• Worked extensively on Oracle Streams.
• Troubleshot OCFS2 install issues and worked on Enterprise Manager.
• Designed and implemented auditing and other security features for the existing Production systems.
• Raised SR and TAR with Oracle Support.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Took Backup of database Logical and Physical (hot and cold) procedures using RMAN.
• Restored and worked on recovery of database in case of database crash and disk/media failure.
• Applied patches and worked on Oracle to make Application environment up to date.
• Took Backups and maintained recovery and tuned Databases Performance.
• Worked on database Designing, creation and maintenance.
• Created users and grant privileges according to the requirements.
• Provided System support for both development and 24*7 production environments.
• Prepared clear documentation on all the processes like program specification, bugs fixing logs and change requests for future reference.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.
• Designed logical and physical data models using Erwin.

Environment: Oracle 10g RAC, ASM, AIX, Linux, Windows, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, Data Guard, SQL*LOADER, Oracle OEM, Import/Export Data Pump, STATSPACK

Confidential, Piscataway, NJ

Oracle Developer/ DBA

Responsibilities:

• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Installed, configured, maintained and tuned Oracle 12c 11g and 10g.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
• Administered the production database 24*7, supported and monitored to ensure a proactive problem recognition and resolution of database issues.
• Worked on daily database administration tasks including backup and recovery through RMAN, Import/Export
• Performed data transfer using Export/Import command line as well as in interactive mode and through Data pump.
• Installed and configured Oracle Enterprise Manager Cloud Control 12c.
• Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups.
• Created and Managed Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Worked on n recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Worked on n Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Worked on Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments and Data Dictionary.
• Implemented backup strategies using hot/cold, used Exp/impon the business req.
• Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetric.
• Worked on documentation, provided documentation for database design, analysis, modifications, and creating schemas.

Environment: Oracle 10g RAC, ASM, AIX, Linux, Windows, RMAN, SQL*Plus, SQL, PL/SQL, UNIX Shell Scripting, Data Guard, SQL*LOADER, Oracle OEM, Import/Export Data Pump, STATSPACK

Confidential, Albany, NY

Oracle Developer

Responsibilities:

• Develop and provide support to all system interfaces and coordinate with all project managers to provide specifications for all core modules.
• Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
• Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.
• Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
• Evaluate all architecture for Oracle applications and prepare layouts for all logical models and maintain database objects for various application components.
• Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.
• Monitor and identify specific programming languages and recommend enhancement to all programs and evaluate all software resolution.
• Design and analyze all computer hardware, firmware and embedded systems and prepare and maintain various reports for metrics.
• Collaborate with various departments and perform research on all data processing functions.

Environment: Windows vista/7, Linux, Oracle 10g, Oracle Enterprise Manager (OEM), STATSPACK, PL/SQL, SQL*Loader

Confidential

Oracle Developer

Responsibilities:

• Perform design and development of Oracle applications according to project requirements.
• Design, code, and maintain the Oracle systems based on established standards.
• Understand project requirements and develop design specifications.
• Perform initial design reviews and recommend improvements.
• Write clear codes and prepare coding documentations.
• Provide technical assistance to other Developers as needed.
• Analyze and troubleshoot system issues in a timely manner.
• Develop Oracle reports and database procedures.
• Modify existing codes to optimize Oracle applications.
• Assist in system integration and acceptance testing and perform bug fixes less experienced staffs on programming guidelines.

Environment: Windows 2000/2003 and vista, and Linux, Oracle 9i, 10g, Oracle Enterprise Manager (OEM), STATSPACK, PL/SQL, Postage SQL, SQL*Loader