Atlanta Metropolitan Area
More than 20+ years of experience in database administration (DBA) and database development work for various kinds of applications in Oracle on both UNIX and Windows environments. A self-motivated, responsible, and reliable team player with a powerful set of technical skills in a wide range of database work. I can be contacted at: ***************************************** [email protected] ****************************** Certification: Oracle 8i OCP Databases: DB2, Oracle 8, 9i (9.0-9.2), 10g, 11g, 12c, 19c, Oracle Exadata, MySQL, MS SQL Server, and PostgreSQL Operating Systems: Oracle Exadata Storage Server, HP/UX, MS NT/Windows, Solaris, Linux, AIX, and VMS Training: AS400 Training, JD Edwards training(AP, AR and PO) Professional Automotive Sales Techniques by Total Sales Solutions (TSS) Languages: APEX, C, C#, .NET, Crystal Reports, Centura/SQLWindows, GoldenGate, Transform and Load (ETL), Informatica, Oracle Reports, PL/SQL, SQL Loader, T-SQL, Siebel, HTML, shell scripts, SQRW, XML, Perl, Python, Unified Modeling Language (UML), and Liquibase Version Control: PVCS, AllFusion Harvest CM, Configuration Management and Version Control (CMVC), and MS SourceSafe Tools: DataMirror, ERwin, Enterprise Manager, Rational Rose, SQL Navigator, TOAD, SQL*Plus, Quest Tools, and Visio Specialties: ** Oracle Exadata ** Oracle Exadata Patching ** Oracle 6, 7, 8, 9, 10g, 11g, 12c,19c, and 21c ** Oracle RAC ** PL/SQL ** Oracle Streams ** Oracle GoldenGate ** Oracle Data Guard ** Core DBA
Responsible for PL/SQL Developer for Benefits Integrated Delivery (BID)/Enterprise Management Payment Workflow and Reporting (eMPWR) Agile projects. Writing and Maintaining Stored Programs (PL/SQL)
Responsible for PL/SQL Developer for Nautilus LIMS (System to manage blood and urine samples and associated data) Lead PL/SQL Developer for all projects. Agile projects Reviewed the Code for design, architecture, and development. Writing and Maintaining Stored Programs (PL/SQL) Database performance tuning and query optimization Support the ETL process with the warehouse database. Cross-trained other teammates on stored programs and database query optimization
Maintain Database Architecture for the State of Georgia and North/South Carolina Department of Labor Southeast Consortium for Unemployment Benefits Integration (SCUBI) Project Maintained Stored Programs (Functions, Procedures Triggers, and Packages) for the projects Duties included: Database Troubleshooting automation including alarm log for down database, Oracle patching, SR’s, database performance tuning and query optimization, killing user sessions which were blocking other connections, the addition of space in response to proactive alarms, database recoveries and various other problem situations Database size: Large +TB
Responsible for Database Support for Custom Refrigeration Systems Maintained Database Architecture Maintained the DBA Support for Oracle (12c) and SQL Server Database performance tuning and query optimization Maintained Stored Programs (Functions, Procedures Triggers, and Packages) for the projects Duties included: DBA Support, Database Backup/Restore (RMAN), Database installation, administration, patching, SR’s, Database performance tuning and query optimization
Upgraded Oracle Real Application Clusters (RAC/ASM) database from 11.2.0.3 to Exadata 11.2.0.4 with Oracle Corporation Using RMAN and Transporting Tablespace for Exadata upgrade. Install Audit Vault and Database Vault on Exadata Implemented Oracle Data Guard Advising, mentoring, and technical leadership for the upgrade to Exadata Writing Korn Shell scripts for task automation Maintained, supported, and configuration Replication (Oracle GoldenGate) Writing and Maintained Stored Programs (PL/SQL) Duties included: DBA Support, Database Backup/Restore (RMAN), Database installation, administration, Oracle patching, SR’s, Database performance tuning and query optimization Database size: Large +TB