We provide IT Staff Augmentation Services!

Database Engineer Resume

3.00/5 (Submit Your Rating)

Charlotte, NC

SUMMARY

  • An Oracle OCP11g with experience in deploying disaster recovery solutions with standby databases in compliant to Oracle maximum availability architecture and more than 9 years of industrial experience in high end Oracle technology starting with Oracle RDBMSversion 9 up to 12C. Six years of which were experience in database administrator in development, test and production environments.
  • Experienced in Capacity Planning, Configuration, Installation, Upgrades and High Availability (HA) solutions and & Backup & Recovery, performance tuning & Cloning.
  • Oracle DBA with in - depth knowledge of DBA Fundamentals, optimization, Backup/Recovery, relational database, and PL/SQL Programming.
  • Planning, building, implementing, administering, and maintaining on High Availability (HA) Setup of Oracle Real Application Clustering (RAC) database on Oracle 11g/12c/18c RDBMS, Grid infrastructure (GI), Automatic Storage Management (ASM), Data Guard and applying patches of GI and Oracle 11g/12c/18c RDBMS software binaries on Unix/Linux environments.
  • Experience with Oracle Golden Gate 11g/12c replication setup across heterogeneous database vendors
  • Implementation of High Availability solutions with Oracle RAC, Physical and Logical Standby Databases (Data Guard) and Replication using GoldenGate.
  • Expertise in Export/Import data using ORACLE Data Pump
  • Excellent problem-solving skills strengthened by technical and business education and years working in a fast pace high energy environment.
  • Adept at multi-tasking with the ability to handle the demand of a very dynamic and high energy manufacturing environment.
  • Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
  • Has managed internal databases, from planning and testing stages through implementation, support and has involved in end to end performance tuning, High Availability and Disaster Recovery solutions.
  • In-depth understanding of diagnostics of performance issues, security, and backup procedures to ensure database integrity.
  • Possesses superior skill in communication, presentation, analytical and problem-solving skill. Work well with all levels of business.
  • Experience working with large Oracle environment.
  • Worked on ORACLE ARGUS as a comprehensive pharma covigilance platform to enable manufacturers to make faster and better safety decisions,optimize global compliance, and easily integrate risk management.
  • Experienced in multi-tier patching, cloning, system troubleshooting and database upgrade
  • Implemented Oracle Golden Gate Cloud Service (GGCS) to replicate physical server to Oracle cloud (DBaaS).
  • Experience with Materialized Views, creating DB-Links, Schema Compression, PL/SQL, and Job Schedulers.

TECHNICAL SKILLS

  • Golden Gate
  • SQL*Plus
  • Enterprise Manager (OEM)
  • SQL Loader
  • RMAN
  • AWR
  • Scheduler
  • Data Pump
  • RAC
  • Partitioning
  • Active Data Guard
  • MobaXterm
  • UNIX Shell Scripting
  • ASM
  • Data Archiving
  • SQL
  • DBCA
  • Putty
  • Unix Shell Scripting
  • DBMS SCHEDULER
  • HTML
  • MS Word
  • Excel
  • PowerPoint
  • SQL-Developer
  • Oracle Golden Gate Veridata
  • AWS
  • DBaaS

PROFESSIONAL EXPERIENCE

Database Engineer

Confidential - Charlotte, NC

RESPONSIBILITIES:

  • Managing different databases through multiple product lifecycle environments, from development to mission-critical production systems.
  • Applying data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
  • Independently analyzed, solved, and corrected issues in real time, providing problem resolution end-to-end.
  • Implementing High Availability Oracle GoldenGate OGG systems on Oracle 11gR2 RAC environments Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack.Cell-Storage, InfiniBand Switches, and ZFS Storage Appliances.
  • Providing and implementing performance tuning recommendations of all components in Exadata database machine.
  • Performing database upgrades, migrations and installation PSU/CPU and on-off patches as needed.
  • Performing reorganization database structure as needed as well as redistribution of datafiles to improve I/O performance.
  • Designing, deploying, and managing of enterprise Backup and Recovery strategies, using RMAN, Import/Export, Data Pump.
  • Proactively monitoring and tuning of database performance using AWR. Tune the various components of the database - Memory, PSU/CPU, I/O, and SQL statements.
  • Creating and managing of database objects - tables, Indexes, views, synonyms, snapshots, materialized views, stored procedures, triggers, table partitions and partitioned indexes.
  • Providing 24/7 database support to production application users as well as application developers and testers.
  • Performing database refreshes from production to test/development as well as performing change/code deployment to production accordance with enterprise change management process.
  • Working with Systems Administrator in database/application problems troubleshooting and resolution.
  • Monitoring and management of database storage and tablespace space utilization.
  • Representing DBA group in weekly change management meetings and various project meetings
  • Design, deployment, and management of enterprise Backup and Recovery strategies, using RMAN, Import/Export, Data Pump.
  • Proactively monitoring and tuning of database performance using AWR. Tune the various components of the database - Memory, PSU/CPU, I/O, and SQL statements.
  • Creating and managing of database objects - tables, Indexes, views, synonyms, snapshots, materialized views, stored procedures, triggers, table partitions and partitioned indexes.
  • Performing scheduled maintenance and support release deployment activities after hours if required.

Senior Database Administrator

Confidential - Atlanta, GA

RESPONSIBILITIES:

  • Experienced in Postgres SQL RDBMS with knowledge of installations and Configurations, Backups, Warm/Hot Standby/Streaming Replication/pgHA, pgbouncer, Stado and ora2pg.
  • Provided support for critical production systems.
  • Installed, configured Oracle 9i, 10G, 11gr2, 12c, 18c and 19c on Linux, Sun Solaris, and HP servers.
  • Performed migration of standalone databases to RAC and ASM.
  • Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using Golden Gate.
  • Designed and implemented disaster recovery for the PostgreSQL Database.
  • Implemented Golden Gate replication between SQL Server data warehouse, Oracle database and ERP.
  • Implemented Golden Gate (10.x/11.x/12.x) replication solutions to facilitate data flow between heterogeneous (SQL Server, MySQL, Exadata and Oracle) environments.
  • Monitoring, compare and verify set of data replication using Oracle Golden Gate Veridata.
  • Work with software vendors and Oracle support to ensure all database and application related issues are resolve timely and efficiently.
  • Performed tuning and optimization of Oracle applications and databases.
  • Performed AWR reports, SQL Trace, explain Plan. identify problems and implement solutions; to ensure the database is running at optimum speed and efficiency.
  • Engineered System Administration-related solutions for various project and operational needs.
  • Installed new / rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements.
  • Developed and maintained installation and configuration procedures.
  • Applied OS patches and upgrades on a regular basis and upgrade administrative tools and utilities. Configure/add new services, as necessary.
  • Scheduling jobs with DBMS SCHEDULER
  • Performed ongoing performance tuning, hardware upgrades and resource optimization as required and configure CPU, memory, and disk partitions as required.
  • Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware. schema and Percona toolkit to identify redundant and unused indexes
  • Performed daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems, and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
  • Performed daily backup operations, ensuring all required file systems and system data are successfully backed up to the appropriate media
  • Created and maintained oracle Data Guard configuration for disaster recovery and to manage planned maintenance.
  • Installed and Implemented DataGuard (Standby) for high availability/disaster recovery purpose and configured the database to Switchover and failover.
  • Generated and interpreted Automatic Workload Repository AWR, Active Session History ASH, and Automatic Database Diagnostic Monitor ADDM reports using OEM.

Database Administrator

Confidential - Atlanta GA

RESPONSIBILITIES:

  • Installed and configured new servers as per customer’s request.
  • Cloned the Development, test and UAT environments with production data as per customer’s request.
  • Designed and implemented disaster recovery for the PostgreSQL Database.
  • Installed,configured, monitor (Nagios), upgrade, andtune new and existingPostgreSQL databases.
  • Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community.
  • Configured and fixed the Issues with Pgadmin-III client application.
  • Responsible for monitoring environments using monitoring tool viz. Nagios,Check Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.
  • Performed capacity planning, design, and installation, configuration, and deployment of Oracle 11g database within the computing environment.
  • Installed and managed RAC multi-node cluster.
  • Implemented High Availability Oracle GoldenGate OGG systems on Oracle 11gR2 RAC environments Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack.Cell-Storage, InfiniBand Switches, and ZFS Storage Appliances.
  • Provided and implemented performance tuning recommendations of all components in Exadata database machine.
  • Performed database upgrades, migrations and installation PSU/CPU and on-off patches as needed.
  • Performed reorganization database structure as needed as well as redistribution of datafiles to improve I/O performance.
  • Designed, deployed, and managed enterprise Backup and Recovery strategies, using RMAN, Import/Export, Data Pump.
  • Proactively monitoring and tuning of database performance using AWR. Tune the various components of the database - Memory, PSU/CPU, I/O, and SQL statements.
  • Created and managed database objects - tables, Indexes, views, synonyms, snapshots, materialized views, stored procedures, triggers, table partitions and partitioned indexes.
  • Provided 24/7 database support to production application users as well as application developers and testers.
  • Performed database refreshes from production to test/development as well as performing change/code deployment to production accordance with enterprise change management process.
  • Worked with Systems Administrator in database/application problems troubleshooting and resolution.
  • Monitored and managed database storage and tablespace space utilization.
  • Represented DBA group in weekly change management meetings and various project meetings

Database administrator

Confidential - Atlanta GA

RESPONSIBILITIES:

  • Installed and managed of two-nodes RAC cluster on Linux.
  • Implemented physical database and database changes per logical design
  • Performed upgrades and migrated several oracle 9i databases to 10G
  • Created, procedures, functions, packages, triggers, views, tables, indexes, table partitions, Partitioned indexes, synonyms, and database links.
  • Managed database security - created users, roles, grating and revoking of privileges as required.
  • Managed database storage and database space utilizations
  • Interfaced with vendors, project implementation groups & end users.
  • Attended DBA group in weekly change management meeting, where all planned production changes are approved prior to deployment.
  • Worked knowledge with Amazon Web Services (AWS) technologies: RDS, Postgres Aurora, Cloud Formation, EC2, S3, EMR, SCT, DMS, Auto scale, and Cloud watch. Expert migrating databases to Cloud.
  • Interfaced with vendors, project implementation groups & end users for efficient service delivery.
  • Performed data loading using SQL Loader, Export/Import Data Pump.
  • Configured Golden Gate for Classic and Integrated capture components for replication
  • Working knowledge in performance analysis, tuning, to ensure optimal database performance through exhaustive pre-service testing and ongoing real-time monitoring using OEM, SQL Tuning advisor, AWR, ADDM, ASH.

Information Security Analyst/Database Administrator

Confidential - Jacksonville, FL

RESPONSIBILITIES:

  • Enforced database security by managing users’ privileges, creating logins, users, roles and granting permissions
  • Performed upgrades, patches, and database cloning
  • Hands-on experience in planning designing Oracle Backups and Recovery strategies using RMAN, export/import -logical and physical backup
  • Proficient in use of tools like Oracle Designer, SQL loader, Recovery Manager, Oracle Enterprise Manager, SQL-Developer
  • Extensive experience in DBA activities including schema/user management, space management monitoring on Oracle administration.
  • Implemented database activities like monitoring databases servers, scheduling jobs, monitoring performance issues patches implementation on Oracle database, setting up alerts, ASM Management, Data Guard implementation.
  • Tuned SQL queries on Oracle RAC databases, Implemented database with ASM and SAN storage
  • Actively participated in DBA meetings to resolve and suggest alternatives to resolve issues in the systems.
  • Identified and resolved problems occurring in all database environments including performance related issues

We'd love your feedback!