Prabhpal S

Database Administrator - 9 Years of Experience - Near 30005


Database Administrator


Alpharetta, GA

Education Level:


Will Relocate:



SUMMARY Results oriented Certified Oracle DBA having 9+ years of experience in database administration, system maintenance, production support, RAC, performance tuning, standby, replication, space management, installation, migration, backup recovery, cloning and database security. * Worked as a dedicated team member responsible for monitoring/support of oracle databases performing release upgrades including overall performance tuning/patch management. * Documented all technical details including operations, maintenance and end user application issues. * Installed and configured Oracle 9i, 10g, 11g, 12c on Sun Solaris, AIX, UNIX/LINUX, HP-UX and Windows environment. * Synch -up database environments (DEV, QA) after each major release or production change. * Implemented One node RAC and four node 11g RAC clusters on Linux platform and AIX LPARs having GPFS cooked SAN Storage. * Provided support to the Database system Infrastructure area that had few critical Business Systems including TR, Bills Order and Tracking, Online Charges. * Co-ordinate with UNIX administrators and management team for space management, problem resolution, capacity planning, software version control, evaluation and support on various servers. * Established standby/cloned database via Data Guard for Database Disaster Recovery * Employed predefined UNIX scripts to cleanup database files such as outdated archived redo logs and trace files out of bdump, udump and audit directories. * Trouble shoot and Configured Sql*Net files according to client and server settings to transfer data. * Worked on export/import, data pump and SQL Loader. * Data warehouse analysis and design for diverse legacy system integration. * Process/workflow analysis, project management from analysis and design for implementation. * Conceptual data modeling, logical and physical data modeling. * Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning. * Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace. * Good experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Standby Databases, Backup and Recovery procedures. * Worked closely with the application, development and middleware teams for bug fixes and escalation of critical issues related with WAS. * Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*Loader. * Worked with team of DBAs in migration of databases from oracle 10g to 11g, 12c.





CollapseJob Skills