We provide IT Staff Augmentation Services!

Database Analyst Resume

4.00/5 (Submit Your Rating)

SUMMARY:

  • More than 15 years experience as a Database Administrator working with Oracle, MySql and DB2 and NoSQL .
  • Able to work on own initiative and as part of a team.
  • Good analytical, design and problem solving skills.
  • Have Amazon AWS RDS and EC2.Knowledge of data analytics tools like DataTables, Big Data, Hadoop and Oracle Data Miner

TECHNICAL SKILLS:

  • Hands On experience with Migration 9i to 10g and 10g to 11g
  • Creation and implementation backup and recovery solutions using RMAN
  • Good Knowledge of RMAN and EM Grid Control

EMPLOYMENT HISTORY:

Confidential

Database Analyst

  • Design of relational database structures
  • Mysql and Oracle Migration from local DC to Amazon AWS
  • Migration from Oracle 11g to Mysql 5.6 on Amazon RDS
  • Migration from Local Oracle 11g to Amazon RDS
  • AWS EC2 migration To RDS.
  • Troubleshooting,optimizing,and tuning Sql
  • Mysql Clustering and Replication configuration on Amazon RDS
  • Experience in Performance Tuning and Query Optimization.
  • Performs the capacity planning required to create and maintain the databases.
  • Working closely with system administration staffs for the system environment requirements.
  • Give consultation to development teams
  • Implement and maintain backup and recovery policies and procedures
  • SqlServer 2012 Modeling and Fisical implementation on AWS RDS
  • SqlServer 2012 Audit Configuration
  • MongoDb install and Configuration
Confidential

Oracle and Mysql DBA

  • Working with functional teams clarify ETL requirements and business rules
  • PL/SQL scripting; SQL Code performance tuning
  • Data Migration Process Support using PowerCenter
  • ETL With Informatica PowerCenter
  • Installing, upgrading and patching Oracle 11g and Mysql 5.6
  • Migration Databases from Local to Remote Datacenter
  • Creation and implementation backup and recovery solutions using RMAN
  • Mysql Differential and Transaction Log backups
  • EM Grid Control 11g and 12c implementation
  • Security management and general support for the development teams
  • MongoDB Installation And Configuration for POC
  • Documentation, creation of Checklists and follow - up validations
  • Troubleshooting, optimizing, and tuning sql and PLSQL
  • Mysql Clustering and Replication configuration on RDS AWS
  • AWS Cloud services experience with Ec2 and RDS.
Confidential

Oracle and Mysql DBA

  • Work with mission critical databases Velocity cc Data Center in Georgia
  • Installing, upgrading and patching Oracle 11g and Sql server
  • Creation and implementation backup and recovery solutions using RMAN
  • EM Grid Control 11g and 12c implementation
  • Lawson ERP Data Refresh
  • Database Clone
  • Oracle 11G RAC implementation and support
  • Design of relational database structures
  • Experience working with Oracle Support Services to resolve issues
  • SQL tuning and PL/SQL debugging
  • Mysql 5.5 and 5.6 management and administration
  • Backups and restores, managing job schedules and correcting failures,
  • Mysqlinstallations and updates
  • Security management and general support for the development teams
  • Tsql and PLSQL Tuning for performance
  • AWS Cloud services experience like Ec2 and RDS.
Confidential

Oracle Apps DBA

  • Technical Management of Oracle´s ERP and CRM outsourcing contract
  • RFCs Technical Approval and Review
  • Manage and Creation of Concurrent Manage Users and Roles
  • User Validation and Objects creation
  • Manage and validation of Reorg Plan With Oracle
  • Installing, Mysql/MongoDB, Backup Plan creation
  • Sqlserver objects Creation and administration
  • Daily activity checklists and the maintenance on Oracle and Mysql databases
  • Security/Compliance projects implementing Oracle TDE on Tables with credicards numbers
Confidential

Oracle & Mysql DBA

  • Mysql Objects Creation and administration
  • Installing Mysql using RPM command
  • Tuning queries using Explain plan
Confidential

Oracle Dba

  • Standby Database Creation and Administration on Oracle Data Guard 11G
  • Oracle RAC 11gR2 Grid Infrastructure Installation on HP-UX 11.31
  • Creation and implementation backup and recovery solutions using RMAN
  • EM Grid Control 11g Agent communication troubleshooting
  • Installing, upgrading and patching Oracle 10g and 11g
  • Hands On experience with Migration 10g and to 11g
  • Creation and implementation backup and recovery solutions using RMAN
  • Patch set and Cpu (Critical Patch Update) apply
  • Standby database Creation and Administration using Data Guard
  • Database Clone Oracle 10G RAC implementation and support
Confidential, Remote

Oracle DBA

  • Work Base on SLA
  • Work with mission critical databases on a highly active production environment
  • Work with all kinds of Database Problems and Requests
  • Installing, upgrading and patching Oracle 9i and 10g and 11g
  • Hands On experience with Migration 9i to 10g and 10g to 11g
  • Creation and implementation backup and recovery solutions using RMAN
  • Good Knowledge of RMAN and EM Grid Control
  • Working knowledge of Microsoft operating systems and UNIX
  • Daily activity checklists and the maintenance
  • Experience with SQL Plus scripting; PL/SQL scripting; SQL Code performance tuning
  • Patch set and Cpu (Critical Patch Update) apply
  • Standby database Creation and Administration on Oracle SE and EE using Data Guard
  • Database Clone
  • Oracle 10G RAC implementation and support
Confidential

Database Administrator

  • Installing, upgrading and patching Oracle 9i and 10g and MS-SQL 2005
  • Hands On experience with Migration 9i to 10g
  • Creation and implementation backup and recovery solutions using RMAN
  • Good Knowledge of RMAN and EM Grid Control
  • Working knowledge of Microsoft operating systems and UNIX
  • Daily activity checklists and the maintenance
  • Experience with SQL Plus scripting; PL/SQL scripting; SQL Code performance tuning
  • Patch set and Cpu (Critical Patch Update) apply
  • Standby database Creation and Administration on Oracle SE and EE using Data Guard
  • Database Clone
  • SAP Basis Knowledge, BrTools, Sapdba
  • MSSQL Clustering configuration and Maintenance.
  • Homogeneus system Copy
  • Experience with SAP Migration from 4.6 to 6.0
  • MS-SQL 2005, export import tables
  • Tsql and PLSQL Tuning for performance
  • Sqlserver objects Creation and Administration, Backup Maintenance
  • Daily activity checklists and the maintenance on Oracle and MSSQL databases
Confidential

Systems Analyst (DBA)

  • Creation and implementation Oracle and Sqlserver backup and recovery solutions
  • System administration Support for MICROSIGA ERP
  • Responsible for develop procedures, triggers, functions, Packages using Pl/sql,
  • Develop the interface between the Shop floor system and the ERP
  • Developers Support
  • Standby database Creation and Administration,
  • Creation and implementation backup and recovery solutions
  • Creation of DTS Packages, Data export and import, Store procedures on Sqlserver 2000
  • Daily activity checklists and the maintenance on Oracle and MSSQL databases

Confidential

Systems Analyst ( DBA )

  • Creation of DTS Packages, Data export and import, Store procedures on Sqlserver 2000
  • Data Migration from Shop Floor systems DFC( DB2 ) to SFDM ( Oracle )
  • Providing Forms and Reports Developing 6i & 9i for ( OM, INV, AR, AP, RA, WIP, PO )
  • Responsible for develop procedures, triggers, functions, Packages using Pl/sql,
  • Provide secondary support for legacy systems and general duties including space & user management, backup & recovery procedures ( DB2, Oracle, MSSQL )
  • Set-up of backup and recovery procedures, test and implementation
  • Production & Development support of 8 Oracle databases running on Windows NT4 and Solaris.
  • General DBA duties including user, space and schema management.
  • Alert file, Archives, Locks, Performance, Disk Space, Dblinks, Db Clone, Growing Report

We'd love your feedback!