About Me

Hello and welcome to my database blog

For those who are interested to find out more about me:

I’m Justin John, an enthusiastic and knowledgeable Principal Consultant with 19 years of Oracle and MS SQL and MySQL experience. I work with different Oracle Customers daily with their Oracle database adventures.

I’ve worked extensively in the following technologies:

Expert hands on Oracle RAC (8i,9i,10g, 11g 12c and 18c), Backup with RMAN/NetBackup/Tivoli, High Availability Data Guard/Standby, Grid Control, ASM, OEM, Data Warehousing, on variety of UNIX (Solaris, Linux, HP-UX, AIX), Exadata, and Windows platforms. Handled very large OLTP Databases in 24×7 environments on Oracle, SQL Server and MySQL platform (customer facing). Performance tuning, Optimizing SQL, using varies Oracle tools such as AWR/ADDM/Statspack/Tracing/TKPROF/Explain plan etc. Expert in Infrastructure planning, database design, capacity planning, architect, deploying and managing database and IT Infrastructure and business applications within large scale enterprise environments.

Data warehouse with Microsoft SSIS, SSAS, BIDS and Strong experience with Database Modeling, Data Analysis and Conceptual, Logical and Physical modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.

SQL Server Profiler, Activity monitor, Perfmon (windows) to tune the databases, queries, and performance related issues like memory CPU and I/O issues.

I also have the following certifications:

Oracle Certified Professional (OCP): Database Administration 9i,10g, 11g & 12c
Oracle Certified Real Application Clusters (RAC) Expert: 10g, 11g & 12c
MySQL Certified Database Administrator (5.6)
Oracle Database Cloud Administrator Certification (OCP)
Advanced Project Management (Stanford University)
Java Certified Professional (JCP).