Senior Oracle Database Administrator Resume
Atlanta, GA
SUMMARY:
A senior - level Database Administrator, with certification, and with significant experience in all facets of database administration: data architecture, database design and implementation, database performance tuning, application development, and more. This experience was gained in high-profile systems development and production environments for large and small businesses.
SKILLS/KNOWLEDGE:
- Oracle database administration (Oracle Certified Professional DBA)
- Oracle 8, 9, 10, 11g, 12c
- SQL Server administration
- Oracle Enterprise Manager (OEM) Grid Control
- Oracle Recovery Manager (RMAN)
- Oracle Real Applications Cluster (RAC)
- Oracle Data guard
- Oracle Golden Gate
- Oracle Application Express
- Oracle Application Server (OAS) administration
- Logical and physical database design
- Data Architecture
- Database performance tuning
- SQL and PL/SQL
- DB2 database administration
- UNIX administration and shell scripting
- ksh, csh. bash command shells
- Automatic Database Diagnostic Monitor (ADDM)
- Data Masking
- Development, Test and Production Data Management
- SCCM
- VMWare
- Automatic Workload Repository (AWR)
- ETL
WORK EXPERIENCE:
Confidential, Atlanta, GA
Senior ORACLE Database Administrator
RESPONSIBILITIES:
- I supported Development and Test systems mostly, but was also called on for Production issues. There are 10-20 PL/SQL developers here, and each one has his/her own Oracle instance.
- I created instances, modified and maintained instances, imported and exported application data, and provided PL/SQL support for product code.
- Extensively worked on oracle wallet and advanced security.
- Also have a sound knowledge and hands on experience in working with data guard.
- I provided support for Oracle Streams and Golden Gate, and for IBM’s CDC (Change Data Capture). I was part of the team that upgraded Oracle from version 10 to version 11. Confidential switched this past year from Oracle to DB2.
- I supported in performing the database restores
- Worked continuously on rman backups and also have the hands on experience in taking and resolving rman backups.
- Sound and good working knowledge on oracle tuning
- Worked extensively on LINUX platform
- Also worked on WINDOWS platform.
- I also worked on ORACLE cluster ware platform, also have understood how basic clustering services at operating system level enables oracle software to run in the cluster mode.
Confidential, Atlanta GA
Principal ORACLE Database Administrator
RESPONSIBILITIES:
- I supported internal Oracle and DB2 databases for development and testing.
- I supported the database creation portion of the product install process, and
- I supported customer databases for the Customer Service and Professional Services teams.
- This support included RAC one-node, performance tuning, problem resolution, ETL, and product implementation.
Confidential, Atlanta GA
Principal Consultant
RESPONSIBILITIES:
- I performed problem analysis and resolution, and database object creation and maintenance.
- The work was on Oracle versions 8, 9, 10, and 11, and required familiarity with performance tuning, database monitoring, RMAN backup methods, Unix shell scripting, OEM, and more.
Confidential, Atlanta GA
Senior Database Administrator
RESPONSIBILITIES:
- As the sole Oracle resource I managed development, test, and production databases running behind the company’s Web-based Auto Auction clearinghouse.
- I performed PL/SQL development to support the application’s business logic.
- I kept the database tuned for optimal performance and monitored status for potential problems.
- I implemented RMAN as backup and recovery solution and participated in the setup of a Disaster Recovery site.
- I upgraded all company databases from Oracle 9 to Oracle 10g.
Confidential, Duluth GA
Database Manager
RESPONSIBILITIES:
- Managed databases for the company’s Video-On-Demand (VOD) system reporting tool, running at customer sites in USA and Canada.
- I assisted with product development in SQL and PL/SQL.
- I administered and supported Linux OS on the VOD reporting hosts.
- I also supported internal tools including a helpdesk ticket system and a customer information system.
Confidential, Atlanta GA
Senior Database Administrator
RESPONSIBILITIES:
- Consultant working at Verizon Business in Alpharetta GA. I managed corporate databases running Oracle versions 9 and 10.
- I administered and supported RMAN, Oracle Enterprise Manager on Oracle hosts running Solaris, HP-UX, and Linux.
Confidential, Statesboro, GA
Senior Systems Support Specialist (and full-time graduate student)
RESPONSIBILITIES:
- Managed Oracle versions 8, 9, and 10 databases running on Solaris.
- Supported Oracle Application Server (OAS) versions 9 and 10, running Oracle Forms-based and intranet-based applications.
- Supported Banner Student Information System. Installed and configured OEM Grid Control for database and host monitoring and management.
- Installed and configured Oracle mid-tier application server, including Oracle Identity Management, Single Sign-on, and Certificate Management.
- Installed, configured, and implemented an RMAN-based backup strategy using Grid Control and Unix shell scripts.
- Supported development team by providing SQL and PL/SQL review.
- Implemented a high-availability solution using Oracle Dataguard.
Confidential, Atlanta, GA
Database Consultant
RESPONSIBILITIES:
- Migration of legacy Oracle database to local server.
- Design of new SQL Server 2000 database for re-engineered application.
- Migration of data from Oracle to SQL-Server.
Confidential, Atlanta, GA
Senior DBA and Data Services Manager
RESPONSIBILITIES:
- I setup and configured the database environment.
- I managed the databases and data-related functions for an internally-developed internet site, for an internal call center application, and for company administrative systems.
Confidential, Atlanta, GA
Lead DBA and Data Services Manager
RESPONSIBILITIES:
- I designed, built, and managed Oracle databases, including the Confidential product catalog.
- I helped design and implement a database for BellSouth’s locally-focused internet portal.
- Designed and implemented database solutions for external BellSouth customers.
- Supported the sales team on RFP responses and on pre-sales communications.
Confidential, Atlanta, GA
Senior Internal Consultant and Senior DBA
RESPONSIBILITIES:
- I provided systems expertise and advisement to Confidential internal business units.
- As a Lead DBA I managed Oracle databases for several commercial credit-related products.
- I redesigned the database for the primary product as part of an application re-engineering.
- I was responsible for monitoring, maintenance, and tuning as well as front-end reporting.
- I was also responsible for data administration, pre and post-sales support, and business analysis.