SUMMARY:

To obtain a position which utilizes my strengths as a team leader, or mentor in a Microsoft .NET application development environment using SQL Server 2000 - 2008 as back ends. I have developed custom tools and applications using the .NET framework for ASP Web forms and Windows Forms based platforms.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server DBA/SQL Developer .NET C# SOA Development

Responsibilities:

• Use T-SQL development in SQL Server to read, store and create EDI documents relevant to the transportation industry (204, 990, 210 & 214) formats.
• Develop complex SSIS packages with C# code as well as T-SQL scripting and advanced stored procedures.
• Develop client side and server applications to utilize SQL Server’s Service Broker.

Confidential

SQL Server DBA/SQL Developer .NET Win Client Development

Responsibilities:

• Perform all phases of Database Administration in a Multi-Database, Replicated Environment.
• Use .NET to automate SMO using C# to automate the movement of SQL objects and settings between environments and servers.
• Use C# to E-Mail reports formatted as Excel spreadsheet.
• Published stored procedures according to guidelines put together by Plante & Moran.
• Build and tune stored procedures.
• Monitor SQL server statistics looking for negative trends.
• Built jobs, scripts of all kinds and conducted T-SQL code reviews and standards.

Confidential

SQL Server DBA/SQL Developer .NET Win Client Development

Responsibilities:

• Perform all phases of Database Administration in a Multi-Database, Replicated and Clustered Environment.
• Perform Partition Maintenance duties.
• Develop SQL Code to automate several Admin tasks like Index Maintenance and Foreign Key work.
• Develop various C# tools to work with foreign key maintenance.
• Participate on internal Confidential C# Framework and T-SQL Coding standards committees.
• Use .NET to automate SMO using C# to automate the movement of SQL objects and settings between Test, Development and Production SQL Server instances.
• Also created a stale data deletion project with both .NET and SQL server stored procedures.
• Member of company SQL Performance and T-SQL Standards Committees.
• Conducted several physical to virtual database server migrations as well migrations to an offsite disaster recovery location in Denver Colorado.
• Stood up Development/Testing/Productions tiers for multiple SQL Server Instances.
• This was all done in a clustered multi node environment.

Confidential

SQL Server DBA/SQL Developer/ .Net Web and WN Client Development

Responsibilities:

• Install, Monitor and re/configure 275+ SQL Server and SSRS Instances for High Availability, 24/7. SQL Server versions and Editions would include anything from SQL Server Express to SQL Server Enterprise Edition.
• Develop SSIS packages to monitor disk space usage and job completion status from a given set of Critical Servers.
• I have addressed and improved several vendor database performance issues.
• I have also developed and deployed several SQLCLR assemblies as custom table triggers.

Confidential

SQL Server DBA/SQL Developer/ .Net Web Development

Responsibilities:

• Primary DBA and SQL Developer for multiple SQL Server instances to build a Bonus program to incentivize Confidential dealers and service line personnel to sell Confidential approved products.
• Build C# .NET Windows Services and other applications to load a 500,000 line EDI file daily into the database as well as files in 6 other file types.
• Develop SSIS packages and convert and maintain existing DTS packages.
• Other accomplishments include the complete migration from SQL Server 2000 to SQL Server 2008 R2.

Confidential

SQL Server DBA/SQL Developer/ .Net Web Development

Responsibilities:

• Developed an application to allow for the dynamic assembly of PDF documents to print vehicle brochures for every Ford automotive dealer in the world.
• The end integration tool is called XMPie. XMPie is controlled via web services all through the .NET Framework using C# and SQL Server 2000 and 2008.
• I am utilizing and administrating the SQL Server 2000 and 2008 R2 to collect all the data and make it available 24/7 as well as developing with ASP .NET 4.0 and ASP .NET 3.5 to develop custom server controls and web pages in C# as well as working with XMPie’s web services as a consumer using custom serialization/deserialization classes and methods.

Confidential

Senior SQL Server DBA

Responsibilities:

• Primary DBA and SQL Server Developer for 6 SQL Server 2005 and 2008 servers and 100 Databases with thousands of connections.
• Assisted all developers in their T-SQL and stored procedure development.
• Analyzed databases for badly performing queries and rewrote them.
• Performed all DBA duties such as Backups and Restores as well as mirroring and replication and index tuning and DB Monitoring.
• Established and implemented T-SQL coding standards.
• Provided Classic ASP and ASP .Net code maintenance and new development projects to include ASP .NET web projects using. MVC, JSON, JQuery using both VB and C# as code-behind languages.
• Developed as WinForms projects as well. Wrote Web Service layers for various games and libraries as well as developed a completely new Data access layer for the .NET side of the house as well as re-working most of the access layer classes for existing core libraries in both VB .Net and C#.