Ana Lima Email & Phone Number

Orlando, Fl, Us

Lake Mary, Fl

Orlando, Florida Area

• Executed overall database administration and system tasks, support and maintenance for Oracle and SQL Server databases such as: Install, Creation, Support, Upgrade, Patching, Migration, Cloning, Backups, Monitoring, Restore and Recovery implementing industry best practices.• Maintain under support Oracle Databases by applying PSU patching and executing Upgrades following Application requirements.• Troubleshoot performance issues with the databases.• Developed and Implemented Oracle backup strategy for NARS using RMAN with Oracle Cloud Backup.• Undertook Tuning / Optimizing, database Re-Organization on Oracle Production databases using SQL Scripts as well as Enterprise Manager.• Formulated policies, procedures, and standards relating to database management and monitors transaction activity and utilization• Produced and maintained technical and user documentation.• Executed a Security Audit to remove unnecessary escalated permissions in production instances.• Ensured standardization of systems implementation, support techniques, and adherence to formal processes, change control, best practices, and total quality practices in all activities.• Actioned incident and problem management activities, escalating issues to external technical support parties when required ensuring no SLA breach.• Supported team members with data analytical and other application support activities.• Handle different IT projectsKey Achievements• Improved Oracle recovery by creating a Backup Strategy over the Cloud.

Sydney, Australia

• After QBE acquired CUNA Mutual Group in 2011, I continued my career as a Database Administrator at QBE.• Provided overall database administration and system tasks, support and maintenance for Oracle and SQL Server databases.• Migrated and upgraded SQL Server database environment from CUNA domain to QBE.• Undertook tuning / optimizing, database re-organization, backups/restore/recovery processes, UAT and DEV environment refresh.• Executed periodic database maintenance and systems support in both Oracle and SQL server environments.• ORACLE and SQL Server database design, system analysis and architecture design.• Actioned incident and problem management activities, escalating issues to external technical support parties when required using Remedy as an incident management tool.• Provided auditing reports during audit time for both Oracle and SQL Server databases.• Participated in 24 X 7 "On-call" support rotation for SQL Server and Oracle database systems.• Supplied database statistics and related data on a timely basis.• Supported team members with data analytical and other application support activities.• Managed operational tasks such as provided technical support for interface files and FTP processes, and supported for end of month (EOM) activities.• Produced and maintained technical and user documentation.• Executed performance monitoring and tunning using Foglight and Spotlight tools.• Created change request using Remedy to manage, control and follow up production environment changes.• Ensured standardization of systems implementation, support techniques, and adherence to formal processes, change control, best practices, and total quality practices in all activities.

Sydney, Australia

“CUNA Mutual Group is a leading global financial insurance provider that specializes in serving cooperative groups”• Provided overall database administration and system tasks, support and maintenance.• Undertook Tuning / Optimizing, Database Re-Organization, Backups/ Restore/ Recovery Processes, Database De-Fragmentation and others.• Executed periodic database maintenance and systems support in both Oracle and SQL server environments.• Executed Incident and Problem Management activities, escalating issues to external technical support parties when required.• Supplied database statistics and related data on a timely basis.• Supported team members with data analytical and other application support activities.• Managed operational tasks such as provided technical support for interface files and FTP processes, and supported for end of month (EOM) activities.Key Achievements• Successfully executed capacity planning, architecture design, migration and upgrade to create SSRS & SSIS environment as well as SQL Server database server for application databases using SQL Server 2008 on Windows 2008 R2.• Awarded as quarterly employee.

Caracas Area, Venezuela

- Install and test DB2 for the customer.- Execute test of Information Server DataStage components - Server and Client GUI. This task involves:- Contribute to the Business Unit Success and client satisfaction doing the correct follow-up to critical situation with product failure is problem source. - Successfully practice the most efficient methods of proving solutions to clients/partners.- Actively advising the sales team, IBM Management, and customers on the appropriate use of demos, Proof of Technology, Proof of Concept, Services, etc.

Venezuela

- Diagnose and perform improvements in the databases environments of customers and execute projects according to their requirements. - Give support to customers regarding the pertinent changes to be made on their productive environments, this is, to suggest any upgrade, migrations to/from Versions, backups, tuning, patching databases. Many customers need to upgrade a database from the old Oracle version or need to migrate data from one environment to the other.- Execute projects for the implementation of political backups and recovery using Oracle's tools as RMAN and Data Guard. - Execute installation and configuration projects using Oracle RAC 9i for the customers who requested them and transferred knowledge to them for the appropriate administration of the productive environment.

- Manage the resources assigned to the database division, these resources included, hardware, software and human resources. - Project Leader for all the projects related to the Business Intelligence and CRM divisions of Digitel.- Monitor and administrate all the database environments installed, the database server was ORACLE 8.1.7.3.4 and the data costumer application was Siebel. Other database environments were the relational database and the multidimensional DWH. - Support the functional manager in developing related tasks as well as provided assistance in any reporting duties. - Administration the ETL architecture, allowing all data replications, snapshots, jobs and cron. - Performance database upgrades and migrations on all database environments. - Tools used included: Toad Quest, Unix HP UX 11i, Oracle 8.1.7.3.4, Metalink, Oracle Resources and QCO Quest.

Magister, Systems

Engineer, Informatics

Bachelor Of Science (Bs)