SUMMARY:

• Experienced Information technology specialist with record of success in simplifying IT operations. Proven team leader with demonstrated ability to communicate and resolve issues between business units and management levels. Creative problem solver with the ability to develop and strategically improve reliability while consistently exceeding goals.
• Technology - Solid background with Windows 2003, 2008, 2012 R2, 2016, 2019 CentOS, Red Hat, and zLinux operating systems. Extensive experience with SQL Server, Oracle. Netezza, Teradata, Redshift, Postgres, and MySQL platforms. Highly developed troubleshooting and problem solving abilities.
• Problem Solving - Regularly displays advanced skill in solving complicated issues. The ability to design simple solutions to complicated scenarios and problems. Proven record for creating reliable system architecture.

PROFESSIONAL EXPERIENCE:

Sr. Database Administrator Team Lead

Confidential

Responsibilities:

• Worked with developers to guide changes through environments. Lead team of 6 DBAs in supporting 146 SQL Server installations and two Oracle instances. Designed database systems for high availability and disaster recovery. Worked with both SQL Clustering and AlwaysON technology. Created coding standards for developers and junior DBAs to follow.
• Advised developers to efficiently tune SQL code for optimal performance. Developed solutions to increase and tweak database performance. Performed troubleshooting of SQL Servers. Created performance baselines and developed systems to gather metrics to predict future growth of systems. Designed and implemented SQL failover cluster using SQL 2008 and Windows Server 2008 R2. Later upgraded cluster to SQL Server 2014 and Windows Server 2012 R2. Setup log shipping, SQL replication, database mirroring and used third party products to meet disaster recovery requirements. Developed systems to exchange data between other database platforms including DB2 and Oracle.
• Created disaster recovery plan. Setup data replication between SQL servers for different departments and data consumers. Setup reporting services and crystal reports and worked with developers to deliver data reporting needs. Monitored system usage to insure adequate resources and made recommendations to developers, managers, and senior management. Lead team to design SQL 2008 upgrade strategy. Designed database maintenance systems using maintenance plans, written scripts, and third party tools. Implemented Qlikview system leading a team of 4 BI developers.
• Migrated database content from SQL Server and Sharepoint to Mysql and Drupal. Later migrated from Mysql EC2 instances to Amazon Aurora RDS instances. Used both instance based and serverless based implementations. Planned capacity for serverless Amazon Aurora RDS to reduce costs and still provide adequate performance for front end applications. Lead team in successfully deployment of Netezza data analytics platform. Converted 11TB data warehouse to Netezza over 18 month period. Converted queries, stored procedures, and sequences to work on Redshift from SQL Server and Netezza. Continually optimizing Redshift Queries. Lead team of 10 DBAs to successfully implementation of SQL Server 2014 upgrade and migration to AWS. Worked to Migrate Netezza to AWS Redshift and Google Big Query.

Database Administrator

Confidential

Responsibilities:

• Designed and managed installation of Microsoft Axapta 4.0 ERP installation. Performed data migration from GP 8.0, Radio Beacon, AccPac, and proprietary software. Install SQL Server 2005 Passive/Failover on EMC SAN Cluster. Manage EMC Clarion SAN. Setup maintenance plans to do database backups, integrity checks, and optimizations. Setup notifications to alert systems team of failed backups.
• Deployed SSAS 2005 to provide business with business intelligence reporting system.

Database Administrator

Confidential

Responsibilities:

• Maintain SQL 2000 and SQL 2005 database servers. Develop and maintain SQL Scripts, Stored Procedures, and T-SQL statements. Become familiar with HL7 and ensure database designs meets standards. Evaluate status of SQL servers and make recommendations on how to maximize SQL Server performance. Assisted with Great Plains 9.0 implementation.
• Lead team of developers to create business reports in Business Objects to provide comprehensive revenue and expense report system. Worked with SQL Server 2005 to generate Word 2003 and 2007 mail merge documents which automatically updated content based on views. Developed front end applications to work with SQL Server back-end data.

Network Engineer

Confidential

Responsibilities:

• Maintained large network infrastructure of 40 servers and 500 clients including WAN link between 4 different branch offices, VPN, Pix firewalls, Tipping Point IPS, Cisco routers and switches, and Dell switches. Worked with PIX 525 and 515 firewalls and Tipping Point IDS / IPS. Deployed comprehensive spanning-tree solutions using fiber optics on Cisco and Dell switches. Planned, setup, installed, and maintained SharePoint Portal web server. Designed and implemented SQL 2000 replication topology to minimize downtime and provide high fault tolerance.
• Implemented and maintained Microsoft Dynamics products (GreatPlains and CRM). Setup and maintained SQL backup and maintenance routines. Maintained .NET web applications and supported COM+ objects. Provided support to systems admin on Dell servers, tape drive, and SAN arrays. Evaluated software and hardware to recommend purchases to COO. Assisted with budget recommendations. Deployed SQL 2005 Cluster on Windows Server 2003.

S ystems Engineer

Confidential

Responsibilities:

• Designed and installed 4 server and 100 client network. Supported 75 other software engineers. Setup and designed redundant internet connection for 99% availability. Managed large network stores and cluster machines. Deployed Exchange Server 2000 in Windows 2000 Server environment. Installed NetVanta 3200 and Cisco 2600 and deployed L2TP VPN for employee use. Deployed small 3 user PPTP VPN using Windows Server 2003 RRAS for separate subnet used to transfer large log files from customer. Assisted users over in China to connect to VPN.
• Installed Lotus Domino 6 on Windows Server 2003 to assist with Lotus development project. Worked with development team and installed Tomcat Apache web server to develop and test ASP and ASP.NET websites for clients. Designed and maintained SQL 2000 database backend to work with front-end web application. Worked with junior systems administrator to train on implemented technologies.