Resume

Sign in

Manager Oracle

Location:
Minneapolis, Minnesota, United States
Posted:
October 11, 2016

Contact this candidate

Resume:

Sylveria Kimbi

acw0jw@r.postjobfree.com

240-***-****

PROFESSIONAL SUMMARY

With over 9 years of IT and related experience coupled with 7+ years of extensive knowledge and proficiency in oracle 9i, 10g and 11g database administration – I have worked on very large production databases performing various DBA roles. I have experience across a multitude of platforms (LINUX, Solaris, UNIX, AIX and Windows) in production, development and test environments.

I am an enthusiastic,proactive team player who is fast at picking up new technology with great attention to detail.I possess excellent leadership ability and creative problem solving skills in both strategic and tactical areas as well as great communication /documentation skills. With my strong aptitude to analyze and resolve problems, I have a well-honed ability to adapt and thrive in a dynamic fast paced and challenging work environment.

PROFESSIONAL EXPERIENCE

Ventech Solutions, Manassas, VA Oct. 2015 – Jul. 2016

Oracle Database Administrator

Administered and supported developmentof Oracle 11g databases by installing, upgrading and configuring the Oracle server, creating databases, objects, database backup and recovery, monitoring and optimizing database performance.

Cloned production databases as needed for testing, development using RMAN and Grid Control.

Implemented backup procedures using RMAN and Data pump utility for Oracle databases and test regularly in conjunction with Operations.

Maintained 24*7 Availability by implementing standard processes and troubleshooting live issues within defined tight SLA times.

Assisted in SQL tuning and providing consultation such as creating Materialized views, table partitions, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst others.

Database Capacity Management (Worked with Storage teams for ASM Disks) using automated scripts/processes and Reports.

Performed batch jobs using crontab utility.

Managed database security by creating and assigning appropriate roles and privileges to users depending on the user activity, auditing and other security related task including transparent data encryption.

Troubleshoot Database Performance issues using OEM, AWR, ADDM and ASH.

Planned, implemented and maintained Oracle Dataguard/Standby databases, for production database fail-over to remote disaster recovery sites.

Oracle High Availability involving Oracle RAC, and Dataguard exposure.

Provided 24*7 on-call production database support (rotation).

Deployment.

Patching.

World Financial Group, Largo, MD Jan. 2012 – Aug. 2015

Oracle Database Administrator

Identified root cause of Oracle errors and provided solutions to resolve errors. Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database tables Design /Maintenance using ORACLE partition technologies.

Monitored bugs from alert log, audit logs and trace files.

Used DDL statements to CREATE and ALTER within a dynamic SQL script to create schemas, Synonyms and Roles. Extensive use of SELECT statements for reporting.

Evoked RMAN for database refresh with the hot backup, incremental backup and validate to ensure backup is secured and reusable for recovery.

Knowledgeable of Software Development Life Cycle (SDLC) principles and the development of documentation for new procedure and processes for technical projects.

Involved with a team that evaluated current policies to improve SOX compliance implementation.

Managed users. Created users, assigned user profiles, privileges and roles. Including password changes.

Shell scripting.

Ingersoll Rand, Davidson, NC June. 2009 - Dec. 2011

Oracle Database Administrator

Assisted with gathering data and statistics used for capacity planning metrics and CBO evaluations.

Monitored quota on tablespace in line with resource planning guide.

Created database objects such as tables, views, synonyms, sequences, and triggers.

Implemented database security measures based on vulnerability reports generated by security team. Measures included password policy, patching, parameter modification, and system privileges restriction for users and or schemas.

Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters.

Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability.

Troubleshoot application related problems with developers and system administrators

Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes.

User creation and management.

TECHNICAL APPLICATIONS/TOOLS

BEST PRACTICE FRAMEWORK: ITIL, Oracle

OPERATING SYSTEMS: Windows, RHEL6, Sun Solaris, HP-AIX

RDBMS: Oracle 9i, 10g/11g R2, Microsoft SQL Server 2000.

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting

TUNNING TOOLS: TKPROF, EXPLAIN PLAN, AWR and ADDM, ASH, SQL TRACE

SOFTWARE/ APPLICATIONS/ TOOLS: SQL*PLUS, DBCA, DBUA, Recovery Manager (RMAN), Data Pump (expdp,impdp), SQL*Loader, Oracle Enterprise Manager (OEM), SQL Developer, ASM,PUTTY, SQL Developer

EDUCATION/TRAINING

Oracle University

Oracle Certified Associate (OCA)

University of Buea, Cameroon

Bachelor of Science major in Sociology and Anthropology

Minor in Women and Gender Studies

MISCELLANEOUS SKILLS

Advanced knowledge in Excel, Access, PowerPoint and outlook.

Advance knowledge of Adobe PDF Professional, Dreamweaver and Photoshop.

Able to speak French.

References

References shall be provided upon request.



Contact this candidate