SUMMARY:

• An astute Oracle professional, self - motivated with around 6+ years IT experience as an Oracle DBA (versions 12c/11g/10g/9i) in Oracle products, both production and development environments spanning several industries: production, health care, financial services, and high tech.
• Installation, upgrade, maintenance, administration of multi-terabyte standalone and RAC on multiple platforms like IBM-AIX, Sun-Solaris, UNIX, Linux, Windows.
• Hands on experience in test, development databases, production support and day-to-day activity to ensure zero alert thresholds is met 24x7.
• Extensive knowledge and experience on Data Warehouse using ETL tools like Informatica.
• Extensive knowledge and experience on Amazon Web Services(AWS) Technologies like: EC2, RDS, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), IAM, VPC, Subnets.
• Experience with installation of Grid Infrastructure for ASM, RAC. Very good understanding of GpnP (Grid Plug n Play).
• Migrated OS file system storage to ASM with minimal downtime and administered ASM disk groups and instance.
• Server side and Client-side fault tolerance achieved by configuring SERVICES and TAF (Transparent Application Failover).
• Proactively monitored and diagnosed symptoms using OEM (Enterprise Manager) to significantly increase the probability of success of production db and application.
• Ample knowledge and experience on Amazon Web Services and involved ongoing database technical support for RDS, EC2 environment.
• Responsible for launching EC2 instances w/ Linux AMI and bootstrapping with Apache using Bash scripting, using auto-scaling and load balancers (ELB).
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities ESTAT/BSTAT, STATPACK, End-user tuning and troubleshooting using various tools like EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR, ADDM, ASH, v$ performance views.
• Knowledge of Shareplex for Materialized Views, Good experience with Data Modeling to translate logical data elements into the physical database design.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) /Network Attached Storage (NAS).
• Involved in setting up of POC Environment for OBIEE, which involves Installation of OBIEE Platform, OBIEE Applications, Informatica; Configuring OBI Server, OBI Presentation Server and DAC.
• Build complex entity relationship models - both logical and physical database design.
• Experience in resolving complex restore and recovery issues using RMAN.
• Experience in working on Remedy (Incident management / Change management) BMC Patrol.
• Experience working with Application development team in Release and Deployment Management processes.
• Experience in UNIX Shell Scripting for automating the DBA tasks like User maintenance, Performance Monitoring of CPU, Disk and Memory usage, and File system monitoring.
• Good Experience in Hot/Cold Backups, and Cloning of Databases.
• Extensive knowledge on database backup/recovery strategy (RMAN), Import/Export & Datapump, Capacity Planning, Replication (Streams) standby databases, Oracle configuration management, Dataguard, database cloning, refresh and patch management and Oracle Exadata Database Machine.
• Experience in Database Security and Auditing.
• Extensive knowledge in Korn shell and Perl scripting.

TECHNICAL SKILLS:

Databases: Oracle 12c, 11g, 10g, 9i, 8i, 8.x MS SQL Server 2005 and 2008

Languages: C, C++, Java and J2EE

Application server: Oracle 9iAS Release 2, Websphere MQ, Web logic, iPlanet

Tools: and Utilities: OEM 2.2, Forms6i, Reports6i, SQL*Loader, Oracle Workflow, Oracle PL/SQL, Designer 6i, Developer/2000, Discoverer 3.1(Administration & User) Visual Basic 5.0

ERP Applications & Tools: Oracle Applications - 11i, 11.0.3, 12.0.6, 12.1.1

ETL Tools: Informatica (Power Mart & Power Center)

Decision Support Tools: Business Objects, Brio, Web Intelligence and Apache

Web Technologies: Weblogic, IBM Websphere MQ

Fusion Middleware: IDM, OIM, OAM, SOA, OBIEE and SSO

Replication: Golden Gate, Streams and Oracle Advanced Replication

Hardware: Sun Fire V880, Sun Ultra Enterprise 3500, Sun Ultra Enterprise 250/450, Acer Altros19000 DDE Org Supermax RISC Plus IBM, Dell 6600, Compaq Proliants, Compaq DL580, IBM Netfinity

Operating Systems: RHEL 4.x/5.x/6.x/7.x, Sun SPARC Solaris 2.x, CentOS, SUSE, Linux Red Hat Advanced server, HP-UNIX, IBM AIX Unix Windows 2000 advanced server, Windows XP, Windows 2003 and Windows 2008

PROFESSIONAL EXPERIENCE:

Confidential, O’Fallon, MO

Oracle DBA/AWS Cloud Engineer

Responsibilities:

• Install, Setup and Configure Oracle Clusterware and database software.
• Performed upgrades to Oracle 11g from earlier versions of Oracle.
• Successfully upgraded databases to version 11.2.0.4 and applied latest PSU patches.
• Performed rolling Grid Infrastructure upgrade from 11.2.0.4 to 12.1.0.2
• Implement and enforce database security to meet PCI requirements.
• Migrated development/production Oracle databases to AWS RDS.
• Assisted in developing consistent distributed databases by using shading and replication on AWS platform.
• Created network architecture on AWS VPC, subnets, Internet Gateway, Route Table and NAT Setup.
• Achieved HA (High Availability) and FT (Fault Tolerant) for AWS EC2 Instances using the AWS Technologies like: EC2, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), VPC, Subnets.
• Worked with IAM to manage the users and groups using IAM by assigning individual policies and roles to each users and group as per requirements.
• Plan and implement backup, recovery solution using RMAN.
• Plan and develop contingency solutions for supported databases.
• Perform ASM Installation, Migration & Configuration as per the requirements.
• Migration of Non-ASM standalone database to One Node RAC.
• Migration of Databases to Oracle Exadata machines using datapump import.
• Creation and setup of physical standby databases and oracle active Dataguard on exadata machines.
• Designed, implemented SSL/TLS on Oracle databases for network encryption of data; Generated wallet, keystore, and imported certificates into wallets.
• Manage RAC environment for Day to Day Database administrator, performance tuning.
• Securing stored data using oracle transparent data encryption by installing TDE wallet and creating encrypted tablespaces and storing sensitive data in encrypted tablespaces.
• Successfully performed Disaster recovery exercises for highest availability using DataGuard broker (DGMGRL).
• Performed database rolling upgrades and PSU patching.
• Provide the support for day to day database maintenance activities; planning & scheduling the changes.
• Enforce and maintain database audit and security standards for PCI standards.
• Develop and implement high availability, scalability and disaster recovery solutions dataguard, replication, streaming & golden gate as per the application's business needs to meet the required SLAs.
• Database performance monitoring, tuning to optimize overall response times.
• Performed online database reorganizations as required to improve database performance.
• Administer all physical and logical database and storage structures.
• Reviewing and resolving database backup and OEM alert reports on daily basis.
• Support for Development, Stage and Production databases hosting business critical applications.
• Experience working with Enterprise Manager Cloud Control 12c.
• Managing and mentoring offshore teams and provided 24x7 on call support.

Environment: Oracle 12c/11g 3-node RAC, AWS (EC2, AMI, VPC, Route53), RHEL 6.7/5.11, IBM AIX, CRSCTL, SRVCTL, RMAN, ASM, OBIEE, Physical Standby db, Data Guard Broker, OEM Grid Control, Data pump, SQL Developer/TOAD, SQL* Plus, Putty, SSH

Confidential, Jersey City, NJ

Oracle DBA

Responsibilities:

• Managed database on 11g R2 RAC.
• Wrote PLSQL jobs and scheduled via oracle scheduler to run daily.
• Excellent knowledge of 11g RAC srvctl, crsctl, ocrdump, ocrcheck and ocrconfig utilities
• Performed converting single node instance to RAC and Adding instance to the existing RAC
• Administered GI resources like ASM, SCAN Listener, node listener, OCR, Vote files using CRSCTL and SRVCTL utility.
• Successfully added nodes to the existing RAC cluster by extending GI and Oracle binaries.
• Troubleshooted Node eviction (split brain syndrome) issue due to flooded interconnect traffic.
• High availability and load balancing achieved with Services which was fully integrated with 11g/12c Grid Infrastructure.
• Perform Database monitoring, Tuning RAC.
• Client-side fault tolerance achieved by configuring TAF (Transparent Application Failover) in RAC as well as Data Guard env.
• Upgraded more than 15 db from 10.2.0.1 to 11.2.0.1 and then 11.2.0.1 to 11.2.0.2 including patchset updates using opatch.
• Wrote procedures/packages to load data using new SQL features like copy.
• Effective use of tuning packs like ADDM, AWR, ASH, Tuning Advisors to troubleshoot resource-intensive SQL, enqueues, locks.
• 50% improved Performance of fetching LOB data by creating partitions. Data footprint reduced by purging older partitions to lowered operational cost.
• Data migration using Data Pump export/import to bring historical data from application so to analyze the growth of db over a period.
• Installing ASM environment and migrating database from NON-ASM to ASM
• Cloned databases using Export Import, Data Pump and RMAN Duplicated Databases.
• Worked on logon triggers to trace session coming from applications servers.
• Clone databases using RMAN duplicated.
• Provided technical troubleshooting and give consultation to development teams.
• Worked on loading of data from several flat files to Oracle database Targets.
• Designed the procedures for getting the data from all systems to Data Warehousing system.
• Tuned complex SQL's using SQL tuning advisor and SQL Access advisor.
• Applied High priority, security patches downloaded from Meta link
• Used Oracle Enterprise Manager to monitor database health and check log files for errors.
• Installed operating systems, patching, upgrading managing configurations
• Managed User accounts and granted directory permissions to secure UNIX systems in meeting industry practices

Environment: Oracle 12c/11g 3-node RAC, RHEL 6.6/7.1, OEL 5.8, IBM AIX, Grid Infrastructure, CRSCTL, SRVCTL, RMAN, ASM, Physical Standby db, Data Guard Broker, OBIEE, OEM Grid Control, Data pump, TOAD, SQL* Plus, Putty, SSH

Confidential, Fort Lauderdale, FL

Oracle DBA/Developer

Responsibilities:

• Installation, up gradation and Maintenances of Oracle Databases on Linux & Windows platforms.
• Used Shell Scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Proactively monitored the database and database access, and maintained the database security.
• Extensively worked under UNIX environment to provide DBA support.
• Supported data management through on-site & off-site storage and retrieval service.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Backup of database Logical and Physical (hot and cold) procedures and also using RMAN.
• Perform database monitoring, capacity planning and performance tuning.
• Scripted jobs to refresh tables/schemas and databases as well.
• Generating AWR reports to deal with performance issue.
• Tuned database SQL statements and procedures by monitoring run times and system statistics.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement, SQL queries, stored procedures for performance improvement.
• Refreshed Schema in DEV environment. As well as adding Meta data information to the database.
• Created PL/SQL stored procedures, functions and packages to process the data according the requirement.
• Created Database Deployment instruction and deploy the code on production sever.
• Troubleshoot performance issues and bugs within packages, forms, and reports using dbms output, Forms debugger, explain plan.
• Written scripts to monitor tablespaces, file systems.
• Taking care of all alerts for space issues and user requests.
• Configuration of tnsnames.ora, listener.ora and sqlnet.ora files after upgrading databases.
• Performed database cloning from old system to new system.
• Used EXPORT/IMPORT for table level and full database de-fragmentation.
• Transported tablespaces between production and development databases.
• Running scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Environment: Oracle 11g, 10g, RHEL 5.x/6.x, CentOS, IBM-AIX, RHEL Advanced Server/Enterprise 2.1/3.0, OEM(Grid-Control), PL/SQL, RMAN, AWR, ADDM, PL/SQL, SQL Developer, WinSCP.

Confidentia, Holland, MI

Jr. Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g/11g databases.
• Installation, configuration and maintenance of 11.2.0.3 Oracle Data Guard as a high availability solution.
• Installing and configuring physical standby database using RMAN duplicate from active database on RHEL 6.3.
• Possess strong RHEL and Solaris skills.
• Applying one off patches using OPATCH utility.
• Creating and managing application schemas with appropriate table spaces and Indexes.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
• Manage users, privileges and profiles, schemas using Oracle Grid Manager, Oracle Enterprise Manager (OEM) and SQL.
• Refreshing application schemas using data pump export/import
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Used RMAN to cloned and duplicated databases.
• Migrated databases from Windows to Linux using transportable tablespaces.
• Oracle 10g & 11g RAC, ASM, Data Guard (Physical, Logical standby), Enterprise Manager (EM) Grid Control, RMAN, Installation, Upgrades, Migrations, Performance Tuning Recent Experience.
• Creating and managing application schemas with appropriate table spaces and Indexes,
• Create public and private database links.

Environment: Oracle 11g/10g, SUSE 9.x, HP-UX, OEM grid control, TOAD, Data Pump, RMAN, AWR, ASM

Confidential

Technical Analyst

Responsibilities:

• Involved in gathering requirement, Analysis, Design.
• Created database objects including tables, views, synonyms, sequences, constraints, indexes.
• Created Pl/SQL Stored Procedures, Functions, Packages, Triggers, Cursors.
• Prepared migration documents & other documentations. Monitored db performance via STATSPACK.
• Participated in design reviews for upcoming application enhancements.
• Performed data extracts/loads in the testing environment using SQL*Loader.
• Assisted developers to troubleshoot SQL and PL/SQL code and increase the efficiency of execution.
• Created daily, weekly, and monthly DBA checklists for each environment.
• Documented database/server configuration for production, test, and development databases.
• Setup Crontab jobs to automate the routine tasks.

Environment: Oracle 9i, SQL*Plus, Pl/SQL, TOAD, SQL*Loader, SQL*PLUS, UNIX, VSS, OEM, Stats pack, QC