We provide IT Staff Augmentation Services!

Lead Senior Oracle Dba Resume

3.00/5 (Submit Your Rating)

Atlanta, GA

OBJECTIVE:

To work in a Senior Oracle Database Administrator role where my acumen in information systems and database management can be utilized in enhancing and developing database management systems.

SUMMARY:

  • Demonstrated expertise in database architecture, administration, tuning and maintenance of production and development databases on various RDBMS platforms including Oracle, MongoDB, SQL Server and Teradata.
  • Oracle Certified Professional Database Administrator.
  • Bachelor of Science in Computer Information Systems.
  • Bachelor of Science in Telecommunications Management.

­­­­­­­­­­

EXPERIENCE:

Confidential, Atlanta, GA

Lead Senior Oracle DBA

Responsibilities:

  • Responsible for interacting with development team to identify and resolve performance issues in core domestic and international Digital Life Oracle 11g and 12c database environments.
  • Communicates ongoing project statuses and strategic direction for database management to senior leadership.
  • Performs database migrations from 11g to 12c as well as builds pluggable 12c infrastructure for new 12c instances.
  • Built and manages OEM 12c environment to control all db environments including test,development,QA and production.
  • Architected and installed Mongodb 2.7 in dev, test, qa and production cloud based environments for analytics data warehousing application.
  • Responsible for working with system engineers to plan hardware and memory requirements for Mongo DB installation footprint in Confidential & Confidential ’s private cloud infrastructure..
  • Worked with vendor team and Mongodb subject matter experts to architect Big Data solution from planning to implementation phase.
  • Installed and configured On - Premise installation of Mongo DB Management Service for monitoring, alerting and backups of Mongo DB database environments.
  • Oversees business critical Digital Life core Oracle 11g database environment.
  • Manages bi-directional replication of Oracle 11gR2 databases across multi data center environments by utilizing Oracle 11g Golden Gate 11g.
  • Performs database related code reviews and works with testing team to ensure scalability of new releases.
  • Monitors and updates Golden Gate extracts and replicat definitions as necessary to enhance performance.
  • Participates in weekly on-call rotation to provide 24x7 support for all production databases (Oracle and Mongo DB)
  • Strives to drive overall cost lower for database performance, data conversion and administrative services
  • Applies patches (CPU/PSU) as necessary per recommendations.

Confidential, Atlanta, GA

Lead Senior Production Oracle DBA

Responsibilities:

  • Responsible for troubleshooting and resolving day-to-day performance impacting issues in production environment.
  • Identified performance bottlenecks and liaised with development team to coordinate and implement database solutions and enhancements.
  • Configured and installed disaster recovery solution using Oracle 11g Data Guard in multi-node Oracle 11gR2 RAC environment.
  • Developed and documented solution to enhance application availability by implementing Active Data Guard.
  • Completed project to upgrade mission critical customer databases from Oracle 10gR2 to Oracle 11gR2 in multi-node RAC environment.
  • Participated in on-call rotation to manage business-critical monthly invoice billing application.
  • Assisted application DBA team in identifying performance bottlenecks and provided resolutions via alteration of database objects and database parameters to enhance and improve overall database performance.
  • Responsible for architecting monitoring and alerting solution using Oracle 11gR2 Enterprise Manager.
  • Architected solution to migrate Enterprise Manager 11g to Enterprise Manager 12c.

Confidential, Atlanta, GA

Senior Oracle DBA/Architect

Responsibilities:

  • Participates in 24/7 oncall support rotation to ensure high availability for business critical databases.
  • Works closely with developers and analysts to trouble shoot and resolve database performance issues as well as assist with designing and architecting new database environments.
  • Performs weekly reviews of assigned instances to identify bottlenecks and make recommendations to improve performance.
  • Addresses application issues reported by portfolio analysts through diagnosis via AWR reports, wait events, etc.
  • Works with developers to design and implement data models for new projects and application enhancements.
  • Selected by principle DBA to plan cross platform strategy and perform work to migrate 10g database environments from Solaris 10 to Linux.
  • Installed and configured disaster recovery system in multi-node RAC environment using Oracle 11gR2 Data Guard.
  • Performed installation and configuration of Oracle Golden Gate in development environment for proof of concept testing and promoted to production.
  • Tasked with performing installations, upgrades and maintenance (data refreshes) as required to support database infrastructures.
  • Participating in enterprise level project to migrate existing databases from previous versions (9i, 10) to Oracle 11g.
  • Tasked with managing data masking of production data through use of dbms obfuscation toolkit and Enterprise Manager Data Masking Pack
  • Responsible for troubleshooting and managing customer database environments utilizing Oracle Streams.
  • Planned project and performed upgrade of Enterprise Manager Grid Control 10g to 11g and migrated clustered OMS servers to new hardware.

Confidential, Roswell, Georgia

Lead Senior Oracle DBA & Architect

Responsibilities:

  • Created data center migration plan for production infrastructure and developed disaster recovery plan
  • Presented plan to chief technical officer for database migration utilizing RMAN duplication.
  • Developed plan for disaster recovery by implementing a physical standby database through use of Oracle Data Guard.
  • Documented and tested plan for disaster recovery to perform switchover or failover in case of maintenance or emergency.
  • Managed and mentored Junior DBA staff to increase the skillset in database managed & administration.
  • Tasked with managing DBA staff as well as participating in on-call duties and daily DBA activities for all production and non-production database environments.
  • Designed and built OLTP database environment utilizing Oracle 11.1.0.6 for mission critical web application
  • Installed and configured Oracle 11g Real Application Clusters on Sun 4600s.
  • Setup and configured Physical standby database in remote data center utilizing Oracle 11g.
  • Implemented proactive database monitoring through use of Oracle Enterprise Manager Grid Control 10.2.0.5.
  • Liaised with project management team to deliver project statuses and addresses problem or concerns pertaining to database architecture, support and maintenance.
  • Participated in various full life-cycle projects such as database build, upgrade, migration, conversion, performance regression testing and application releases.
  • Architected and constructed Oracle 10g Data Guard Physical Standby environment for business-critical production databases to offsite remote location for disaster recovery.
  • Redesigned and implemented new pre-production environment using Oracle 10g release 2 (10.2.0.3) Real Application Clusters on MS Windows 2003 and Oracle 11g release 1 on Linux consisting of Development, Quality Assurance and Staging databases:
  • Planned and configured all back-end storage configurations for new 10g and 11g RAC environments on EMC CX3 and Clariion SAN disk arrays.
  • Installed and configured Oracle 10g and 11g Real Application Clusters on HP ProLiant BL680c G5 blade servers.
  • Migrated existing pre-production environments to new storage and db environment using RMAN duplication.
  • Devised and configured new backup and recovery strategy using RMAN.
  • Initiated plan to document and organize all database environments
  • Researched and formulated proposal for purchase of ERD software.
  • Reverse-engineered all production and non-production databases into ERDs using Toad Data Modeler to allow development team to have better understanding of database layout.
  • Generated reports for Senior management detailing gaps and/or errors in data structures that could be revamped or removed from databases.

Confidential, Alpharetta, Georgia

Senior Oracle DBA

Responsibilities:

  • Selected by Senior VP of Operations to develop and oversee cross-functional infrastructure team to manage and shore up requirements for tier-one international customer:
  • Developed technical workshop to address European customer’s concerns and finalize service level agreements.
  • Put together “follow the sun” support model to provide support and maintenance for European customer during their business hours; Traveled internationally (France) to reengage service level commitment and host technical workshop for system re-architecture for Tier 1 customer.
  • Spear-headed and successfully implemented projects for process improvement in the areas of change control management and database administration: redesigned enterprise-wide procedures to improve internal change control processes.
  • Successfully migrated mission critical databases (production, staging and development environments) from Oracle 8i to Oracle 10g release 2.
  • Implementing Oracle Enterprise Manager, centralized database management tool to allow DBA staff to better monitor and manage all production and non-production database environments.
  • Provides operational database support and tuning for customer databases.
  • Responsible for backup/recovery via RMAN for all customers using recovery and non-recovery catalog methodologies using Oracle versions 9i and 10g.
  • Tasked with providing a high-level of database support to a diverse multi-national client base.
  • Participates in on-call rotation for after-hours support of all production customer databases.
  • Architects plans for customer database projects: complex migrations, RAC configurations, installations.

Confidential, Atlanta, Georgia

Senior Oracle DBA

Responsibilities:

  • Provided 24 / 7 availability and uptime for all mission critical databases through:
  • Supported rotational on-call schedule and responding promptly to issues effecting database performance and availability.
  • Hands-on expert level knowledge in configuring and implementing multi-node Oracle Real Application Clusters environments using HACMP and raw devices on AIX 4.3.3 and AIX5.2L
  • Controlled and monitored user access to production and development databases.
  • Installed and upgraded Oracle software and application tools (patches, migrations, installations).
  • Managed user accounts and maintaining system security.
  • Assisted in development and planning of disaster recovery procedures.
  • Strong knowledge of Oracle Enterprise Manager; Implemented and managed Oracle Enterprise Manager to monitor 60+ production and non-production databases ranging in sizes from 800MB to 2TB in single instance and RAC environments.
  • Provided application support to developers by participating in database design / modeling, data refreshes, object creation and modification and SQL tuning.
  • Responsible for leading change management effort to ensure all changes and modifications to databases are documented and implemented through change management processes and procedures.
  • Acted as lead database administrator for supporting several business-critical back end applications; Provided DBA support and administration for Vitria Business Process Applications.
  • Well-developed understanding of Oracle architecture, backup/recovery and common utilities.

Confidential

Senior Programmer Analyst

Responsibilities:

  • Developed ETL process to load and migrate data from corporate data warehouse to regional data marts.
  • Tuning of stored procedures and application code in production/development environment for both SQL Server clusters and Teradata.
  • Migrated mission critical application structure from BTEQs and Multiloads to Teradata stored procedures, functions and macros.
  • Using Erwin, assists in the design of corporate and regional data models from logical design to physical implementation.
  • Ensures integrity and compliance between test and production databases by performing data refreshes and tracking database object modifications.
  • Worked closely with clients through all phases of software development life cycle to design and deploy back end applications.
  • Tasked with defining architecture for multi-tiered application environment.
  • Used Oracle Parallel Server and SQL Server clusters to design and develop data marts as well as write views, stored procedures and complex queries for various back end client applications.
  • Used Active Server Pages along with VBScript and Javascript to assist in developing front-end applications for all end-user systems through use of Microsoft FrontPage.
  • Used Erwin data modeling tool to engineer, construct and analyze data models for implementation into production SQL Server and Oracle environments.

Network Engineer Switching & Signaling Operations

Confidential

Responsibilities:

  • Maintained throughput for all ATM data Confidential 99.999% or greater.
  • Responsible for cell and packet analysis to determine most efficient routing path for ATM and Frame Relay traffic.
  • Worked in collaboration with fellow engineers to test, turn-up and install new network elements.
  • Worked tenaciously in conjunction with ATM Network Operations Control Center to quickly resolve network-impacting issues.
  • Constantly reinvented methods for troubleshooting to aid in the development of process improvement.
  • Tasked with tuning, and maintaining core and edge commercial ATM switches

Internet Application Developer

Confidential

Responsibilities:

  • Developed web application using ASP, Java and VBScript to effectively track video-conferencing calls logged.
  • Created customized web reports for senior management to serve as a tool for tracking daily business practices.
  • Acted as interim application database administrator; Supporting both SQL Server and Oracle environments. Assisted developers by tuning SQL queries as well as migrating “production-ready” applications from staging to production environment.

We'd love your feedback!