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

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.

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.

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

Oracle & Mysql DBA

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

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

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

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

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