SUMMARY

• A certified Oracle database administrator and Certified Information System Auditor (CISA) with an overall knowledge - based of over 10 years working in various roles as a database administrations and migration architect of databases including Sybase into oracle platform as well as smooth interoperability of these databases where they needed to co-exist.
• 10 years’ experience as Oracle Database administration.
• Capacity planning, Architect, Installation, configuration & upgrades of Oracle RDBMS on different environments and platforms.
• Databases management system (RDBMS/DBMS): Oracle, Sybase, MS Access.
• Database language & Scripting: SQL, ISQL, PL-SQL, SQL-Loader etc
• Services Controls & Scheduler: CRSCTL, SRVCTL, ASMCMD,EMCTL DBCONSOLE, OEM/GRID, Oracle Scheduler, CRON etc
• Networks & Storage system: LAN/WAN, TCP/IP-Wireless protocol, FTP,DHCP, Active Directory Services, LDAP,SAN,NAS,UDP
• Extensive experience of working on Oracle 9i, 10g, 11g on Sun Solaris, IBM AIX, HP-UX, Red Hat Linux, Ubuntu Linux, Oracle Virtual Box (VMware) and Windows.
• Setup physical standby (snapshot/failover/switchover/Active database) for disaster recovery (DR) and Business Continuity.
• RAC Clusterware installations & management both in 10g and GRID infrastructure in 11g on ASM Architecture using DNS/DHCP.
• Configuration & Proficiency in using of Manager (OEM) and GRID control for managing and monitoring Oracle database
• Used Oracle Enterprise Manager (OEM) for database performance monitoring, job scheduling, Setting Optimizer Statistic, etc.
• Real database application Replay & testing (RAT + SPA) to capture production workload and replay it on different environment.
• Upgrade database, Clusterware, RAC and ASM from oracle 10g to 11g and applied oracle patches for PST/CPU
• Hands on experience with Installation and Configuration of Golden Gate software for Heterogeneous Data Replication and oracle Shareplex for replicating data between oracle databases.
• Database migration/upgrade from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• Sound database tuning experience from Active Session History report (ASH), AWR, AWRSQL, ADDM etc for analysis, findings and recommendations.
• Designed and implemented Database Backup and Recovery strategies using RMAN, OEM and Schedule Parallel backup for the same file using Oracle 11g RMAN feature.
• Backup/Recovery using RMAN, Conventional export/import and Data Pump.
• Wrote Shell script for automated hot backup using RMAN.
• Performance tuning of RAC at cluster level and OS level using HACMP by setting different clusters and Kernels parameters.
• Used database tuning advisor and SQL Profiler for performance optimization.
• Wrote UNIX shell script with SQL scripts for monitor database and automate backup.
• Monitor Database using hand written scripts, OEM, Spot light, Quest Foglight etc
• Installed, configured, administrated and maintained SYBASE databases.
• Administrated large Production database (100G to TB) and Large Data Warehousing and VLDB.
• Analytical Reporting tools such as Crystal Report, Advanced MS Excel etc.
• Risk analysis and mitigation skills using Value@Risk, Stress testing, Scenario Analysis, Basel III with Regulatory bodies, SOX, etc
• Excellent communication and interpersonal skills, good team player with analytical and presentation acumen couple with strong attitude towards learning pros and cons of new technologies.

TECHNICAL SKILLS

RDBMS: Oracle 8i, 9i, 10g R2, Oracle 11gR1/11gR2, Sybase 11/12

OS: Windows XP, 2000, SUN SOLARIS 9/10/11, HP-UX Itanium 11.31, Red Hat Linux 4/5, AIX 7.1 used with Smitty

Tools: /Technology: OEM, TOAD, SQL Developer, PSFTP, FTP, Putty, MOBAXTERM, Spot Light, fog light, DBArtisan, Crystal reports, UDP, NAS,SAN

DB Utilities: SQL * Loader, Exp/Imp, Data Pump Utilities, RMAN, OLTP

Language: SQL, PL/SQL for Oracle, Shell programming

Scripting language: HTML, XML, VBA, shell

Shell script: Unix Shell Script

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle Database Administrator

Responsibilities:

• Act in a capacity of A Stack DBA on a L3 capacity by taking escalations from L2/L1 incident Management team
• Refresh database schemas from the production to UAT and Development server
• Ensure the optimum performance and success of jobs schedule on Autosys.
• Setup physical standby (snapshot/failover/switchover/Active database) for disaster recovery (DR) and disaster recover
• Real life Quarterly PAT (Production Active Test) failover to Physical standby by all stakeholders in conjunction with policy.
• Implement and maintain physical snapshot standby Dataguard and guarantee restore point using flashback architecture
• Perform incremental and full database backup as well as schema/tables/objects dumps for partial refresh.
• Used of DG Views like v$managed standby, v$archived gap,v$log history,v$restore point,v$archived log,V$logfile etc.
• Use SQL Profiler to ensure that SQL query plan flips and stale hints statistic are enforced.
• Experience on handling production oracle databases in Linux, windows and UNIX in 24 X 7 environments.
• Core skills on 11g database creations and software binaries installations in Windows/Unix environment using 10g and 11g advance features.
• Practical experience in monitoring and tuning a database to provide a high availability service.
• Core experience on Oracle high availability setup likes cluster, RAC, Data guard (active DG,Failover including DGMGRL, etc) and ASM
• Practical experience in database backup & recovery using RMAN and Knowledge on Exports, Imports, Data pump, SQL-Loader.
• In cases of some High level issues/problems, open a case with Oracle and do coordination with principle till closure of SR.
• Responsible for ensuring availability and performance of the databases that support the system.
• Experience in analysis of data tablespace, TEMP, UNDO tablespace growth.
• Knowledge on performance tuning of database
• Hands on experience on cloning of databases with databases restorations and recoveries.
• Hands on experience on CPU patching and upgrades.
• Jobs automation via shell scripting using Autosys/Crontab schedulers.
• Hands on experience on Stats pack, AWR report analysis with SPA enhance for SQL tuning sets.
• Knowledge in writing shell scripts needed for automated jobs like Autosys and Cronjobs.
• Automated alert monitoring using Nimbus and Lab128 tools.

Confidential

Oracle Database Administrator

Responsibilities:

• Analyzing performance test results generated by Oracle Real Application Testing for structured query language (“SQL”) for the targeted migrations for both the OLTP and batch transactions.
• Monitor the applications running on the CVS architecture OEM and resolving locking conflicts using SQL, PL-SQL optimizer scripts.
• Analyzing report generated from the SQL performance Analyzer (SPA) during the high peaks for the OLTP transactions on QA.
• Data security and objects backup/recovery using RMAN, TSPITR, Data Pump, Flashback data from Archive destination/DPDUMP.
• Managing the Servers running on AIX 7.1 Unix for Upgrades and Patches on EMC storage area in a 5 RAC nodes Clusterware.
• Database performance analysis and tuning assistance for the migrated database using any of the following tools, as determined appropriate by Oracle: Oracle Enterprise Manager (“OEM”) diagnostics and tuning packs, Oracle Automated Workload Reports (“AWR”).
• Capture, Process, Replay, Analyze and Report all findings discovered in the database workload Replay by executing DBMS workloads and wrc.
• Management of VLDB on an Exadata Platform for easier queries performance using a smart flash cache technology
• Management of the 5 nodes RAC architecture databases, Clusterware home and Automatic storage management ASM
• Performing and comparing execution plans between top running SQLs including Procedures with binds variable in Oracle 10g and 11g and restructuring or tuning as may be required.
• Writing and debugging complex PL-SQL statements using CURSOR etc.
• Using SQL Auto-trace and Explain Plan to tune and improve the performance of the Top-bad SQL from the AWR/ASH/AWRSQL Report and ADDM recommendations and findings.
• Use oracle SQL Developer tool for the management of queries in a more user friendly environment including 3rd Party Databases.

Confidential, Basking Ridge, NJ

Oracle Database Administrator

Responsibilities:

• Oracle general purpose configuration and management on the MCS, Vision System, SCM and CMP for data processing control.
• Monitor the applications running on the MCS architecture via GRID/OEM and resolving locking conflicts using SQL, PL-SQL optimizer scripts.
• Support as PRODUCTION/QA DBA to over 20 databases running concurrently on 10 different servers running to Terabytes.
• Data security and objects backup/recovery using RMAN, TSPITR, Data Pump, Flashback data from Archive destination/DPDUMP.
• Linux/Solaris installations & administrations of upgrades, Patches etc on SAN/NAS Servers or VMware prior Oracle installations.
• Experience in code management, database change and management through the stages in System development life cycle (SDLC).
• Configuring, implementing and managing of the various services on the 4 RAC Nodes on GRID home using the SRVCTL and the CRSCTL utilities dedicated for the Information system.
• Real database application Replay & testing (RAT) for upgrade and capacity planning using SQL performance analyzer & Replay.
• Configuring and management of the GRID infrastructure and management of the utility services ASMCMD, ./CRSCTL, SRVCTL
• Implementation and management of Oracle Golden Gate on a bidirectional (Active-Active instant failover) for replication of data, transaction within and outside the database as well as management of Oracle SharePlex replication Technology.
• Utilizing Dataguard snapshot to clone test & development servers as well as maintaining Maximum High Availability in failovers and switchover.
• Configuring ASM High Redundancy for best protection during data & storage failure and maintaining availability in disks failures.
• Using Flashback technology to recover tables, transaction & events from Undo, while database is recovered from Flashback area.
• Maintaining and analyzing database performance using the SQL tuning advisor, Explain Plan, TkProf, SQL Trace, Analyze, etc.
• Maximizing Partitioning on the oracle and OS level to ensure multiplexing of core Critical objects/disks in a more flexible pattern to avoid disaster and minimize (MTBF).
• Using UNIX shell scripts and oracle scheduler to schedule jobs and for system tablespace auto Extent management.

Environment: Oracle 11g, Red-Hat Linux 5.x, Sun Solaris, RAC, Toad 9.5, PL/SQL, SQL*LOADER, SQL PLUS, UNIX shell scripts.

Confidential, Watertown, CT

Oracle DBA

Responsibilities:

• Medicare Management Information Systems (MMIS) to Provide 24 X 7 Oracle database on-call support services.
• Manage the oracle production database instances and ensure performance monitoring of the database using SQL tuning set.
• Participate in the Planning, Analysis, implementation and Maintenance of production database resources running on UNIX.
• Creating and maintaining database objects for complex business rules. Disabling constraints for bulk DMLs upload
• Install various components of oracle E-Business Suite applications and configuration to support the Aix-Unix environment.
• Provide input on design decisions in the integration of databases using SQL-Loader or SQL Server Interface service (SSIS).
• Monitor database growth trends and develop capacity planning and data archival strategies using the optimizer statistics tools.
• Oracle security based audits & disaster recovery plan using Data Replications infrastructure & scalable Dataguard flexibility.
• Implemented and managed Oracle Golden Gate technology on unidirectional basis (Reporting database) with one of our partner health provider using the golden gate command interface ggsci
• Performed upgrades from Oracle 10.2.0.3 to 11.1.0.1 and Monitor Oracle 11i Application instances.
• Configured, administered and monitored a Streams environment using tools like OEM console and apply changes on database
• Set up, configured and maintained oracle data guard (primary and standby databases) to ensure faster disaster recovery, high availability and data protection
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes
• Installation and maintenance of 2 nodes RAC including the Clusterware + ASM (G.I) and configuring the services with SRVCTL.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
• Based on the thresholds configured, notifications and alarms are generated; actions are executed while gathering performance data for planning, analysis, and reporting.
• Monitored log apply rates, capturing diagnostic information, and detecting problems quickly with centralized monitoring, testing, and performance tools in physical/logical databases
• Installed Oracle 11g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases
• Designing the security and database access strategies using tools like ESM and writing a SQL Scripts for bulk authorized users.
• Indexed at the database level and used pre-tuned queries at the application level to tune OLTP.
• 24x7 production support for several mission critical systems which utilize multiple databases.

Environment: Oracle Server 11g/10g, SQL, PL/SQL, UNIX, RedHat Linux 5.x

Confidential, Jersey city, NJ

Oracle-Database Administrator

Responsibilities:

• Integration and Interoperability of other Business applications (KASTLE and 3rd parties applications) with FLEXCUBE CBA
• Co-ordination, review, testing and deployment of patches and fixes bug in the FLEXCUBE modules and E-Business suites apps.
• Design and Co-ordination of FLEXCUBE Center of Excellence - 24/7 online Database support for Flex-branch & FLEXCUBE.
• Handle problems relating to Oracle FLEXCUBE Helpdesk management and resolving Oracle applications bugs for VLDB
• Tuning of instances and database using optimizer statistics from AWR & ADDM by setting the baseline, metrics, threshold etc.
• Query optimization using SQL advisor, bind variable, and explain plan, trace, views, indexing and various types of joins.
• Analyzing CBO and instance parameter for best result of query by monitoring performance at session, query and system level. To find problematic SQL from History tables.
• Rewriting of SQL queries for different types of joins. Define outlines and profile for SQL for stereotype queries.
• Writing PL/SQL block for bulk DML tasks. Monitoring and estimating size PL/SQL blocks. Partition of database, table and schemas (split Env).
• Monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs using CRON, creation of users, schemas, tablespace and other database objects. (crontab - e, crontab - l, crontab - r)
• Writing SQL and SHELL scripts for monitoring database. Automation of database maintenance using OEM, SHELL scripts. Configure alert, thresholds and email in OEM.
• Creating scripts automate backup of database by RMAN, Import/Export of data file and user schema. Recovery of full database by applying archive and redo logs (Alter database open resetlogs).
• I was involved in writing queries involving multiple-joins to generate applications reports using Business report or OBIEE Tools on Toad, Quest tools etc.
• Planned the index rebuilding, index analysis and table analysis on periodical basis.
• Scheduled & coordinated database maintenance activities including such items as database reorganizations, restructures, migrations, tuning, SOX (Sarbanes-Oxley Act) sensitive views, materialized views & staged data refresh.
• Capturing the database statistics and metrics for proactive database management
• Cloning of production database to the test environment using Recovery Manager (RMAN).
• Monitored the growth of the database objects for capacity planning and analysis.
• Loading data from flat files into Oracle Database using SQL*Loader and automated the process using UNIX Shell scripting.
• Migrated databases from windows SQL Server to HP-UNIX servers using Data Warehousing (ETL).
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Developed, implemented and tested a backup and recovery strategies.

Environment: Oracle 10gRAC, 9i, RedHat Linux, HP-UX, IBM Aix, OEM, RMAN, SQL*Loader, Oracle Golden Gate

Confidential

Oracle DBA/Technical lead

Responsibilities:

• Management of data architecture & risk assessment processes from an in-depth understanding of risk & security measures.
• Implemented and managed Dataguard on Primary Core Database against the standby database to manage databases failovers.
• Management of Virtual data and automate backup using Data Pump and RMAN embedded script on oracle scheduler.
• Administration & Migration of data running on DB2, Sybase and SQL-Server to Oracle Aix-UNIX Platform using SQL-Loader, a metadata management of Non-Oracle database system.
• Scheduling routine CRON jobs on AIX Unix production Servers on a 2 nodes grid infrastructure to allow for maximum performance.
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes & materialized views.
• Taking snapshots into the Automatic Workload Repository (AWR) to proactively maintain the database using Statistic optimizer and minimize reactive resolution of the Automatic Database Diagnostic Management (ADDM) over a threshold frequency.
• Obtaining efficiency with Recovery Manager (RMAN) in backup, restoring and recovery of p-files, control files and datafiles.
• In Merger/Acquisition Project, I was involved in the data migration of a legacy banks’ data in Financle/Equinox banking application running on DB2/Sybase to FLEXCUBE banking application running on Oracle in an Aix UNIX Server OS platform.
• Configuration of Oracle Instance with SGA, PGA and Background Processes.
• Managing Logical objects like Tablespaces, segments, and extents in estimating table sizes, table spaces.
• Maintaining indexes and performance management of Undo Data.
• Create Users and Roles with appropriate privileges, roles. Thus create user profiles and assign to appropriate user.
• Also define Database level authentication and OS level authentication using password file.
• Performing regular Backups and Recovery as per Organization Strategy to support the database and Troubleshooting with restoring and recovery (Instance, media).
• Performing hot/cold backup. Setting up of RMAN on the database to perform necessary back-up.
• Integrated the Backup Status Reporting for all the databases using shell script.
• Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata.
• SQL query optimizing using CBO (cost base optimizer), bind variable, Explain Plan, TKPROF, stats pack and instance as per company’s requirement for high tuning.
• Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, and production environments.
• Written extensively UNIX Shell Scripts, PL/SQL, Stored Procedures, Functions and Triggers.
• Create table, view, and materialize view, private and public synonyms.
• Create user define packages and use pre-define packages. Different kind of Exception handling.
• Responsible for integrity and concurrency of data, locks and latches.
• Working with management system like DBMS and RDBMS with specific functions, database tools and utilities. Managed and resolved design issues during development.
• Work with lines of business to create functional process & data flow charts for customer and technical review on modeling.
• As a technical lead, Producing detailed Data Architecture framework within which Entity Relationship Diagram & Data Model Designs (conceptual, logical, and physical) will be developed.
• Implementing a disaster recovery plan (DRP) or business continuity plan (BCP) for the Universal lending systems.
• Ensuring bugs are fixed & thoroughly tested on the development and test environment before applying patches to production Server in line with operating manuals.
• Develop MIS & other Credit reports of all credit facilities by categories (Overdraft, Personal Loan, Credit Card, Mortgage loan, Auto loan and other credit facilities) to Credit Bureau using Crystal report tools, Oracle report and Business objects.
• Analyze internal and external data for portfolio segmentation and validation with thorough execution of credit loan from origination to disbursement via the various stages of underwriters and Counterparty rating in the ERP of Oracle EBS suite.
• Proficiency in using IBM Websphere & MQ Websphere for the implementation of KASTLE Universal Lending System (ULS).
• Strong knowledge of Application development life cycle (SDLC), including functional testing (QA) and requirements gathering.

Environment: UNIX, Oracle 8i, 9i, 10g RMAN, SQL Server 2005, 2008 Crystal Reports 5.0, SQL * Loader, Toad.

Confidential

Sybase DBA/Application analyst

Responsibilities:

• Tera-data Management of database running on UNIX OS; Database architecture/administration with emphasis on data integrity, quality & security while maintaining access & control of users, assigning privileges and roles.
• Taking database Dumps and Upload from the ISQL command prompts for database backup and recovery
• Integration and Interoperability using SQL Server Integration Services (SSIS) with Extract, Transform & Load (ETL) capabilities.
• Writing DML and DDL queries using SQL/PL-SQL to manage data, table and transactions maintenance on the Toad/DB-Artisan.
• Coordinate and manage service level agreement with consultants and user across the network to maximize up-time.
• System Administration on file Servers (Equinox/Phoenix Banking Application) running on SQL Server RDBMS.
• Reviewing, Fixing and debugging queries coming for change management and recompiling invalids objects.
• Extensive performance/tuning of ANSI SQL, PL/SQL using various methods i.e. tuning of memory parameters, hinting queries.
• Fixing the joins with proper columns and indexes. Writing PL-SQL for business logic including triggers, procedures.
• Writing SHELL scripts which set profile of any instance with single commands. Debugging PERL and SHELL scripts.
• Efficient in managing database server from command-line and using SQL developer tools and Toad.
• Supported as DEVELOPMENT/PRODUCTION DBA to 40+ databases on 6 different servers with over a Terabyte in size.
• Hand over the QUERY PERFORMANCE result to off-shore developers for better design of DB and automatically taking reports Of SQL queries that run beyond a threshold frequency in a session and fixing it with proper join and indexes.