SUMMARY:

• Experiences in banking financial, e - business, supply chain, telecommunication, health care industries. Oracle certified professional with many years Oracle/SQL DBA. Technical strengths include production support of highly available mission critical database with disaster recovery and replication plan/setup. C lustered environments using Oracle RAC 10g, 11g. 12c.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, Atlanta

Senior Oracle DBA

Responsibilities:

• Migrate/Recover/Configure various Oracle databases including RAC/ASM and data guards. In multiple OLTP major projects of consolidating data centers in Oracle 11g and 12c, in both physical and Oracle VM environments of Linux Redhat enterprise.
• Setup and configure Oracle 13C OEM grid control and ignite, including notification, performance, and trending.
• Support/managed Oracle 11g on a Exadata machine system (X2-2).
• Trouble shooting. Work closely with Oracle support on any critical issues.
• Work with customers in business needs in terms schema/objects, data tests/modification/transporting, and user accounts.
• Data replication and best practices in OLTP or OLAP. Designed and implemented groups of material view replication from production to production DB of development life cycle, as well as Goldengate, and data guards.
• Physical and logical data modeling, design, and analysis using tools such as OEM, Erwin, SQL developer data modeler, and Toad.
• In a project with Goldengate support with initial setup from Oracle consultant and Oracle 12c upgrade/migration.
• Intensive performance tuning through ignite, OEM 13C, Toad, explain plan.
• RMAN configure and setup with various backup/restore/recovery with Exagrid support.
• Shell/SQL scripting mostly for DB maintenance related, PL/SQL, SQL query for daily proactive monitoring, automation, and messaging along with OEM 12c, 13c.
• Database testing/evaluating, auditing, capacity planning, and patching.
• Support 24x7 on-call basis for critical production DB include a data warehouse system.
• Good knowledge in NoSQL/Hadoop big data cloud environments such as Cassandra, and MongoDB, in administration and data modeling of best practices.

Confidential, Atlanta, GA

Senior Oracle DBA Consultant

Responsibilities:

• 24x7 production support
• Tested and evaluated Oracle Exadata system
• Implement and support Oracle streams and 3-node RAC on production systems
• Use Veritas cluster for system support
• Implement and upgrade Oracle OEM grid control
• Customer support on production applications and databases

Confidential - Manheim . Atlanta, GA

Senior Oracle DBA Consultant

Responsibilities:

• Implement 2-nodes and 3-nodes Oracle RAC Cluster in Production, QA & Staging environments in iTrax project. Engaged in RAC troubleshooting.
• 24x7 production support
• Development support in SQL tuning and implement schema enhancements
• Monitor database performance, tuning and resource utilization of OLTP applications, SGA, PGA, I/O waits, hits, latches and resource contentions issues using AWR, ADDM, and STATSPACK, Oracle Grid Control, Oracle Enterprise Management Packs - Top Session, Capacity Planning, Performance Advisories.
• Configure and setup grid control in performance, monitoring, and notification.
• Design and implement database High Availability and Disaster Recovery solutions using Oracle Data Guard, Real Application Cluster.
• Design, configure and implement database backup and recovery solutions to support business recovery needs. This project uses NetApp snapshot and snapshot mirror features in backup incorporated with RMAN catalog to setup a company wide standards for backup and recovery strategies.
• Manage database security and authorization through privileges and roles granting and revoking to users and group of users.

Confidential, Alpharetta, GA

Senior Application System DBA and E nterprise Architecture

Responsibilities:

• Original design and modeling the pricing billing system framework. Provide company with pricing system infrastructure design and implementation solution.
• Performance tuning and load balancing.
• Unix and SQL scripting.
• Monitoring and support the systems including collecting and reporting on daily update/load statistics and data trending.
• Install, configure, and upgrade Oracle as well as CPU (critical patch unit).
• Designed and created a distributed database system for pricing/ubill project across 10 IBM P650 (AIX 5.1) servers with very large and dynamic database. This project accomplished both OLTP and data warehousing features with heavy daily data load from data marts to partitioned tables with local partitioned indexes remotely.
• Initial design and setup of Oracle 10g RAC DB on Grid Linux RH 3.0/4.0. The project utilized database and application failover and backup.
• Manage and implement advanced queuing.
• Design a reporting system with materialized views and functional indexes in performance tuning.
• SAP and Java support

Confidential, Atlanta, GA

Senior Oracle DBA

Responsibilities:

• Setup new 9i databases with advance replication global wide (North America, Asia, and Europe) with iFS in XML formats as project lead.
• Performance tuning with OEM tuning features such as SQL analyze and Oracle expert.
• Created a complete backup/recovery plans.
• Provide training documentation on disaster recovery.
• Implement SAFE by applying uniform extent local tablespaces.
• Varity of setups on database high availability configurations, such as Oracle failsafe, standby database, replication, RAC, and RMAN.
• Database migration and upgrades.
• Support extraction and transformation of HP contract data marts for Oracle Application 11i interface with ERP applications.
• Developer supports and production release upgrades.
• Database modeling and logical and physical design for new business for both Oracle in data warehousing and SQL servers.
• Written several application/Oracle technical guides and documents posted on HP domestic and international intranet websites.
• Supported a 9iAS product with J2EE and infrastructure, including installation and configuration.
• Train junior DBA and present systematic teaching sessions to Europe/Asia DBA support groups.

Confidential, Atlanta, GA

Senior Oracle DBA

Responsibilities:

• Created backup/recovery plan and implementation procedures of company’s nation wide production databases support (24x7) for Oracle and SQL servers.
• System and application performance tuning. Implement SAFE by applying uniform extent local tablespaces. Implemented, and maintained Oracle advanced replication (3 way, Atlanta, Chicago, and SFC) with multi-master sites as technical project lead.
• Varity of setups on database high availability configurations, such as Oracle failsafe, standby database, replication, and test of parallel servers.
• Setup and maintained an Oracle iFS database system.
• Developer supports and production release upgrades.
• Database logical and physical design for new business growth.

Confidential, Alpharetta, GA

Senior Oracle DBA, contractor

Responsibilities:

• Remote Oracle database administration over 24x7 databases on hospital sites nationwide, including heavy database migration, initial configuration, trouble shooting, performance tuning, and auditing. Designed Batch Framework to provide process flow functionality.
• Disaster recovery and setup disaster recovery plan.
• Lot of UNIX script updates and creations. Developed auto-reporting system to generate database statistics from client sites into formatted monthly reports.
• Upgrade and/or apply patches to Oracle 8/8i.

Confidential, Alpharetta, GA

Oracle DBA/Project lead contractor

Responsibilities:

• On large variety of databases at enterprise level, regular maintenance over an Oracle Application 11i ERP & Financials (AP-$20B, AR-$850M, GL) including new setup and upgrade.
• Migration and configuration from Oracle7 and 8.05 over to Oracle 8i (8.1.6).
• Create/Setup Oracle Intelligent Agent and OEM for database server event tracking, monitoring, and job scheduling.
• Recover Manager (RMAN) configuration and setup.
• UNIX script developments. Maintained/support a data warehousing database. Modeling customer database into production.
• Some web development with Visual InterDev 6.0 with web server.
• Minor support on products of Sybase and Informix databases.

Confidential, Alpharetta, GA

Oracle/Sybase/MS SQL Server DBA contractor

Responsibilities:

• Enterprise environment with SUN Solaris. Created and maintained multiple databases instances in a mutli-tier and distributed processing architecture for an Oracle UNIX/NT OLTP application.
• Data modeling and performed database logic and physical design.
• Tuning and reallocating space and transaction definition of the parameters for all the table/index scripts, and tablespaces.
• Server and disk initial setup & configuration.
• Defined naming conventions.
• Migration and configuration from Oracle7 over to Oracle8/8i and setup WebDB. Performance tuning.
• Migration and configuration from Sybase System 10 to Adaptive Server.
• Some Sybase and MS SQL server administration tasks.

Confidential, Norcoss GA

Application Developer/DBA

Responsibilities:

• Performed a wide variety of application development DBA (Oracle, Sybase, and SQL server) and system design functions.
• Responsible for a critical performance & tuning project on Sybase 11/HP-UX 10.20, including reviewing index usage, joins, query optimization, disk and memory management, tuning SQL server and HP-UX system parameters (with tools of GlancePlus and Preview), applying patches to SQL Server and HP-UX, and benchmark testing.