SUMMARY

Senior Database Administrator - Developer: Database administration of a variety of database platforms including SQL Server, Sybase, MySQL, Oracle. Performance optimization of both hardware and queries. Microsoft Windows Server and SQL clustering and availability groups. Database modeling and development, M. S. Analysis Services development. Development of a variety of tools of ETL automation as well as tool for managing database systems, virtualized environments VMWare Power CLI , Power Shell scripting, JavaScript validation, etc.. Data warehouse modeling and processing. Strong knowledge of SQL query language. ETL design and optimization using SSIS, BCP, etc. Configuration, installation, optimization of SQL Server and Sybase ASE database server systems on Red Hat Enterprise Linux. Training of both technical and non-technical personnel on a variety of technologies.

TECHNICAL SKILLS

Microsoft SQL Server, M.S. SQL Server 6.5, 7, 2000, 2005, 2008, 2012, 2014. Sybase ASE 15.x. SQL replication. Microsoft Server and SQL Server clustering, disaster recovery planning. Crystal Reports report writing. ETL, SSIS, OLAP, database mining, DAX, tabular data modeling, Microsoft Reporting Services report development, COGNOS reporting development Excel Power Pivot. C , ASP .Net, Script, Java Script, CGI, HTML, ASP, VB, Oracle 7.3-8.x, Oracle 7 to 8 and 8i, Windows server 2003, Server 2012, 2008, 2000, XP server and NT-4 server installation and configuration. Red Hat Enterprise Linux, Sun Solaris, Windows 95 / 98, Window 3.x, Windows for work groups, MS-DOS, Apple system 7, Team Foundation Server 2005 and 2008, TFS 2005 to TFS 2008, Microsoft Build design and builds.

PROFESSIONAL EXPERIENCE

Confidential

Senior database administrator

• Administration of Microsoft SQL Server 2008, 2005, and 2012 Enterprise Ed. databases.
• Development and modeling of Microsoft Analysis Services tabular data warehouses.
• Database administration support in a 24/7 99.997 uptime required production environment.
• Administration of Microsoft SQL Server high availability technologies including availability groups, clustering, and virtualized environments in VMWare.
• Development of SQL queries, stored procedures, SQL Server Integration Services SSIS packages, and other supporting software in support of the companies billing system and requirements.
• Performance monitoring and tuning of critical database systems in support of 1st tier applications requiring consistent query response time less than 100 ms.
• Design of ETL packages for transferring of data between disparate systems using SSIS, Stored Procedures, scheduled MS-DOS batch scripts, etc.
• Report writing and optimization. OLAP, database mining, Microsoft Reporting Services report development, Excel Power Pivot.
• Upgrade of Microsoft SQL Servers in a high availability environment inclusive of Microsoft server, SQL Server clustering technologies, and SQL availability groups.

Confidential

Senior database administrator

• Development of stored procedures, user defined functions, SQL Server Integration Services SSIS packages, ETL, as well as Windows Power Shell applications for IT operations.
• Development of Automation of VMWare virtual machine refreshes, and Compellent SAN snapshots via Power Shell. VMWare PowerCLI and Compellent Command Set.
• Development custom automation jobs for Sybase ASE administrative functions including backups, index optimizations, and other misc database management tasks. Inclusive of writing scripts for SAN replication tasks.
• Administration of Microsoft SQL Server 2008, 2005 and 2000 Enterprise Ed. databases.
• Sybase ASE 15.x database administrator. Including installation, administration, upgrading, disaster recovery, troubleshooting and SAN snapshot replication. All on Red Hat Enterprise Linux.
• Production database administration in support of BAAN ERP software and other ERP systems.
• Transact SQL Server T-SQL development of various administration tasks including index optimizations, backup and recovery, etc.
• 24x7 support as required.

Confidential

Senior database developer

• Development of stored procedures, user defined functions, SQL Server Integration Services SSIS packages, ETL, and other supporting programming.
• Development in support of check writing software reporting software that output thousands of compensation checks per hour based on complex business logic rule sets.
• Transact SQL Server T-SQL development on a financial compensation system, in support of highly complex business rules, in a rapidly changing environment.
• On call duty during peak month end business cycles.

Confidential

Senior database administrator

• Team Foundation Server administrator, Team Foundation Build master. For the purpose of source control and development build cycling in an Agile development model
• Development and administration of database systems in support of 3M vehicle registration software.
• Query optimization and trouble shooting, database implementation, disaster recovery planning, code migration, etc. TFS administrator and TFS Build administrator and developer.

Confidential

Senior database developer

• Development of various reporting projects against SQL 2005 databases to 400GB in size.
• Wrote custom index maintenance routines, in SSIS. Write ETL in SSIS for de-normalized data tables.
• Wrote stored procedures, develop distributed views, initiate replication topology, consult on best practices for reporting projects written in C WPF.
• Worked with M.S. Reporting Services and develop stand alone applications.
• Report writing and optimization. OLAP, database mining, Microsoft Reporting Services report development.
• Developed, configured, and optimized distributed views against over 150 databases with matching schema / different customer bases for reporting purposes.

Confidential

Senior DBA /Developer

• Development and data warehouse design for Cognos reporting server including OLAP and star schema based reporting database schemas for data mining.
• Developed customized maintenance jobs to defrag and rebuild indexes, execute backups, update statistics, etc, in a resource and maintenance down time limited environment.
• Administration of Microsoft SQL Server 2005 and 2000 Enterprise Ed. databases.
• Administration of over 30 instances with an average database size of 300 400GB.
• Performance tuning and re-writing of existing stored procedures and UDF's, including index tuning and optimization.

Confidential

Senior SQL Server Database Developer

• Developed ETL for a large scale data merge process that included merging archival data into existing production data, including duplicate record recognition and resolution as well as merging de-normalized data into 3rd normal form data.
• Involved significant work in data validation and testing the data both pre and post deployment of the data merge. Day to day maintenance including backups, DTS execution logging and trouble shooting, and 24x7 support.
• Administration of SQL Server 2000 and 2005 databases, with over 30 database instances.