Lead Senior Oracle Dba Resume
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.
