Oracle Dba Consultant Resume
Atlanta, GA
OBJECTIVE:
- Seeking for a position where my work experience and educational background, in addition to good communication and analytical skills, can be best put to use to ensure company profitability and customer/client satisfaction.
TECHNICAL SKILLS
Operating Systems: Dos, Windows 95, 98, 2000, Windows NT, UNIX Sun Solaris
Databases: Oracle 7.3, 8.0, 8i, 9i, Oracle Database10g R2, Oracle 11g
Applications: Oracle E - Business Suite Release 11.5.10
Certifications: Oracle8/8i/9i/10g/11g DBA Oracle Certified Professional (OCP)
Training: Oracle 8/8i/9i,10g, 11g & Developer 2000 (SQL, SQL *PLUS, PL/SQL), UNIX
Software & Networking: Experience in Network environment that had Windows 98, NT, 2000 - by providing technical support. Familiar wif Network Connectivity - Hubs, Bridges
Hardware: Installation and configuration of IDE SCSI hard disks. Upgrading Hard Disks, Motherboards etc. Routine Maintenance of laser printers.
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
Oracle DBA Consultant
Environment: Oracle Database 11gR2 (11.2.0.3) and 10g database running on RHEL 6, Oracle Enterprise Manager Cloud Control 12c, Oracle Real Application Clusters (RAC), mySQL, PostgreSQL, Confidential InfoSphere Guardium
Responsibilities:
- Tracking and reporting database operations such elements as tuning tasks that involved determining which SQL statements run on behalf of a specific batch job, what their execution statistics were, what was occurring in teh database when teh operation was executing, and so on.
- Monitoring resource usage wif a view to determine SQL execution using excessive CPU, issues an excessive amount of I/O, or takes a long time to complete. Wif Oracle Database Resource Manager (teh Resource Manager), configured thresholds for each consumer group that specify teh maximum resource usage for all SQL executions in teh group.
- Tuning for Response Time in that most of database operation issues are mainly SQL performance issues.
- Monitored SQL Executions in Oracle Enterprise Manager Cloud Control 12c.
- Performed operations using tools such as Import/Export - Data Pump
- RMAN backup and Recovery Operations.
- Troubleshooting RMAN Backups.
- Troubleshooting mySQL and PostgreSQL databases.
- Monitoring using Confidential InfoSphere Guardium.
Confidential, Charlotte, NC
Oracle DBA Consultant
Responsibilities:
- Troubleshooting Oracle Database performance
- Performance of Oracle and Operating System performance monitoring and teh necessary adjustments.
- Analysis of awr reports
- Analysis of addm reports
- Analysis of ash reports
- Analysis of explain plans
- Analysis of tracefiles
- ORA-00060: deadlock detected while waiting for resource - issues
Confidential, New York
Oracle DBA Consultant
Environment: Oracle Database 11gR2 (11.2.0.3) database running on RHEL 6, OEM 12c Cloud Control
Responsibilities:
- Troubleshooting and Performance Tuning of Oracle Database using Oracle Database 12c Cloud Control.
- Engaged in Troubleshooting of Oracle Database; and Performance Tuning using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).
- Troubleshooting Oracle RAC in view of time synchronization issues wif Network Time Protocol (NTPD) and Cluster Synchronization Services Daemon (CTSSD).
- Monitoring of Oracle Exadata environment using Oracle Database 12c Cloud Control.
- Performed a number of import / exports using Data Pump.
Confidential, Charlotte, NC
Oracle DBA Consultant
Environment: Oracle Database 11gR2 (11.2.0.3) database running on RHEL 6
Responsibilities:
- Identify teh database that will be configured wif Active Dataguard
- Identify teh location for teh physical standby database of teh automation database
- Identify teh location for teh physical and logical standby databases for teh billing database
- Validate space and storage requirements for teh standby database
- Review current OEM implementation. Determine best method for Active Dataguard implementation through OEM or manual
- Review current RMAN backup. Determine if to use existing backup or create a new backup to use for Dataguard.
- Configure Active Dataguard and Dataguard broker for teh automation database
- Transfer data from primary to secondary location.
- Startup standby database in open read-only mode.
- Validate Active Dataguard configuration by executing a switchover and switch back.
- Provide support to teh City of Charlotte dba/middleware team while they perform failover testing
- Configure Active Dataguard and Dataguard broker for teh billing database
- Transfer data from primary to secondary location and create a physical and logical standby databases to mirror their current 10g environment.
- Startup standby databases
- Validate Active Dataguard configuration by executing a switchover and switch back.
- Provide support to teh City of Charlotte dba/middleware team while they perform failover testing
- Document configuration steps
- Review configuration wif City of Charlotte and provide knowledge transfer
Confidential, Norcross, GA
Oracle DBA Consultant
Environment: Oracle Database 10g and 11gR2 running on UNIX AIX, RHEL 6
Responsibilities:
- Oracle 11g upgrade & Oracle patch updates
- Oracle Database Monitoring and review using Oracle Grid Control
- Backup and Archiving Strategy overhaul for Database Servers
- Capacity Planning and Analysis review for Database Servers
- Spotlight Monitoring for SQL Server Databases
Confidential, Columbia, MO
Oracle Production DBA
Environment: Oracle Database 11g, 10g, 9i, 8i, on Red Hat Linux, Sun Solaris, AIX, HP-UX, Windows
Responsibilities:
- Thorough knowledge of Oracle RDBMS 11g/10g/9i/8i environments.
- Several years experience in Oracle Database Administration/support in Oracle RDBMS 11g, 10g, 9i in 24x7x365 production environments.
- As an Oracle DBA, provided physical database support in…installing and upgrading oracle 9i, 10g and 11g.
- Equally, provided physical database support utilizing teh tool OEM/Oracle Grid Control in RAC and non-Oracle RAC environments.
- About 18 months experience in setting up and maintaining production Oracle RAC environments.
- Strong Database and RAC implementations experience and troubleshooting skills in mission critical Environment.
- Maintaining Dataguard on 11g, 10g wif MAA.
- Experience wif setting up and managing ASM instances.
- Strong knowledge of Oracle Database Tuning and using AWR/ADDM/ASH.
- Demonstrated, in-depth knowledge of database internals and data structures.
- Knowledge of SQL/SQL*Plus.
- Managed trouble tickets that came in via teh Remedy ticketing system, Oracle Grid alerts.
- Involved in database growth and system utilization, trend analysis and predicting future database resource requirements.
- Involved in Oracle space management regarding extent, segments, datafiles, tablespaces...etc. racle space management - resolved Archiving and space destination issues.
- Performance Tuning & Capacity Monitoring; worked wif developers to improve performance by creating and analyzing Execution Plans...in addition to creating Objects to improve performance.
- Troubleshooted Oracle GoldenGate Down issues...in Reporting Database - extract, replicat, trail files.
- Troubleshooted RMAN backup and recovery issues....in addition to using SQL Backtrack.
- Killed sessions in RAC, single instance using Pid, SID, Serial#.
- Monitoring blocking sessions, hang sessions using Oracle Database 11g Grid Control, monitored jobs, user administration.
- Worked in several Oracle Databases meeting SOX requirements.
- Participated in High Bridge calls, Webex Bridge calls.
- Participated in a rotating on-call schedule wif DBA team.
Confidential, Douglasville, GA
Oracle Database Administrator
Environment: Oracle 10g, 9i, on Red Hat Linux
Responsibilities:
- Created 9i, 10g DBs using DBCA and also manually. Worked on Large Database of Size 1.1 Terabyte.
- Refreshed DBs from One Box to Another. Created DB Link between Oracles databases.
- Extensively used Datapump. Backing up and Refreshing Oracle DBs.
- User Administration, Creating Tables, Application Specific queries using SQL Analyzer in Oracle Database’s. Configured teh RMAN Backups using HP Omni Data Protector.
- Explored 10g’s improved Automatic Optimizer Statistics Collection using Automatic Workload Repository (AWR). Worked wif AWR Snapshots, Created Baselines, Viewing AWR Reports. ADD on analysis on AWR Snapshots. Explored Automatic Shared Memory Management.
- Implemented Automatic Storage Management. Created Big file Table Space creating and maintaining big file Table Spaces. Creating and Dropping temporary table space Groups.
- Creating and default Permanent Table Spaces.
- Hands on experience in Backup and Recovery, schedule backups (Datapump and RMAN) via cronjob.
- Installed, configured, upgraded, and managed Oracle RDBMS 10g, 11g.
- Maintained/Monitored, and provided backup suppport for teh Oracle 10g / 11g Database.
Confidential, Atlanta, GA
Oracle Database Administrator
Environment: Oracle 9i and 10g on Sun Solaris9
Responsibilities:
- Ensured that teh databases remain healthy and stable, ensuring Confidential meets its overall SLA's.
- Worked wif onshore and offshore resources.
- Provided DBA services to support steady state day to day work
- Performed application and database performance tuning.
- Developed procedures and scripts for continuous improvement, repeatable processes and maintenance activities related to databases.
- Ensured consistency and completeness across system changes.
- Researched technical problems and assisted in identifying solutions.
- Interacted wif app teams and client personnel on technical issues.
- Coordinated database level changes wif data center, tech team, applications team and management.
- Provided support in SQL tuning, backup and recovery support, installation of Oracle software and configuration, applied patches, Unix shell scripting, partitioning of tables and indexes, partition maintenances, archiving of data, capacity planning, complex security architectures and utilizing basic Unix administration skills.
Confidential, Atlanta, GA
Implementations Specialist II
Responsibilities:
- Troubleshooting and resolution of customer problems, including identifying user errors, unit issues, Sprintlink IP, Sprint Asynchronous Transfer Mode (ATM) anomalies, and network related problems.
- Responsible for maintaining teh trouble reporting process for customer reported troubles (internal and external) on products such SprintLink IP Networks, ATM, Frame Relay etc
- Identifying and resolving critical customer service effecting problems, performs liaison activities between Engineering, Operations, Sales, Marketing, Customer Care and Corporate Engineering.
- Participated in market level personnel and customer care notification process on unscheduled and scheduled system outages.
- Resolved subscriber network troubles using trouble management software tools. Performed first-line diagnostics on subscriber network trouble tickets and issues that are escalated.
- Escalated client problems according to established procedures.
- Managed teh network using network management tools, analyzed network performance and recommend network enhancements.
- Analyzed network performance to ensure adequate bandwidth for business needs.
- Recommended enhancements to teh network infrastructure, and wif management agreement enhance proactive network management tool set.
Confidential, Roswell, Ga
Responsibilities:
- Assisting upgrading and new customers wif implementation of PLD (Package Level Detail)
- Certifying and troubleshooting customer’s PLD files
- Participating in annual user acceptance testing of PLD specifications and certification tool
- Creating documents and templates to clarify PLD specifications based on customer queries
- Excellent oral and written communication skills
- Strong analytical and problem solving skills; excellent trouble shooting skills
- Attention to detail and quality
- Customer focused; capability to accurately convey information to customers
- Ability to analyze customer needs and recommend appropriate solutions
- Professional demeanor
- Self-directed; work well wifin a team environment
- Ability to work collaboratively wifin a cross-functional environment
- Ability to learn new technical concepts quickly
- Ability to prioritize and manage multiple projects
- Proficient use of personal computers and Microsoft Office suite
- Proficient wif PC software and hardware; familiarity wif AS400