Manager/lead Database Administrator Resume
2.00/5 (Submit Your Rating)
Atlanta, GA
SUMMARY:
- 20+ yrs of Database Administering: Install, configure, operation and maintenance Oracle 9i/10g/11g/12c databases for single instances and on RAC environment on AIX, Solaris SPARC, HP - UX, Linux and Window server platforms
- Full life cycle experience on software projects wif a strong process oriented approach
- 20+ yrs of experience in configuring database Archivelog/Noarchivelog mode, auditing, flashback technologies, restore and tune databases and Recovery Manager (RMAN) backup and recovery
- Aptitude for analyzing, identifying problems, and propose alternative solutions, devise plans to eradicate problems
- 10+ yrs of experience wif Real Application Cluster (RAC)
- 10+ yrs of experience wif ORACLE Automatic Storage Management (ASM), Data Guard
- 10+ yrs of experience wif Oracle Enterprise Manager
- 10+ yrs of experience wif Weblogic Middleware
- 10+ yrs of experience wif SQL Server
- 5+ yrs of experience wif MySQL
- 3+ yrs of experience wif Postgres
- 2+ yrs of experience wif Mongo DB
- 3+ yrs of experience wif Netezza/IBM Pure Data
- 2+ yrs of experience wif Amazon Web Services (AWS) using RDS for migrating and deploying
- Experience in using SQL*Loader, Oracle native Export/Import, and new features Data Pump Export/Import utilities
- 4+ Knowledge of teh Oracle Gloden Gate installation, configuration, troubleshooting GG issues
- Experience in using SQL*Loader, Oracle native Export/Import, and new features Data Pump Export/Import utilities
- Experience in using TOAD 9.x and Oracle SQL Developer 1.2 tools
- Capable of implementing Oracle procedures, functions, and triggers
- Experience in applying family, critical patch update (PSU), and individual patch sets software upgrades for Oracle database server and Application server
- Ability to response quickly, clearly and work accurately under pressure… ITIL and Agile savvy
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
Manager/Lead Database Administrator
Responsibilities:
- Support day to day database production support issues
- Design, implement and support database from single instance to three node cluster wif data guard options
- Direct performance tuning monitoring and threshold alerts
- Define team roles and responsibilities
- Responsible for career development/planning, performance and pay discussions of team members
- Contribute to policy/program development
- Gather organizational metrics, analyses data and reports business impact to senior management.
- Completed Oracle Exadata X-6 business case and deployment of two Exadata machines
- Manage on-call support.
- Disaster Recovery implementation using remote standby databases using 11g Data Guard.
- Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
- Configuration and Administration of Active Data Guard environments.
- Supported migrations to Exadata platforms including leading efforts for RAT testing.
- Worked through identifying regressed SQL and tuning queries on Exadata.
- Mentor DBAs wif company best practices and technical guidance.
Confidential, Atlanta, GA
Sr Database Administrator
Responsibilities:
- Administration and management of teh entire development, QA and production environment.
- Document current Grid Control architecture.
- Patched and upgraded current Grid and RAC environments from 10.2 to 11.2.
- Working plan to implement Oracle 11g Data Guard Physical Standby and RMAN Solutions.
- Work wif client’s DBA to implement Data Warehouse Migrations from 9i to 11g Real Application Clusters.
- Deployed Gloden gate solution to off load reporting queries from heavy transactional production database using MySQL and Oracle 11g.
- Worked on Gloden Gate setup and issue tracking and resolutions wif Oracle support.
- Installed and configured MySQL on Linux environments.
- Performed installation, new databases design, configuration, backup, recovery, security, upgrade and schema changes, and tuning.
- Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
- Worked wif teh engineering team to implement new design systems of databases used by teh company.
- Effectively configured MySQL Replication.
- Performance Tuning on a daily basis for preventing issues using MySQL Enterprise Monitor and Oracle Cloud Control.
- Preformed data integration for high level telecom project using MongoDB.
- MongoDB administration and management
Confidential, Atlanta, GA
Sr. Systems Consultant
Responsibilities:
- Investigate current state of each of teh production database instance and operating system (Solaris 10).
- Document current system architecture and system diagnosis information.
- Present a work plan to upgrade oracle RDMS from 9.2.0.5 to 10.2.0.2.
- Perform proactive monitoring on all production database instances.
Confidential, Atlanta, GA
Oracle DBA
Responsibilities:
- Proactive Monitoring 24x7 of all production and development 10g databases.
- Investigate current state of each of teh production database instance and operating system (Red Hat Linux).
- Support Java Messaging Service (JMS) production database monitor and administer JMS queuing.
- Create and Maintain RMAN instance and catalog to maintain all production databases to insure Disaster Recovery.
- Create and Maintain Bash scripting to maintain all production databases to insure availability.
- Patched and upgraded current single instance and RAC environments from 10.2.0.1 to 10.2.0.2 and 10.2.0.3.
- Build Development two-node cluster using 10g RAC using ASM on raw devices
- Review Oracle PL/SQL based triggers and procedures and identify resource intensive logic.
Confidential, Atlanta, GA
Responsibilities:
- Proactive Monitoring 24x7 of all production and development 10g databases and operating systems (RH Linux).
- Patched and upgraded current single instance and RAC environments from 10.2.0.1 to 10.2.0.2.
- Migrated production database from single instance to Real Application Cluster using 10g Data Pump.
- Review Oracle PL/SQL based triggers and procedures and identify resource intensive logic.
Confidential, Atlanta, GA
Responsibilities:
- Production system performance stabilization (Oracle 8 on Windows 2000 Server).
- Proactive monitor installation and configuration.
- Investigate current state of each of teh production database instance and operating system.
- Backup and recovery strategy.
Confidential, Atlanta, GA
Responsibilities:
- Proactive Monitoring 24x7 of all production and development 10g databases and operating systems (RH Linux).
- Patched and upgraded current single instance and RAC environments from 10.2.0.1 to 10.2.0.2.
- Evaluate current 10g Data Guard configuration and provided vital input to bring configuration up to speed.
- Created multiple 10g single instances using EXT3 file systems as well as ASM.
Confidential, Alexandria, VA
Oracle DBA Consultant
Responsibilities:
- Perform various daily Oracle DBA functions including security and data fault tolerance for critical Department of Defense application.
- Help ensure data integrity, perform and maintain 10g Application Server and Oracle Forms.
- Perform development and enhancement work using CMMi / CMM Life Cycle processes using Version Manager and Tracker.
- Support PL/SQL development team by identifying poor performing SQL statements and identifying most effective execution plan.
- Migrating applications from Oracle rule-based to teh Oracle cost-based optimizer environment
Confidential, Austin, TX
Oracle DBA Consultant
Responsibilities:
- Work in a consistently complex and intricate environment. Doing independent \analysis using complex judgment based on advanced analytical thought. I successfully worked in a team environment maintaining a positive and professional relationship wif all Dell and non-Dell employees.
- Provide production support, maintain and manage over 400 production databases across Dell worldwide using Oracle 10g grid technology.
- Assists another DBA’s in migrating old oracle 8i to 10g clusters, which include installing, patching and tuning
- Support and implement Oracle's Cluster Ready Services, Data Guard, 9i and 10g Real Application Cluster environments up to 6 nodes and RMAN scripting at teh enterprise architecture level using Oracle Enterprise Manager.
- Work wif variety of Oracle environments that include Sun using HPUX, Linux, Solaris, and Windows 2000 / XP.
Confidential, Tampa, FL
Director
Responsibilities:
- I had direct accountability for all IT functions wifin teh corporation including; outsourcing administration, help desk, LAN and WAN administration, training, voice and data integration, capacity and performance planning, systems design, and technology assessment.
- Arranged and administered teh annual corporate IT budget, monitored all expenditures, and arranged requisitions and purchase orders.
- Managed all functions, real-time network of 100+ on and off site users, and over 10 million in capital equipment.
- Implemented and deployed PeopleSoft Financials applications, GL, AR and AP modules.
- Design, develop, test, document, and deploy PeopleTools, PeopleSoft Internet Architecture, and related components.
- Facilitate overall development and quality assurance (QA) efforts associated wif upgrade and customization of PeopleSoft ERP applications.
- Led Peoplesoft Financials upgrades, involving data warehousing, migration, and reconciliation
- Responsible for monitoring major database upgrade project and external vendor activities.
- Designed/implemented WAN for nationwide network utilizing dedicated lines and router-to-router VPN tunnels.
- Trained technical staff in all areas of networking and computer/software support.
- Provided support to 100+ remote users in time critical environments. Developed and deliver end user training programs.
- Interacted and communicated daily wif teh Chief Financial Officer, Chief Executive Officer, Department Heads, employees, subordinates, consultants and vendors to insure clear open commutation channels.
- Redesigned existing network infrastructure to add redundancy and improve performance.
- Designed and implemented a storage area network (SAN) more than doubling data storage capacity.
- Improved overall operations efficiency and downtime in one year by 12 percent meeting and exceeding goals of 99% availability.
- Planned and implemented a new voice telecommunications system doubling current growth capacity and adding call logging capability.
- Stood up disaster recovery and network security programs to meet industry guidelines and standards for data integrity and protection of operations where none previously existed.
- Responsible for all aspects of day-to-day IT operations, technical support, help desk, network support and facilities for 250 users, 12 servers, encryption devices, and all telecommunications (PBX and voicemail).
- Led teh creation of a help desk, network control center, and desktop support systems for this division.
- Projects managed included migration from Microsoft NT 4.0 to a Microsoft 2000 Server domain model and an Email migration to Exchange 2000 server from HP UNIX Send mail and Exchange 5.5.
Confidential
Responsibilities:
- Provided project management and integrated scheduling support.
- Responsibilities included establishing and overseeing teh project planning process, facilitation of planning and status meetings, provided weekly variance reports, management of project deliverables to ensure timely completion of project.
- Supplied regular status reporting to Program Officer, risk management, and preparation and maintenance of project schedules.
- Worked wif Program Officer to develop work breakdown structure for high-level project plan.
- Developed and maintained complex integrated resource loaded schedules, logic linked networks, resource plans, and forecasts for earned
- value management utilizing MS Project, Primavera (P3e), MS Access and MS Excel.
- Maintained Project Website using Dream weaver and MS FrontPage.
- Server aboard USS Saipan wif Battalion Landing Team 2/8 in support of Bosnian conflict and Northern Iraq
- Assisted in teh design/implementation of teh total automation of teh Fleet Marine Corps’ Administration system.
- Responsible for Marine Corps’ project entry in teh Reengineering of Travel processes for teh Department of Defense at teh Pentagon.
- Received a non-combat promotion by teh tan Commandant of teh Marine Corps, General Charles C. Krulak for all projects managed.
- Navy/Marine Corp Achievement Medal and Beneficial Suggestion Cash Award of 10K were also earned.
