Summary
Overview
Work History
Education
Skills
Projects
Accomplishments
Additional Experience & Industries worked (2001-2011)
Timeline
Generic

Rajesh Sahitya

Edison,NJ

Summary

Over 22 years of IT experience. Specialization in Oracle Core DBA, Independently managing Crown Jewel applications as Client facing DBA. Leadership skills to manage team, Extensive experience in Database design, Oracle Installation, Backup/Recovery, Database and Application migrations, Database and application performance-tuning, troubleshooting, firefighting, developer/integrator relations, script development. Managed complex Oracle Exadata, ASM and RAC Engineered systems on latest oracle product versions. Worked on Oracle versions 9i, 10g, 11G, 12c, 19c(19.19). Performed planning and implemented systems on AWS cloud. Migrated Oracle On-premise databases to Oracle RDS/EC2 environment in Amazon Web Services (AWS). Performed Quality Gate Checks to ensure the database is complaint with engineering Standards. Configuring high availability solutions, Multi-AZ for AWS cloud DBs and Data guard for on-premise critical databases. Worked on multiple Disaster recoveries and Database decommission process requests.

Overview

12
12
years of professional experience

Work History

Project DBA

Merck & Co Inc.
Rahway, NJ
09.2011 - Current
  • Worked closely with application developers to ensure proper design of applications and database structures.
  • Implemented data replication solutions like GoldenGate or DataGuard.
  • Partnered with project management teams on development of scope and timelines.
  • Scheduled jobs for maintenance activities like index rebuilding.
  • Installed and configured Oracle Database software, components, and tools.
  • Monitored database performance and tuned accordingly.
  • Updated and inspected database security features and protocols.
  • Provided technical assistance to users in resolving database related issues.
  • Provided 24x7 on-call support for critical incidents related to databases.
  • Evaluated and implemented third party products that integrate with Oracle databases.
  • Deployed patches and upgrades on existing installations as per best practices guidelines.
  • Tested new database features before introducing them into production environment.
  • Analyzed system requirements and developed logical data models with ERWIN toolset.
  • Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
  • Maintained database security by creating user accounts and profiles and granting appropriate privileges.
  • Developed and implemented security initiatives to protect important company data.
  • Detected and resolved data quality issues and discrepancies for integrity and quality control.
  • Managed multiple databases across different environments like development, testing and production.
  • Created and maintained database objects such as tables, indexes, views, triggers, stored procedures.
  • Designed high availability solutions for mission-critical databases using clustering technologies.
  • Upgraded the databases from older versions to newer ones while ensuring minimal downtime.
  • Ensured data integrity through regular validation checks on data quality and consistency.
  • Managed user accounts and support systems within complex Oracle database and cloud systems.
  • Prioritized and organized tasks to efficiently accomplish service goals.
  • Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
  • Leveraged [Software] skills to input and compile data gathered from various sources.
  • Collaborated with others to discuss new opportunities.
  • Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
  • Displayed strong telephone etiquette, effectively handling difficult calls.
  • Assisted with customer requests and answered questions to improve satisfaction.
  • Approached customers and engaged in conversation through use of effective interpersonal and people skills.
  • Maintained open communication with team members and stakeholders, resulting in successful project outcomes.
  • Worked with cross-functional teams to achieve goals.
  • Achieved cost-savings by developing functional solutions to problems.
  • Exceeded customer satisfaction by finding creative solutions to problems.
  • Recognized by management for providing exceptional customer service.
  • Identified needs of customers promptly and efficiently.

Education

Master of Computer Applications -

IGNOU
India

Diploma - Information Technology

GNIIT
NIIT

OCA -

Oracle Certified Associate

Oracle Application -

Oracle Apps Certified

ITIL -

ITIL Certified

GBS -

Global Business Skills

Skills

  • Oracle Exadata X8M-2
  • Database Design & requirement analysis
  • Backups & restore
  • Application & Database performance tuning
  • GxP, SOX audit and compliance standards
  • Disaster recovery
  • Team building and leadership
  • Documentation and SOP management
  • Decommission process
  • Friendly, Positive Attitude
  • Decision-Making
  • Teamwork and Collaboration
  • Self-Directed
  • Active Listening
  • Excellent Communication
  • Interpersonal Communication
  • Team Management

Projects

  • Working as Database Project DBA - Merck & Co., Inc. (Merck) is a global health care company that delivers health solutions. (Inventing for Life)
  • Working on Design, Documentation, Data Modeling,Database End to End management of Align (Crown Jewel Application) Project, One of largest revenue management system (24*7, 365 days). Project is on Oracle Exadata and Golden Gate on latest Oracle Platform.
  • Worked as Project DBA, on Design, Documentation, Data Modeling and managing End to End management of ELN Project (24*7, 365 days) for Merck & Co Inc. Project is on latest Oracle Platform i.e. Exadata, RAC (Real Application Cluster). Database Size is 22 Terabyte.
  • The EFPIA program is charted to implement a solution that will enable Merck to meet business and compliance reporting needs around HCP and HCO spend disclosure. The need to report on HCP and HCO spend is driven by both the EFPIA Code and local law.
  • Client facing Primary DBA managed End to End setup and implementation of Customer master, MCM and Animal Health Project for Merck & Co Inc on SUN SOLARIS, Linux, HP (UX).Responsibilities include Oracle installation, database creation, maintaining users and space, deciding the backup strategy, taking backup of database, restoring the database, database tuning to enhance system performance etc.

Accomplishments

  • Managed Engineered Oracle large Databases independently ( MMIT, ELN, DPS, Orion) on Exadata & Golden Gate
  • Created Database SOPs, Disaster recovery project plan, documentation
  • Managed Offshore and Onsite DBA as Project manager handiling multiple projects
  • Working experience of Jira tickets, Jira boards and SNOW tickets
  • Successfully implemented projects in various divisions.

Additional Experience & Industries worked (2001-2011)

  • HCL India ( DBA Operation lead) client facing DBA
  • RBS (Royal bank of Scotland) , worked on financial application
  • Oracle India (Multiple independent client) Oracle Core & Apps DBA
  • Birlasoft (GE Insurance) Primary senior DBA
  • CRIS (Indian Railways) FOIS major system development

Timeline

Project DBA

Merck & Co Inc.
09.2011 - Current

Master of Computer Applications -

IGNOU

Diploma - Information Technology

GNIIT

OCA -

Oracle Certified Associate

Oracle Application -

Oracle Apps Certified

ITIL -

ITIL Certified

GBS -

Global Business Skills

Similar Profiles

CREATE PROFILE
Rajesh Sahitya