SUMMARY

• Over 12 years’ experience as Oracle Database Administrator (8i/9i/10g/11g) on different Operating systems including: AIX, Linux, Red Hat Enterprise Linux, Unix - AIX, HP-UX, Sun Solaris (5.6/5.7/5.8/5.9 ,10) and Windows 2000/NT/XP.
• Support of Oracle 9i, 10g and 11g, 12c SQL Server, and DB2 Databases on AIX, HPUX, LINUX, and Windows platforms.
• Responsible for providing database support and performance tuning on both an online-transactional and online-analytical processing environment.
• Developed rules and standards for the access and maintenance of shared data resources using Oracle.
• Designed technologically advanced solutions to meet customer's mission, objectives, and requirements.
• Improved automation, operation stability, and performance by researching new features and functionality with each release.
• Ensured database configurations comply with published standards.
• Developed transaction logging and backup/recovery facilities.
• Participated in defining and implementing data security and logical to physical database mapping and table parameters.
• Created database schemas and sub-schemas and Work with application development teams to ensure efficient data access in application programs and to review test benchmarks and statistics.
• Reviewed overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirements.
• Assisted in technical support in the definition and resolution of database problems.
• Tuned and improved application SQL code, database configuration parameters and system disk configurations.
• Acted as the primary interface between the Critical Systems team and the middleware/DBA team.
• Provided complete documentation on developed recommendations and solutions.
• Provided technical assistance to IT support staff.

PROFESSIONAL SUMMARY

Confidential

Oracle Database Administrator III

Responsibilities:

• Practice self-development and promote learning in others by proactively providing information, resources, advice, and expertise with coworkers and customers; building relationships with cross-functional stakeholders; influencing others through technical explanations and examples; adapting to competing demands and new responsibilities; listening and responding to, seeking, and addressing performance feedback; providing feedback to others and managers; creating and executing plans to capitalize on strengths and develop weaknesses; supporting team collaboration; and adapting to and learning from change, difficulties, and feedback.
• Meet timelines to drive the delivery of appropriate, sustainable, and prompt solutions.
• Assist all the technical and project team members to resolve system problems and application-specific issues.
• Support the stability, availability, and performance of enterprise systems (e.g., systems, applications, network, databases, storage, security) by performing complex systems analysis to identify problems, trends, and opportunities for improvement.
• Provide first and second level support for enterprise systems and systems in one or more additional IT domains by diagnosing, troubleshooting, and resolving complex incidents to minimize system issues.
• Escalate unresolved or critical issues, risks or problems to system engineers.
• Support communications with product users and suppliers to share information, identify opportunities, resolve problems, prioritize customer requirements, and maintain continuous improvement through customer feedback.
• Plan and perform complex system configuration.
• Participate in installs, upgrades, or decommissions of designated systems, products, and infrastructure.
• Create documentation of new and existing system configuration and procedural information, and ensures system configurations documentation is complete and accurate.
• Plan the implementation of hardware and software changes into environments and one or more additional IT production environments by performing impact analyses of system changes.
• Support vendor support activities, as appropriate.
• Participate in and influences change management processes with bi weekly on call rotations.
• Define the maintenance, modification, and documentation of complex and advanced OBIEE applications.
• Support the development of guidelines to prevent and/or resolve recurring problems.
• Recommend and executes performance tuning and optimization activities.
• Work and implement GoldenGate Uni-Directional/Bi-Directional Replication for Delphix and Exadata Quarter Rack Engineered Systems for the X4-X5.

Confidential

Principal Technical Support Engineer

Responsibilities:

• To manage and resolve Service Requests logged by customers (internal and external) on Oracle products and contribute to proactive support activities according to product support strategy and modelOwning and resolving problems and managing customer expectations throughout the Service Request lifecycle in accordance with global standards
• Maintaining product expertise in High Availability technology products (RMAN, DataGuard, Oracle Secure Backup, etc.)
• Working towards, adopting and contributing to new processes and tools (OWC, diagnostic methodology, health checks, scripting tools, etc.
• Participating in proactive knowledge activities.
• Working with development on product improvement programs (testing, BETA programs etc.) as required.
• Operating within Oracle business processes and procedures.
• Respond and resolve customer issues within key performance Indicator targets
• Operate in line with Bug Diagnosis and Escalation/Development Bug guidelines in resolution of Bug related Service Requests.

Confidential

Sr Oracle DBA

Responsibilities:

• Working on Exadata performance tuning and migrations of systems to Exadata platform.
• Creation and implementation of all aspects of 12c RAC - Including but not limited to storage requirements, setup and pre checks in terms of hardware, software and storage and successfully building out a 3 node 12c RAC cluster on RHEL.
• Day to day tuning of complex SQL queries for Quest Diagnostics Applications.
• Weekend maintenance and space management using Partition drop activities including but not confined to dropping
• Referential, Interval, Graph, Power and Unknown Partition types for Oracle 11.2.0.3 databases running on RHEL Solaris.

Environment: Oracle 9i/10g/11g/12c, Red Hat Enterprise Linux, Sun Solaris, Windows XP/Server 2000, UNIX Shell Scripts and Perl Scripts, Tivoli Manager, VERITAS NET BACKUP,TOAD for Oracle 10, ORACLE SQL DEVELOPER 2.1, Toad for DBA, Networker for Backups.

Confidential

Oracle DBA Architect

Responsibilities:

• Project was about migrating all the from its old legacy health care system to new Exadata Quarter Rack system. This included migrating the Medicare and Medicaid Members, Enrollments, Providers, Contracts, Claims/Encounters, Service History and Authorizations and Utilizations to the new system from the Legacy Systems.
• As a database architect, I was involved in the end to end system planning, design, mapping and data delivery for the Core and Care Applications from Business as well as IT perspective. Initiated and coordinated the analysis and design requirements for ODS (operational Data Source) including schema and ETL scripts.
• Worked closely with Oracle BI Suite on the system configuration and reporting compliance requirements to be implemented as part of the Business Intelligence reporting application.
• Worked with different Business Units (viz. Provider Management, Claims Processing, Payment Processing, Services and Membership etc.) to capture gaps and functional requirements.
• Worked with Vendors to setup various Environments for project implementation.
• Coordinated with various Vendors and the EDI teams to Load data to applicable EDI interfaces.
• Provided input to activities for the ASPEN/ Development teams on issues they may be working on, or to any INT, QAT, UAT and PROD issues that needs addressing from an application perspective as well as from the database side.
• Responsible for migration of all the 11.2.0.2 (Image Now) & 11.2.0.3(ASPEN/YESNM) databases from Single Instance residing on VBlock to Quarter Rack Exudates for which we have 2 Database Machines - One is high capacity and other is high performance to 11gR2 RAC databases.

Environment: Oracle 10g R2, 11g R1/R2,RAC,DATAGUARD, ASM, Red Hat Enterprise Linux Server release 5.8 (Tikanga), Windows XP/Server 2000, UNIX Shell Scripts and Perl Scripts, Tivoli Manager, VERITAS NET BACKUP,TOAD for Oracle 10, ORACLE SQL DEVELOPER 2.1, Tkprof and L*Net/Net8

Confidential

Oracle Data Architect

Responsibilities:

• Data Warehouse Architect responsible for the design, building, testing, and documentation of an Enterprise Data Warehouse integrating several source system schemas using Oracle Warehouse Builder (OWB 11gR1) and Oracle 11g. Designing and implementing the ETL process using several staging schemas and an Operational Data Store for reporting using Business Objects. Dashboards are being implemented for monitoring the job feeds as well as monitoring data quality. The stage and target star / snowflake schemas are being designed and modeled using ERWin as a data modeling tool
• Designed and implemented stage, vault, and datamart schemas using Oracle 10g database, Oracle Warehouse Builder11gR1
• Developed several Oracle database standards documents including schema design, installation+patch, feed system designs, database configurations, as well as installation documents and security..
• Provided input to activities for the teams on issues they may be working on, or to any production issue that needs addressing.
• Reviewed all tables in the eprd and mprd database where the clob columns are used. For the clob columns that are not compressed, review and make recommendations on addition tables/clobs that would benefit from compression. Made sure to review the usage patterns for all the tables where clob columns are used. Researched on how the table and its clob column are used by the application and if the clob compression is appropriate. Reviewing the top sql reports was a good starting point for this activity.

Environment: Oracle 11g R1/R2, MySql 5.5 Enterprise 5.5, Java, Ruby on Rails, RAC One Node, Exadata, Red Hat Enterprise Linux 5.4, OEL 5.8, 6.2, Windows XP/Server 2000, TOAD for Oracle 10, ORACLE SQL DEVELOPER 2.1, Tkprof and SQL*Net/Net8, Dell R910 Servers, SunFire x4150 DB Servers, F5 Big IPS LTM (Local Traffic Managers) used for Load.

Confidential

Sr Oracle DBA

Responsibilities:

• Installed, configured, upgraded, migrated and patched Oracle 9i/10gR2/11g databases in heterogeneous environment.
• Extensive worked on the production piece of Oracle 10gR2/11g environment including RAC, PL/SQL, OEM Grid control, Data Guard, ASM, RMAN, Partitioning, database tuning and troubleshooting.
• Planned implemented and maintained Disaster Recovery methodology for all production databases and also suggested best practices to ensure High Availability at all times.
• Technical Team Lead for other Database Administrators which also included Sybase and Sql Server DBA groups for Lending Mortgage DBA Group.
• Worked extensively with technical architects and developers to ensure data model met the platform's requirements from the business and technical perspectives.
• Defined business object/database table mappings and structures, fail-over strategies and distributed data strategies.
• Ensured database objects (views, stored procedures, triggers, constraints, etc.) and SQL statements met performance and security objectives.
• Ensured database migration scripts and programs meet data integrity, performance and security objectives by testing them in DEV, UAT & Pre Production environments.
• Maintained and published the database installation/operation guide and other pertinent documentation for the technical and application teams.
• Developed, reviewed and enforced database standards as laid out by Oracle.
• Wrote Perl scripts and PL/SQL scripts to fetch, parse and load data from the external sources. Supported databases were on Linux and Solaris.
• Planned, implement and tested company’s disaster recovery strategy using RMAN.
• Worked on Oracle Virtualization using Oracle VM for x86 machines.

Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, Red Hat Enterprise Linux, Windows XP/Server 2000, UNIX Shell Scripts and Perl Scripts, Tivoli Manager, VERITAS NET BACKUP,TOAD for Oracle 10, ORACLE SQL DEVELOPER 2.1, Tkprof and SQL*Net/Net8.

Confidential

Sr Oracle DBA

Responsibilities:

• Working and troubleshooting all kinds of technical issues related to SAMS CLUB databases and Online Customer Orders Management System.
• Provide 24x7 on call Support for Remedy issues and tickets and interact with Off-Shore teams and drills in India.
• Handle all aspects of ORACLE RAC clusters and Data Guard and maintain a High Availability Architecture with preferably zero downtimes.
• Handle and troubleshoot all aspects of Oracle Enterprise Manager Grid Control and Agents.
• Interacting with Client DBA team and teams in Brisbane, CA to work on Production issues and database refresh.
• Activities and testing and switching over of existing DATAGUARD physical standby databases.
• Working on a migration plan to upgrade database applications from 10g to 11g platform.

Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, Red Hat Enterprise Linux, Windows XP/Server 2000, UNIX Shell Scripts and Perl Scripts, Tivoli Manager, VERITAS NET BACKUP,TOAD, ORACLE SQL DEVELOPER 2.1, Tkprof and SQL*Net/Net8.

Confidential

Sr Oracle DBA

Responsibilities:

• Configured optimal Oracle 10g/11g RAC architecture and Golden Gate Replication.
• Performance Tuning for Oracle Real Application Clusters (RAC).
• Prepared plans for upgrading of all critical Production Databases from 10g to 11g on Linux and ACTIVE DATAGUARD implementation with RAC.
• Interacting with Vendor support to resolve issues
• Worked on changing NLS Character sets
• Resolution of production issues which included interacting with Oracle Support as we as Metal ink Usage.

Environment: Oracle 10g R2, 11g R1,RAC,DATAGUARD, ASM, GOLDENGATE, Red Hat Enterprise Linux Windows Server 2000, UNIX Shell Scripts, VERITAS NET BACKUP,TOAD, Tkprof and SQL*Net/Net8