Database Administrator Disaster Recovery

Experience Summary:

Seasoned database administrator with over 20 years of experience supporting Oracle databases across 300+ Oracle and third-party applications. Expertise spans Oracle releases from Oracle 7 to Oracle 19c on diverse operating systems, including Linux, zLinux, AIX, HP-UX, SUN, and Microsoft Windows. Proficient in Amazon AWS cloud migration and implementations, with five years of experience in provisioning, migrating, and managing AWS services such as Amazon S3, EC2 (IaaS), and Amazon RDS (DBaaS) for Microsoft SQL Server, Oracle, MySQL, MariaDB, PostgreSQL, and Amazon Aurora. Skilled in AWS administration, monitoring, troubleshooting, data synchronization, backup and recovery, geographic data replication across regions and availability zones, CloudWatch performance monitoring, system tuning, and disaster recovery planning and execution. Expert in database services for Amazon RDS, on-premises/cloud data integration, cloud migration analysis, and implementation. Well-versed in IT automation, configuration management, and provisioning tools like Chef and Ansible. Possesses deep expertise in advanced Oracle features, including high availability configurations, Oracle GRID/OEM, data warehousing, partitioning, parallel processing, and advanced security. Extensive experience across all key database disciplines, including administration, SQL tuning, monitoring, high availability, disaster recovery, security, and auditing. Additionally, adept in evaluating and implementing new database technologies to optimize system performance and reliability.

Core Competencies

24/7 Oracle and AWS Database Administration & Support

Cloud Migration & Integration (AWS & On-Premises)

High Availability & Replication Strategies

Performance Monitoring & Optimization

Backup, Recovery & Disaster Recovery Planning

Oracle Exadata & ODA Administration

IT Automation & Configuration Management

SQL Optimization & Performance Tuning

Advanced Security & Compliance (DISA STIG, Audit Vault, VPD, FGA)

Storage & Space Management.

Technical Proficiency

Databases: Oracle 7-19c, Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, Amazon Aurora

Cloud Platforms: Amazon AWS (EC2, RDS, S3, CloudWatch, IAM, VPC, Route 53)

Operating Systems: Linux, zLinux, AIX, HP-UX, Solaris, Windows

Automation Tools: Chef, Ansible, Bash, Perl, Python

Oracle Technologies: RAC, Data Guard, GoldenGate, Grid Infrastructure, Secure Backup

Monitoring & Management: OEM, RMAN, SQL Developer, Veritas NetBackup, IBM Rational Software

PROFESIONAL WORK EXPERIENCE:

Sr. Oracle DBA Meridian Technologies -Blue Cross Blue Shield of South Carolina/DPSS Inc. (Jun 2022 – Present.)

• Serve as the primary lead in managing and maintaining Oracle databases.

• Provide mentorship and guidance to junior staff on Oracle database management and best practices.

• Conduct compliance reviews and implement updates for Oracle databases to ensure adherence to policies and standards.

• Administer and support Oracle 12c and 19c databases, ensuring optimal performance and availability.

• Manage and maintain Oracle RAC (Real Application Cluster) databases for high availability and scalability.

• Configure Oracle databases to align with DISA STIG (Defense Information Systems Agency Security Technical Implementation Guide) security and compliance requirements.

• Develop comprehensive work instructions, desk procedures, database standards, and other technical documentation.

• Effectively communicate critical operational issues and updates to management, particularly for high-visibility situations.

• Create detailed estimates, technical approaches, and work breakdown structures (WBS) for database administration tasks associated with projects.

Oracle DBA Lead, Technology and Operations, Shared Services.

DPSS Inc/Peraton/Seneca Resources - US Senate. (May 2020 - Jun 2023)

• Installed, configured, and maintained Oracle 12c and 19c databases on Z-Linux and Linux servers.

• Ensured the integrity, security, and availability of multiple databases, including responsibilities for disaster recovery, performance tuning, index maintenance, and database monitoring.

• Administered and enforced database policies and procedures to secure and maintain the integrity of data systems.

• Evaluated and recommended database management system (DBMS) solutions to meet organizational needs. Designed, developed, and maintained databases while ensuring optimal performance and scalability.

• Conducted database and software lifecycle activities to maximize system performance, availability, and compliance with business requirements.

• Developed and managed organizational data policies, database standards, and operational procedures, providing clear guidance and responding to user inquiries regarding policies and procedures.

• Ensured compliance with data management standards across all database operations.

• Led evaluations and provided recommendations for adopting new database technologies and architectures, especially in anticipation of increased data capacity requirements.

• Designed and implemented data mining and warehousing programs, including developing solutions for data migration and integration from other databases as needed.

• Consulted on data analysis and requirements gathering, defined specifications, and contributed to database design, normalization, and implementation. Conducted performance tuning, ensured backup operations, and executed database recovery processes to maintain system reliability.

Sr. IT Specialist. DPSS Inc/Purisolve Atlanta, GA. at Internal Revenue Service IRS. (September 2017 – April 2020)

Remote Senior IT Specialist, DPSS Inc./Purisolve at The Internal Revenue Service (IRS). Project: Oracle 11g to 12c Upgrade & Oracle 11g to 12c Forms/Reports Migration. Worked collaboratively with a team of Database Administrators (DBAs) and Developers to upgrade Oracle 11g databases and migrate Oracle Forms and Reports to Oracle 12c. The migration process spanned across various environments, including sandbox, development, testing, and production, with completed projects such as TAMIS, PAC, CASE-MIS, SERP, AUR, CTW, OL5081, BBTS, PHOREF, PTRACER, and TRAC/EDS.

KEY RESPONSIBILITIES:

• Database Installation & Maintenance: Installed, configured, and maintained Oracle 12g and 19c databases on Z-Linux and Linux servers. Ensured the integrity, security, and availability of multiple databases across environments.

• Forms/Reports Migration: Migrated all Oracle 11g Forms and Reports to 12c. Packaged pertinent files from sandbox servers and deployed them to development, testing, and production servers. Configured Oracle 12c Fusion Middleware and WebLogic for all projects post-migration.

• Testing & Configuration: Conducted unit and project testing to validate the successful migration of forms and reports. Assisted teams in troubleshooting issues during testing phases.

• Database Administration Duties: Administered, maintained, and implemented policies to ensure database security and integrity. Performed disaster recovery planning, performance analysis and tuning, and index maintenance. Monitored databases to optimize system performance and ensure compliance with business requirements.

• Evaluation & Recommendations: Evaluated database management system (DBMS) products and recommended solutions based on project needs.

• Lifecycle Management: Executed database and software lifecycle activities to maintain peak system performance and availability. AWS, SQL Server, and Application Administration: Performed administration tasks for AWS, SQL Server, and other application servers.

• Data Management: Organized and formatted data for efficient querying and storage processes.

TEKsystems/PNC Bank, College Park, MD / Department of Treasury (August 2009 to October 2016)

Senior member of the Database Administration group of PNC Financial Services Group Riverdale MD, part of an

organization committed to customers, employees, investors, and communities. Worked on Transaction Reporting System of United States Treasury (TRS) now Collection Information Repository (CIR) and data Warehouse databases (CIR) which ranges from 4TB to 6TB in size. Caslink2 is a global electronic cash concentration system used to manage the collection of government funds, and to report balances to the Federal agencies. CLII is used by over 2,500 Federal agencies which collect more than $800 billion annually. It is a deposit reporting application. CIR/TRS is a Financial Management Services (FMS) wide transaction broker, data warehouse, and reporting solution.

• Designed, Planned, implemented, and configured AWS environment to support Data warehouse project and TRS project and build highly redundant and resilient cloud infrastructure for both projects (IBM AIX server to Cloud Linux).

• Provided EC2 and RDS instances on AWS and Migration of databases on local servers to AWS cloud.

• Hands on experience in using configuration management tools like Chef, Puppet and Ansible deployment tools.

• Experience in Linux Administration, Configuration management, Continuous Integration (CI), Continuous Deployment, Release management and cloud implementation. Design EC2 instance architecture to meet high availability application architecture and security parameters.

• Maintained the user accounts (IAM), RDS, Route 53, VPC, RDB, Dynamo DB, SES, SQS and SNS services in AWS

cloud.

• Provided High Availability (HA) and Disaster Recovery (DR) solutions to maintain business data integrity. Installed,

configured, and maintained Oracle 9i, 10g and 11gR2. Responsible for Data-guard Physical Standby database support,

Data/Code Migration and Data Integration.

• Provided 24x7 productions support services for all the PNC database operations TRS, CLII and Card Data Mining (CDM). Ensured availability and timely maintenance of all the databases. Ensured adherence to Service Level Agreements, performed performance and capacity planning analysis, Developed and or updated operational procedures, when necessary, monitored operations and performance of databases, Conducted root cause analysis and effective and timely communication of issues to leadership.

• Led Oracle Monitoring and Management implementation initiative, architect, design and implement the solution with over 98% result deployment.

• Responsible for implementing and overseeing enterprise database security standards and ensuring compliance with the corporate IT change management process.

• Improved DB monitoring with OEM by installing, configuring, and implementing Oracle Enterprise Manager (OEM) 12c cloud to make 24/7 production DB monitoring an easy one for TRS, CL2, Card Data Mining project.

• Installed, configured, and created the first PNC Oracle 11g Database Data Guard, high availability solutions for card data mining project with Oracle encryption, Oracle wallet & Oracle Database Vault features. Also upgraded several databases from Oracle 9i to 10g and from 10g to 11g in all PNC database environments.

• Efficiently handled space management, size and capacity planning in different versions of Oracle databases and worked with the systems Operations in defining Hardware and Architectural requirements such as disk space, file system layout as related to Oracle data files and system memory in all PNC database environments

Senior Enterprise Database Administrator/ Information Technology Specialist, Oracle DBA Lead

Select Computing Inc - Columbia, MD (June 2004 to August 2009)

•Team lead, Database Administration group of Select Computing Inc. at Center for Medicare and Medicaid Services. Worked on Department of Health & Human Services, Centers for Medicare, and Medicaid Services (CMS) projects. Worked in a group of fourteen SQL server & Oracle DBA, provided day-to-day development, QA, & production support for all CMS OLTP applications, (COTS, CMS, and contractor developed), online analytical processing (OLAP) applications, and decision support systems (DSS). Over 180 databases on various platforms: UNIX Sun Solaris 9, 10, Red Hat Linux 5.0 and AIX operating systems. Database environment consisted of databases that ranged in size from 200 gigabytes (GB) to 4 terabytes.

Senior Oracle Database Administrator SAIC / VeriSign / Network Solutions Inc - Herndon, VA (August 1999 to June 2004)

•Managed and optimized Oracle database systems, ensuring high availability, performance, and security for

critical business applications, while leading a team of database professionals in implementing best practices and

troubleshooting complex technical issues.

Oracle Database Administrator AT&T Communications - Herndon, VA (May 1997 to July 1999)

•Managed and optimized Oracle database systems to ensure high availability, performance, and security, while

collaborating with cross-functional teams to support business-critical applications.

EDUCATION:

Masters in information technology Charles Sturt University May 2011

Bachelor of Arts Mass-Communication Ogun State Polytechnic May 1991

CERTIFICATIONS AND LICENSES:

AWS Certified Solutions Architect - Associate. March 2020 to March 2023.

Oracle Database 8i, 9i, 10g, 11g & 12c Administrator Certified Professional. February 2015 to Present.

Oracle E-Business Suite R12 Application Database Administrator Certified Professional. March 2015 to Present.

Microsoft Certified Professional (MCP) Microsoft Office Share Point. March 2009 to Present.

ITIL V3 Foundation. February 2009 to Present

Oracle Database 11g Administrator Certified Professional. September 2008 to Present

AWS Developer Associate. November 2018 to November 2021

AWS Security Specialist. January 2020 to January 2023

Certified Information Security Manager (CISM) August 2021

MANAGEMENT: Strategic planning, Personnel management, Project/Program management, Budget planning, Policy and Procedure enforcement, Business Process Re-engineering.

Contact this candidate