OBJECTIVE

• To obtain a Database Administrator position in which my loyalty, experience and education will further the success of a company while providing myself an avenue of career growth.

SUMMARY

• Experience in Oracle Database Oracle 12c, 19c, Oracle 11g, Oracle 10g, Oracle9i,Oracle8i, SQL Server 6.5 - SQL Server 2008
• Experience in RDBMS - Oracle and MS SQL databases, installation, database migration, database upgrade and tuning for highest performance
• Experience in GI, RAC, ASM, Data Guard, Oracle Grid Control 12c and 13c, 11g, 10g, Exadata, RMAN, SQL Developer and Toad, Familiar with Oracle Golden Gate
• Experience in SQL Profile, SQL Access Advisor and SQL Tuning Advisor, Managing SQL Tuning Sets
• Application DBA experience supporting developers and Data Architects to develop and implement database schemas
• Hands-on administrative tasks programming experience (SQL, PL/SQL, T-SQL, Unix, Linux)

PROFESSIONAL EXPERIENCE

Confidential

Consultant

Responsibilities:

• Migrate database for prove of concept (POC) from Linux to Azure VMware Solution (AVS)
• Clone Oracle 12c Binary on AVS
• Crate Oracle 12c Database.
• Imported database using Data pump on AVS server.

Confidential

Senior DBA

Responsibilities:

• Provided DBA support for application deployment on various environments
• Made suggestion for Database performance improvement and database administration activities, created new methods to decrease deployment time
• Created and supported various Unix/SQL scripts for generating reports, managing schemas
• Migrated Oracle 11g schemas from AIX to Linux Exadata
• Migrated Oracle 11g schemas from Linux/AIX server to Linux Oracle 12c Multitenant databases Exadata server
• Used Oracle Cloud control to monitor Exadata server performance
• Migrated AIX Unix/SQL Oracle 11g scripts to Linux Oracle 11g and Oracle 12c Multitenant database servers
• Introduced new database environments after migration from AIX 11g to Linux 11g and 12c pluggable databases to other DBAs.
• Created Oracle 11g and Oracle 12c databases and configured Cloud OEM monitoring and RMAN backup on Linux Exadata Servers
• Prepared documents for 12c and 11g database migration and application schema deployment and refresh steps on Oracle Exadata servers
• Proactively monitored sql performance, provide suggestion, such as creating indexes, changing database parameters, statistics gathering to improve performance, advised developers sql/plsql code changes to improve performance.
• Advised on implementation of automatic status gathering instead of custom scheduled stats gathering method.

Confidential

Consultant

Responsibilities:

• Advised on datawarehouse segment management, developed procedures to increase index performance and reduce space usage, developed SQL procedure for table and partition maintenance to optimize space and increase overall database performance.
• Developed statistics gathering method for a datawarehouse database
• Created PL/SQL procedures for implementing statistics gathering for datawarehouse database
• Created Oracle Enterprise manager 12c Security configuration, advised on architecting on Oracle 12c Enterprise Manager
• Monitored and analyzed database performance as required, mainly on the datawarehouse database
• Developed several documents for DBAs, such as how to use SQL profile, how to create database services, monitoring active database user sessions.
• Migrated MS Access Schema to Oracle 10g database

Confidential

Consultant

Responsibilities:

• Upgraded many production and development databases from Oracle 10g to Oracle 11g
• Developed upgrade and migration procedures for Oracle databases
• Extensively utilized oracle Grid/Cloud Control for database upgrade and migration
• Developed SQL Plus and Unix scripts to optimize database upgrade and migration processes
• Supported Golden Gate replication form production to other environments testing and reporting databases
• In addition to database upgrade made suggestions on various database practices to save cost and time, and to simplify database maintenance
• Experiment with oracle Data Guard for Standby database creation with various scenarios

Confidential

Responsibilities:

• Provided DBA support on Oracle8i, Oracle9i, Oracle 10g, Oracle 11g and SQL Server databases on Unix and Windows servers.
• As Prime DBA, Managed Oracle 11g, Oracle 10g, Oracle9i, Oracle8i, SQL Server 2000 databases
• Participated in creating enterprise Database standards
• Installed Oracle and SQL Server databases on Unix, Linux and Windows servers and applied patches as required
• Created Oracle and SQL Server Databases
• Provided 24/7 on call DBA support at enterprise level
• Proactively monitored sql performance provide suggestion, such as creating indexes, creating sql profile, changing database parameters to improve performance, advised developers sql/plsql code changes to improve performance.
• Used Oracle 10g and Oracle 11g Grid Control to manage Oracle databases
• Prepared and used Unix, Linux, SQL, PL/SQL, Transact SQL scripts to manage databases and schemas
• Installed in house backup and monitoring scripts
• Managed backup and monitoring configurations
• Participated in database upgrade projects, upgrade databases, migrate schemas
• Participated in data conversion projects, cloned databases, export/import databases and schemas
• Prepared data compression procedure and scripts to address space issue on 8 terabyte Oracle 9i database which reduce space by more than 40 %
• Created and managed oracle 10g Data Guard Standby Databases
• Used 10g and 11g Grid Control to address performance issues, implemented User defined metrics, created alerts
• Implemented SQL profiles
• Advised development team to optimize SQL statements for optimal performance
• Managed schemas as prime for Operational Data Store (ODS) applications and reporting databases
• Participated in Database and schemas capacity planning
• Participated in schema design and deployment. Worked closely with Data Architects and Developers on various projects to rollout schema changes
• Participated in Physical Data model Design
• Created new schemas and implemented new DDL with Oracle best practices
• Upgraded existing schemas
• Implemented automatic partition maintenance using in house scripts
• Provided support with application performance tuning, advice on schema design for high performance.
• Created and managed application and user accounts

Confidential

Oracle 8i Database Administrator

Responsibilities:

• Supported multiple instances of Oracle 8i Databases on Sun Solaris OS. Set up and managed database backups and user accounts. Utilized Oracle Enterprise Manager and OS tools to monitor database storage utilization and performance optimization. Provided support for development team by running analysis on tables and indexes and assisting with performance and SQL problems.
• SQL Server 2000 and SQL Server 6.5 Database Administrator
• Administered SQL Server databases with more than 150 instances. Created schemas for customers and manage user accounts. Implemented backup and restore strategies for SQL server 2000/6.5. Recovered several databases and performed Import/Export based on user requests. Configured database alerts, SQL Mail and various tasks. Assisted technical support team and customers on SQL Server Database issues. Resolved performance issues using SQL Profiler and stored procedures. Implemented SQL Server 2000, 6.5 Service packs and patches. Actively involved and compiled data dictionary for billing database.

Confidential

Instructor

Responsibilities:

• Oracle8i Instructor - Day class
• Oracle8i Instructor - Evening class
• Planned and delivered Oracle Certified Professional (OCP) - DBA courses: Introduction to Relational Database, Oracle SQL and PL/SQL, Oracle8i Database Administration, Backup and Recovery, Performance Tuning, and Network Administration.