SUMMARY:

• Over twenty years of related experience in Database Administration, Design Development and Support of client/server multi - tier business-to-business, financial, e-commerce and scientific applications in Production, Test, Development and Cluster Server Environments .
• RDBMS modeling/architecture, LAN configuration. Good communication skills, management experience in the different areas of software development and customer support. Pro-active, self-starter attitude.
• Hands on Experience in installing, configuring, managing, monitoring, and troubleshooting SQL Server 2000/2005/ 2008/2012/2014/2016 , including Load Balancing and Fail Over custom made system.
• Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication, AlwaysON High Availability and SQL Server clustering in financial environments.
• Extensive experience working in a 24x7 environment.
• Database upgrades from different version of SQL Server to 2000/2005/ 2008/2012/2014/2016 .
• Customization and production implementation of high performance e-commerce platforms are a specialty.
• Leading edge corporate applications development and implementation for public companies (NYSE and OTC BB) highlight experience.

KNOWLEDGE & SKILLS SUMMARY:

Operating Systems: MS-DOS, Windows 3.xx, Windows NT 3.51 and 4.0, Windows 95, 98, 2000, XP, 2003, 2008, 2012.

System configurations: Windows NT/2000/2003, 2008, 2012 Enterprise server, clustered environment for fail-over, and load balancing, multiple SQL Server installations tied to production server farm (DELL and HP Servers).

Languages: MS Visual Basic 3.0/4.0/5.0/6.0 , VB .NET, VBA for MS Access, Excel, Office, Transact SQL, ASP, and HTML.

Databases: MS SQL SERVER 6.5/7.0/2000/2005/2008 R 2/2012/2014/2016 , MS Access 2.0/7.0/8.0/2000/2003/2007/2012 , FoxPro 2.6/5.0,Engres 1.2/2.0, Pervasive 8, Application Server DSN configuration, test, and performance tuning, ORACLE 10i/11g.

Development Tools: ActiveX Components, ActiveX Controls, ActiveX Documents, Crystal Reports 3.0 - 10.5, Windows API's16/32, MS Office 97/2000/2003/2007/2013 Dev Edition, Citrix, Logic Works Erwin 3.0/3.5, VERITAS Backup, MS Exchange 6.5, Cognos (Power Play), SalesLogix 2000/5.2/6.2 , KRONOS 4/5, IDERA SQL Diagnostic Manager and SQL compliance manager, SSIS, Tableau 5.2, Pervasive Map Designer 8.1, Red Gate Tool Belt (SQL Monitor).

PROFESSIONAL EXPERIENCE:

Sr. SQL Server DBA

Confidential

Responsibilities:

• Managed the migration of SQL Server 2005 databases to SQL Server 2008/2012/2014/2016 , including SSIS packages.
• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor, IDERA Diagnostic Manager, Red Gate tools.
• Experience in using SSIS for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Experience in Database administration activities for DB Security (creating logins, users, roles, and permission).
• Experience in Disaster Recovery Planning , Execution and Testing at remote side.
• Generated physical database schema. Maintain conceptual, logical, and physical data models.
• Database capacity planning. Performed database tuning. Perform product and system testing.
• Conducted security audits using Idera SQL compliance manager. Provided 24x7 rotation supports as needed.
• Assisted with database/application migrations, disaster recovery scenarios, and server upgrades whenever feasible.
• Implemented transactional, snapshot and merge database replications. Advanced log shipping technology.
• Managed the migration of SQL Server 2000/2005 databases to SQL Server 2008/2012/2014/2016 , including SSIS packages.
• Created Linked servers on SQL Server to be able to query data in Oracle database
• ORACLE installation, setup, configuration, database & user management. Data export/import.
• Developing process of database migration from MS Access and Oracle to MS SQL Server 2008/2014

Environment: Windows Server 2003/2008/2012 (64bit) in high availability environment, VMware 5.x, SQL Server 2000/ 2005/2008/2012 /2016 , Idera SQL Diagnostic Manager, Idera SQLCheck, Red Gate SQL Monitor, Backup, Data Compare..

Sr. SQL Server DBA

Confidential

Responsibilities:

• Performed daily tasks including backup and restore by using SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor, IDERA Diagnostic Manager, Red Gate tools.
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Created policies, procedures, maintenance plans, and system standards.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Generated physical database schema. Maintain conceptual, logical, and physical data models.
• Database capacity planning. Performed database tuning. Perform product and system testing.
• Conducted security audits using Idera SQL compliance manager. Provided 24x7 rotation supports as needed.
• Deploy and support database components in all DB environments which include DEV, TEST, and PRODUCTION.
• Develop scripts to automate routine and repetitive database administration tasks.
• Coordinating DDL changes; QA support; and the production implementation of all DB changes.
• Assisted with database/application migrations, disaster recovery scenarios, and server upgrades whenever feasible.
• Implemented transactional, snapshot and merge database replications. Advanced log shipping technology.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008/2012 , including Confidential, SSIS packages.
• ORACLE installation, setup, configuration, database & user management. Data export/import.

Environment: Windows Server 2000/2003/2008 (32bit/64bit) in high availability environment, VMware 5.x, SQL Server 2000/ 2005/2008/2012 , Idera SQL Diagnostic Manager, Idera SQLCheck, Red Gate SQL Monitor, Backup, Data Compare..

Database Manager

Confidential

Responsibilities:

• Full lifecycle development and design for Confidential Insurance and Club Budget Programs.
• GUI completed in MS Access 2000 \ 2003, Visual Basic .NET, Visual Basic 6.0.
• Back end created in MS Access 2000 \ 2003 \ 2007, and SQL Server 2000 \ 2005.
• Modified Branch Inventory Program to automate the manual process of taking inventory and compare it with POS.
• Created modules to Insurance Company Commissions program. It creates payroll feed to HR, a general ledger feed to accounting system and a number of Management reports.
• Created numerous financial reports utilizing Crystal Reports.
• Documented business and technical processes, logical designs, data flows and gap analysis to streamline business development.
• Acted as liaison between business and technical staff to resolve software issues for end users.
• Developed new business processes and reports with finance team, which reduced quarterly report generation from two-weeks to on-demand.
• Composed monthly financial reports, for use by executive management to guide, measure, and estimate commissions.
• Hands-on database management, ETL processing, data conversion and manipulation. Schedule and monitor the maintenance and backups of all databases in SQL Servers and MS Access.
• Maintain and upgrade SQL Server hardware and software.
• Perform database administration of the current systems involving report creation, troubleshooting and ETL.
• Used the SQL profiler to generate traces used to identify long running queries causing database to lock down. Cleansing and solving Database troubles.
• 24/7 of the production SQL Server database supporting
• Responsible for corporate-wide SQL Server database administration.
• Full lifecycle development design cycle for Confidential custom shipment prototype system.
• Designed complete relational database system in Access 97/2000 and data transfer to SQL Server 2000 and Oracle.
• Completed GUI in Visual Basic 6.0 and MS Access.
• Created stored procedures, triggers and views.
• Created numerous analytical reports utilizing Crystal Reports software, MS Access, SQL Server 2000 and Oracle.
• Build data distribution, transfer and update procedures using Confidential .
• Improved departmental efficiency by analyzing and identifying inefficient manual processes, procedures, and practices which were then replaced by SQL Server, MS Access tools, Excel applications.
• Create, revise, and maintain coded database objects including views, triggers and stored procedures.
• Used relational database SQL, MS Access/ Excel for reporting, quality, data collection, and data management.
• Implemented Database Mirroring and Log Shipping as part of Disaster Recovery.
• Automated several tasks by creating SQL Jobs and created Alerts when job failed, task completion.
• Used system stored procedures and DBCC commands.
• Tuned SQL queries and Stored procedures using SQL Profiler and Database Tuning Advisor.
• Rebuilding the Indexes at regular intervals for better performance.
• Involved in database and log backups & restoration, backup strategies, scheduling
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Design and document a Disaster Recovery Plan for the databases.
• Perform capacity planning for databases moved to upgrade Intel Xeon servers running windows 2003 as well as setup fresh maintenance plans.
• Configured Merge Replication to facilitate smooth running of billing engine for data cleansing.

SQL Server Database Manager

Confidential, New York, NY

Responsibilities:

• Designed, developed, implemented, and maintained complete Load Balancing and Fail over system for several applications web based as well as client/server type for major financial brokerage company. System included four servers with MS SQL Server 2000 installed. This system balanced access for over 350 users and hosted 25 databases, two of them were configured with Merge and Snapshot Replication.
• Development of the customizations for SalesLogix CRM software.
• Administration of the SalesLogix software including creation of the additional database schema to support customizations; creation and administration of the users’ security.
• Design, development, and implementation of the custom application to support Literature Fulfillment via UPS and Airborne carriers. Application has two versions: one was written in SalesLogix Architect and the other was written in MS Visual Basic.
• Design, development, and implementation of the custom application for controlling data entry for Accounts/Contacts information based on the quarterly updated US Postal Service information, and current geo-codes to allow users to map their customers thru MapQuest or other geographical software. Application has two versions: one was written in SalesLogix Architect and the other was written in MS Visual Basic.
• Created numerous (over 1000) financial reports utilizing Crystal Reports software.
• Perform data manipulations. Write scripts to fix data integrity, move data between databases, cleaning bad data.
• Daily Databases Administration tasks. Jobs, Scheduling, Backups, Recovery, Confidential .
• Created stored procedures, triggers, and views. Database modeling and data mapping.
• Perform data manipulations. Write scripts to fix data integrity, move data between databases, clean bad data.
• Provide technical support to 350 end users.
• Managed group of 3 DBA and 3 consultants.

Sr. SQL Server DBA and Integration Engineer

Confidential, Mt. Laurel, NJ

Responsibilities:

• Main responsibilities include integration maintenance and support of the existing and development applications.
• Duties include:
• Daily DBA maintenance for e-commerce web applications for inventory, auction, trade and barter systems. Production environment consists of server cluster for web applications and SQL
• Local/Remote trouble-shooting of the installation problems;
• Full development design cycle implementation, from beta testing to production environment, providing supporting documentation to development team for resolution of bugs effecting product wide application installations.
• Primary involvement in the documenting and improvements of the installation process for current software and future versions.
• Full process and procedures for implementation of web based software for laptop presentations and corporate sales.
• Daily Database Administration for over 30 databases. Jobs. Scheduling. Stored Procedures. Confidential automation.
• Advanced Crystal Reports automation for statistical analysis. Also includes IIS WebTrends reporting automation.

Network/SQL Server Database Administrator

Confidential, Princeton, NJ

Responsibilities:

• Main responsibilities include maintenance and support of the existing applications.
• Duties include:
• Implementation and configuration of the software for particular client. Client list includes: Government of Israel, Deutsche Bank, several manufacturing companies in Brazil, etc.;
• Remote trouble-shooting of the installation problems;
• Development of the Utility software for administrative tasks in MS Visual Basic 5.0/6.0;
• Extensive involvement in the documenting and improvements of the installation process for current software and future versions.
• Developing process of database migration from Ingress to MS SQL Server 6.5/7.0.
• Customer support and troubleshooting for CA clients worldwide.