SUMMARY:

• Install Enterprise SQL Server database systems in shared and dedicated, physical and virtual environments for use with web and client - server applications.
• Administer multiple SQL Servers and named instances in an enterprise environment.
• Install and administer clustered systems using SAN technology.
• Design, install and implement databases in large scale environments.
• Administration: maintenance plans, backup (native & SQL Lite), restore, job creation, alerts, re-indexing, integrity checks. Versions: SQL Server 2005, 2008, 2012, 2014
• Performance Tuning: System performance analysis / tuning and query performance analysis / tuning using native SQL Server tools.
• Capacity planning: Proactively evaluate system status using jobs & VB script.
• Write T-SQL (stored procedures, triggers, functions).
• Perform database and system migrations to accommodate upgrades to newer releases of SQL Server and Windows operating systems.
• Document procedures and participate in Disaster Recovery drills.
• Implement SSIS packages.
• Roll out and support high availability solutions using SQL Server 2005, 2008, 2012, 2014 .
• Enforce database and server level security.
• Knowledgeable in TCP/IP concepts.
• Utilize virtual servers for database requirements using VMware.
• Change management through promotion (Development, Test, UAT, QA & Production).
• Can work remotely using high speed Internet connection to corporate VPN to complete all DBA functions. for 24 x 7 coverage
• Solid understanding of Windows environment for use with SQL Server.

EXPERIENCE HISTORY:

Confidential, Plano, Texas

SQL Server DBA

Responsibilities:

• Support production systems and migrate data from older servers to newer systems.
• Administer releases as they come available.
• Operate as a Remote DBA, working from my home.

Confidential, Philadelphia, PA

SQL Server DBA and Application Deployment

Responsibilities:

• Support for software used by member-firms that conduct the business of auditing and accounting.
• Construct new release documentation for administrators to install and operate systems using this software.

Confidential, Fort Washington, PA

SQL Server DBA

Responsibilities:

• Work with application developers, system engineers and other technology teams to test and promote code and changes, maintain stability and remediate problems throughout the enterprise.

Confidential, NY

Assignment:

Responsibilities:

• Additional SQL Server DBA for offsetting demands on the existing staff. Implement log shipping and replication for use during a disaster recovery drill as well as bring new ideas to the team as systems are being prepared for upgrades.

Confidential, Princeton, NJ

SQL Server DBA

Responsibilities:

• Remediate database and server related issues collaborating with Web Engineering, Software Engineering, Platform Engineering, Database Engineering, developers, vendors and clients.
• Performance tuning: make appropriate changes to system configuration after analysis.
• Write T-SQL code for development, updates and optimization.
• Use Remedy to catalog all requests and responses in accordance with service level agreements (SLA).
• Participate in project management to recommend appropriate use of environments shared, virtual or dedicated physical servers, security considerations, recovery model, server and SAN requirements, and cost estimates.
• Provide vendors, developers and business clients the best choices available to support new applications in accordance with company standards and best practices.
• Provide support to other DBAs when appropriate to insure overall team success.
• Install and configure SQL Server in shared, virtual and dedicated database environments.
• Develop and follow Standard Operating Procedures (SOP).
• System Upgrades to SQL Server 2005 and SQL Server 2008.
• Migrate database instances between systems and versions of SQL Server including 64 bit SQL Server 2005 on 64 bit Windows Server 2003 and 2008.
• Write VBscripts for jobs to proactively gather information from all of the SQL Servers in the enterprise, catalog results and distribute information to appropriate designates regarding problems requiring DBA attention.
• Perform database software installations, configuration and upgrades.
• Enforce company database Standards and Procedures in daily practices.
• Provide technical support in application development and upgrade processes.
• Participate in disaster recovery, policy, procedures, and drills.

Confidential, Glen Allen, VA

Manager \ SQL Server DBA

Responsibilities:

• Administer Microsoft SQL Server database systems in OLTP and OLAP environment.
• Perform backup and disaster recover preparedness, system and data security policies, write SQL code, job scheduling, capacity planning and Performance Tuning.
• Manage the SQL Server database systems in a High Availability environment by installing SQL Server 2000 in an Active/Passive Clustered configuration.
• Develop implementation plans and control change management as enhancements became effective in the system lifecycle.
• Manage changes in the lifecycle of a pharmaceutical data entry, retrieval and data reporting application. Work closely with the programming consultants ensuring that the methods and standards were kept consistent with standards and best practices.
• Advise/inform the business unit (clients) about the use of new features developed for the applications they use.
• Release new versions of applications when the testing and debugging has been completed.
• Create the Windows domain design. Utilize Wins, DHCP, DNS, print, fax and application servers. Construct procedures for tape backups, offsite tape archiving and disaster recovery.
• Install and manage all utilities required by the applications including Microsoft Internet Information Server for FTP, SQL Server for Bulk Insert and DTS and Oracle database servers. Maintain data communications lines between facilities.