Oracle Manager

SURESH MEDURI

Cell: 703-***-**** (Expired) Secret Clearance ************@*****.*** US citizen Oracle certified Associate (11g) https://www.linkedin.com/in/suresh-meduri-19368a16/

IT DATABASE ORACLE ADMINISTRATOR/ Applications DBA

Customer- oriented IT Database specialist with notable success directing a broad range of corporate IT initiatives while participating in planning, designing, and implementation of information-technology solutions in direct support of business objectives.

• Provide support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/DataProtector, trace analysis, service creation, cluster and system management.

• Excellent communication skills and experience communicating with management at all levels both orally and in writing.

• 20 years of IT career experience with 15+ years as a Database Administrator. 11 years of Federal experience (Department of Defense & Department of Transportation) as a contractor with databases and systems administrator.

• Installed, configured and tested several Oracle dataguard installations for physical standby systems to the production systems using Linux operating systems. Versions of the databases were from Oracle 8i and Oracle 12C.

PROFESSIONAL ACCOMPLISHMENTS

FAA, Mclean VA Senior Database Administrator July 2016 – May 2017

Designed, configured and installed Oracle 12C on Linux server for standby database.

Tuned existing queries for the upgrade version of the application for the FAA Prism.

Analyzed the existing version of the Prism database to suit the needs of the latest version of the application and the Oracle database.

Participated in the meetings with developers and stake holders of the Prism application to move to the latest version of Oracle 12C.

Cloned databases from Production to Development and Test environments.

Installed standby database for the Production which is on Oracle12C with Linux 6.7 server.

Written technical documents for the migration of the database.

SunGard Inc, Geneva, IL Oracle Apps DBA April 2014 – June 2016

Installed and upgraded Oracle 11g databases on standard and enterprise editions.

Upgraded Oracle 11g enterprise databases to 12c Installed and configured Oracle dataguard on STCM and OBS servers for replication.

Designed and developed a DR system for the production STCM.

Created cron jobs for maintenance of the daily tasks like purging and deleting the files and directories.

Upgraded existing systems of Oracle databases from version 11.2.0.3 to 11.2.0.4. enterprise and standard editions of Oracle Servers on Linux environments.

Maintenance of SOA suite with forms, reports and web-logic front-end.

Starting and shutting down the Web-logic server on needed basis.

Maintenance of databases included backup and recovery using RMAN.

Extensive experience in configuring and implementing ASM and using ASMCMD and ASMLIB.

Worked with Oracle Apps E-Business Suite systems like refreshing production to QA system.

Deployed and modified code and maintained XML burst for generating invoices.

Created, disabled, and modified users for the Oracle Apps systems.

Generated reports in Oracle EBS for the Executive management and Security management.

Cloning and duplication of databases using RMAN.

Installed and configured Dell Shareplex for production to DR systems for STCM using for data replication purposes.

DOD, North Chicago, IL Senior Oracle DBA July 2013 – Mar 2014

Design and developed Oracle 11g databases on Linux.

Installed and configured Oracle Fusion Middleware software including Web-logic server and Jboss, Tomcat app servers.

Maintenance of SOA suite with forms, reports, OIM and web-logic front-end.

Starting and shutting down the Web-logic server on needed basis.

Modified and tuned existing code in PLSQL for the customer requirements.

Implemented single sign on all the three stack servers test, development and production environment. Created and renamed tables, users, roles using Toad for the creations of scripts.

Implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC) and specific network storage and clustering solutions.

Experienced in configuring and implementing ASM, using ASMCMD and ASMLIB.

Assisted developers in their code which include PLSQL, SQL and creation of materialized views.

Performance and tuning of the databases using ADDM, AWR and ASH reports.

Created scripts for Backup and recovery using RMAN.

Duplicating databases using RMAN for the databases for testing and quality assurance purposes. Written technical guides and user guides for the customer.

Consolidation of databases and migration from Oracle9i to Oracle 11g.

Census Bureau, MD DBA/Middleware Administrator February 2012 – June 2013

Maintained and monitored Oracle Fusion Middleware systems, OID, PORTAL, Web-logic server and Apache servers using single sign on.

Maintenance of SOA suite with forms, reports, OIM, and web-logic front-end.

Involved in designing and implementing the application process flow with BPEL.

Development, deployment and testing of various BPEL Processes.

Involved in designing SOA interfaces with BPEL for different applications.

Configuration and maintenance of WebLogic with JDBC, JMS, JNDI, SNMP and J2EE Services.

Deployed applications (WAR, EAR, JAR) in Domain and Clustered environments. Configured JDBC Connection pools and Data-sources with Oracle database.

Starting and shutting down the Web-logic server on needed basis.

Performance and tuning of the Oracle 11g production databases using Oracle tools like ADDM, ASH, AWR and various advisers.

Implementation and support for high availability solutions using Oracle Data Guard, Real Application Clusters (RAC) and specific network storage and clustering solutions.

Experienced in configuring and implementing ASM, using ASMCMD and ASMLIB.

Backup and recovery of Production, Development, Test databases using RMAN and Veritas backup tools on daily and weekly basis.

Installed and configured Oracle dataguard on production system for replication purposes.

Monitoring databases using Toad, Enterprise Manager, Grid Control, and Reflection terminal.

Assisted in tuning, development of reports and forms on the middleware layer.

Upgraded Oracle 11.2.0.1 to 11.2.0.3 and applied CPU patches for all the database servers.

DOD, Reston, VA Senior Oracle DBA August 2010 – Jan 2012

Designed and configured Oracle 11g, 10g databases on Sun Solaris machines.

Designed and modified logical and physical data models using Erwin 7 for the DOD applications. Applied CPU patches and IAVA patches to meet the DOD requirements and custom requirements. Worked as production DBA supporting a team of DBAs' globally.

Duties included backup and recovery, migration, maintenance, tuning, replication, development, developers requirements and ad-hoc reports.

Performance and Tuning of the Oracle databases using ADDM, ASH and AWR tools for the development and Production databases as per the users request.

Installation of COTS products, customized applications for the users of RFID.

Periodically refreshed the data for test, development and staging environments.

Extensive use of tools like Toad, Subversion, Exp and Imp, Data-pump, RMAN, Enterprise Manager, DataGuard and SQL Developer.

Worked on technical, user manuals and other documentation for various systems as per client requirements.

Pentagon, DOD Supervisor/Database/Administrator November 2005 – July 2010

Managed 4 projects (Department of Army Headquarters Tracking System) HQDATS, (ASP) Army Suggestion Program, (ASBCA) Armed Services of Board Contract of Appeals, and Checkbox Survey Server.

Designed logical and physical data model using Erwin 3.5.1 for the Army Suggestion Program and HQDATS.

Installed and configured Oracle dataguard on Oracle server for replication purposes.

Installed and configured several SQL databases for the Customer.

Worked on configuring the IIS for several applications.

Maintainence of SQL Server databases in tuning, capacity planning and space management.

Tasks include support of the team in SharePoint, Humming Bird Document management Services, StarTeam, Webhosting team and Systems Administration.

Responsibilities include planning work to be performed by team members, set and adjust short-term priorities, and prepare schedules/project plans for the completion of work based on priorities.

As PS Admin tasks include truncating tables, indexes rebuild, purging cache, database cloning and backup issues.

Debugged code written in PLSQL and SQL for performance tuning.

Suggested and guided developers in their code written in PLSQL and SQL for performance.

Migrated data from Sybase ASE 12 to Oracle databases and SQL Server databases on windows platform.

Generated scripts using Toad for the developers in creation and modification of tables, views, roles and other objects for development databases.

Applied Oracle patches and IAVA security patches and DISA STIG for the Oracle databases.

USPS, VA Oracle DBA Jan 2002 – Oct 2005

Started as a senior Oracle database administrator and was instrumental in the implementation and maintenance of the PostalOne Interface. This project was the backbone of the revenue division of the USPS. The PostalOne was a centralized database where different regions and divisions of the USPS interact and share information to the respective regional offices. As a part of the team, was instrumental in creation of local PostalOne regional database to communicate with the Centralized PostalOne database. The other project (MIS) Mail Irregularity System was a pilot system to be implemented nationwide by the USPS which included the storing of the images in a database where the damages incurred to the mail pieces and were unable to deliver. The project was successfully completed after user acceptance testing. The technology and tools used for the projects was Oracle9i, PeopleSoft, Sun Solaris, Windows2000, ERWIN, Oracle Enterprise Manager, Diagnostic packs, PLSQL, SQL*Loader, Oracle export and import command tools.

Keane Inc., Chicago, IL Project Lead/DBA Jun 1998 – Dec 2001

Worked as a senior project/database lead for the IRIS (Illinois Revenue Information System) phase II development. This system tracks and maintains the city of Chicago revenue department. It was quite complex and most visible to the City of Chicago. Managed a team of 16 (developers, analysts, 4 government employees and junior dba, and quality assurance team).

Worked with business sponsors and analysts to understand the scope and requirements, designed and developed the relational data model for the IRIS system, and the reporting environment system.

Reviewed the work for quality and suggest ways to improve production and increase the quality of the work of the team.

Developed instructions, training courses, and procedures for handling problems.

Communicated orally and in writing with the customers and contractors to solve problems and questions relating to work, assisting contractors understanding and applying the City of Chicago goals and visions, conduct user meetings, prepare and submit status reports to the senior management.

Worked as a production DBA in maintaining daily backups and databases refresh for the development servers where the developers would test their code.

Cloned several databases for development purposes and refreshed them periodically. Replication of Report Server using materialized views.

Generated reports using BRIO for Executive management from the DSS system.

Worked on the ETL tool CA’s Advantage Data Transformer to move data from source to target databases.

Authored performance and tuning for the production systems on a weekly basis.

Instrumental in setting up the backup and recovery scenarios for the Oracle production databases on Sun Enterprise servers.

IHS, Inc MD Program/QA Analyst July 1996 - May 1998

Managed a group of 6 employees (analyst, developers and testers) for the project to manage the customers tracking information for the company. My tasks included assigning and reviewing the work of the employees, training customers and team members. Responsible for setting and meeting goals on the quantity and quality of work expected within a set time frame. Communicated orally and in writing between the customers and the team members to solve the problems and questions related to work.

Tasks include the installation, analysis, design, development, testing and implementation of tracking system on Sun Solaris.

Designed, developed and created databases in Oracle, SQL Server 6.5, Sybase ASE 11.5 and IBM DB2 on Sun Solaris, Windows NT and AIX server respectively.

Data loading to the Decision Support System using ETL tool, sql loader and plsql programs from various legacy systems.

Extracted data from IBM DB2 to Sybase ASE server on windows platform. The development environment included the technology and tools used for these projects were Oracle, BRIO, CA Advantage Data Transformer, Sybase ASE, ERWIN, Discoverer, Oracle Data Warehouse, SQL*Loader, PLSQL, Oracle Reports.

MCSI Inc., Silver Spring MD Program/ QA Analyst Nov 1993 – Jun 1996

Worked as a programmer analyst and was instrumental in managing the projects.

Worked with 4 contractors (developers and support staff) providing support to various projects in DOT.

Tasks included assigning and reviewing the work of contractors, training customers and team members. Responsibilities included were design, development and implementation efforts of the projects. The projects worked for DOT were ‘PAYDAFIS’, ‘PAYBACIS,’ ‘BEST’, and ’CARS’. These projects were very critical to the Office of the Budget in MARAD where report were submitted to the Congress. The technology and tools used for testing these projects were Oracle, Oracle Forms, Oracle Report*Writer, SQLPLUS, SQL*LOADER, SQL*MENU, ERWIN, Mips3240 (UNIX platform) and Novell.

TECHNOLOGY

Platforms: Microsoft Windows operating systems, Sun Solaris (7,8,9,10), HP-Unix, Linux, Vax VMS. Languages: SQL, PLSQL, HTML, PRO*C, and C++.

Databases: Oracle (6 -12C),IBM DB2, MS SQL Server (6.5,2005,2008,2016), Sybase.

ERP: Oracle EBS, SAP and PeopleSoft.

Data Modeling Tools: ERWIN, Oracle Designer, Microsoft Visio, and DB Artisan.

BI Tools: Brio, ADT, Business Objects and Oracle Discoverer.

Report Tools: PowerBuilder, TOAD, Oracle Reports, Discoverer, SQLPLUS and SQL Navigator.

Tools: Oracle Forms, Oracle Enterprise Manager, SQL*Loader, HummingBird, Microsoft SharePoint, Vi editor, Microsoft Project, Microsoft PowerPoint, IIS, SAP Security.

Training: SQL Server 2016, SAP DBA, TADM10_1, TADM10_2, TADM12_1, TADM12_2 and TADM51. Oracle 11g, Oracle Financials, RAC, Performance Tuning at Oracle University.

EDUCATION

Masters in Management Information Systems - Bowie State University, Bowie, Maryland.

Contact this candidate