Manager Oracle

Sudhakar ‘sid’ Perumal

SUMMARY

Over ** years of experience in Information Technology. As a System Analyst I have supported wide range of applications including Human Resources, Financial application, Payroll systems, Travel agency, Inventory and Order processing packages specializing in ORACLE E-Business Suite, INFORMIX and Oracle database administration.

TECHNICAL SKILL SET

Oracle Data Guard

Oracle Real Application Clustering (RAC) 10G and 11G

Oracle database performance tuning using Oracle Enterprise Manager (OEM) 11g

Oracle E-Business Suite 11i, 12.1

Automated Scripts generation using Unix C Shell / Korn Shell and Perl

Oracle Enterprise Database Server versions 7 thru 11G.

Oracle PLSQL and SQL query writing

Oracle Recovery Manager (RMAN)

Oracle Advanced Compression, Partitioning and other Oracle 11g advanced security features

Oracle Application Framework

Report Generation using Crustal Reports

Oracle Application Management Suite Oracle BI Discoverer 11G Oracle Web logic server and Fusion Middleware

Microsoft Visual Studio

PeopleSoft Database Administration and report building Database Migration on Oracle, Informix

Knowledge, Expertise and Transferrable Skills

Systems Analysis

Database Design-Management

Enterprise Application cloud hosting

Systems Analysis

DBMS Security controls Implementation

Most Recent Accomplishments

1.Implemented Security postures for 11 DB Servers and related application servers. Reviewed over 262 security controls. Reviewed weekly Department of Defense (DoD) Information Assurance Vulnerability Management alerts (IAVM).

2.Scheduled and directed database team on implementing security controls. Documented PO&AMS (plan of action and Milestones) and DRAs (DAA Risk Acceptance) measures.

3.Designed and developed web-based reporting solution for Air Force Personnel systems using Oracle Web logic and BI Discoverer saving the Air Force over 1 million dollars in software acquisition and implementation costs.

4.Planned and coordinated solution to host over 60 servers for hosting Air Force Military personnel records system at 2 DISA DECC's leading a team of 5 people for a Legacy HR system migration utilizing Oracle E-Business Suite R12

PROFESSIONAL EXPERIENCE

Lockheed Martin Info Systems & Global Services 11/1998 to Present

Database Administrator Sr. 11/2003 to Present

As an Oracle Database administrator I supported numerous Air Force Personnel database systems including Automated Records Management System (ARMS), Military Personnel data system (MILPDS), Virtual Personnel Centre (Vpsc), Air Forms promotions system (AFPROMS).

Responsibilities included:

Lead team of database administrators, HR Functional administrators, Data Management teams.

Lead technical feasibility analysis on large scale cloud migrations for ERP systems.

Lead effort to develop policies and procedures for high system availability and business continuity measures.

Database Administrator Sr. 03/2002 to 11/2003

I worked as an Oracle Database administrator for the Automated Records Management System (ARMS) legacy conversion project for the Air Force Personnel Center, Randolph AFB. The task involves mapping of legacy Informix database to the current Oracle database server. Setting up database alerts and monitoring thresholds to ensure 24X7 system availability. Responsibility involved maintenance and support of the Air force Personnel Databases (MILPDS) and related USAF personnel unique systems.

Responsibilities included:

Identified hardware requirements and implemented best practices for standing up database instances.

Designed and developed backup and recovery measures using Oracle Recovery Manager (RMAN).

Assisting Developers with PLSQL coding / SQL queries and analyzing database performance issues.

Database Administrator 11/1998 to 03/2002

Worked a database administrator for a system integration project. This was an Immunization Record Management system for the Department of Defense. The earlier version was supported only in Oracle.

Responsibilities included:

Identifying tools for conversion.

Highlighting specific bottlenecks in converting source code from Oracle to INFORMIX. Study of existing application and providing workarounds for features used in Oracle database not supported by INFORMIX database.

Installation of INFORMIX server and client applications. Configuration of Connectivity software for Enterprise Applix, which was the front end tool. Configuration of INFORMIX server to support OLTP operations.

Installation involved setting up of development and test environments. The development and test database contained conversion of Oracle database to INFORMIX database.

Data transfers, coding of stored procedures and triggers in INFORMIX database.

Setting up Archive cycles.

Packaging of INFORMIX database with COTS application.

Involved in technical assessment of candidates as INFORMIX DBA for a permanent position in the client office.

Training the database administration staff in server configuration and database operations.

Hitech Consultants (HTC) 09/1997 to 09/1998

Software Consultant

Worked on a benefits administration processing for US Bancorp system.

Involved in DBA and development activities for the migration of the database from the client work site to the development system and from the development system to the production system.

Responsible for installation of INFORMIX Online server.

Configuration of INFORMIX server to support OLTP operations.

Setting up Archive cycles.

Created and maintained Production Database.

Verified data consistency including performance tuning of the database.

This system involved enrollment of employees under employee stock purchase plan. Generated enrollment information including on coming changes with interfaces catering to multiple health care providers.

EDUCATION

BCM, Commerce University of Madras April 1993

CompTIA Security + Jan 2013

Contact this candidate