We provide IT Staff Augmentation Services!

Dba-system Administrator Resume

Logan, UtaH

SUMMARY

Ability to communicate effectively both orally and in writing to Clients AND Development communities: Strong knowledgeable in SDLC,AGILE and ALM methodologies and environments: Knowledge and expertise in Source Control software (SVN,GIT, GITHUB, Team Foundation, etc): Expertise in working in multi - platform OS environments (Unix, Windows, Linux) environments utilizing Sys Admin experience and knowledge: Ability to break down and simplify complex issues providing options to improve and/or simplify process, methods, or develop requirements: Expert Customer Service skills and has ability to work with Development Teams to ensure Customer Business Requirements are met by becoming the interface between the Customer and the Developer or team of developers: IT Project Management: Leadership skills: Attention to Detail; Critical Thinking, Problem Solver: Enterprise Wide Programs; UML Knowledge: Strategic Planning/Oversight; System Architecture; Information Security/Assurance; Cyber security; Team Building; Interagency, DBA knowledge of Big Data, and DBA Architect knowledge and experience: DBA knowledge and experience of maintaining Development, Test, Pre-Prod, Production environments

TECHNICAL SKILLS

Databases: MS SQL Server 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, SSIS, SSRS, SSAS, Oracle

System: Windows (7,10) Desktop, Citrix Thin Client, Servers Windows Server - 2012, 2014,1016, LINUX

Languages: T-SQL, PL/SQL, SQL, C, C++, VB, JAVA, JS, XHTML, HTML5, XML, CSS

Concepts: Data Mart, Data Warehousing, Module Design, OOD, Share Point, Agile, CMMI, AWS Cloud

DBA Toolset: IDERA, Redgate, FogLight, DeZign, DBSchema, SVN Tortoise, WinAutomation, GitHub, Team Foundation, Automate, iTops

PROFESSIONAL EXPERIENCE

Confidential, Logan, Utah

DBA-System Administrator

Responsibilities:

  • Managing Configuration and operation of Server Hardware, Desktops, Laptops and Software used throughout the company which includes upgrading old systems currently used to newest OS, and best system configurations affordable, and available including software thereby improving network security, and reducing vulnerability: Verify backup of all systems.
  • Work with Team during Parent Company Security Audits, to ensure full enhanced security measures are in place: Resolve any issues and report back to Parent company.
  • Provide Help-desk assistance when needed as a backup: provide upgrade advice, and accountability for all Printers used within Network: Trouble shoot Application issues, create and maintain Batch files: Update and Maintain third party Ticketing, and inventory Management system: Keep in Sync with changes to AD.
  • Work with IT Management to create and maintain NEW AD domain, and infrastructure: Work as team to migrate old domain to new domain: Consult, provide information to third party vendor on Single Sign on capabilities: Work with IT Management and team to create DMZ, and within DMZ an FTP server.
  • Administrate, upgrading, and Maintaining infrastructure of vSphere Hypervisor, including Linux environments, Windows environments, databases, malware protection software, update VMtools, and other processes bringing it in line with overall improvement in systems, and network security.
  • Create ‘WinAutomation’ Solutions to Parent company SAMSUNG SAP ERP System: Work with Development team to create Solutions upon request.
  • Perform Database Administration, Architecture and SQL Developer functions on current MS SQL, MySQL, PostgreSQL, AWS Databases in all environments: As needed Architect new databases, and work with Development team for large projects, and architect new database solutions for Tableau {Including Cloud}, SSRS, and SSIS: Utilize SSIS automation skills in development of packages, etc. for all environments: Create and work with Parent company to create automation between Samsung Parent SAP system and Internal customized ERP infrastructure and Application: Provide updates, maintenance, tuning, backups, verification of backups, troubleshooting, modeling, update current database schemas if necessary improving data integrity, and improving security.
  • Create one - year auditing security log process by sending security logs from each system to Gray log server providing capability of identify threats to network: Reviewing application logs, and monitoring systems daily, responding immediately to security threats, usability or performance issues.
  • Working with Tableau BI Analyst develop and improve reporting structure, and data analytics of Production data to stake holders, and managers within the company.
  • Develop Project Plan to upgrade MFG software used in production working with Stake holders, Vendors, and Management planning outage, and timeline, and costs to improve productivity, and reduce costs.
  • Upgrade and maintain current software {iTops} used for ticketing, management, and systems monitoring, providing remote capability to resolve reported problems, and creating ticketing history, work order history, and network issues: Migrating old to new systems.
  • Working with IT Management and Network team develop a Disaster recovery plan for current And future infrastructure currently in place including possible solutions to AWS Cloud.
  • AWS Management- Work with developers and users of AWS Cloud and manage accounts and billing: Help develop new Architect plans and ideas for utilization of the AWS Cloud.
  • Working with IT Team ensure that we meet all Quarterly goals and objectives

Confidential, Salt Lake City, Utah

Application Specialist (SME)

Responsibilities:

  • Key point of contact for Operations & Development in resolving critical business issues with reference to Securities Lending (SL) associated Applications, various Batch jobs, and Business continuity planning (BCP) activities, Iview Alerts, Incident Management.
  • Wrote Sybase and MS SQL Scripts in creating tools to determine root cause, and quickly determine root cause of reported problems.
  • Wrote Linux scripts in creating tools to determine root cause, filter through logs, and determine root cause of reported problems.

Confidential, Draper, Utah

Upgrade Engineer

Responsibilities:

  • Implemented upgrades to VMax, VMax3, Symmetric, plus other product lines associated to storage arrays remotely globally working in Windows and Linux environments.
  • Executed, Validated and Verified Storage configurations, health checks, product solutions, and upgrades solutions to ensure systems fully operational.
  • Utilized Windows and Linux Skill set to confirm DELL/EMC Storage Array Healthy after upgrade.
  • Upgraded, Modified, and Verified detailed oriented step by step instructions for Upgrade solutions.

Confidential, Olympia, WA

Information Technology Specialist

Responsibilities:

  • Utilized SCCM Sys Admin skills to Maintain and Monitoring and patching of all DSHS agency systems for which our Infrastructure team was assigned utilizing SCOM2012/SCCM.
  • Implemented Windows Sys Administration services in support of SCCM Patching of all DSHS Server systems(750+).
  • Accurately tracked Windows Servers to ensure at proper approved MS Patch Levels in conformance with policy and procedures.
  • Technical Support on Database issues and/or Windows Administration issues on Servers reported problems on Virtual VM environments or Physical servers
  • Wrote MS Windows Power Shell Script and TSQL Script to automate extraction of information from Active Directory and other sources to automate update to CMDB Database used in conjunction with larger Database FEAF being utilized by DSHS.
  • Create CR via Ticketing process per ITIL procedures Document and close per processes.
  • Utilized Business Analyst and Project Management-Lead expertise when working with Development team to transition legacy software Database over to new External On Line Application, and Internal third party Applications
  • DBA Consultation on new project work with Badge security system (EBAS) for DSHS WA State wide utilizing Third party Software, Windows 2012 Operating System, and Microsoft SQL 2012, and database skill set..

Confidential, Lacey, WA

Information Technology Specialist

Responsibilities:

  • Maintained, scheduled, tracked changes, DBA support for 1.5 Terabyte Statewide child welfare information case management system as well as projects associated to Various Databases in Production, and Non-Production environments (Dev, ST, UAT, Pre-Prod).
  • Day to Day Administration Production OLTP database including User Access, Specific special request permissions, backups, restores, and execution of ad hoc developer queries for each environment (Dev, ST, UAT, Pre-Prod, Prod)
  • Backup Data Warehouse Administration Production database including Production Replications, replication scripts, user access, specific permissions, and ETL Package implementations, and new releases: Monitored replication process utilizing Replication monitor process utilizing Snapshot and transactional replication methods.
  • Implemented MS Best Practice Security guidelines and DOD Security Guidelines.
  • TSQL Code review Peer to Peer for Development Team programmers: Reviewed and approved basic to semi-advanced T-SQL scripts prepared by development team for database changes for major releases(DLL, DML), Emergency HOT fixes, and data fixes during development phases (AGILE), using SVN Tortoise change control software.
  • Migrated MS SQL Server and databases from Physical to New Virtual environments (Dev, ST, UAT, Pre-Prod, Prod).
  • Work Experience working with ETL and BI Solutions utilized by Data Warehouse.
  • 24/7 Database support, and Customer Service support

Confidential, Tumwater, WA

Information Technology Specialist

Responsibilities:

  • Maintained, scheduled, tracked database changes, DBA support, as well as projects associated to various third-party Databases in Production, and Non-Production environments
  • Day to Day Administration Internal and External Production databases including User Access, Specific special request permissions, backups, restores, and execution of ad hoc developer queries for each environment.
  • Built and Supported SharePoint site including Database and SSRS, SSAS: Continued Support of Analysis, Reporting tool after Installation and implementation phases completed.
  • Delivered consultation, analysis, and implemented database migration from Physical to Virtual environment project including database security standard using MS best practice standards: LINUX and UNIX Operating System
  • Analyzed the databases daily, evaluating connections, intrusions, and bottlenecks utilizing SOLAR WINDS and COMPUWARE product application and network monitoring tools.
  • Utilized COMPUWARE Automated Testing Tool Test Partner to Test 22+ On Line Applications for Functionality.
  • Go To Expert Application Testing utilizing Compuware "Test Partner" Daily Application Testing/Monitoring of Production on 22 applications: Created MS VB Code to automate testing, managed daily statistical reports based on test results, and intervals of testing each application which is displayed on DAILY MONITORING screen in view of all of IT department:
  • Network Monitoring- Database Administration utilizing MySQL knowledge and expertise to create requested adhoc reports produced by COMPUWARE and/or SOLAR WINDS monitoring tools(MySQL Database).
  • UNIX System Administration support for Unix Servers including the installation of patches, managing users, disk space oversight, and software support.
  • Go To Expert for any LINUX - UNIX Sys Admin questions in mentoring VMware SysAdmins.
  • Windows Sysadmin used for application testing overseeing the installation of Windows System for desktop configurations and installation of software

Hire Now