SUMMARY:

• Experience in 24 x 7 Production support, developing production roll scripts & maintain Shell Scripts.
• Experience Oracle Server Installation (Oracle 11g/10g/9i/8i and 8.x) on Linux.
• Performed DBA tasks like managing users and security, schema objects, such as tables, indexes, views and monitoring and tuning performance
• Supported daily production corporate Sap and non - SAP databases and worked closely with users for daily administrative tasks such as disk space monitoring, database objects creation.
• Developed, tested and performed database disaster recovery, backup strategy, database reorganization, upgrade scheduling, software installation and configuration.
• ABAP coding for SAP reports, configured for SD, MM, FI modules and job scheduling
• Installed, updated QUANTUM software for SAP application
• Extensive training courses on SAP R/3, CCMS, MM, SD, BOM modules
• Expertise in SQL tuning and creating a Modularized and Layered Subprogram (procedure, function, packages and triggers)
• Created Java stored procedure for enhance performance.
• Experience in Installing and configuring various Databases Oracle11g/10g/9i/8x and MS SQL Server.
• Well-organized and efficient professional with demonstrated skills in creativity and flexibility. Highly motivated and eager to accept challenge and responsibility, can perform well under pressure and meeting tight deadlines and able to work in weekends. Team player Good analytical, oral and written communication skills.
• Sound experienced in projects analysis, designing and development in, Health Care, Financial Manufacturing, Distribution, Insurance and Services Industry.
• Sound hand-on experienced of complete SDLC cycle, requirement gathering, technical design
• Excellent communication skills, interpersonal skills, motivated, energetic, team player with demonstrated proficiency for learning new tools and business environment with excellent Analytical skills.
• Experienced in database design and data modeling (physical and logical) using ERWIN.
• Proficient in database design and modeling for very complex application using ERWIN (Domain and Subject area more than 500 tables).
• Proficient in Reverse engineer existing physical database using ERWIN.
• Experienced Involved in Data Modeling and Database Design using ERWin & UML.
• Experience of Oracle 11g environment and documented experience in performance tuning existing applications, including use and integration of best practices to increase processing time.
• Experienced in Oracle Advanced PL/SQL APIs DBMS STATS, DBMS METADATA, DBMS GenXML TEXT IO and FTREE.
• Design & Developed OLTP and OLAP applications using Oracle with Dynamic P/LSQL
• Strong analytical, problem-solving, organizational, communication, learning and team skills.
• Hands on experience in all aspects of System Development Life Cycle (SDLC).

TECHNICAL SKILLS:

Software: SAP, MS Excel, MS Word, MS FrontPage, MS Project, MS Outlook, Visual Studio .Net 2005, Smart Draw,Photoshop CS 5, Jgrasp, Net Beans, VM Ware, Notepad++, Crystal Reports

Languages: PL/SQL, SQL XML/XDK, Shell Scripting, Java, PHP, HTML, C, C++, Pro *C, PHP,Action Script, HTML

Databases: Oracle 11g/10g/9i/ 8i/8/7.x/6.x, MS SQL Server 2005 & 2008, MYSQL, MS Access

Platforms: Linux, Sun Solaris, AIX, HP UNIX, Windows server 2008/NT/XP/98, Vista and Windows 7

Development: Developer Suite 11g, (Forms 11g/10g/9i/6i/4.5), SQL Navigator,PLSQL Developer, SQL Developer, Warehouse Builder, Java Developer,Toad 8.5, Graphvz and Informatica 8.6, Toad 11.6

Data Modeling: ERwin 7.1/4.x/3.x, UML,MS Visio, Toad Data Modeler

Power Shell: Windows Power Shell command line utility i.e. PS Scripting, SQL Server PS,General task, scheduled Sripts, Creating database tables, Invoke SQLCMD etc.

EXPERIENCE:

Confidential, Memphis, TN

Database Administrator

• Upgrade oracle database 10g to 12c on HP-UX server.
• Creating tablespaces, datafile multiple instance.
• Setup SQL trace, Monitored and tuned AppSever performance.
• Identified, resolved, or provided recommendations to other different kinds of the performance problems ranging from Database performance problems to I/O hardware performance problems.
• The tools used mainly are Savant, TKPROF, Explain Plan, and some my own scripts. T
• Setup Dev, Test, and Production environments.
• Provided Oracle database administrative supports for other different applications, CIS, BANNER and DOCUMENT MANAGEMENT SYSTEM.
• Created new databases and users, setup RMAN backups, Export, and other monitoring scripts.
• Provided 24x7 on call production support.
• Managing table spaces, data files, redo logs, tables and its segments.
• Maintaining data integrity also managing profiles, resources and password security.
• Managing Users, Privileges and Roles.
• Install Oracle software and patches.

Confidential, AZ

Database Administrator

• Installation of Oracle Applications R11.1.1 and SUSE 9 SP 3 Linux Platforms.
• Setting up of DEV, UAT, CPRD and Production Environments.
• Applied Oracle Applications and Databases patches.
• Cloning Oracle Applications and Databases between DEV, UAT, PRD and Production Environments.
• Refreshing data on cloned instance of Oracle application by cloning.
• Troubleshooting problems with web server, web listener, forms server, and concurrent managers, and database.
• Monitoring and supporting day today activities of the production and development databases
• Configuring Backup (RMAN) for database and restoring database.
• Configuring Backup for Applications and restoring Applications using Shell Scripts.
• Performed SQL tuning, application and database tuning.
• Administration of VMSERVERS.
• Writing and Testing Shell Scripts for Daily, Weekly and Monthly backups.
• Migrating custom objects between instances.
• Installing and configuring OBIEE (10.1.3.4.1 ) For Financial Reports for Performance Management.
• OMS Application is under development which is running on Oracle 10g 64bit with SSD Disk as storage.
• Cloning of SMS databases from DEV to TEST.
• Tuning Memory and Tables for DATA Migration.
• Moving Pre-Production databases from SCSI to SSD (Solid State Disks).

Confidential, Los Angeles, CA

Senior Database Administrator

• Creating and Managing 40+ Oracle databases.
• Configure Enterprise Management control for our Linux
• Create clone Oracle Instance and Databases on ASM. Perform database cloning and re-location activities.
• Managing table spaces, data files, redo logs, tables and its segments.
• Maintaining data integrity also managing profiles, resources and password security.
• Managing Users, Privileges and Roles.
• Install Oracle software and patches.
• Upgrading the 9i databases to 11gR2
• Creating Statspack report for oracle 9i version and recommendation for application developer to tune SQL statements.
• Update native compilation mode for PLSQL Objects for performance tuning in oracle 11g R2. 11g R2 has new feature Native instead of intermediate ( C Compiler ).
• Create script for Backup and recovery operation through RMAN.
• Create duplicate databases through Rman backup and configure secondary server through RMAN DUPLICATE command. Also create duplicate database from Active Database without Backup to the secondary server.
• Upgrading the Database from lower version to higher version.
• Tune SQL statement against database and its objects.
• Write script to monitor the database with shell and PL, SQL code or SQL PL, SQL code such as procedure, function, and package.

Confidential, Ogden, Utah

Senior Oracle DBA / SAP

• Installed, configured, upgraded and administrated SAP/Oracle applications for Enterprise Metadata Application
• LINUX/SAP/Oracle tech supports for all issues during the SAP /Oracle implementation.
• Experience in Oracle database design to fit the highly available and scalable environments and applications, including for SAP environment and application
• Expert knowledge and experience in Oracle database software installation, database creation, maintenance and database backup and recovery
• Experience in Oracle database performance tuning, modify configuration parameters, rebuild/redesign indexes, find IO intensive code and redesign it if possible to lower the IO to improve performance.
• Experience in Oracle database migrations
• Worked on the security and controls implementation involving all major releases of SAP including ECC 5.0/6.0, VIRSA/GRC Release 4.0, 5.0, 5.2 and 5.3 which include all this products (Access Enforcer, Firefighter, Role expert and Compliance Calibrator).
• Familiarity and hands-on experience on GRC 10.0 configuration.
• Pre and post implementation of SAP in identifying and designing control points and preparing working documents in readiness for external audit assessments.
• Established identity by use of professional knowledge and acumen in areas of SAP Security at different levels of organization.

Confidential, Pasadena, CA

Senior Oracle DBA

• Supported the implementation of the upgrade of SAP modules
• Support production, QA and test databases, large Business Warehouse on AIX p-series servers
• Provided a thorough business and technical impact analysis for new software evaluation
• Migrated, installed, upgraded, patched and maintained various Oracle database version from 8i to 11g to AIX platform.
• Presented to upper management and business user communities the technical and impact analysis of customer issues
• Administration of Oracle Database 11g rel. 2, creating logon triggers for our Datawarehouse database which has sizes from 1 terabyte to 2.5 terabyte.
• Managed Partitions for RDWP01, RDWS01 and RDWD01 Databases.
• Perform backup & recovery operation on day to day environment, capture block change for our biostat department.
• Monitor daily jobs running on our RDW server.
• Managed tablespaces, datafiles and Data guard.
• Query Analysis and testing new application through toad.
• Performance tuning, using hints, explain plan, materialized view.
• Worked on multiple databases, Database Administration, monitor Data files, performance tuning both server level and SQL level.
• Compare objects at database level, schema level in Toad.

Confidential, CA

SQL Server Analyst

• Worked with SSIS Integration services, Creating Packages with SQL Server Import and Export Wizard. Define Source and destination configuration, formatting and transformation, save and execute
• Defined server based connections to database other than SQL Server
• Imported and exported Flat files and other files
• Upgraded, managed, and migrated existing DTS 2000 packages to integration service
• Upgraded SQL Server 2005 Integration services to SQL Server 2008 Integration
• Imported data through BCP Bulk Copy command line utility. Define permissions and modes i.e. character mode, native and wide mode
• Exported data through BCP
• Created system views, catalog view, information schema views, and dynamic management view
• Created useful system stored procedures
• Worked on the server / client side installation, client configuration, and client data access technologies
• Created user administration, authentication mode, managed principles, logins, SQL server security, user/schema separation and roles
• Managed permissions, logins through SSMS and T-SQL. Managed full recovery and bulk logged recovery
• Managed Backup devices i.e. disk, tape, network shares media sets
• Configured SQL server agent
• Managed SQL server jobs, defining multiple jobs, view job history, scripting jobs and alerts
• Multiserver job management, created master server, powershell, and start power shell
• Created and modified tables, views, partition tables, function, and schemas

Confidential, Los Angeles, CA

Senior Oracle DBA

• Day to day implementation and administration of security in SAP production environment Review of critical and sensitive authorization, implementing improvement to meet audit requirements
• Performed user administration (create, lock, unlock, change and delete user account) using SU01, SU10 and SU3
• Update transactions via SU24 (managing authorization object)
• Developed, tested and performed Disaster Recovery for critical databases
• Supported production, QA and test corporate databases in various sizes from 500G to 2.5 Terabytes in multiple platforms i.e. HP, Sun, AIX, Linux.
• Provided a thorough business and technical impact analysis for new software evaluation
• Migrated, installed, upgraded, patched and maintained various Oracle database version from 8i to 11g
• Maintenance of installed Oracle Applications and supporting multiple production, development and test instances of varied complexity including multiple tier, PCP and RAC environments.
• Handling day-to-day DBA activities using Oracle utilities and tools, monitoring space and memory requirements and Memory tuning. Checking Alert Logs, Archive Logs, Trace files and to work proactively on alerts for the file system and cpu issues.
• Space management, adding datafiles / resizing datafiles, Analyzing tables and schemas Code Promotions.
• System administration activities such as creating executable, programs, request sets and attaching program to request group.
• Interacting with Functional Consultant to tune the SQL queries in Custom Applications to improve the performance.
• Application of apps and database patches.
• Oracle database upgrade from 10g to 11gR2.
• Upgrading oracle applications from 10.2.0.3 to 11.5.10.2.
• Participate in critical issue meetings, co-ordinate development efforts across all modules in e-business suite.
• Designed database schema using Erwin tool.
• Created the database schema objects like tables, views, synonyms, indexes, procedures, and functions. Written UNIX shell scripts to transform & load data from flat file to staging tables.
• Involved in the Database design and Technical Design Specifications for enhancement applications using oracle Designer 6i
• Involved in the Data modeling of ER diagrams, Functional flow diagrams, Data Flow diagrams using Oracle Designer
• Migrate data from mySQL database to Oracle 11.2gR2.
• Configuration changes which includes changes of files for various components of Oracle Applications for example database (init.ora) Apache(httpd.conf,jserv.properties,jserv.conf) and forms(appsweb.cfg).
• Cloning of Oracle Applications.
• Database backup and recovery using RMAN. Written RMAN scripts to perform automatic full and incremental backup. Tuned backup for performance by parallelizing channel allocation. Performed complete and incomplete recovery using RMAN.
• Troubleshoot problems with web server, web listener, forms server concurrent managers, workflow and database.
• Handling Discoverer issues.
• Performing of all cutover tasks needed for go-live of production instance.
• Generating tkprof Report with Explain plan for analysis.
• Installed Oracle 9i RAC in a Unix environment for multiple nodes· Configured a 10G database in a non RAC environment using Sun clusters.
• Installed 10GR2 RAC with ASM on a 4 node linux cluster.
• Designed physical and logical database using Oracle Designer9i and ERWIN data-modeling tools.
• Performance tuning of queries and cursors using HINTS, Explain Plan and TKProf and PL/SQL Developer.