oracle database

Sabastine S Ngwa

Oracle Database Administrator/ SQL Server Database administrator

Phone +1-469-***-****

*************@*****.***

Education

Bachelor’s Degree Computer Science, University of Buea

ORACLE DATABASE 12C, SQL FOUNDAMENTALS

Profile

I have over 7 years plus of extensive experience in Oracle Database Administration/SQL Server Database administrator, Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control and Oracle Streams.

Professional Skills

Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, StatsPack, and SQL Trace.

Excellent experience in Installation and configuration of Oracle 12c,11g, 10g in UNIX/LINUX and Windows environment.

Upgraded Databases from 10g, 10g to 11gand 11g to 12c on various platforms.

Proficient in Database administration activities such as user management, space management, Monitoring, Creating Database, Managing Oracle Instance and Database security and Materialized Views.

Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions) using oracle 11g tools like AWR, ADDM, Advisories, SQL TRACE,EXPLAIN PLAN for the better performance.

Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).

Supported teams in resolving SQL Server Reporting services and T-SQL related issues.

Experience in performing point in time recovery at times of necessity.

Design and implement backup and recovery including disaster recovery structures.

Familiar with Data Warehousing (ETL), Data mining and OLTP concepts and ASM, SAN.

Wrote scripts to inform the DBA team on the status, performance and space management of the database.

Experienced in monitoring metrics on EC2, EBS, Elastic Load Balancer, RDS USING CloudWatch.

Created load balancers (ELB) and used Route53 with failover and latency options for high availability and fault tolerance

installed and configured Oracle 10g, 11g, 12c on Sun Solaris AIX, UNIX/LINUX, HP-UX and Windows environment.

Synch -up database environments (DEV, QA) after each major release or production change.

Worked on export/import, data pump and SQL Loader.

Experienced in installation and configuration of Oracle cluster ware and Automatic Storage Management (ASM) in RAC environment.

Experience in conversion of Single Node Instance to multimode RAC with ASM, and adding instance to existing RAC.

Experience in Migration of Oracle Databases from non-RAC to RAC and non-ASM to ASM Instances.

Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).

Configured and maintained physical standby databases using Oracle Data Guard to perform quick disaster recovery.

Data warehouse analysis and design for diverse legacy system integration.

Process/workflow analysis, project management from analysis and design for implementation.

Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.

Participated in planning and implementation of off-site Disaster-Recovery planning and testing

Worked with development and operations staff in resolving problems quickly and efficiently

Oracle GOLDEN GATE for data sharing using EXTRACT, REPLICAT, DATAPUMP, MANAGER PREOCESS for Bidirectional, unidirectional, Broadcasting and consolidation topologies.

Experienced in Encryption and Oracle TDE, Oracle Wallet.

Proficient with encryption algorithms, which allows TDE onto column and tablespace encryption.

Manage security and grants for database users.

Maintained Oracle 11g ASM OID database. Applied PSU and CPU security updates.

• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

• Expertise in T-SQL writing stored procedures, triggers and functions.

• Administering SQL Server High Availability and Disaster Recovery strategies.

• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

• Worked on logical and physical data base modelling with UML and ERWIN tools.

• Experience in using DMV and dynamic management functions for finding out long running queries.

• Worked extensively on Clustering and server consolidation. Troubleshooting production issues and raising high availability.

• Experience in Disaster Recovery Planning and Security Management operations.

• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

• Having hands on experience in DR processes including Log Shipping and Database Mirroring.

• Worked on configuring SQL Server with minimum privileged access.

• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.

• Troubleshoot performance problems, fine-tuning of databases and index Analysis.

• Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

• Maintained individual service accounts for SQL Server services on cluster with different Security groups to raise security mark.

• Having Experience on Data centre servers and handling 1.4 TB databases.

• Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

• Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.

• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

• Strong experience in mentoring team members and writing documentation.

• 24 X 7 Production Database on Call Support

Professional Experience

Windstream Communications - Twinsburg, OH

JUL 2017 - Present

Oracle/SQL Database Administrator.

Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)

Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.

Monitor for performance and tune PeopleSoft Financial applications running Application release 9.x2 and People Tools 8.54.

Configured Security group for EC2 Window and Linux instances and also for puppet master and puppet agents.

Design and implementation of Backup & Recovery strategies

Upgrade 11G RAC to 12c RAC and Administering the RAC Environment through SRVCTL and CRSCTL and applied patches in rolling fashion

Worked on 12c RAC new builds and administering 12c RAC and managed ASM on RAC

Configured disk groups with different redundancy levels and created fail groups and managing and tuning ASM parameters

Configuration & Troubleshooting the Oracle Data Guard & Golden Gate environment in Oracle 11g & 12c versions.

Maintained encryption on various databases using Oracle TDE.

Configured Golden Gate 12c RAC, RAC Active configuration with 12c database

Hands on experience in GGSCI utility for administering Extract, Pump, Replicate & reviewing the error logs and troubleshooting Abend scenarios.

Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.

Performed Data file recovery from logical and physical block corruptions

Good understanding and Implementation expertise in RAC, ASM, Data Guard like remedy change and user tickets, frequently communicate effectively with technical and non-technical customers.

Exp on Cluster management, event management, application management, connection management, storage management, load balancing and availability. Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkrpof, Explain plan.

Experience working with SQL, PL/SQL coding, stored procedures, functions, packages, triggers.

Partitioning strategies for very large tables. Implemented Range, List, Hash and various Sub Partitions, Create and schedule refresh for materialized views.

Work with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.

Management of schema objects, partitioning of tables & indexes and performing SQL*Loader jobs for loading data from flat files (ETL) and Oracle Database monitoring, troubleshoot and resolve the issues.

SQL tuning - AWR history of sql execution, index recommendations, SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Interpret Execution plans, Re-write more efficient SQLs.

Data Refresh of large production data warehouse environment to setup test, development environments using SAN level storage mirroring: Gold image copy and cloning.

Tuned the Database and applications using AWR, ADDM, STATSPACK, ESTIMATE, ANALYSE, EXPLAINPLAN, SQLTRACE, and TKPROF and gathered DBMS statistics.

Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.

Improving the performance of the database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g

Worked on setting up Physical Standby Data Guard environment for Prod & non-prod databases.

Provide support to developers to enhance their SQL, PL/SQL code and responsible for setting up of new user accounts, schema Deployments and related user administrative tasks.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

ABC Health Services, Miami, F

April 2013 – May 2017

SQL SERVER DBA

•Responsibilities:

• Performed server installation and configurations for SQL Server 2005 and SQL Server 2000.

• Performed installation of SQL Server Service Packs.

• Upgraded databases from SQL Server 2000 to SQL Server 2005.

• Involved in capacity planning, sizing, and database growth projections.

• Scheduled Full and Transactional log backups for the user created and system databases in the production environment using the Database Maintenance Plan Wizard.

• Setup backup and restoration jobs for development and QA environments

• Created transactional replication for the reporting applications.

• Implemented disaster recovery solution at the remote site for the production databases using Log Shipping.

• Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.

• Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.

• Used SQL Server Profiler to monitor and record database activities of particular users and applications.

• Used DBCC commands to troubleshoot issues related to database consistency.

• Used Index tuning wizard to redesign and created the indexes for better performance.

• Fine-tuned Stored Procedures using Execution Plan in T-SQL for better performance.

• Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.

• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

• Worked on upgrading DTS packages to SSIS packages.

• Implemented trigger and stored procedures and enforced business rules via checks and constraints.

• Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.

• Reviewed DB Scripts from the development team before releasing them into the Production.

Environment:

Windows 2003 Server, SQL Server 2005, SQL Server 2000,T-SQL, PL/SQL, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, HTML/DHTML, XML, Oracle8i.

Technical Environment

OPERATING SYSTEMS:

Red Hat Linux RHEL 5.x and Windows XP

RDBMS:

Oracle 10g/11g and 12c

LANGUAGES:

SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/ TOOLS:

DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Cloud Technologies Amazon Web Services, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS:

SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

SQL SERVER TOOLS:

Operating Systems Windows Server 2012/2008, MS Office Access

Programming HTML, XML SQL Server Management studio (SSMS), SQL Profiler.

Databases:

MS SQL Server 2012, 2008, MS SQL Server 2005

Programming:

Visual Basic 6, Visual Basic 5, C, C++ & SQL

DBA:

database administration of MS SQL Server 2012,2008, 2005

Operating System:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Other Software:

Windows 2008/2003 Advanced Server, NT & Windows 9x, Linux

Tools:

Backup Utility, SQL LiteSpeed, Visio

Network Topologies:

TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

Environment: Oracle 10g, 11g, 12C, Unix shell script, Grid Control, Data Guard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Statspack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring.

Contact this candidate