We provide IT Staff Augmentation Services!

Database Administration Resume Profile

Summary

  • In response t your recent email concerning your needs for a Sr. level SQL DBA, I am enclosing a summary of my resume for your consideration. I'm confident that I possess the required communication, organizational, and interpersonal skills you are seeking for this position.
  • I believe that my record of responsibilities, integrity, proven abilities, and diversified work history will provide a good match t the requirements of this position. If you agree, I would certainly appreciate the opportunity t discuss how I can contribute t the future success of your company. I look forward t your response, and the opportunity t visit with a member of your organization in the near future.

Summary of Experience:

  • Working in the micro-computer industry for over 30 years with experience as a software engineer, network administrator, application project manager, and database administrator, managing projects through all aspects of development including:
  • Concept Formation
  • Physical Planning hardware Individual Servers t Data centers
  • Feasibility Studies Time and materials with scrum
  • Contract Negotiation Resources
  • Research Hardware/ Software and process flows
  • Installation an Setup of :
  • With Security considerations
  • Audits/Intranet/Extranet/Web apps
  • Database Mail / Alerts with best practices
  • Analysis Services
  • Integration Services
  • Replication - Snapshot/Transactional/Merge/ Log Shipping
  • Reporting Services
  • Notification Services
  • Service Brokers
  • Full-Text Searching
  • Designing Logical models
  • Designing Physical models
  • Ervin / Embarcader DB-Artisan
  • SSMS, SSIS, SSAS, and SSRS
  • Visual Studi 2000 2012 32 and 64bit
  • JAVA, PHP, ASP, C , Power shell, learning Android
  • I/ subsystem configuration and planning
  • Server Services
  • XML and web services experience
  • Microsoft SQLXML, Native XML Web Services
  • Sizing from ecommerce sites with 2 products being sold up t call centers with Terabytes of data being inserted/updated daily
  • Creation of Databases from scripts
  • Creation of tables
  • Network configuration and installation
  • Installation of cluster Services
  • Using the built in Server functions
  • Performance Tuning
  • Maintenance and Troubleshooting
  • OLAP cubes and services
  • Installation Management
  • Designing Cubes
  • Application Implementation
  • Staffing/Training
  • Technical and End-user documentation, training, and support.
  • Projects have varied in duration, scope, and complexity from concept through enhancements, and maintenance of mature product lines. Projects in some cases have overlapped in part due t being able t remotely administer the servers.

PROFFESIONAL EXPERIENCE

Confidential

Sr. Database Administrator Production

  • Hardware: Varies depending on client
  • Software:
  • MS SQL Server 2008 R2
  • MS SQL Server 2012
  • MS SQL Server 2012 R2
  • MS SQL Server 2014
  • Log-shipping
  • Replication setup and maintenance
  • MS SQL Windows Failover Clustering both Active/Active and Active/Passive

Confidential

Sr. Database Administrator Production

  • Hardware:
  • DELL Compellent SAN/ SERVERS
  • 458 TB on primary SAN with 250 TB on secondary
  • 28 production servers in 14 clusters log-shipping t datacenter
  • 143 secondary servers including pre-prod, QA, DEV, Internal clusters w/ offsite datacenters
  • Software:
  • MS SQL Server 2008 R2
  • IDERA backups with monitoring
  • Redgate Professional DBA tools
  • IDERA suite
  • Log-shipping
  • MS SQL Windows Failover Clustering

Confidential

Database Manager

Environment: SQL Server 2005 2008,2012, 12 Active/passive Clusters mirrored t DR, MS SQL 2012 AlwaysOnGroups, Windows 2003 Server, VB script , Dell R810/R510, Dell Compellent SAN storage, Crystal report, MS Office ,ETL, Service Oriented Architecture, T-SQL, OLAP, .NET, DDL, DML, OSSQL, TCP/IP, Named Pipes, DTS, SSIS, SSMS,SSAS, SSRS, Team Foundation Server, Powershell 2.0 3.0, windows 2003, 2008, HTML, CSS, IIS, XML, DNS, ODBC, ERWIN, Quest Spotlight, Redgate DBA ToolBelt.

Responsabilities included:

  • While working closely with the business units on multiple projects with teams of engineers t improve the commercial web sites. Reported directly t the CIO/Project Managers/Directors as well as assisted in the maintenance of all 2 environments, quality assurance and production.
  • Managed the work of SQL Server Team t include establishing objectives and work plans, priorities, tasks, and reporting on accomplishments. Provided technical leadership t the DBA Development team by assisting junior team members and sharing knowledge and research of tools/techniques
  • Work closely with Architecture, Integrations, data warehouse and BI teams in meeting responsibilities with regard t project management, operations, and implementation of future technical requirements
  • Installation and maintenance of all SQL servers.
  • Review of MS SQL 2012 Migration of SQL 2005 and 2008 R2 t 2012
  • Replication log shipping complete, Transactional with replication monitor.
  • Mirroring of all OLTP databases t offsite DR site
  • Clustering 12 complete clusters
  • Always On Groups of databases Set up of Finance applications with multi-subnet for DR
  • Master Data Services using MD Manager, MDS Model Deploy with web services with add-ins for EXCEL
  • Use of Multiple Active Result Sets MARS .
  • Dimension / Cube Design
  • MS Great Plains from ver 9 t ver 2013, upgrade of four separate companies.
  • Worked with Team members t solve current issues as well as planning for software rollouts.
  • Responsible for all imports of data from multi-dimensional, sources sizes from 2k t 800gig per session
  • Reporting of all production issues t be presented t management
  • Reporting new technologies t both data team and development team
  • Working in a multi project environment was able t maintain stability within all levels
  • Development of best practice for CLR assemblies and SSIS packages in 2005 and 2008 integrating 2010
  • Brought in VS 2012 t upgrade t 64bit support for data transfers
  • Implemented a design search t bring the data up t and maintain the current PCI standards for confidential information
  • Complete ownership of the SQL Servers, on 24/7
  • Provide continuous feedback on project status and offer constructive options t ensure project continues t meet original expectations
  • Identified resources and/or schedule conflicts and changing of project scope
  • Identified and presented resolutions of business/project issues, as well as the monitoring, tracking and reporting on project deliverables t ensure adherence t project plan
  • Monitored database performance and space utilization investigate and resolve reported issues as well as recommend upgrades/updates
  • Assisted project teams in setting up and testing development, test, and production environments
  • Research, analyze, and recommend patches, tools, and/or database upgrades t resolve issues and add features/functionality
  • Assist project teams in data modeling and architecting/designing data accesses methods
  • Expense budget planning and adherence

Confidential

Projects included:

  • Database Administrator While working closely with the business units on multiple projects with teams of engineers t improve the commercial web sites. Reported directly t the CIO/Project Managers/Directors as well as assisted in the maintenance of all 3 environments, development, quality assurance and production.
  • Review of MS SQL 2008 Migration of SQL 2k and 2005 t 2008 R2
  • Replication log shipping complete, Transactional and snapshot and replication monitor.
  • Worked with Team members t solve current issues as well as planning for software rollouts.
  • Responsible for all imports of data from multi-dimensional, sources sizes from 2k t 800gig per session
  • Reporting of all production issues t be presented t management
  • Reporting new technologies t both data team and development team
  • Working in a multi project environment was able t maintain stability within all levels
  • Development of best practice for CLR assemblies and SSIS packages in 2005 and 2008 integrating 2010
  • Brought in VS 2012 t upgrade t 64bit support for data transfers
  • Implemented a design search t bring the data up t and maintain the current PCI standards for confidential information
  • On-call rotation including one week per shift as well as at least one late day per week
  • Investigated and researched problem areas and identified areas of interest t increase performance

Confidential

Projects included:

  • Database Administrator While working closely with the business units on multiple projects with teams of engineers t improve the commercial web sites. Reported directly t the CI as well as assisted in the maintenance of all 3 environments, development, quality assurance and production.
  • Installation and review of MS SQL 2008 Migration of SQL 2k and 2005 t 2008
  • Replication merge of multiple masters as well as log shipping complete, primary and secondary and a monitor.
  • Responsible for set up and maintenance of all three in-house environments, as well as supervisory roles in set up and maintenance of client sites and data centers in national and international environments, including USA, Panama, UK.
  • Complete support of clients Tier 1 through tier 3
  • Worked extensively with teams of application developers t resolve issues and debug both front-end code as well as SQL server t create a stronger faster application.
  • Implemented the change management process, including best practices, upgrades and application of patches.
  • Monitored database servers and assigned workloads.
  • Worked with multiple projects giving priority and implementing solutions for each.
  • Implemented MMC t use as monitor and access point for the servers.
  • Used Erwin t create logical models that translated int physical models with scripts t build and document the production environment.
  • Used Microsoft's tools t perfmon, profiler t gather both baseline information as well as defining bottlenecks within the systems.
  • Planning and executing of all scheduled database activities then following up on jobs t make sure they ran properly
  • Implemented and maintained database security with groups, roles, users
  • Met with clients and upper management t maintain communication throughout the development lifecycle
  • Developed and implemented disaster recovery policies and procedures for both onsite and offsite situations
  • Used a variety of hardware including
  • ProLiant tower servers
  • ProLiant rack servers
  • ProLiant blade servers
  • IBM / HP Blade System for medium-sized businesses
  • HP Tape, disk-based backup products - Data protection for high performance, reliable recovery
  • NAS solutions - Flexible, windows-based network storage and file sharing access
  • SAN solutions - Consolidate and manage shared pool of storage assets
  • Testing of the new G6 servers with MSA2000i with a ProCurve Ethernet switch
  • Defined best practices for current staff as well as for client sites
  • Worked with SQL developers t fine tune stored procedures, ETL, and SSIS procedures.
  • Clients t include:
  • Thread-Rite Current projects include conversion tables, ecommerce solution, current maintenance with production support.
  • Culinary International Current projects include: email marketing and maintenance
  • GoRadioActive.com Current projects include: Stock photography and site maintenance
  • Katrina Long Current projects include: production support
  • Michael St Amand Current projects include: 2005 report services maintenance
  • Prima Luce on the River Current projects include: Real estate Broker office, with project management

Confidential

  • Projects included:
  • Training of jr level DBA's
  • Documenting all necessary configurations, processes, and policies for both usage and administration
  • Upgrading and updating installed systems, processes, and documentation as necessary
  • Audit of production servers as well as implemented best practices in development and production
  • Reengineered the backup and recovery process
  • Business process review interconnecting AS400/ DB2 with SQL 2000/ 2005

Confidential

  • Projects included:
  • Created a complete WEB front end t Microsoft Business Financials
  • MS SQL 2005/ Macromedia Flex 1.5/2.0 / ASP / WEB Services ASP and xml
  • Retail management back end integration t Microsoft Small Business Management. Our primary goal for the client was t provide a Point-of-sale package for the clients retail outlets, a secondary objective was t provide the client with a digital dashboard of real time information throughout the day.
  • Responsibilities t include configuration, and maintenance of MS SQL Server 2000/2005 DBMS in a NT 2003 environment. Conversion of 2000 t 2005 SQL Server, Development and implementation of automated backup and recovery strategies, performance tuning, creating policies, setting standards for security, and documentation of the MS SQL Server environment.
  • In addition t the backend I was required t learn Macromedia Flex 1.5 3.1.
  • Creation of Web services for credit card verification.
  • Creation of receipt printing templates
  • Drivers for barcode scanners and Epson printers.

Confidential

  • Projects included:
  • Statistics production fine tuning
  • Production Support On call level 3
  • Development DTS backup and recovery
  • Responsible for the installation, configuration, and maintenance of MS SQL Server 2000 DBMS in a NT / HP-SAN environment. Supervision of automated backup and recovery in both production and development. Implemented modifications t the design of the data warehouse. Provided 24x7 coverage in a clustered, multi-server production environment Implemented DTS packages t transfer information t an Oracle based application.

Confidential

  • MS SQL Server 2k multiple production and development
  • Projects included: ALLINONE, Document imaging, Assist, RFS, Phonebook
  • Responsible for the installation, configuration, and maintenance of MS SQL Server 2000 DBMS in a NT environment. Development and implementation of automated backup and recovery strategies, performance tuning, creating policies, setting standards for security, and documenting the MS SQL Server environment.
  • Provided management with Documentation for current and legacy systems, using ERWIN 4.1.2 volumetric planning, and replication between sites.

Confidential

  • Projects included:
  • Accounting Accounts Payable, Accounts Receivables General Ledger
  • Production Telecommunications, Retail management, Call Center
  • Development - Telecommunications, Retail management, Call Center
  • Responsible for the installation, configuration, and maintenance of MS SQL Server 2000 DBMS in a NT environment. Development and implementation of automated backup and recovery strategies, performance tuning, creating policies, setting standards for security, and documenting the MS SQL Server environment. Provided management with capacity planning for current applications, with projected future growth int the terabyte range for Client's database environments. Implemented modifications t the design of the data warehouse. Managed the migration of existing applications and the development of new applications int a web-enabled environment. Was involved in development and execution of project plans, presentations, needs analysis, and delivering customer driven results. Provided 24x7 coverage in a clustered, multi-server production environment and coordinated onsite contractors and staff t resolve problems in legacy systems as well as new development. I provided all error handling procedures. Implemented DTS packages t transfer information t an Oracle based application. While using FTP replication t acquire information from multi-location retail outlets running php with a mySQL for inventory reporting and sales forecasting.

Confidential

Database Administration

B2B project provided shipping information t multi-national corporations for shipping overseas clients included Home Depot, Fed Ex, UPS. Managed all 7 production environments with WWW server farm, DEV. server farm and versioning. Trained in-house development staff in providing best practices for multi-project development teams. Mentoring of individual application/SQL developers. Provided DTS scripting and replication of data/structures using merge and transactional replications schemas in the multi-server environment. Responsible for upgrade and implementation of SQL 2000 clustered servers in both an active/passive development and active/active Production/WEB design. Redesigned and Implemented new maintenance procedures for the current production eCommerce database. Responsible for design and implementation of all stored procedures. Database administration Installation, configuration, application installation and configuration, security both SQL server and Network, system auditing, backup, recovery, user management, check for health, performance tuning, sizing and capacity planning, system uptime, planning and scheduling of system fail over, disaster recovery, etc. . Extraction of eCommerce data from order fulfillment process t decision support reporting. ERWIN Logical and physical design , WEB server IIS 4.5 with both source code management and configuration management experience using Microsoft Visual SourceSafe.

Hire Now