SUMMARY:

Senior Oracle HA DBA with considerable experience in installing, upgrading and managing Grid infrastructure, ASM and Oracle Database with Real Application Clusters (RAC). Exposure to various industries covering OLTP, OLAP, DW, ODS technologies in a Multi tier, Virtual and Cloud computing enviroments. Expertise in supporting large scale, mission - critical database systems, configure them for high availability, highly scalable and disaster recovery. Provide support for application development, Code deployments, Performance Tuning, System Integration. Thorough understanding of Data Analysis, Data Integration, Data Modeling and Reverse Engineering. Strong programming and end-to-end application development experience. Posses good analytical, troubleshooting and problem solving skills. Exposure to project management and ITIL. Successful in managing resources on- and off-shore.

TECHNICAL SKILLS:

Databases: Oracle RAC 10g, 11g R2, Cache

Oracle Tools: SRVCTL, CRSCTL, ASMCMD, ADRCI, Golden Gate, Data Guard, SQL*Loader

Administration Monitoring: Oracle 12c, Oracle Enterprise Manager - Grid control, TOAD, Embarcadero performance center

Backup & Recovery: Oracle RMAN, BMC SQL-Backtrack, Datapump

Operating Systems: Sun Solaris, Sun OS, AIX, HP-UX, RHEL, MS Windows

Languages: SQL, PL/SQL, C, Pro*C, C++, Unix shell scripting, Widows batch programming, Perl, Cgi-perl, HTML, XML, Java

Development, Reporting: Developer 2000,Oracle Forms Developer 6i, Oracle Reports Developer 6i, SQR, Brio, Hyperion Performance Management 8.3, RoboHELP

Job scheduling: CRON, AT, AppWorx

Hardware: IBM Power 750 Express server, SAN-Clariion CX4 Model 480, NCUBE, AMD64, HP 3000, DEC Alpha, RS 6000, Sun 3's, Sun SPARCstations, VMS 6000, Alpha AXP

PROFESSIONAL EXPERIENCE:

Confidential, Addison, TX

Senior Technology specialist Databases - ( Oracle DBA )

Responsibilities:

• Successfully installed, upgraded and configured Oracle Grid infrastructure, ASM and Oracle Databases for high availability. As part of this major upgrade, we have converted RAC to non-RAC, Multi node RAC to Single node RAC, RAC to non-RAC then convert non-RAC to multi node RAC. Around 40+ databases were part of this process. All of these are running on Oracle 11g R2 and Solaris 10; Implemented data files using either ASM or on raw devices for some projects.
• Used Data Guard to create physical standby for disaster recovery, and logical standby for Cognos reporting
• Designed and created backup scripts and tested database restores . Monitor and manage space for LUNs, Tablespace, Datafile. Monitor system resources, system performance, used AWR, ADDM for tuning long running SQLs and fixed by adding additional indexes, changing access paths, rewriting queries, adding Partitioning and collecting statistics on ad-hoc basis; Refreshed dev and test databases with production data. Weekly on-call rotation with 24X7 support and weekend maintenance
• Used Toad, Oracle Enterprise Manager Grid Control, Oracle 12c

Confidential, Fort Worth, TX

Oracle DBA

Responsibilities:

• Administer and Upgrade Oracle databases running on HP-UX. These large-scale databases support logistics applications and Oracle EBS applications.
• Design and Develop scripts to refresh applications and build test databases with subset of refined data. Migrate large volumes of production data to archive databases
• Closely monitor disk space, system load, disk IO, CPU and memory usage. Identify top oracle processes, top SQL to troubleshoot performance issues. Identify locking sessions then work with users to clear holders or waiters. Identify and Kill zombie sessions
• Oversee off-shore team for weekend maintenance. Send monthly activity reports to management about sessions, batch jobs, CPU utilization.
• Co-ordinate with other teams to rollout WMS application code, MQ broker code, and Promoting Oracle EBS code. Weekly on-call rotation with 24X7 support and weekend maintenance

Confidential, Jackson, MS

Oracle DBA

Responsibilities:

• Install, configure and administer 20+ Oracle databases running on SunOS, Linux and Windows. These databases support medical center critical applications like ERP, Clinical and revenue cycle.
• Design and implement backup & recovery solutions using RMAN and BMC SQL-Backtrack. Clone/Refresh test, development databases with production data. Perform Tablespace Point-in-Time Recovery. Tested crash recoveries using conventional hot & cold backups, RMAN and BMC-Sqlbacktrack
• Upgrade databases and Migrate databases using export/import, data pump
• Tune all Oracle instance components including SQL queries and PL/SQL. Analyze Key Performance Metrics and Monitor health of databases using OEM, Toad, Embarcadero Performance Center. Awareness of EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports. Create automated scripts for additional monitoring
• Experience in Materialized Views, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management.
• Plan, Install, upgrade, configure, administer, monitor, troubleshoot Cache Databases and Epic Environments on AIX 6.1 Power 750 Express server;

Confidential, Clinton, MS

Senior Software Engineer / Oracle DBA

Responsibilities:

• Collaborated on suite of mission critical applications (ITRS, INMP, INSR, LCR, NTTR) to process incoming calls from all Verizon international switches, generating more than $5 billion in annual revenue; processed data was sent to downstream billing systems and several reporting systems.
• Installed, configured and administered Oracle databases running on Sun Solaris. Did backup & recovery using RMAN. Populated test, development databases with production data.
• Did complex data analysis, studied end-to-end application and data flow, understood relationship among the tables to investigate and create user queries. Developed ad-hoc, Decision support tools. These used to reconcile billing with major carriers and save millions of line cost.
• Maintained ad modified business logic to summarize data using C++ and PL/SQL, as well as cgi / perl and shell scripts for reporting. Used SQL*Loader and External tables to load summarized data into oracle data warehouse; Created materialized views on Fact tables for fast queries.
• Developed reportsusing Brio, installed Hyperion Performance Management, and migrated Brio reports to Hyperion. Designed and maintained metadata models and tables.
• Served as subject matter expert / team lead for international traffic systems. Gathered requirements from users, coordinated development with Verizon off-shore development team, reviewed design documents with external users to confirm requirements, and provided code management to release code to production boxes.

Confidential, Ann Arbor, MI

Programmer Analyst

Responsibilities:

• Gathered requirements for high-level system design; wrote technical designs, created test plans / cases, and performed unit and system testing for mortgage processing application
• Participated in logical and physical database design and data modeling, including data normalization
• Developed screens using Oracle Forms. Developed reports using Oracle Reports. Created SQR reports and integrated with Oracle Forms. Developed packages, libraries, database triggers, stored procedures, object libraries and Java stored procedures. Utilized hierarchical trees, reference cursors, PL/SQL tables, and built in packages. Tuned web forms, reports, and queries for optimum performance.
• Wrote load programs to load Oracle tables from flat files and developed modules to schedule and extract data using AppWorx. Created web interface using HTML, JavaScript, and JSP to enter and retrieve data formats for load programs and reports.

Confidential, Ann Arbor, MI

Programmer Analyst

Responsibilities:

• Designed and developed GIDIAMS (Global Investigational Drug Information and Management System) application according to software development methodology using Oracle designer, Oracle Forms and Oracle Reports.
• Performed logical and physical database design for test database; created entity relationship diagrams and data models, including data normalization. Coordinated performance tuning to reduce response time for long-running queries.
• Developed packages, libraries, database triggers, stored procedures, object libraries, and Java stored procedures. Wrote scripts to generate packages and data base triggers automatically. Designed and developed audit packages and integrated SQR into forms. Created form templates and set GUI and PL/SQL standards.

Confidential, Dearborn, MI

Programmer Analyst

Responsibilities:

• Designed, Developed various Front end applications using Oracle Designer, Oracle Forms, Oracle Reports, Pro*C. These applications establish and manage plant, do inventory of parts and help designing new automobiles and enforce signoff process.
• Developed distribution kit using InstallShield and completed performance tuning to reduce response time for long running queries. Migrated data from flat files to Oracle database using Pro*C