Post Job Free

Resume

Sign in

Database Administrator Data

Location:
Gaithersburg, MD
Posted:
June 16, 2023

Contact this candidate

Resume:

CLEARANCE AND CERTIFICATIONS

●Active U.S Top Secret Clearance

●Oracle Certified Professional

●SQL Fundamentals

●Security Plus SE +

●AWS Certified Database -Specialty

SUMMARY

Summary: An accomplished database administrator (DBA) with over 6 years of experience in Oracle Database Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and

Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, RAC, Data Guard, Golden Gate, AWS, Oracle Financial. Excellent written, verbal, analytical and organizational abilities; proven leader with motivational management style, development of innovative solutions; results-oriented achiever with excellent track record for identifying opportunities for accelerated growth; dedicated team player who listens, thrives on collaborating with diversely talented team members, and integrates their divergent thoughts, opinions, and perspectives into meaningful action; energetic, competitive achiever who can successfully manage multiple priorities and perform under pressure in a fast-paced, rapidly changing environment.

QUALIFICATION HIGHLIGHTS

Experienced in data encryption using Oracle TDE to protect the organization’s critical information and exceeding the industry standard.

In-depth understanding of security and backup procedures to ensure database integrity.

Experience with various tools, such as SQL_Server, SQL, RMAN, PL/SQL and Oracle Enterprise Manager, ETL tools, Cloud EC2, RDS, IAM services, Setup AWR, Agile Methodologies.

Setting up Cronjobs, monitoring and refreshing Golden Gate, OEM, WebLogic.

User Management, creation, monitoring and management of database users.

PROFESSIONAL EXPERIENCE

DMI Corp. (Prime Contractor at Department Information Systems Agency Project) Fort Meade

Database Administrator June 2021– Present

Used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Setting up the Automation of the Data Quality refresh of the database.

Upgrade Oracle 12c to Oracle 19c to EC2, RDS, IAM services.

Load Oracle database products, utilizing RAC.

Implement security measures for computer or information systems.

Implemented database security using Oracle's Transparent Data Encryption based on Database.

Applied PSU/SPU Patches as a part of maintenance activity.

Hardening databases Systems for Security Technical Implementation Guide (STIG) developed by Defense Information Systems Agency (DISA).

Manage all JIRAs tickets from creation to closing. Manage ServiceNow system.

Perform Oracle Golden Gate maintenance, monitoring and troubleshooting.

Participate in Oracle Golden Gate STIG.

Creates and maintains database schemas and users privileges.

Develop guidelines for system implementation.

Coordinate project activities with other personnel or departments.

Monitoring the health of a database administrator with Weblogic OEM (Oracle Enterprise Manager) 11g/12c.

Collaborate with vendors to introduce new DBA related technology and troubleshooting.

Monitoring the health of a database and ensuring that it performs optimally is an important task for a database administrator with OEM (Oracle Enterprise Manager) 11g/12c.

Use Remedy ticketing system and Service Now to address users’ tickets.

Write SOP for systems functional and for procedures.

Creating and resolving JIRA’s tickets in Argyle Methodology, and use Service Now to create new tickets.

Reviewed users accounts inactive, provisioned roles and segregation of duties.

Vantraq Corp. (Subcontractor at State Department Project) Washington, DC

Database Administrator March 2019– June 2021

Provided analysis of legacy data, archiving, retention, deleting and cleansing the data.

●Maintained, stored, & managed data including.

●Supported troubleshooting of data problems and reconcile data anomalies.

●Built Oracle tablespaces, executed commands and applied SQL queries for database.

●Created and maintain processes and standards documents.

●Performed appropriate procedures to perform recovery of system.

●Data Guard expertise for Data Migration and failover.

●Implemented backup and recovery operations within SQL Server.

●Installed and configured OEM to monitor databases issues.

●Working alongside Tier 2 & Tier 3 support teams. Experience within Data Warehouse, ETL.

●Reduced SQL processes runtime in second. Tuned multiple databases and Application such as Oracle databases, Sql Server and other applications.

●Worked on both Window NT and Window 2008/2010 platforms, Sql server 2014, 2012.

●Support includes performing backups, adding users, and refreshing databases using Datapump.

●Applied Oracle patches, MS patches, monitored databases, upgrade SQL server instances from 2005 to 2008.

●Setup sql server backup. Set process to clean sql server logs. Monitor sql server performance of the database. Configure sql server mirroring. Refresh test and development databases as needed.

●Support server, database, and security administration needs on Windows 2000 and SQL server.

●Granting roles and privileges to end users.

●Implemented Oracle Fusion Middleware and BI reports for higher managers.

CSC (Prime at TSA Project), Pentagon City, VA

Oracle Database Administrator Sep 2018- March 2019

Good knowledge on Logical and Physical Data Modeling using normalization techniques.

Experience with Data flow diagrams, Data Dictionary, Database normalization theory techniques, Entity relation.

●Monitored Oracle WebLogic 11g, single host clustering and multiple host clustering, started and stoped Node manager

●Start and stop Web logic Node Manager.

●Establishes user needs and monitors database performance, users’ access, and security.

●Responsible for quarterly patches, /maintaining/monitoring/upgrading the production and test

Databases.

●Table space monitoring, Performance monitoring and tuning for performance improvement.

●Set up, monitor, tune, and administer PeopleSoft environment systems.

●Provide database support to eTAS Release 2.0 Kronos-Workforce Central (WFC) 6.3 Upgrade following the build document.

●Logical Volumes layouts, Disk layouts and Capacity planning

●Test backups. Test recovery by forcing database crashes.

●Perform database tuning by reviewing AWR & ADDM reports, implementing SQL profiles and baselines, designing table and index partitioning and coalescing of database objects for faster query performance. Include memory, I/O, contention, and SQL statement tuning.

●Migrated data from Oracle 10g R2 database on UNIX to Oracle 11g on a Linux platform.

●Provide Oracle Database Administration support and troubleshooting, including install Oracle Software, patches and upgrades.

Micros System Columbia MD,

Oracle Database Administrator Sep 2006- March 2008

●Participated in system administration and operational support.

●Reviewed and analyzed system logs and problem reports, adds, changes, backups, and file restores.

● Monitored Concurrent Managers of the system's performance and capacity planning.

●Installed, patched, upgraded tuned and maintain the Oracle E-business Suite 12i and 11g/12c Oracle databases.

●Troubleshoot and start concurrent Managers.

EDUCATION/CERTIFICATIONS

Master’s in Business Management/Business Intelligence, University of Maryland, Robert Smith School of Business.

Bachelor of Science (BS) in Computer Sciences, Strayer university, Washington DC

*References available upon request



Contact this candidate