Manager Oracle

RAJAN SHARMA

***** ******* ****, **********, ** *0871 US CITIZEN 240-***-**** (c) ********@*******.***

Executive Summary

Rajan has over 20 years of extensive experience in Financial, Healthcare, and Commercial sectors. Supporting Federal, Non-Profit, and Commercial clients, with strategic planning, enterprise architecture design/development/deployment. Throughout his career, he has filled a variety of technical roles such as Architect, Lead, Engineer, DBA, and Integration Specialist. Expertise in managing highly complex multi-layered environments for multinational commercial and federal government clients. Proven in developing novel solutions and techniques for integrating disparate architectures, and effectively communicating and collaborating with various levels of stakeholders including CIOs, CTOs, and Business Teams. Experience in bringing all stakeholders to the table to ensure long term, scalable, and agile architecture that supports business needs and enables future growth. Strong team player, with negotiation skills to influence change in the team that aligns with organizational goals.

Rajan has experience with major enterprise architecture technologies including flavors of UNIX, Oracle Database, Fusion Middle Ware, and development, including Web development. Fluent with UNIX administration and scripting. In-depth understanding of Oracle Database Administration, Database Migration, Database Replication, Data Security, Backup & Recovery, Auditing and Security, Oracle Fusion Middleware installation and administration, Data Design, Data Analysis, Oracle Fusion Middleware, Web Application Development. Has excellent communication, presentation, analytical and problem solving skills.

Education

MS COMPUTER 1994 SP UNIVERSITY, GUJARAT, INDIA

BS SCIENCE STATISTICS 1991 SP UNIVERSITY, GUJARAT, INDIA

TECHNICAL EXPERIENCE

OS: Solaris/Dec-Alpha4100/Hp-ux9000/AIX/Red hat/Linux, shell scripting, Perl scripting, Windows 20xx

Oracle 5.0-11: RAC, ASM, Data Guard, RMAN, TKPROF, Grid, AWR, ADDM, Data Pump, Virtual Database, Schema Maintenance, SQL Tuning, Auditing, PLSQL, Forms/Reports.

Applications Servers: WebLogic, Tomcat, Apache, Fusion Middle ware, Web Center, Portal, OID

Languages: html/CSS, XML/SOAP, SOA, JSON, JavaScript, jQuery, primary java, TIBCO, C, Assembly, Pascal, COBOL, Visual Basic, PowerBuilder, FoxPro, and MapInfo.

Experience

SOLUTIONS CONSULTANT ARC CONSULTING INC, CLARKSBURG, MD NOV’11-PRESENT

Client: US Department of Commerce (USDOC), Federal Government

Architected enterprise solution to support Oracle Middleware Suite applications leveraging internet directory, portal, PLSQL, JavaScript, JSON, jQuery technologies.

Enhanced and scaled in-house developed legacy oracle financial applications.

Designed and implemented TIBCO interface application using the secure (PKI) SOA architecture (SOAP/XML) for consumption by an external vendor website leveraging tomcat server.

Designed enterprise dashboard application to track Key Performance Indicators (KPIs) for status of departmental projects, which facilitated document repository using portal.

Designed and implemented application for an IT budget dashboard using RESTful architecture.

Customized interface in portal for OID user, group and roles management for internet directory and single sign on.

ORACLE SUBJECT MATTER OF EXPERT SRA INTERNATIONAL, ARLINGTON, VA JAN’09-NOV’11

Client: Federal Deposit Insurance Corporation (FDIC), Federal Government

Improve and enhance enterprise operation to enable 24x7 operations to support 99.99% uptime capacity with the highest data security and integrity.

Served as primary contact for the oracle technical operation at FDIC production operation group.

Worked and lead efforts in 24x7 environment to ensure an integrated environment is available and issues are resolved in timely fashion as per high availability Service Level Agreement.

Installation/Configuration/Patching the infrastructure (LDAP), Portal, IDM (SSO), APPs in about 70 different Solaris containers (Zones/Virtual machine).

Standardization and automation of startup and shutdown procedures for Solaris virtual containers, middleware, database and application by implementing services and scripts.

Supported application code deployments. Standardization of intricate password change procedures that span several technology layers.

The environment hosted several technologies like Solaris virtual zones, oracle databases, oracle middleware suite including portal/OID/IDM/web/SOA/app, PeopleSoft, business objects, various COTS products, and Active-directory/Wintel products.

ENTERPRISE ARCHITECT/DBA LOCKHEED MARTIN, ARLINGTON, VA JAN’06-JAN’09

Client: Federal Deposit Insurance Corporation (FDIC), Federal Government

Acted as the primary DBA for multiple databases. Assisted other group DBA(s).

Reconfigured the Oracle database with flashback, archive, RMAN scripts, hot backup scripts, RMAN, and Data Guard.

Implemented OID based Enterprise User security (EUS), for database user authentication.

Participated in an on-call rotation with other DBA(s) to provide coverage.

Installation/Configuration of Grid Control Enterprise Manager and Oracle application server 10g. Deployment of grid control above 1500 targets. Used automated push of binaries, automated push database, push agent, CPUs and patches applied from grid to the targets.

24x7 support for core production environment that included application deployment, backup recovery, audit and troubleshooting, and patch maintenance. Automation of UNIX/Oracle jobs.

Developed the corporate portal landing page for all corporate applications. Secured the portal by interfacing it with the OID single-sign on. Provided users with the access privileges to the applications by creating groups and roles. Worked on OID provisioning to propagate the changes from the OID to applications.

Implemented Identity Management high availability with SSO and by configuring complex Oracle Directory Integration (ODI) profiles to synchronize a very large and complex Active Directory (AD) of 40,000+ users into Oracle Internet Directory (OID).

Supported PeopleSoft application re-platform/migration from db2 to oracle 10g on mainframe IBM to Solaris UNIX. This was also an upgrade of PeopleSoft from 8.44 to 8.49.

Automated scripted jobs for monitoring the oracle environment by Perl/shell script.

Documentation for oracle hardware/software layout, installation, upgrades.

SENIOR DBA LIVANTA LLC, COLUMBIA, MARYLAND MAY’06-DEC’06

Installations of Oracle (10.1.0.2) on CentOS Linux HP ProLiant 530. Migration of the databases from the NT Platform to Linux.

Installation and configuration of Grid Control Enterprise Manager and Oracle application server 10g.

Configured Oracle Data guard standby databases for disaster recovery.

Worked on database servers as well as application servers configuration, patches/releases, upgrades, instance-cloning, migrations, RMAN backups, imp/exp, SQL*Loader, data recovery, database creation, tuning and SQL*NET configuration.

Designed and Implemented Disaster Recovery/Failover plan.

ORACLE CONSULTANT BRANDON GROUP, NEW JERSEY JUL’03-MAY’06

Mar’06-May’06, Client: ATG, Washington DC, e-Commerce Hosting

Feb’06-Mar’06, Client: Verizon, Arlington, VA, Telecommunications Company

Jan’04-Feb’06, Client: NASA, Washington, DC, Federal Government

Nov’03-Dec’03, Client: Motorola, Phoenix, AZ, Electronics Manufacturer

Jul’03-Sep’03, Client: Magellan Behavioral Health Services, Columbia, MD, Behavioral Health

Installed of Oracle 10g R2 Real Application Cluster (RAC) Environment under SUSE Linux on HP Blade Server.

Installed TWO RAC Clusters RAC (10.1.0.2) on two node clusters on Red Hat Linux 3.4., which included OCFS installation, configuration of SAN for EMC (cx400) using Navisphere, Connectivity for Power path and Navisphere agent and Local area network configuration.

Configured the primary (DC)/secondary (Ohio) site in failover mode using data guard and the log transport services. The configuration included no more than 30 mins data loss.

Database Consolidation for multiple applications.

Set-up the Backup/Recovery for the production database using Oracle RMAN.

Tested the Oracle 10g RAC Environment by using STATSPACK, TAF and FCF.

Extensively used OEM for performing various tasks including monitoring database locks, long running SQL statements, viewing performance statistics, tuning the database, running explain plan and scheduling various jobs.

DBA/DEVELOPER SYSTALEX CORPORATION, GAITHERSBURG, MD AUG’99-JUL’03

Client: US Department of Commerce, Federal Government

Worked as Senior Oracle DBA for Commerce Administrative Management Support (CAMS Support Center) on Five UNIX servers including 2 Dec Alpha 4100 servers, One 2100 Alpha server, One SunEnterprise3500, One IBM-AIX machine and 12 NT-servers. Responsible for administrating 38-48 Oracle databases in different versions including Ora7.3.4, 8.0.5, 8.1.5, 8.1.7, 9i servers.

Installation and maintenance of core Oracle RDBMS software, Oracle Enterprise Manager 9i, 2.2, OEM management server 2.2, Install 9iAS application server with forms and reports services. Repository for Designer 6.0 and Data warehouse builder 2.1. Installation of the third party products like toad, ERWIN. Installation and administration of 9iAS, Forms 6i server and Reports 6i server. Installation of patch updates for RDBMS software, 9iAS forms, and reports.

Designed backup and recovery scripts, strategy as well as automatic database programs for monitoring the status of hit-ratio, object extents/max extents, table spaces and data file usage.

Created and administered databases in all versions and Migration of databases from 7.3.4 to 8.1.7. Support for Migration project and evaluation of third party software like Kumaran, Migrator.

Administered and monitored databases for their optimal performance, backup and recovery, tuning, SQL*net administration of the database on ad-hoc basis.

Wrote k-shell scripts, AWK scripts and Perl scripts for daily database maintenance tasks like user maintenance, maintain/analyze schemas, rebuild indexes, alert logs, monitor user processes, space usage monitoring, tune db.

Supported McAfee helpdesk software database, Clear Case and Attaché.

Implemented the Bank Card Application for the Oracle web-server 4.0.8 for NT and 9iAS over Sun Solaris platforms across DOC bureaus.

Maintained Regular patch updates for the databases as well as oracle front-end software like dev2000/des2000/discoverer3 and maintaining their patches.

Provided extensive support for database migration of 7.3.4 to 8.1.7.

Performance tuning table sizing, locking issues, index creation, sql*tuning using hints for AR-Receivable Application.

Database support for data warehouse team.

Participated in projects like Reorg, Accounts Receivable, and AR Standard Interface. Was responsible for handling system design using des/2000. Coordinated final testing and implementation of developed modules for production use. Data loading scripts using SQL*loader.

For above mentioned projects assisted the programmers for system development using the tools like Forms, Reports, Toad, SQL tuning. Supported programmers on oracle forms 6i.

Oracle Database Administrator/Systems Analyst Trinet Solutions, New Jersey Feb’99-Jul’99

Migrated Oracle Database from NT to UNIX platform.

Assisted in setting up the UNIX server.

System Analyst/Programmer GCMMF Limited (AMUL), India Dec'95-Dec'98

Created and maintained RDBMS databases and their design and performed administration of Databases on Solaris platform using Sun Enterprise 3000.

Developed & maintained Software Systems of Sales Analysis, Wholesale Distributor’s System, FMCG Retailer’s survey System for Distribution Department.

Developed and monitored the Wholesale Dealer’s Network System.

Super-imposed Geographic Data on GIS Software. Installed & maintained various software(s).

GIS for Market Network and Sales Monitoring using MapInfo and Oracle.

Kaizen Champ for the year of 1997-98 facilitated the Kaizen movement.

Systems Programmer IRMA, India Mar’94-Nov’95

Designed and programmed student monitoring system.

Contact this candidate