Sql Dba - Data Warehouse Administrator/architect Resume
OBJECTIVE
- To obtain a position in an environment of continued technological advances and integration through utilization of my architect, administration, programming and business management skills while allowing me to provide innovative, automated and effective solutions.
TECHNICAL SKILLS
Languages: Visual Studio.Net, VB.Net, C & C++, SQL, Access VBA, Perl, Shell, Phyton, Bash Coldfusion, ASP.Net, Dreamweaver, Html, T - SQL, XML, PowerShell, VB Scripting
Networking: LAN/WAN & Wireless Networks, TCP/IP, Ethernet
Platforms: Windows 95-2000/NT/XP/2003 - 2016 (64 bit), UNIX AIX/Linux
Applications: MS SQL Server 2000-2017 Suite, AlwaysOn, Crystal Reports, MS SharePoint, GIT SQL Azure, AWS, AutoSys, DynaTrace, BMC Remedy, eSOMS, Fusion, SoapUI, Enterprise Architect, Beyond Compare, SQL Compare, SQL RD, MAPICS (Syteline), APS, BI Tools, CRM, Cognos (Impromptu), FRx, Workflow, ACT, SAP, GPS, RoboHelp, Citrix, Great Plains, MS Exchange, Active Directory, Siebel, Kronos, Star(McKesson), Interface Manager, Omega, IDX, KinetX, Pharmlink, Veritas, WS/FTP Pro, LiteSpeed, Thycotic Suite, Red Gate Product Suite, Business Objects, MicroStrategy, MS Project, Visio, MS Windows Script, VSTS, Tableau, Datris Profiler, WinSCP3, Secure Transport(Valicert), SCOM 2007 - 2012 R2, GoldenGate, Horizons BPP - Copperleaf and PGP Encryption, ServiceNow, Zerto
PROFESSIONAL EXPERIENCE
Confidential
SQL DBA - Data Warehouse Administrator/Architect
Responsibilities:
- Administrator/Architect/Developer involving design/review/implementation of innovative/automated technologies for several projects including day-to-day governance and performance management operations of Multi-Million dollar merger/acquisitions, data center migrations, HA/DR implementations, organization standards, and security enhancements through setup/configuration/implementation of new virtual SQL Server/Infrastructure Architecture on EMC XtremeIO utilizing SQL Server 2014 - 2016 Suite, Visual Studio 2015, AlwaysOn, BI Tools and various 3rd party applications delivering cost effective innovative strategies for enterprise scalable, secure/stable solutions, reporting, and monitoring while eliminating operational risk and developing environments adhering to HIPPA, SOX and other Government Regulatory Policies.
- Administrator/Architect/Project Manager to implement solutions involving migrations and operational support of legacy systems to SQL Server 2014 -2016 from various systems including DB2, Neeteza, Oracle, PostGres, Hadoop, MongoDB, MS Access and legacy SQL Server installations working closely with System Architects, developers, Infrastructure Admins and management to deliver overall direction and best practices within the organization.
- Perform Architectural review of various systems within the organization including High Availability/Disaster Recovery Solutions, new acquisitions/mergers, internal (in-house) developed applications, external clients, reporting, new technologies, 3rd party vendor apps, legacy and existing applications to improve security, scalability and performance of systems to develop and implement strategic direction of systems and drive continuous improvements while implementing new company standards, policies, procedures and best practices for various lines of business and the corporate IT team.
- Administrator/Architect/Lead/Team member involving implementation of automated processes utilizing Powershell, Shell, ServiceNow, SCCM, Orchestrator, GIT, SSIS, Ab Initio, AutoSys, Bamboo, NetBackup and Puppet to automate deployments, DB system installations, system/server configuration, patching, resolution of ServiceNow ticket requests and backups/restores including development of templates for virtual environments, DB processes/updates, monitoring, and expediting client requests for Production related change requests
- Administrator/Architect/Lead to improve SQL Server/ERP and Off-Shore developed applications providing guidance to DBA’s/developers, update senior management concerning project timelines and status, provide oversight partnering with Solution/Data Architects, various LOB’s and engineers to review best practices and standards are followed increasing performance of ETL load processes, Data migrations, automation, administration, stored procedures,security, availability, daily processes, and reporting while leading efforts to implement proactive enterprise level monitoring applications to include SCOM, Idera, DynaTrace, EM7 and SentryOne increasing reliability in a 24/7 multi-site environment while performing daily and project work as a Web/App Admin, Infrastructure Architect (Design) working closely with Security/Storage/System Admins to provide stable/robust environments ensuring service related issues are identified and resolved in agreement with SLA policies.
Confidential
SQL DBA - Data Warehouse Administrator/Architect
Responsibilities:
- Administrator/Architect/Developer involving design/implementation of leading technologies/applications to increase company-wide Productivity, enhance security, provide 24/7 support and reduce overall operations cost through setup/configuration/implementation of new SQL Server/Infrastructure Architecture, cutting-edge technologies, best practices/procedures, performance optimization, capacity planning, data migrations and various applications utilizing Microsoft SQL Server 2000 - 2014 Suite, Visual Studio 2005 - 2015, BI Tools, and various reporting/third party applications increasing business continuity, maximizing availability and adhering to strict Government Regulatory Compliance Policies.
- Administrator/Architect involving team members to evaluate/design/implement new Production/QA/Test/Development environments on new EMC 64 bit SAN with clustered/virtual servers and creation of new Disaster Recovery Architecture/Procedures, backup strategies and High-Availability Solutions leveraging SQL Server 2014 - 2008 R2 Suite including SSIS, SSRS, SSAS and Enterprise Architect while working closely with Systems Architects, Data Architects, Oracle/DB2 DBA’s, Developers, Management and end-users to meet business requirements.
- Work with various teams to design/ develop/review all database development activities including Development teams, BI Teams, and DBA Teams to ensure data integrity and structure from end to end for data consumption by client apps and data feeds/migrations into the ODS and datawarehouse.
- Administrator/Architect to improve SQL Server/3rd Party/ERP applications performance, security, availability, replication processes, apply preventive techniques/maintenance, reporting, disaster recovery, proactive monitoring, build/maintain and administer web/application servers and reliability in a 24/7 multi-site global environment through creation of scalable solutions and implementation of new technologies/applications utilizing SQL Server Suite, BI Tools and DynaTrace while ensuring service related issues are identified and resolved in agreement with SLA policies.
- Administrator/Architect/Web Admin involving implementation of in-house/3rd party vendor applications, enhance legacy applications and implement Multi-Million dollar merger-related projects between Confidential and Progress Energy to increase company-wide operations and efficiency helping to lower overall production cost and provide reliable support to end-users/customers while enhancing application features and functionality, performance improvements, reporting and stabilize/maximize Production operations involving deployment of new terabyte transactional databases (OLTP), operational data stores (ODS) and datawarehouse datamarts.