Senior Oracle & Sql Server Dba Resume
Nashville, TN
AREAS OF EXPERTISE
- Database Administration
- Data Analysis & Design
- Data Modeling
- Systems Performance Tuning
- Explain Plan Tuning
- Software Development (Full SDLC)
- Major Software/Systems Implementations
- Project Management
- Systems Administration (Unix\Linux\Windows)
- SQL, PL\SQL, T - SQL, Unix Shell Scripting
TECHNICAL SKILLS
Databases: Oracle Database (8i, 9i, 10g, 11g, 12c), SQL Server (2000/05/08, 2012/2014/2016 ), MySQL
Languages: Unix Shell, C#, ASP.net, VB.net, C, C++, Java, Perl, SQL, T-SQL, PL/SQL, XML, PowerShell
Servers/ Apps: Oracle - (SQL Plus, OEM Grid Control, RAC, ASM, RMAN, TKProf, AWR/ADDM/ASH, Data Guard, Forms & Reports, Weblogic, Oracle Application Server, Replication), IBM - (AIX, WebSphere, TSM) Microsoft - (Cluster Server, Reporting Services, Integration Services, Profiler, Query Analyzer), Toad, Quest Spotlight, Apache, JBoss
Systems: AIX, Windows Server (NT thru 2016), Unix\ Linux, z/OS, WANG
PROFESSIONAL EXPERIENCE
Confidential - NASHVILLE, TN
Senior Oracle & SQL Server DBA
Responsibilities:
- Upgraded mission critical 24/7 Oracle databases from various versions (9i,10g,etc) to latest versions of 11g/12c.
- Participated in the design/implementation of Oracle and SQL Server DR/Business Continuity planning and DR testing exercises at offsite IBM facility in Boulder, CO. Backup strategy included daily offsite backup to Boulder site using RMAN/TSM/IBM ProtecTIER.
- Designed and built SQL Server infrastructure composed of dedicated 2-node vSphere 5.5 hosts with Microsoft Clustering backed by IBM SAN storage. VM host servers sized to support 60+ databases with ample resources for future growth. Migrated and upgraded all databases (SQL Server 2005/2008/2012 upgraded to 2014) to new VM guests on the VM cluster.
Confidential - BRENTWOOD, TN
Oracle WMS Application DBA
Responsibilities:
- Performed performance tuning on the mission critical 1TB+ production Oracle 11.1 database with 300% improvement.
- Complete infrastructure stack support of 1.5 TB Oracle database running on IBM Power7/AIX with WebSphere application servers on IBM Power7 LPARs encompassing Dev, QA, and Production environments.
- Lead DBA/Engineer for three Distribution Center Go-Live projects. Duties included full environment stand-up, database schema build-out and refreshes, and continuous performance tuning of the primary Manhattan WMOS systems and secondary application environments (e.g. MHE systems, Cognos BI/Reporting, Vocollect Voice Picking).
Confidential - MONTGOMERY, AL
Oracle/SQL Server DBA
Responsibilities:
- Application DBA on Oracle Fusion Middleware -- OAM\OIM Access & Identity Management system that secures the company’s self-registering Customer Portal allowing customers to access their personal accounts on the company’s website.
- Migrated 100+ databases from a multi-node SQL Server 2005 cluster to a 3-node SQL Server 2008 enterprise cluster.
Confidential - MONTGOMERY, AL
DBA/Developer/Analyst
Responsibilities:
- Advanced to a more specialized position as the IT Division matured, managing the software development section and a major .Net & SQL Server 2008 project. Responsible for all data analysis, modeling and SQL Server database administration.
- Served as Lead Developer and DBA on $1.1 million inter-agency web development and data-integration project that consolidated all Alabama probation, parole, and pardons legacy data into a central database with a new web-based front-end - C#.Net, VB.Net, ASP.Net & SQL Server 2008.
- Designed new schema and migration plan and wrote T-SQL stored procedures.
- Established standardized processes for development, documentation, and quality assurance.