Technical Architect / SQL Server Database Administrator Resume

SUMMARY:

Over 20 years of experience in Information Technology working for a variety of industries. Experienced in all phases of software and database design and development.
This includes database administration, development, maintenance, upgrades, implementation, testing, planning, monitoring, and performance tuning.
Excellent problem - solving and communication skills.
Ability to quickly learn new tools, languages, and applications and understand how best to use them to increase productivity and efficiency.

TECHNICAL SKILLS:

SQL Server 2008, 2012, 2014, SSIS, SSRS, BizTalk 2013 R2, Sybase 11.5, 11.92, 12.5, Ingres, MySQL
Windows Servers 2012, 2008, 2003, 2000, Linux, Unix, HPUX, Solaris, VMWare ESXi
Microsoft Office: Word, Excel, PowerPoint, Visio, Project
Languages: PowerShell, C#, SQL, HTML, Perl/CGI, PHP, Korn/Bourne/C shell scripting, SQR, Visual Basic, Application Engine, PeopleCode, PeopleTools, PL/1
PeopleSoft, SAP, Oracle Hyperion Financial Management

PROFESSIONAL EXPERIENCE:

Technical Architect / SQL Server Database Administrator

Confidential

Responsibilities:

SQL Server Database Administration (2005, 2008, 2012)
Deployed, Administered and Upgraded Microsoft Windows Server 2008 and 2012 R2 for multiple commercial off the shelf applications used for global applications.
Deployed Windows 2012 Servers using VMWare ESXi for use by the Biztalk development and testing team.
Deployed SQL Server 2014 on Microsoft Azure ( IaaS and PaaS ) for Power BI developers.
SQL DBA support for variety of global applications (HFM, Lumesse, SAP, Peoplesoft, Hitachi IDM)
SQL Server Clustering (2008 active/passive).
SQL Server 2005 Replication for OLTP and DSS databases for Peoplesoft 8.43
Monitored, performance tuned, maintained, and performed upgrades on critical OLTP financial ERP applications such as PeopleSoft, Hyperion Financial Management, and SAP using SQL Server 2000, 2005, and 2008.
Developed processes using SQL Server Integration Services, stored procedures, and Perl scripts to convert data between various legacy financial systems (such as Lawson, Oracle Financials, PeopleSoft, etc) into SAP ERP. Developed data cleansing, validation, and transformation processes.
Rewrote reports, SQL stored procedures, queries, and batch programs to improve run times from hours to minutes.
Developed best practice standards for improving performance of software applications.
Mentored developers on best practices for software and database development using tools such as SQL Server Integration Services, table design, SQL, stored procedures, triggers, and indexing strategies.
Monitored and maintained global software applications used by multiple countries in Europe, Asia, and Latin America. Applications include: ERP Financials, project tracking, HR, applicant tracking, credit collections, and treasury management.
Lead 3 person team for deployment of Hitachi Identity and Password Management ( version 8.20 ).
Consulted on software projects to recommend architecture for software solutions.
Deployed and administered a Biztalk 2013 R2 solution with multiple servers and a clustered SQL 2012 backend.
Wrote and performed directions for off site recovery of various applications. ( Peoplesoft, Oracle Financials, Lumesse )

Sybase DBA / HPUX Admin

Confidential, Troy, MI

Responsibilities:

Database Administrator for Sybase 11.92 on HP K-class servers
Supported SQL development for web e-commerce solution.
Runtime improvement for triggers, stored procedures and indexes on the backend OLTP database.
Database disk mirroring for servers
Upgraded Sybase to ASE 12.5.

Sybase DBA / Solaris Admin

Confidential, Troy, MI

Responsibilities:

Database Administrator for Sybase 11.5 (later 11.92) on Sun Solaris servers.
Supported developer for Peoplesoft 7.5 solution.
Wrote custom stored procedures, triggers, views.
Runtime improvement for triggers, stored procedures and indexes on the backend OLTP database.
Sybase Replication between 2 Sun servers for

Database Administrator (HP Unix / Sybase DBA )

Confidential, Troy, MI

Responsibilities:

Database Administrator for Sybase 11.0 database
Supported Developers customizing Web Based Leasing System ( LeasePAK )

System Engineer (HP Unix Admin / Ingres DBA )

Confidential

Responsibilities:

Database Administrator for Ingres database on a HPUX D Series server.
Wrote C with embedded SQL programs for web based plant routing system.
Visual Basic front-end development to retrieve and display CAD drawings stored in Ingres to end user.

ESD Candidate / Qnx Admin

Confidential

Responsibilities:

Installed and administered a robot control server for auto body stamping using Qnx.
Wrote the Proof of Concept for replacing aging system with client server model to control metal delivery.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship