Priyamandeep Singh

Senior Oracle Dba Exadata Dba Apps Dba @Motor Coach Industries

Working as APPS DBA for Motor Coach Industries Ltd and NewFlyer Industries Ltd, one of the largest transit and coach manufacturers in North America. • Performed the major EBS database migrations from traditional systems to Exadata. • Configured the monitoring on various Exadata components. • Provided all aspects of Database Administration - installation, administration, upgrade, tuning and maintenance for company mission-critical Oracle 9i/10g/11g/12c/18c/19c databases in a 24*7 production environment. • Maintained Oracle databases in different phases and environments of SDLC (production, testing, and development). • Disaster recovery planning, implementation, backup and recovery using RMAN through Dell EMC Data Domain Boost. • Extensive experience in Data Guard configuration, implementing and maintaining standby databases on Unix file system and ASM. • Performed Database Duplication using RMAN. • Recovered the database from block corruption. • Implemented Defect Prevention Plan, performed root cause analysis and implemented permanent fix as part of Problem Management. • Upgraded the Oracle E-Business Suite databases from 11g (11.2.0.4) to 12c (12.1.0.2). • Created Unix shell scripts to automate the database backup, to check hosts and services availability, to parse log files and send alerts. • Identify tuning opportunities, implement improvements and advice developers on SQL tuning options. • Performed the ADOP patching on Oracle E-Business Suite mid-tier servers. • Providing on call support as required. • Configured and managed Oracle Enterprise Manager Cloud Control and Agents. • Created monitoring templates for the Production databases in Oracle Enterprise Manager Cloud Control 13c. • Implementing the Application changes on Production using Dell Stat for Oracle E-Business Suite. • Supporting different flavours of SQL Servers (2005,2008,2012,2014,2016,2017). • Supporting the Progress databases on HP-UX 11i server container framework.