Description
Professional background of over twenty (30) years productive and successful experience in Database Administration with a proven track record functioning as an independent consultant. I have completed many projects with full life cycle. MIS team leader/project leader. Team player attitude with the ability to work independently. Possess very good analytical skills. Ability to effectively communicate with peers and management. Ability to mentor/cross-train other DBA's and associates. Provide Database Administration leadership in designing and implementing highly scalable database solutions deliverables. * Analyze, design and data model solutions for business needs in cooperation with various levels of business and systems personnel (Flow Charting, ERD diagrams, etc.) * Perform database analysis, design, coding, testing and implementation of database structures. * Participate in requirement gathering and business requirements. Understand complex data relationships and business requirements to formulate efficient and reliable solutions to difficult problems. End-to-end design and implementation of data modeling and database planning including data warehousing. * Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems including project planning. * Review database access code and recommend performance tuning opportunities and system testing. * Write code to access database. * Advise less experienced team members in all phases of the assignments and assist in the coordination of team activities. * Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms. * Install, test, evaluate, implement and maintain DBMS related system software and tools. * Design and implement database backup and recovery procedures. * Monitor and tune database performance including SQL performance tuning. * Implement effective database security practices and procedures. * Implement complex enterprise changes as they pertain to the database environment. * Develop, document and enforce database standards and procedures. * Maintain and improve high availability and disaster recovery. * Strong skill in PL/SQL procedures, packages, triggers and replication. * Work with development and operations staff in resolving problems quickly and efficiently. * Clear communication and documentation of technical specifications. * Sharing knowledge by effectively documenting work. * Load and extract formatted data in and out of database (ETL). * Migrate data to other databases. * Recover lost databases. * Database storage management. * Finest granularity approach to Oracle implementation and defragmentation. * I/O distribution analysis. * Capacity planning, capacity monitoring and management. * Strong database troubleshooting experience. * Perform transaction-sizing measurements. * Managed day-to-day production databases. * Possess a thorough understanding of Oracle fundamentals, concepts, utilities and applications. * Seasoned experience with Unix and Linux a strong ability with shell scripting. * Experience working in large database environments. * Calculate disk space requirements. * Oracle's Enterprise Manager (OEM), Statspack Reports, Explain Plan, SQL Trace, TKPROF and AWR Reports. * Oracle SQL*Net Network Configuration. * Volume sized production database with over 45 terabytes of data. * Install Oracle patches and upgrades. * Provide Database Administration using SDLC from initial feasibility study through maintenance and development of the completed database and application cycle using conceptual data modeling tools to describe stages of complete database implementation.
Work Experience
Education
SCHOOL | MAJOR | YEAR | DEGREE |
---|---|---|---|
Computer Science courses | Pascal | 1989 | Bachelor Degree |
Techniques for Effective Systems Development course | Yourdon Structured Analysis and Design workshop | 1988 | Bachelor Degree |
Atlanta Junior College six months | and Data Structures | 1985 | Bachelor Degree |
University of North Carolina | Political/Computer Science | 1983 | Bachelor Degree |