PROFESSIONAL SUMMARY:

• 12 years experience in designing, administration and maintenance of production and development databases. Full lifecycle database application analysis and development experience in industries such as finance, legal, government, communications etc.
• Continuously seek innovative ways to improve operation productivity via introducing new technologies, systems and methods.
• Very strong in MS SQL Mirroring, clustering and replication.
• Experience in creating SSIS packages. Experience in DTS Migration and Meta data Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in data migration (using tools like DTS, BULK INSERT, BCP and Replication) between different homogeneous and heterogeneous systems and SQL Server.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Well organized, detail oriented and quick learning; Enthusiastic team player and self - starter. Works well in fast paced environment and under multi-tasks.

PROFESSIONAL EXPERIENCE:

Confidential, Mt. Pocono, PA

SQL DBA

Responsibilities:

• Develop and document standards, policies, procedures and key performance metrics that support the continued improvement of IT services
• Work closely with project managers, application developers, and system administrators on new and ongoing IT projects
• Assist system DBA team by performing backup, recovery and archival tasks on databases management systems
• Assist with Windows Server configuration and management as it relates to MS SQL Server installation and performance
• Provide support and guidance to Application Developers in creation of stored procedures and other database objects to ensure quality and high performance
• Provide support and technical expertise to development, QA and other teams
• Assist developers with all the database activities

Confidential, New York, NY

SQL DBA

Responsibilities:

• Created procedures, reports and queries requested by the CR department
• Data migration using SSIS and stored procedures across different databases, MS access/Excel & flat files.
• Designed and implemented new databases requested by the CR dept
• Created Excel macros to streamline the data cleaning process
• Developed processing guides for collecting and cleaning datasets
• Maintained internal control of the database involving implementation, tuning, throughput, optimization, security and integrity of the environment.
• Responsible for ongoing SQL Server performance tuning and troubleshooting.

Confidential, Newark, NJ

Applications Analyst

Responsibilities:

• Responsible for ongoing SQL Server performance tuning and troubleshooting.
• Participant in IT security review, design and implementation. Assistant to and support for corporate IT security audit.
• Plan, setup and test to certify new SQL server versions and patches to internal products. Successfully managed and upgraded SQL Server from version 2000 to 2005, 2005 to 2008 R2, 2005 and 2008 to 2012.
• Responsible for reviewing database codes from developers; developing stored procedures and Ad-Hoc SQL Server queries to support developer and tester needs and prototyping.
• Worked with Applications, Litigation, and Network teams to plan, design, install, configure and upgrade database servers; administer and support Production Servers in day to day operations.
• Participate in Disaster Recovery planning and design
• Plan for system growth and monitor capacity usage for new hardware or software requirements and communicate these requirements to upper managements.
• Proposed, architected and managed SQL 2008 R2 MS Reporting Service for product reporting solution, and develop SSIS packages for internal data transformations.
• Proactively using tools and custom scripts to monitor production database systems alerts and performance to identify and prevent potential issues.
• Provide best practices for database development and deployment. Significantly improved database and application code promotion and deployment. Mentoring Litigation, and Application teams on stored procedures writing, indexes turning and other database development activities.
• Manage database security and user access. Provide technical support and assistance to all database end-users. Provide 24x7 on-call database support.
• Import Excel Datasets into SQL\Access. Convert Excel spreadsheets to SQL DBs.
• Utilized Access & Excel applications for reporting.
• Created Excel macros, Pivot Tables, Formulas, and V look ups

Confidential, Glen Rock, NJ

Systems Administrator

Responsibilities:

• Last Level Support - worked with clients to solve problems the support team could not resolve. Worked with vendors if problem was product related.
• Managed Rental Machines - Determined needs, ordered new and replacement machines, returned end of lease machines, coordinated with consultants to image new machines and repair damaged ones, scheduled with clients swaps and returns. Purged data from machines before returning.
• Supervised Consultants - Trained, distributed work, assessed quality of work, and maintained standards
• Imaged all new machines for East Coast Operations 1500+ machines
• Created standard images for machines - Determined the needs of our diverse client base and created several images which met the needs of several groups and machine models. Tested all images to maintain quality and resolve issues.
• Document operational, installation, and testing guidelines for the support staff.
• Work with Hardware and software vendors to solve problems.
• Evaluated all new software and upgrades. Organized client testing. Worked with vendors to resolve any issues.

Confidential, Newark, NJ

Programmer/ Analyst

Responsibilities:

• 2nd Level Support
• Evaluated code written by developers
• Traveled to remote sites to setup software and equipment