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
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