Sql Server Database Administrator
Resume:
Richard chungong
Sr. Solution Management Consultant
Union City, Georgia, United States
***************@*****.***
www.linkedin.com/in/richard-chungong-93b57a1a3
SUMMARY
*Oracle Database Administrator experience in performance tuning, crisis management, and supporting high availability to increase reliability, maximize productivity and ensure system efficiency.
*Experiences in setting up Oracle Golden Gate one-way, two-way/Bi-directional, active-to-active, and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgrading OGG 11gR2 to 12c to 19c, configuring OGG in RAC high available environment.
*Install, upgrade, and patch all Oracle instances (12C,18C,19C); ensure proper security levels are maintained; tune; clone; and perform day-to day maintenance to ensure a high level of reliability and stability.
*Database administrator (DBA) with extensive experience designing, developing, testing, and supporting next generation database solutions in oracle enterprise, SAP, and AWS cloud server environments.
*Proficient in an assortment of technologies, Data Guard, Golden Gate, Exadata, Oracle 12c and 19c, Access, Windows, Linux, SQL server,Aix and Unix.
*DBA skills include:
*Oracle Database Administration
*SAP Basis installation, upgrades and Configuration
*Performance Tuning & Capacity Planning and Monitoring
*Oracle RAC & ASM Administration/ Installation
*SQL Server installation, upgrade and Configuration
*Data Security, Backup & Recovery (Rman and SAP brrtool)
*Data Guard setup and Standby / Failover Administration WORK EXPERIENCE
September 2021-December 2022
Sr. Solution Management Consultant
Syniti
United States
*Installation and support of client server or Web applications utilizing a SQL Server database
*Perform Data Migration from legacy systems (oracle, SAP S4HANA) into SQL Server
*Perform Data replication from open legacy systems into SQL Server.
*Implement Syniti Advance Data Migration Solutions Best Practice (ADM)
*Performed DSP upgrades for clients in SQL Server.
*Performed SAP S4HANA Server installation (1610)
*Implement Syniti Knowledge Platform (SKP) on SQL Server implement the core data quality, data migration and information governance funstionality.
*Network administration, database connectivity, or Web application "hosting" including understanding various database architectures like HANA, Oracle, SQL server
*Advanced knowledge of SQL Server architecture including but not limited to maintenance, performance tuning, and scaling
*Systems architecture design and Data Migration from various systems into SQL server.
*Syniti platform understanding including web applications, Concento, and legacy dsp methodology *Working knowledge of networks, ports, and firewalls
*Analyzes and evaluates moderate to complex data processing/manipulation systems pertaining to data migration activities
*Creates Basic Rules and Reports
*Performs data loads using both the ETL tools and any Target system load programs
*Monitors Data Loads and Data Pulls
*Creates and Maintains relevant Documentations for installations and upgrades
*Working knowledge of SAP and/or other ERP target Systems
*Working knowledge of open legacy database systems and application connectivity
*Working knowledge of Windows SQL Server Environments May 2018-March 2021
Sr. Oracle/SAP Consultant
Accenture Services LLC
Mauritius
*Build and maintain Oracle databases in new solutions, including all production, backup, and development files, creates and supports databases across internal and end-user applications, improves database integrity through quality assurance and manages change control processes
*Troubleshoot and resolve performance issues related to Oracle databases 11g, 12c.
*Enhanced users understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions, and creating users friendly training materials.
*Setup Data Guard configuration between Primary and Standby databases for clients for High Availability, Data protection, Software upgrade and Backup & Disaster Recovery.
*Served as DBA or project lead in the completion of 80% of medium to large implementation, managing projects of business requirements analysis to solution delivering and support.
*Developed and tested storage strategies and disaster-recovery for large pharmaceutical company's operational database, delivering solutions that guaranteed recovery performance and high availability
*Build strong relationships with the application development and infrastructure teams - specifically with technical team members - to develop shared vision and execution for AWS standards and management.
*Partner with the application and infrastructure teams to analyze complex environments, design and
*Communicate elegant and pragmatic architecture(s).
*Collaborate with internal teams around technical task identification along with work estimates and skills required to assist project managers with task scheduling and resource requests.Ensure technical viability of architecture design
*Provide technical leadership to the implementations team through the design, build, test, and delivery lifecycle.
*Proactive monitoring and resolution of issues of all the EBS environments.
*Creating and managing concurrent programs, request groups, responsibilities setup, and program scheduling.
*Creation of users. Registering these users in the application.
*Troubleshooting application issues, concurrent jobs/program failures
*Database Backup and restore
*Performance Tuning of EBS or BI Jobs, Database Slowness etc.
*Monitoring system stability and performance for RAC critical systems for remote clients.
*Installation and configuring of Oracle Databases in a RAC environment.
*Strong Database Management skills, including RMAN backup and recovery procedures.
*Strong experience with Oracle Enterprise Manager.
*Perform test switchover and failover operations using Data Guard between Primary and Standby systems.
*Monitoring all Oracle database systems for availability 24X7 from Development, QAS and Prod for remote clients in France.
*Perform quarterly database health checks for managed service clients.
*Performed oracle replication from oracle to other heterogonous Operating systems using Golden Gate.
*Administer the SAP database with Database Administrator (plan and perform database upgrades, apply database maintenance, design and maintain physical database layout, perform database reorganizations, design and implement backup and restore strategy, maintain database security, administer database performance, manage database storage, database problem determination and resolution, etc.).
*Strong organization and time management skills. Ability to communicate effectively (both written and oral) using clear, concise, and understandable language
*Skilled at learning new concepts quickly while working well under pressure, highly organized and dedicated with a positive attitude.
February 2016-March 2018
Sr. Oracle DBA
Tradex Corporation
Douala, Cameroon
Support various Projects and support related tasks under the guidance of DBA managers.
* Participate in functional test planning and testing for the assigned application(s), functional area(s) or Project(s)
* Participate in problem solving and troubleshooting for the assigned application(s), functional area(s) or Project(s)
* Share knowledge by effectively documenting work
* Respond quickly and effectively to production issues and taking responsibility for seeing those issues through resolution.
* Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
* Install and maintain database software.
* Manage backup and recovery of databases using RMAN and/or Network Appliance Snapshots
* Manage security of database structures and corporate data held within databases.
* Develop database procedures, triggers and SQL scripts for development teams.
* Assist in the definition and implementation of database standards.
* Review scripts submitted by the Development team to ensure that all standards are met.
* Monitor databases for errors and perform problem determination when necessary.
* Design and implement highly available production systems using the following technologies: Hot Standby/Data Guard, Advanced Replication, Oracle Golden gate, Advanced Queuing, Real Application Cluster (RAC) and Oracle Enterprise Manager
* Manage Clients OEM 13c environments.
* Automate routine DBA tasks defined by client DBA leadership. January 2009-January 2016
SAP Basis/Oracle DBA
Shulam IT Consulting Ltd
United States
*Installed, maintained, and optimized documentation of all database and applicationssecurity systems and communication links.
*Served as lead database architect in the design team.
*Identified, recommended, and prioritized new database and applications new
*Features in conjunction with business leaders and department managers.
*Increased database and Application security and cost efficiency by 10%.
*Complete database and application requirements analysis including the evaluation of
*Systems specifications, capacity planning, database growth for clients.
*Developed and communicated databases and applications usage, security policies andstandards to all users.
*Established policies and procedures for accessing databases and applications inconjunction with data retrieval.
*RAC expert, Oracle E-Business, Oracle Data Guard, Golden Gate.
*Administering Backups and Recovery Plans
*Software installation / Add-on Packages
*Responding to Monitoring Alerts
*Perform Client Copied both local and Remote from DEV,QAS and to Prod.
*User administration / Authorization
*Performance Optimization
*Troubleshooting operational issues.
April 2005-April 2009
Advance Technology Consultant
Cerner Corporation
Kansas City, Missouri, United States
*Consulting Database Administrator to Health Care Institutions advising on implementation of Cerner Millennium systems specializing in performance tuning, Database upgrades, RMAN implementations, Golden Gate, and Hardware upgrades
*Use of RMAN to backup and recover databases
*Project Management of Oracle Migrations and Hardware Migrations Oracle versions 7.3.3.4, 7.3.3.6, 8.1.7.4, 9.2.05, 10.2.0.3, 11.1.0.7, 11.2.0.4
*Installation of Oracle RAC kernel, Oracle migrations, upgrades and Cluster Ready Services
*Implementation of standby databases
*Train client dba's on RMAN and database management practices
*AIX, HP/UX, Linux, and Open VMS Operating Systems Consulting Database Administrator to Health Care Institutions advising on implementation of Cerner Millennium systems specializing in performance tuning, Database upgrades, RMAN implementations, Golden Gate, and Hardware upgrades
*Use of RMAN to backup and recover databases Project Management of Oracle Migrations and Hardware Migrations Oracle versions 7.3.3.4, 7.3.3.6, 8.1.7.4, 9.2.05, 10.2.0.3, 11.1.0.7, 11.2.0.4
*Installation of Oracle RAC kernel, Oracle migrations, upgrades and Cluster Ready Services Implementation of standby databases Train client dba's on RMAN and database management practices AIX, HP/UX, Linux, and Open VMS Operating Systems
March 2003-February 2005
Technical Lead
RC Uniforms LLC
Kansas City, Missouri, United States
AIX, HP/UX, Linux, and Open VMS Operating Systems
Train client dba's on RMAN and database management practices Implementation of standby databases
*Installation of Oracle RAC kernel, Oracle migrations, upgrades and Cluster Ready Services Oracle versions 7.3.3.4, 7.3.3.6, 8.1.7.4, 9.2.05, 10.2.0.3
*Project Management of Oracle Migrations and Hardware Migrations Use of RMAN to backup and recover databases.AIX, HP/UX, Linux, and Open VMS Operating Systems Train client dba's on RMAN and database management practices.
*Implementation of standby databases Installation of Oracle RAC kernel, Oracle migrations, upgrades and Cluster Ready Services Oracle versions 7.3.3.4, 7.3.3.6, 8.1.7.4, 9.2.05, 10.2.0.3
*Project Management of Oracle Migrations and Hardware Migrations
*Oracle Migrations and Hardware Migrations Use of RMAN to backup and recover databases April 1999-September 2003
Oracle Application DBA
UMB Bank, NA
Kansas City, Missouri, United States
*Lead DBA for millennium system. Implemented Full database development lifecycle, including design, development, deployment, integration, test, and maintenance for the millennium system. *Installed, configured, and upgraded Oracle server software and related products.
*Evaluated Oracle features and Oracle related products.
*Established and maintained sound backup and recovery policies and procedures.
*Implemented and maintained database security (creates and maintains users, roles and assign privileges to programmers).
*Performed tuning and performance monitoring for both production and development data.
*Performed growth and capacity planning of production and development databases.
*Responsible for the day-to-day monitoring, tuning and maintenance of SAP and Data Warehouse databases. February 1997-March 1999
Application / Production DBA
Sprint Telecommunication
Chevy Chase, Maryland, United States
*Responsible for the day-to-day monitoring of; six production, seven development, and nine testing databases.
*Managed users and resources by creating users, granting privileges setting the maximum number sessions users can open concurrently.
*Database migration and complete refresh of testing databases once a month.
*Applied Database Change Control Requests (Decor's) from development all the way to production.
*Do migration from the development databases to testing databases. Generate DDL Scripts for these databases using ERWIN software.
*Create tables, tablespaces, indexes, synonyms, and database links sequences, create new users and grant them different roles based on their functionality etc.
*Take logical backup of the testing databases by taking full exports three times a week. January 1995-January 1997
Junior Oracle DB Administrator
American Management System Inc
Fairfax, Virginia, United States
*Scheduled walk - through with developers regarding changes that had to be done in the database.
*Database capacity planning.
*Enhanced users understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions, and creating users friendly training materials.
*Support various Projects and support related tasks under the guidance of DBA managers.
*Participate in functional test planning and testing for the assigned application(s), functional area(s) or Project(s)
*Participate in problem solving and troubleshooting for the assigned application(s), functional area(s) or Project(s)
*Share knowledge by effectively documenting work
*Respond quickly and effectively to production issues and taking responsibility for seeing those issues through resolution.
*Resolve database performance issues, database capacity issues, replication, and other distributed data issues.
*Install and maintain database software.
*Served as DBA or project lead in the completion of 80% of medium to large implementation.
*Implemented security guidelines in production to make sure no one apart from the DBA could create objects in the database.
EDUCATION
-Current
BSc
University of District Columbia
United States
*University of District Columbia
BSc Accounting & Business Management
• Accounting & Business Management
SKILLS
Data Migration Data Retreival Data Retrieval Database Database Administration Database Administrator Database Systems DDL MS SQL Server SQL Server Oracle Oracle 10G Replication SQL WEB Database Database Development Disaster Recovery RMAN Change Control Technical Leadership ERP SAP Amazon Elastic Block Storage EBS Amazon Web Services AWS Erwin Requirements Analysis Systems Architecture Enterprise Resource Planning ETL HANA Backups Data Protection Application Development Visio Firewalls Network Administration Data Replication Data Quality AIX Linux UNIX Deployment Migrations E-Business Cerner Millennium Kernel Open VMS Data Warehouse Performance Tuning Test Planning Quality Assurance Maintenance Scheduling Self Motivated Very Organized Highly Organized Excellent Written and Verbal Communication Skills Written and Verbal Presentation Skills Operations Time Management Problem Solving Database Management Customer Service Oriented Customer Service Business Requirements Capacity Planning Business Intelligence BI Crisis Management Business Management Managing Projects Project Management Documentation Documenting OEM Governance Clients DSP Switch Capacity Telecommunication Security Policies Performance Optimization Employee Resource Group AWS Certified User Experience Design UX Accounting Retail Sales Excel Microsoft Office MS Office 2010 Microsoft Powerpoint Powerpoint CERTIFICATIONS
*DBA Workshops oracle 12c and 19c administration and New features
*AWS Certified Solutions Architect - Associate
*Certified Oracle Professional 9i
AWS Certified Solutions Architect
Certified Oracle Professional 9i
Certified Oracle Professional
*Oracle 10g New Features
Certified Oracle
LANGUAGES
English - Intermediate French - Intermediate
Contact this candidate