SUMMARY:

• Versatile and reliable Sr. Database administrator/ engineer with thirteen years of experience.
• Microsoft Exchange Server
• UNIX Shell Scripting /ABL Coding
• SQL Server 2005/2008 & R2/2012 & R2/ 2014/ 2016
• Excel/ MS Project/ Access
• Progress RDBMS /Oracle RDBMS
• Adobe Design
• Powershell 1.0 - Powershell 5.0
• CIM Infrastructure & Schema proficient
• MySQL
• RMAN/ Oracle Enterprise Manager 9i/ 10g/ 11g/ 12c - limited 13c
• SQL 2005/2008/2012/ 2014/2016 Installation, migration, & upgrade
• SQL Failover Procedures
• GoldenGate 12c
• Mirroring/ Replication
• JDEdwards EPR
• Digital transfer expediency
• Typing Speed is 75+ wpm
• SharePoint (Portal, 2.0, 3.0, Server 2007, Server 2010, & Server 2013)
• Jscript / VBscript
• Azure/ SQL Data Warehouse procedures
• Proficient in SSRS, SSIS, & SSAS
• MCSE Certification
• AlwaysOn Clustering for multiple nodes
• PMP Certification
• AWS Procedures/ Architecture
• Data querying and analysis
• Installing, configuring, and maintaining SQL 2000, SQL 2005, SQL 2008, SQL 2012, SQL 2014, SQL 2016, Perl, Oracle, Vader, IDMS, & Mongo DB environments
• Evaluating and designing a best fit scenarios based on budget and demographics
• Developing end-customer focused metrics
• Facilitating JAD Sessions
• Managing projects & customer risks
• Managing multiple schedules

PROFESSIONAL EXPERIENCE:

DATABASE ENGINEER

Confidential

Databases: Microsoft Azure, SQL 2018 (Beta), Amazon AWS

Responsibilities:

• Microsoft Stack engineer working in conjunction with Confidential Research & Development to expand the possibilities of cloud-based technologies.
• Lab-based environment - utilizing Microsoft SQL 2018 (Beta) in conjunction with Linux systems with Windows 2016.
• E2E SQL Database installation/planning directly under Program Manager within Spheres of Support/ Fanatical Support.

Confidential

Database Administrator IV/ IT Specialist

Databases: SQL Server 2005, 2008, 2008 R2, SQL Server 2012 & 2012 R2, SQL 2014 & 2016; Mongo DB / Oracle 11g & 12c

Responsibilities:

• Overseeing ten other Database Administrators on numerous projects, setting weekly expectations in coordination with project managers and the chief of data operations while maintaining data security in compliance with AITC standards and congressional mandates.
• Duties include installing/updating SQL patching, trouble-shooting, encryptions, data migration/allocation, and daily routine maintenance.
• Migrating applications from development/test environments to production - including customization to client specifications in both SQL (NoSQL) and Oracle (GoldenGate 12c) Extensive use of SQL Back-Up procedures including to tape, cloud, and NetBackUp.
• Developer of infrastructure architecture with responsibilities including hardware sizing, effort estimation and security oversight.
• Part of team working in conjunction with Microsoft representatives to utilize innovating applications such as AlwaysOn to maintain and improve VA Database Servers and best policy practices.
• Daily utilization of SharePoint Server in conjunction with approved venders via shared service applications.
• Regular utilization of BI - SQL Server Reporting Server (SSRS), SQL Server Analytics Services (SSAS), & SQL Server Analytics Services (SSIS).
• Well versed in United Stated Government standards & practices.

Confidential

Database Architect/ Administrator

Platforms: Microsoft Windows 7, 8

Databases: SQL Server 2008, R2, & SQL Server

Responsibilities:

• Database patches, scripting tables, indexes, constraints, stored procedures, and user-defined functions from production systems to replicate & create database installers for a novice development environment. Installation extraordinaire via upgrade from old (SQL 2008) to new system (SQL 2012) following careful migration procedures.
• Supported trending analysis of data gathered during scheduled systems maintenance before finding new ways to evaluate/troubleshoot repeat queries.
• Worked within multiple IDE's - including Microsoft Visual Studio, XCode, & Xojo) Performed SQL 2008 primary database administrator role maintaining domain structures, user authentication, digital signatures, information security practices, security software packages, and security controls.
• Secondarily responsible for the protection, availability, and integrity of all administered systems data on the in-house network, both domestic and abroad in an OLTP environment.
• This included extensive back-up/recovery specialization and in-house training.
• Supported the automation & process improvement of functions relative to DFS project databases in production including the introduction of new tools (as needed).
• Worked within multiple IDE's - including Microsoft Visual Studio, Eclipse, and Oracle JDeveloper.
• Project manager of SQL 2012 installation/migration from SQL 2008 system process team.
• Daily performance tuning/ testing administered to optimize network integrity across all platforms. Heavy use of MS Powershell 3.0 - later conversion to Powershell 4.0 in conjunction with Sharepoint Enterprise 2010. RMAN back-up specialist (due to extensive work with historical documents/records).
• Daily utilization of SQL 2008 and Windows Server 2008 that included extensive recovery training.

Confidential, Austin TX

Database Administrator/ IT Specialist/ Data Architect

Platforms: Microsoft Windows Vista, Windows 7

Databases: SQL Server 2005, SQL Server 2008 & 2008r2 / Oracle 10g

Responsibilities:

• Information security specialist Director of Production level support for onsite & offshore teams during development life cycle.
• Co-architect of optimized integral data for international shipping methods for 2009 using Jscript & VBscript. Maintained optimal service levels, recoverability, maintenance, space requirements, and overall database performance and integrity of SQL 2005 system (including weekly performance tuning, upgrades, and back-up).
• Other tasks included creating and maintaining database schemas using stored shipping procedures, views and triggers; providing hypothesis for all root cause analysis with supporting evidence and identifying actions required to restore optimal operating conditions (including configuration changes, patches, etc.)
• Responsible for implementing Enterprise Resource Planning (ERP) into day-to-day projects via a streamlined integration by utilizing MS Sharepoint.

Confidential, Dallas TX

Database Admin/ Architect

Platforms: Microsoft Windows ME, 95, 98, 2000, XP, Vista, Windows 7

Databases: SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012

Responsibilities:

• Numerous assignments on a case-by-case and direct hire basis.
• Freelance database architecture for small businesses who cannot otherwise afford a constant presence; tasks generally include (but are not limited to) system migrations, basic upgrades, multi-systems testing, staging, working within developmental environments, and lots of script writing. Team lead responsible for training junior administrators
• Allowed for numerous networking opportunities that have since served to not only increase exposure to various sizes of database needs; but also provided valuable insight into the evolution of data warehousing from small, to enterprise level scaling.

Confidential, Los Angeles, CA

Paige for Legal Department/ DBA II

Platforms: Microsoft Windows XP, Vista

Databases: SQL Server 2005, SQL Server 2008

Responsibilities:

• On team responsible for installing, implementation, and configuration of SQL 2008 for entire Confidential west coast operations upon release.
• Coordinated system upgrades, enhancements, and software updates as directed.
• Met all service level requirements for entire duration of internship, including system monitoring, troubleshooting client connectivity, lock resolution, and performance issues