SUMMARY

• Around 14+ years of IT experiences as an Oracle DBA on a variety of UNIX (Tru64 Unix, AIX), Windows server platforms with Oracle 9i/10g/11g/12c
• Database installation and administration, manage user profile, performance tuning, triggers, stored procedures, security, auditing, storage configuration with hardware level disk mirroring, backup, recovery, troubleshooting and perform root cause analysis on failures
• Familiar with Oracle 12c new features, RAC, Materialized views, OEM, ASM, RMAN, Data Guard, and Golden Gate and worked extensively in OLTP and OLAP environments
• Creating tablespaces and planning the location of data, index and rollback tablespaces, redo log files and control files in adherence to the Optimal Flexible Architecture and best practice guideline
• Proficient in SQL, SQL*Plus, Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF, STATSPACK and AWR to analyze timing & execution plan for tuning.
• Experienced in designing, developing, scheduling and monitoring UNIX shell and SQL scripts for hot and cold backups, EXPDP/IMPDP database backups and recovery
• Used ETL concepts in data discovery, conversion, mapping and migration
• Extensive experience in application development using PowerBuilder, PFC libraries, OOP, SOAP, WSDL web service, XML, DLLs, and Socket programming handling XML data packets.
• Hands on experience in applying patches on Oracle 9.2.0.6 and 9.2.0.7, 10.2.0.1.0 and upgraded it to Oracle 11.2.0.3.
• Experience with Disaster Recovery, Data Guard, RMAN, Real Application Cluster (RAC), OLTP and Data warehousing environments.
• Implemented Oracle Enterprise Manager (OEM), Automatic Storage Management (ASM) & Automatic Database Diagnostic Monitor (ADDM).
• Good understanding of Exadata features like smart scans, HCC, flash cache, Infiniband, ILOM
• Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM), Oracle Grid Control.
• Statistical analysis, modeling, data collection, cleaning, visualization, regression, data mining, decision tree, cluster analysis, random forest, forecasting and reporting using SAS, Python and R
• Working knowledge of Big data technologies and the System Development Lifecycle (SDLC)
• Expertise in all aspect of Systems Development and complete Project Life Cycle in Oracle Technologies with Software Development including requirements analysis, design & development
• Strong communication, Presentation and analytical skills. Proven skills as an efficient Team Lead in System Analysis, Designing, Development, Customization, Migrating and Documentation
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c, SQL Server, Informix IDS 7.3, MS - Access, Sybase ASA

Oracle and other DB related Tools: SQL*Loader, SQL*Net, OEM, TOAD, Data Guard, ASM, Golden Gate, RAC, Oracle SQL Developer, ERWin

Operating Systems: AIX 7.1, HP Tru64 Unix 5.1B, HP-UX and Windows Server 2003/08/12

Languages: SQL, PL/SQL, SAS, Python, R, C/C++, PowerBuilder 9-12.5, Visual Studio and ASP.Net

Big Data Apps: Hadoop, MapReduce, HDFS, Hive, Pig, Spark, NoSQL, Hbase etc.

Web Servers: IIS, Apache

Reporting Tools: MS-Office (Excel Macro, VBA), MS-Visio

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Senior Oracle Database Administrator/ Lead

Responsibilities:

• Administrated and created production, development, and test Oracle 12c/11gdatabases hosted on Windows and Linux Server.
• ConfiguredOEM 12cmonitoring. Created rules to send out mission critical alerts from production database.
• Backup and recovered test and development databases using RMAN and DataPump.
• DefinedOracle11gupgrade strategy for production, development, and test databases.
• Measured the performance of the shell scripts by getting the expected results.
• Upgraded database from 11g to 12c bothRAC and Non RACincluding Standby databases.
• Supported failover and switchover ofStandby DatabasesduringDisaster Recovery
• Created and maintained Databases and their objects like tablespaces, tables, indexes, views.
• Experience inOracle 11g/12c Real Application Clusters RAC, Oracle Data Guard, ASM.
• Migrated Stand alone databases on file system toRAC databases on ASM.
• Appliedpatchesregularly on Oracle 11g/10g Clusterware and RAC databases.
• Added and deleted RAC nodes as per the application requirement.
• Worked on major issues involving 11g databases on 11g R2 Grid/RAC and 11g ASM.
• Configured RMAN scripts for taking full or incremental backup, with or without recovery catalog fortest and production databases at regular intervals
• Performed Database cloning usingDatapump, RMAN Duplicate and Cold backup restore.
• Partitionedappropriate tables to optimize performance and simplified maintenance work.
• TunedandoptimizedSQL Query, SGA and Disk I/O using Oracle Enterprise Manager and by monitoring theAWRreport generated from snapshots taken at the peak business hours.
• Monitoredand tuned rollback segment, temporary tablespaces, redo log buffer, sort area size.
• Supported disaster recovery by opening the standby databases inread writemode .
• Set up scripts to monitor log apply onStandby Database.
• RebuiltMultiple Standby databases 10g and 11g
• Created numerousMaterialized view groupsinvolving huge tables.
• Worked onPerformance tuningwith AWR, ADDM, SQL Tuning advisor, SQL Trace and TKProf.
• Experienced in Database design on OLTP and OLAP databases and maintained database security, create and maintain users and roles, assign privileges
• Tuned database/cluster/ASM according to application requirements.
• Tuned long running queries by TKPROF and explain plan and hints.
• Worked on all types of partitions. Set up partition strategy involving tables with millions of rows to improve performance.
• Worked onGoldenGate Replicationand Configured Extract, Replicat processes for GoldenGate.

Environment: Oracle 11GR2, 10gR2, 9x, SQL, PL/SQL, Golden gate 11x, Red Hat Linux (RHEL), OEM, and RMAN, RAC, ASM, Shell Scripts.

Confidential - New York, NY.

Senior oracle database administrator

Responsibilities:

• Installed and configured Oracle 11g/12c on Linux and Windows in production, pre-prod & QA environments.
• Performed administrative maintenance, monitoring on Oracle databases in Windows, Linux/UNIX
• Performed archive log recovery for stand by database using RMAN and Synched with production database
• Identify poorly performing SQL’s using Oracle 12c SQL monitoring feature and run SQL tuning advisor to analyze advisory suggestions.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases
• Used Oracle 11g SQL plan stability feature to stabilize execution plans of poorly performing SQL queries on OLTP systems.
• Configured Data guard using physical and logical standby database.
• Restoration and Recovery of databases at the times of occurrence of critical failures
• Implemented and enhanced the scripts for database backup and archive log backup’s using RMAN.
• Refreshed the database schemas using Data pump utility from production to stand by databases.
• Restored full database backup from tape, recreated the control file and made the databases operational.
• Applied latest PSU patches on Oracle 11g and 12c environments using Opatch utility.
• Oracle services have been used to configure Golden Gate high availability for the RAC nodes.
• Implemented Shell script to monitor the tablespace usage and added space to the tablespace whenever required.
• High availability of Golden Gate is achieved by creating Golden Gate VIPs and services for RAC databases. If one node is failed Golden Gate automatically failovers to the other node.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• GoldenGatetroubleshooting using Log miner
• Migrated Database between servers using Data pump Export/Import

Environment: Oracle 11gR2, Red Hat Linux 6.x, Windows, Toad, SQL*Loader and Data guard.

Confidential

DBA/Database Admin

Responsibilities:

• Responsible for overall planning and execution of all IT functions and Database administration
• Purchased HP Alpha server systems, 2 node Unix cluster with SAN storage, installed and configured Oracle 9i and RAC, redesigned database structures and migrated older data from Informix IDS server
• Designed, developed and deployed entire Money Exchange applications using Power Builder 9-12.5, a bilingual (English & Arabic) application, designed to serve customers to send money worldwide
• Installed and configured Oracle 9i with multilingual NLS, under Windows servers for the 24 local branches, covering troubleshooting database, network communication and data transfer issues
• Created and updated Shell Scripts and Oracle SQL, PL/SQL Scripts to monitor database performance, alert logs, and other related activities, resolved critical issues with Oracle MetaLink and 3rd party SLA
• Purchased AIX based IBM Power730 Server, upgraded to Oracle 11g and consolidated 24 branches to use IBM as a central system, applied patches and monitored alert logs and performance tuning
• Performed backups using O/S, Hot backups with RMAN and also tested various recovery plans
• Importing and exporting data to and from the database servers using data pump (EXPDP & IMPDP) and Creating & maintaining detailed configuration documentation, and maintenance plans
• Designed and maintained Oracle databases, views, stored procedures, triggers, queries, PL/SQL programming, database links, materialized views and documented data flow diagrams
• Extensive use of Crontab in UNIX environment for scheduling routine tasks
• Attend scheduled and monthly meetings with top executives to understand business need and provide suggestions, cost benefit analysis, budgeting for system expansions and enhancements
• Optimized business process to reduce downtime, cost and contributed to corporate profit by 40%

Environment: IBM Power730, AIX 7.1, Alpha ES45, Tru64 5.1B, Oracle 11g/10g/9i, Windows Server 2003/08/12, MSA 1000, Palo-Alto P500 firewall, Cisco 2950 Router