Senior Database Consultant Resume
Atlanta, GA
TECHNICAL SKILLS:
Database Versions: Oracle, MySQL, MariaDB, Sybase, DB2, PostgreSQL, SQL Server, MongoDB, Hadoop, Cassandra, Sybase
Applications/Cloud: Amazon Web Services (AWS), Oracle R12, PeopleSoft, Oracle ERP systems, Rackspace
Operating Systems: AIX, Linux, Sun Solaris, Windows, Apple MAC, HP - UX, OpenVMS, VMWare
Languages: Korn Shell, C shell, PL/SQL, Perl, Shell scripting
Tools: BMC Patrol BMC SQL Backtrack Dimensions PVCS EMC Powerpath EMC Replication ManagerErwin Exceed Mongo Ops Manager/MMS Oracle Grid Control OEM 12c/13c Oracle Golden Gate Oracle Data Guard (Active) Oracle Partitioning RedShift Mariadb Replication Mgr RMAN Seibels SolarWinds DB Artisan SQL Diagnostic Manager SQL Query Optimizer SQL Server Management Veritas HA
PROFESSIONAL EXPERIENCE:
Senior Database Consultant
Confidential, Atlanta, GA
Responsibilities:
- Provided day-to-day support and maintenance for Oracle, MongoDB and Sybase databases for the Digital Life Application.
- Provide technical leadership and supervision to Database Administration team.
- Develop and document Database Administration procedures.
- Execute database creation, configuration, upgrades, patches, and refreshes.
- Define and execute database performance and tuning scripts.
- Implement and administrate appropriate database management tools.
- Provide technical assistance and subject matter expertise to application developers.
- Act as escalation point for database and application teams.
- Participate in after-hours incident resolution situations.
Senior Database Consultant
Confidential, Atlanta, GA
Responsibilities:
- Provided day-to-day support and maintenance for Oracle, MariaDB and Postgres databases, also provide tech support and troubleshoot functionality/client-server connectivity issues with RDBMS
- Responsible for daily backups, production support, performance tuning, applications troubleshooting of all 11g and 12c RAC database environments
- Setup/Configured/Managed Database-as-a-Service (DBAAS) in the Oracle Cloud environment.
- Designed architectural solutions such as a 4 node 12c RAC environment on an Exadata appliance and configured Active Oracle Dataguard.
- Upgraded/Patched/Tuned 11.2.0.3 Oracle databases to 12c in development, QA, Production lifecycles
- Setup Master/Slave MariaDB environments using Galera Clustering
- Standardize the environment and supervise the database design process to ensure data integrity persists and the database is highly available per SLAs
- Responsible for database installations, upgrading/patching databases, performance tuning
Global Database Systems Manager
Confidential, Atlanta, GA
Responsibilities:
- Hands on database technical manager with strong project management, time management and problem solving skills.
- Managed a team of onshore and offshore DBAs to primarily support Oracle, Mysql and Postgres database environments.
- Led team to develop test and POC environments for NoSQL database suh as Mongo and Cassandra
- Manage and oversee multiple development resources in the design, build, implementation of highly available database environments
- General production support of production databases, including security, monitoring, space management, database migrations, database and system tuning, database refreshes, backups and restores, and user resource management.
- Responsible for designing, implementation, backups, production support of several different database environments.
- Plan, coordinate and implement security measures to safeguard information against accidental or unauthorized damage, modification or disclosure.
- Built an highly available Oracle RAC environment including Oracle DataGuard and Goldengate
- Developed a faster OLTP using SAP ASE (Sybase) which lowered our operational costs by 30%.
Lead Oracle/Sql Server DBA
Confidential
Responsibilities:
- Lead DBA in a production support environment that encompasses several types of databases such as Oracle, MySQL and SQL Server
- Manage, deploy, install and support of four node RAC cluster with two node Data Guard active standby databases
- Manage, deploy and install Oracle GoldenGate in uni-directional and bi-directional modes
- Monitored backup and recovery process via RMAN and 12c OEM (Grid Control)
- Developed pl/sql scripts, shell scripting, for performance monitoring and ad-hoc jobs
- Experienced in code migration, database change management through various stages of development life cycle
- Experienced designing, building, implementing database environments on al OS platforms including VMWare systems
Lead Oracle DBA
Confidential
Responsibilities:
- Provide technical leadership to the DBA team by assisting junior team members and sharing knowledge and research of tools/techniques
- Serve as team liaison to project managers for database administration and system administration services
- Provide work coordination and management for teams of DBAs, including project lead, project management, task assignment and coordination, and status reporting
- Coordinate and drive cross functional project teams, schedule, install, test and deliver contracted products within scheduled timeline and with a high degree of quality and customer satisfaction
- Provide support for all Oracle and SQL Server database environments to include problem identification, reporting, tracking, analysis, and resolution
Sr Oracle Database Administrator
Confidential
Responsibilities:
- Responsible for providing operational database support for databases on many different software levels and versions, utilizing a wide variety of DBMS features, on many different operating system (such as Linux, Solaris, AIX, HP UX)
- Production support DBA for mission critical 24/7 environment which main job function consisted of running daily batch jobs, creating health check scripts, and ensuring accurate and reliable database backups.
- Configured one way and bi-directional replication using Oracle Golden Gate
- Experienced in performing database backups and recoveries, database disaster recovery, database growth and disk space utilization, database problem analysis and resolution
- Installed/maintained multiple node RAC databases using ASM
Sr Oracle Database Administrator
Confidential
Responsibilities:
- Responsible for the installation, configuration, tuning and maintenance of RAC database of different releases across several State agencies
- Great relationship with developer team and tuned, corrected and promoted their code to development and production environments
- Established and ensured compliance with methodologies and standards, including security policies and standardized procedures and controls
- Makes data changes/conversion using PL/SQL procedures and shell scripts as well as writing backup and recovery scripts for disaster recovery initiatives
Principal Oracle Database Administrator
Confidential
Responsibilities:
- Experience in code migration, database change management and data management through the various stages of the development life cycle
- Developed, tested, and implemented software that are related to databases and/or application
- Establish and maintain sound backup and recovery policies and procedures
- Database performance optimization and benchmarking
- Define and document installation process and scripts for database for product implementations
- Support Oracle Applications (Oracle E-business) on multiple platforms
Lead Principal Oracle Consultant
Confidential
Responsibilities:
- 100% traveling consultant who implemented Oracle Highly Available environments at multiple customer sites around the world
- Oracle Consultant who taught mid-level to senior level dbas Oracle technologies such as 10g RAC, DataGuard and Oracle Streams
- Often supported customers with database performance issues, RAC issues or DataGuard problems.
- Installed, configured, tuned, and implemented 10g RAC solutions on multiple client sites
- Installed, implemented physical and logical standby database solutions on multiple client sites
Sr. Database Administrator
Confidential
Responsibilities:
- Supported over 2500 (Oracle, Sql Server, MySQL, Sybase) databases across multiple platforms, size ranging from 500MB to 2TB
- Develop RMAN scripts for backup and recovery of databases
- Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
- Provide development and production support including on call requirements
- Database design/architecture experience using both logical and physical modeling using Erwin Tools