SUMMARY

• Over 12 + years of experience in Software Industry with 9 years of experience in Oracle 11g/10g/9i/8i Database Administration on AIX/Unix/Sun Solaris/Windows platforms in ensuring quality, integrity and availability of the company’s data within oracle servers. Experienced in RAC.
• Strong experience in Oracle DBA tasks like Installation, creation, maintenance, performance tuning, problem identification, resolution and migration in production and development environments.
• Well versed with Database Administration, Cloning Databases, Physical/Logical Standby Database, Backup and Recovery strategy using Hot Backup, User Managed and RMAN.
• Designing Database, tuning the Database, Database Security & Assigning the Roles, Profiles and Privileges to the various Users on Objects and Optimization by Explain Plan and SQL TRACE facility, Used other utilities like AWR, Statspack, and TKProf.
• 24/7 support for Production databases and responsible for round - the-clock database operations. Offered solutions for Production/Development of database applications and ensured customer satisfaction as the prior important.
• Administered Voting Disks and Services, Configured channels for Recovery Manager, Administered Cluster Registry, Managing Backup and Recovery in Oracle Real Application Cluster (RAC)
• Administered Disk groups and Instances in Automatic Storage Management (ASM).
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Restored tables, schemas in test environments from export backups based on business requirements.
• Enabled Trace for specific user. Refreshed databases. Used expdp and impdp (Datapump).
• Leadership skills and Goal Oriented, Good Communication and Co-operation with the Teams, Management and Customers. Adept at learning and adaptable to complex work environment.
• Worked as a Lead for DBA team consisting of seven DBA’s
• Proven record of success in business development, operations, client management, benefit administration and project management
• Exceptional leader selected to participate in work-based mentoring program
• Completed a detailed course in Project Management (including LEAN Six Sigma Green Belt) at Rutgers University

TECHNICAL SKILLS

Databases: Oracle 11g, 10g, 9i and 8i

Tools: Oracle Enterprise Manager, SQL*Plus, STATSPACK, DBMS Packages, Export/Import, Datapump, SQL*Loader, RMAN, Logminer, BD Artisan, Oracle Fail Safe Manager, 3.3.2, Oracle Designer2000, PeopleSoft, OEM, OAM, Oracle Data Guard, Oracle Universal Installer, Oracle Configuration Assistant, BMC patrol, Power Builder, PL/SQL, Erwin3.5, Toad, Tivoli Storage Manager, 4.2.1, Tivoli Data Protection, 3.3.2. and Veritas Volume Manager, HP Open View, Big Brother, Jobit and Logit.

Operating Systems: Sun Solaris 10,8/7 Aix 5.3/5.2/4.3, Redhat Linux AS 4/2.1, HP UNIX 11/10 and Windows.

Languages: C, FoxPro 2.6, SQL, PL/SQL, UNIX Shell Scripting, SAS, OS/MVS JCL, SQL, COBOL I and II, DB2, Visual Basic.

Data Storage: Veritas Volume Manager (VVM)

Hardware: IBM 3090, IBM 3270 IBM PC, HP-UX 11.11; Hardware HP-UX Sparqnet servers (HP RP5470), Windows NT &Windows 2000 server

Methodologies: Rational Unified Process (RUP), Waterfall Method

Microsoft Tools: MS Word, MS Excel, MS PowerPoint, MS Access, MS Visio, MS Project Servers, Windows SharePoint Services.

Concepts: Problem Analysis, Structured Programming Design & Techniques, Debugging, Database & File Manipulation, Table Handling

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Senior Database Architect

Responsibilities:

• Installed cluster binaries 11.1.0.6.0 using shared file system on SUN servers
• Installed 11.1.0.6.0 Oracle RAC database software to implement Applications on sun4u machines with Solaris 10 operating system.
• Successfully led the migration team with database and application teams.
• Installed 11.1.0.6.0 version Oracle Binaries on CRS cluster 11.1.0.6.0 supported by raw devices with ASM and created related Disk groups in support with the Engineering team.
• Performed Oracle CRS and Database Binaries upgrades from 11.1.0.6.0 to 11.1.0.7.0 for TMO.
• Implemented Flashback database and Flashback concepts as per the requirements..
• Planned and configured Automatic Memory Management.
• Implemented BCTF to fine tune backup window.
• Estimated the size of the FRA during configuration of FRA.
• Implemented Datapump and RMAN to migrate data from PROD to other environments
• Designed backups using RMAN and Datapump, and implemented RMAN compression for space optimization.
• Configured standby database and tested RTO for switchover and failover scenarios.
• Designed the procedures, developed the scripts and implemented processes for DR test from tapes at the DR site.
• Monitored production and non-production database through Grid Control, Optimize queries, startup, shutdown and configure agents to communicate with grid control for various different maintenance tasks.
• Performance Tuning of Applications/Databases using various Oracle tools like SQL trace, TKPROF, Explain Plan, AWR, ASH and ADDM.
• Worked closely with application developers and system administrators to ensure all database needs are being met.
• Documented Tech Specs for the proposed data base design.

Confidential, Manhattan, New York

Senior Database Administrator

Responsibilities:

• Support more than 30 Oracle 10g RAC/ASM, 9i database instances as primary DBA (PROD/DR/QA/DEV). Provide 24x7 support for Production databases.
• Install and upgrade Oracle software using OFA structures. Applying patches and bug fixes.
• Create new Oracle databases using DBCA or database scripts. Creating new ASM disk group or raw devices for RAC DBs.
• Manage both OLTP and data warehouse databases that have more than a thousand of concurrent user sessions and over terabytes of data.
• Creation of different DBA/APP/USER schemas and setup proper user profiles. Grant/revoke certain sys/object privileges to meet bank security and audit requirement.
• Build/Repair Standby databases/Data Guard using RMAN restore and duplicate command.
• Perform Oracle performance tuning and monitoring using Oracle OEM/AWR/Quest tools.
• Recover user errors using both Oracle Flashback based recovery and also time based incomplete recovery by applying archived redo logs from the Veritas Netbackup tapes.
• Migrated Automated and Monitoring jobs from CRON TAB to AUTOSYS jobs to perform RMAN database disk and Netbackup tape backup.
• Implement systems with 24x7 high availability using different methods including Oracle RAC/Standby/IBM HACMP and EMC SRDF.
• Work with developer in designing database tables, partitioning/indexing, developing PL/SQL stored procedures, triggers and performing queries optimization.
• Troubleshoot DB issues and provide immediate response for critical Production databases. Reach out to Oracle technical support through Metalink and service request TARs.
• Tune SQL slow statement by collecting/setting cost based optimizer statistics and also using hints to accommodate some particular queries.
• Implemented Data pump to replace EXP/IMP.
• Set up and maintain company standard db scripts and documentation for new Oracle databases build.

Confidential, NY

Senior Oracle Database Administrator

Responsibilities:

• Involved in development of FNX application at all stages including data modeling and deployed FNX application to the Production.
• Installation and configuration of Oracle Real Applications cluster (RAC) 9.2.0.7. Used shared file system to support nodes in the cluster.
• Implemented DBCA to build Real Application Cluster (RAC).
• Configuration of system to achieve High Availability, Load balancing.
• Partitioned some of the large database tables.
• For better performance of the System implemented stripping at storage (EMC) level and Operating System level.
• Implemented RMAN Backups, Creation of catalog database, Developed RMAN scripts and tuned various parameters. Developed the scripts to monitor multiple databases and generate reports from single server.
• Extensively worked on OEM (Oracle Enterprise Manager).
• Performed Cloning and data refresh from Prod to QA and DEV databases.
• Data Migration from AS-400 system to Oracle 9.2.0.5.
• Involved in resolving database and application problems. Highly experienced in troubleshooting problem queries that take long.
• Implemented the database tuning to improve the performance of the database using the Perfstat package and DBMS.STATS Pack.
• Migration from 8.1.7 to 9.2.0.5.
• Implemented Standby Database for all the Production databases.
• Developed the Structure of Tablespaces and planned the data distribution for the FNX application.
• Erwin tool was used for some of the databases for data modeling.

Confidential, Moline, IL

Database administrator

Responsibilities:

• Installed the Oracle 8.1.6/8.1.7 RDBMS on servers and configured the databases for Client/Server architecture.
• Involved in Technical Requirement Analysis for various systems and Review Project Documents with Client.
• Designed and managed all aspects of development, test and production databases.
• Configuring the Oracle Networking environment using Oracle Net and Net8.
• Migrated Oracle database 7.x.x to 8.1.7.
• Developed the scripts for Hot and cold Backups.
• Performed Backups using RMAN.
• Performed Oracle Database Cloning from Production to Test and Development databases as per client requirements.
• Implemented the database tuning to improve the performance of the database using the Perfstat package.
• Configured the database in the ARCHIVE LOG mode in order to run the ARCH process for archiving updates and changes to the database.
• Migrated databases from No Archive Log mode to Archive Log Mode.
• Interacted with the developers to improve the Server performance and User Business requirements.
• Developed the database triggers for business functionality.
• Active member of the on-call team to support Clients of different Industries relating to our team 24/7, to keep the High critical systems running.

Confidential, Fort Lee, NJ

SAS Programmer/Analyst

Responsibilities:

• Identify and implement solutions aimed at enhancing operational efficiencies resulting in reduced costs and/or increased revenues
• Review functional requirements documentation and translate functional requirements into technical specifications
• Analyze and document complex business problems and formulate solutions by composing and executing SQL queries
• Research, analyze, maintain and document specific operational issues. Enhance processes to resolve existing system/process issues
• Developed a rules engine to map inbound client data to the Sasbase structure and subsequently deploy data to vendors/clients in a flat file format
• Facilitate information sharing and process improvement across various Data Management groups
• Improve Metrics and Reporting by performing root cause analysis and enhancing service delivery
• Participate in the successful transition of work to offshore vendor(s)
• Train new employees on client responsibilities to ensure a smooth transition
• Produced new interfaces for eligibility files on client projects
• Updated current interfaces by request of business analyst and/or client
• Acted as a liaison with vendors by coordinating meetings & negotiating relationships
• Assisted business teams with understanding and implementing IT solutions to meet FMLA, HIPAA, and COBRA requirements
• Lead the client implementation team for American Express