Database Administrator Sql Developer

NILVIS BONGKIYOI

Address: **** ****** ******, ** ****, MN 55106

Email:**********@*****.***

Linked: linkedin.com/in/nilvis-bongkyoi-a220a31bb

Phone: 763-***-****

ORACLE DATABASE ADMINISTRATOR

PROFESSIONAL SUMMARY

An accomplished Oracle Database Administrator (DBA) with over 8 years of experience and extensive knowledge in Database Design and development, performance monitoring and tuning, migration, upgrades, Database Backup and Recovery, Database Security Implementation, database configurations, installations and Patching. Proficient in Oracle database administration of versions 11g, 12c and 18c across different platforms such as windows, Red Hat Linux, Solaris and UNIX, and currently in the process of upgrading to 19c. Enthusiastic, proactive team player who is fast at picking up new technology with great attention to details with strong organization, verbal and written communication skills. Able to multitask successfully and thrive in a dynamic fast paced and versatile work environment with excellent, interpersonal, strong analytic and decision-making skills and with ability to juggle multiple priorities and perform effectively under pressure.

SKILLS AND COMPETENCIES

• Installation, configuration and upgrade of Oracle databases using OUI, DBCA, DBCA

• Monitoring and performance tuning using Oracle Enterprise Manager Console and SQL Developer, Toad, Grid control

• Works with various operating systems like MS Windows Servers (2016) and LINUX

(Red Hat)

• Database Design and development (SDLC)

• Backup & Recovery using RMAN

• SQL*Plus

• PL/SQL, UNIX Shell Scripting

• Oracle ASM (clusters) and RAC configuration and administration

• Database security

• Database migration using Exp/Imp/Data pump, and SQL Loader

• Network and Connectivity

• SQL Server.

PROFESSIONAL EXPERIENCE

SUPER TARGET, MINNEAPOLIS -SEPTEMBER 2017 - PRESENT ORACLE DATABASE ADMINISTRATOR

• Uses Oracle Enterprise Manager Console and SQL Developer to manage daily tasks regarding performance and maintenance

• Monitors and reports daily backups with Recovery Manager (RMAN) configures and manages backups (full and incremental).

• Perform Installation, security and patch upgrades over successive Oracle generations using the Oracle Universal Installer (OUI), Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA).

• Full responsibility and expertise in Database Administration (DBA), Performance Tuning, Database Recovery, Database Security, Database Optimization, Database Migration of Oracle instances.

• Creates database objects such as tables, views, synonyms, sequences and triggers, materialized views.

• Creates user accounts and assigns appropriate privileges

• Monitors and resolves Data guard problems, maintains flashback capability, troubleshoots database problems including performance issues and resolves them with the Automatic Workload Repository (AWR), Performance views and SQL Tuning advisor.

• Implements a backup and recovery policy and using RMAN

• Responsible for monitoring and troubleshooting the database environment.

• Table space monitoring, Performance monitoring and tuning for performance improvement.

• Implements database security using Oracle's Transparent Data Encryption (TDE) to protect the organization's critical information and exceeding the industry standard.

• Perform SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor

(ADDM) reports and active session history (ASH).

• Administered tablespaces (data file) on space management and adjust for future needs.

• Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases

• Clones databases using RMAN and DATA PUMP utilities for all database sizes

• Installs and administers Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)

• Works in a cross functional team that oversees the Oracle RAC installation and configuration for Linux environments.

• Installs, configures, patches Oracle database 18c and 19c software. Creates databases and migrates data on 18c and 19c.

• Develops a backup strategy for our MSSQL Server databases and administered these databases using tools like SS management studio, SS DCA.

• Work knowledge of Microsoft SSIS, SAAS, ETL, SSIS WALMART SUPERCENTER, ST PAUL -FEBRUARY 2014 – JULY 2017 ORACLE DATABASE ADMINISTRATOR

Administered and supported development of Oracle 11g databases by installing, and configuring the Oracle Server. Created databases and database objects and cloned production databases as needed for testing and development using RMAN and Grid Control. Identified the root cause of Oracle errors and provided solutions to resolve them. Implemented proactive database monitoring using SQL Trace. Performed database design and maintenance using Oracle partition technologies.

• Implemented backup and recovery procedures using RMAN and Data Pump utility for Oracle databases and tested regularly

• Maintained 24*7 Availability by implementing standard processes and troubleshooting live issues.

• Monitored and optimized database performance, troubleshooting performance issues using OEM and AWR.

• Performed SQL Tuning and provided consultation such as creating Materialized views, table partitions, build indexes, drop unnecessary indexes.

• Managed database security by creating and assigning privileges to users depending on the user’s activity, auditing and performing other security related tasks including Transparent Data Encryption as well Tripled A and acknowledged Health Insurance Portability Accountability Act (HIPAA) laws.

• Used oracle flashback technology to bring the database back in time so as to undo human errors.

• Monitored bugs from the alert log and trace files and used Data Definition Language

(DDL) statements to CREATE and ALTER within a dynamic SQL script, created schemas, synonyms and roles.

• Used RMAN for database refresh with hot backups, incremental backups and

• Validated to ensure the backups were secured and usable for recovery.

• Participated as part of a teamwork effort for SDLC principles and the development of documentation for new procedures and processes for technical projects.

• Managed users by creating them, assigning roles, managing passwords and privileges including other security related tasks.

• Managed Automatic Storage Management (ASM) and Non-ASM database file systems

• Used Oracle Enterprise Manager (OEM) for database monitoring, security, schedule backup and recovery performance tuning and tablespace creation.

• Installations of Oracle databases on Linux OS and analyzed SQL statements, reorganize database objects and rebuild indexes.

• Performed day to day database administration tasks like database creation, monitor user's activities, check databases performance for any bottleneck, as well as working on projects such as upgrades from (11g, 12c and 19c) and patching.

• Installed, configured, and monitored Oracle golden gate in my environment. EDUCATION AND CERTIFICATION

Bachelor of Science (BS) in Applied Zoology University of Bamenda, Cameroon –2016 Oracle Certified Associate (OCA) – in progress

Contact this candidate