Professional Experience

Confidential

To keep my skills honed, I have taken courses and developed application on Azure related to SQL Server 2008 R2/2012-13 administration, development, SSRS, SSIS, SSAS, SharePoint, Windows 2008, VB.net C 2007-2013. Active participant at SQL Server .net User Groups.

Confidential

SQL Server DBA/Developer/Architect Systems Engineer

• Upgraded 200 SQL Server 2000, 2005 2008 database servers physical and virtual ESX 4/5 environment to a 2008 R2 Cluster.
• Tuning servers, databases, queries, Indexes.
• Developed SSIS packages leveraging vb.net, C , T-SQL and WMI/WML to collect disparate distributed data from various applications and facilities with Visual Studio 2007-2013.
• Creating and optimizing T-SQL code base, HA DR Cluster, Log Shipping, Replication.
• SQL Server lead for the EMC Avamar storage rollout.

Confidential

SQL Server DBA/Developer/Architect

• Performance tuning SQL Server 2005, 2008 2008 R2 and Oracle 10g database servers in a virtual ESX 4 environment.
• Tuning servers, databases, queries Indexes.
• Creating and optimizing T-SQL code base. Developing ETL architectural flow and processes for SSIS packages using Visual Studio 2007. Reconfiguring server settings in accordance with best practices without disrupting application integration.
• Troubleshooting VB.net, ASP.net applications, Meditech, GE Centricity and other applications.

Confidential

SQL Server DBA, Systems Application Engineer

• Reconfiguring SQL Server 2008 R2 on VMware settings and drivers that integrate with SAP Business Objects Crystal Reports XI.
• Providing performance tuning and recommendations for tuning T-SQL.

Confidential

SQL Server DBA/Developer/Architect Systems/Application Engineer

• Database and Application upgrades.
• Installing, configuring, implementing and administering, SQL Server 2000/2005/2008 physical and virtual production databases.
• Creating SANs on HP Proliant Servers. And VMWare, Vsphere, VCenter, ESX, ESXi. Load balancing, multi-node clustering SQL Server Farm, Data Marts. Mirroring, Log Shipping, Replication Transact, Merge Snapshot , Disaster Recovery, Backup, restores, T-SQL scripts, stored procedures triggers.
• Monitoring, tuning and automating processes. SQL Profiler. ETL DTS and SSIS. SSRS Reporting.
• Configuring IIS and converting ASP to ASP.net web applications.
• Developed High Availability, Capacity, Disaster Recover, Compliance, and Business Continuity plans.
• Installed EMC Virtual Disk Library. Emc Navisphere, Networker, Celerra, Centerra, Clarion, Powerpath.

Confidential

SQL Server DBA/Developer System Application Support Engineer VI

• Systems and Database Administration functions.
• Installing, configuring, and administering Workforce Central with Crystal Reports, SQL Server Report Server and Oracle database.
• Troubleshooting, and resolving customer custom and Canned Crystal Reports and SQL Server Reports issues via phone, email, and remote Go2Assist application sessions.
• Database Administration functions including installation, configuration, tuning, Reports and disaster recovery.

Confidential

SQL Server DBA/Developer/Architect Systems Engineer Contract

• SQL Server 2000 production databases.
• Configuring maintenance plans, notifications, writing, reviewing and running T-SQL scripts, and stored procedures using Query Analyzer. Authored script to purge old database objects.
• Successfully executed a list of deliverables for Sarbanes Oxley Certification, including performing a data and security audit.

Confidential

SQL Server DBA/Developer/Architect Systems Engineer Contract

• Performing upgrades and data migration of SQL Server 2000/2005 servers.
• Designing, developing and administering SQL Server 2000 and 2005 databases.
• Utilizing BIDS, DTS SSIS for ETL migration projects and new development.
• Providing work around solutions for legacy code base, and developing new SQL Server 2005 database applications.
• Analysis, optimization and tuning of SQL queries, stored procedures and ETL processes.

Confidential

SQL Server DBA/Developer Systems Application Engineer Contract

• Installing, configuring, administering, implementing, and supporting 300 SQL Servers containing 1000's of development production databases.
• Configuring Maintenance plans, notifications, replication, mirroring, log shipping and clustering.
• Creating, reviewing, and running T-SQL scripts, and stored procedures. Set up traces using Profiler.
• Monitoring with Microsoft Operations manager MOM . SharePoint Server, ETL DTS.
• Using Enterprise Manager and Tivoli Storage Manager for Backup Restore, server migrations to Tivoli Storage Management TSM ProLiant and HP Integrity Servers disks and tape.
• OLAP Analysis Services Report Services. Resolve customer issues through standard troubleshooting methodology, and CRM resources.

Confidential

Systems and Database Administrator/Analyst

• InCenter .NET Portal Support. With SQL Server 2000 backend.
• Troubleshooting Enterprise database, hardware, network, Web and client/server applications.
• Code review and maintenance of LiveLink data object assets. Enforcing data encryption, SSL certificates, firewalls, proxies, and Integrated Security Tool IST application integrity.
• Trained myself on Philip's disparate ERP Solutions, including SAP and Oracle 11i.

Confidential

SQL Server DBA/Developer/Architect Systems Application Pre-Post Sales Engineer

• Installing and integrating Oracle 9i, SQL Server 2000 with proprietary applications.
• Oracle Portal, Http Server, Oracle self-service 4.0 Discoverer.
• Installed and configured Oracle 10g and 10gAS. Interfaced with field sales and tech representatives to troubleshoot application, database and connectivity issue.
• Provided Proof of Concepts for customer trials. Developed a Visual Basic.net add on to an existing application.

Confidential

SQL Server DBA/Developer/Architect Systems Application Engineer

Installing, configuring, and implementing Windows 2000 Server and SQL Server database systems.

Confidential

SQL Server Oracle DBA/Developer/Architect Systems Application Support Engineer

• Top Rational Technical Support Engineer November 2001.
• Systems and Database Administration functions.
• Installing, configuring, administering, implementing, and supporting Content Management, and Configuration Management UCM applications.
• Setting up test environments developing multiple node Information Systems. Database Administration, Relational Database Management Systems SQL Server7, SQL Server 2000 and Oracle 8/8i/9i information systems including Rational Content Studio, Clear Case UCM , and Clear Quest.