PROFESSIONAL SUMMARY:

• Proven 100% remote telecommute experience
• Operational management experience to include SLA management/compliance/reporting, contract management, proactive statistical analysis of performance data with recommendations to optimize performance and utilization
• 10+ year experience in Database, Windows and Linux/Unix Systems Administration, with experience in Federal Government, Health Care, Banking and Financial industries
• Proven ability to manage database infrastructure in Amazon AWS RDS Cloud based, On - premise and Virtualized environments (VMware, Hyper-V); Advance knowledge of SQL Server 2002, 2005, 2008, 2008 R2, 2014, 2016, Oracle RDBMS 8i, 9i, 11g, 12c, PostgreSQL 9.1
• Excellent systems administration skills (Windows Server and Unix/Linux Server )
• DevOps experience with developing a fully customizable GUI application allowing customers to query and update database tables using Visual Basic, C++ and T-SQL
• Hands on development of data mining reports using Crystal Reports and .Net
• Successfully Managed and Mentored a team of 12 Dev Ops Database Administrators
• Strong track record of identifying and remediating performance bottlenecks in transactional database environments larger than 1TB
• Hands on disaster recovery experience automating Oracle backup routines through shell scripts on Unix/Linux systems and automating SQL Server backups through Powershell scripts.
• Hands on experience migrating Oracle instances to SQL Server instances and vice-versa; Informix databases to SQL Server; SQL Server to SQL Server; Oracle to Oracle.
• Understanding of Python 3.5 and pyodbc scripting for automating DML(data manipulating language) from SQL Server databases using a cursor.
• Experience with the following technologies: Linux/Unix administration, Linux scripting(bash), PosgreSQL, Microsoft Windows Server, Microsoft PowerShell, Microsoft SQL Server, Microsoft Active Directory, Microsoft Remote Desktop Services, Microsoft Operations Manager, Citrix, VMWare virtualization, Oracle RDMBS, Oracle Portal, Oracle Grid, Oracle RMAN and Apache HTTP Server.
• Deep understanding and hands on experience with (STIG); a cybersecurity methodology for standardizing security protocols within networks, servers, databases and logical designs to enhance overall security. Solid knowledge of Version/Source Control
• Able to pass Government background check. Currently hold interim Secret Security Clearance
• Oracle Certified Database Administrator

PROFESSIONAL EXPERIENCE:

Senior Database Administrator

Confidential, Des Moines, Iowa

Responsibilities:

• Took control of team in order to provide guidance to teammates, came up with a game plan for day to day tasks, worked with other teams to bring cohesion, created much needed documentation and began updating scripts in order to automate tasks and have begun working with python in order to create forms for updating data requests
• Working with team to migrate and consolidate separate legacy 2005, 2008 database servers into consolidated SQL Server 2016 clustered database servers
• Analyze, re-write and optimize sql procedures and jobs, working to convert them into SSIS packages
• Support clustered and non clustered databases environments with encryption
• Mentor team members on a day to day basis
• Work with and assist application developers in an effort to convert cold fusion forms to .Net.

Database Administrator / Manager

Confidential

Responsibilities:

• Successfully led a team of 12 database administrator located around the world; supporting 1600 databases servers on Oracle RDBMS, SQL Server and Posgresql in both Windows and Linux environments on the AWS Cloud
• Unified four separate teams into one cohesive team while increasing customer satisfaction
• Daily duties included troubleshooting, performance tuning, backups, restores, migration support, application support, implementing best practices, isolating and providing guidance on problem sql statements, creating checklists, documentation and working to automate DBA tasks.
• Worked with DevOps in assisting to troubleshoot automated backup routines, replication automation and database user permission automation.
• Completely removed personnel from working the grave yard shift to increase morale while still providing support around the clock.
• Worked to lead my team by being in the forefront to always be aware of what is actually happening in the front lines.

Senior Database Administrator - Lead

Confidential, Illinois

Responsibilities:

• Developed analytical and data mining reports for upper management on a day to day basis and eventually I automated the process by creating a customizable web-based front end using coldfusion to publish reports using crystal reports connecting to a master report database. I also created slave databases on all other databases servers to assist in automating the push of data to the master report database. Allowing for on-demand reporting.
• Led a team of two Database Administrators and four web developers for a period of year on an initiative to migrate SQL databases to newer versions, migrate applications from Oracle to SQL server and to develop and migrate web based applications to .Net from coldfusion.
• Hands on experience installing and troubleshooting Oracle Database instances on Unix HP-UX and Linux RedHat, Microsoft SQL Server, Windows Servers, Microsoft Operations Manager, Active directory (users, groups, permissions, containers), Microsoft Clusters, IIS, Sharepoint, ColdFusion Web Services, SSAS, SSIS, Database Mail and Server Group policies
• Hands on experience installing security updates and patches on both Oracle RDMBS and Microsoft SQL Server; performance tuning Oracle and SQL database servers; optimizing sql queries; automating backups; performing restores; migrations and working with customers architecting database structures.
• Developed checklists, documentation and processes for team duties to meet Government requirements.
• Developed, migrated and assisted customers in troubleshooting SSIS and DTS packages.

Software Solutions Specialist

Confidential, Rock Island, Illinois

Responsibilities:

• Hands on experience with import, export, extracting and manipulating database data and structures in order to migrate them off of legacy based database systems and into Microsoft SQL Server
• At times, I had to creatively figure out how to access databases systems with no documentation and no login information in order to assist customers exporting the data out.
• Developed scripts and packages in order to automate the conversion of data from like legacy database systems into SQL Server, effectively becoming the only person in the company to ever take a customer live with all of their data. The norm was to import customer data 30 days after taking the customer live with our applications.
• Developed Crystal reports based on customer requirements on a day to day basis, including troubleshooting and migrating/updating existing reports.
• Developed an application using Visual Basic and C++ that allowed end users to query and update database data. I made the application headers and sql/t-sql completely customizable.
• Developed and troubleshot DTS packages.
• Hands on experience installing SQL Server, Windows Server, proprietary applications, Crystal Reports, printers and working with firewalls.
• Assisted development team in creating and troubleshooting Ghost Imaging Process.
• Hands on experience working with ODBC and ADO connections.

Database Pre-Sales Consultant / Systems Engineer

Confidential, Chicago, Illinois

Responsibilities:

• Hands on experience installing, configuring and troubleshooting Oracle 8/8i/9i databases, 9i Internet Application Server, Portal Architecture and Apache Http server for customer demonstrations in a Pre-Sales environment.
• Developed custom scripts using Http, SQL and PL/SQL for customers demonstrations
• Created and gave presentations to C-level executives on Oracle 8/8i database architecture, Enterprise Manager, Backup, Recovery, Performance Tuning packs, 9iAS Portal benefits, architecture and instructed classes on how to build and manage a 9iAS Portal Website.
• Hands on experience installing and troubleshooting all aspects of Windows 2000, NT 4.0 Server/Workstation and Windows 95 computer systems.
• Hands on experience replacing internal laptop and desktop parts
• Experience configuring and maintaining Primary/Backup Domain Controllers, Active Directory Groups, Print Servers, Veritas Netbackup3.02.
• Hands on experience configuring and troubleshooting network related issues: Novell, TCP/IP, DHCP, PPP and static IP.