
Over 10 plus years of sound experience as core DBA in database design and administration of Oracle 9i ,10g ,11g,12c, 19c, Oracle EBS 11i, 12x ,SQL Server 2000/2005/2019, MySQL8, EDB PostgreSQL in development, integration, staging and production environments, Experience with Cassandra data store and familiarity with document store Mongo DB. Solid understanding of hadoop architecture and components of Hadoop ecosystem (HDFS, MapReduce, Pig, Hive, Sqoop, Oozie). Experience in database administration of OLTP and Data warehousing (OLAP) environment. Working knowledge of ETL tool Informatica to create design process flow for Data extraction transformation and load and subsequent mappings. Monitoring of databases to identify performance issues - using Precise i3, OEM, TOAD, etc. Demonstrated proficiency in managing Oracle/SQL Server Instance, database storage structure, schema objects. Strong knowledge of SDLC and AGILE methodologies. Knowledge and experience on Oracle EXADATA X3-2, architecture (half rack, quarter rack, full rack), smart scan and other features. Knowledge of EXADATA features like smart flash cache intelligent caching, smart scan processing, I/O resource management. Knowledge of command and scripts to do monitoring and maintenance of EXADATA machine like exachk, dcli, cellcli ,cellsvrstat. Knowledge on Oracle Security technologies and tools Transparent Data Encryption(TDE), FGAC etc. combined with best practices of ITIL to design solutions by mapping customer business problems to reusable end to end process and process combined with technology solutions. Excellent knowledge and understanding of Oracle Architecture (SGA, PGA, Instance). Expert knowledge of maintaining security by creating Users and Roles with appropriate Privileges and Profiles, OID. Knowledge of Oracle Audit Vault for automating the audit collection, monitoring and reporting process for detecting unauthorized activity. Constructed Partitions on tables for managing large tables. Monitored tablespaces, segments, extents, and indexes. Good understanding of Parallelism and batch processing of SQL queries in OLTP environment. Hands on experience of managing Very Large Databases (VLDB) in the range of 500 GB to 20 TB. Extensive use of Crontab in UNIX environment for scheduling routine tasks. Knowledge of ENSCRIBE rdbms for supporting unstructured, key-sequenced, entry-sequenced, relative and queue file systems. Experience in writing UNIX shell scripts to check the status, space management and performance of the database. Knowledge of RAID levels namely RAID 0 through RAID 5. Strong knowledge of SQL Server 2000/2005 database techniques DTS and SSIS for data transformation. Experience in using oracle packages such as DBMS_STATS, UTL_FILE, DBMS_JOB and DBMS_SCHEDULER. Implemented Database link to access the object on remote database and script to check the connectivity among all the databases. Exposed to database tuning, SQL tuning and capacity planning in Oracle 8i/9i/10g environments. Cloned database from PRODUCTION to TEST and DEVELOPMENT and from Development to production using RMAN. Strong experience in performing database backup, restore and recovery using RMAN. Experience in Upgrade and Migration of oracle database to higher version installing patches and other platforms without/with using Oracle Data Migration Assistant (DBMA) and Oracle Data Upgrade Assistant (DBUA).