Raj Rathore

**** ***** ***** ****

Raleigh, NC **617

ad24nh@r.postjobfree.com

919-***-****

Summary of Qualifications

Rajendra is US Citizen and able to obtain Public Trust, he held public trust; his current location is Raleigh NC and available for onsite work.

He is oracle 12c certified.

Senior level IT professional with 25+ years of experience in design, analyse, develop, implement and manage database systems including 10+ years as an Oracle/PL/SQL Developer.

Holds certification in Oracle 12C.

Well versed in ORACLE 9i/10g/11g/12.2, PL/SQL, SAP HANA 2.0, Informatica 9.1, Tableau, PERL, Java, Korn Shell, JavaScript, C, SolarWinds, SAS, DB2, Oracle Recovery Manager (RMAN), Oracle utilities, BMC Patrol for Oracle, SCO UNIX, Linux Real Application Cluster (RAC), Version Control Software (ClearCase), Data modelling, and Data guard.

Experience in troubleshooting Oracle databases, setting up service requests with Oracle Corporation for unresolved customer issues.

Managed MS SQL Server 2008 databases, setting user security and setting up maintenance plans.

Performed Stress test on Oracle server using Quest product Spotlight & Foglight.

Developed tools to monitor Oracle user objects, administration of Oracle database backups and Oracle security and User audit management.

Assisted developers in leveraging Oracle features to provide a security model that was easy to maintain, supported all the user roles and prevented unauthorized back-end access to the database.

Developed SAP HANA 2.0 information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access).

Designed and configured SolarWinds based management of Oracle and SQL Servers to facilitate monitoring and management of mission critical infrastructure including support of user concerns and needs in a timely manner.

Administered large scale enterprise databases in multi-terabyte environments up to 163 TB

Education

MS in Atmospheric Sciences North Carolina State University, Raleigh, North Carolina 1983

MS in Geophysics Benaras Hindu University, Varanasi, India 1975

BS in Maths Benaras Hindu University, Varanasi, India 1973

Certifications

Oracle 12C Certified

Technical Skills

Hardware: SUN, HP, IBM 370/1XX, 43XX, 30XX series, VAX DEC-11/7XX, 8XXX, PDP-11/XX, NCR 35XX/3600, Intel based Servers.

Software: PERL, Java, Korn Shell, JavaScript, C, FORTRAN, ORACLE 9i, 10g, 11g, 12.2, SAP HANA 2.0, NoSQL, Informatica 9.1, Solarwinds, INGRES, Sybase, SAS, DB2, PowerBuilder, Deft and 4-Dimension case tools, Erwin ERX, Power Designer case tool, Oracle Recovery Manager (RMAN), PL/SQL, Oracle utilities, BMC Patrol for Oracle, I/Watch by Quest, Quest Spotlight for Oracle, TOAD, Version Control Software (Clearcase), HP/UX, SCO UNIX, Linux, OS/MVS, VM/CMS, SNOW.

Relevant Professional Experience

McKesson Technology, Irving, Texas (November 2022 to Present)

Oracle Database Administrator/ Developer/ Engineer

Current responsibilities are as following.

Oracle 19C performance tuning and maintenance in Oracle Data Guard configuration.

Oracle 19C data encryption in physical standby data guard configuration.

Oracle 19C health check, sessions blocking, index quality and tablespace monitoring.

Oracle 19C database capacity planning and flashback monitoring.

OEM reports for database, archivelog backups and agent blackout status.

Sybase IQ growth, file system and availability and backup monitoring through custom scripts.

Extensive experience with ServiceNow, creating CRQs, incidence and reporting

Indo US Ventures, Raleigh, NC 06/2019 – October 2022

Oracle DBA/Oracle PL/SQL Developer

Developed PL/SQL code to monitor Oracle Database Systems for database resources monitoring.

Analysed existing database structures and made recommendations to improve access speed in PL/SQL code with overall improvement of 20%.

Created oracle stored procedures, tables, indexes, pl/sql and UNIX shell scripts to create files to be transmitted to vendors via extranet automatically every week without user intervention.

Fixed the impacted tableau reports associated with complex Sql Queries.

Developed new backup strategies to backup data moved to newer hardware.

Apex Tool Group, Apex, North Carolina 03/2013 – 05/2019

Senior Oracle DBA /SQL Database Developer

Oracle & SQL Server Database software installation, patching and upgrade to development, test and production servers.

Expertise in the creation of databases table spaces, tables, indexes and other database objects.

Responsible for Physical and Logical database design on UNIX and NT systems and analysed new database requirements and database specifications: including but not limited to normalization, entity/relationship modelling, sizing, access planning, security, and tuning. Installed and maintained commercial-off-the shelf management systems and related technology, including, WEBDB and developer 2000 server.

Knowledge and understanding of Real Application Cluster (RAC) and Data guard.

Manage MS SQL Server 2016, 2012, 2008 R2 databases, setting user security and setting up maintenance plans.

Administered, designed and developed NoSQL database solutions to users..

Additionally, performed database change control requests and configuration management requests. Responsible for designing and maintaining server-based software, pl/sql and UNIX scripts to retrieve data from an oracle RDBMS based in a client/server architecture and wrote numerous NT and UNIX shell scripts.

Created and managed Package Configurations, Package deployment and User-defined Variables for SSIS 2016/2012/2008 R2.

Developed reports using SSRS to send information to different Clients and managers.

Provided Oracle 12.2, 11g & 9i administrative supports for SAP Basis running on HP-UX in large database environment.

Migration of BW 7.3 on Oracle 12.2 to BW 7.3 on HANA 2.0 database.

Integration of ECC with HANA Database using the SLT Replication

Developing SAP HANA 2.0 information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access).

Designed and configured SolarWinds based management of Oracle and SQL Servers to facilitate monitoring and management of mission critical infrastructure including support of user concerns and needs in a timely manner.

Developed PL/SQL code, ORACLE SQL and TOAD queries for data manipulation and analysis.

SAP Basis Admin handled performance management in ABAP and JAVA stack and ensure that improvements are identified regularly and systems are tuned optimally.

Administrated Oracle database: Space Management and other Database activities using BRTOOLS.

Federal Reserve Bank, Atlanta, GA 08/2012 – 01/2013

Senior Oracle/SQL Database Admin

Trouble shooting Oracle databases, setting up service requests with Oracle Corporation for unresolved customer issues.

Management and monitoring of Oracle 11g in Oracle Dataguard configuration.

RMAN database backups and restore for 11g databases in Linux, Sun Solaris and Linux environments.

Grid configurations for hot/ cold and archive log backups & jobs setups

Patch management and version control For Windows and Linux based systems.

Managed MS SQL Server 2008 databases, setting user security and setting up maintenance plans.

Conoco Phillips, Bartlesville, OK 01/2012 – 07/2012

Senior Oracle Database Admin

Management and monitoring of Oracle 10g, 11g in Oracle Dataguard configuration.

Database backups and restores using RMAN and datapump.

Oracle database Grid configurations for hot/ cold and archive log backups

Backup and recovery of Oracle 10g & 11g database on AIX 7.1, Linux 6.1 and Solaris

Migrated Informatica mappings/sessions/workflows from Dev, QA to Prod environments using various technique such as export, import method, DG/Folder migration in Informatica 9.1

Wells Fargo/Wachovia Bank, Charlotte, NC 05/2010 – 09/2011

Senior Analyst/Database Admin

Application development for call centers, define requirements, write specifications and design, develop, test and integrate software including web-based applications.

Administering ETL process from Oracle to Sql Server databases.

Report generation using SQL and Java Programming language for IVR systems.

DSM Pharmaceutical, Greenville, NC 11/2008 –11/2009

Oracle & SQL Server DBA - Supervisor

Application support for customers in material tracking systems, learning management systems, documentum, environmental monitoring system, human resources management systems, employee time recording systems and chemical dispensing systems.

Performance and tuning of 8.1.7, 9i, 10g, &11g databases for DSM Pharmaceutical.

Design, develop and maintain OS level scripts for DBA and Reporting functions.

Installation and maintenance of OEM Grid Control, 10g and 11g RAC software.

Performed databases backup & recovery.

Development and maintenance of PL/SQL code for clinical systems.

Unix Shell scripting for pharmaceutical applications.

ABB, Inc., Raleigh, NC 11/ 2007-10/2008

Oracle DBA & Oracle Application Server Admin

Development and maintenance of PL/SQL procedures and triggers for network systems software for major international utility companies.

Installation and administration of Oracle 10g Application Server.

Performed databases upgrades, backups & recovery of Oracle 9i, 10g & 11g databases under AIX 6.0 and Solaris 9.

Provided customer support for Oracle 9i, 10g RAC databases and Oracle 10g Application Servers

Installation and maintenance of Oracle ASM, AWR, OEM, 10g and 11g RAC software.

Maintenance and management of Oracle Streams Advanced Queuing

DSM Pharmaceutical, Greenville, NC 06/ 2006-11/2007)

Oracle & SQL Server DBA

Application support for customers in material tracking systems, learning management systems, documentum, environmental monitoring system, human resources management systems, employee time recording systems and chemical dispensing systems.

Performance and Tuning of Oracle 7.3.1, 8.1.7, 9i & 10g databases for DSM Pharmaceutical

Migration of Oracle 7i and 8i databases to Oracle 9i and 10g databases.

Performed databases backup & recovery.

Developed tools to monitor Oracle database.

Configuring the raw disks for Oracle RAC, installed and maintained Oracle10g RAC.

Installation and maintenance of Oracle APEX for web application deployment.

S & R Incorporated, Selma, NC 01/2005- 05/2006

System Manager / Oracle DB Administrator

Responsible for implementation and maintenance of Oracle 8/9i & 10g in UNIX and PC environments.

Created and developed Oracle databases test environments on UNIX/Windows platforms

Ensured backup and recovery integrity, maintenance & tuning of multiple databases in the different Oracle environments.

City of Winston Salem, Winston-Salem, NC 08/ 2004-11/2004

Oracle Server DBA

JS Incorporated, Durham, NC 09/2002 to 07/2004

Oracle Server DBA

BB&T Bank, Wilson, NC 06/2000 to 07/2002

Senior Oracle Developer

DB Management, Durham, NC 02/2000 to 05/2000

President

United States Postal Services, Raleigh, NC 11/1998 to 01/ 2000

Database Consultant

AT&T, Greensboro, NC 09/1994 to 11/1998

Database Consultant

Northern Telecom, Inc., Research Triangle Park, NC 06/ 1994 to 08/ 1994

Database Consultant

GE Capital, Inc., Raleigh, NC 12/1993 to 05/1994

Database Consultant

Contact this candidate