Occupation:Database Administrator |
Location:Norcross, GA |
Education Level:Master |
Will Relocate:YES |
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. * 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 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. * 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
