SUMMARY:

Talented Oracle DBA with over 20 years of experience in IT, leading teams of up to 20 seeks to improve the accuracy and efficiency of complex systems and applications.

TECHNICAL EXPERTISE:

Operating Systems: Redhat Linux, HP - UX, Solaris, Windows Server 2003,Windows Server 2008

Languages: Basic, C, HTML, Perl, SQL-RDBMS, Java, SQL/ PL/SQL

Databases: Oracle 8i, 9i, 10g, 11g,12c, MYSQL, SQL server, Sybase,, Informix

Software: Oracle Enterprise Manager, Oracle 12c Cloud Control, RMAN, RAC, Oracle Grid Control, Oracle database console, ASM, Dataguard, Microsoft Office, Microsoft Access, Siebel, Brio, PVCS Tracker, Winrunner, Loadrunner, TestDirector, Quicktest Pro, TOAD, Powerdesigner

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Analyst

Responsibilities:

• Installed and configured 12.2, 11.2g RAC on Linux 6.
• Implemented restore and recovery stratagies(using rman) in live disaster recovery production environment.
• Setup and monitor Oracle DataGuard database technology.
• Perform database administration (10g, 11g, 12c) and maintenance functions in support of the database system within Testing, development and production environments.
• Installed and configured Oracle 12c Cloud control on Linux 6.
• Responsible for SQL Server 8, 12, 16 database administration
• Perform preventive database management, maintenance, and performance monitoring, tuning, and optimization
• Tune indexing, rollback, and initialization parameters
• Provide database administration tasks to include product upgrades and patch application.
• Experience performing tasks with Standard database tools such as but not limited to T.O.A.D and Oracle Enterprise Manager.
• Perform code migration, database changes, data and menus through the various stages of the development life cycle.
• Create and manage Users, Privileges and Roles.
• Maintaining data integrity also managing profiles, resources and password security.
• Provide assistance to developers/data analysts in SQL creation and Tuning
• Database support for the deployment of major software releases, feature enhancements, and bug fixes
• Provides DBMS expertise to other development groups as requested
• Diagnose and resolve database and related data problems
• Managing tablespaces, datafiles, redo logs, tables and its segments.
• Administering Oracle networking such as listener.ora and tnsnames.ora.
• Perform interrogation of system events, wait states, lock and latch activities and take corrective action based on analysis of these activities
• Refresh databases as needed using Import and export utility.
• Formulate policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
• Responsible for installation of Oracle 10g, 11i, 12c on unix and windows platforms.
• Performed upgrades from Oracle 11g to 12c.
• Performed upgrades from SQL Server 8 to 16

Confidential

Responsibilities:

• Responsible for migrating database from Oracle to MYSQL.
• Implemented restore and recovery stratagies(using rman) in live disaster recovery production environment.
• Perform database administration of Oracle (8i, 9i, 10g, 11g) and maintenance functions in support of the database system within Testing, development and production environments.
• Responsible for SQL Server 8 database administration
• Perform preventive database management, maintenance, and performance monitoring, tuning, and optimization
• Tune indexing, rollback, and initialization parameters
• Provide database administration tasks to include product upgrades and patch application.
• Experience performing tasks with Standard database tools such as but not limited to T.O.A.D and Oracle Enterprise Manager.
• Perform code migration, database changes, data and menus through the various stages of the development life cycle.
• Create and manage Users, Privileges and Roles.
• Maintaining data integrity also managing profiles, resources and password security.
• Provide assistance to developers/data analysts in SQL creation and Tuning
• Database support for the deployment of major software releases, feature enhancements, and bug fixes
• Provides DBMS expertise to other development groups as requested
• Diagnose and resolve database and related data problems
• Managing tablespaces, datafiles, redo logs, tables and its segments.
• Administering Oracle 10g networking such as listener.ora and tnsnames.ora.
• Perform interrogation of system events, wait states, lock and latch activities and take corrective action based on analysis of these activities
• Refresh databases as needed using Import and export utility.
• Provide SQL Server administration technical support as needed.
• Formulate policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
• Responsiblefor installation of Oracle 10g and 11i on unix and windows platforms.

Confidential

Responsibilities:

• Responsible for MYSQL database administration of NOVEC website.
• Responsible for migrating databases from NOVEC web-facing database(novec.com) from Oracle to MySql.
• Served as LINUX and HP-UX administrator for all NOVEC systems.
• Installed and configured 11.2g RAC on Linux 6.
• Implemented restore and recovery stratagies(using rman) in live disaster recovery production environment.
• Perform database administration (8i, 9i, 10g, 11g) and maintenance functions in support of the database system within Testing, development and production environments.
• Perform preventive database management, maintenance, and performance monitoring, tuning, and optimization
• Tune indexing, rollback, and initialization parameters
• Provide database administration tasks to include product upgrades and patch application.
• Experience performing tasks with Standard database tools such as but not limited to T.O.A.D and Oracle Enterprise Manager.
• Perform code migration, database changes, data and menus through the various stages of the development life cycle.
• Create and manage Users, Privileges and Roles.
• Maintaining data integrity also managing profiles, resources and password security.
• Provide assistance to developers/data analysts in SQL creation and Tuning
• Database support for the deployment of major software releases, feature enhancements, and bug fixes
• Provides DBMS expertise to other development groups as requested
• Diagnose and resolve database and related data problems
• Managing tablespaces, datafiles, redo logs, tables and its segments.
• Administering Oracle 10g networking such as listener.ora and tnsnames.ora.
• Perform interrogation of system events, wait states, lock and latch activities and take corrective action based on analysis of these activities
• Refresh databases as needed using Import and export utility.
• Provide HP-UX and Windows system administration technical support as needed.
• Formulate policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
• Responsible for installation of Oracle 10g and 11i on unix and windows platforms.

Confidential

Oracle Database Analyst

Responsibilities:

• Responsible for MYSQL database administration of NOVEC website.
• Responsible for migrating databases from NOVEC web-facing database(novec.com) from Oracle to MySql.
• Served as LINUX and HP-UX administrator for all NOVEC systems.
• Installed and configured 11g RAC on Linux.
• Implemented restore and recovery stratagies(using rman) in live disaster recovery production environment.
• Perform database administration (8i, 9i, 10g, 11g) and maintenance functions in support of the database system within Testing, development and production environments.
• Perform preventive database management, maintenance, and performance monitoring, tuning, and optimization
• Responsible for migrating databases from Oracle to MySql.
• Tune indexing, rollback, and initialization parameters
• Provide database administration tasks to include product upgrades and patch application.
• Experience performing tasks with Standard database tools such as but not limited to T.O.A.D and Oracle Enterprise Manager.
• Perform code migration, database changes, data and menus through the various stages of the development life cycle.
• Create and manage Users, Privileges and Roles.
• Maintaining data integrity also managing profiles, resources and password security.
• Provide assistance to developers/data analysts in SQL creation and Tuning
• Database support for the deployment of major software releases, feature enhancements, and bug fixes
• Provides DBMS expertise to other development groups as requested
• Diagnose and resolve database and related data problems
• Managing tablespaces, datafiles, redo logs, tables and its segments.
• Administering Oracle 10g networking such as listener.ora and tnsnames.ora.
• Perform interrogation of system events, wait states, lock and latch activities and take corrective action based on analysis of these activities
• Refresh databases as needed using Import and export utility.
• Provide HP-UX and Windows system administration technical support as needed.
• Formulate policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
• Responsible for installation of Oracle 10g and 11i on unix and windows platforms.

Sr. Oracle Database Administrator (DBA)

Confidential

Responsibilities:

• Was responsible for Oracle Database Analysis, Database Backup and Recovery Procedures including RMAN, Database Performance Tuning (CPU, Disk, Memory, and SQL Statements),
• Installed and configured 11g RAC on Linux.
• Responsible for MYSQL database administration of NOVEC website.
• Served as LINUX and HP-UX administrator for all NOVEC systems.
• Implemented restore and recovery stratagies(using rman) in live disaster recovery production environment.
• Perform database administration (8i, 9i, 10g, 11g) and maintenance functions in support of the database system within Testing, development and production environments.
• Perform preventive database management, maintenance, and performance monitoring, tuning, and optimization
• Responsible for migrating databases from Access to Oracle, Oracle to MySql.
• Tune indexing, rollback, and initialization parameters
• Provide database administration tasks to include product upgrades and patch application.
• Experience performing tasks with Standard database tools such as but not limited to T.O.A.D and Oracle Enterprise Manager.
• Perform code migration, database changes, data and menus through the various stages of the development life cycle.
• Create and manage Users, Privileges and Roles.
• Maintaining data integrity also managing profiles, resources and password security.
• Provide assistance to developers/data analysts in SQL creation and Tuning
• Database support for the deployment of major software releases, feature enhancements, and bug fixes
• Provides DBMS expertise to other development groups as requested
• Diagnose and resolve database and related data problems
• Managing tablespaces, datafiles, redo logs, tables and its segments.
• Administering Oracle 10g networking such as listener.ora and tnsnames.ora.
• Perform interrogation of system events, wait states, lock and latch activities and take corrective action based on analysis of these activities
• Refresh databases as needed using Import and export utility.
• Provide HP-UX and Windows system administration technical support as needed.
• Formulate policies, procedures, and standards relating to database management, and monitors transaction activity and utilization.
• Responsible for installation of Oracle 10g and 11i on unix and windows platforms.

Confidential

Oracle Database Administrator (DBA)

Responsibilities:

• Perform database administration (8i, 9i, 10g) and maintenance functions in support of the database system within Testing and development environments.
• Perform preventive database management, maintenance, and performance monitoring, tuning, and optimization
• Responsible for migrating the databases as necessary; tune indexing, rollback, and initialization parameters
• Provide database administration tasks to include product upgrades and patch
• Application.
• Develop, update and maintain physical data models as needed.
• Experience performing tasks with Standard database tools such as but not limited to T.O.A.D, Oracle Enterprise Manager and Grid Control
• Perform code migration, database changes, data and menus through the various stages of the development life cycle.
• Create and manage Users, Privileges and Roles.
• Maintaining data integrity also managing profiles, resources and password security.
• Provide assistance to developers/data analysts in SQL creation and Tuning
• Database support for the deployment of major software releases, feature enhancements, and bug fixes
• Provides DBMS expertise to other development groups as requested diagnose and resolve database and related data problems
• Managing tablespaces, datafiles, redo logs, tables and its segments.
• Administering Oracle 10g networking such as listener.ora and tnsnames.ora.
• Performing Installation and Configuration of Oracle's Enterprise Manager 10g Control utility, using Database Configuration Assistant (DBCA) or manually by running scripts
• Perform interrogation of system events, wait states, lock and latch activities and take corrective action based on analysis of these activities
• Performing Oracle 10g Data Pump Import and export utility.
• Experience With Oracle RAC (Real Application Clusters)

Sr. Software Test Engineer

Confidential

Responsibilities:

• Primary responsibilities are to acquire functional understanding of MT eGrants and Generic Financial System (GFS) as tasked by daily interaction with developers of the modules, FEMA representatives and as necessary end-users.
• Review, log, and test system change requests, and deploy new builds of the eGrants application into the development environment.
• Perform manual and automated(using Winrunner and LoadRunner) unit, system and regression test activities in Development and Test environments
• Document results in testing logs and the requirements matrix as applicable.
• Clarify and develop requirements with FEMA representatives.
• Develop new and execute existing SQL queries to review data and test results.
• Analysis and development of software development lifecycle (SDLC) documentation, such as software design documents, requirements documents, test strategy documents, test plans.
• Provide daily production support to user throughout the country for MT eGrants system.
• Use of PVCS Tracker to log defects and enhancements and track testing progress.

Confidential

Software Developer/tester

Responsibilities:

• Debugged and modified code in response to requirement changes or to change requests generated during software testing.
• Created stored procedures in Sybase, and wrote UNIX shell scripts to automate routine tasks and provide users with up-to-date billing data.
• Wrote and executed complex test scripts and test cases, investigated and verified bug reports, and verified bug fixes as part of comprehensive functional testing activities.
• Managed up to 20 Quality Assurance testers in a high-pressure environment and maintained a perfect record of on-time delivery.
• Interacted extensively with local and remote clients, traveling to the UK offices as needed.
• Set up and managed the QA testing environment using C, Perl, UNIX, and Sybase. Gained extensive experience in shell scripting and querying the database using SQL.
• Supported the development team throughout the software development life-cycle.
• Directed all aspects of User Acceptance Testing for the initial release of multiple source system feeds for WorldCom's international IBIS system.