Resume

Resume Details
A. G.
Location	Trenton, NJ
Contact	Click to View Contact
Source	Direct Candidate
Salary	N.A.
Rate	N.A.
Resume


Experience 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 Active-Passive clusters 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 2000, 2005 and 2008 R2.
Performance Tuning: System performance analysis - tuning and query performance analysis - tuning using native SQL Server tools.
Capacity planning: Proactively evaluate system status using jobs  VBscript.
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.
Develop and support for SSIS packages.
Provide and support SQL Server Reporting Services and Analysis Services.
Roll out and support high availability solutions using SQL Server 2000-2005-2008.
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).
Implementation of 32 and 64 bit SQL Server 2005-2008-2008 R2.
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 and RAID levels.


Experience History
04-16-2012 - Present

         Micthell Martin
                     307 W. 38th Street, Suite 1305 NY, NY 10018
                     Assignment: 
         Cenlar Bank: 425 Phillips Boulevard Trenton, NJ 08618
                     Additional SQL Server DBA for offsetting demands to the existing staff as well as bring new                                        ideas to the team as systems are being prepared for upgrades.

11-01-2008 - 04-2012
         TyGar Data Solutions SQL Server Database consulting projects

Assignment:  11-02-2011 - 01-31-2012
Kimba Medical Supplies: Seaside Park, NJ. - Upgrade SQL Server database system for an order entry system from SQL Server 2000 on Windows 2000 to SQL Server 2008R2 on Windows Server 2008. Enhancements to the application required schema changes and testing to verify valid system operations. Automated database maintenance jobs were created to simplify the turnkey objective in this assignment.



Assignment:  10-04-2010 - 08-20-2011
Merrill-Lynch: Pennington, NJ. - SQL Server DBA for mission critical systems support. Provide support for operations, fault remediation and system life cycle changes. Work with developers, system engineers and other technology teams to test and promote code changes, maintain stability and remediate problems throughout the enterprise. Upgrade database systems to newer versions of SQL Server as part of the upgrade and planning process and communicate with all other technology teams when resolving application, system and performance incidents. 
                       
 Assignment:  05-03-2010 - 10-03-2010
Merrill-Lynch, Pennington, NJ 08534 - SQL Server DBA-Programmer on a project for Merrill-Lynch and Bank of America. We are creating a customer service web fronted customer requests and resolution application to be used by all Bank of America and Merrill Lynch customer service agents and managers to manage all banking and investment requests and inquiries worldwide. Design database structures, stored procedures, performance tuning and deployment as part of the application development team. 

                        Assignment:  08-06-2009 - 11-20-2009
Merrill-Lynch, Pennington, NJ 08534 - SQL Server DBA-Programmer on a project for Merrill-Lynch and Bank of America aimed at a long-term campaign to groom customers from Bank Of America as financial clients into Merrill-Lynch investment clients. Design SSIS packages to import and export data between corporate sites. Write stored procedures to support the application and SSIS packages. Create and modify tables as the database design warranted changes. Use source control, Microsoft Visual SourceSafe, to catalog all additions, changes and deletions from previous system designs.

Assignment:  11-17-2008 - 06-24-2009
Therapeutic Devices 1800 Blvd, Seaside Park, NJ 08752 - Performed a system upgrade and migration of SQL Server 2000 to SQL Server 2005. Install new hardware and Windows operating system. Upgrade and re-write packages from DTS to SSIS as well as write modifications to SQL code. Coordinate efforts with application programmers as their modifications were being made. Create SQL Server maintenance jobs to insure system recovery as well as jobs to support the application functions.

01-06 - 10-19-2008   Bristol - Myers Squibb 
                                  100 Nassau Park Blvd., Princeton, NJ 08540

                                  SQL Server DBA (Database Engineering)
Support over 200 (Dev, Test, UAT, Prod) databases.
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.

07-04 - 12-05            SELF-EMPLOYED - Computer System Development and Support as a private consultant. 
                                  Completed several database designs, setup maintenance plans and support projects for 
                                  Clients, using Windows Server 2003 with SQL Server 2000 database systems.

                                                                     
01-00 - 06-04           First Health Services Corporation 
                                 4300 Cox Road, Glen Allen VA 23060 (assigned to the Princeton, NJ facility)

                                 Manager \ SQL Server DBA
Manage the technology team at the Princeton, NJ facility including DBA, .NET programmer, Windows Server person and desktop support person. Hired and performed yearly reviews of these employees including supervising daily activities and initiatives.
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.


09-98 - 01-00           COMPUTER LEARNING CENTER
                                 50 Craigwood Road, South Plainfield, NJ 07080
                                 9-98-11-98 part-time Evening Instructor. 11-98 forward, full-time day Instructor.
Teach Windows NT Operating System and elective courses from Official Microsoft
                                        training materials. 


Use extended laboratories, explanations and additional training materials for students 
      seeking networking careers and having MCSE certification goals.                                 

8-97 - 11-98              PRUDENTIAL INSURANCE COMPANY
                                  1 Prudential Drive, Cranbury NJ 08512
                                   LAN Analyst: Support an Enterprise of NT servers, domain controllers, application 
                                   servers, print servers, network printing, tape backup systems, in a client-server and 
                                   mainframe environment. Perform network administration in a multiple master domain 
                                   including data and user migrations between domains. Monitor and tune systems 
                                   performance. Install and maintain SQL Server database systems. Support the desktop group 
                                   with client-Server related issues. Manage data security, accessibility, system capacities, 
                                   system and user data backup and restoration, anti-virus protection and other activities. 

2-95 - 8-97               SAKS FIFTH AVENUE, Lawrenceville Data Center
                                 2303 Brunswick Pike, Lawrenceville, NJ 08648  
                                 PC Analyst: NT system installation, administration and support. Systems include 
                                 application servers, print servers, DHCP servers, WINS servers and DNS servers in a 
                                 diverse environment including mainframe, HP-UX, Novell and NT. Install and support
                                 client-server applications for user community, develop PC and Lap-Top application
                                 suites for standard PC configurations. Develop and distribute special configurations 
                                 for remote locations and dedicated processing requirements. Provide Tier-3 support 
                                 for the helpdesk. Upgrade systems and support migrations from Windows 3.x to 
                                 Windows 95*, Windows NT Workstation and Windows NT Server.

2-92 - 1-95                SELF-EMPLOYED - Real Estate Broker-Salesperson

10-84 -2-92               SELF-EMPLOYED - Restaurateur

2-79 - 10-84              HEWLETT-PACKARD  Manhattan Avenue, Fullerton, Ca. 
                                 Customer Service Engineer: Installation and maintenance of pre HP-UX operating system 
                                 for HP 3000 business computer systems. Installation and updates to hardware and OS and 
                                  products function and ongoing support. System level support for hardware and operating 
                                  issues including problem diagnosis and resolution. Maintain continual customer relations 
                                  and a high level of customer confidence.

Education                  MCDBA Microsoft Certified Database Administrator
                                  MCSE Microsoft Certified Systems Engineer
                                  Electronics Technology Graduate - RCA Institutes, NY, NY
                                  HP 3000 computer systems training - Hewlett-Packard
                                  Microsoft Courses - Dow Jones Training Center, Princeton, NJ  Self Training  

Military Service        USAF Reserves, Honorably Discharged.
<< Back
Resume

Similar Candidates
