I’m a seasoned Senior Oracle DBA with a rich background at Accenture Federal Services, where I’ve honed my skills in Oracle database migrations and performance tuning. I’ve successfully led efforts that reduced operational costs by over $ 440,000 while also enhancing our data security protocols. My experience with RMAN has allowed me to lead teams effectively, ensuring high data availability and project success.
In my role, I’ve focused on cloud migrations and database architecture, taking on initiatives that not only save costs but also drive strategic growth. I’m proud of leading a project that saved $ 440,000 per year, which showcases my ability to plan and lead effectively. I’m well-versed in Oracle 19c and have extensive experience with tools like RMAN, EXPDP/IMPDP, and cloud services, including AWS EC2, RDS, and S3.
I thrive in collaborative environments and enjoy tackling challenges with innovative solutions. My passion lies in optimizing database performance and maintaining data integrity across different platforms, ensuring that our systems are both efficient and secure.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Sr. Oracle DBA (Associate Manager)
Accenture Federal Services supporting DOJ (US Marshall Services)
Crystal City
10.2016 - Current
Oversee database operations and maintenance for the U.S. Marshals Service, performing upgrades on Linux, and installing and managing Oracle databases using Grid and Oracle Enterprise Manager (OEM) Cloud Control. Install and configure the required network components to support database access, consistency, and integrity. Define and communicate the technical roadmap and lifecycle for the components and systems supported by the database administration team. Migrated Oracle database 19c to the cloud, AWS EC2, and AWS RDS. Effectively communicate project status to all stakeholders, executive leadership, and project teams. Conduct periodic security evaluations at the data system level and on applications, and develop action plans to increase security protocols. Manage installations, migrations, upgrades, backups, and recoveries, as well as SQL and performance tuning, proactive monitoring, and troubleshooting of Oracle databases in a 24/7 environment. Research options and design architecture solutions for backend database environments and web-based systems to support technical, service-level objectives, and business goals.
Key Contributions:
Managed the development of strategic plans, frameworks, patterns, and best practices while collaborating with other IT architects.
Successfully troubleshot and resolved log gaps in Data Guard Configuration, maintained Data Guard physical standby databases for disaster recovery within a short period, and shortened the downtime for the application users.
Installed Oracle database, Data Guard with Data Broker, and performed multiple production switchovers using the Data Guard Broker utility of Data Guard.
Installed and upgraded the OEM cloud control from 13.2 to 13.3.
Moved Oracle databases from the legacy RH6 environment to the new data center RH7 environment.
Performed an Oracle Database upgrade from 11g to 12c in a Linux environment.
Performed an Oracle Database upgrade from 12c to 19c in a Linux environment.
Experience in managing PostgreSQL.
Performed database refresh/cloning using RMAN to duplicate production data for development and testing.
Manage and implement a disaster recovery strategy by performing seamless switchovers between data centers.
Manage and perform quarterly Oracle database patching over 68 databases across 45 Linux servers.
Achieved backup efficiencies with RMAN, Data Pump EXPDP/IMPDP, and AWS Cloud storage.
Saved a client $440K+ in operational expenses by consolidating server resources and migrating the 11g database to 12c.
Successfully migrated development, test, and production on-premises Oracle databases to AWS EC2.
Developed consistent, distributed databases by using replication on the AWS platform.
Created network architecture on AWS VPC, subnets, Internet Gateway, Route Table, and NAT setup.
Sr. Oracle DBA
Accenture Federal Services supporting DHS (ICE)
Washington DC
03.2016 - 10.2016
Spearheaded the initiative to provide collaboration reports to Accenture, project teams, and client leadership, significantly reducing travel expenses for many clients. Led a four-member DBA team that collaborated with B2Ts, BAs, Enterprise, and Application teams to ensure high data availability in the application testing database. Utilized ADDM, gathered and analyzed AWR reports, and performed daily monitoring and performance analyses for the clients' databases. Developed functional and technical design documents after thoroughly examining source systems and business requirements. Conducted database tuning by generating an Explain plan for long-running SQL queries, and creating indexes on columns to improve performance. Implemented a backup and recovery strategy for disaster recovery using hot and cold backups with the Oracle backup utility, such as RMAN. Minimized fragmentation using logical backup and restore (Export and Import Data Pump: EXPDP/IMPDP) processes, and reimagined database objects, tables, and indexes—mentored and cross-trained project team members in development and architecture methodologies to increase project throughput.
Key Contributions:
Effectively coordinated efforts with application development and project management staff to govern project planning and resource allocation, devise task definitions, and establish project schedules for high-profile projects involving databases.
Led, planned, and designed database changes, and maintained database configurations, data refresh, migration, and conversion.
Performed user management activities.
Managed database security compliance, and performed gap analysis.
Administered and managed WebLogic and OBIEE environments.
Performed data load using Apex Data Loader.
Assisted in building new Salesforce solutions, leveraging standard configuration and custom code to include Visualforce and Apex.
Expertise in database reorganization.
Strong development knowledge in the Apex/ORDS-related application stack, with a preference for setting up ORDS on a WebLogic Managed Server.
Experience in Oracle WebLogic, setting up managed servers, and troubleshooting performance issues.
Managing Fusion Middleware, OHS, and Oracle Reports servers.
Oracle DBA
Accenture Federal Services supporting DOD (US Air Force)
Dayton
04.2015 - 03.2016
Supported and maintained multiple production databases, Oracle applications, and report server environments for the Air Force. Planned, installed, configured, managed, troubleshot, and upgraded Oracle 10g and 11g databases on Windows OS and Linux. Researched, monitored, optimized, and allocated physical data storage for database systems. Implemented relevant network components to ensure database access, consistency, and integrity. Established and maintained Oracle database maintenance plans, and Enterprise Oracle backup, recovery, and disaster recovery strategies. Managed and maintained existing Informatica interfaces, including Data Quality, PowerCenter, Power Exchange, and ODBC connections, to ensure services remained up and running in development environments. Managed migrations, upgrades, patches, service pack implementations, and planned infrastructure maintenance and outages.
Key Contribution:
Successfully decreased the delivery time by implementing efficient, accurate measurements.
Effectively monitored all Oracle database testing, development, and production, including maintenance, upgrades, and issue resolution.
Effectively analyzed EDB360 and AWR reports, and accurately presented the reports to the management.
Properly built, modified, and administered database structures, and physical storage allocations.
Oracle DBA
Comcast Corporation
01.2011 - 04.2015
Managed 24/7 production database administration, providing ongoing support and monitoring to proactively address system errors and failures, with minimal downtime and production impact. Installed and configured Oracle 11gR2 Data Guard, 11gR2 (RAC) on ASM storage, Oracle RAC Clusters, and Oracle RDBMS on UNIX and Windows environments. Created and managed user accounts, granted and revoked required privileges, developed and managed user groups, and consulted with department managers to identify roles and access requirements. Developed SQL code, DDL, and DML scripts to implement new features, perform necessary maintenance and bug fixes, and install specified requirements. Performed extensive code reviews for the Software Development, Data Architects, and Business Intelligence teams. Consistently upgraded system functionality by installing and managing patches, and system upgrades, to maintain a bug-free environment and increase data integrity. Designed hot, cold, and RMAN backup and recovery processes, and instituted logical backup scripts to automate and streamline procedures.
Key Contribution:
Successfully troubleshot and resolved log gaps in Data Guard configuration, and maintained Data Guard physical standby databases for disaster recovery.
Database Administrator
Capitol View
Washington DC
01.2010 - 11.2010
Operated as Subject Matter Expert in developing and designing database architectures. Analyzed existing environments and reviewed proposals to determine best-case scenarios to address business needs and objectives adequately. Installed and maintained Oracle Internet Directory and Application servers and designed and configured database architectures to align with developer and user requirements. Conducted database tuning to ensure optimal performance and system availability, installed client-side Oracle on the developer and end-user PCs, and ensured network connectivity. Collaborated with developers to build and institute PL/SQL procedures, including troubleshooting database problems and failures and running test queries. Consulted with customers to outline new database features, led studies to evaluate the effectiveness and existing database methods and processes, and thoroughly investigated data loss and corruption immediately to minimize or eliminate production impact.
Key Contribution:
Effectively developed and deployed application WAR files designed by developers to fix bugs and ensure proper functionality.
Executed database performance testing using OEM functions and ran diagnostic reports using ADDM and AWR.
Oracle DBA
Eagle Plus, Inc.
Sterling
07.2009 - 01.2010
Administered, installed, configured, maintained, and supported the Oracle Relational Database Management System, troubleshot system failures, identified root causes, and implemented technical solutions to minimize system downtime. Developed backup and recovery procedures, tuned the data, installed software upgrades, monitored database activity and file usage, and removed obsolete files and processes to allocate resources for proper functionality. Utilized DBCA to create and DBUA to upgrade Oracle databases, Oracle on UNIX, Linux, Windows servers, and Oracle databases. Performed routine database backup using RMAN, executed programs, generated reports, moved files, and tuned system performance.
Key Contribution:
Properly built, modified, and administered database structures, and physical storage allocations. Maintained data dictionaries, and performed daily incremental backups and full weekly backups using the Oracle backup utility.
Education
Bachelor of Science - Mechanical Engineering
University of District of Columbia (UDC)
01.2012
Skills
Platforms: UNIX (Linux and Solaris), Windows (95, XP, 2000 Server, 2003 Server, Vista)