Summary




n Record of achievement in undergraduate and graduate academic programs. Hold Master's degrees in Statistics, Computer science from the University of Missouri
n Over 20 years high level consulting experience in Government, Finance, Education, Manufacturing, Transportation, Research and Telecommunications using Relational Database Management Systems products Oracle, DB2, SQL Server, Sybase on mainframes and clients/Servers environments.
n SUN Microsystems Partner and over 20 years of databases and applications administration, development, testing, architecture, design and support.


Education

Miscellaneous

Senior Database Administrator/Consultant and Technical Lead, Government of the State of Ohio, Department of Job and Family Services, Columbus, Ohio ;
Intelcom, Columbus Ohio ; NCR Dayton, Ohio
Environment : Oracle Software : Oracle 8, 8i, 9i, 9i RAC, 10g, 10g RAC, 11g, 11g RAC, 11i, 8iAS, 9iAS, Designer 2000, Oracle Data Guard, Oracle Standby.
Third Party Software : FileNet 3.5, 4.0, Informatica, Clarity, OmniRim, EM Job scheduler, Dimensions, BMC, TSM, Erwin, Sql Server, Peoplesoft, SAP, Erwin, QMF, CSP.
Operating Systems : Windows 2000, 2003, XP, IBM AIX 4.3.3/5L, SUN Solaris 2.7/2.8/2.9, IBM Mainframe
Under general direction from the management, I performed all aspects of Oracle database/applications management administration, design, modeling, tuning, maintenance, backup/recovery data guard/oracle standby, deployment, migration, integration, installation/upgrade/patching, troubleshooting and support, training in a client server environment in a RAC and non-RAC environment.
Responsibility included Production and Operations Pre-Production Databases and Applications administration and Support. Following were typical detailed responsibilities : Ensure continuous 24x7 availability, reliability and optimal performance tuning of production and development database instances and applications RAC, non-RAC, Standby, Data Guard, Coordinate all aspects of the application life cycle across the agencies/sections to meet the desire business goal RAC, non-RAC, Standby, Data Guard
Install, configure and upgrade/patch Oracle databases/applications software, monitor and control disk space usage, objects creation, data security and hardware usage RAC, non-RAC, Standby, Data Guard
Ensure contingency plans for each database/applications systems backup, recovery are documented and tested RAC, non-RAC, Standby, Data Guard, Propose and develop strategic database improvements in technical areas of database/applications implementation, support and enhancement RAC, non-RAC, Standby, Data Guard, Provide technical leadership and direction in implementing enterprise information integration architecture practices using Oracle database and third party applications software RAC, non-RAC, Standby, Data Guard, Work with development team to coordinate and promote new versions of Oracle RDBMS/applications, new installations, upgrades and patches, deployments and migrations RAC, non-RAC, Standby, Data Guard, Act in a consulting capacity supporting development teams during database and applications design and implementation phases RAC, non-RAC, Standby, Data Guard, Develop and maintain a system integrated architecture that enables seamless interoperability of agencies/Sections complex applications systems RAC, non-RAC, Standby, Data Guard, Troubleshoot user databases/applications issues this includes working with the individual end-user groups, engineering, external clients and the Technical Support organizations of 3rd party vendors RAC, non-RAC, Standby, Data Guard, Work as a leader in the implementation of the technical aspects of the production and development, maintenance, enhancement, troubleshooting and support of the enterprise system architecture and integration for several successful business applications RAC, non-RAC, Standby, Data Guard.
Develop, document and enforce applications/databases standards and procedures, ensuring the quality and consistency of data and database systems by following a defined set of procedures change control, security procedures, user passwords, backups, etc RAC, non-RAC, Standby, Data Guard, Lead and participate in several aspects of the project tasks integration production and development like architecture, design, development, system testing and user acceptance RAC, non-RAC, Standby, Data Guard, Generate and interpret data to identify and correct database/applications performance issues, coordinate database cloning, schema and table level data refreshes with development team and support staff RAC, non-RAC, Standby, Data Guard, Write/maintain OS level scripts ie, UNIX shell for system databases and applications maintenance RAC, non-RAC, Standby, Data Guard, Work with cross project teams to resolve technical performance issues/bottlenecks eg, network, storage, applications RAC, non-RAC, Standby, Data Guard, Use best practices to recommend query optimization to Developers, perform basic SQL Server administration functions, provide methodologies and standards in business/applications levels in order to achieve successful applications integration results RAC, non-RAC, Standby, Data Guard, Review overall physical database/applications structures for data integrity, performance quality, recoverability, maintenance and space requirement considerations RAC, non-RAC, Standby, Data Guard, Work closely with applications development teams to ensure proper data modeling and design paradigms are applied in the creation and ongoing maintenance of respective databases/applications to ensure efficient data access in application programs RAC, non-RAC, Standby, Data Guard, Serve as the central point for all technical aspects for the business/projects integration issues by analyzing the systems functional and performance requirements for the implementation of new designs and scenarios RAC, non-RAC, Standby, Data Guard, Review test benchmarks, overall physical database/applications structures for data integrity and performance RAC, non-RAC, Standby, Data Guard.
I monitored Production and Pre-Production database/applications query results for performance in an online and batch environments, monitored all Oracle/applications data and system objects to maintain integrity of relational database/applications management system .I monitored efficiency of Oracle/applications database performance, database/applications growth and deploy/migrate tuning measures to improve performance using high-level information system tools/utilities like Oracle Enterprise Manager OEM, Grid Control, UNIX tools and Statspack.
Senior Database Administrator/Consultant and Technical Lead with UPS KY, AT and T IL, XEROX TX, IBM IL, Sun Microsystems IL, MasterCard International MO, World Bank DC, Bank of New England MA, Paul Revere Insurance MA, National Steel IN.
Environment : Oracle Software : Oracle 5, 6, 7, 8, 8i, 11i, Designer 2000.
Third Party Software : BMC, Sql Server, PeopleSoft, SAP, QMF, CSP.
Operating Systems : Windows, IBM AIX 4.3.3 SUN Solaris 2.7/2.8/, IBM Mainframe.
Under general direction from the management, I performed all aspects of Oracle database/applications management administration, design, modeling, tuning, maintenance, backup and recovery, deployment, migration, integration, installation/upgrade/patching, troubleshooting and support, training in a client server environment in a non-RAC environment.
Responsibility included Production and Operations Pre-Production Databases and Applications administration and Support. Following were typical detailed responsibilities : Ensure continuous 24x7 availability, reliability and optimal performance tuning of production and development database instances and applications non-RAC, Coordinate all aspects of the application life cycle across the agencies/sections to meet the desire business goal non-RAC
Install, configure and upgrade/patch Oracle databases/applications software, monitor and control disk space usage, objects creation, data security and hardware usage non-RAC
Ensure contingency plans for each database/applications systems backup, recovery are documented and tested non-RAC, Propose and develop strategic database improvements in technical areas of database/applications implementation, support and enhancement non-RAC, Provide technical leadership and direction in implementing enterprise information integration architecture practices using Oracle database and third party applications software non-RAC, Work with development team to coordinate and promote new versions of Oracle RDBMS/applications, new installations, upgrades and patches, deployments and migrations non-RAC, Act in a consulting capacity supporting development teams during database and applications design and implementation phases non-RAC, Develop and maintain a system integrated architecture that enables seamless interoperability of agencies/Sections complex applications systems non-RAC, Troubleshoot user databases/applications issues this includes working with the individual end-user groups, engineering, external clients and the Technical Support organizations of 3rd party vendors non-RAC, Work as a leader in the implementation of the technical aspects of the production and development, maintenance, enhancement, troubleshooting and support of the enterprise system architecture and integration for several successful business applications non-RAC.
Develop, document and enforce applications/databases standards and procedures, ensuring the quality and consistency of data and database systems by following a defined set of procedures change control, security procedures, user passwords, backups, etc non-RAC, Lead and participate in several aspects of the project tasks integration production and development like architecture, design, development, system testing and user acceptance non-RAC, Generate and interpret data to identify and correct database/applications performance issues, coordinate database cloning, schema and table level data refreshes with development team and support staff non-RAC, Write/maintain OS level scripts ie, UNIX shell for system databases and applications maintenance non-RAC, Work with cross project teams to resolve technical performance issues/bottlenecks eg, network, storage, applications non-RAC, Use best practices to recommend query optimization to Developers, perform basic SQL Server administration functions, provide methodologies and standards in business/applications levels in order to achieve successful applications integration results non-RAC, Review overall physical database/applications structures for data integrity, performance quality, recoverability, maintenance and space requirement considerations non-RAC, Work closely with applications development teams to ensure proper data modeling and design paradigms are applied in the creation and ongoing maintenance of respective databases/applications to ensure efficient data access in application programs non-RAC, Serve as the central point for all technical aspects for the business/projects integration issues by analyzing the systems functional and performance requirements for the implementation of new designs and scenarios non-RAC, Review test benchmarks, overall physical database/applications structures for data integrity and performance non-RAC.
I performed other related duties as assigned eg, attends conferences seminars and workshops, complete on-line training, read manuals and literature in order to stay abreast of current database management techniques .I attended and facilitated staff/team meetings ; traveled across States to meet with services providers and related organization .I provided input to Administrators concerning performance evaluations of lower-level analysts.