Description
SUMMARY 9+ years of Experience with high-volume, high-performance database systems. Experience with Enterprise-scale data warehouse systems. Experience in the Design, maintenance, and administration of ORACLE 12c/11g/10g Experience writing, Creating, and Tuning SQL. Experience in SAS data management, and IBI monitoring and runtime optimization of applications, data jobs, replication, and cloud activities including AWS. * Proposed, designed, documented, and deployed many infrastructure projects saving the client significant money in managed cost and cost avoidance. * Solutions proposed, architected, deployed including HP-UX to Linux platform migration, advanced compression, Real Applications Clusters (RAC), Database migrations. * Extensive knowledge on database administration for ORACLE 12c/11g/10g with experience within very large scale database environment and mission-critical large OLTP and OLAP systems * Expert with planning, creation, administration, and troubleshooting of ORACLE 12c/11g/10g OLTP (multiple instances)/OLAP databases in production. * A handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU's) in various environments. * Worked on HP-UX, AIX, Sun Solaris, RED HAT Linux and Oracle Linux and Windows environments. * Development and implementation of Enterprise database services standards, guidelines, processes & procedures, and best practices. * Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and BIDIRECTIONAL REPLICAT issues. * Solid experience in disaster recovery, Database backup concepts, and options such as user-managed backup, RMAN-managed backup with or without a catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies. * Backup, Recovery, and Cloning of databases using RMAN also profound in using the new Oracle 11g features in these utilities. * Writing scripts in the UNIX-based environments for managing the user's roles and privileges, scheduled backups (using Data Pump /cold backups), manage statistics. * Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes. * Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF. * Experience in writing PL/SQL Stored Procedures, Functions Packages, and Triggers, various scripting languages such as Perl, Awk, and UNIX Shell Scripting. * Extensively used BMC Remedy and Service Now Ticketing systems for monitoring. * Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude. * Involved in designing and deploying a multitude applications utilizing almost all of the AWS stack * Migrated the current Linux environment to AWS/RHEL Linux environment and used auto scaling feature * Install and configure chef server/workstation and nodes via CLI tools to AWS nodes * Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
Accomplishments
Highlights:
Keywords
