Senior Systems Administrator / Dba Resume
4.00/5 (Submit Your Rating)
Mooresville, NC
SUMMARY:
- The great challenge of IT lies in effectively communicating with business partners.
- I have decades of IT experience in multiple industries as both as a consultant and as an employee.
- I can communicate effectively because I have a long term understanding of the technology and an understanding of when in fits in the business.
- There is very little in the realm of IT infrastructure that I have not been responsible for,but my first loves remain by best: Unix, databases, automation, and firewalls.
TECHNICAL SKILLS:
- Linux (including Ubuntu Red Hat) Windows Server and Domains Linux hardening
- IP Tables Most networking protocols Apache/nginx/IIS Web server Check Point and Gauntlet Firewalls SMTP (SendmailPostfix)
- Communicate technological ideas w/o causing glassy eyed stares tSQL pgsql
- PL/SQL Microsoft SQL Server MySQL /Postgresql Server MS Reporting Services Oracle Server Bash
- Perl
- Python
- PowerShell ETL (Pentaho various scripting languages)
- VoIP / Asterisk HP - UX 9.0
- 10.x 11.x
PROFESSIONAL EXPERIENCE:
Senior Systems Administrator / DBA
Confidential, Mooresville, NC
Responsibilities:- Implemented, supported, and maintain all aspects of MS SQL Server and MS Reporting Services.
- Automated backups, index maintenance, and procedure usage and performance tracking.
- Developed and tuned SQL reporting datasets for for analysts.
- Taught basic and advanced SQL to IT staff.
- Designed SSRS reports and report templates.
- Created ETL tools for automation of weekly batch database loading using PowerShell,SQL Server
- Business Intelligence suite, and Pentaho Kettle.
- Performed code review, code optimization, SQL query optimization and performance improvement for servers.
- Incorporated feedback and recommendations from other staff members when modifying software.
- Maximized server utilization and minimized hardware costs via server virtualization using libvirt/KVM host emulation and LXC containers.
- Specified and procured server system builds.
- Website maintenance and modifications on IIS and nginx.
- Migrated web applications to secured data center.
- Implemented and maintained firewalls, series switches, site-to-site VPN, and remote employee VPN.
- Diagnosed system hardware and software problems using advanced root-cause analysis.
- Trained IT team.
Senior Systems Administrator / DBA
Confidential, Mooresville, NC
Responsibilities:- Troubleshot, maintained and enhanced a multi-tiered Application Service Provider environment, utilizing Oracle and MySQL databases and custom applications on Windows and Linux platforms.
- Planned and implemented migration of Oracle 9i database to a new Oracle 10g server in co-located data center.
- Administered and supported IIS Web Services, Microsoft SQL Server and Reporting Services.
- Administered and supported Red Hat Linux and Apache Web servers.
- Administered and configured 3Par SAN.
- Provide scripting support and back end operational enhancement programs utilizing Perl.
- Administered and expanded use of virtualization technologies, including VMware Server, to maximize our computing efficiency.
- Ultimately migrated all production servers to a virtualized environment on new hardware using Linux KVM, LXC, and drdb virtualization cluster managed by Ganeti software in a co-located data center.
- Administered the office Microsoft Windows Domain and Exchange server.
- Supported and maintained network switches, firewall platforms, and security policies for corporate and ASP production networks.
- Maintain and configure Cisco routers for partner IPsec tunnels and customer dial up synchronization access.
- Administered the Intertel phone switch and customer support Interactive Voice Response (IVR) system.
- Designed and implemented Elastix 16 Line PBX / IVR and transitioned to VoIP phones.
- Negotiated telecommunication contracts.
Co-Owner
Confidential, Pahrump, NV
Responsibilities:- Provided low voltage wiring for home security, phone/networking, and entertainment systems in new construction homes and businesses. Installation of home theater systems, Internet / network cable, intercom, and home automation systems in existing homes.
- Provided network and entertainment system testing and trim completion, and Wireless AP installation in hotels.
- Responsible for system design, costing and blueprint updates.
- Generated job bids, implementation wiring layout and schematics.
- Responsible for accounting and payroll.
Owner
Confidential, Pahrump, NV
Responsibilities:- Set-up and operation of Hi-Speed Internet to businesses and residents.
- Provided network solutions to local businesses.
- Designed and implemented a Wireless mesh system using Skypilot Network equipment.
- Provided Business network troubleshooting.
- Provided Email management.
- Simple technology implementations for small businesses.
Data Security Analyst
Confidential, Bloomington, IL
Responsibilities:- Diagnosed firewall system hardware and software problems for Checkpoint and Gauntlet firewall systems deployed in load balanced redundant pairs using advanced root-cause analysis.
- Collaborated with various project groups traversing the corporate network perimeter to provide secure reliable network communication aligned to corporate security protocols.
- Worked with other defect management level teams to analyze, fix or patch, and report root cause for esoteric networking and load balancing issues.
- Used network packet captures to determine networking and protocol issues for communications traversing firewalls.
- Assisted with project implementations designed to enhance the availability and/or functionality of the network perimeter, email infrastructure and anti-virus support.
- Provided defect management support for Internet, intra-net and external vendor connected firewalls.
- Created scripted support tools for firewall monitoring, change propagation, configuration validation, deployment and administration utilizing Perl, awk and shell script.
- Test and evaluate new firewall technologies based on performance, security and suitability for corporate infrastructure. Evaluate and verify vendor enhancements to deployed firewall products.
- Provided Sendmail expertise consulting.
- Created specialized M4 Sendmail configurations for encrypted mail processing, partner domain rerouting via secure tunnel/leased line connections, and enterprise Internet email standardization enforcement.
Systems Analyst
Confidential, Bloomington, IL
Responsibilities:- Provide on-site support for large HP OpenMail deployment (40+ servers, 10K+ users).
- Provide scripting support for email monitoring, support and administration utilizing Perl, awk and shell script.
- Provided system performance and tuning enhancements to HP-UX OpenMail servers.
Systems Engineer / Computing Technology Consultant
Confidential, Charlotte, NC
Responsibilities:- Designed computing infrastructure for accounting and manufacturing execution systems.
- Designed and implemented initial electronic messaging infrastructure for various companies utilizing HP OpenMail and Microsoft Exchange.
- Evaluated companies technology implementations and system processes, and created and implemented legacy systems migration plans.
- Created disaster recovery plans, including hardware design to meet maximum available downtime requirements. Data backup and recovery procedures and archival policies. Redundant hardware requirements.
- Network security policies.
- Installed many standalone and clustered HP-UX servers with various RAID configurations.
- Installed and configured Oracle databases for Oracle versions 7.2.2-8.0.2. Including database creation and expansion for Baan, Oracle Apps, other MES systems.
- Designed initial network infrastructure for small to mid-sized banks and manufactures; including wide area network design and implementation, IP address schemes, and local area switched backbone deployment utilizing Cisco, Bay Networks and Confidential equipment.
- Implemented many multi-site WANs using T-1, fractional T-1, Frame Relay, and sadly modem links with Confidential and Cisco routers.
- Conducted group training classes for HP-UX, OpenMail, and Raptor firewalls.
- Provided consultation and implementation services in over 10 states and US territories.