Phone :443-***-**** Email:email@example.com
Seasoned database administrator with extensive professional work experience in securing the integrity of Oracle and SQL Server databases. Profound in the administration, installation, upgrading, configuration, maintenance, and troubleshooting of databases. Background experience involves working with technical teams to design, test, code and support next generation solutions for our company. Proven the ability to champion the implementation of updated versions of Oracle/SQL Server products to enhance the workplace productivity. I’m a competitive achiever who can successfully manage multiple priorities, willing to work, and perform under pressure in a fast-paced, rapidly changing environment. Experienced in maintaining high quality standards to meet the challenges of this “frenzied” and high turn-over industry. My core strengths are in the areas of:
Oracle 11g and 12c database administration on Linux and Windows platforms
MSSQL Server 2008, 2012 database administration on Windows Server
Database Duplication, Migration, Refresh, Upgrade and Patch application
Physical (RMAN) and Logical (Expdp/Impdp) database backup, restore, and recovery
Performance turning (Proactive and Reactive maintenance)
Administering and Managing RAC, ASM, RAID & Data Guard
Capacity planning, sizing applications and server hardware
User and security management
Assisting developers with application design
Collaborating with vendors, end users, and other support groups
RDBMS: Microsoft SQL Server (2008, 2012), Oracle (11g, 12c)
Operating Systems: Linux/Unix (RED HAT LINUX), Windows (2008, 2010)
Tuning utilities/Oracle Concepts: Oracle Enterprise Manager, Dataguard, SQL Plus, Data Pump, RMAN, ADDM, Oracle Jobs, Flashback, Oracle Recycle Bin, Oracle Advanced Queuing, Oracle Streams, SQL LOADER
Quest Diagnostics, Chantilly, VA (Feb 15 - Present)
Oracle 11g, 12c
Roles and Accomplishments:
Configure databases for recoverability
Manage Oracle 11g RAC database using CRSCTL and SRVCTL
Manage RAC database on ASM storage
Apply critical patch updates on RAC database using OPatch auto
Manage Oracle 11gR2 data guard
Worked with DBA team to migrate 12T of data from 11g to 12C (VLDB)
Troubleshoot and resolve log gap in data guard configuration
Validate RMAN Backup, restore and recovery of database physical files
Perform Database refresh using Export and Import Data Pump
Create database links to enhance developers
Performance tuning of databases with optimizer, AWR, ADDM, explain plan and advisory frameworks
Tune slow running queries
Reverse engineering of database schemas into physical and logical models
Performed operation and maintenance tasks at O.S and database level
Monitor Sessions and resolve lock issues
Manage PL/SQL stored procedures, triggers and packages
Collaborate with developers to investigate database issues and execute scripts
Document database structure, changes, problems, issues for future reference using one note
Work with developers/analysts on troubleshooting issues.
Provide database security measures by creating and assigning appropriate roles and privileges to users.
Generate object comparisons between databases.
Provide solutions and maintain the database for troubleshooting by using trace files, and alert logs.
Daily incremental backup and weekly full backup of databases using RMAN.
Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and running scripts given by the clients.
Routine database clean ups, removing old trace files/ archived logs.
Monitored and resolved issues that appear in production environment
Table space monitoring, performance monitoring and tuning for performance improvement.
MSSQL SERVER 2008/2012
Routinely monitored Server activity, error log and space
Schedule backup using Full, Differential and Transactional log backup process
Deploy SSIS packages
Perform database refresh from higher environments to lower environments
Manage security scheme for the database environment
Monitor Job logs and manually execute failed jobs
Monitor SQL server agent
Vector Security, Hanover, MD (Dec 13-Feb 15)
Jr. Oracle DBA
Roles and Accomplishments:
Install the Oracle client and server software and configuration
Configuring Backup (RMAN) for database and database recovery/restoration.
Database Links, Creating, Managing Tablespaces and Datafiles.
Load and transfer data using Data pump and SQL Loader utilities.
Set up and manage database security by creating new users, roles, profiles, and
provide required user privileges
Managing schema objects
Regular monitoring alert log files and trace files on day to day basis
Configure and implement the use of Oracle Recovery Manager (RMAN)
Moved data from one database to another using transportable tablespace
Granting roles and privileges to end users.
Implement multiplexing of control files and redo log files
Performed Oracle CPU Patch using OPatch.
Monitor Tablespaces and Datafiles
Loading data into database tables using SQL Loader.
Implemented Materialized views, database links.
Responsible for quarterly patches, /maintaining/monitoring/upgrading the production and test databases for products.
Responsible for the administration of highly available web logics database solution supporting over 70 concurrent users.
Administer databases using SQL Server Management Studio (SSMS).
Provide on-call support to production environments (sometimes wknds)
Work in a team environment and provide hands on experience sharing to DBA team
Managing, troubleshooting and resolving Oracle database and application issues.
Allied Barton, Columbia, MD (Jan 13-Dec13)
Jr. Oracle DBA
Roles and Accomplishments
Monitor, tune, and supporting day-to-day activities of the production, testing and development databases; then work on urgent issues and resolve them based on priority.
Collaborated with managed service providers, internal development team, consultants and Oracle Support.
Assist users with request such as creating tables, accounts, and users.
Assist on the development, test, and production of database support.
Assist/Monitor database management on 11g OEM (Oracle Enterprise Manager)
Develop and implement database queries.
Attended Oracle Identity Management training. (Tues, Thurs)
Oracle: SQL Fundamentals 11G
Oracle: 11g Database Administrator Certified Associate (OCA)
Prince Georges Community College: Aug 06-May 09 (General Studies)
Coppin State University: Aug 09-May 10 (Mass Communications)
Graduate School of Washington DC: June 11- Dec 11 (Clinical Lab Science)
DBA/Oracle Tutoring in Laurel MD: Jan 17 - Present
Reference upon request