Senior Database Administrator Resume
SUMMARY:
- Able to master new hardware and software quickly
- Veteran world traveler (10 countries, multiple continents & hemispheres)
- Customer Oriented: customer service background
- Superb written and verbal communication skills
PROFESSIONAL EXPERIENCE:
SENIOR DATABASE ADMINISTRATOR
Confidential
Responsibilities:
- Sole DBA for 30 MS SQL Servers
- Primary Database Developer for SSRS, SSIS and SSAS projects
- Responsible for all Accounting, HR, Transportation and Mobile back - ends
- Built and deployed several SSIS packages for external ETL operations.
- Deployed all new SQL code to all four environments
- Managed PigChamp upgrade including rewriting 37 custom VIEW objects
- Sole provider of 24/7 On-Call Support
- Performance tuning and improvement for SQL database objects
- Performed audit of existing installations and licensing
- Rebuilt Replication for Reporting Services downstream servers.
Technology Used: MSSQL, Windows Server, PigChamp, EMC SAN, C#.NET, IIS, SSIS, SSAS, SSRS, ActiveDirectory 2012, PowerShell 4.0, TFS, VisualStudio
SENIOR DATABASE ADMINISTRATOR
Confidential
Responsibilities:
- Sole DBA for 75 MS SQL Servers
- Built new MS SQL 2014 servers for IBM Cognos analytics for external client Toyota
- Responsible for very large 7GB sized single database in Production, Performance, Staging, Testing and Development environments.
- Built and deployed several MS SQL 2014 servers to upgrade environments from 2005.
- Deployed all new SQL code to all five environments
- Managed servers in 4 different ActiveDirectory domains
- Sole provider of 24/7 On-Call Support
- Performance tuning and improvement for SQL database objects
- Performed audit of existing installations and licensing
- Refreshed large 7GB single database with Quest LiteSpeed to all 5 environments
- Technology Used: MSSQL, Windows Server, Quest LiteSpeed, ETL, SAN, C#.NET, IIS, SSIS, SSAS, SSRS, ActiveDirectory 2008R2, PowerShell 4.0, TFS, IBM Cognos, Pure & Compellent Storage
SENIOR OPS DBA TEAM LEAD
Confidential
Responsibilities:
- Backup for Team Manager, team of 19 DBAs
- Team leader for 5 direct report DBAs in application group
- Responsible for very large petabyte sized datastore in multiple data center enterprise
- DBA tech lead for BizTalk 2013 in multiple data center DR setup
- Migrated multiple databases and systems upstream to SQL Server 2012
- DBA Code Review team member using TFS
- 24/7 On-Call Support on a weekly rotation
- DBA lead for DR exercises providing round-the-clock support
- SQL Standards Committee member, contributed multiple written standards
- Performance tuning and improvement for SQL database objects
- Management of Backups, Restores and Multi-Tier code refresh
Technology Used: MSSQL, Windows Server, BizTalk, EMC SAN, C#.NET, IIS, SSIS, SSAS, SSRS, ActiveDirectory 2012, PowerShell 4.0
SENIOR DATABASE ADMINISTRATOR
Confidential
Responsibilities:
- Responsible for 900+ database 7TB datastore in multiple datacenters
- Co-Administrator of BizTalk 2009 in multiple datacenters
- Chief Administrator for four IIS Web Farms versions 6 & 7
- Decomissioned, Rebuilt, Deployed and Repaired 2008 Cluster Nodes and Instances
- Chief Administrator for Assyst Trouble Ticket system for all of I.T.
- Migrated multiple databases and systems upstream to 2008 Clusters
- Critical Action Team Member for Security Review
- 24/7 On-Call Support on a weekly rotation
- Production Control for all SQL code promotion
- Managed SQL Tie-ins with Oracle JDE ERP & IBM iSeries systems
- Co-author of the SQL & SSIS standards document
- Performance tuning and improvement for SQL databases
- Management of Backups, Restores and Multi-Tier code refresh
- Technology Used: MSSQL, Windows Server, BizTalk, SAN, ASP.NET, IIS 4.0-6.0, SSIS, SSAS, SSRS, Active Directory 2008R2, PowerShell, DB2
WEB & DATABASE CONSULTANT
Confidential
Responsibilities:
- Content management system integration and creation (ASP.NET)
- Graphic element & Logo designs (Photoshop)
- Performance tuning, query and stored procedure rewriting (SQL)
- Social Networking tie-ins and messaging
- Search Engine Optimization and page-rank management
- Provide progress reports and future planning recommendations to C-level executives
Technology Used: MSSQL 2008, Windows Server 2003, VPN, SAN, ASP.NET, PHP, Cisco, XML, HTML, DB2, Microsoft Dynamics
DATABASE CONSULTANT
Confidential
Responsibilities:
- Database load-balancing, server building and migration in cluster (MSSQL)
- Interim-IT Director managing staff of 8 to achieve business goals
- Performance tuning, query and stored procedure rewriting (SQL)
- Baseline Performance logging and monitoring (MSSQL 2005)
- Upgrade path from (MSSQL )
- Integration of multiple applications to accounting backend database (MS Dynamics, SQL)
- Managing cluster, data warehousing and SAN access (LeftHand SAN, MSSQL 2005)
- Provide progress reports and future planning recommendations to C-level executives
- Technology Used: MSSQL 2005, MSSQL 2008, Windows Server 2003, VPN, SAN, Crystal Reports, ASP.NET, PHP, Cisco, VMWare, DB2
DATABASE ADMINISTRATOR
Confidential
Responsibilities:
- Financial data mining, verification and reporting (SQL)
- Primary administrator of four MS-SQL instances for various resources (SQL)
- SQL Database design, implementation and maintenance (MSSQL)
- Management and upgrades for CRM database (Junxure)
- Maintenance of Web-based middleware for multiple applications (ASP.NET)
Technology Used: MSSQL 2000, Active Directory, Access, Windows Server 2003, VPN, HTML, DHTML, VB, Junxure, Schwab Performance Technology
SECURITY ANALYST/DBA
Confidential
Responsibilities:
- User data mining, verification and reporting (SQL)
- Global account reconciliation with 161 country members (SQL)
- SQL Database design, implementation and maintenance (MSSQL)
- Installation and management of Global Security Agents (BMC, AIX, Windows, etc.)
- Maintenance of Web-based middleware for user account creation. (ASP.NET)
Technology Used: MSSQL 2000, Active Directory, Enterprise 2000, Access, Windows Server 2003, VPN, HTML, DHTML, VB, BMC Suite, AIX (+other Unix systems), DB2
WEB SYSTEMS DEVELOPER
Confidential
Responsibilities:
- Electronic Order Entry and Customer Care Application maintenance (ASP/SQL)
- BlackBerry mobile access to EOE Application functions coding (METAMessage)
- SQL Database design, implementation and maintenance (MSSQL)
- Bug hunting, code cleanup and conversion (ASP, ASP.NET)
Technology Used: MSSQL 2000, Active Directory, Enterprise 2000, ASP, ASP.NET, Windows Server 2003, VPN, HTML, DHTML, JavaScript, BlackBerry, VB, VB.NET
WEB SYSTEMS DEVELOPER
Confidential
Responsibilities:
- Remote Access Control system for North American customer support (ASP)
- CRM Application development and maintenance (ASP.NET, VB)
- SQL Database design, implementation and maintenance (MSSQL)
- Backup Systems Administrator
Technology Used: MSSQL 2000, Active Directory, Enterprise 2000, ASP, Windows Server 2003, Norton Ghost, PCAnywhere, VNC, Cisco PIX, VPN, HTML, DHTML, JavaScript, VB, VB.NET
WEB SOFTWARE TEAM LEAD
Confidential
Responsibilities:
- Web-based Software Team Leader (Developers, PM, BA)
- E-Commerce Web Security (IIS)
- Server Design and Implementation of SQL and Windows 2003 Server (MSSSQL)
- Software Design and Implementation Management
- Web Software Sales Lead for Dealer Networks
Technology Used: MSSQL 2000, Active Directory, ColdFusion, ASP, Enterprise 5, Norton Ghost, VNC, PCAnywhere, Cisco Routers, HTML, DHTML, JavaScript, VB
DIGITAL VIDEO TECHNICIAN
Confidential
Responsibilities:
- Created & Managed trouble ticket database online
- Top Tier Tech Support for Web-based Digital Video Delivery Software
- Automated News File Delivery system management
- Built and Deployed 100+ SQL/IIS Servers around the country (MSSQL/MySQL)
Technology Used: MSSQL 7, Active Directory, MySQL 4, ASP, Scala InfoChannel, VNC, Norton Ghost, PCAnywhere, HTML, DHTML, JavaScript, VB
NETWORK ADMINISTRATOR
Confidential
Responsibilities:
- Database Administrator for Contact and Project Management MS Access databases
- Email, FTP, Database, Web and Proxy Server Management
- Firewall & Security Administration
- VPN Support for mobile user base of 100+
Technology Used: Windows Server 2000, Access 97 & 2000, Enterprise 4, Cisco Routers, VPN, HTML
