Sql Server Support
Resume:
Charles C. Donaldson
Microsoft Certified Solutions Associate
*******@************.***
Professional Summary:
• Certified in Administering Microsoft SQL Server 2012 Databases, Implementing a Data Warehouse with Microsoft SQL Server 2012, Querying SQL Server 2012, Networking Essentials, and Implementing and Supporting NT™ Server 4.0. Also CompTIA A+ certified and NetApp Certified Data Management Administrator.
• Experience Cloud Technologies such as with VMWare, HP CSA, HP OO, HP DMA, HP Private Cloud/Public Cloud and other various other HP Helion Cloud offers. Also have some basic AWS experience with EC2 cloud formation templates.
• Dedicated professional with extensive hands-on database administration and network administration experience in large-scale production SQL environments.
• Broad knowledge and experience in matching appropriate technologies, designs, and systems development techniques with organizational needs, capabilities and resources, with experience in the healthcare and financial sectors.
• Comprehensive understanding of database development methodology from multiple perspectives: user, developer and administrator.
• Extensive experience in developing operational plans to meet organization goals; including disaster recover planning and implementation, database clustering, mirroring, replication and log shipping.
• Effectively communicate with all levels of management, customers, development team members, and vendors.
• Detailed oriented and committed to delivering superior quality work.
• Extensive experience is designing, implementing, and supporting SQL Server High Availability and DR solutions such as SQL Server 2012 AlwaysOn, SQL Server 2012 Clusters, SQL Server DB Mirroring, Replication and Log shipping.
Technical Skills:
Database Administration: SQL 20012, SQL 2008 R2, SQL 2005, SQL 2008, SQL 2000, Relational databases, SQL 2000/2005/2008/2012 Clustering, SQL Server AlwaysOn Clustering
SQL 2008/2005/2000 Log shipping; SQL 2005 Database Mirror; SQL Backup; SQL Diagnostic’s Manager;
Disaster Recovery: DoubleTake, Capacity Planning (Hardware and SQL), Long-term strategic planning and analysis, Failover testing and recovery, DR Site design and implementation
Applications: Bart PE, Ghost V8, DOS, Windows 2003, Windows 2008 R2, Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Microsoft FrontPage, Internet Explorer, Antivirus security management, User support, Installation, Product rollout, Beta Testing
Networking: SNMP, TCP/IP, SSL, NTFS, SMTP, SIP, RTP, DNS, NFS, Cisco IOS, Configuration, Optimization, Training, Active Directory, Microsoft.NET, LDAP, POP3, IMAP, HTTP (Smartermail), IPMonitor
Operating Systems: Windows, DOS, UNIX, Linux,
Network Operating Systems: Windows Server 2008, Windows Server 2012, Windows 2000 Professional, Windows Server 2003
Work History:
April 2011 – Present
Lead Database Engineer, HP
• Currently implementing and supporting Large Scale SharePoint Cloud project in which I designed the SQL Server Clustered Environment.
• Currently implementing and supporting the HP Helion Cloud Projects.
• Currently implementing and supporting a Large Scale Email Cloud Service project where SQL Server is the backend. I also designed this SQL Server Clustered Environment.
•Create Design, implementation and Design documentation for new projects.
• Support High transactional Production OLTP databases
• Configure and Support SQL Server Clusters, Database Mirroring and Log Shipping configurations
• Create, monitor, maintain and support SQL OLTP Databases, including Performance tuning
• Configure and support SQL high available servers
• Disaster Recovery planning, implementation and testing
• Migration planning, design, implementation, and support.
• Deploy patches and fixes to our Production SQL environment
• Create SQL Process documentation for our Operations teams to follow
Jan 2011 – April 2011
Sr Production Database Engineer, WellPoint Contractor (Sterling, Va)
• Support High transactional Production OLTP databases
• Configure and Support SQL Server Clusters, Database Mirroring and Log Shipping configurations
• Create, monitor, maintain and support SQL OLTP Databases, including Performance tuning
• Configure and support SQL high available servers
• Disaster Recovery planning, implementation and testing
• Migration planning, design, implementation, and support.
• Deploy patches and fixes to our Production SQL environment
• Create SQL Process documentation for our Operations teams to follow
December 2009 – July 2010
Lead Production Database Engineer, Standard Insurance (Portland, OR)
• Worked on several projects at Standard, including implementing MS Project Server, implementing SSRS in SharePoint mode. Migrated and upgrading many COTS applications.
• Worked on several migration projects at Standard, including migrating applications that used SQL 2000 and 2005 to SQL 2008.
• Support High transactional Production OLTP databases
• Planned, designed, configured and supporting our BI Environment (SSRS 2008, SSAS 2008, SSIS 2008, Performance Point, and SharePoint). MS Project Server also leverages this BI environment.
• Configure and Support SQL Server Clusters, Database Mirroring and Log Shipping configurations
• Create, monitor, maintain and support SQL OLTP Databases, including Performance tuning
• Configure and support SQL high available servers
• Disaster Recovery planning, implementation and testing
• Migration planning, design, implementation, and support.
• Deploy patches and fixes to our Production SQL environment
• Create SQL Process documentation for our Operations teams to follow
• Create monthly and quarterly SQL Server audits
• Provided 1st level support for Oracle databases on Linux/Solaris systems, including starting listeners and enabling printers
September 2008 – December 09
Senior Production Database Engineer, Volt at Microsoft (Redmond, Wa)
• Configure and Support SQL Server 2008 Clusters, Database Mirroring and Log Shipping configurations
• Support High transactional eCommerce Production OLTP databases
• Create, monitor, maintain and support SQL Databases, including Performance tuning
• Configure and support SQL high available servers
• Disaster Recovery planning, implementation and testing
• Migration planning, design, implementation, and support.
• Deploy patches and fixes to our Production SQL environment
May 2008 – August 2008
Lead Database Analyst, Northeast Medical (Charlotte, NC)
• Support High transactional Production OLTP databases
• Configure and Support SQL Server Clusters, Database Mirroring and Log Shipping configurations
• Create, monitor, maintain and support SQL Databases, including Performance tuning
• Configure and support SQL high available servers
• Disaster Recovery planning, implementation and testing
• Migration planning, design, implementation, and support.
• Provided on-call 1st level support for Oracle databases on Linux/Solaris systems, including starting listeners and enabling printers
August 2007 – May 2008
Sr Database Analyst, Fidelity National Information Services (Charlotte, NC)
• Configure and Support SQL Server 2005 Clusters, Database Mirroring and Log Shipping configurations
• Support High transactional eCommerce Production OLTP databases
• Create, monitor, maintain and support SQL OLTP Databases, including Performance tuning
• Configure and support SQL high available servers
• Disaster Recovery planning, implementation and testing
• Migration planning, design, implementation, and support.
August 2006 – August 2007
Database Administration Consultant, (Charlotte, NC)
• Configured and Supported SQL Server Clustering, Replication and Database Mirroring
• Create, maintain and support ftp access and SQL Databases remotely
• Configured SQL servers, setup Access databases and created reports, maintained databases, and created domains
• Manage network and acted as a liaison between Dell and other vendors for my small clients
• Manage DNS records, Image Servers, Disaster Recovery
• Troubleshoot any hardware/network issues that arise
May 2005 – August 2006
Database Administrator, ORCSWEB Inc. (Charlotte, NC)
• Configured and Supported SQL Server Clustering, Replication and Database Mirroring
• Create, maintain and support clients ftp sites, websites, email domains, SQL Databases, dedicated servers and shared servers
• Install Dell PowerEdge Servers at our Data Center and configure them for use as Dedicated web application servers, SQL 2000/2005 database servers, Shared web servers, or Webfarm servers
• Manage Vault development application allowing developers to access and upload code from anywhere
• Manage DNS servers and maintain/update the DNS entries
• Upgrade hardware, including adding memory, hard drives, and cpu’s to the Dell Servers
• Troubleshoot any hardware, network or application issue that arises
• Troubleshooting and rebuilding RAID 1 and RAID 5 configurations
• Maintain/Install and upgrade Component Services and Certificate Services
April 2002 - April 2004
Database/Network Administration Team Lead, Ceridian Employer Services (Atlanta, Ga)
• Install and maintain Live and test Servers, including Windows NT/2000/2003, Novell Netware 5/6, SQL Server 2000, SQL 7, Exchange 2000/2003 Citrix Metaframe and Citrix Winframe
• Support High transactional eCommerce Production OLTP databases
• Server Configuring and Troubleshooting DNS, WINS, TCP/IP, WAN/LAN, Active Directory, SMTP, IIS
• Configuring and Troubleshooting Hardware Devices and Drivers
• Managing Shared Folders, and Configuring Share Permissions for Web Content
• Monitoring and analyzing System Performance using perfmon, Event Viewer, Performance Console and Task Manager
• Managing and creating User Objects with Active Directory Users and Computers
• Managing, monitoring and troubleshooting Network Printers
• Configure and manage Web and FTP Sites using IIS 5 and IIS 6
• Create Schedule, manage and restore Backups using NTBACKUP and SQL Server Agent
• Experience with Normal, Differential and Incremental Backups and Restores
• Performing Disk Defrag and Configured Disk Quotas used drives
• Manage escalated Tech Support Calls
• Providing Phones support to our Remote Analyst/Reporters with connectivity problems, access request, and troubleshooting desktop problems
• Function as the LAN resource; configure protocols, Applying Service Packs, Performing updates and installing upgrades
• Configured Workstations, installed Drivers, Applications, and served many needs for the analyst
• Functions as the Network Resource, FTP Site Administrator, Communications resource, and Network Security resource for internal and external clients
• Used Enterprise Manager to Restore Add or Remove and Databases to our SQL Servers
April 1998 - April 2002
Application Support Analyst II/Database Analyst, Ceridian Employer Services (Atlanta, Ga)
• Maintained and supported clients websites and databases on SQL7 and SQL 2000, including performance tuning, benchmark testing, upgrading to SQL 2000, as well as configuring indexes, setting up backup maintenance plans, managing SQL users, and restoring databases (including tlogs and differentials) as needed.
• Provided 2nd Level Applications support for our S100, S500 and DOS customers
• Maintain customers' system via Remote Desktop to setup printers, check memory, check virtual memory, and export/import data
• Supported customer’s payroll software via modem, FTP, or PCAnywhere and ensure that the customer was able to communicate with our Network in order to transfer their files.
August 1997 – April 1998
Application Support Analyst II, PEACHTREE SOFTWARE (Atlanta, Ga)
• Provided 2nd level of support for One-Write Plus for both DOS and Windows
• Maintain customers' system via dial-up networking (PCAnywhere) to setup printers, check memory, check virtual memory, and export/import data
• Coordinated application upgrades with end users
• Replicate and Troubleshoot Application Problems and errors
• Test Beta Software in different environments
Professional Qualifications:
Database Administration: SQL Server 2012, SQL 2005 and SQL 2000 and SQL7, Server administration, Database programming, Performance and optimization techniques, Transactions and record locking, Report creation, Database design/installation, Relational database design, Database permissions, Database migration
Network Administration: Network OS Installations, network configuration, configuration of Domain Controllers and protocols, installing Network applications such as Mail Servers, Databases, Drivers. Establishing security policies and system recovery using RAID 5 and RAID 1, network optimization, network maintenance, Remote administration, Networking Operating Systems: Administration, Installation, Supporting, Planning, Security Administration, Configuration management, User management, Administer print services, Security planning, Protocol analysis, Systems backup, Security management, System troubleshooting, Login scripts, Client configuration
Hardware: Installation, Troubleshooting, Repair, Maintenance, PC Support, Peripheral devices and driver support
Operating Systems: Installation, Troubleshooting, End user training, Beta test,, Customer support, Field Service maintenance
Help Desk: Internal customer support, Escalation support
Technical Writing: Documentation, Technical manual development, User training, Help support
Systems Analysis: Team Leader
Quality Assurance: Product testing, Scalability testing, Quality Control, User assessment
Education:
1992- 1996 Clark Atlanta University, Atlanta, GA
Major: Computer Information Systems
2001-2003 AIU, Dunwoody Campus, Atlanta, GA
Major: IT
Awards:
2003-- Awarded the Ceridian Stars for excellent service for the year
2002-- Awarded the Quarterly Ceridian Stars for excellent service 1st Quarter
2001-- Awarded the Ceridian Stars for excellent service for the year
Certifications:
2014 – NetApp Certified Data Management Administrator
2012 Implementing a Data Warehouse with Microsoft SQL Server 2012
2012 Administering Microsoft SQL Server 2012 Databases
2000 Networking Essentials, and Implementing and Supporting NT™ Server 4.0
1999 CompTia A+ Certified Technician
Contact this candidate