Smaila Allan

PROFESSIONAL SUMMARY

An Oracle MySQL Database Administrator Professional with extensive experience as Oracle and MySQL Database Administrator. Worked extensively on Oracle 11g and 10g 12c 19c versions involving database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.

Performed backup & recovery of large databases and provided 24X7 production support to high critical databases.

Provided root cause analysis and permanent fix of production problems.

Installation, administration, and maintenance of Oracle 11g & 12c RAC.

Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space. Performed SAN analysis and provided recommendations.

Knowledgeable in using Grid Control and OEM Features.

Worked extensively on Oracle Installation, Oracle Version Upgrades, Migrations (from 10g to 19c) and patching.

Developed RMAN scripts for database backup and recovery including- hot and cold backup.

Performance tuning of the database – in SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.

Team player with excellent interpersonal, analytical and communications skills.

Wrote scripts to inform the DBA’s regarding the status, performance, and space management of the database.

Participated in planning and implementation of off-site Disaster-Recovery planning and testing.

Worked with development and operations staff in resolving problems quickly and efficiently.

Monitored and managed various database components (logical & physical) like table- spaces, segments.

Involved in performance tuning and database reorganizations. Worked on Disaster Recovery and Implementation.

Extensively used Database Administrative tools like Oracle Enterprise Manager, DBA Studio, SQL*PLUS, TOAD.

Monitoring VLDB (Very Large Databases) using Grid Control and working offshore while monitoring.

Handled operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc.

Plan and monitor the AWS Cloud Infrastructure

Build and configure the production systems.

Manage updating process of the server-based technologies.

Coordinate with the architecture teams to design new software technologies for clients.

Test and implement constant updates while recommending the engineers about improvement opportunities.

TECHNICAL SKILLS

Operating Systems: Oracle Enterprise Linux 5.x, Red Hat Linux RHEL 5.x

RDBMS: Oracle 11g/10g/12C

Languages: SQL, PL/SQL, UNIX Shell Scripting, bash Scripting

Software/ Applications/ Tools: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, TOAD, Data Pump, SRVCTL, SQL*Plus

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Plan and monitor the AWS Cloud Infrastructure

Microsoft Azure SQL Admin Exadata DB Administration

Sybase DB Administration SQL Server DB Administration

Oracle Database Administration Energy Supply & Trading

Project Invoicing Project Management

MySQL DB Administration MS Project Server

Microsoft Azure

Cisco Meta cloud

Libode

Build and configure the production systems.

Manage updating process of the server-based technologies.

Coordinate with the architecture teams to design new software technologies for clients.

Test and implement constant updates while recommending the engineers about improvement opportunities.

EDUCATION

Master’s in health care management, Southern New Hampshire university

Bachelors in computer science, IMO state University (IMSU)

OCA Certified

PROJECT HISTORY

Boston Globe Media Group Nov-2021 Jan 2023

Database Engineer

Worked on a 24x7 basis as a production support DBA on a primary/ secondary pager rotation; and supported on holidays, weekends, beyond regular working hours and night shifts.

Installed, configured, and maintained Oracle 19c 12C, 10g and 11g R2 on Linux and Upgraded from Oracle 10g to 11g.

•Installing, configuring and upgrading the MySQL database software and related tools.

Monitoring database and server performance to ensure KPIs and SLAs are being met.

Managing and monitoring security and access controls to the database.

Troubleshooting and resolving any issues related to the database such as data corruption, replication issues, performance bottlenecks and security breaches.

Managing and monitoring database backups and disaster recovery procedures.

Collaborating with development and architect teams to design and implement new database structures, management, or automation capabilities.

Work closely with the App Ops and Architect teams to provide support for any ongoing projects/releases.

Participation in an On-Call rotation, and timely response to any critical incidents.

Find the best set of applications for the company.

Manage access to software applications to ensure security.

Monitor how often employees use SaaS applications.

Onboard and offload employees to the proper applications

Develop processes for approving the use of a new SaaS application.

Develop and adhere to an IT budget.

Automate the administration of a company's SaaS applications.

Teach employees how to use the software applications.

Establish a system of record to maintain organization.

Optimize the SaaS budget by identifying which software is most valuable to the company.

Develop a process to protect company data and information.

Creating Cloned Database using RMAN on remote Server.

Restructured the File system where we had to migrate the Data files from one File system.

File systems as per Oracle standard in Production.

Setup configured and maintained Oracle data guard, Oracle Golden gate ensure disaster recovery, high availability and data protection.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.

Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.

Performed SAN analysis to determine how long the SAN sustains in all Production environments. Responsible for maintaining and developing Oracle 11g databases, Oracle forms, shell scripts on Sun Solaris 11 server’s support.

Worked on a 24x7 basis as a production support DBA on a primary/ secondary pager rotation; and supported on holidays, weekends, beyond regular working hours and night shifts.

Installed, configured, and maintained Oracle 19c 12C, 10g and 11g R2 on Linux and Upgraded from Oracle 10g to 11g.

Successfully installed Oracle Real Application Cluster (RAC) including Grid infrastructure (Cluster ware and ASM). And Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle 12c and 19c.Strong performance tuning skills with 12c, 18c & 19c RAC environments. Experience in designing and configuring high-availability systems using Data Guard with physical standby effectively configured and used Data Guard Broker utility. Responsible for Maintenance, upgrading, migrating and supporting of multi-terabyte databases in production, test and development environments. (Linux, Red hat). Installing, deploying, and upgrading production and non-production databases. Testing new RDBMS features for later integration into infrastructure and applications using RAT. Patch 12c, 18c and 19c oracle databases using BladeLogic. Use Delphi, rman, data pump to refresh database for the development team. Configured Oracle Golden Gate for bi-directional replication and migrated databases with ZERO downtime. Participated in implementation and maintenance of Golden Gate replication and troubleshooting the GG abends. Extensive troubleshooting of typical Oracle Golden gate technical issues: such as differences in the rows count from source to target, column mismatch errors, unique key violation by using ggsci / log dump/discard file & ggserr.log analysis. Replicated tables using single extract/pump/replicate process, performed many to one replication. Recommending system hardware and software configurations for given data processing loads. Analysing storage options, recommends storage hardware and configuration for optimal DB performance. Production support and work closely with development and application support teams so that we build reliable, scalable and compliant RDBMS environments for our customers. Participating in weekly DBA on-call rotation, supporting production environment. Providing support to developers working on SQL, including development of best practices, hands on demos, and knowledge transfer. Ability to self-initiate, prioritize and execute effectively in a dynamic work environment with multiple concurrent demands. As part of the GDBA Support team we provided L2/L3 level support to the application teams during high-risk issues (escalations) and within normal activities like code migration, Database recovery via RMAN, troubleshoot performance issues, export and import of tables/schemas among environments. Oracle Database Administration. Performance Tuning & Capacity Monitoring. Data Security, Backup & Recovery. Database migration to cloud. Migration to Exadata machine. Support MS SQL server databases. Database Replay for performance testing. Oracle RAC & ASM Administration/Installation. SQL Tuning in an Oracle Environment. Production support DBA. Install and monitor OEM 12c and 13c. Configuration and troubleshooting of golden gate. Data guard configuration. Support PostgreSQL databases. Oracle PL/SQL Data masking and data redaction

Extensive experience in RMAN recovery testing, RAC and stand-alone databases.

Refreshed the testing environment from production environment for testing purposes.

Creating Cloned Database using RMAN on remote Server.

Restructured the File system where we had to migrate the Data files from one File system to many.

File systems as per Oracle standard in Production.

Setup configured and maintained Oracle data guard, Oracle Golden gate ensure disaster recovery, high availability and data protection.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.

Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.

Performed SAN analysis to determine how long the SAN sustains in all Production environments. Responsible for maintaining and developing Oracle 11g databases, Oracle forms, shell scripts on Sun Solaris 11 servers’ support.

ECOG-ACRIN, Boston MA DEC 2019 –till Nov 2021

Database Engineer

Worked on a 24x7 basis as a production support DBA on a primary/ secondary pager rotation; and supported on holidays, weekends, beyond regular working hours and night shifts.

Installed, configured, and maintained Oracle 19c 12C, 10g and 11g R2 on Linux and Upgraded from Oracle 10g to 11g.

Successfully installed Oracle Real Application Cluster (RAC) including Grid infrastructure (Cluster ware and ASM). And Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle 12c and 19c.Strong performance tuning skills with 12c, 18c & 19c RAC environments. Experience in designing and configuring high-availability systems using Data Guard with physical standby effectively configured and used Data Guard Broker utility. Responsible for Maintenance, upgrading, migrating and supporting of multi-terabyte databases in production, test and development environments. (Linux, Red hat). Installing, deploying, and upgrading production and non-production databases. Testing new RDBMS features for later integration into infrastructure and applications using RAT. Patch 12c, 18c and 19c oracle databases using BladeLogic. Use Delphi, rman, data pump to refresh database for the development team. Configured Oracle Golden Gate for bi-directional replication and migrated databases with ZERO downtime. Participated in implementation and maintenance of Golden Gate replication and troubleshooting the GG abends. Extensive troubleshooting of typical Oracle Golden gate technical issues: such as differences in the rows count from source to target, column mismatch errors, unique key violation by using ggsci / log dump/discard file & ggserr.log analysis. Replicated tables using single extract/pump/replicate process, performed many to one replication. Recommending system hardware and software configurations for given data processing loads. Analysing storage options, recommends storage hardware and configuration for optimal DB performance. Production support and work closely with development and application support teams so that we build reliable, scalable and compliant RDBMS environments for our customers. Participating in weekly DBA on-call rotation, supporting production environment. Providing support to developers working on SQL, including development of best practices, hands on demos, and knowledge transfer. Ability to self-initiate, prioritize and execute effectively in a dynamic work environment with multiple concurrent demands. As part of the GDBA Support team we provided L2/L3 level support to the application teams during high-risk issues (escalations) and within normal activities like code migration, Database recovery via RMAN, troubleshoot performance issues, export and import of tables/schemas among environments. Oracle Database Administration. Performance Tuning & Capacity Monitoring. Data Security, Backup & Recovery. Database migration to cloud. Migration to Exadata machine. Support MS SQL server databases. Database Replay for performance testing. Oracle RAC & ASM Administration/Installation. SQL Tuning in an Oracle Environment. Production support DBA. Install and monitor OEM 12c and 13c. Configuration and troubleshooting of golden gate. Data guard configuration. Support PostgreSQL databases. Oracle PL/SQL Data masking and data redaction

Plan and monitor the AWS Cloud Infrastructure

Build and configure the production systems.

Manage updating process of the server-based technologies.

Coordinate with the architecture teams to design new software technologies for clients.

Test and implement constant updates while recommending the engineers about improvement opportunities.

Plan and monitor the AWS Cloud Infrastructure

Build and configure the production systems.

Manage updating process of the server-based technologies.

Coordinate with the architecture teams to design new software technologies for clients.

Test and implement constant updates while recommending the engineers about improvement opportunities.

Extensive experience in RMAN recovery testing, RAC and stand-alone databases.

Refreshed the testing environment from production environment for testing purposes.

Creating Cloned Database using RMAN on remote Server.

Restructured the File system where we had to migrate the Data files from one File system to many.

File systems as per Oracle standard in Production.

Setup configured and maintained Oracle data guard, Oracle Golden gate ensure disaster recovery, high availability and data protection.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.

Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.

Performed SAN analysis to determine how long the SAN sustains in all Production environments. Responsible for maintaining and developing Oracle 11g databases, Oracle forms, shell scripts on Sun Solaris 11 servers’ support.

Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.

Supported 6 applications at the same time and coordinated application team for any changes.

Proficient in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNI with X Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler).

Installed the Oracle software using silent feature and created databases.

Managed database growth and performance with database reorgs

Assisted developers in database and application tuning for optimal performance.

Loaded and refreshed non-production databases for application testing.

Provided 24/7 on call support for production databases on a rotation basis.

Supported & maintained the Production/Development databases on various servers.

Extensively worked on setting up auditing in many databases we supported.

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Experience in creating automation tools for managing relational databases (auditing, account management, backup/restore, and schema deployment).

Experience working within databases such as PostgreSQL, MySQL, and Oracle.

Experience in assisting and mentoring junior DBA staffs.

Track record of engineering performance and availability solutions.

Knowledge and experience in NoSQL solutions.

Strong knowledge of AWS technologies.

6+ years of experience supporting MySQL/PostgreSQL.

Environment: Windows, RHEL, Oracle 10g, 11g and 12C, Oracle RAC 11g, Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SHELL SCRIPTING, SQL*Plus.

BAE System Information Technology, Boston MA JUNE 2014 –till date 2019

Oracle DBA

Worked on a 24x7 basis as a production support DBA on a primary/ secondary pager rotation; and supported on holidays, weekends, beyond regular working hours and night shifts.

Installed, configured, and maintained Oracle 12C, 10g and 11g R2 on Linux and Upgraded from Oracle 10g to 11g.

Extensive experience in RMAN recovery testing, RAC and stand-alone databases.

Refreshed the testing environment from production environment for testing purposes.

Creating Cloned Database using RMAN on remote Server.

Restructured the File system where we had to migrate the Data files from one File system to many.

File systems as per Oracle standard in Production.

Setup configured and maintained Oracle data guard, Oracle Golden gate ensure disaster recovery, high availability and data protection.

Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.

Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.

Performed SAN analysis to determine how long the SAN sustains in all Production environments. Responsible for maintaining and developing Oracle 11g databases, Oracle forms, shell scripts on Sun Solaris 11 servers’ support.

Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.

Supported 6 applications at the same time and coordinated application team for any changes.

Proficient in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNI with X Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler).

Installed the Oracle software using silent feature and created databases.

Managed database growth and performance with database reorgs

Assisted developers in database and application tuning for optimal performance.

Loaded and refreshed non-production databases for application testing.

Provided 24/7 on call support for production databases on a rotation basis.

Supported & maintained the Production/Development databases on various servers.

Extensively worked on setting up auditing in many databases we supported.

Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.

Experience in creating automation tools for managing relational databases (auditing, account management, backup/restore, and schema deployment).

Experience working within databases such as PostgreSQL, MySQL and Oracle.

Experience in assisting and mentoring junior DBA staffs.

Track record of engineering performance and availability solutions.

Knowledge and experience in NoSQL solutions.

Strong knowledge of AWS technologies.

2+ years of experience supporting MySQL/PostgreSQL.

Environment: Windows, RHEL, Oracle 10g, 11g and 12C, Oracle RAC 11g, Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SHELL SCRIPTING, SQL*Plus.

Hertz, San Francisco, CA JANUARY 2013 – APRIL 2014

Oracle DBA

Provided technical support for Oracle Server to customers for Production Database

Supported customers including international customer to install the developed application on different operating system e.g. windows, UNIX flavours on Oracle Database (10g,11g)

Planning, installation, configuration, management and troubleshooting of Oracle 10g and 11g databases on Linux and Windows OS

Performed Oracle database Upgrade and Migration from Oracle to 10g to 11g.

Installation and management of Oracle database using Grid and database control.

Installation and application of several Oracle critical patches to various database versions

Monitor, optimize and allocate physical data storage for database systems.

Developed, implemented and maintained an Enterprise Oracle backup, recovery and disaster recovery strategy.

Implemented the use of Oracle Recovery Manager (RMAN) to back up the databases.

Performed import and export as needed and scheduled nightly export on each database.

Perform various RMAN cold and hot backups.

Troubleshoot and resolve various Oracle problems such as connectivity problems, backup and performance issues.

Perform maintenance and related preventative maintenance on databases.

Providing Oracle network troubleshooting, technical and administrative duties

Resolve complex database issues.

Applied security features to 10g and 11g databases.

Perform bulk load into the database using SQL Loader

Tune the database and applications for faster and better performance; also, performing goal-oriented tuning as necessary.

Experience and managed Oracle database partitioning (Range, List Hash and Composite)

Perform fine grain database auditing.

Schedule jobs using various Oracle tools such as Oracle OEM, DBMS JOBS and SCHEDULER

Maintained stored procedures, functions, triggers, packages and views used by the database instance.

Documented database structure, changes, problems, issues for future reference

Develop and enforce database related policies, standards, naming conventions, operating procedures and best practices.

Develop a strategic plan for the database development that supports the organization's operational requirements.

Administer database user accounts. Create, modify and deactivate user accounts; assign and monitor user access rights.

Knowledge and understanding of Real Application Cluster (RAC) and Data guard.

Environment: Solaris, Red Hat Linux, Windows 2000/2003, Oracle 10g, Oracle Enterprise Manager (OEM), SQL*Plus, PL/SQL, SQL*Loader, Shell Scripting, Toad

Trover Solutions. Louisville KY JULY 2012 – January 2013

Junior Oracle DBA

Responsible for administering and supporting production and development Oracle 11g databases.

Responsible for installing, upgrading and configuring the Oracle server, creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Designed backup and recovery procedures for OLTP system.

Partitioned large tables to increase the performance. Configured scripts to monitor activity with database.

Responsible for optimizing the queries and application tuning.

Implement Hot, Cold and Logical backup plans.

Environment: Windows 2003, Oracle 10g/11g, TOAD, Database Tools/Utilities

Contact this candidate