SUMMARY

• Proven DBA with three years of Oracle GoldenGate/DataGuard experience in addition to 8 years managing employees and contractors responsible for day - to-day support of Oracle environments. Known for ability to handle multiple projects simultaneously in a fast-paced environment; knowledge of various DBMS platforms; and developing, documenting, and implementing policies and procedures to improve system availability. Highly motivated, self-directed with excellent communication skills. Able to use analytical mind to solve business problems.
• 7 years of experience in Designing, Developing, Deploying, implementing, maintaining and administering new platforms of Oracle Databases, including systems architect, project management, implementation and tuning of mission critical enterprise applications.
• Experience in installing, configuring and maintaining Oracle 10g/11g (RAC and non-RAC) databases, Exadata, Oracle Application Server 10.1.3 and 10.1.2, Web logic Server, OEM 12c, Cassandra (NoSQL).
• Experience in installing, configuring and administering Golden Gate replication technology.
• ExceptionalDatabase performance monitoring and tuning includes Instance tuning, Query (SQL) Tuning using Tkprof, AWR, ADDM, ASH, general troubleshooting, firefighting, developer/integrator relations, script development, documentation and DBA training.
• Experience in design and implementation of Streams in 10gR2 and Golden Gate technology.
• OEM 10g Grid Installation and Oracle Application Server installation, maintenance, performance tuning (JVM Sizing, HTTP tuning, Report tuning etc...) and Weblogic Server Administration.
• Auditing Past Transactions With Oracle LogMiner, diagnosing the efficiency of Disk Striping And Load Balancing, Data Encryption Management, Diagnosing Oracle Replication Timings and Replication Management.
• Experience in Migrating databases from file systems to ASM, Data from Non-production to production databases.
• Hands on experience in configuring Disaster Recovery Site for single instance and RAC databases.
• Hands on experience in upgrading databases from one version of oracle to higher version.
• Hands on experience in Shell Scripting.
• Capacity planning of critical production databases.
• Good Understanding and basic management skills of other RDBMS products like My SQL, Sql Server, DB2 on UNIX.
• Ability to plan, execute, and manage the loading for meta data from various sources including databases, database design tools, business intelligence tools, data integration tools, and business meta data artifacts.
• Skilled at writing SQL, Stored procedures, Functions & Triggers.
• Experienced in deploying J2EE applications on Oracle application server 10.1.2, Apache Tomcat web server and WebLogic, WebSphere, JBoss, Tomcat application servers.
• Solid Management skills, demonstrated proficiency in leading and mentoring individuals to maximize productivity, forming cohesive team environment also in onsite/offshore model and working in agile methodologies.

TECHNICAL SKILLS

Programming Languages: C, C++, Java, Visual Basic 6.0, PHP, SQL, PL/SQL

Operating Systems: Windows NT 4.0/XP/2000/2003/ME/95/98, Redhat linux, IBM AIX, HP Unix, Sun Solaris 2.x, OS 390/AS 400

RDBMS: Oracle 9i/ 10g/11g, SQL Server 7.x, MS Access 7.x

Web Technologies: HTML, XML, JavaScript, VBScript, ASP

Tools: Dream weaver 4.0, Flash 6.0, Microsoft Visio, SQL*Plus, OEM, TOAD, RMAN, Exp/Imp, Expdp/Impdp, SQL, PLSQL, RAC, ASM, GoldenGate, Data Guard, Streams

Testing Tools Scripting: Win Runner’s TSL, Load Runner’s TSL, SQABasic

Networking Protocols: TCP/IP, RIP, UDP, OSPF, BGP, BOOTP, DHCP,SMTP

Application Servers: Oracle Application Server, Tomcat and Apache WebServer, Weblogic, Websphere,CRM, Data warehousing, Business Intelligence

PROFESSIONAL EXPERIENCE

Confidential

Senior DBA

Environment: Oracle 11g/10g/9i, Linux/HP-UX/AIX/Solaris & windows 2000, RAC, ASM, AWR, ADDM, EXP/IMP, Data pump, Data Guard, Golden Gate, Streams, DataGuard, SQL * Loader, STATSPACK, MViews, Partitions, TOAD, SQL Trace/ TKPROF, PL/SQL, Shell Scripting, cron jobs, Precise

Responsibilities:

• Involved in all phases of the project; requirements gathering, Impact Analysis, design, coding, database deployments, unit testing, performance testing, UAT Testing.
• Install, configure & upgrade Oracle software and related products in a UNIX/Linux/AIX environment
• Create and implement backup & recovery methods and disaster recovery methods using RMAN & third party backup tools ( Data Protector from HP)
• Database tuning for optimal performance to meet Business SLA*s
• Oracle database move from AIX to Linux (2015) - Designed and implemented GoldenGate and Data Guard replication solution to allow immediate switchover and switchback between Oracle 11gR2 on AIX and Linux.
• Data Split (2014) - Designed and partially implemented GoldenGate replication solution to split data from consolidated schema in three source databases on IBM/AIX into 6 schemas on 6 smaller databases on Linux. Included moving to new databases in a phased approach over several months. Design included full DR solution utilizing GoldenGate replication enabling the ability to convert from 3-way replication to 2-way replication. Also evaluated GoldenGate Conflict Detection Resolution (CDR) options and performance impacts.
• Application upgrade (2013) - Designed GoldenGate replication solution utilizing conversion database to replicate data from 2 down-level production source databases to single conversion database where GoldenGate transformation and SQLEXEC processes were utilized to convert data on-the-fly to new application version and then used cascading replication to populate 2 new up-level production databases.
• Oracle database move from HP to IBM (2012) - Utilized GoldenGate replication to move Oracle 10g database from HPUX to Oracle 11g database on IBM/AIX. Automated scripts to reverse replication as needed. Designed combined DR/Up-Level/Down-Level solution using a combination of GoldenGate and Data Guard replication. Challenge: due to hardware issues, replication was reversed many times before final move to AIX.
• Data Segmentation (2011) - Designed and implemented GoldenGate multi-way replication solution. Project started with converting DR database into active application database and implementing 2-way replication between the two data centers. Project also included upgrading production databases in both data centers to 11gR2 RAC and implementing a third data center. End environment was three 25TB databases doing 3-way replication and 1-way replication to reporting and other down-stream applications.
• Up-Level/Down-Level (2010) - Implemented multiple minimum-downtime solutions for new software releases. One project included switching between different databases each release and the other project included creation of up-level tables within the source production database.
• Designed and implemented all required GoldenGate changes for required transformation routines including use of SQLEXEC statements to invoke stored procedures. Release weekend tasks for switching databases included changing DNS and LDAP aliases and reversing GoldenGate replication. Release weekend tasks for up-level tables included renaming objects and repointing synonyms.
• Installed RAC10g on 2 node cluster for large production system and migrated the legacy system from Non-Rac environment to RAC11g cluster database and configured.
• Duties includedDatabase performance monitoring and tuning includes Instance tuning, Query (SQL) Tuning using Tkprof, AWR, ADDM, and ASH, general troubleshooting, script development, documentation and DBA training.
• Experience in Migrating databases from file systems to ASM, Data from Non-production to production databases.
• Maintains 8 production databases and we configure Golden gate to keep all the databases in sync.
• Also enabled Replication between 90 Test databases using Golden Gate.
• OEM 10g Grid Installation and Oracle Application Server installation, maintenance, performance tuning (JVM Sizing, HTTP tuning, Report tuning etc...) and Weblogic Administration.
• Built oracle databases in non RAC and RAC environment on oracle cluster ware, ASM.
• ASM Management using RAC utilities like SRVCTL, OCRCHECK, OCRDUMP and CRSCTL.
• Synchronizing the Development, System Test and Production Like databases with Production DB dumps using exp and imp and data pump & Steams technologies.
• Provided 24/7 Production Support for all mission critical system.

Confidential

Senior Oracle DBA

Environment: Oracle 10g, 9i, SQL, PL/SQL, TOAD 9.0, OEM 9.0.2, RAC, Developer 2000, RMAN v9.2.0.2.0, DBA Studio, Windows XP, SQL *Report, SQL * Forms, SQL*Loader, Windows 2000, UNIX Shell Scripting.

Responsibilities:

• Provide primary DBA design and support services for establishing, upgrading and maintaining the Oracle software environments, which support the company.
• Create, maintain and refresh required Oracle instance for development, test and production environments.
• Provided 24x7 On Call production support including remote support.
• GoldenGate for DR - Designed and implemented solutions for multiple applications including: (1) one-way replication for small application to DR database and tiered recovery database utilizing 4-8 hour deferred apply, (2) one-way replication to real-time reporting database and DR site. Created and automated process for reversing replication in case of a disaster, (3) replication of 20TB of data from production which ran heavy batch jobs in addition to OLTP to a secondary database for real-time reporting.
• GoldenGate for Reporting and DR - Inherited real-time reporting project from another resource. Reviewed and simplified design and parameter files to improve performance and ease support requirements. Designed, coded, and implemented monitoring scripts for down processes, lag, and error messages. Then designed and implemented scripts required to reverse GoldenGate replication to convert reporting database to DR.
• Handled oracle DBA jobs and have experience with SQL and PL/SQL
• Created different types of Indexes (B tree, reverse key, IOT and Bitmap etc), different types of partitions (List, Range, Hash, Composite etc) on different tables.
• Managed undo space management, Oracle DBMS tuning.
• Understanding of table space layout, volume layout, RAID striping techniques.
• Implemented the Advanced Snapshot Replication.
• Experience implementing 10g RAC (using raw devices, ASM) for test environment.
• Analysis and management of Oracle problems/defects using TARs and or Metalink with Oracle Corporation and installation of patches
• Manage DBA projects related to database upgrades, platform changes, and/or new technology deployment and provide status reports to IT management. Handle off-hours on-call responsibility on a rotating basis to resolve critical problems as they arise.
• Participate as part of a team ensuring daily system operations are smooth, this may include following daily checklists, participating in status meetings as well as being on-call.
• Done performance tuning using SQL application tuning using TKPROF, SQL TRACE for session, STATSPACK, Explain plan.
• Provided tuning support for SGA (shared pool, buffer pool and log buffer pool etc).
• Used RMAN to Migrate the Non-ASM Database to ASM Database

Confidential

Senior Oracle DBA

Environment: Oracle 9i, Oracle 10g, SQL, PL/SQL, TOAD 9.0, OEM 9.0.2, RAC, Developer 2000, RMAN v9.2.0.2.0, DBA Studio, Windows XP, SQL *Report, SQL * Forms, SQL*Loader, Windows 2000, UNIX Shell Scripting.

Responsibilities:

• Install, configure & upgrade Oracle software and related products in a UNIX environment
• Create and implement backup & recovery methods and disaster recovery methods using RMAN & third party backup tools ( Data Protector from HP)
• Database tuning for optimal performance to meet Business SLA*s
• Design, test and implement Oracle high availability solutions
• Establish effective database performance monitoring procedures. Execution plan analysis, tuning and optimization. Proficient in influencing data access paths via SQL hints and physical changes (indexes, partitioning, init parameters and SGA)
• Responsible for operations of all Oracle databases, and all database servers including performance management, capacity planning, operational stability/reliability
• Setting up automated routine tasks such as monitoring, alerts, backups, and replication
• Ensuring that all server environments (development, QA, production) are synchronized with respect to software release levels
• Maintain a current awareness of technological developments and trends as it relates to the administration Oracle (training and tools)
• Perform in database design and development of new structures and code as required.
• Allocate systems storage & develop plans for future storage req.(Capacity planning)
• Set up and maintain documentation and standards.
• Proactively monitor and report key system performance metrics, using the wait interface, tools, stats pack and Symantec Precise.
• Performance tuning of custom application schema, provide security recommendations, and storage management. Modify database structure to support applications and data growth.
• Create, replicate, clone and upgrade environments (Oracle Software and DB) to support implementation activities as required..
• Act as information resource for questions about the RDBMS (andrelated software) to developers, management, operators, and users.Should be able to provide information concerning SQL code duringtuning of stored procedures and triggers.
• Proactively build good relationships with business partners and otherpersonnel for solving work-related issues.
• Rotational On-call support

Confidential 

Oracle DBA

Environment: Oracle 8i, SQL, PL/SQL, TOAD 5.0, OEM 4.0.2, DBA Studio, Windows XP, SQL *Report, SQL*Loader, Windows 2000, UNIX Shell Scripting.

Responsibilities:

• Administered and provided production & development DBA support to the several databases (Oracle 8i, Sybase ASE & SQL Servers) of Business Objects Technical support team.
• Provide expert assistance in setting up instances, tablespaces, tables, indexes and views. In conjunction with programmer/analysts, define new objects or modifications to existing objects.
• Provide expert assistance in SQL statement tuning to improve performance. This includes, but is not limited to, re-writing SQL statements, creating new indexes and altering existing indexes
• Setting up database environments for reproducing and resolving the customer issues and exporting and importing the customer dump files to the databases
• Serve as primary DBA support for mission-critical or problematic databases, and own problem resolution from end-to-end
• Daily and intraday monitoring of database health - availability, reliability, performance, capacity planning, server clustering, replications, DR implementations e.g. log shipping, and connectivity, with timely production issue remediation
• Performance tuning: Indexing, compression, drive distribution, load-balancing, replication
• Coordinate with and provide support for applications programmers, system programmers, users, administrators, and IT personnel where databases are concerned.
• Install DBMS patches as supplied by the vendor as needed, in coordination with systems administration and Firm security policy, as well as ensuring all server builds and patches are current
• Responsible for design procedures for business continuation planning (daily backup and recovery as well as backup integrity checks) as required by system-availability/SLA agreements for each application
• Providing consultation and development support for the physical database design for database applications in production and development environments
• Responsible for maintaining and providing DBA-level access as required for all production-status applications on production and support/staging environments (DBA-level access in a development environment is shared with the development staff)
• Providing database device configuration data (hardware and software) for systems administration, such as disk usage, memory, etc